• Lecture Database system concepts (6/e): Chapter 2 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 2 - Silberschatz, Korth, Sudarshan

    Chapter 2 - Intro to relational model. Chapter 2 introduces the relational model of data, covering basic concepts such as the structure of relational databases, database schemas, keys, schema diagrams, relational query languages, and relational operations.

     30 p tgu 24/02/2024 3 0

  • Lecture Database system concepts (6/e): Chapter 5 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 5 - Silberschatz, Korth, Sudarshan

    Chapter 5 - Advanced SQL. In this chapter, we cover some of the more advanced features of SQL. We address the issue of how to access SQL from a general-purpose programming language, which is very important for building applications that use a database to store and retrieve data.

     83 p tgu 24/02/2024 2 0

  • Lecture Database system concepts (6/e): Chapter 7 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 7 - Silberschatz, Korth, Sudarshan

    Chapter 7 - Entity-relationship model. This chapter provides an overview of the database-design process, with major emphasis on database design using the entity-relationship data model. The entity-relationship data model provides a high-level view of the issues in database design, and of the problems that we encounter in capturing the semantics of realistic applications within the constraints of a data model. UML class-diagram notation is also...

     102 p tgu 24/02/2024 4 0

  • Lecture Database system concepts (6/e): Chapter 6 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 6 - Silberschatz, Korth, Sudarshan

    Chapter 6 - Formal relational query languages. In this chapter, we start by presenting the relational algebra, which forms the basis of the widely used SQL query language. We then cover the tuple relational calculus and the domain relational calculus, which are declarative query languages based on mathematical logic.

     88 p tgu 24/02/2024 4 0

  • Lecture Database system concepts (6/e): Chapter 1 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 1 - Silberschatz, Korth, Sudarshan

    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 1 0

  • Lecture Database system concepts (6/e): Chapter 3 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 3 - Silberschatz, Korth, Sudarshan

    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 2 0

  • Lecture Database system concepts (6/e): Chapter 4 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 4 - Silberschatz, Korth, Sudarshan

    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 4 0

  • Lecture Database system concepts (6/e): Chapter 9 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 9 - Silberschatz, Korth, Sudarshan

    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 2 0

  • Lecture Database system concepts (6/e): Chapter 14 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 14 - Silberschatz, Korth, Sudarshan

    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 1 0

  • Lecture Database system concepts (6/e): Chapter 16 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 16 - Silberschatz, Korth, Sudarshan

    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 2 0

  • Lecture Database system concepts (6/e): Chapter 15 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 15 - Silberschatz, Korth, Sudarshan

    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 1 0

  • Lecture Database system concepts (6/e): Chapter 11 - Silberschatz, Korth, Sudarshan

    Lecture Database system concepts (6/e): Chapter 11 - Silberschatz, Korth, Sudarshan

    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 2 0

Hướng dẫn khai thác thư viện số
getDocumentFilter3 p_strSchoolCode=tgu
getDocumentFilter3 strKey=LIBTAILIEU2_LIST_FILTERtgu241660vi