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

niveditha
m icrosoft data warehousing sql server 7 0 l.
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 -

play fullscreen
1 / 26
Download Presentation
M icrosoft Data Warehousing - SQL Server 7.0 -
843 Views
Download Presentation

M icrosoft Data Warehousing - SQL Server 7.0 -

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Microsoft Data Warehousing - SQL Server 7.0 - State of the Technology Presentation by Sujata Angara Nakul Johri Sang Ho Park

  2. Microsoft’s Data Warehousing Strategies • Reducing complexity • Reducing costs • Increasing scalability

  3. 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

  4. 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

  5. Addressing Scalability • Database that can scale upwards to up to 3TB • Scale downwards into the small and midsize business (SMB) market

  6. Microsoft Data Warehousing Products Two products that address the server and client • SQL Server 7.0 and • Office 2000 (Excel 2000 in particular)

  7. Data Warehousing Requirements • Access to diverse information sources • Integrating and consolidating information from heterogeneous data sources • Data warehouses

  8. SQL Server 7.0 Features • Scalable Business Solutions • Powerful Data Warehousing • Integration with Microsoft Office 2000

  9. Scalable Business Solutions • Terabyte-sized database support • Scalability • Easy to Build, Manage, and Deploy • Designed for Mobile Computing • An Ideal Platform for Commerce

  10. Powerful Data Warehousing • Database with Integrated OLAP and Data Transformation Services (DTS) • Integration with the Microsoft Repository • Advanced query processor • Visual Data Tools

  11. Integration with Microsoft Office 2000 • New Microsoft Data Engine (MSDE) • New PivotTable® Service

  12. 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

  13. 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

  14. SQL Server 7.0 OLAP Services Salient features: • Highly scalable architecture • Extensibility • Wide availability of desktop application clients • Low cost of ownership

  15. 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

  16. Microsoft Data Warehousing Framework

  17. Data Warehousing Framework Components Two enabling technologies • The integrated metadata repository • The data transport layer (OLE DB)

  18. 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

  19. Industry Standards and Other Vendors: Sybase • Adaptive Server IQ • Column based indexing • Performance optimized algorithms

  20. Case Study: Shoney’s Restaurants • Background • Platforms • Issue Description • Product Functionality • Strengths • Weaknesses • Technical Support

  21. 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

  22. 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

  23. 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

  24. Microsoft’s Answer • Partnered with NCR to integrate its high-end Teradata server with SQL Server 7.0

  25. Questions?

  26. THANK YOU