Tài liệu, ebook Cơ Sở Dữ Liệu

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 ...

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

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*

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

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...

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

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...

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

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

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

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...

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

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)

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

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...

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

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

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

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...

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