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 from [...]
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 are [...]
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
Database Engineer - Database/SQL Server Defense Daily Network (subscription) Description & Key Skills Required: The candidate's primary responsibility will be to provide database engineering support to the development and integration ... 29 Jul 2010 at 3:47pm
Software Development Engineer, Community Mashable (blog) Relational Database design and SQL skills are preferred. * Candidates should have experience developing highly scalable web applications and services. ... 29 Jul 2010 at 5:55pm
Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta Average Customer Review: based on 156 reviews. Customer Review: I am not kidding when I say I knew NOTHING about SQL prior to getting this book. Every chapter has been REAL. The information is clean, direct, and the language is level-headed. Ben Forta really targeted the novice and inexperienced SQL user, and he presents each SQL concept in clear usage using a common table across chapters. It's...
SQL For Dummies by Allen G. Taylor Average Customer Review: based on 33 reviews. Customer Review: This was just what I wanted. I was pleased with the service and the book.
Learning SQL by Alan Beaulieu Average Customer Review: based on 33 reviews. Customer Review: The header on the front page of this book says "A Pain-Free Introduction to SQL..." and that's what the book exactly is. The book introduces and discusses SQL statements for DB creation, population, querying - and subquerying -, data generation, conversion and manipulation. The SQL statements are illustrated through practical sound ...