A Data Warehouse Architectural Design Using Proposed Pseudo Mesh Schema
Rajdeep Chowdhury, Amitava Ghosh, Mallika De · 2013
A set of dimension tables interlinked with one another, ensuring improvement in the time complexity of a data warehouse is presented through the formulation. Fact tables and dimension tables have been used here, in their normalized form, to diminish redundancy. The notion of pseudo mesh schema architecture, conforming interlinking of all dimension tables and fact tables to one another, have been proposed at the very inception of the devised work. The number of links can be precisely calculated using n (n-1)/2, wherein n embodies the number of tables present within the structure. The structure is obviously a flexible one, as any increase or decrease of one or more databases within the structure, doesn’t affect the entire schema structure of the data warehouse in concern. The structure uses the concept of fact views to connect with the existing dimension tables. Keywords— Fact Table, Dimension Table, View Table, Redundancy, Star Schema, Snowflake Schema, Pseudo Mesh Schema, Fact view.