Universal Delta data loading technology

A data loading and data technology, applied in the field of database systems, can solve problems such as inaccurate information and inability to reflect data

Active Publication Date: 2014-11-12
SAP AG
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the processing of data in the database may not ...

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
  • Universal Delta data loading technology
  • Universal Delta data loading technology
  • Universal Delta data loading technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] In the following description, for the purpose of illustration, specific figures, materials and configurations are given in order to give a comprehensive understanding of the current framework and method, and in order to meet the statutory written description, implementation, and best practice requirements. It will be apparent, however, to one of ordinary skill in the art that the present framework and methodologies may be practiced without the specific exemplary details. In other instances, well-known features are omitted or simplified in order to clarify the description of exemplary implementations of the present frameworks and methods, thereby better illustrating the present frameworks and methods. Also, for ease of understanding, certain method steps have been described as discrete steps; however, these separately depicted steps should not be understood as necessarily order-dependent or separated in their performance.

[0017] The current framework as described herei...

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

Described herein is a technology for facilitating delta data load. In some implementations, history tables corresponding to physical tables in a data source are provided in a database layer. The database layer includes change list tables corresponding to the history tables and a physical data model based on one or more physical tables. Delta data is determined by analyzing the change list table to create delta data summary tables. Key lists are generated for summary tables corresponding to physical tables which physical data is based. The delta data is applied to the physical data model.

Description

technical field [0001] The present disclosure generally relates to database systems. More specifically, the present disclosure relates to delta data loading in database systems. Background technique [0002] In today's business environment, huge amounts of data can be generated. Such data may be stored in a database, managed by a database system. Data may be stored, for example, in tables. Data may relate, for example, to employees, customers and customer orders. The data can be manipulated as required to provide desired information about the data in the database. Such processing may, for example, provide analytical results such as statistical information and generate reports. [0003] Data in tables may be constantly changing or generated. For example, in a transaction processing system, countless transactions may occur in a day. Changes in tables or new data (delta data) need to be loaded into the database. However, traditional databases do not specify a delta data...

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
IPC IPC(8): G06F17/30
CPCG06F17/30174
Inventor 陈颖宇李涵宋翊涵
Owner SAP AG
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products