Đồ án, luận văn, do an, luan van

Database Management System - Chapter 16: Data Warehouse Technology and Management
Outline 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: 724 | Lượt tải: 0
Database Management System - Chapter 15: Transaction Management
Outline Transaction basics Concurrency control Recovery management Transaction design issues Workflow management
49 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 668 | Lượt tải: 0
Database Management System - Chapter 14: Data and Database Administration
Outline 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: 661 | Lượt tải: 0
Database Management System - Chapter 13: Database Design for Student Loan Limited
Outline 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: 788 | Lượt tải: 0
Database Management System - Chapter 12: View Design and Integration
Outline 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: 667 | Lượt tải: 0
Database Management System - Chapter 11: Stored Procedures and Triggers
Outline 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: 671 | Lượt tải: 0
Database Management System - Chapter 10: Application Development with Views
Background 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: 640 | Lượt tải: 0
Database Management System - Chapter 9: Advanced Query Formulation with SQL- Part 2
Before 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: 761 | Lượt tải: 0
Database Management System - Chapter 9: Advanced Query Formulation with SQL - Part 1
Outer join problems Type I nested queries Type II nested queries and difference problems Nested queries in the FROM clause Division problems Null value effects
37 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 671 | Lượt tải: 0
Database Management System - Chapter 8: Physical Database Design
Overview of Physical Database Design File Structures Query Optimization Index Selection Additional Choices in Physical Database Design
70 trang | Chia sẻ: candy98 | Ngày: 28/11/2020 | Lượt xem: 666 | Lượt tải: 0