Microsoft Data Warehousing
Building Distributed Decision Support Systems
Published on 5. April 1999
Book
Paperback/Softback
XVI, 368 pages
978-0-471-32761-5 (ISBN)
Description
SQL Service is Microsoft's database management system (DBMS) and is a leading DBMS on Windows NT. As the NT market has grown, so too has the SQL Server audience. With release 7.0 of SQL Server, Microsoft has targeted the Data Warehouse market through an alliance with over 20 leading software vendors. Many new features are included in version 7.0, but the key feature is the data warehousing component. This function is designed to appeal greatly to database developers and administrators currently using SQL Server, as well as new SQL Server developers who are looking for a data warehousing tool. This book is in two parts: Part One lays the framework from which the data warehouse will be built; Part Two uses that framework to build a data warehouse for a customer management system with Microsoft's key technologies. Important topics are: data warehousing issues with Windows NT 4.0 and the upcoming 5.0; how to use all of the new components within SQL Server 7.0
- OLAP, DTS; how Microsoft's other database technologies fit in, such as OLE DB, ADO, Universal Data Access, and the Repository; and data warehousing with SQL Server technologies will be a course offered by Microsoft approved training houses.
- OLAP, DTS; how Microsoft's other database technologies fit in, such as OLE DB, ADO, Universal Data Access, and the Repository; and data warehousing with SQL Server technologies will be a course offered by Microsoft approved training houses.
More details
Persons
Content
THE 5 ENVIRONMENTS; Decision Support Architectures; The Source Environment; The Storage Environment; The Desktop Environment; The Data Warehouse Life Cycle; BUILDING A MICROSOFT-BASED DECISION SUPPORT SYSTEM; Design Process and Tools; Development; Implementation; Operations and Management; Analytical Applications; Bibliography; Index.