• Object-Oriented database developmentObject-Oriented database development

    Updating tuples in a nested table: update table (select beers from manfs m where m.name = ‘Anheuser’) b set b.color = ‘blue’; First, you have to flatten the object table using the pseudo function table before you can do an update on the object table. Not quite obvious, because update essentially refers only to the object table beers and not ...

    ppt93 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 4 | Lượt tải: 0

  • Bài giảng Database System - 13. Emerging Research Directions in DBs/ISsBài giảng Database System - 13. Emerging Research Directions in DBs/ISs

    Research Directions (2006-2010) (cont.) Advanced Information Systems: E-/M-Commerce SOA-Based Modern Information Systems Large Database Systems Web Information Systems Modern Information Retrieval Systems Stream Data Management* Bioinformatics*

    ppt51 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 8 | Lượt tải: 0

  • Bài giảng Database System - 12. Database Security: An IntroductionBài giảng Database System - 12. Database Security: An Introduction

    Summary Introduction to Database Security Issues Types of Security Threats to databases Database Security and DBA Access Protection, User Accounts, and Database Audits Discretionary Access Control Types of Discretionary Privileges Specifying Privileges Using Views Revoking Privileges Propagation of Privileges Using the GRANT OPTION An ex...

    ppt53 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 9 | Lượt tải: 0

  • Bài giảng Database System - 11. Practical Database Design and TuningBài giảng Database System - 11. Practical Database Design and Tuning

    Additional Query Tuning Guidelines WHERE conditions may be rewritten to utilize the indexes on multiple columns. Example: SELECT REGION#, PROD_TYPE, MONTH, SALES FROM SALES_STATISTICS WHERE REGION# = 3 AND ((PRODUCT_TYPE BETWEEN 1 AND 3) OR (PRODUCT_TYPE BETWEEN 8 AND 10)); may use an index only on REGION# and search through all leaf pa...

    ppt24 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 6 | Lượt tải: 0

  • Bài giảng Database System - 10. Overview of Database Design ProcessBài giảng Database System - 10. Overview of Database Design Process

    Data Storage Disk Storage Devices Files of Records Operations on Files Unordered Files Ordered Files Hashed Files RAID Technology Indexing Structures for Files Types of Single-level Ordered Indexes Multilevel Indexes Dynamic Multilevel Indexes Using B-Trees and B+-Trees Indexes on Multiple Keys

    ppt52 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 7 | Lượt tải: 0

  • Bài giảng Database System - 8 & 9. Functional Dependencies & Normalization for Relational DBsBài giảng Database System - 8 & 9. Functional Dependencies & Normalization for Relational DBs

    Introduction: “goodness” measures for relations Functional dependencies (FDs) Definition of FD Direct, indirect, partial dependencies Inference Rules for FDs Equivalence of Sets of FDs Minimal Sets of FDs Normalization 1NF and dependency problems 2NF – solves partial dependency 3NF – solves indirect dependency BCNF – well-normalized rela...

    ppt66 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 10 | Lượt tải: 0

  • Bài giảng Database System - 6 & 7. SQL (Structured Query Language)Bài giảng Database System - 6 & 7. SQL (Structured Query Language)

    SQL developments: an overview SQL DDL: Create, Alter, Drop DML: select, insert, update, delete Introduction to advanced DDL (assertions & triggers), views, DCL (commit, rollback, grant, revoke)

    ppt92 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 6 | Lượt tải: 0

  • Bài giảng Database System - 5. Relational AlgebraBài giảng Database System - 5. Relational Algebra

    Brief Introduction to Relational Calculus Another variation of relational calculus called the domain relational calculus, or simply, domain calculus is equivalent to tuple calculus and to relational algebra QBE (Query-By-Example): see Appendix D Domain calculus differs from tuple calculus in the type of variables used in formulas: rather than ha...

    ppt60 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 8 | Lượt tải: 0

  • Bài giảng Database System - 1. Database System Concepts and ArchitectureBài giảng Database System - 1. Database System Concepts and Architecture

    File-based Approach Database Approach Three-Schema Architecture and Data Independence Database Languages Data Models Database Schema and Database State Data Management Systems Framework (where are we?) Next week: ER Model

    ppt39 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 7 | Lượt tải: 0

  • Bài giảng Database System - 4. Relational Data Model and ER-/EER-to-Relational MappingBài giảng Database System - 4. Relational Data Model and ER-/EER-to-Relational Mapping

    Summary Relational Data Model Basic Concepts Relational Integrity Constraints: key, primary & foreign keys, entity integrity constraint, referential integrity Update Operations on Relations ER/EER-to-Relational Mapping 3 Main Phases of Database Design: An Overview Conceptual Database Design: A Summarization Logical Database Design ER- & EE...

    ppt76 trang | Chia sẻ: vutrong32 | Ngày: 19/10/2018 | Lượt xem: 9 | Lượt tải: 0