alexa Towards Design, Analysis and Performance Enhancement o
ISSN ONLINE(2319-8753)PRINT(2347-6710)

International Journal of Innovative Research in Science, Engineering and Technology
Open Access

Like us on: https://twitter.com/ijirset_r
OMICS International organises 3000+ Global Conferenceseries Events every year across USA, Europe & Asia with support from 1000 more scientific Societies and Publishes 700+ Open Access Journals which contains over 50000 eminent personalities, reputed scientists as editorial board members.

Open Access Journals gaining more Readers and Citations

700 Journals and 15,000,000 Readers Each Journal is getting 25,000+ Readers

This Readership is 10 times more when compared to other Subscription Journals (Source: Google Analytics)

Special Issue Article

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

 
To read the full article Peer-reviewed Article PDF image

Abstract

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

Keywords

Share This Page

Additional Info

Loading
Loading Please wait..
Peer Reviewed Journals
 
Make the best use of Scientific Research and information from our 700 + peer reviewed, Open Access Journals
International Conferences 2017-18
 
Meet Inspiring Speakers and Experts at our 3000+ Global Annual Meetings

Contact Us

 
© 2008-2017 OMICS International - Open Access Publisher. Best viewed in Mozilla Firefox | Google Chrome | Above IE 7.0 version
adwords