OO Database System Properties (Cont.)


Ad Hoc Queries
Compared with programming languages, ad hoc language such as SQL generally has only limited computational power but a high level of abstraction.

Computational Completeness
Computational completeness simply means that one can express any computable function. Object-oriented systems achieve computational completeness by binding methods to classes, therefore, a link to a programming language can be established.

SQL is not computational completeness.

Version Management
In the course of development, versions of objects are combined to form configurations, which eventually result in products to be manufactured.

Version: One of a sequence of copies of an object, each incorporating new modification.

Extensibility Database and DBMS (DataBase Management System)
Review: Database Management System Properties
    Which statement is NOT true about databases?

      SQL is an ad hoc language.
      SQL is a computationally INCOMPLETE language.
      The secondary storage management of DBMSs uses B-trees commonly.
      Transactions accept intermediate ending states.
        Result:




      “Death is no more than passing from one room into another.    
      But there’s a difference for me, you know.    
      Because in that other room I shall be able to see.”    
      ― Helen Keller