Skip to Main Content
 

Global Search Box

 
 
 
 

Files

File List


ucin1242762457.pdf (7.03 MB)

ETD Abstract Container

Abstract Header

Automating Multiple Schema Generation using Dimensional Design Patterns

Deshpande, Monali A.
http://rave.ohiolink.edu/etdc/view?acc_num=ucin1242762457

Abstract Details

2009, MS, University of Cincinnati, Engineering : Computer Science.
A data warehouse is a repository where data is collected from various sources, integrated, and represented in a dimensional model. The structure and description of the data stored in the repository is called the schema. The two basic approaches for designing a data warehouse schema are data-driven and requirement-driven. Data-driven approaches use operational sources as the guide to creating schemas, while requirement-driven approaches are guided by end-user query and analysis needs. Most approaches in the literature are data-driven; however, some researchers have initiated research into requirement-driven methodologies. Jones and Song [JS05, JS07] propose a requirement-driven approach inspired by design patterns from software engineering. They define dimensional design patterns (DDPs) that capture features common to many dimensional schemas. The use of DDPs assists a designer in creating a dimensional schema. We automate the process of creating one or more star schemas using DDPs and perform case studies to illustrate use of the software tool in different domains. In addition, we automate a process to examine the generated schemas to identify shared dimensions, called conformed dimensions that can be further used by the designer to refine and merge the schemas.
Karen C. Davis, Dr. (Committee Chair)
Raj Bhatnagar, Dr. (Committee Member)
Chia-Yung Han, Dr. (Committee Member)
100 p.
Computer Science
data warehouse schema; star schema; dimensional design patterns

Recommended Citations

Citations

  • Deshpande, M. A. (2009). Automating Multiple Schema Generation using Dimensional Design Patterns [Master's thesis, University of Cincinnati]. OhioLINK Electronic Theses and Dissertations Center. http://rave.ohiolink.edu/etdc/view?acc_num=ucin1242762457

    APA Style (7th edition)

  • Deshpande, Monali. Automating Multiple Schema Generation using Dimensional Design Patterns. 2009. University of Cincinnati, Master's thesis. OhioLINK Electronic Theses and Dissertations Center, http://rave.ohiolink.edu/etdc/view?acc_num=ucin1242762457.

    MLA Style (8th edition)

  • Deshpande, Monali. "Automating Multiple Schema Generation using Dimensional Design Patterns." Master's thesis, University of Cincinnati, 2009. http://rave.ohiolink.edu/etdc/view?acc_num=ucin1242762457

    Chicago Manual of Style (17th edition)

ucin1242762457
644
© 2009, all rights reserved.
This open access ETD is published by University of Cincinnati and OhioLINK.