Supercharge Your Innovation With Domain-Expert AI Agents!

Management system and method of heterogeneous database

A management method and database technology, applied in database management systems, electronic digital data processing, structured data retrieval, etc., can solve the problems of reducing the work efficiency of the network management system, achieve the effect of reducing network overhead and improving work efficiency

Active Publication Date: 2015-12-16
FENGHUO COMM SCI & TECH CO LTD
View PDF3 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, since the grammars supported by the above-mentioned types of databases are quite different, the network management system needs to manage different types of databases separately, thus reducing the work efficiency of the network management system

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
  • Management system and method of heterogeneous database
  • Management system and method of heterogeneous database
  • Management system and method of heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The present invention will be described in further detail below in conjunction with the accompanying drawings and embodiments.

[0027] see figure 1 As shown, the embodiment of the present invention provides a management method for a heterogeneous database, including the following steps:

[0028] Step S1. Create a table definition file that records database information. Preferably, the table definition file is an XML file.

[0029] Step S2. Read the table definition file, generate the corresponding table-building script file and foreign key script file according to each type of database, and then according to the table-building script file and foreign key script file corresponding to each type of database Field information, write stored procedure script files and static data script files; databases are divided into row databases, column databases and distributed databases according to their types.

[0030] Step S3. According to the type selected by the user, execute ...

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 management system and method of a heterogeneous database, and relates to the technical field of databases. The method comprises the following steps: creating a table definition file recording database information; reading the table definition file, generating corresponding table building script file and external key script file according to each type of database, and compiling a storage process script file and a static data script file; executing the table building script file, the external key script file, the storage process script file and the static data script file of the corresponding type of database, and generating the corresponding type of database; receiving a maintenance instruction, reading the table definition file, generating a backup restoring script file, executing the backup restoring script file, maintaining the database and ending; receiving a database access instruction, encapsulating various database interfaces into unified interfaces of the databases, calling the corresponding type of interface implementation function through the unified interfaces of the databases, accessing the databases, returning the execution result and ending.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a management method and system for heterogeneous databases. Background technique [0002] At present, with the rapid development of network technology, the scale of broadband users continues to expand, resulting in an increasing number of devices managed by the network management system, which in turn results in an increasing amount of data stored in the network management system. As an important supporting part of the bottom layer of the network management system, the database is divided into row database, column database and distributed database according to the type. Among them, the row database is suitable for data processing with a small amount of data, and the column database is suitable for data processing when the data volume surges. Data processing, distributed databases are suitable for data processing under massive data. Therefore, users need to choose the correspon...

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/2291G06F16/25
Inventor 邹昊朱红霞
Owner FENGHUO COMM SCI & TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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