SQL3 Support for CALS Applications

摘要

Previous reports to CALS have identified the importance of Database Language SQLin CALS Phase II requirements. In particular, a July 1989 point paper on SQL and RDA identified features in the existing SQL standard and its near-term SQL2 replacement that are most appropriate to CALS data management concerns. The report focuses on SQL3, a follow-on standardization project for major new SQL enhancements that is expected to be adopted by American National Standards Institute (ANSI), International Organization for Standardization (ISO), and as a Federal Information Processing Standard (FIPS) in the mid 1990's. Many of the proposed SQL3 features are of particular importance to the Standard for the Exchange of Product model data (STEP) because of that standard's unique data modeling and data access requirements. Existing and planned features in SQL3 may not satisfy all STEP requirements, but they should provide an appropriate base from which many requirements can be suitably addressed. Since features in SQL3 are just now being specified, they are open to modification and improvement to best suit CALS needs. The report identifies the major enhancements under consideration by the ANSI and ISO SQL standardization committees and relates them to known manufacturing and product management requirements. It also discusses the status of these features in the SQL3 specification and indicates opportunities available to CALS to influence further development.