ISO/IEC JTC 1/SC34 N0346

ISO/IEC JTC 1/SC34

Information Technology --

Document Description and Processing Languages

TITLE:

JTC 1 / SC 32 Data Management and Interchange Liaison Report to JTC 1/SC 34

SOURCE:

JTC 1/SC 32 Secretariat

PROJECT:

 

PROJECT EDITORS:

 

STATUS:

 

ACTION:

For review and comment

DATE:

12 November 2002

SUMMARY:

 

DISTRIBUTION:

SC34 and Liaisons

REFER TO:

 

SUPERCEDES:

 

REPLY TO:

Dr. James David Mason
(ISO/IEC JTC1/SC34 Chairman)
Y-12 National Security Complex
Information Technology Services
Bldg. 9113 M.S. 8208
Oak Ridge, TN 37831-8208 U.S.A.
Telephone: +1 865 574-6973
Facsimile: +1 865 574-1896
E-mail: mailto:[email protected]
http://www.y12.doe.gov/sgml/sc34/sc34oldhome.htm

Ms. Sara Hafele Desautels, ISO/IEC JTC 1/SC 34 Secretariat
American National Standards Institute
25 West 43rd Street
New York, NY 10036
Tel: +1 212 642-4937
Fax: +1 212 840-2298
E-mail: [email protected]

 

ISO/IEC JTC 1/SC 32 Data Management and Interchange

SC 32 PERIOD REVIEW

Excellent progress has been made in developing SQL, SQL MM, RDA, Open-Edi, Metadata Registry standards, and we expect that progress to continue in the future. Excellent progress has been made in developing SQL. The remaining parts of the SQL:1999 standards have been completed. An aggressive schedule for the next complete revision of ISO/IEC 9075 has been set with a target end date of 1st quarter 2003.

The ISO/IEC 15944 standards have been approved to be freely available. This includes:

Information technology - Business Agreement Semantic Descriptive Techniques Part 1: Business Operational Aspects of Open-edi for Implementation

Information technology - Business Agreement Semantic Descriptive Techniques Part 2: Registration of Scenarios and their Components

And two additional parts.

JTC 1 has approved the ISO/IEC 11179 Metadata Registry family of standards to be freely available. These await ISO and IEC approval.

 

SC 32 MARKET REQUIREMENTS

Market requirements for SC 32 standards are driven by the rapid pace of hardware and software advancement as well as by the explosive growth of Internet/Intranet/Extranet applications. These drive a stream of market requirements that are addressed by SC 32 standards for data management and interchange, including metadata management. The data management market continues to grow rapidly in line with the geometric increase in the volume of data stored and served.

An SC 32 study period has found an increasing market demand for semantics management. This is needed for data in databases, EDI messages, text in documents (which may be stored in databases), etc. While there are several ISO standards for various terminology content and structure, there is little connection between those standards and their potential use for data management and interchange. SC 32 is exploring the market requirements for semantics management and the existing standards in order to articulate and then fill the unmet need.

Users are driving the market demand for metadata registries that describe the structure and meaning data. Major organizations are implementing metadata registries according to SC 32 standards and in the process are creating demand for extensions and broader coverage. This work is especially driven by the public access requirements of users and by market forces requiring the capability to share metadata between organizations.

The market demand for SQL database products remains strong. The clear acceptance of the new SQL:1999 standards by the database vendors is very encouraging. The development of new parts and new features within the 9075 family of standards continues to be driven by perceived market priorities; the effort applied and the scheduling of the various parts has been adjusted accordingly.

Market demand of EDI and electronic commerce products grows as firms struggle to move into the electronic marketplace. Standards for EDI functions are necessary to facilitate this demand. The SC 32 work related to Open edi work and metadata registries is supporting JTC 1 involvement with the ISO IEC UN/ECE MoU Management Group.

Each part of SQL/MM standards is based on explicit requirements from a domain market. Especially, SQL/MM Part 2: Spatial specifying Spatial Data Management received much attention from TC 204, TC 211, and OGC (Open GIS Consortium) and is being developed under close coordination with TC 211 and OGC. Thus, we believe that our standards meet real market requirements.

