The Extract-Transform-Load (ETL) system is the foundation of the data
warehouse. A properly designed ETL system extracts data from the source
systems, enforces data quality and consistency standards, conforms data
so that separate sources can be used together, and finally delivers data
in a presentation-ready format so that...
Software quality, by its very nature, is elusive. Add to that the issue of ever-changing user requirements and the vagaries of software project management and "quality" can easily become a mere word on a distant horizon. This highly acclaimed book demonstrates how the Unified Modeling Language (UML) can be used within a process...
This book constitutes the refereed proceedings of the 26th International Conference on Conceptual Modeling, ER 2007, held in Auckland, New Zealand, in November 2007.
The 37 revised full papers presented together with 3 keynote lectures were carefully reviewed and selected from 167 submissions. The papers are organized in topical sections on...
The main subject of this book is data warehousing. A data warehouse is a special kind of database that, in recent years, has attracted a great deal of interest in the information technology industry. Quite a few books have been published about data warehousing generally, but very few have focused on the design of data...
"Supply Chain Event Management (SCEM)" is one of the major topics in application-oriented Supply Chain Management. However, many solutions lack conceptual precision and currently available client-server SCEM-systems are ill-suited for complex supply networks in today's business environment. Agent-based proactive information logistics...
Web mining is moving the World Wide Web toward a more useful environment in which users can quickly and easily find the information they need. It includes the discovery and analysis of data, documents, and multimedia from the World Wide Web. Web mining uses document content, hyperlink structure, and usage statistics to assist users in meeting their...
As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the...
Pentaho Data Integration (a.k.a. Kettle) is a full-featured open source ETL (Extract, Transform, and Load) solution. Although PDI is a feature-rich tool, effectively capturing, manipulating, cleansing, transferring, and loading data can get complicated.
This book is full of practical examples that will help you to take advantage of...
Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address...
This title comprehensively documents essential concepts for SAS features, the DATA step, and SAS files so you can effectively manage your data.
SAS is a set of solutions for enterprise-wide business users as well as a powerful fourth-generation programming language for performing tasks such as these:
The official guide on how to develop interoperable data warehouse and business intelligence applications from the authors of the CWM specification
This authoritative guide will show you how to develop interoperable data warehouse and business intelligence applications using the Common Warehouse Metamodel (CWM) specification. It provides you...