ANALYSIS AND DESIGN OF CONCEPTUAL MODELS OF DATA WAREHOUSE IN ARISTY WEDDING ORGANIZER
DOI:
https://doi.org/10.56127/ijst.v2i1.554Keywords:
wedding organizer, conceptual model of data warehouseAbstract
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