SC 32 ACHIEVEMENTS

The following projects have completed or are in Stage 5 - Publication

 

The following projects are completing Stage 4 - Approval Stage by being submitted to ITTF for final vote.

1.32.04.01.06.00 ISO/IEC FDIS 13249-6 - Information technology - Database languages - SQL Multimedia and Application Packages - Part 6: Data Mining

1.32.04.02.01.00 ISO/IEC FDIS 13249-1 - Information technology - SQL Multimedia and Application Packages - Part 1: Framework 2nd ed.

1.32.15.02.03.00 ISO/IEC FDIS 11179-3 - Information technology -- Metadata Registries (MDR) - Part 3, Registry Metamodel and basic attributes

1.32.31.01.01.00 ISO/IEC FDIS 15944-1 Information technology - Business Agreement Semantic Descriptive Techniques Part 1: Business Operational Aspects of Open-edi for Implementation

 

The following project completed Stage 3 - Committee Stage with FCD ballot

1.32.04.01.06.00 ISO/IEC FCD 13249-6 Information technology - Database languages - SQL Multimedia and Application Packages - Part 6: Data Mining

1.32.04.02.01.00 ISO/IEC FCD 13249-1 Information technology - SQL Multimedia and Application Packages - Part 1: Framework 2nd ed.

1.32.10.02.00.00 ISO/IEC FCD 5218 Information technology - Codes for the representation of human sexes (Revision of ISO 5218:1977)

1.32.15.02.03.00 ISO/IEC FCD 11179-3 Information technology -- Data Management and Interchange -- Metadata Registries (MDR) - Part 3, Registry Metamodel (MDR3) (Revision of ISO/IEC 11179-3:1994)

1.32.16.01.00.00 ISO/IEC FPDTR 20943-1Information technology - Achieving Metadata Registry Content Consistency - Part 1: Data elements

 

 

The following project progressing Stage 3 - Committee Stage with FCD ballot

1.32.03.05.01.00 ISO/IEC FCD 9075-1 Information technology - Database Languages - SQL - Part 1: Framework (SQL/Framework)

1.32.03.05.02.00 ISO/IEC FCD 9075-2 Information technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation)

1.32.03.05.03.00 ISO/IEC FCD 9075-3 Information technology - Database Languages - SQL - Part 3: Call-Level Interface (SQL/CLI)

1.32.03.05.04.00 ISO/IEC FCD 9075-4 Information technology - Database Languages - SQL - Part 4: Persistent Stored Modules (SQL/PSM)

1.32.03.05.09.00 ISO/IEC FCD 9075-9 Information technology - Database Languages - SQL - Part 9: Management of External Data (SQL/MED)

1.32.03.05.10.00 ISO/IEC FCD 9075-10 Information technology --Database Languages - SQL - Part 10: Object language bindings (SQL/OLB)

1.32.03.05.11.00 ISO/IEC FCD 9075-11 Information technology --Database Languages - SQL - Part 11: Information and Definition Schemas (SQL/Schemata)

1.32.03.05.13.00 ISO/IEC FCD 9075-13 Information technology --Database Languages - SQL - Part 13: SQL/JRT (for SQL:200n)

1.32.03.05.14.00 ISO/IEC FCD 9075-14 Information technology --Database Languages - SQL - Part 14: SQL/XML (for SQL:200n)

1.32.04.02.02.00 ISO/IEC FCD 13249-2 Information technology - SQL Multimedia and Application Packages - Part 2: Full-Text (Revision of ISO/IEC DIS 13249-2)

1.32.04.02.03.00 ISO/IEC FCD 13249-3 Information technology - SQL Multimedia and Application Packages - Part 3: Spatial 2nd Edition

1.32.04.02.05.00 ISO/IEC FCD 13249-5 Information technology - SQL Multimedia and Application Packages - Part 5: Still Image 2nd

 

 

