Pemanfaatan Data Warehouse pada Institusi Pemerintahan
Keywords:data warehouse, dimensional model, fisheries, decision support system
Data warehouse has a very important role in assisting of decision making, where the data warehouse became the core. Data in the data warehouse provide valuable information for its users. By using data warehouse, governance institutions can conduct data analyzes in order to build new strategies to make benefits for all stakeholders. This paper discusses about the design of data warehouse in Balai Besar Riset Sosial Ekonomi dan Kelautan. Data warehouse design using dimensional model approach introduced by Kimball. The information required by management at Balai Besar Riset Sosial Ekonimi dan Kelautan are divided into three groups: income, consumption and commerce. With the data warehouse organizations can easily perform analyses and generate reports, which can be viewed from various scopes, including time, region, fishermen and fisheries.
Connolly, Thomas & Begg, Carolyn. (2010). Database Systems: A Practical Approach to Design, Implementation, and Management (fifth edition). Boston: Addison-Wesley.
Guan, J., Nunez, W., & Welsh, J.F. (2002). Institutional strategy and information support: the role of data warehousing in higher education. Campus-Wide Information Systems, 19 (5), ISSN 1065-0741.
Kimball, Ralph & Ross, Margy. (2002). The Data warehouse Toolkit (second edition). Indianapolis: Jon Wiley & Sons.
Loshin, David. (2003). Business Intelligence: the Savvy Manager’s Guide. San Francisco: Morgan Kaufmann.
Raman, V. V. R., & Tewari, Veena. (2011). Decision support system and managerial decision making. International Journal of Knowledge and Research in Management & E-Commerce 1(1).
Williams, Steve & Williams, Nancy. (2007). The Profit Impact of Business Intelligence. San Francisco: Morgan Kaufmann.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: