Library Automation and Digital Archive
LONTAR
Fakultas Ilmu Komputer
Universitas Indonesia

Pencarian Sederhana

Find Similar Add to Favorite

Call Number SEM - 359
Collection Type Indeks Artikel prosiding/Sem
Title Multi-vendor interperability through SQL access (hal 414)
Author Scott Newmann;
Publisher Proceedings of the 1992 acm sigmod international conference on management of data san diego,carlifonia june 2-5,1992
Subject
Location
Lokasi : Perpustakaan Fakultas Ilmu Komputer
Nomor Panggil ID Koleksi Status
SEM - 359 TERSEDIA
Tidak ada review pada koleksi ini: 48141
Several years ago, there was no general approach to providing widespread interoperability between databases and database tools from different sources. the interoperability solutions that did exist were primarily achieved through specific, point solutions that provided interoperability between a single pair of vendors. at the time, many companies were faced with the expensive and daunting possibility of creating and supporting a number of these pair-wise solutions. The SQL access group was formed in order to provide common solutions to the multi-vendor interoperability and portability problems. its primary focus is to accelerate existing efforts in official standards bodies, such as ANSI and ISO, by providing input to the standards in order to ensure their viability. The SQL access group is currently working in three areas: the SQL language (API), client-server formats and protocols (FAP), and a dynamic SQL-oriented, procedure call-based interface (CLI). a common definition for the SQL language is essential for application potability and for client-based interoperability, because SQL statements are communicated between client and server. the SQL access embeddeed SQL definition is based on SQL-89 with extensions from SQL2, some of which were originally proposed by SQL access. the specification is published by X/Open in coperation with SQL access. Client-server communication is achieved through the use of formats and protocls that are based on the ISO remote database access (RDA) standard over an OSI network. the SQL acces group was instrumental in providing essential input the RDA standard. the group is also finalizing a mapping of the formats and protocls for TCP/IP networks. The SQL access call-level interface (CLI) is a produce call-based interface that will shortly be published as an X/open "snapshot" specification. it is intended to support the requirements of "shrink-wrapped" software vedors, and others wishing to use an alternative to embedded SQL. SQL access members are currently working towards products that implement one or more of the SQL access standards. digital equipment corporation is expecting to ship a SQL access (FAP) server in the near future. microsoft corporation has recently announced their open database connectivity (ODBC) architecture, that has the SQL access CLI at its core. they expect to ship ODBCin june 1992. additional SQL access-based products are expected from these and other sources in late 1992 and early 1993. the talk will describe the SQL access group and elaborate on the areas in which the group is working. the relationship between the work of the SQL acces group and ISO SQL2 and remote database access (RDA) standards will be explained, as well as their involvement with X/Open. in addition, some parallels with other significant remote database access approach will be illustrated.