[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

457.0. ""Open SQL"" by SNOC02::PHILLIPSB (Blair Phillips - sws Canberra) Sat Oct 14 1989 15:31

    One of the local computer comics has a story on something called 
    "Open SQL".
    
    The lead paragraph says:
    
    	SAN FRANCISCO - Users could take a giant leap forward in solving
    	their SQL database interoperability woes if a new stabdards group,
        tentatively called "Open SQL", can meet its goal of producing a
        common SQL application interface (API) by early next year, followed
        by a reference model in late 1990.
    
    The rest of the article gets increasingly incoherent, and it is not at
    all clear whether the proposed standard is for an API or for an
    interoperability interface between databases, or both. (Actually, I
    think that the SQL Module Language makes an adequate API, so I don't
    see the need for another.)
    
    The article says that the initial membership consists of Tandem,
    Informix, RTI, Digital, Hewlett-Packard, NCR, Sun and Teradata.
    
    Can anyone shed some light on this group? In particular, what
    interfaces is it aiming to standardize?
    
    	Blair
    (Posted in Ultrix/SQL and Rdb_VMS_Competition)
     
T.RTitleUserPersonal
Name
DateLines
457.1SQL AccessPOOR::BALBONIMon Oct 16 1989 18:1638
This story was leaked to the press by some of our friends at "RTI". The other
20 plus members of the group have agreed to be silent about this until our
formal press announcement next week. The Computer World story has lots of wrong
information in it.

Here are some facts about the group:

The group was started by Digital and Tandem earlier this year and today has
grown to over 20 plus members. 

The name of the consortium was changed to SQL Access. RTI after joining the
group renamed their Common SQL Architecture to Open SQL and trademarked the
name.

The consortium will define and implement a set of specifications based on the
existing SQL standard and RDA standard. These specifications when incorporated 
in database and application programs, will help achieve true interoperability by
allowing users to work across different database systems.

The consortium will publish a technical specification, which will include a
standard (API) application programming specification as well as a Formats and
Protocols Specification (FAP).

ISO/SQL defines a syntax to access SQL data. The syntax (API) gives
source-level portability among SQL systems. ISO/SQL does not provide syntax to
access remote SQL data or servers. SQL Access defines some syntactic extensions
to ISO/SQL which will allow the application to name and access remote data on
servers. The language chosen by the group for the API will be ANSI SQL2 
Dynamic SQL (Level 3).

The FAP defines message and formats for SQL Access requests and replies as well
for connection to an SQL Server. Data types, lengths, and representation are
also defined by the FAP. The formats for data streams that flow between a
client and a server are also defined. 

Jeff Balboni
SQL Access Technical Chair
    
457.2The penny drops...UBEAUT::CLEARYA deviant having fun..."Thu Oct 26 1989 13:068
    I guess this explains why Sybase have suddenly renamed their server to
    Open Server and their client to Open Client.
    
    Do you know if SQL services in Rdb uses RDA ?  The local defence dept
    is real big on OSI standards and have been asking about our support for
    all these wierd standards most of us have never heard of.
    
    -mark
457.3NoCLYPPR::BOOTHWhat am I?...An Oracle?Thu Oct 26 1989 14:433
    No, RDA isn'tthat close to being a standard yet.
    
    ---- MIchael Booth
457.4Based on early standards activity, partiallyCOOKIE::BERENSONI'm the NRAFri Oct 27 1989 01:431
Well, yes sort of.  Ask for details in the SQL SERVICES conference.