|
 |
|
 |
 |
Microsoft(r) Data Warehousing: Building Distributed Decision Support Systems
|
by Robert S. Craig, Joseph A. Vivona, David Berkovitch, and David Bercovich
Sales Rank: 2766054
|
$0.44
At Amazon
|
|
Paperback: 384 pages
Publisher: John Wiley & Sons; 1 edition March 22, 1999
Language: English
ISBN-10: 0471327611
ISBN-13: 978-0471327615
Product Dimensions:
9.3 x 7.5 x 0.9 inches
Shipping Weight: 1.4 pounds
Product Review
Data warehouses can help businesses identify trends early enough to capitalize upon them and can prove immensely valuable in running a company well. However, implementing a data warehouse requires that considerable effort be spent in corralling an organization's business processes, decision makers, customer base, and technology resources into a manageable form. Microsoft Data Warehousing helps map the process for you, particularly if you're planning to build your warehouse around Microsoft SQL Server 7 and its related technologies.
The Microsoft Data Warehousing Framework centers on the Microsoft Repository, and the authors of this book go into depth on how Repository represents metadata. They also cover the Component Object Model (COM), Open Database Connectivity (ODBC), Object Linking and Embedding database (OLE DB), and ActiveX Data Objects (ADO) as they relate to enterprise databases. While Microsoft Data Warehousing gets into actual development of SQL Server systems to a small extent, the book's illustrations are mainly useful as educational tools--you'll want to have a more development-centric book on hand for actual construction work.
In addition to its overview of Microsoft's enterprise database technologies, this book provides quite a bit of management information and commentary. If you are curious about what enterprise data management can do for your company or you are involved in designing a warehouse system from the top, you will find this business-centric information helpful. --David Wall
Book Description
Microsoft 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. 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. JOSEPH A. VIVONA is Vice President of Applications Development and Delivery at KPI Technologies Inc., which specializes in the development and deployment of Decision Support applications using various OLAP tools. He has more than ten years of experience in BRP and product development, focusing on how technology can be applied to help organizations reduce their amount of manual analysis and report generation for their data warehouse. DAVID BERCOVITCH has over eight years of experience working with decision-support technology and is currently a partner in The Sierra Consulting Group which specializes in creating the information-centric office, an environment where information is at the hub of corporate decision-making.
|
Microsoft(r) Data Warehousing: Building Distributed Decision Support Systems
Available from Amazon
Price: $0.44
| |
|
|
|
|
