Database Management System - Chapter 18: Object Database Management SystemsOutline Motivation for object database management Object-oriented principles Architectures for object database management Object database definition and manipulation in SQL:2003 Object database definition and manipulation in Oracle 10g
61 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 529 | Lượt tải: 0
Database Management System - Chapter 17: Client-Server Processing, Parallel Database Processing, and Distributed DatabasesOverview Client-Server Database Architectures Parallel Database Architectures Architectures for Distributed Database Management Systems Transparency for Distributed Database Processing Distributed Database Processing
58 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 519 | Lượt tải: 0
Database Management System - Chapter 16: Data Warehouse Technology and ManagementOutline Basic concepts and characteristics Business architectures and applications Data cube concepts and operators Relational DBMS features Maintaining a data warehouse
56 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 493 | Lượt tải: 0
Database Management System - Chapter 15: Transaction ManagementOutline Transaction basics Concurrency control Recovery management Transaction design issues Workflow management
49 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 509 | Lượt tải: 0
Database Management System - Chapter 14: Data and Database AdministrationOutline 1. Organizational context 2. Tools of database administration 3. Processes for database specialists 4. Overview of processing environments
46 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 495 | Lượt tải: 0
Database Management System - Chapter 13: Database Design for Student Loan LimitedOutline 1. Case description 2. Conceptual data modeling 3. Logical database design 4. Physical database design Case Overview Guaranteed Student Loans Environment Student Lender Service Provider Guarantor Department of Education Replace existing information system
26 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 577 | Lượt tải: 0
Database Management System - Chapter 12: View Design and IntegrationOutline 1. Motivation for view design and integration 2. View design with forms 3. View integration Motivation Database complexity reflects organizational complexity. Time-consuming and labor-intensive process Collect requirements from different user groups Coordination among designer team members Manage complexity of large designs
43 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 510 | Lượt tải: 0
Database Management System - Chapter 11: Stored Procedures and TriggersOutline 1. Database programming language background 2. Stored procedures 3. Triggers Motivation for Database Programming Languages A procedural language with an interface to one or more DBMSs. Interface allows a program to combine procedural statements with nonprocedural database access. Customization Batch processing Complex operation...
48 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 528 | Lượt tải: 0
Database Management System - Chapter 10: Application Development with ViewsBackground Creating views and using views Processing queries that reference views Updatable views Data requirements for hierarchical forms Data requirements for reports
36 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 506 | Lượt tải: 0
Database Management System - Chapter 9: Advanced Query Formulation with SQL- Part 2Before beginning the animation, let's examine a SELECT statement containing a Type II nested query. Execution model of the Type II Nested query: - More complex execution model: nested loops - Nested query executes one time for each row in the outer query Example query: - Retrieve faculty who are not students - Type II nested query impleme...
6 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 564 | Lượt tải: 0
