Sql mm part 8 metadata registry mdr
Download
1 / 32

SQL/MM Part 8: Metadata Registry (MDR) - PowerPoint PPT Presentation


  • 126 Views
  • Uploaded on

32N1893. SQL/MM Part 8: Metadata Registry (MDR). Working Group 4 – SQL Multimedia & Application Packages. ISO/IEC JTC 1/SC 32 Plenary Jeju, Korea, June 22, 2009 Dongwon Jeong Dept. of Informatics & Statistics, Kunsan National Univ.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL/MM Part 8: Metadata Registry (MDR)' - elysia


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sql mm part 8 metadata registry mdr

32N1893

SQL/MM Part 8: Metadata Registry (MDR)

Working Group 4 – SQL Multimedia & Application Packages

ISO/IEC JTC 1/SC 32 Plenary

Jeju, Korea, June 22, 2009

Dongwon Jeong

Dept. of Informatics & Statistics, Kunsan National Univ.

[email protected] | [email protected]; http://ist.kunsan.ac.kr/


Contents
Contents

Background

Motivation

Introduction to SQL/MM MDR

Concluding Remark

Q/A

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Background motivation introduction to sql mm mdr concluding remark

Background

Motivation

Introduction to SQL/MM MDR

Concluding Remark


Metadata
Metadata

  • For ISO/IEC 11179,

    • metadata is defined to be data that defines and describes other data.

    • This means that metadata are data, and data become metadata when they are used in this way.

    • The set of circumstances, purposes, or perspectives for which some data are used as metadata is called the context.

    • So, metadata are data about data in some context.

DATA

METADATA

  • Name: personName

  • Definition: a name to identify human

  • Data type: String

  • Max size: 20

  • Min size: 10

  • . . . . . .

Dongwon Jeong

personName

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Purposes of iso iec 11179 metadata registry
Purposes of ISO/IEC 11179 – Metadata Registry

  • The purposes of ISO/IEC 11179 – Metadata Registry are to promote the following:

    • Standard description of data

    • Common understanding of data across organizational elements and between organizations

    • Re-use and standardization of data over time, space, and applications

    • Harmonization and standardization of data within an organization and across organizations

    • Management of the components of data

    • Re-use of the components of data

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


High level metamodel of iso iec 11179
High-level metamodel of ISO/IEC 11179

  • High-level overview of the central regions of the metamodel

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


High level metamodel of iso iec 11179 example

Country name

Countries

Country name code

ISO 3166 3-Alpha Code

High-level metamodel of ISO/IEC 11179: Example

  • High-level overview of the central regions of the metamodel

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Mdr implementations
MDR Implementations

There are various MDR Implementations

Ref.: http://metadata-standards.org/MDR_implementations.html

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Background motivation introduction to sql mm mdr concluding remarks

Background

Motivation

Introduction to SQL/MM MDR

Concluding Remarks


Issues
Issues

Making a metadata search system based on various metadata registries

Designing a database schema using metadata of metadata registries

  • Various MDR systems (instances)

  • Get metadata information from any registries?

Providing a standardized inference for users to use a registry

Developing an integrated metadata registry systems

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Issues cont
Issues (cont.)

Making a metadata search system based on various metadata registries

Designing a database schema using metadata of metadata registries

How can we achieve this goal?(obtain metadata from MDRs)

  • Various MDR systems (instances)?

  • Get metadata information from any registries in a consistent/standardized manner?

A Consistent/Standard access method is required

Providing a standardized inference for users to use my registry

Developing an integrated metadata registry systems

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Issues cont1
Issues (cont.)

  • No Standardized Access Method !!!

    • (ISO/IEC 11179 does not provide)

Making a metadata search system based on various metadata registries

Designing a database schema using metadata of metadata registries

  • Various MDR systems (instances)?

  • Get metadata information from any registries in a consistent/standardized manner?

Providing a standardized inference for users to use my registry

Developing an integrated metadata registry systems

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Issues cont2
Issues (cont.)

MDR systems have been developed with different access methods each other

(Heterogeneity between MDR management systems)

No method to build valid MDRs strictly following the standard

(No mandatory attributes; Misuse)

Inconsistency Issue between MDRs

(Incompatibility issue of metadata)

Need to get metadata from one or more MDRs

(for building a database according to predefined DEs)

Difficult to realize an integrated metadata registry system

