Monday, October 26, 2020
dbametrix
More
    Home Technology SQL a History

    SQL a History

    Called Structure Query Language or Sequel Query Language.

    First developed by Andrew Richardson, Donald C. Messerly and Raymond F. Boyce Of IBM in the 1970.

    - Advertisement -
    dbametrix

    SQL has been an official standard, promulgated by the International Institute of Standardization (ISO) and its American Affiliate, the American National Standard Institute (ANSI) since 1986.

    There were lot of version of SQL introduced like SQL86, SQL89, SQL92 and SQL99.

    Following are standard sub-components of SQL99.

    SQL Framework

    - Advertisement -
    dbametrix

    Provides logical concept

    SQL Foundation

    Builds on the material in Framework and specifies, for the more fundamental parts of the standard,the actual nuts and bolts of the language.

    SQL/CLI (Call-level interface)

    Specifies a standard API (Application Programming Interface) through which
    SQL operations can be called.

    SQL/PSM (Persistent Stored Modules)

    Refers to procedural extensions to SQL that make it computationally complete and therefore suitable for the development of full applications.

    SQL/Bindings

    Specifies how SQL is to be bound to variable host languages,excluding Java.

    SQL/MM (Multimedia)

    This extends SQL to deal intelligently with large,complex and sometimes streaming items of data, such as video,audio and spatial data.

    SQL/OLB (Object Languege Bindings)

    Part 0 (as they call it) of the SQLJ specification for embedding SQL in Java.

    In short SQL was developed by IBM in 1970. First commercial used by Oracle. And day by day all DBMS and RDBMS are following to use this language for Backend interaction.

    Thanks and regards,

    Gitesh Trivedi.

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments