• Corpus ID: 56207900

Conceptual Architecture of Data Warehouses - A Transformation-Oriented View

@inproceedings{Kemper2000ConceptualAO,
  title={Conceptual Architecture of Data Warehouses - A Transformation-Oriented View},
  author={H.-G. Kemper},
  year={2000}
}
A data warehouse (DWH) is an integrated collection of worthwhile data for management support. [] Key Method This machine supports sub-processes of filtering, harmonization, aggregation and enrichment and is maintained by controller and technician interfaces. Furthermore an access, load and meta data administration handles the secure and documented loading and accessing of relevant data and guarantees technical and businessoriented documentation of all transformation activities.

Figures from this paper

From data warehouses to transformation hubs - A conceptual architecture
TLDR
The relevant motives that drive the trend towards THs and the resulting requirements are delineated and the logical composition of a TH is developed based on data transformation steps.
The customer-centric data warehouse - an architectural approach to meet the challenges of customer orientation
  • H.-G. Kemper, Phil-Lip Lee
  • Computer Science
    36th Annual Hawaii International Conference on System Sciences, 2003. Proceedings of the
  • 2003
TLDR
The role of the operational data store (ODS) is worked out in the light of CRM: it presents how the ODS supports its counterpart, the data warehouse, in the dichotomic approach for the maintenance of high performance and low response times.
Impact of service-oriented architectures (SOA) on business process standardization - Proposing a research model
TLDR
The relevant motives that drive the trend towards THs and the resulting requirements are delineated and the logical composition of a TH is developed based on data transformation steps.
From Data Warehouses to analytical atoms - the Internet of Things as a centrifugal force in Business Intelligence and Analytics
TLDR
A literature review for identifying relevant application drivers, challenges and building blocks for BIA solutions suggests that particularly Internet of Things (IoT) applications drive federated analytical “ecosystem” solutions.
Business Intelligence in the Cloud?
TLDR
This contribution combines results from the outsourcing and the BI literature and derives a framework for delineating “Cloud BI” approaches, and considers six possible scenarios – some of which within immediate reach today.
Business Intelligence Outsourcing - A Framework
TLDR
A framework is derived that supports the identification and evaluation of BI outsourcing opportunities and usage and benefits of the framework are demonstrated and discussed for five different scenarios and show that the related activities have to be handled with extraordinary care.
BUSINESS INTELLIGENCE OUTSOURCING
The purposeful application of selective outsourcing has become a core building block of IT Governance approaches. It seems compelling to apply outsourcing rationales for activities related to
Management Support with Structured and Unstructured Data—An Integrated Business Intelligence Framework
TLDR
Three types of approaches for tackling the respective challenges are distinguished and the approaches are mapped to a three layer BI framework and discussed regarding challenges and business potential.
A Changeability Approach for Process Management and Decision Support on the shop Floor
TLDR
In this paper a concept is shown how the lower management can reallocate production process steps in order to avoid penalty costs if a just in time production is requested by an original equipment manufacturer.
...
...

References

SHOWING 1-10 OF 19 REFERENCES
Building the data warehouse
TLDR
This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking.
Planning and Designing the Data Warehouse
TLDR
This is a comprehensive survey of key issues associated with planning and designing enterprise data warehouses, from planning a data warehouse, to achieving management support, to implementing metadata repositories that make it easier to access real information, rather than mere data.
Data Warehouse: From Architecture to Implementation
TLDR
This book will be the key reference for any team undertaking the construction of a data warehouse, aimed primarily at the IS managers, architects, and designers involved in this process, as well as the end users having a key role in the evolving implementation of the data warehouse.
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
TLDR
Drawing upon their experiences with numerous data warehouse implementations, Ralph Kimball and his coauthors show you all the practical details involved in planning, designing, developing, deploying, and growing data warehouses.
Data warehousing - strategies, technologies, and techniques
TLDR
Enterprise computing professionals will discover how to design and build an effective data warehousing system with Rob Mattison's well-organized, step-by-step plan.
Data warehousing in the real world - a practical guide for building decision support systems
TLDR
Data Warehousing in the Real World provides comprehensive guidelines and techniques for the delivery of decision support solutions using open-systems data warehouses.
Data Warehousing: The Route to Mass Customisation
From the Publisher: In this book Sean Kelly takes a step beyond the technological architectural aspects of information technology (IT) to reveal it as a driver of corporate strategy formulation. The
Using the Data Warehouse
TLDR
The Data Warehouse and the ODS: Architecture for Information Systems and the Manager's Perspective is presented.
The Intranet Data Warehouse: Tools and Techniques for Connecting Data Warehouses to Intranets
TLDR
The first technical guide to one of today's most exciting new developments in corporate computing, The Intranet Data Warehouse is a must read for IT managers and administrators, database managers, and corporate Webmasters.
Data Warehouse Performance
TLDR
This text seeks to enable data warehouse designers to learn performance techniques for upgrading the existing data warehouse as well as design and build new ones, and covers performance issues related to data marts and operational data stores.
...
...