D 2012

Relational Schema Protocol (RSP)

PŘEHNAL, Vojtěch

Basic information

Original name

Relational Schema Protocol (RSP)

Name in Czech

Relational Schema Protocol (RSP)

Authors

PŘEHNAL, Vojtěch (203 Czech Republic, guarantor, belonging to the institution)

Edition

první, s přílohou CD. Hradec Králové, Proceedings of IMEA 2012, p. 81-87, 7 pp. 2012

Publisher

Univerzita Hradec Králové, Fakulta informatiky a managementu

Other information

Language

English

Type of outcome

Proceedings paper

Field of Study

Informatics

Country of publisher

Czech Republic

Confidentiality degree

is not subject to a state or trade secret

Publication form

printed version "print"

RIV identification code

RIV/00216224:14330/12:00059624

Organization

Fakulta informatiky – Repository – Repository

ISBN

978-80-7435-185-3

Keywords (in Czech)

RSP; relational schema; serialization schema; metadata model; communication protocol; user interface; data visualization

Keywords in English

RSP; relational schema; serialization schema; metadata model; communication protocol; user interface; data visualization
Changed: 1/9/2020 12:15, RNDr. Daniel Jakubík

Abstract

V originále

Widely disparate applications are very often required to share and exchange relational data. Typically, this is accomplished by passing messages over a shared environment (e.g. computer network, file system, computing memory, etc.) in a well-defined, machine-processable format. In simple scenarios, when the relational schema is invariable, only the data need to be serialized and exchanged. The interacting applications are precisely customized for the particular schema: they share a custom serialization schema, they perform custom business logic on the data and, eventually, they have a custom user interface designed. As the relational schema evolves, the serialization schema has to be redefined and the interacting applications have to be reimplemented. In order to access evolving relational schema in real-time, it is necessary to serialize the schema using some metadata model and to exchange the schema together with the data. As a consequence, the user interface has to be inferred from the schema and generated on-the-fly instead of being designed and customized by the software vendor. This puts high demands on the metadata models to supply sufficient information for generating rich user interface from the provided metadata. This paper specifies the Relational Schema Protocol (RSP). RSP enables loosely coupled applications to share and exchange relational data. It provides access to heterogeneous relational data sources using a uniform set of operations and data types. It extends the standard relational meta-models such as SQL INFORMATION SCHEMA, OIM or CWM with additional metadata for rich user interface generation. It defines a set of operations for on-line schema exploration and efficient data manipulation in real-time.
Displayed: 18/6/2025 17:31