The Data Warehouse ETL Toolkit_Ralph Kimball
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 application developers can build applications and end users can make decisions.
This book is organized around these four steps. The ETL system makes or breaks the data warehouse. Although building the ETL system is a back room activity that is not very visible to end users, it easily consumes 70 percent of the resources needed for implementation and maintenance of a typical data warehouse. Continue Reading »
The Data Warehouse ETL Toolkit_Ralph Kimball
Data Warehousing Fundamentals-A Comprehensive Guide For IT Pro
Are you an information technology professional watching, with great interest, the massive unfolding of the data warehouse movement? Are you contemplating a move into this new area of opportunity? Are you a systems analyst, programmer, data analyst, database administrator, project leader, or software engineer eager to grasp the fundamentals of data warehousing? Do you wonder how many different books you may have to read to learn the basics? Are you lost in the maze of the literature and products on the subject? Do you wish for a single publication on data warehousing, clearly and specifically designed for IT professionals? Do you need a textbook that helps you learn the fundamentals in sufficient depth—not more, not less? If you answered “yes” to any of the above, this book is written specially for you. Continue Reading »
Data Warehousing Fundamentals-A Comprehensive Guide For IT Pro
Building The Data Warehouse
We are told that the hieroglyphics in Egypt are primarily the work of an accountant declaring how much grain is owed the Pharaoh. Some of the streets in Rome were laid out by civil engineers more than 2,000 years ago. Examination of bones found in archeological excavations in Chile shows that medicine—in, at least, a rudimentary form—was practiced as far back as 10,000 years ago. Other professions have roots that can be traced to antiquity. From this perspective, the profession and practice of information systems and processing are certainly immature, because they have existed only since the early 1960s. Information processing shows this immaturity in many ways, such as its tendency to dwell on detail.
Building The Data Warehouse
Advanced Data Warehouse Design
management and problem solving in order to achieve their operational goals. This situation compels people in those organizations to utilize analysis tools that will better support their decisions. Decision support systems provide assistance to managers at various organizational levels for analyzing strategic information. These systems collect vast amount of data and reduce it to a form that can be used to analyze organizational behavior [53]. Since the early 1990s, data warehouses have been developed and deployed as an integral part of modern decision support systems [205, 269]. Continue Reading »
Advanced Data Warehouse Design
