Building the Data Warehouse by W. H. Inmon

By W. H. Inmon

  • The re-creation of the vintage bestseller that introduced the information warehousing covers new ways and applied sciences, a lot of which were pioneered by means of Inmon himself
  • In addition to explaining the basics of knowledge warehouse platforms, the e-book covers new subject matters similar to equipment for dealing with unstructured facts in an information warehouse and storing info throughout a number of garage media
  • Discusses the professionals and cons of relational as opposed to multidimensional layout and the way to degree go back on funding in making plans facts warehouse initiatives
  • Covers complex themes, together with facts tracking and checking out
  • Although the booklet contains an additional a hundred pages worthy of priceless content material, the fee has truly been decreased from $65 to $55

Show description

Read or Download Building the Data Warehouse PDF

Best database storage & design books

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Written with readability and a down-to-earth method, Sams educate your self SQL Server 2005 show in 24 Hours covers the fundamentals of Microsoft's newest model of SQL Server. professional writer Alison Balter takes you from easy innovations to an intermediate point in 24 one-hour classes. you'll study the entire simple projects useful for the management of SQL Server 2005.

Microsoft sql server 2008 integration services problem-design-solution

This publication is a treasury for ETL builders / architects. it's very various from different ETL books within the manner that it truly is written with a top-to-bottom procedure rather than concentrating on information of an ETL instrument. every one bankruptcy offers an issue that an ETL developer/architect will face in the course of a true undertaking.

Database Programming with JDBC and Java

Java and databases make a strong blend. Getting the 2 aspects to interact, notwithstanding, takes a few effort--largely simply because Java offers in items whereas so much databases don't. This publication describes the normal Java interfaces that make transportable object-oriented entry to relational databases attainable and gives a strong version for writing functions which are effortless to take care of.

Learn SQL Server Administration in a Month of Lunches

Microsoft SQL Server is utilized by thousands of companies, ranging in measurement from Fortune 500s to small outlets world wide. even if you are simply getting all started as a DBA, assisting a SQL Server-driven program, or you have been drafted through your workplace because the SQL Server admin, you don't need a thousand-page e-book to wake up and operating.

Additional info for Building the Data Warehouse

Example text

In addition, accessing an entire tape file may take as long as 20 to 30 minutes, depending on the data on the file and the processing that is done. Around the mid-1960s, the growth of master files and magnetic tape exploded. And with that growth came huge amounts of redundant data. The proliferation of master files and redundant data presented some very insidious problems: ■■ The need to synchronize data upon update ■■ The complexity of maintaining programs ■■ The complexity of developing new programs ■■ The need for extensive amounts of hardware to support all the master files In short order, the problems of master files — problems inherent to the medium itself — became stifling.

To help them appreciate why there is such a difference from the world they have known, they should understand a little bit about the different users of the data warehouse. The data-warehouse user — also called the DSS analyst — is a businessperson first and foremost, and a technician second. The primary job of the DSS analyst is to define and discover information used in corporate decision-making. It is important to peer inside the head of the DSS analyst and view how he or she perceives the use of the data warehouse.

The last contributing factor to the lack of credibility is that often there is no common source of data to begin with. Analysis for department A originates from file XYZ. Analysis for department B originates from database ABC. There is no synchronization or sharing of data whatsoever between file XYZ and database ABC. Given these reasons, it is no small wonder that there is a crisis of credibility brewing in every organization that allows its legacy of hardware, software, and data to evolve naturally into the spider web.

Download PDF sample

Rated 4.36 of 5 – based on 24 votes