1 / 32

Overview: Databases

Learn about database systems, major systems like Oracle and SQL Server, database architecture, warehouse concepts, and key technologies in this comprehensive overview.

jagnes
Download Presentation

Overview: Databases

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Prof. HeleMai Haav: CSC 230 Spring *03 Overview: Databases

  2. A database system (DBMS) is a program product for keeping computerized records about an enterprise • sales database • university database • web examples ?

  3. Database system provides efficient, convenient, and safe multi-user storage of and access to massive amounts of persistent dataBanking systemdata-?Massive -many gigabytes, on diskpersistent -data outlives programs that operate itmulti-user -Jane and ATM1; John and ATM2; the same account numbersafe -from system failures and malicious usersconvenient -simple commandsefficient - do not search all files to find info

  4. Major Database Systems • Oracle-Oracle server, runs Unix, Win NT: www.oracle.com • DB2 Universal Database-IBM, Unix www.ibm.com/db2 • Informix Dynamic Server 2000, Unix www.informix.com • Microsoft SQL Server, Access • Sybase

  5. A Relational database

  6. Object Relational database

  7. Database System Architecture

  8. SQL Agent Module Connection session SQL-server SQL client The SQL Client-server interaction

  9. Database Users • End users • casual- SQL queries • naïve- menus • application programmers- write apps • database administrators-supervise the DBMS

  10. Data Warehouses

  11. Roughly 90% of decisions are made without the benefit of the information you already have. • The most intelligent solution is an open, integrated data warehouse and business intelligence infrastructure based on proven technology and industry "best practices" to turn that data into a strategic resource while reducing risk.

  12. Data warehousing is bringing data from operational databases to a single warehouse to do • analysis (OLAP) • and mining www.walmart.com

  13. What is in data warehouse? • “fact data” • sales transactions, course enrollments • update frequently, very large • “dimension data” • store items, students, courses • update infrequently, not as large

  14. Two models for data warehouse dim • Relational OLAP • star schema • Multidimensional OLAP • data cube, • facts in cells • dimensions form axes facts time Total sales region facts sales channel

  15. Oracle 11i www.oracle.com education.oracle.com Sybase Industry Warehouse Studio Adaptive Server IQ www.sybase.com

  16. Oracle 9i Oracle9i Database Oracle9i Database Release 2 is the first major follow-on release to the award-winning Oracle9i Database. In addition to numerous quality and performance enhancements, Oracle9iDB Release 2 features full XML database functionality with the new XML DB feature, enhancements to the groundbreaking Oracle9i Real Application Clusters and additional self-tuning and self-management capabilities to help improve productivity and efficiency. In addition, the built-in OLAP functionality has been expanded and significant enhancements and tunings have been made for Windows and Linux systems.

  17. Sybasehttp://www.sybase.com/

  18. MS Access • http://www.microsoft.com/office/using/column06.asp • http://www.microsoft.com/office/access/evaluation/tour/page3.asp

  19. Rolling Thunder Bicycles (an example)

More Related