Download e-book for kindle: Data Warehousing Fundamentals by P., (Author) Ponniah

By P., (Author) Ponniah

ISBN-10: 0471221627

ISBN-13: 9780471221623

Precis, and evaluate workouts on the end of every bankruptcy, Ponniah's paintings will entice IT pros who already layout, enforce, or continue information warehousing structures in addition to beginners to the topic. the fundamental parts of knowledge warehousing are defined prior to Ponniah turns to themes of undertaking administration, defining company standards, the structure and infrastructure, the function of metadata, implementation, progress, and upkeep. Ponniah first constructed this direction at a group university in North department, New Jersey.

Show description

Read or Download Data Warehousing Fundamentals PDF

Best organization and data processing books

Implementing and Integrating Product Data Management and - download pdf or read online

Simply because today’s items depend upon tightly built-in and software program elements, approach and software program engineers, and venture and product managers have to have an realizing of either product info administration (PDM) and software program configuration administration (SCM). This groundbreaking ebook will give you that crucial wisdom, mentioning the similarities and adjustments of those approaches, and exhibiting you the way they are often mixed to make sure potent and effective product and method improvement, creation and upkeep.

New PDF release: Creating a Trading Floor: The Project Manager's Guide to the

The undertaking manager's Bible to the layout and implementation of ground-breaking buying and selling flooring to stick aggressive, buying and selling flooring require state-of-the-art know-how, a posh community that contains every little thing from cell traces to info servers. This sensible guide deals huge, up to date recommendation for all these desirous about the making plans, layout and building of buying and selling flooring and knowledge facilities in any of the world's significant monetary facilities, from manhattan to Hong Kong.

Download e-book for iPad: Projects in Computing and Information Systems: A Student's by Christian Dawson

Venture a tutorial venture is a key function of such a lot of modern day computing and data structures measure programmes. easily placed, this ebook offers the reader with every thing they'll have to effectively entire their computing venture. the writer tackles the 4 key components of undertaking paintings (planning, engaging in, proposing, and taking the venture extra) in chronological order giving the reader the fundamental abilities they'll desire at each one level of the project's improvement: *Writing Proposals *Surveying Literature *Project administration *Time administration *Managing probability *Team operating *Software improvement *Documenting software program *Report Writing *Effective Presentation

Extra info for Data Warehousing Fundamentals

Example text

The account number in the Savings Account application could be eight bytes long, but only six bytes in the Checking Account application. Before the data from various disparate sources can be usefully stored in a data warehouse, you have to remove the inconsistencies. You have to standardize the various data elements and make sure of the meanings of data names in each source application. Before moving the data into the data warehouse, you have to go through a process of transformation, consolidation, and integration of the source data.

For a manufacturing company, sales, shipments, and inventory are critical business subjects. For a retail store, sales at the check-out counter is a critical subject. Figure 2-1 distinguishes between how data is stored in operational systems and in the data warehouse. In the operational systems shown, data for each application is organized separately by application: order processing, consumer loans, customer billing, accounts receivable, claims processing, and savings accounts. For example, Claims is a critical business subject for an insurance company.

The file layouts, character code representations, and field naming conventions all could be different. In addition to data from internal operational systems, for many enterprises, data from outside sources is likely to be very important. Companies such as Metro Mail, A. C. Nielsen, and IRI specialize in providing vital data on a regular basis. Your data warehouse may need data from such sources. This is one more variation in the mix of source data for a data warehouse. Figure 2-2 illustrates a simple process of data integration for a banking institution.

Download PDF sample

Data Warehousing Fundamentals by P., (Author) Ponniah


by Jason
4.2

Rated 4.36 of 5 – based on 32 votes

About admin