A Detailed Report on SQL Standards: Framework and Evolution

This report delves into the realm of SQL (Structured Query Language) standards, essential for Database Administrators (DBAs) in managing and accessing databases. It traces the evolution of SQL, highlighting the significant contributions of the American Standards Institute (ANSI) in establishing query language standards, beginning in 1986. The report outlines the nine parts of the SQL standard, including the SQL Framework, SQL Foundation, Call-Level Interface, procedural extensions, external data management, object language binding (SQLJ), schemata definition, SQL routines using Java, and XML-related specifications. It emphasizes the impact of these standards on SQL databases, particularly the integration of XML and Java programming language. References to relevant research articles are provided to support the analysis.

Running head: SQL STANDARDS
SQL Standards
Name of the Student
Name of the University
Author Note

1SQL STANDARDS
The structured query language or the SQL is the language of the DBA (Database
Administrator) for managing and accessing the databases. In the recent years the SQL has
developed a lot. Many version of the SQL has emerged in the time period. The American
Standards Institute or the ANSI created several standards for the query languages of the
database. The first standard was given by the ANSI is in the year 1986 and from that it is
continuously developing. The total SQL standards is divided into 9 parts (Foster and Godbole
2016).
Part 1: ISO / IEC 9075 - 1:2011 this SQL Framework offers the concepts that
are logical.
Part 2: ISO / IEC 9075 - 2: 2011 this SQL Foundation includes the central elements of
the SQL.
Part 3: ISO / IEC 9075 - 3: 2008 SQL of this Call-Level Interface explains the
interfacing components like the structures, procedures and the variables used binding the
executing SQL. Like the C++ language.
Part 4: ISO / IEC 9075 - 4: 2011 this standards outlines the standards for the SQL’s
procedural extensions. It also has the flow control and the condition handling. It also assign
expressions to parameter and variables.
Part 9: ISO / IEC 9075 - 9: 2008 SQL of the Management of external data which
includes the extensions to the SQL which defines the types of the data links and the foreign
data wrappers which enables manage data for the SQL (Masunaga, Nagata and Ishii 2018).
The data that is external is accessed but cannot be managed by the DBMS which is SQL
based.

2SQL STANDARDS
Part 10: ISO / IEC 9075 - 10: 2008 it is SQL or Object language binding that defines
the syntax and the semantics of SQLJ. The SQLJ embedded the java into the SQL. That
defines the java packets that contains the classes.
Part 11: ISO / IEC 9075 - 11: 2011 this SQL or Information and the schemata
definition, that determines the definition of the schema and the information of the schema and
it offers tools for making the objects of the SQL and the self-describing database. It also
includes the identifier of the SQL object, authorization and security specifications, and the
integrity constraints too. It supports the features of the package of the ISO/IEC 9075, and also
the features which is provided by the DBMS implementations that are SQL based (Dudakov
2015).
Part 13: ISO / IEC 9075 - 13: 2008 it makes the SQL routines and the types of the
SQL using the java programming language. It has the capacity as the java classes are utilized
as the SQL structured types of the user defined.
Part 14: ISO / IEC 9075 - 14: 2011 it is the XML related specifications which defines
the SQL based extensions when the XML is used with the SQL. This standard also describes
the SQL from XML data type from the storage mapping and also manages the XML into the
database of the SQL (Schweinsberg and Wegner 2017).
In the recent time the SQL standards are gone through several changes and all the
changes affected the SQL database. The most important changes among them is the
implementation of the XML in the SQL database and the use of the Java Programming
Language in the data base of the SQL.

3SQL STANDARDS
References:
Dudakov, S.M., 2015. On inflationary fix-point operators safety. Lobachevskii Journal of
Mathematics, 36(4), pp.328-331.
Foster, E.C. and Godbole, S., 2016. Overview of SQL. In Database Systems (pp. 205-209). Apress,
Berkeley, CA.
Masunaga, Y., Nagata, Y. and Ishii, T., 2018, January. Extending the View Updatability of Relational
Databases from Set Semantics to Bag Semantics and Its Implementation on PostgreSQL.
In Proceedings of the 12th International Conference on Ubiquitous Information Management and
Communication (p. 19). ACM.
Schweinsberg, K. and Wegner, L., 2017. Advantages of complex SQL types in storing XML
documents. Future Generation Computer Systems, 68, pp.500-507.