Methodological Proposal for Data Warehouse Design
نویسندگان
چکیده
منابع مشابه
A Methodological Framework for Data Warehouse Design
Though designing a data warehouse requires techniques completely different from those adopted for operational systems, no significant effort has been made so far to develop a complete and consistent design methodology for data warehouses. In this paper we outline a general methodological framework for data warehouse design, based on our Dimensional Fact Model (DFM). After analyzing the existing...
متن کاملDynamic Data Warehouse Design
A data warehouse (DW) can be seen as a set of materialized views de ned over remote base relations. When a query is posed, it is evaluated locally, using the materialized views, without accessing the original information sources. The DWs are dynamic entities that evolve continuously over time. As time passes, new queries need to be answered by them. Some of these queries can be answered using e...
متن کاملData Warehouse Schema Design
A data warehouse is an integrated database primarily used in organizational decision making. Although the deployment of data warehouses is current practice in modern information technology landscapes, the methodical schema design for such databases has only been studied cursorily. In this paper we pursue schema design for data warehouses in the spirit of classical database design, organized as ...
متن کاملData Warehouse Modeler: A CASE Tool for Warehouse Design
Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...
متن کاملANTS for Data Warehouse Logical Design
The problem addressed in this research, namely the vertical fragmentation problem (VFP), arises in the context of data warehouse design, when trying to minimize the system average query response time. It is a combinatorial optimization problem of significant actual interest which has so far received little attention from the optimization community. This paper describes the application of the AN...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Sistemas y Telemática
سال: 2006
ISSN: 1692-5238
DOI: 10.18046/syt.v1i2.928