Efficient Data Organisation in Distributed Computer Systems using Data Warehouse

  • Smaranda Cosma Faculty of Business, Babeş-Bolyai University
  • Mădălina Văleanu Faculty of Medicine, "Iuliu Haţieganu" University of Medicine and Pharmacy
  • Dan Cosma Faculty of Medicine, "Iuliu Haţieganu" University of Medicine and Pharmacy
  • Dana Vasilescu Faculty of Medicine, "Iuliu Haţieganu" University of Medicine and Pharmacy,
  • Grigor Moldovan Faculty of Mathematics and Computer Science, Babeş-Bolyai University, Cluj-Napoca, Romania

Abstract

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.

Author Biography

Smaranda Cosma, Faculty of Business, Babeş-Bolyai University
Faculty of Business, Babeş-Bolyai University

References

[1] 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.

[2] C.J. Date, On Introduction to Database Systems, 8th Edition. Pearson Education Inc, Addison Wesley Higher Education, 2004.

[3] 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.

[4] 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.

[5] 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.

[6] 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.

[7] 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.

[8] W.H. Inmon, Building the Data Warehouse, Third Edition. Pub. John Wiley&Sons, Inc. USA, 2002

[9] 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.

[10] 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.

[11] 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.

[12] 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

[13] 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.

[14] EG. Ularu, F. Puican, Noua generatie de baze de date NoSQL. Rev. Romana de Informatica si Automatica, Vol.22, no.4, 2012
Published
2013-06-02
How to Cite
COSMA, Smaranda et al. Efficient Data Organisation in Distributed Computer Systems using Data Warehouse. INTERNATIONAL JOURNAL OF COMPUTERS COMMUNICATIONS & CONTROL, [S.l.], v. 8, n. 3, p. 366-374, june 2013. ISSN 1841-9844. Available at: <http://univagora.ro/jour/index.php/ijccc/article/view/463>. Date accessed: 04 july 2020. doi: https://doi.org/10.15837/ijccc.2013.3.463.

Keywords

Database, Distributed Databases, Relational Databases, Optimization Algorithms, Data Warehouse, Data Marts