An Improved two-layer Model in the Logical Level Data Warehouse Designing

Q: How can I download an article?

To download an article from SID, first log in to the site, search for the article title, and click on the 'Download Article' option.

Q: How can I download an ISI article?

To download an ISI article on SID, enter the keyword or article title in the search bar, view the relevant results, click on the desired article, and select the 'Download Article' option.

Q: How can I access the SID database?

To access the SID database, visit SID.ir, create an account, and log in to access scientific resources.

Q: Is downloading articles from SID free?

Some articles on SID are available for free, while others require payment. Details are specified on the article's page.

Oroumiyeh Mahya; Daneshpour Negin

مرکز اطلاعات علمی Scientific Information Database (SID) - Trusted Source for Research and Academic Resources

Journal Paper

Paper Information

Journal: Modeling in Engineering Year:2018 | Volume:16 | Issue:54 Page(s): 21-37

Download Full-Text

Persian Verion

View:

402

Download:

Cites:

Information Journal Paper

Title

An Improved two-layer Model in the Logical Level Data Warehouse Designing

Author(s)

Oroumiyeh Mahya | Daneshpour Negin | Issue Writer Certificate

Keywords

Data Warehouse In conceptual levelQ1

Data Warehouse In logical levelQ1

Snowflake SchemaQ1

Star SchemaQ1

Data warehouse DesigningQ2

Abstract

Data warehouses are centralized repositories collected from various heterogeneous sources in a wide range of time (time-variant) for decision support systems. Data warehouses are data sources used in decision making processes by online analytical processing. The process of developing a data warehouse is done through operational database analyzing, analytical requirement identification and finally designing in conceptual, logical and physical levels. In this paper, the design models at different levels of data warehouses are researched and the logical level models are compared and analyzed with respect to their properties. Finally, an improved model is proposed in logical level that combines two models (star and snowflake) in the form of a two-layered model. Queries response time measure is used to compare the proposed model with existing models. Experiments show that the proposed model improves the response time of queries. In fact, the response time of queries on the proposed model (two-layer) is improved 58. 53 percent in average versus star model, and 96. 61 percent in average versus snowflake model.

Cites

No record.

References

No record.

Cite

APA: Copy

Oroumiyeh, Mahya, & Daneshpour, Negin. (2018). An Improved two-layer Model in the Logical Level Data Warehouse Designing. JOURNAL OF MODELING IN ENGINEERING, 16(54 ), 21-37. SID. https://sid.ir/paper/359392/en

Vancouver: Copy

Oroumiyeh Mahya, Daneshpour Negin. An Improved two-layer Model in the Logical Level Data Warehouse Designing. JOURNAL OF MODELING IN ENGINEERING[Internet]. 2018;16(54 ):21-37. Available from: https://sid.ir/paper/359392/en

IEEE: Copy

Mahya Oroumiyeh, and Negin Daneshpour, “An Improved two-layer Model in the Logical Level Data Warehouse Designing,” JOURNAL OF MODELING IN ENGINEERING, vol. 16, no. 54 , pp. 21–37, 2018, [Online]. Available: https://sid.ir/paper/359392/en

Related Journal Papers