Efficient Data Organisation in Distributed Computer Systems using Data Warehouse
Keywords:
Database, Distributed Databases, Relational Databases, Optimization Algorithms, Data Warehouse, Data MartsAbstract
Databases represent a highly developed form of data organisation. The efficient use of databases by their beneficiaries is a permanent and stringent concern. The first part of the article presents a short development of the way data are organised and of the ways distributed databases can be optimised in computer networks. Then, two means for the efficient operation of distributed databases are shown. The last part of the paper evaluations of the architectures of some data warehouses (DW) and of their building are made. Using the data warehouse, a beneficiary can prepare in advance the required support to get reports and then make the right decisions in specific situations.
References
M. Alsqour, K. Matouk, M.L. Owoc, A survey of data warehouse arhitectures - preliminary results, Proc.of the Federated Conference on Computer Science and Information Systems, 1121-1126, 2011.
C.J. Date, On Introduction to Database Systems, 8th Edition. Pearson Education Inc, Addison Wesley Higher Education, 2004.
F.G. Filip, Decizie asistata de calculator. Concepte, metode si tehnici pentru deciziile centrate pe analiza datelor, Rev. Informatica Economica, 4(16):8-22, 2000.
D. Fusaru, Z.Gherasim, I. Lungu, A. Bara, Tehnici si arhitecturi pentru micsorarea timpului de raspuns in sistemele cu depozite de date (Data Warehouse), Analele Universitatii Spiru Haret. Seria Economie, Ed. Fundatia Romania de maine, Bucuresti, 4(4):419-426, 2004.
M. Golfarelli, S. Rizz: A Methodological Framework for Data Warehouse Design. In: Proceedings ACM First International Workshop on Data Warehousing and OLAP (DOLAP), Washington, pp. 3-9, 1998.
M. Golfarelli, S. Rizzi, E. Turricchia, Modern Software Engineering Methodologies Meet Data Warehouse Design: 4WD. In 13th International Conference on Data Warehousing and Knowledge Discovery (DaWaK 2011), pp. 66-79, Touluse, France, 2011.
M. Golfarelli, S. Rizzi, B. Vrdoljak, Data warehouse design from XML sources, Proceedings ACM Third International Workshop on Data Warehousing and OLAP (DOLAP'01), Atlanta, pp. 40-47, 2001.
W.H. Inmon, Building the Data Warehouse, Third Edition. Pub. John Wiley&Sons, Inc. USA, 2002
C.Jennings, L. Tristan, The Perils of Over Complicating Data Warehouses How Avoiding Unnecessary Complexity Con Provide Satisfaction and Savings, Business Intelligence Journal, 16(2):39-43, 2011.
G. Moldovan, M. Valeanu, The Performance Optimization for Date Redistributing System in Computer Network, INT J COMPUT COMMUN, Vol.1, Supplementary Issue, 1(S):470- 473, 2008.
G. Moldovan, O problemă de redistribuire a serviciilor într-un sistem partiţionat în zone distincte după anumite criterii. "BabeÅŸ-Bolyai" University Cluj-Napoca, Fac. Math. and Computer Sci., Res. Sem. Preprint, no.5, 5-8, 1993.
T.T.Y. Suen, J.S.K.Wong, Efficient Task Migration Algoritm for Distributed Systems, IEEE Transactions on Parallel and Distributed Systems, 3(4):488-499, July 1992. http://dx.doi.org/10.1109/71.149966
M. Valeanu, S. Cosma, D. Cosma, G. Moldovan, D. Vasilescu, Optimization for Date Redistributed System with Applications, INT J COMPUT COMMUN, 4(2):156-161, 2009.
EG. Ularu, F. Puican, Noua generatie de baze de date NoSQL. Rev. Romana de Informatica si Automatica, Vol.22, no.4, 2012
Published
Issue
Section
License
ONLINE OPEN ACCES: Acces to full text of each article and each issue are allowed for free in respect of Attribution-NonCommercial 4.0 International (CC BY-NC 4.0.
You are free to:
-Share: copy and redistribute the material in any medium or format;
-Adapt: remix, transform, and build upon the material.
The licensor cannot revoke these freedoms as long as you follow the license terms.
DISCLAIMER: The author(s) of each article appearing in International Journal of Computers Communications & Control is/are solely responsible for the content thereof; the publication of an article shall not constitute or be deemed to constitute any representation by the Editors or Agora University Press that the data presented therein are original, correct or sufficient to support the conclusions reached or that the experiment design or methodology is adequate.
