An Improved two-layer Model in the Logical Level Data Warehouse Designing
Author(s):
Article Type:
Research/Original Article (دارای رتبه معتبر)
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.
Keywords:
Language:
Persian
Published:
Journal of Modeling in Engineering, Volume:16 Issue: 54, 2018
Pages:
21 to 37
magiran.com/p2041000
دانلود و مطالعه متن این مقاله با یکی از روشهای زیر امکان پذیر است:
اشتراک شخصی
با عضویت و پرداخت آنلاین حق اشتراک یکساله به مبلغ 1,390,000ريال میتوانید 70 عنوان مطلب دانلود کنید!
اشتراک سازمانی
به کتابخانه دانشگاه یا محل کار خود پیشنهاد کنید تا اشتراک سازمانی این پایگاه را برای دسترسی نامحدود همه کاربران به متن مطالب تهیه نمایند!
توجه!
- حق عضویت دریافتی صرف حمایت از نشریات عضو و نگهداری، تکمیل و توسعه مگیران میشود.
- پرداخت حق اشتراک و دانلود مقالات اجازه بازنشر آن در سایر رسانههای چاپی و دیجیتال را به کاربر نمیدهد.
In order to view content subscription is required
Personal subscription
Subscribe magiran.com for 70 € euros via PayPal and download 70 articles during a year.
Organization subscription
Please contact us to subscribe your university or library for unlimited access!