ANALYSIS AND DESIGN OF CONCEPTUAL MODELS OF DATA WAREHOUSE IN ARISTY WEDDING ORGANIZER

Authors

  • Isni Oktria Universitas Gunadarma
  • Dyah Cita Irawati Universitas Gunadarma

DOI:

https://doi.org/10.56127/ijst.v2i1.554

Keywords:

wedding organizer, conceptual model of data warehouse

Abstract

Wedding Organizer is a business that specializes in services that specifically help the bride and groom and families in the planning and supervision of the implementation of a series of events into a wedding party. The necessity of designing a conceptual model of data warehouse on a wedding organizer devoted to designing the model and the data flow that existed at the wedding organizer. The data warehouse is a collection of data from various sources placed together in a safae place for querying and reporting processes. The conceptual model of the data warehouse is a logic design that represents the data. Data warehouse design method used in the study is the dimensional data modeling Powell. The study resulted in the design of data into multiple tables then the tables is determined which inculeds the dimension tables and fact. The identification process is intended to design a star schema, snowflake schemas, and the fact constellation schema of existing data on the wedding organizer CV . Aristy so that in the future can be created a wedding organizer information system for CV. Aristy

References

Hidayat, K. M. W., Wariswam, S., Mardiani., 2013. Perancangan Data Warehouse Obat-Obatan Pada RS. ABC Palembang, STMIK GI MDP, Palembang.

Sandhu, M. K., Kaur, A., Kaur R., 2015. Data Warehouses Schemas. IJIRAE Issue 4 Volume 2, ISSN: 2349-2163.

Saxeena, G., Agarwal B. B., 2014. Data Warehouse Designing: Dimensional Modelling and E-R Modelling, International Journal of Engineering Inventions Volume 3 Issue 9 PP: 28-34, e-ISSN: 2278-7461, p-ISSN: 2319-6491.

Engel, J. F., Blackwell, R. D., Miniard, P. W., 1994. Perilaku Konsumen Edisi Keenam Jilid 1, Binarupa Aksara, Jakarta.

Loudon, L. D., Bitta, A. J. D., 1984. Consumer Behaviour: Concepts and Applications 2nd Edition, Mc-Graw-Hill, Madison.

Kotler, G., Armstrong, P., 2003. Marketing Management, Prentice Hall, New Jersey.

Lamb., Hair., McDaniel., 2001. Pemasaran Edisi Pertama, Salemba Empat, Jakarta.

Schiffman, L. G., Kanuk L. L., 2004. Perilaku Konsumen Edisi 7, Prentice Hall, Jakarta.

Dharmmesta, B. Swastha., Handoko, T. Hani., 2000. Manajemen Pemasaran: Analisa Perilaku Konsumen, BPFE-Yogyakarta, Yogyakarta.

Ebert, R., Griffin., 1995. Consumer Behaviour. Intenational Edition.

Sutabri, T., 2005. Sistem Informasi Manajemen, Andi Offset, Jakarta.

Mcleod, Jr, R., 2001. Sistem Informasi Edisi 7 Jilid 2, PT. Prenhallindo, Jakarta.

Arbie, E., 2000. Pengantar Sistem Informasi Manajemen, Bina Alumni Indonesia Edisi Ke-7 Jilid 1, Jakarta.

Muhyuzir T.D., 2001. Analisa Perancangan Sistem Pengolahan Data, PT. Elex Media Komputindo Cetakan Kedua, Jakarta.

O’Brein., James, A., 2005. Pengantar Sistem Informasi, Salemba Empat, Jakarta.

Jogiyanto, H. M., 2005. Sistem Teknologi Informasi, Andi Offset, Yogyakarta.

Sidharta, L., 1995. Pengantar Sistem Informasi Bisnis, PT. ELEX Media Komputindo, Jakarta.

Jogiyanto, H. M., 1999. Analisis dan Disain Informasi: Pendekatan Terstruktur Teori dan Praktek Aplikasi Bisnis, Andi Offset, Yogyakarta.

Gordon, B. D., 1991. Kerangka Dasar Sistem Informasi Manajemen Bagian 1, PT Pustaka Binamas Pressindo, Jakarta.

Hoffer, J. A., Prescott, M. B., Topi, H., 2009. Modern Database Management 9th Editions. Prentice Hall, New Jersey.

Laudon, K. C., Laudon, J. P., 2010. Management Information Systems 11th Edition, Pearson Prentice Hall, New Jersey.

Connolly., T. M & Begg, C. E., Carolyn., 2010. Database Systems A practical Approach to Design, Implementation, and Management Fifth Edition, Pearson Education, Boston.

Mcleod, Jr, R., Schell, P. G., 2007. Management Information Systems, Pearson Education, New Jersey.

Sawyer, S.C., Wiliams, B. K., 2007. Using Information Technology, Pengenalan Praktis Dunia Komputer dan Komunikasi, (Edisi 7). Diterjemahkan oleh Nur Wijayaning Rahayu & th . Arie Prabawati.

O’ Brien, J. A., Marakas, G. M., 2009. Management System Informations 9th Edition, McGraw Hill, New Jersey.

Singh, A., D. C Uphadaya, D., Yadav, H., 2011. Data Warehouse Processes: An Multidimensional Meta Modelling Framework, IFRSA International Journal of Data Warehousing & Mining Vol. 1 Issue 1.

Matamala, C. Z., Contreras, M. V., Sepulveda, A. U., 2012. A model driven approach for fuzzy data warehouse design, Ingeniare: Revista Chilena de Ingenieria, 20 (1), 99-113.

Poolet, M. A, 2009. 7 Steps for Successful Data Warehouse Projects, SQL Server Magazine, 11 (4), 29-33.

Inmon, W. H. (2005). Building The Data Warehouse 4th Edition, Wiley Publishing Inc, Indianapolis.

Han, J., Kamber, M., Pei, J., 2011. Data Mining Concepts and Techniques 3rd Edition, Elsevier Inc, USA

Downloads

Published

2023-03-09

How to Cite

Oktria, I., & Irawati, D. C. (2023). ANALYSIS AND DESIGN OF CONCEPTUAL MODELS OF DATA WAREHOUSE IN ARISTY WEDDING ORGANIZER. International Journal Science and Technology, 2(1), 8–14. https://doi.org/10.56127/ijst.v2i1.554

Similar Articles

1 2 3 4 > >> 

You may also start an advanced similarity search for this article.

Most read articles by the same author(s)

Obs.: This plugin requires at least one statistics/report plugin to be enabled. If your statistics plugins provide more than one metric then please also select a main metric on the admin's site settings page and/or on the journal manager's settings pages.