m icrosoft data warehousing sql server 7 0 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
M icrosoft Data Warehousing - SQL Server 7.0 - PowerPoint Presentation
Download Presentation
M icrosoft Data Warehousing - SQL Server 7.0 -

Loading in 2 Seconds...

play fullscreen
1 / 26

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


  • 833 Views
  • Uploaded 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
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
Microsoft’s Data Warehousing Strategies
  • Reducing complexity
  • Reducing costs
  • Increasing scalability
reducing complexity
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
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
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
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
Data Warehousing Requirements
  • Access to diverse information sources
  • Integrating and consolidating information from heterogeneous data sources
  • Data warehouses
sql server 7 0 features
SQL Server 7.0 Features
  • Scalable Business Solutions
  • Powerful Data Warehousing
  • Integration with Microsoft Office 2000
scalable business solutions
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
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
Integration with Microsoft Office 2000
  • New Microsoft Data Engine (MSDE)
  • New PivotTable® Service
sql server 7 0 olap services
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
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
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
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
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
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
Industry Standards and Other Vendors: Sybase
  • Adaptive Server IQ
  • Column based indexing
  • Performance optimized algorithms
case study shoney s restaurants
Case Study: Shoney’s Restaurants
  • Background
  • Platforms
  • Issue Description
  • Product Functionality
  • Strengths
  • Weaknesses
  • Technical Support
case study shoney s restaurants21
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
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
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
Microsoft’s Answer
  • Partnered with NCR to integrate its high-end Teradata server with SQL Server 7.0