The following project is progressing in Stage 3 - Committee Stage

1.32.15.02.04.00 ISO/IEC CD 11179-4 Information Technology -- Data Management and Interchange -- Metadata Registries (MDR) - Part 4: Rules and guidelines for the formulation of data definitions (Revision of ISO/IEC 11179-4:1995)

1.32.15.02.05.00 ISO/IEC CD 11179-5 Information Technology -- Data Management and Interchange -- Metadata Registries (MDR) - Part 5: Naming and identification principles for administered items (Revision of ISO/IEC 11179-5:1995)

1.32.16.01.03.00 ISO/IEC PDTR 20943-3 Information technology - Achieving Metadata Registry Content Consistency - Part 3: Value Domains

 

 

 

SC 32 FOCUS NEXT WORK PERIOD

SC 32 has refined its program of work to ensure that it is focusing on those standards that will meet market requirements. SC 32 plans to continue to focus on developing standards for SQL, SQL/MM, Open edi and data semantics. SQL work is expected to be particularly active. The metadata registry market is becoming more active with implementations of ISO/IEC 11179.

 

Database Languages (WG 3) work is active with the focus on a completely revised set of ISO/IEC 9075 parts as well as two new parts addressing more Java support and XML support. WG 3 has assumed some of the projects from the former WG 5.

 

The Open-Edi (WG 1) is concentrating on on is the second part of ISO/IEC 15944: Information technology - Business Agreement Semantic Descriptive Techniques Part 2: Registration of Scenarios and their Components, and the fourth part of ISO/IEC 15944: Information technology - Business Agreement Semantic Descriptive Techniques Part 4: Business Transactions and Scenarios - Accounting and Economic Ontologyand ISO/IEC 18038 Identification, mapping and IT-enablement of existing standards for widely used encodable value domains. A key characteristic of commerce world-wide is that it makes extensive use of enumerated lists, code sets, etc. representing possible choices of common aspects in business transactions. The problem is that most of these code sets in use world-wide are paper-based and, even if available in electronic form, lack a computer-processable version. The objective of this standardization work is (1) the development of a tool to facilitate the creation of IT-enabled versions of existing sets of "codes representing X", and (2) to do so, in a manner which will support localization and multilingual requirements of the marketplace.

 

The Metadata Working Group (WG 2) is progressing the metadata registries with revisions to the ISO/IEC 11179 family of metadata registry standards. Part 3 of ISO/IEC 11179 was revised to incorporate a structure of a metadata registry and is now at ITTF for FDIS ballot. Technical reports on metadata registry content are progressing. The content TR addresses the exchange of metadata among ISO/IEC 11179-based registries that depends not only on standard-conforming software, but also on contents that are compatible across registries. The goal of this project is to produce Technical Reports that will promote a common understanding of the content of metadata registry data elements so that they can be shared among registries. The intent is to provide guidance by example in registering data elements. WG 2 intends to recommend using XML for accessing and interchanging information in 11179 conformant data registries. We expect that specific XML tags and data structures will be algorithmically derived from the normative UML data model specified in 11179 part 3. The Object Management Group (OMG) has already adopted a standard for XMI (XML Model Interchange), which we expect to recommend as one mechanism for such algorithmic derivation of XML representation from UML models. Work is also underway to foster interoperation between ISO/IEC 11179 metadata registries, XML registries, Universal Description, Discovery and Integration (UDDI) registries, database catalogs, ontology registries and CASE tool repositories. The SC 32 work is positioned to meet the deeper semantic management aspects of data management and interchange.

 

SC 32 OPPORTUNITIES

The Internet, electronic commerce, semantics management, object technologies, and XML represent major areas of opportunity where market forces are creating demand for SC 32 standards. We will continue to work with the others involved to identify the specific standardization needs and to respond with current and newly proposed standards.

XML represents a major area of opportunity where market forces are creating demand for standards and SC 32 is continually monitoring the work in this area and will react as soon as it sees and appropriate opportunity.