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

Method and system for importing relational database data into hierarchical real-time database

A hierarchical structure and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as real-time databases with hierarchical structures that have not yet been discovered

Inactive Publication Date: 2018-11-23
NR ELECTRIC CO LTD +1
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, the technologies for downloading from relational databases to real-time databases are basically aimed at the operation of single-table real-time databases without correlation, and no technology for hierarchical real-time databases has been found.

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
  • Method and system for importing relational database data into hierarchical real-time database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] The present invention will be further described below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solution of the present invention more clearly, but not to limit the protection scope of the present invention.

[0023] Such as figure 1 As shown, the method for downloading relational database data to a hierarchical real-time database includes the following steps:

[0024] Step 1, configure the table domain relationship, that is, configure the table-to-table and domain-to-domain relationship between the relational database and the real-time database, and save the configured table domain relationship in an XML file.

[0025] Among them, during configuration, domain-to-domain configuration needs to focus on:

[0026] a. The matching of the data type of the field. For example, if the data of the field in the relational database is a non-numeric character string, the field of the real-time database cannot b...

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 method and a system for importing relational database data into a hierarchical real-time database, the method comprises outputting data in a relational database as a text file, analyzing a hierarchical structure relationship between the table and the table, converting text data into the text of the hierarchical structure through the defined table-to-table, domain-to-domain relationships between the relational databases and the real-time databases, then importing into the real-time database. Thereby, the data import of the relational database to the hierarchical real-time database is realized.

Description

technical field [0001] The invention relates to a method and a system for downloading relational database data to a hierarchical real-time database, belonging to the field of electric power real-time monitoring. Background technique [0002] In the field of power monitoring, the real-time performance of data acquisition and control is often very high, and the performance of traditional relational databases is difficult to meet the needs of real-time monitoring. Therefore, many power monitoring manufacturers and products have adopted virtual memory technology to realize the manufacturer's private memory. Database, also known as real-time database. Considering that the power monitoring system inevitably deals with relational databases in actual engineering, the data in the relational database and the real-time database are imported and exported to each other, which also results in downloading (relational database to real-time database) and uploading between the two databases. ...

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
Inventor 湛锋陆鑫孙超钱锋
Owner NR ELECTRIC CO LTD