An Improved two-layer Model in the Logical Level Data Warehouse Designing
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 warehous...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | fas |
| Published: |
Semnan University
2018-09-01
|
| Series: | مجله مدل سازی در مهندسی |
| Subjects: | |
| Online Access: | https://modelling.semnan.ac.ir/article_3381_a37b5de991023f8f5cba87da19a88898.pdf |
| _version_ | 1797296576514752512 |
|---|---|
| author | Mahya Oroumiyeh Negin Daneshpour |
| author_facet | Mahya Oroumiyeh Negin Daneshpour |
| author_sort | Mahya Oroumiyeh |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-03-07T22:06:46Z |
| format | Article |
| id | doaj.art-fdfed799a6bf4599a35075393356e98a |
| institution | Directory Open Access Journal |
| issn | 2008-4854 2783-2538 |
| language | fas |
| last_indexed | 2024-03-07T22:06:46Z |
| publishDate | 2018-09-01 |
| publisher | Semnan University |
| record_format | Article |
| series | مجله مدل سازی در مهندسی |
| spelling | doaj.art-fdfed799a6bf4599a35075393356e98a2024-02-23T19:05:32ZfasSemnan Universityمجله مدل سازی در مهندسی2008-48542783-25382018-09-011654213710.22075/jme.2017.5631.3381An Improved two-layer Model in the Logical Level Data Warehouse DesigningMahya Oroumiyeh0Negin Daneshpour1دانشگاه آزاد اسلامی- واحد قزوینAssistant Professor Shahid Rajaee Teacher Training UniversityData 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.https://modelling.semnan.ac.ir/article_3381_a37b5de991023f8f5cba87da19a88898.pdfdata warehouse in conceptual leveldata warehouse in logical levelsnowflake schemastar schemadata warehouse designing |
| spellingShingle | Mahya Oroumiyeh Negin Daneshpour An Improved two-layer Model in the Logical Level Data Warehouse Designing مجله مدل سازی در مهندسی data warehouse in conceptual level data warehouse in logical level snowflake schema star schema data warehouse designing |
| title | An Improved two-layer Model in the Logical Level Data Warehouse Designing |
| title_full | An Improved two-layer Model in the Logical Level Data Warehouse Designing |
| title_fullStr | An Improved two-layer Model in the Logical Level Data Warehouse Designing |
| title_full_unstemmed | An Improved two-layer Model in the Logical Level Data Warehouse Designing |
| title_short | An Improved two-layer Model in the Logical Level Data Warehouse Designing |
| title_sort | improved two layer model in the logical level data warehouse designing |
| topic | data warehouse in conceptual level data warehouse in logical level snowflake schema star schema data warehouse designing |
| url | https://modelling.semnan.ac.ir/article_3381_a37b5de991023f8f5cba87da19a88898.pdf |
| work_keys_str_mv | AT mahyaoroumiyeh animprovedtwolayermodelinthelogicalleveldatawarehousedesigning AT negindaneshpour animprovedtwolayermodelinthelogicalleveldatawarehousedesigning AT mahyaoroumiyeh improvedtwolayermodelinthelogicalleveldatawarehousedesigning AT negindaneshpour improvedtwolayermodelinthelogicalleveldatawarehousedesigning |