Databases ibm system r - relational dbms

All lectures: All lectures on the discipline: databases ibm system r - relational dbms are collected here. These fascinating lectures provide us with the opportunity to explore the deep principles and phenomena underlying our knowledge and our desire to understand the world.


1. The Basics of Modern Databases Preface
2. Lecture 1. Databases and file systems
3. 1.1. File systems
4. 1.2. File scopes
5. 1.3. Information System Needs
6. Lecture 2. DBMS Functions. Typical organization DBMS. Examples
7. 2.2. Typical organization of modern DBMS
8. 2.3. Example: System R
9. Lecture 3. Early approaches to the organization of the database. Systems based on inverted lists, hierarchical and network DBMS. Examples Strengths and weaknesses of early systems
10. 3.1. Main features of systems based on inverted lists
11. 3.2. Hierarchical systems
12. 3.3. Network systems
13. 3.4. Advantages and disadvantages
14. Theoretical foundations of relational databases and relational database management systems
15. Lecture 4. General concepts of the relational approach to database organization. Basic concepts and terms
16. 4.1. Basic concepts of relational databases
17. 4.2. Fundamental properties of relationships
18. 4.3. Relational data model
19. Lecture 5. Basic means of manipulating relational data
20. 5.1. Relational algebra
21. 5.2. Relational calculus
22. Lecture 6. Designing relational databases
23. 6.1. Designing relational databases using normalization
24. 6.2. Semantic data modeling, ER charts
25. Two classic experimental systems
26. 7.1. Terminology used
27. 7.2. The main objectives of System R and their connection to the system architecture
28. 7.3. Organization of external memory in System R databases
29. 7.4. RSS interface
30. 7.5. Synchronization in System R
31. 7.6. Logging and Recovery in System R
32. Lecture 8. Ingres: general organization of the system, Quel language basics
33. 8.2. Ingres as a UNIX-oriented DBMS. Dynamic system structure: a set of processes
34. 8.3. Data structures, access methods, data access interfaces
35. 8.4. General characteristics of the language QUEL. EQUEL programming language
36. 8.5. General approach to the organization of representations, integrity constraints and access control
37. Internal organization of relational DBMS Lecture 9. External memory structures, index organization methods
38. 9.1. Relationship storage
39. 9.2. Indices
40. 9.3. Journal information
41. 9.4. Service information
42. Lecture 10. Transaction Management, Transaction Serialization
43. 10.1. Transactions and Database Integrity
44. 10.2. User isolation
45. 10.3. Transaction serialization
46. Lecture 11. Transaction Serialization Methods
47. 11.1. Synchronization captures
48. 11.2. Timestamp method
49. Lecture 12. Journaling DB Changes
50. 12.1. Logging and buffering
51. 12.2. Individual transaction rollback
52. 12.3. Recovery after a mild failure
53. 12.4. Physical database consistency
54. 12.5. Hard Failure Recovery
55. Relational database language SQL Lecture 13. SQL language. Functions and main features
56. 13.2. SQL language in commercial implementations
57. 13.3. SQL standardization
58. Lecture 14. SQL Standard Database Language 14.1. Data types
59. 14.2. Schema Definition Tools
60. Lecture 15. The SQL language. Means of data manipulation
61. 15.2. Table expression
62. 15.3. Aggregate functions and query results
63. Lecture 16. The use of SQL in application programming 16.1. Module language or embedded SQL?
64. 16.2. Module Language
65. 16.3. Embedded SQL
66. 16.4. A set of operators to manipulate data Cursor, fetch, delete and update. example cursor for mysql
67. 16.5. Dynamic SQL in Oracle V.6
68. Lecture 17. Some features of SQL / 92 and SQL-3
69. 17.1. Descriptor memory allocator
70. 17.2. Memory freeing operator
71. 17.3. Operator get information from the SQL descriptor area
72. 17.4. Descriptor Setup Operator
73. 17.5. Training operator
74. 17.6. Operator rejection of the prepared operator
75. 17.7. Operator request query description of the prepared operator
76. 17.8. Operator perform the prepared statement
77. 17.9. Immediate preparation operator
78. 17.10. Cursor declaration operator over a dynamically prepared select statement
79. 17.11. Cursor definition operator over dynamically prepared select statement
80. 17.12. The operator to open a cursor associated with a dynamically prepared sample statement
81. 17.13. The operator of reading the line on the cursor associated with a dynamically prepared sample statement
82. 17.14. The cursor closing operator associated with a dynamically prepared sample statement
83. 17.15. The positional delete operator on the cursor associated with a dynamically prepared sample operator
84. 17.16. The operator of the positional modification of the cursor associated with a dynamically prepared sample operator
85. 17.17. Prepared Positional Delete Operator
86. 17.18. Prepared positional modification operator
87. 17.19. Summary of SQL-3 features
88. Compilers of SQL language Lecture 18. Compilers SQL. Optimization problems
89. 18.1. General request processing
90. 18.2. Syntax query optimization
91. 18.3. Semantic query optimization
92. 18.4. Selection and evaluation of alternative query plans
93. DBMS in the architecture of "client-server" Lecture 19. Architecture "client-server"
94. 19.1. Open systems
95. 19.2. Clients and servers of local networks
96. 19.3. Client-server system architecture
97. 19.4. Database servers
98. Distributed databases Lecture 20. Distributed databases
99. 20.1. Varieties of distributed systems
100. 20.2. System R * Distributed Database Management System
101. 20.3. Integrated or federated systems and multi-databases
102. Current research and development directions
103. Lecture 21. Next generation database management systems
104. 21.1. Orientation to Extended Relational Model
105. 21.2. Abstract data types
106. 21.3. Generation of application-oriented database systems
107. 21.4. Rule-based query optimization
108. 21.5. Support for historical information and temporal queries
109. Lecture 22. Object-oriented DBMS
110. 22.1. The connection of object-oriented DBMS with the general concepts of object-oriented approach
111. 22.2. Object Oriented Data Models
112. 22.3. Object-Oriented Database Programming Languages
113. 22.4. Object Oriented Database Query Languages
114. 22.5. Examples of object-oriented DBMS
115. Lecture 23. Rule-based database systems.
116. 23.1. Extensional and intensional parts of the database
117. 23.2. Active databases
118. 23.3. Deductive databases