A Comp Arison of Data Warehouse Design Models

Only available on StudyMode
  • Download(s) : 36
  • Published : March 2, 2013
Open Document
Text Preview
A COMPARISON OF DATA WARE HOUSE DESIGN MODELS

A MASTER’S THESIS in Computer Engineer ing Atilim Univer sity

by BERIL PINAR BAŞARAN J ANUARY 2005

A COMPARISON OF DATA WARE HOUSE DESIGN MODELS

A THESIS SUBMITTED TO THE GRADUATE SCHOOL OF NATURAL AND APPLIED SCIENCES OF ATILIM UNIVERSITY BY BERIL PINAR BAŞARAN

IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF MASTER OF SCIENCE IN THE DEPARTMENT OF COMPUTER ENGINEERING

J ANUARY 2005

i

Approval of the Graduate School of Natural and Applied Sciences

_____________________ Prof. Dr. Ibrahim Akman Director I certify that this thesis satisfies all the requirements as a thesis for the degree of Master of Science. _____________________ Prof. Dr. Ibrahim Akman Head of Department This is to certify that we have read this thesis and that in our opinion it is fully adequate, in scope and quality, as a thesis for the degree of Master of Science. _____________________ Prof. Dr. Ali Yazici Co-Supervisor _____________________ Dr. Deepti Mishra Supervisor

Examining Committee Members Prof. Dr. Ali Yazici Dr. Deepti Mishra Asst. Prof. Dr. Nergiz E. Çağıltay Dr. Ali Arifoğlu Asst. Prof. Dr. Çiğdem Turhan ii _____________________ _____________________ _____________________ _____________________ _____________________

ABSTRACT

A COMPARISON OF DATA WARE HOUSE DESIGN MODELS Başaran, Beril Pınar M.S., Computer Engineering Department Supervisor: Dr. Deepti Mishra Co-Supervisor: Prof. Dr. Ali Yazici January 2005, 90 pages

There are a number of approaches in designing a data warehouse both in conceptual and logical design phases. The generally accepted conceptual design approaches are dimensional fact model, multidimensional E/R model, starER model and object-oriented multidimensional model. And in the logical design phase, flat schema, terraced schema, star schema, fact constellation schema, galaxy schema, snowflake schema, star cluster schema and starflake schemas are widely used approaches. This thesis proposes a comparison of both the conceptual and the logical design models and a sample data warehouse design and implementation is provided. It is observed that in the conceptual design phase, object-oriented model provides the best solution and for the logical design phase, star schema is generally the best in terms of performance and snowflake is generally the best in terms of redundancy. Keywords: Data Warehouse, Design Methodologies, DF, starER, ME/R, OOMD, flat schema, terraced schema, star schema, fact constellation schema, galaxy schema, snowflake schema, star cluster schema, starflake schema, DTS, Data Analyzer

iii

ÖZ

VERİ AMBARI TASARIM MODELLERİ KARŞILAŞTIRMASI Başaran, Beril Pınar Yüksek Lisans, Bilgisayar Mühendisliği Bölümü Tez Yöneticisi: Dr. Deepti Mishra Ortak Tez Yöneticisi: Prof. Dr. Ali Yazici Ocak 2005, 90 sayfa

Veri ambarı tasarımının kavramsal ve mantıksal tasarım aşamaları için birden fazla yaklaşım vardır. Kavramsal tasarım safhası için genel olarak kabul görmüş yaklaşımlar “dimensional fact”, “multidimensional E/R”, “starER” ve “object-oriented multidimensional” modelleridir. Mantıksal tasarım safhası için genel olarak kabul görmüş yaklaşımlar “flat”, “terraced”, “star”, “fact constellation”, “galaxy” , “snowflake”, “star cluster” ve “starflake” şemalarıdır. Bu tez, kavramsal ve mantıksal tasarım modellerini karşılaştırır, örnek bir veri ambarı tasarımını ve uygulamasını içerir. Bu tezde, kavramsal tasarım aşamasında “object-oriented multidimensional” modelinin; mantıksal tasarım aşamasında performans kriteri açısından “star” şemanın, veri tekrarı kriteri açısından “snowflake” şemanın en iyi çözümler olduğu gözlendi.

Anahtar Kelimeler: Veri Ambarı, Tasarım Yöntemleri, DF, starER, ME/R, OOMD, flat şema, terraced şema, star şema, fact constellation şema, galaxy şema, snowflake şema, star cluster şema, starflake şema, DTS, Data Analyzer

iv

To my dear husband Thanks for his endless support

v

ACK NO...
tracking img