You get a bonus - 1 coin for daily activity. Now you have 1 coin

Lecture 17. Some features of SQL / 92 and SQL-3

Lecture



We will not even superficially describe the new features of the SQL language in the SQL / 92 standard. This is not very meaningful now, because the only available implementation of SQL / 92 is the expensive version of Oracle V.7. However, it seems useful to include in our guide a summary of dynamic SQL statements with few comments, since SQL / 92 made the first attempt to standardize this part of the SQL language, and this description can be used at least as a reference when comparing different implementations. At the end of the lecture is a brief summary of the new features expected in the new SQL-3 standard, which is still being worked on.
created: 2014-09-27
updated: 2026-03-09
351

Was this answer useful?
Choose a quick rating so we can improve the next answer for you.
How satisfied are you?

Comments

To leave a comment

If you have any suggestion, idea, thanks or comment, feel free to write. We really value feedback and are glad to hear your opinion.
To reply

Lectures and tutorial on "Databases IBM System R - relational DBMS"

Terms: Databases IBM System R - relational DBMS

The Basics of Modern Databases Preface
Lecture 1. Databases and file systems
1.1. File systems
1.2. File scopes
1.3. Information System Needs
Lecture 2. DBMS Functions. Typical organization DBMS. Examples
2.2. Typical organization of modern DBMS
2.3. Example: System R
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
3.1. Main features of systems based on inverted lists
3.2. Hierarchical systems
3.3. Network systems
3.4. Advantages and disadvantages
Theoretical foundations of relational databases and relational database management systems
Lecture 4. General concepts of the relational approach to database organization. Basic concepts and terms
4.1. Basic concepts of relational databases
4.2. Fundamental properties of relationships
4.3. Relational data model
Lecture 5. Basic means of manipulating relational data
5.1. Relational algebra
5.2. Relational calculus
Lecture 6. Designing relational databases
6.1. Designing relational databases using normalization
6.2. Semantic data modeling, ER charts
Two classic experimental systems
7.1. Terminology used
7.2. The main objectives of System R and their connection to the system architecture
7.3. Organization of external memory in System R databases
7.4. RSS interface
7.5. Synchronization in System R
7.6. Logging and Recovery in System R
Lecture 8. Ingres: general organization of the system, Quel language basics
8.2. Ingres as a UNIX-oriented DBMS. Dynamic system structure: a set of processes
8.3. Data structures, access methods, data access interfaces
8.4. General characteristics of the language QUEL. EQUEL programming language
8.5. General approach to the organization of representations, integrity constraints and access control
Internal organization of relational DBMS Lecture 9. External memory structures, index organization methods
9.1. Relationship storage
9.2. Indices
9.3. Journal information
9.4. Service information
Lecture 10. Transaction Management, Transaction Serialization
10.1. Transactions and Database Integrity
10.2. User isolation
10.3. Transaction serialization
Lecture 11. Transaction Serialization Methods
11.1. Synchronization captures
11.2. Timestamp method
Lecture 12. Journaling DB Changes
12.1. Logging and buffering
12.2. Individual transaction rollback
12.3. Recovery after a mild failure
12.4. Physical database consistency
12.5. Hard Failure Recovery
Relational database language SQL Lecture 13. SQL language. Functions and main features
13.2. SQL language in commercial implementations
13.3. SQL standardization
Lecture 14. SQL Standard Database Language 14.1. Data types
14.2. Schema Definition Tools
Lecture 15. The SQL language. Means of data manipulation
15.2. Table expression
15.3. Aggregate functions and query results
Lecture 16. The use of SQL in application programming 16.1. Module language or embedded SQL?
16.2. Module Language
16.3. Embedded SQL
16.4. A set of operators to manipulate data Cursor, fetch, delete and update. example cursor for mysql
16.5. Dynamic SQL in Oracle V.6
Lecture 17. Some features of SQL / 92 and SQL-3
17.1. Descriptor memory allocator
17.2. Memory freeing operator
17.3. Operator get information from the SQL descriptor area
17.4. Descriptor Setup Operator
17.5. Training operator
17.6. Operator rejection of the prepared operator
17.7. Operator request query description of the prepared operator
17.8. Operator perform the prepared statement
17.9. Immediate preparation operator
17.10. Cursor declaration operator over a dynamically prepared select statement
17.11. Cursor definition operator over dynamically prepared select statement
17.12. The operator to open a cursor associated with a dynamically prepared sample statement
17.13. The operator of reading the line on the cursor associated with a dynamically prepared sample statement
17.14. The cursor closing operator associated with a dynamically prepared sample statement
17.15. The positional delete operator on the cursor associated with a dynamically prepared sample operator
17.16. The operator of the positional modification of the cursor associated with a dynamically prepared sample operator
17.17. Prepared Positional Delete Operator
17.18. Prepared positional modification operator
17.19. Summary of SQL-3 features
Compilers of SQL language Lecture 18. Compilers SQL. Optimization problems
18.1. General request processing
18.2. Syntax query optimization
18.3. Semantic query optimization
18.4. Selection and evaluation of alternative query plans
DBMS in the architecture of "client-server" Lecture 19. Architecture "client-server"
19.1. Open systems
19.2. Clients and servers of local networks
19.3. Client-server system architecture
19.4. Database servers
Distributed databases Lecture 20. Distributed databases
20.1. Varieties of distributed systems
20.2. System R * Distributed Database Management System
20.3. Integrated or federated systems and multi-databases
Current research and development directions
Lecture 21. Next generation database management systems
21.1. Orientation to Extended Relational Model
21.2. Abstract data types
21.3. Generation of application-oriented database systems
21.4. Rule-based query optimization
21.5. Support for historical information and temporal queries
Lecture 22. Object-oriented DBMS
22.1. The connection of object-oriented DBMS with the general concepts of object-oriented approach
22.2. Object Oriented Data Models
22.3. Object-Oriented Database Programming Languages
22.4. Object Oriented Database Query Languages
22.5. Examples of object-oriented DBMS
Lecture 23. Rule-based database systems.
23.1. Extensional and intensional parts of the database
23.2. Active databases
23.3. Deductive databases