Datawarehousing

Datawarehousing PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on
  • Presentation posted in: General

Presentation Outline. Datawarehousing Introduction- Kathryn WiyningerHomeRuns.com- Barry Cunningham7-Eleven- Ashima BajajStaffordshire Police- Neil FergusonSummary- Regan Kirkpatrick. What is a Data Warehouse?.

Download Presentation

Datawarehousing

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


1. Datawarehousing Group #4 Ashima Bajaj Barry Cunningham Kathryn Wiyninger Neil Ferguson Olumide Asojo Regan Kirkpatrick

2. Presentation Outline Datawarehousing Introduction - Kathryn Wiyninger HomeRuns.com - Barry Cunningham 7-Eleven - Ashima Bajaj Staffordshire Police - Neil Ferguson Summary - Regan Kirkpatrick

3. What is a Data Warehouse?

4. The center of the architecture for information systems Provides a solid platform of integrated, historical data Is always a physically separate store of data transformed from the application data found in the operational system ALWAYS. WITH NO EXCEPTIONS, the data found within the warehouse is integrated

5. How it works Subject-oriented Integrated Time-variant Nonvolatile

6. Subject Orientation Oriented around the major subjects of the enterprise Focuses on data modeling and database design exclusively Spans a spectrum of time to find many relationships

7. Integration Final product is a singular and globally-acceptable set of information Accomplishes consistency in: Naming conventions Variable measurement standards Encoding structures Data attribution characteristics

8. Time Variant Some moment in time = Not “right now” Time horizon is 5 to 10 years Nearly always an implicit part of the key Long series of snapshots

9. Nonvolatile Initial loading of data Access of data No update of data as a normal part of processing Change in data is restricted to accuracy problems Data is either appended or removed

10. Benefits of Datawarehousing More cost effective decision making Better enterprise intelligence Enhanced customer service Better asset/liability management Business process reengineering Empowerment of all employees

12. Case Study #1

13. HomeRuns.com

19. If Only We Lived in Boston!

20. Case Study #2

21. Background Convenience-store retailing in Japan since 1973 Largest operator, franchiser and licenser of convenience stores Parent company is Southland Corporation, founded in 1927 in Dallas, Texas 7-Eleven Japan Co., Ltd has owned a majority interest in Southland since 1991 7-Eleven Japan operates more than 7,500 7-Eleven stores in Japan and Hawaii under an area license agreement with Southland In 1997, 7-Eleven Japan achieved a profit of 100 billion Yen (US $1 billion)

22. Challenge Track daily sales and inventory of 7,500 retail outlets nationwide, each stocking more than 3,000 different products. To provide system-wide data access to enable speedy, accurate analysis of sales and marketing trends. Design system to facilitate faster, more accurate decision-making on product selection, volume and pricing Each day, outlets generate 2.7 GB of point-of-sales data; need to store data for 450 days Total over 1 TB worth of data

23. Solution Hewlett Packard used for the main system platform Oracle used for database management For large-scale server -nucleus of the system- HP UNIX server and an HP 9000 Enterprise server For the groupware for information sharing- Windows NT-based HP NetServer with HP Kayak PC workstations and HP Vectra PCs For smaller, desktop systems installed at retail outlets- Windows NT based computers

24. Solution cont. In Total: Five HP 9000 K460 servers 225+ HP NetServers accessing the K460s Oracle 8 database with 4.5 TB’s of data 10 TB of disk 100+ concurrent users

25. Why Oracle?

26. Results Speedy, targeted response to customers’ changing needs Real-time tracking of deliveries, product sales, buying patterns and customer profiles to facilitate more accurate decision-making and improvement of inventory management and control Fast, accurate sales projections to maintain leadership position in market Multi-tasking, multi-windows environment that lets users perform business functions in one window, while searching for data in other windows

27. Results Cost savings on internal software development Reduced software development time Currently, with technological advances and efficiencies, quarterly net sales revenues for all 7-Eleven stores are over 2 trillion dollars

28. Case Study #3 Fighting Crime with Business Intelligence The Staffordshire Police

29. Serve County of Staffordshire Stoke-on-Trent Lichfield Stafford 1997/98 - 88,000+ crimes 2,290 police officers 1,300 civilian support staff 10 operational Divisions Staffordshire Police

30. Staffordshire Police

31. Custom-made applications: Crime Recording Custody Recording File Preparation Courts Administration Intelligence System Staffordshire Police

32. Current software platform: Ingres relational database 30 Bull DPX/2 UNIX platforms 400+ users System drawbacks: Limits free-ranging queries through character-based terminals Staffordshire Police

33. Problem #1: Lacking ability to access all Ingres databases from one application Solution: Hummingbird BI/Query Query and reporting component of BI/Suite Hummingbird’s integrated business intelligence solution for the enterprise Implemented in 1994 Staffordshire Police

34. Inspector Phil Challinor - “BI/Query was by far the easiest of the reporting tools to use, and we received excellent support from Hummingbird.” Use/Implementation of BI/Query Initially, handful of users Deployed over entire force Staffordshire Police

35. Problem #2: Decline in report usefulness & effectiveness For example, Simple search to identify the owners of recovered property meant sifting through mass amounts of irrelevant data More precise approach necessary Staffordshire Police

36. Why was this important? 80/20 rule Small number of criminals commit majority of crimes More detailed analysis of data would reveal information about offenders Leading to eventual prosecution Staffordshire Police

37. Solution: BI/Query Already in use Protect existing IT investment Most cost-effective solution Ability to: Chart or map data Filter results Staffordshire Police

38. Phased implementation: Creation of standard formats for data entry Enhancing Home Office crime codes Developing BI/Query data models and reports with a user-friendly front-end (GUI) Widely deployed in early 1998 Staffordshire Police

39. Functions included: General queries Property queries Statistical searches Crime profiling queries Prolific-offender queries More complex queries from police headquarters Staffordshire Police

40. Mapping of Data: Caliper Corporation’s Maptitude Entry-level computerized mapping and spatial analysis system Hummingbird’s BI/Query Resulting in COMET, Crime and Offender Mapping Evaluation Tool Ability to: Mine crime data Map the results Staffordshire Police

41. Benefits of COMET: Presents crime information in a tabular, graphical, or geographical form More readily understandable than list of numbers Significant time savings Manual research used to take days or weeks COMET searches can be completed in <20 minutes Resulting in a quick apprehension of the perp Staffordshire Police

42. Benefits of COMET: Track emerging trends Be more proactive Overall increase in productivity and effectiveness Staffordshire Police

43. What else is planned? BI/Analyze is being used to give a multidimensional view of data Combine data from multiple Divisional databases to provide officers with a big-picture view of crime within the force’s jurisdiction Staffordshire Police

44. Benefits: Scalability Performance Efficiency Time Cost Flexibility Business Advantage Time Sensitive Information Datawarehousing Summary

  • Login