(Integration of relevant and similar MDRs)

Need to harmonize various MDRs

(MDR Integration: Tightly or Loosely Coupled)

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Key issues to be resolved
Key Issues to be Resolved

What Issues should we resolve?

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Key issues to be resolved cont
Key Issues to be Resolved (cont.)

  • How to guarantee valid metadata registry building

  • How to define registry structure & insert, delete, and modify metadata

  • DDL and DML (except retrieval language) in SQL

  • How to get metadata from various registries

  • How to retrieve metadata from registries in a consistent way

  • Retrieval language in SQL

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Possible approaches
Possible Approaches

How to resolve the issues?

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Possible approaches cont
Possible Approaches (cont.)

  • Interface Mapping between MDR Management Systems

    • Required for implementation of one-to-one adaptor  High cost

    • Not guarantee metadata registries to be valid

  • Standardized Binding API-based Approach

    • ISO/IEC 20944 (Program level)

    • Every system should implement functions (bodies) for the binding APIs  High cost

    • Not guarantee metadata registries to be valid

  • Direct DB Access

    • Users should know the schema structures of MDRs  Security problem

    • Not guarantee valid metadata registries

  • Standardized Query Language-oriented Approach: Our Approach

    • SQL/MM Standards Approach

      • User-defined type and Routines

    • Can guarantee valid metadata registries to be built

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Background motivation introduction to sql mm mdr concluding remarks1

Background

Motivation

Introduction to SQL/MM MDR

Concluding Remarks


Discussion history
Discussion History

SC32 Joint Study Periods Meetings (WG2,3,4), Clearwater, FL, February 2007

  • First presentation on this standard item

  • Simple Introduction to SQL/MDR (Idea description)

SC32 Plenary and WG Meetings, New York, USA, July 2007

  • Request for a study period on SQL/MM MDR

  • Documents: 32N1656-WG4N0061-jfk0023-studyrequest-sql_mdr-jfk.pdf & jfk0024-wg4-presentation-sql-mdr.ppt

  • Presentation title: SQL/MDR: Query Language for Sharing and Exchanging of Metadata between MDRs - Proposal for a Study Period in WG4 –

WG 4 Meeting, Jagsthausen, Germany, November 2007

  • A tough draft has been provided

  • Documents: str015 wg4-sqlmm-mdr.doc

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Discussion history cont
Discussion History (cont.)

SC32 Plenary and WG Meetings, Sydney, Australia, May 2008

  • Proposed NWIP

  • Resolutions: SC321737a

  • SC 32 approves the following subdivisions and SC32 instructs its secretariat to conduct a 60-day letter ballot for Project 1.32.04.01.08.00, and accept the project subdivision if at least four National Bodies support the subdivision.

November 15, 2008: Approved

  • SC32N1809: Five NBs approved

SC 32/WG 4 Interim Meeting, Portugal, November 2008

In addition, Open Forums and Workshops

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Purpose
Purpose

  • The purpose of this International Standard is to define multimedia and application specific types and their associated routines for retrieval of metadata using the user-defined features in ISO/IEC 9075

  • ISO/IEC 13249 SQL/MM is structured as a multi-part standard, and at present, it consists of the following parts:

    • Part 1: Framework

    • Part 2: Full-Text

    • Part 3: Spatial

    • Part 5: Still Image

    • Part 6 : Data Mining

    • Part 7: History

    • Part 8: MDR

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Scope
Scope

  • This Part of ISO/IEC 13249

    • introduces the metadata registry part of ISO/IEC 13249,

    • gives the references necessary for this part of ISO/IEC 13249,

    • defines terms, notations, conventions, and definitions specific to this part of ISO/IEC 13249,

    • defines concepts specific to this part of ISO/IEC 13249,

    • defines metadata registry user-defined types and associated routines,

    • covers specifications for retrieval of metadata of registries

    • does not covers specifications for insertion, deletion, modification of metadata including creation of schema structures for registries

      /** According to the comment of the WG 2 experts,

      the Workshop on ROR, On-Demand Model Selection and SMMP,

      September 2008, Wuhan, China */

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Overview
Overview

  • Registries have been used for systematic management of metadata describing data

    • A variety of registry frameworks has been developed for applications fields, and many registries have been built for management of metadata.

  • For valid and exact registry exchanging and sharing, the following problems should be resolved:

    • Inconsistent access method

    • Difficulty of registry management system development

  • This part therefore aims to

    • provide a standard retrieval method

  • This part

    • enables to obtain metadata in a consistent way from metadata registries,

    • and facilitates usage of the standard.

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Overview cont
Overview (cont.)

  • This part includes

    • the specifications for management of metadata registries,

    • and the specifications are defined in the same way with SQL packages such as SQL/MM Spatial, SQL/MM Mining, SQL/MM Still Image, and so on

  • This part covers

    • the definition of operational architectures and processes for the consistent retrieval that can support transparency regardless of registries with different database structures

  • This part specifies user-defined features for the ISO/IEC 11179 standard

    • A user can define an MDR schema using the user-defined types provided in this part

    • This standard can lead the valid MDR creation because the user-defined types reflect all information of the ISO/IEC 11179 standard

    • The user-defined types can also enable management and access of metadata.

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Conceptual model
Conceptual Model

