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

Database table and XML message mapping processing method and system

A mapping processing and database technology, which is applied to the mapping processing method and system field of database tables and XML messages, can solve the problems of time consumption, message message format problems, inefficient message parsing, etc., and achieves improved efficiency and convenience. Effectiveness of management and maintenance

Active Publication Date: 2016-10-12
FUJIAN RONGJI SOFTWARE
View PDF6 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The above shortcomings are likely to cause format problems in the interaction of message messages between systems. When problems occur, the two parties in the technical connection need to communicate and troubleshoot continuously, which increases the complexity of troubleshooting.
[0004] 2. Inefficient packet analysis
In terms of XML structured message parsing and processing, the traditional message processing method is mainly based on the open source dom4j or jdom and other methods for parsing. In terms of message parsing, most of the time is spent on the analysis of message templates and paths, and the lack of corresponding The cache loading strategy does not make full use of the cache technology to achieve the technical advantages of "load once, use everywhere"
In the process of high concurrency and large data volume processing, it is easy to cause low parsing efficiency and prolonged parsing and processing time
[0005] 3. Low code reuse rate
Conventional XML message parsing and processing mainly adopts hard-coded methods. With the development of business, it is necessary to add or delete nodes to the XML message structure, and when adding new message content, it is necessary to adjust the code to increase the Project development, testing, management and other input costs
Another point is that when the project is launched and has been stably running in the actual production environment, such adjustments have certain risks and costs, and it is easy to cause system instability due to the adjustment of the coding design and thus bring corresponding risks.
[0006] 4. Difficulty in management and maintenance
[0007] 5. Lack of effective monitoring
However, this solution is based on business objects, highly coupled with business codes, and based on database configuration, making management and maintenance difficult

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
  • Database table and XML message mapping processing method and system
  • Database table and XML message mapping processing method and system
  • Database table and XML message mapping processing method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0089] Please refer to figure 1 , Embodiment 1 of the present invention is: a kind of mapping processing method of database table and XML message, comprises the following steps:

[0090] S1: The field mapping table between preset database fields and XML message node fields; for example, through

[0091]

[0092]

[0093]

[0094]

[0095]

[0096]

[0097] The name in the node = "database table name", and the column is identified as the corresponding node in the corresponding XML message; the field mapping attribute description is shown in Table 1; each table contains one or more fields, and the field has many attributes that need to be set , such as data type, display format, etc. Two of the more important attributes are is_pk and is_bizpk, which are used to indicate whether the field is a primary key or a business primary key. The business primary key plays a very important role. In the case of updating, the business primary key will be used To locate records, s...

Embodiment 2

[0122] Please refer to image 3 , this embodiment is a further expansion of the embodiment, and the similarities will not be described again. The difference is that after the step S7, a template update process is also included, which specifically includes the following steps:

[0123] S13: Publish the update information of the XML message template to the service bus.

[0124] S14: The service bus pushes the update information to each communication node.

[0125] S15: Each communication node acquires the update information.

[0126] S16: Compare the XML message template in the update information with the unique identifier and version number of the XML message template being used; preferably, the unique identifier is a template number.

[0127] S17: Determine whether an update is required, if yes, perform step S18, if not, perform step S21; that is, determine whether the version numbers are consistent when the unique identifiers are consistent, if they are consistent, no updat...

Embodiment 3

[0137] Please refer to Figure 5 , the present embodiment is a mapping processing system of a database table and an XML message corresponding to the foregoing embodiments, including:

[0138] The first preset module 1 is used to preset the field mapping table between database fields and XML message node fields;

[0139] The first obtaining module 2 is used to obtain the target database;

[0140] An extracting module 3, configured to extract a preset number of target data tables in the target database;

[0141] The first judging module 4 is used to judge whether there is a master-subtable relationship between the target data tables, and obtain a first judging result;

[0142] The first determining module 5 is configured to determine at least one set of master-subtable relationships if the first judgment result is yes;

[0143] The first generation module 6 is used to generate an XML message template corresponding to the number of main-subtable relationship groups according t...

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 invention discloses a database table and XML message mapping processing method and system. The method comprises the steps that a field mapping table of database fields and XML message node fields is preset; a target database is acquired; the preset number of target data tables are extracted from the target database; whether a master-sub table relation exists among the target data tables or not is judged; if yes, at least one group of master-sub table relations are determined; XML message templates of which the group number corresponds to that of the master-sub table relations are generated according to the field mapping table and the master-sub table relations, wherein the XML message templates contain hierarchical nested relations between the main tables and the sub tables; corresponding XML messages are generated according to the XML message templates and the corresponding target data tables. According to the database table and XML message mapping processing method and system, mutual conversion between the data tables and the XML messages can be achieved, the input cost of project development, measurement and management is reduced, the message parsing efficiency is improved, and management and maintenance are convenient.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a mapping processing method and system for database tables and XML messages. Background technique [0002] In the process of traditional data exchange and message processing, the message processing of structured XML files is basically processed by hard-coded XML nodes or path structures for message structures of different formats, but there are Disadvantages: [0003] 1. Lack of standard specifications. XML-structured messages are mostly used in data exchange and service integration. The data exchange and service integration of messages between various systems may easily lead to a lack of uniformity in the format and standards of message messages. It is mainly reflected in the following aspects: message format, character set encoding, special characters, message node naming format, message attributes, message version, different types of databases, data source support, etc. The ...

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/86G06F16/88
Inventor 姚少扬孙玉友靳谊
Owner FUJIAN RONGJI 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