Chapter 1: Introduction. Chapter 1 provides a general overview of the nature and purpose of database systems. We explain how the concept of a database system has developed, what the common features of database systems are, what a database system does for the user, and how a database system interfaces with operating systems.

 24 p tgu 24/02/2024 4 0 Download

Chapter 3 introduction to SQL. This chapter presents the following content: Data definition, basic query structure, set operations, aggregate functions, null values, nested subqueries, complex queries, views, modification of the database.

 78 p tgu 24/02/2024 6 0 Download

Chapter 4 - Intermediate SQL. In this chapter, we continue our study of SQL. We consider more complex forms of SQL queries, view definition, transactions, integrity constraints, more details regarding SQL data definition, and authorization.

 52 p tgu 24/02/2024 7 0 Download

Chapter 9 - Application design and development. Chapter 9 covers application design and development. This chapter emphasizes the construction of database applications with Web-based interfaces. In addition, the chapter covers application security.

 61 p tgu 24/02/2024 5 0 Download

Chapter 14 - Transactions. This chapter focuses on the fundamentals of a transaction-processing system: atomicity, consistency, isolation, and durability. It provides an overview of the methods used to ensure these properties, including locking and snapshot isolation.

 53 p tgu 24/02/2024 4 0 Download

Chapter 16 - Recovery system. This chapter covers the primary techniques for ensuring correct transaction execution despite system crashes and storage failures. These techniques include logs, checkpoints, and database dumps. The widely-used ARIES algorithm is presented.

 95 p tgu 24/02/2024 5 0 Download

Chapter 15 - Concurrency control. This chapter focuses on concurrency control and presents several techniques for ensuring serializability, including locking, timestamping, and optimistic (validation) techniques. The chapter also covers deadlock issues. Alternatives to serializability are covered, most notably the widely-used snapshot isolation, which is discussed in detail.

 90 p tgu 24/02/2024 4 0 Download

Chapter 11 - Indexing and hashing. This chapter covers indexing techniques ranging from the most basic one to highly specialized ones. Due to the extensive use of indices in database systems, this chapter constitutes an important part of a database course. A class that has already had a course on data-structures would likely be familiar with hashing and perhaps even B + -trees. However, this chapter is necessary reading even for those students...

 90 p tgu 24/02/2024 5 0 Download

This chapter describes the process by which queries are executed efficiently by a database system. Query processing refers to the range of activities involved in extracting data from a database. The activities include translation of queries in high-level database languages into expressions that can be used at the physical level of the file system, a variety of query-optimizing transformations, and actual evaluation of queries.

 57 p tgu 24/02/2024 7 0 Download

Chapter 10 - Storage and file structure. In this chapter, we probe below the higher levels as we describe various methods for implementing the data models and languages presented in preceding chapters. We start with characteristics of the underlying storage media, such as disk and tape systems. We then define various data structures that allow fast access to data.

 59 p tgu 24/02/2024 6 0 Download

Chapter 13 describes how queries are optimized. This chapter presents the following content: Transformation of relational expressions, catalog information for cost estimation, statistical information for cost estimation, cost-based optimization, dynamic programming for choosing evaluation plans, materialized views.

 80 p tgu 24/02/2024 6 0 Download

Bài giảng Lập trình hướng đối tượng nâng cao: Chương 8 do ThS. Thái Kim Phụng biên soạn trình bày nội dung về XML Serialization là gì, sử dụng XML Serialization, ví dụ minh họa,...Mời các bạn cùng tham khảo!

 14 p tgu 24/01/2024 17 0 Download