Towards Design, Analysis and Performance Enhancement of Data Warehouse By Implementation and Simulation of P2P Technology on Proposed Pseudo Mesh Architecture

摘要

The data warehouse architectural design using proposed pseudo mesh schema have been the conceptualization backbone towards design, analysis and performance enhancement of the data warehouse by implementation and simulation of P2P technology on proposed pseudo mesh architecture. A set of dimension tables interlinked with one another, ensuring enhancement in the time complexity of the data warehouse is presented through the formulation of the proposed work. 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 between various peers in the system could be precisely calculated using n(n-1)/2, wherein n exemplifies the number of peers in attendance within the structure. To comprehensively emphasize the simulation methodology adhered, diverse networks are associated to each other using routers. The structure is evidently flexible, as any increase or decrease of one or more databases within the structure, does not affect the entire schema of the data warehouse in concern. The structure uses the perception of fact views connecting with existing dimension tables. Peer-to-Peer or P2P technology enables unswerving allotment of computer resources amid two or more computers within a computer network. In a P2P technology, apiece computer operate as mini server, where apiece computer could share its resources with other computers proficiently. The equivalent notion has been implemented in the data warehouse architectural design using proposed pseudo mesh schema, where apiece dimension table in the architecture act as super peer and in consequence form a peer community, with collection of peers. Apiece peer within similar peer community or from unlike peer community could have unswerving relationship amid them using view fact table(s). The improvement in efficiency by reduction of ineffectual searches and utilization of fewer resources is ensured by formulating unswerving exchange of records amid peers using view fact table(s). By using views, the data is desired to be stored only once and then needs to be converted into the logical view definition, thereby diminishing data redundancy, ensuring consistency and simplifying data management responsibilities, entailing no physical storage.