Microsoft Data Warehousing: Building Distributed Decision Support Systems - Softcover

Craig, R.S.; Russom, P.

Softcover

ISBN 10: 0471327611 ISBN 13: 9780471327615

Verlag: Verlag John Wiley & Sons, Inc, 1999

Inhaltsangabe

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.

Über diesen Titel

Über die Autorin bzw. den Autor

ROBERT S. CRAIG is the former Director of Data Warehousing for the Hurwitz Group. He is also the author of the monthly "Database" column for ENT magazine. Craig is currently Vice President of Marketing for WebEngine Inc., an Internet Application Server company.

Von der hinteren Coverseite

Microsoft(r) Data Warehousing, Building Distributed Decision Support Systems, Robert S. Craig Joseph A. Vivona, David Bercovitch.

Foreword by Judith Hurwitz, Robert S. Craig, Joseph A. Vivona, David Bercovitch.

Foreword by Judith Hurwitz, SQL Server 7.0′s exciting new features and components make it the data warehousing tool par excellence. In Microsoft Data Warehousing, experts Robert Craig, Joseph Vivona, and David Bercovitch show database administrators and developers how to use Microsoft′s new generation of powerful DSS technologies to create dynamic, highly scalable data marts and warehouses tailored to their companies′ current and future decision support requirements.

In the first part of the book, the authors provide a detailed description of the data warehouse process based on the five environments that make up an integrated DSS. In Part II, they acquaint you with SQL Server 7.0 components and related Microsoft tools and then show you, step–by–step, how to best utilize them to design, develop, implement, and manage a multi–tier distributed decision–support application within each environment. You get detailed hands–on guidance for:
∗ Data extraction processes and tools.
∗ How to define the most appropriate decision support architecture.
∗ Different DSS tools for the Desktop including EIS, Data Mining, Extended Reporting, and Managed Query.
∗ Configuring SQL Server 7.0 for implementation, table definition, indexing strategies, query processing, and managing and enhancing performance.
∗ The role of Microsoft Repository in design, development, and management and its support of UML.
∗ How to achieve integration across the environments with OLE DB for OLAP and its key APIs.
∗ Client access using Excel, Visual Basic, Java, English Query, and other query and analysis tools with SQL Server 7.0.
∗ How to leverage the data in the data warehouse once it′s built with various analysis scenarios such as customer relationship management, market basket, and market share.

Details zur Ausgabe

• Verlag: Verlag John Wiley & Sons, Inc
• Erscheinungsdatum: 1999
• Sprache: Englisch
• ISBN 10: 0471327611
• ISBN 13: 9780471327615
• Einband: Taschenbuch
• Anzahl der Seiten: 384
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar