Unlock instant, AI-driven research and patent intelligence for your innovation.

View variants in database schema mapping

A technology of data view and database, applied in the field of mapping database schema, can solve problems such as error-prone and time-consuming

Active Publication Date: 2014-09-17
SAP AG
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, data modeling becomes a challenge because the data model is typically specific to the database schema
Managing multiple separate copies of the data model for each database schema can be time-consuming from a development perspective, and can be error-prone when a new version of the data model becomes available and the new copy needs to be rebuilt

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • View variants in database schema mapping
  • View variants in database schema mapping
  • View variants in database schema mapping

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] Although example embodiments may include various modifications and alternative forms, example embodiments are shown by way of example in the drawings and will be described in detail herein. It should be understood, however, that there is no intent to limit example embodiments to the particular forms disclosed, but on the contrary, example embodiments are to cover all modifications, equivalents, and alternatives falling within the scope of example embodiments. Like reference numerals refer to like elements throughout the description of the figures.

[0014] figure 1 A database system according to one or more example embodiments is shown. figure 1 A database system 100 according to an embodiment of the present disclosure is shown in . Database system 100 may include database 102 . One or more database schema instances (“database schemas”) 104a, 104b may be defined in the database system 100 . A data model output manager 106 may be provided to allow a user to query the...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

This disclosure includes a method, a system and a computer readable medium. The method includes receiving a data model configured to model data in a first database schema in a database system, using the received data model to generate a first data view of a first instance of the first database schema in the database system, including referencing, using a first view variant, one or more data tables including the first instance of the first database schema to generate the first data view, and using the received data model to generate a second data view of a second instance of the first database schema in the database system, including referencing, using a second view variant, one or more data tables including the second instance of the first database schema to generate the second data view.

Description

technical field [0001] Embodiments relate to mapping database schemas in interconnected database systems. Background technique [0002] It is increasingly common to consolidate multiple data systems in a business enterprise (or any other organization) into a centralized data system. For example, SAP Database products offer advanced database technologies such as an in-memory database engine that can allow an enterprise to store its most relevant data in main memory enabling analysis to be performed directly in the database. [0003] However, enterprises may maintain separate replica data systems for some of their operations. For example, data systems (eg, manufacturing, sales, etc.) for a facility in the United States may be maintained separately from corresponding data systems for a facility in Europe. Providing a data set for each of the two data systems in the centralized data system can be achieved by creating multiple instances of the database schema for the separate...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30G06F17/30294G06F16/212G06F16/27G06F16/00
Inventor A.凯姆勒T.卡门兹
Owner SAP AG