Coverart for item
The Resource Building a data warehouse with examples in SQL Server, Vincent Rainardi

Building a data warehouse with examples in SQL Server, Vincent Rainardi

Label
Building a data warehouse with examples in SQL Server
Title
Building a data warehouse with examples in SQL Server
Statement of responsibility
Vincent Rainardi
Creator
Subject
Language
eng
Summary
Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later. The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation
Member of
Cataloging source
GW5XE
http://library.link/vocab/creatorName
Rainardi, Vincent
Dewey number
005.74
Illustrations
illustrations
Index
index present
LC call number
QA76.9.D37
LC item number
R35 2008eb
Literary form
non fiction
Nature of contents
dictionaries
Series statement
The expert's voice in SQL server
http://library.link/vocab/subjectName
Data warehousing
Label
Building a data warehouse with examples in SQL Server, Vincent Rainardi
Instantiates
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
To Data Warehousing -- Data Warehouse Architecture -- Data Warehouse Development Methodology -- Functional and Nonfunctional Requirements -- Data Modeling -- Physical Database Design -- Data Extraction -- Populating the Data Warehouse -- Assuring Data Quality -- Metadata -- Building Reports -- Multidimensional Database -- Using Data Warehouse for Business Intelligence -- Using Data Warehouse for Customer Relationship Management -- Other Data Warehouse Usage -- Testing Your Data Warehouse -- Data Warehouse Administration
Dimensions
unknown
Extent
1 online resource (xvi, 523 pages)
Form of item
online
Isbn
9781430205289
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Specific material designation
remote
System control number
  • SPR261325337
  • ocn261325337
Label
Building a data warehouse with examples in SQL Server, Vincent Rainardi
Publication
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
To Data Warehousing -- Data Warehouse Architecture -- Data Warehouse Development Methodology -- Functional and Nonfunctional Requirements -- Data Modeling -- Physical Database Design -- Data Extraction -- Populating the Data Warehouse -- Assuring Data Quality -- Metadata -- Building Reports -- Multidimensional Database -- Using Data Warehouse for Business Intelligence -- Using Data Warehouse for Customer Relationship Management -- Other Data Warehouse Usage -- Testing Your Data Warehouse -- Data Warehouse Administration
Dimensions
unknown
Extent
1 online resource (xvi, 523 pages)
Form of item
online
Isbn
9781430205289
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
Specific material designation
remote
System control number
  • SPR261325337
  • ocn261325337

Library Locations

Processing Feedback ...