IJSER Home >> Journal >> IJSER
International Journal of Scientific and Engineering Research
ISSN Online 2229-5518
ISSN Print: 2229-5518 8    
Website: http://www.ijser.org
scirp IJSER >> Volume 3,Issue 8,August 2012
Convert Database Structure into Star Schema Structure for Data Warehouse
Full Text(PDF, )  PP.72-75  
Author(s)
Mohammed Abdulameer Mohammed, Prof. Nanna Suryana Herman, Harith Azam Abdullah, Mustafa Musa Jaber
KEYWORDS
Database, Data warehouse, Star Schema
ABSTRACT
The database has started in the 1960s to make designing, building, and maintaining easily for information system difficulties. Since this time the database uses as storage for data and information and salves the problem about saving them safely. The dramatically increase in governments and companies transactions meet by increase in their databases, data storage and quires which used to retrieve data from database. They use information processing system which is used for storage of everyday activities about them. However, information processing systems rely on online transaction processing (OLTP) in DB, which is not so easily accessible to the governments and companies' users. Moreover, relational database was not designed to support multi dimensional view. Need for Multi dimensional view, Online Analytical Processing (OLAP) and reducing time consuming for reports generating leads to the concept of a data warehouse. This study convert database into data warehouse based on a star schema structure by using several tools and techniques as software and hardware. We investigate how star schema makes fast respond for quire and for better performance. The star schema structure data can be viewed and analyzed as multi dimensional view and can be used for Online Analytical Processing.
References
[1] V. Radiant, (2007).Decision Support System Architecture, Hardware, and Operating System Platforms. Jurnal Sistem Informasi Vol. 2 No. 1.

[2] L. Van, (2008). A Data Warehouse Model for Micro-Level Decision Making in Higher Education.” The Electronic Journal of e-Learning Volume 6 Issue 3 2008, pp. 235 – 244, available online at www.ejel.org.

[3] H. Inmon, (2002). Building the Data Warehouse, 3rd Edition. John Wiley & Sons, Inc., New York, NY, USA, 2002.

[4] S. Berger and M. Schrefl. Analysing Multi-dimensional Data Across Autonomous Data Warehouses. In Tjoa and Tho [26], pp. 120–133.

[5] J. Bernardino, P. Furtado, and H. Madeira. DWS-AQA: A Cost Effective Approach for Very Large Data Warehouses. In M. A. Nascimento, M. T. O¨ zsu, and O. R. Za¨ıane, editors, IDEAS, pp. 233–242. IEEE Computer Society, 2002.

[6] M. O. Akinde, M. H. B¨ohlen, T. Johnson, L. V. S. Lakshmanan, and D. Srivastava. Efficient OLAP Query Processing in Distributed DataWarehouses. Inf. Syst., 28(1-2): pp. 111– 135, 2003.

[7] S. Berger, and M. Schrefl, (2008). From Federated Databases to a Federated Data Warehouse System.

[8] E. Malinowaki and E., Zimanyi (2006). Hierarchies in a multidimensional model: From conceptual modeling to logical representation.

[9] S. Behrooz, (2003).Teaching Effective Methodologies to Design a Data Warehouse. Retrieved on 25 March 2010, from (http://proc.isecon.org/2001/35c/ISECON.2001.SeyedAbbassi.pdf).

Untitled Page