Developing Analytical Database Applications

Developing Analytical Database Applications

4 (1 rating by Goodreads)
By (author)  , By (author) 

List price: US$57.00

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

A strategic approach to enterprise database development. Developing Analytical Database Applications delivers a complete best-practices methodology for building goal-directed enterprise database applications. Based on the advanced spiral approach, it focuses on the key stages of development that can make or break your project. Learn how to identify your applications strategic vision and scope-and transform this information into a detailed, practical design. Next, walk through constructing the application, and deploying it with maximum effectiveness. Coverage includes: * A complete, practical discussion of dimensional concepts. * Formal modeling techniques for producing analytical applications-with specific data warehousing examples. * Techniques for matching technologies to tasks and employee expertise. * RAD approaches for delivering the enterprises most strategic processes first. * Mechanisms for reviewing and modifying applications as business goals change. Developing Analytical Database Applications is a complete roadmap for ensuring that your enterprise database applications achieve your strategic goals-now, and for years to come.
show more

Product details

  • Hardback | 640 pages
  • 175 x 232 x 41mm | 1,274g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130824305
  • 9780130824301

Table of contents

1. Knowledge Workers and Analytical Applications. What Are Analytical Applications? The Business Need for Analytical Applications. Downsized Organizations. Brittle Systems. Dispersed Decision Making. Faster Access to Information. Knowledge Workers and Analytical Applications. What Knowledge Workers Require. What Knowledge Workers Want. The Structure of Methodologies. Task Domain Analysis. User Domain Analysis. Data Domain Analysis. Summary. 2. A Model For Analytical Applications. Typical Analytical Applications. Sales Performance. Budgeting and Planning. Manufacturing. Common Elements in Analytical Applications. A Model of Analytical Applications. Deep Structure. The Surface Structure. Life At the Interface. Summary. 3. Decision Support and Analytical Applications. The components of information. Content. Structure. Delivery. Knowledge Worker Tasks. Monitoring & Reporting. Analysis & Diagnosis. Simulation & Planning. DSS Technology Space. Data Acquisition Quality and Delivery. Query and Report Writers. Managed Query Environment. Data Visualization. Data Mining. Architectures for Analytical Applications. Relational Online Analytical Processing (ROLAP). Multi-dimensional Databases (MDBs). Hybrid OLAP. Which Technology is More Suitable? Technology Requirements in the DSS Space. Summary. 4. Dimensional Structure of Analytical Applications. Multi-dimensional Views. The Structure of Information. Types of Dimensions. Structural Dimensions. Information Dimensions. Partitioning Dimensions. Categorical Dimensions. More about Dimensions. Multicubes vs. Hypercubes. Dimension Depth and Height. Data Sparsity. Dimensional Explosion. Dimensional Databases. The Star Schema. Deciding between MDBs and RDBs. Summary. 5. Architecture for Analytical Applications. A Sample Database. The Semantics of Information. An Example of a Semantic Ambiguity. Analytical Database Terms and Definitions. Notes on Facts and Dimensions. Implementing dimensional tables. Requirements. Monitoring and reporting. Sharing results. Analysis and diagnosis. Simulation and planning. Summary. 6. A Methodology for Analytical Applications. System Model and Documentation. What is a Methodology? Different Kinds of Methodologies. Summary of Four Quadrants. Quadrant I: Vision & Scope. Quadrant II: Design. Quadrant III: Build. Quadrant IV: Deployment. Project Planning. Task Management. Developing the Plan. Summary. 7. Vision & Scope. Application Goals and Constraints. Monthly Close Processing. IS Staffing Levels. System Availability. Data Center Operations. Technology Decisions. End-user Computing. Setting Goal Priorities. Vision & Scope: Purpose. Vision & Scope: Deliverables. Introduction. Purpose. Goals and Constraints. Readiness Assessment. Project Planning. Glossary. Vision & Scope Actions. Schedule of Events for Vision & Scope. The Consensus Meeting. Collaborative Sessions. Readiness Assessment. Commitment Meeting. Summary. 8. Design. Purpose. Design Qualities. Deliverables: Design Document. Management Documentation. Functional Documentation. Participatory Design. Technical Documentation. Activities: Defining the Business Processes. Collaborative Design Sessions. Source System Analysis. Analytical Process Analysis. Actions. Business Process Design. Assessment. Planning. Commitment Meeting. Summary. 9. Build and Deployment. Build. Imperative
show more

Rating details

1 ratings
4 out of 5 stars
5 0% (0)
4 100% (1)
3 0% (0)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X