Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data distribution method for relational database

A data distribution and database technology, applied in the field of relational database data distribution, can solve the problem of disconnection between user interface operation manual and software implementation, and achieve the effect of reducing the probability of data errors in the production environment, being easy to popularize, and reducing cumbersomeness.

Inactive Publication Date: 2015-11-11
INSPUR COMMON SOFTWARE
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical task of the present invention is to provide a method for distributing relational database data to solve the problem of disconnection between user interface operation manual and software implementation in view of the above deficiencies

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
  • Data distribution method for relational database
  • Data distribution method for relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0058] Example: as attached figure 1 design process, attached figure 2 As shown in the distribution process of the present invention, the specific implementation process of the present invention is,

[0059] design phase:

[0060] (1) Provide a metadata unified management interface, which realizes the identification of new data, identification of modified data, identification of deleted data, conversion of metadata, query of data at design time, unified persistence processing, and acquisition of metadata , archiving and other functions.

[0061] (2) It is necessary to provide an interface for database data delivery to the production environment. Background logic processing implements a unified metadata management interface, and all operational data is converted into metadata when it is persisted.

[0062] (3) If there is no interface operation and the database data needs to be delivered to the production environment, use the unified operation interface to add, modify, and ...

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

The method invention discloses a data distribution method for a relational database, and belongs to the field of computer data distribution. The method comprises: a design step of modeling specific to the relational database, and describing the relational database as two types of metadata, namely, data content and data description; and a distribution step of performing resolving execution on the data. Compared with the prior art, the data distribution method for the relational database has the advantages that data of the relational database is delivered by providing of a way of not using any SQL (Structured Query Language), so that the complexity of SQL compiling in an ERP software development process is lowered, and the probability of production environment data errors caused by software delivery is lowered.

Description

technical field [0001] The invention relates to the technical field of ERP system software data distribution, in particular to a method for relational database data distribution. Background technique [0002] In an enterprise-level application development environment, the products developed by software companies and delivered to users generally include three parts: program files, database table structure, and database prefabricated data; most of the database prefabricated data are data related to program operation logic and some configuration information. The delivery of database prefabricated data generally uses SQL. When writing SQL, there are differences between compatible database types (Oracle, SqlServer, DB2, Sybase, etc.) and versions. Developers need to write carefully one by one. A tedious and time-consuming task. [0003] When SQL is delivered, if it does not support repeated execution, and the production environment executes it without knowing whether it has bee...

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
CPCG06F16/212G06F16/211G06F16/284
Inventor 魏建斌
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com