标题：Towards Design, Analysis and Performance Enhancement of Data Warehouse By Implementation and Simulation of P2P Technology on Proposed Pseudo Mesh Architecture
期刊名称：International Journal of Innovative Research in Science, Engineering and Technology
印刷版ISSN：2347-6710
电子版ISSN：2319-8753
出版年度：2014
期号：NCETAS
页码：178
出版社：S&S Publications
摘要：The data warehouse architectural design using proposed pseudo mesh schema have been theconceptualization backbone towards design, analysis and performance enhancement of the data warehouse byimplementation 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 datawarehouse is presented through the formulation of the proposed work. Fact tables and dimension tables have been usedhere, in their normalized form, to diminish redundancy. The notion of pseudo mesh schema architecture, conforminginterlinking of all dimension tables and fact tables to one another, have been proposed at the very inception of thedevised 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 thesimulation 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 notaffect the entire schema of the data warehouse in concern. The structure uses the perception of fact views connectingwith existing dimension tables.Peer-to-Peer or P2P technology enables unswerving allotment of computer resources amid two or more computerswithin a computer network. In a P2P technology, apiece computer operate as mini server, where apiece computer couldshare its resources with other computers proficiently.The equivalent notion has been implemented in the data warehouse architectural design using proposed pseudo meshschema, 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 haveunswerving relationship amid them using view fact table(s).The improvement in efficiency by reduction of ineffectual searches and utilization of fewer resources is ensured byformulating 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 viewdefinition, thereby diminishing data redundancy, ensuring consistency and simplifying data managementresponsibilities, entailing no physical storage
关键词：Peer-to-Peer; Snow Flake Schema; Star Schema; Dimension Table; Fact Table; Super Peer; Peer;Pseudo Mesh
