Pembentukan Data Mart Menggunakan Metode Generalization

  • I Gede Sugita Aryandana Jurusan Teknologi Informasi, Fakultas Teknik, Universitas Udayana
  • I Made Sukarsa Jurusan Teknologi Informasi, Fakultas Teknik, Universitas Udayana
  • Putu Wira Buana Jurusan Teknologi Informasi, Fakultas Teknik, Universitas Udayana

Abstract

Technology today causing the data needs of an agency or company to process the data or analyze data quickly, dense and higher. Companies or institutions want the data analysis process can save time as much as possible. The data warehouse is a data analysis technology that is useful to resolve the issue. The data warehouse is a repository of data that is useful to accommodate all the history data held by agencies or companies. Data marts are small part of the data warehouse. Data mart is focused on a single subject. This study uses a generalization method to perform the process of establishing a data mart. Generalization is a useful method to reduce or narrow the differences in the data based Subclass. Subclass were integrated into a Superclass useful to collect some data from the Subclass. Subclass is the data that is more descriptive. Superclass is more general in nature of data. The result obtained is a collection of some Subclass predetermined or selected later formed a Superclass useful to accommodate the resources of the Subclass.

Downloads

Download data is not yet available.

References

[1] P. Lane, “Oracle9i Data Warehousing Guide.” Oracle Corporation, 2002.
[2] A. Parekh, “Introduction on Data Warehouse with OLTP and OLAP,” International Journal Of Engineering And Computer Science, vol. 2, no. 8, pp. 2569–2573, 2013.
[3] S. Bagui, “Mapping Generalizations and Specializations and Categories to Relational Databases,” Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, pp. 2009–2011, 2009.
[4] H. B. Zghal, S. Faïz, and H. Ben Ghézala, “CASME : A CASE Tool for Spatial Data Marts Design and Generation,” International Journal of Cooperative Information Systems., pp. 1–11, 2003.
[5] Y. Pitarch, C. Favre, A. Laurent, and P. Poncelet, “Context-aware generalization for cube measures,” Proceedings of the ACM 13th international workshop on Data warehousing and OLAP (DOLAP '10), p. 99, 2010.
[6] R. Liu, K. Koedinger, and E. a Mclaughlin, “Interpreting Model Discovery and Testing Generalization to a New Dataset,” Proceedings of the Seventh International Conference on Educational Data Mining, pp. 107–113, 2014.
[7] M. Golfarelli and S. Rizzi, Data warehouse design: Modern principles and methodologies. McGraw-Hill, Inc., 2009.
[8] A. Bonifati, F. Cattaneo, S. Ceri, A. Fuggetta, and S. Paraboschi, “Designing data marts for data warehouses,” ACM Transactions on Software Engineering and Methodology (TOSEM), vol. 10, no. 4, pp. 452–483, 2001.
[9] J. Eder and S. Kanzian, “Logical Design of Generalizations in Object-Relational Databases,” in East European Conference - Advances in Databases and Information Systems, 2004, vol. 8th.
Published
2016-12-02
How to Cite
SUGITA ARYANDANA, I Gede; SUKARSA, I Made; BUANA, Putu Wira. Pembentukan Data Mart Menggunakan Metode Generalization. Lontar Komputer : Jurnal Ilmiah Teknologi Informasi, [S.l.], p. 138-149, dec. 2016. ISSN 2541-5832. Available at: <https://ojs.unud.ac.id/index.php/lontar/article/view/25456>. Date accessed: 21 nov. 2024. doi: https://doi.org/10.24843/LKJITI.2016.v07.i03.p02.
Section
Articles

Keywords

Data Warehouse; Data Mart Generalization.