1 / 16

SFDV3002

SFDV3002. Introduction to Databases Spring, 2012. Major theme of SFDV3002. Database management systems (DBMS): What are they and what do they do? Defining, accessing, controlling Efficient multi-user access Database programming. Motivation. Databases are everywhere : Hospitals

lucia
Download Presentation

SFDV3002

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. SFDV3002 Introduction to Databases Spring, 2012

  2. Major theme of SFDV3002 Database management systems (DBMS): • What are they and what do they do? • Defining, accessing, controlling • Efficient multi-user access • Database programming SFDV3002

  3. Motivation • Databases are everywhere: • Hospitals • Local government • Human Genome • Virtual sports • Student records • Must design, implement, access and manage large, efficient, multi-user, corporate databases. large amounts of data often accessed simultaneously by large numbers of people SFDV3002

  4. How many databases are you listed in? **Insert montage of local and international business and organisation logos (e.g., banks, government, police, retailers, financial, utilities, online services, etc., etc.). Examples above to get things started. Could animate appearance into logical groupings as listed in the notes. Suggest starting with your University logo.** SFDV3002

  5. Abstract vs. concrete Abstract: • Systems (database) analysis and design • Conceptual modelling • “Traditional” (ERD) vs. object (UML) modelling Concrete (SFDV3002): • The Relational Model of Data • Database implementation and access • Management of large databases with multiple concurrent users SFDV3002

  6. Conceptual level (e.g., ERD) Logical level (e.g., relational, SQL) Physical level (blocks, files, pointers) The “three-schema” (ANSI/SPARC) architecture SFDV3002

  7. **modify as appropriate** Putting SFDV3002 in context • SFDV2002 • Information systems modelling and design • SFDV2004 • Application software development • SFDV3002 • SQL • Multi-user DBMS • Database applications • SFDV3003 • Systems analysis • Conceptual & logical modelling (relational, object) • SFDV3007 • Database admin • Distributed data management • Object DBMS • Decision support SFDV3002

  8. Assumed knowledge & skills • Basic conceptual modelling (ERDs) (see Kifer ch. 4) • Basic relational model (relations, attributes, keys) SFDV3002

  9. Overview of SFDV3002 Chapter 1: Relational database management systems • Motivation and functions • The Relational Model of Data • Relational Algebra Chapter 2 : • Conceptual Model Translation • Normalization SFDV3002

  10. Overview of SFDV3002 Chapter 3: SQL • Database definition (tables, constraints, etc.) • Data manipulation (inserting, querying, etc.) Chapter 4: Multi-user database issues • Security • Transactions • Concurrent access and locking • Advanced integrity checking with triggers SFDV3002

  11. Overview of SFDV3002 Chapter 5: Database programming with SQL • Server-side SQL programming • Oracle10g PL/SQL • Cursors • Procedures • Functions • Triggers • Packages SFDV3002

  12. Why no objects? • Concepts applicable to both relational and object DBMSs. • RDBMSs predominant. • Lack of effective standards (ODMG). • Briefly revisit in SFDV3007. SFDV3002

  13. Recall: the E-R approach(Kifer ch. 4) “many” “one” • PowerDesigner (Finkelstein) notation. • Conceptual model for data analysis. • Entities, relationships, attributes. • Cardinality, participation. Order_head Customer relationship “optional” “mandatory” SFDV3002

  14. Recall: the E-R approach(Kifer ch. 4) “many” “one” • Oracle Designer (Barker) notation. • Conceptual model for data analysis. • Entities, relationships, attributes. • Cardinality, participation. Order_head Customer relationship “mandatory” “optional” SFDV3002

  15. Recall: the Relational Model of Data(Kifer ch. 3) • Logical or implementation data model for most commercial DBMSs. • Relations/tables, attributes/columns, tuples/rows. • Candidate, primary & alternate keys. • Foreign keys. • Functional dependencies & normalisation. SFDV3002

  16. What’s next? Relational database management systems • What are they? • Why are they useful? • What do/should they do? • The Relational Model of Data in more depth • Structural aspects • Operations • Integrity SFDV3002

More Related