You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria [...]
November 18, 2008
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
SQL-92 was developed by the INCITS Technical Committee H2 on Database.
This committee develops standards for the syntax and semantics of database languages.
SQL-92 was designed to be a standard for relational database management systems (RDBMSs).
It is based
SQL-89, which in turn was based on SQL-86. SQL-92 was developed by the ANSI
(then NCITS, and now INCITS) X3H2 committee, which originally began work on a SQL standard in 1982.
SQL-92 does not address objects in any way. Nevertheless, SQL-92 forms the
basis for JDBC, SQLJ, SQL:1999, and ODMG OQL. Each of these specifications are
covered in other parts of this section. See the related content below.
SQL is a database sublanguage that is used for accessing relational
databases. The letters don't stand for anything¹. A database sublanguage is one
that is used in association with some other language for the purpose of
accessing a database. This results in a programming style illustrated by the
embedded SQL statements in the
following diagram.
An example of an embedded SQL statement that creates a new Person instance
would be:
EXEC SQL BEGIN DECLARE SECTION;
char SQLSTATE[6];
char ssan[9];
char name[30];
EXEC SQL END DECLARE SECTION
EXEC SQL
INSERT INTO person VALUES (:ssan, :name);
This code would be in addition to any host programming code. The variables :ssan
and :name would need to be set by the host program using the host programming
language before execution. If you also wanted to manipulate this new Person
instance in the host program, you would need programming code in
addition to this code fragment that populates the instance in the programming
language along with the instance in the database.
¹ According to Jim Melton, the editor of the SQL standard, the
proper pronunciation is "ess cue ell," and not "sequel" as
is commonly heard. Jim also says that SQL stands for "SQL Query
Language" and notes that this is a recursive acronym. In some early prototypes, SQL stood for "Structured
Query Language." That is not true for the standard.
There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.
Search this site for more articles
Custom Search
Browse this site for more articles
Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current
article: SQL-92.
Related recent articles from Google News
Retrieve SQL data effectively with Kernel for SQL Database openPR (press release) (openPR) - Kernel for SQL Database recovery tool is an impeccable utility that allows the users to repair corrupted or inaccessible MDF files thus recovering data from corrupted SQL database. This tool has the perfect package of various outstanding ... 2 Feb 2012 at 11:51pm
SQL Server 2012 Integration Services - Overview Database Journal Assuming that all prerequisites are satisfied, on the Setup Role page of the SQL Server 2012 RC0 Setup wizard, you have the option to select either All Features with Defaults (which includes SQL Server Database Engine Services, Analysis Services, ... and more » 3 Feb 2012 at 2:07am
Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners (SQL Exam Prep Series 70-433 Volume 1 of 5) (Sql Design Series) by Rick A. Morelan, Doug Fritz, Jessica Brown, Peter Kendall Description: Several years ago a challenge was given to technology instructor Rick A. Morelan. Take downsized workers with little or no experience with computers or technology and turn them into industry certified technology experts. The proven material from this venture is now available to you as the Joes 2 Pros series of books and videos. This new approach has vivid pictures on almost every p...
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta Description: Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all ma...
Learning SQL by Alan Beaulieu Description: Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each ...
