Efficient Data Organisation in Distributed Computer Systems using Data Warehouse

Smaranda Cosma, Mădălina Văleanu, Dan Cosma, Dana Vasilescu, Grigor Moldovan

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.


Keywords


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

Full Text:

PDF

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




DOI: https://doi.org/10.15837/ijccc.2013.3.463



Copyright (c) 2017 Smaranda Cosma, Mădălina Văleanu, Dan Cosma, Dana Vasilescu, Grigor Moldovan

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

CC-BY-NC  License for Website User

Articles published in IJCCC user license are protected by copyright.

Users can access, download, copy, translate the IJCCC articles for non-commercial purposes provided that users, but cannot redistribute, display or adapt:

  • Cite the article using an appropriate bibliographic citation: author(s), article title, journal, volume, issue, page numbers, year of publication, DOI, and the link to the definitive published version on IJCCC website;
  • Maintain the integrity of the IJCCC article;
  • Retain the copyright notices and links to these terms and conditions so it is clear to other users what can and what cannot be done with the  article;
  • Ensure that, for any content in the IJCCC article that is identified as belonging to a third party, any re-use complies with the copyright policies of that third party;
  • Any translations must prominently display the statement: "This is an unofficial translation of an article that appeared in IJCCC. Agora University  has not endorsed this translation."

This is a non commercial license where the use of published articles for commercial purposes is forbiden. 

Commercial purposes include: 

  • Copying or downloading IJCCC articles, or linking to such postings, for further redistribution, sale or licensing, for a fee;
  • Copying, downloading or posting by a site or service that incorporates advertising with such content;
  • The inclusion or incorporation of article content in other works or services (other than normal quotations with an appropriate citation) that is then available for sale or licensing, for a fee;
  • Use of IJCCC articles or article content (other than normal quotations with appropriate citation) by for-profit organizations for promotional purposes, whether for a fee or otherwise;
  • Use for the purposes of monetary reward by means of sale, resale, license, loan, transfer or other form of commercial exploitation;

    The licensor cannot revoke these freedoms as long as you follow the license terms.

[End of CC-BY-NC  License for Website User]


INTERNATIONAL JOURNAL OF COMPUTERS COMMUNICATIONS & CONTROL (IJCCC), With Emphasis on the Integration of Three Technologies (C & C & C),  ISSN 1841-9836.

IJCCC was founded in 2006,  at Agora University, by  Ioan DZITAC (Editor-in-Chief),  Florin Gheorghe FILIP (Editor-in-Chief), and  Misu-Jan MANOLESCU (Managing Editor).

Ethics: This journal is a member of, and subscribes to the principles of, the Committee on Publication Ethics (COPE).

Ioan  DZITAC (Editor-in-Chief) at COPE European Seminar, Bruxelles, 2015:

IJCCC is covered/indexed/abstracted in Science Citation Index Expanded (since vol.1(S),  2006); JCR2018: IF=1.585..

IJCCC is indexed in Scopus from 2008 (CiteScore2018 = 1.56):

Nomination by Elsevier for Journal Excellence Award Romania 2015 (SNIP2014 = 1.029): Elsevier/ Scopus

IJCCC was nominated by Elsevier for Journal Excellence Award - "Scopus Awards Romania 2015" (SNIP2014 = 1.029).

IJCCC is in Top 3 of 157 Romanian journals indexed by Scopus (in all fields) and No.1 in Computer Science field by Elsevier/ Scopus.

 

 Impact Factor in JCR2018 (Clarivate Analytics/SCI Expanded/ISI Web of Science): IF=1.585 (Q3). Scopus: CiteScore2018=1.56 (Q2);

SCImago Journal & Country Rank

Editors-in-Chief: Ioan DZITAC & Florin Gheorghe FILIP.