Retrieve Metadata from Metadata Registries

Scope

Metadata Retrieval

Metadata Definition

Metadata Update

call

User-Defined Types

Routines

(Methods, Functions)

association

Registry Storage Model

(Tables/Views)

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Definition of user defined types and routines
Definition of User-Defined Types and Routines

MDR_<ClassName> type

MDR_Data_Element

  • MDR User-Defined Types

    • An MDR user-defined type is mapped to its corresponding MDR class

    • An example of MDR classes = {data element, conceptual domain, ...}

  • Type Definition Form

    • The MDR_<ClassName> type is an abstraction for classes of metamodel of ISO/IEC 11179

    • For example, the user-defined type for the class ‘Data_Element’ of the ISO/IEC 11179 metamodel is defined as follows:

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Definition of user defined types and routines cont
Definition of User-Defined Types and Routines (cont.)

  • Create a UDT Statement

    CREATE TYPE MDR_Data_Element

    AS ( <ALLColumns> )

    STATIC METHOD MDR_administered_item_administration_record()

    RETURNS TABLE(<ALLColumns>),

    STATIC METHOD MDR_data_element()

    RETURNS TABLE(<ALLColumns>),

    METHOD MDR_data_element_name()

    RETURNS <data_element_name>

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Definition of user defined types and routines cont1
Definition of User-Defined Types and Routines (cont.)

user_de_table is the table name that is defined by a user.

i.e., BEGIN-END part should be implemented by users.

  • Definition of the Static Method MDR_data_element()

    • Obtain all data of data element

      CREATE STATIC METHOD MDR_data_element()

      RETURNS TABLE(<AllColumns>)

      FOR MDR_data_element

      BEGIN

      RETURN TABLE(

      SELECT <Columns>

      FROM user_de_table);

      END

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Definition of user defined types and routines cont2
Definition of User-Defined Types and Routines (cont.)

  • Output Parameters of the Static Method MDR_data_element()

    data_element_administration_record MDR_Administration_Record,

    representation_class_qualifier CHARACTER VARYING(30),

    data_element_precision Integer

  • The attribute data_element_administration_record is the structured type MDR_Administration_Record

12th Annual Open Forum for Metadata Registries (OFMR2009)


Retrieve metadata
Retrieve Metadata

  • In the SELECT clause, data_element_name and status are defined based on attribute names in the metamodel of ISO/IEC 11179

  • Select Statement

    SELECT

    DE.data_element_name, DE.status

    FROM

    TABLE (MDR_Data_Element::MDR_data_element()) AS DE

    WHERE

    DE.data_element_administration_record.administrative_status()

    = 'Recorded’;

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


Concluding remark
Concluding Remark

  • Contributions

    • Ease of use

    • Familiarity to users

    • Consistent and Standardized access method

      • Independent query description on physical structures (table structures)

      • Low modeling cost (decreases query description time)

      • Simplicity of query statement for accessing distributed registries

      • Low complexity for distributed query composition

  • In its application aspect, this standard contributes as follows.

    • can be used Unified Access Method to Various Registries

    • provides Unified query and Unified query result form

    • can be used for developing distributed registries management system

    • can be used as a communication protocol (method) for developing semi-automatic tools: Registries Mapping and Integrating tools

    • can do easy data Integration (among databases following their own registry)

Tutorial of SQL/MM Part 8 - Metadata Registry (MDR), ISO/IEC JTC 1/SC 32 Plenary


ad