Oriental Journal of Computer Science and Technology

Open Access Open Access  Restricted Access Subscription Access

Dimensional Modeling using Star Schema for Data Creation


Affiliations
1 Sher-e-Kashmir University of Agricultural Sciences & Technology of Kashmir Srinagar, J&K, India
 

Data Warehouse design requires a to why dimensional modelling is preferred over E-R modelling when creating data warehouse. Radical rebuilding of tremendous measures of information, frequently of questionable or conflicting quality, drawn from various heterogeneous sources. Data Warehouse configuration assimilates business learning and innovation know-how. The outline of theData Warehouse requires a profound comprehension of the business forms in detail. The principle point of this exploration paper is to contemplate and investigate the transformation model to change over the E-R outlines to Star Schema for developing Data Warehouses. The Dimensional modelling is a logical design technique used for data warehouses. This research paper addresses various potential differences between the two techniques and highlights the advantages of using dimensional modelling along with disadvantages as well. Dimensional Modelling is one of the popular techniques for databases that are designed keeping in mind the queries from end-user in a data warehouse. In this paper the focus has been on Star Schema, which basically comprises of Fact table and Dimension tables. Each fact table further comprises of foreign keys of various dimensions and measures and degenerate dimensions if any. We also discuss the possibilities of deployment and acceptance of Conversion Model (CM) to provide the details of fact table and dimension tables according to the local needs. It will also highlight.

Keywords

Conversion Model (CM), E-R Modeling (ER), Dimension Modeling (DM), Fact Table, Dimensional Table, Data Warehouse (DW).
User
Notifications
Font Size

  • Singh, Y. and Kumar, P., "A software reliability growth model for three-tier client-server system", International Journal of Computer Applications, Vol. 1, No. 13, pp. 9-16, 2010, doi:10.5120/289-451

  • Singh, Y. and Kumar, P., "Determination of software release instant of three-tier client server software system", International Journal of Software Engineering, Vol. 1, No. 3, pp. 51-62, 2010.

  • Singh, Y. and Kumar, P., "Application of feed-forward networks for software reliability prediction", ACM SIGSOFT Software Engineering Notes, Vol. 35, No. 5, September 2010, pp. 1-6. doi:10.1145/1838687.1838709

  • Singh, Y. and Kumar, P., "Prediction of Software Reliability using Feed Forward Neural Networks", Proceedings of Computational Intelligence and Software Engineering (CiSE), 2010 International Conference, 2010, Wuhan, China, doi:10.1109/CISE.2010.5677251

  • Kirmani, M., & Wahid, A., "Revised Use Case Point (Re-UCP) Model for Software Effort Estimation", International Journal of Advanced Computer Science and Applications IJACSA, Vol. 6, No. 3, 65-71. doi:10.14569/issn.2156-5570.

  • Kirmani, M., & Wahid, A., "Use Case Point and e-Use Case Point method of software effort estimation: A critical performance comparison", IJCA, Vol. 5, No. 3, 2015, pp. 55-64.

  • Kirmani, M., Wahid, A., & Saif, S., "Web Engineering: An Engineering Approach for Developing Web Applications", International Journal of Software and Web Sciences, Vol. 1, No. 12, 2015, pp. 83-91.

  • Kirmani, M., Mohsin, S., & Wahid, A., "Re-UCP Software Effort Estimation Method: A Critical Study" International Journal of Computer Applications IJCA, Vol. 127, No. 11, 2015, pp. 8-12, doi:10.5120/ijca2015906534.

  • R. Kimball & M Ross, "The Data Warehouse Toolkit", 2e, John Wiley, 2002.

  • J.M. Firestone, "Dimensional modeling and ER modeling in the Data Warehouse", http://www.dkms.com/DMERDW.html

  • N Raden, "Modeling the Data Warehouse", http://members.aol.com/nraden

  • R. Kimball, "A dimensional Modeling Manifesto", http://www.dbmsmag.com/9708d15.html

  • Ralph Kimball, The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses, , John Wiley, 1996.

  • Eric Thomsen, OLAP Solutions: Building Multidimensional Information Systems, John Wiley, 1997.

  • Vidette Poe, Building a Data Warehouse for Decision Support, Prentice Hall, 1995.

  • Kenan Technologies: An Introduction to Multidimensional Database Technology, White Paper, Kenan Technologies, 1995.

  • Ralph Kimbel, “A dimensional modelling manifesto-Drawing the line between dimensional modelling and ER modelling technique" .

  • Ballard, C. et. al. "Dimensional Modelling in business environment", IBM red books, March 2006.

  • Boehnlein, M and Ende, A. U., “Deriving initial data warehousing structures from the conceptual data models of the underlying operational information system”, Proceedings of the 2nd ACM International workshop on Data Warehousing and OLAP, DOLAP 99, pp. 15-21, doi:10.1145/319757.319780

  • Srivastava, J., and Chen, P. Y., “Warehouse creation-A potential roadblock to data warehousing”, Vol. 11, No. 1, IEEE transaction on knowledge and data engineering.


Abstract Views: 291

PDF Views: 0




  • Dimensional Modeling using Star Schema for Data Creation

Abstract Views: 291  |  PDF Views: 0

Authors

Mudasir M. Kirmani
Sher-e-Kashmir University of Agricultural Sciences & Technology of Kashmir Srinagar, J&K, India

Abstract


Data Warehouse design requires a to why dimensional modelling is preferred over E-R modelling when creating data warehouse. Radical rebuilding of tremendous measures of information, frequently of questionable or conflicting quality, drawn from various heterogeneous sources. Data Warehouse configuration assimilates business learning and innovation know-how. The outline of theData Warehouse requires a profound comprehension of the business forms in detail. The principle point of this exploration paper is to contemplate and investigate the transformation model to change over the E-R outlines to Star Schema for developing Data Warehouses. The Dimensional modelling is a logical design technique used for data warehouses. This research paper addresses various potential differences between the two techniques and highlights the advantages of using dimensional modelling along with disadvantages as well. Dimensional Modelling is one of the popular techniques for databases that are designed keeping in mind the queries from end-user in a data warehouse. In this paper the focus has been on Star Schema, which basically comprises of Fact table and Dimension tables. Each fact table further comprises of foreign keys of various dimensions and measures and degenerate dimensions if any. We also discuss the possibilities of deployment and acceptance of Conversion Model (CM) to provide the details of fact table and dimension tables according to the local needs. It will also highlight.

Keywords


Conversion Model (CM), E-R Modeling (ER), Dimension Modeling (DM), Fact Table, Dimensional Table, Data Warehouse (DW).

References





DOI: https://doi.org/10.13005/ojcst%2F10.04.07