M icrosoft data warehousing sql server 7 0
Download
1 / 26

M icrosoft Data Warehousing - SQL Server 7.0 - - PowerPoint PPT Presentation


  • 823 Views
  • Updated On :

M icrosoft Data Warehousing - SQL Server 7.0 - State of the Technology Presentation by Sujata Angara Nakul Johri Sang Ho Park Microsoft’s Data Warehousing Strategies Reducing complexity Reducing costs Increasing scalability Reducing Complexity Released Two Technical Specifications

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'M icrosoft Data Warehousing - SQL Server 7.0 -' - niveditha


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
M icrosoft data warehousing sql server 7 0 l.jpg
Microsoft Data Warehousing - SQL Server 7.0 -

State of the Technology Presentation by

Sujata Angara

Nakul Johri

Sang Ho Park


Microsoft s data warehousing strategies l.jpg
Microsoft’s Data Warehousing Strategies

  • Reducing complexity

  • Reducing costs

  • Increasing scalability


Reducing complexity l.jpg
Reducing Complexity

Released Two Technical Specifications

  • OLE DB for OLAP provides a common interface for front-end analysis tools to access OLAP engines

  • Open Information Model (OIM) - a metadata classification and organization standard


Reducing costs l.jpg
Reducing Costs

  • Bundled OLAP Services and supporting technologies (DTS and an English Query front-end interface) free with SQL Server 7.0.

  • Cheaper than most standalone OLAP servers


Addressing scalability l.jpg
Addressing Scalability

  • Database that can scale upwards to up to 3TB

  • Scale downwards into the small and midsize business (SMB) market


Microsoft data warehousing products l.jpg
Microsoft Data Warehousing Products

Two products that address the server and client

  • SQL Server 7.0 and

  • Office 2000 (Excel 2000 in particular)


Data warehousing requirements l.jpg
Data Warehousing Requirements

  • Access to diverse information sources

  • Integrating and consolidating information from heterogeneous data sources

  • Data warehouses


Sql server 7 0 features l.jpg
SQL Server 7.0 Features

  • Scalable Business Solutions

  • Powerful Data Warehousing

  • Integration with Microsoft Office 2000


Scalable business solutions l.jpg
Scalable Business Solutions

  • Terabyte-sized database support

  • Scalability

  • Easy to Build, Manage, and Deploy

  • Designed for Mobile Computing

  • An Ideal Platform for Commerce


Powerful data warehousing l.jpg
Powerful Data Warehousing

  • Database with Integrated OLAP and Data Transformation Services (DTS)

  • Integration with the Microsoft Repository

  • Advanced query processor

  • Visual Data Tools


Integration with microsoft office 2000 l.jpg
Integration with Microsoft Office 2000

  • New Microsoft Data Engine (MSDE)

  • New PivotTable® Service


Sql server 7 0 olap services l.jpg
SQL Server 7.0 OLAP Services

Overview:

  • Very low data retrieval performance

  • Data sources can include any OLE DB

  • Client-slide cache

  • Calculation engine- PivotTable® Service


Sql server 7 0 olap services13 l.jpg
SQL Server 7.0 OLAP Services

Salient features:

  • Ease of Use

  • Flexible data model

  • Elimination of the Data Explosion Syndrome

  • Intelligent client/server data management


Sql server 7 0 olap services14 l.jpg
SQL Server 7.0 OLAP Services

Salient features:

  • Highly scalable architecture

  • Extensibility

  • Wide availability of desktop application clients

  • Low cost of ownership


Microsoft data warehousing framework l.jpg
Microsoft Data Warehousing Framework

  • Easily integrated with and extended by third-party vendors

  • Import, export, validation, and cleansing services

  • Integrated metadata for data warehouse design

  • Core management services



Data warehousing framework components l.jpg
Data Warehousing Framework Components

Two enabling technologies

  • The integrated metadata repository

  • The data transport layer (OLE DB)


Industry standards and other vendors sas systems inc l.jpg
Industry Standards and Other Vendors: SAS Systems Inc

  • ERP Solutions

  • Enterprise Miner S/W

  • SAP AG’s R/3

  • HR Vision

  • Native compatibility is not a ready feature

  • Rapid Warehousing Methodology

  • Measurable business benefits within a 90-day project cycle


Industry standards and other vendors sybase l.jpg
Industry Standards and Other Vendors: Sybase

  • Adaptive Server IQ

  • Column based indexing

  • Performance optimized algorithms


Case study shoney s restaurants l.jpg
Case Study: Shoney’s Restaurants

  • Background

  • Platforms

  • Issue Description

  • Product Functionality

  • Strengths

  • Weaknesses

  • Technical Support


Case study shoney s restaurants21 l.jpg
Case Study: Shoney’s Restaurants

  • Performance Evaluation

    • Initial load of two to three years of historical data

    • Nightly incremental updates that exceeded 120,000 rows per day

    • Modified several Microsoft Access-based sales analysis applications

    • Analyze and report a variety of sales result


Microsoft limitations l.jpg
Microsoft Limitations

  • A complete range of knowledge-management systems requires other tools, notably ETT tools

  • Even the enhanced spreadsheet applications with Excel 2000 will still provide only rudimentary analysis


Microsoft limitations23 l.jpg
Microsoft Limitations

  • Scalability of SQL Server 7.0 not yet proven

  • These competitive claims were crystallized in "Oracle Million Dollar Challenge" Microsoft does not have a satisfactory answer to this


Microsoft s answer l.jpg
Microsoft’s Answer

  • Partnered with NCR to integrate its high-end Teradata server with SQL Server 7.0




ad