1 / 19

MD807: Relational Database Management Systems

MD807: Relational Database Management Systems. Introduction Course Goals & Schedule Logistics Syllabus Review RDBMS Basics RDBMS Role in Applications RDBMS Functions. Course Goals. Database Management Concepts Design, Capabilities, Limitations Development Process

nitsa
Download Presentation

MD807: Relational Database Management Systems

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. MD807: Relational Database Management Systems • Introduction • Course Goals & Schedule • Logistics • Syllabus Review • RDBMS Basics • RDBMS Role in Applications • RDBMS Functions

  2. Course Goals • Database Management Concepts • Design, Capabilities, Limitations • Development Process • Detailed knowledge of SQL “API” • Managing Data • Manipulating Data • Strong Focus on Reporting • Database Application Development • Focus on procedures • Database-oriented web development

  3. Logistics • Webpage: www2.bc.edu/~spang • Reference Material • Syllabus / Schedule • Access to the Oracle Software • Isqlplus.bc.edu • bcacad3 • Project • Grading • Labs

  4. Syllabus / Sequence • Purpose / Need • Logical design • Physical design • Data Management • SQL Reporting • Procedure development • Data/Logic Security • Data Integrity and Protection • Web Application Environment

  5. BC’s Oracle Software • Host Database • Oracle Release 9i tools • BCACAD1 Instance (Rel 8.1) • Userids/passwords • iSQLPlus on the web • SQLPlus “Thick” Client • Universal Oracle client • Available on BC network • SQLLoader • HTMLDB • Oracle 10 App Development tool

  6. The DBMS in the Application Environment Web Server Disk Storage Client (Browser) browser “Jolt” “OS” DBMS Server Application Server SQLNet, ODBC,…

  7. Application Development Environment Network Servers Operating System/Subsystems Common System Utilities Common Business Code Application Specific Code

  8. DBMS Application Services • Physical Storage of Data • Metadata Repository • API/Language to manage • API/Language to /Use • Utilities and Services • Recovery, Performance • Usage Management • Sharing

  9. DBMS Application Advantages • Single, consistent source of rules for accessing data • Shared access for users, processes • Insulation from data storage mechanics • Increased granularity of access • Integrity/recovery functions

  10. The DBMS Server layers DBMS Storage DBMS Server Database Tablespace Table Tablespace Table Table Server Instance Schema Instance Schema Schema “Mounts”

  11. DBMS Architecture • Disk Storage / File System • DBMS Application • Server • Instance • Schema • Logical Data Constructs • Tablespaces • Tables • Views • Clients • SQLNet Heavy Clients • Web Clients

  12. DBMS Operations • Starting the Instance • Mounting the database • Opening the Database • Quiescing / Closing the Database

  13. Data Integrity • Locking • Allows simultaneous use • Different levels available • Logging • Prevent partial updates • Recovery from failures • Constraints • Limits on acceptable entries • Discussed in detail later • Process

  14. Locking Scenario • User A requests record 5 • User B requests record 5 • User A changes record 5 • User A commits changes • User B changes record 5 • User B commits changes

  15. Data Security • Granularity • Filter records • Filter columns • Type of Access • E.g. read-only • Multiple levels • Database • Table • Function • Roles • Groups of privileges • Assignable to individuals

  16. SQL API • Defines command syntax • Data Definition • Data Manipulation • Session Management • Open Standard • Extensions for each vendor

  17. Utilities • Import / Export • SQLLOADER • Backup / Recovery • Administrative tools for DDL/DML • Operations Management • Gateways

  18. Terminology Review • Database Server • Database Instance • Schema • Table-space • Table • View • Column, Row • Data type • Procedure • Set Processing

  19. Preview the Sample Database Login Finding Data Running a request

More Related