SQL (Structured Query Language)-based database management method and device

A management method and management device technology, applied in the field of computer applications, can solve problems such as low work efficiency, manual execution, and inability to judge and save the execution status of each script, so as to reduce maintenance costs, reduce manual intervention, and improve execution efficiency. Effect

Active Publication Date: 2012-01-18
NANJING ZNV SOFTWARE CO LTD
View PDF4 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method has the following defects: First, engineers need to manually execute each script, and professional technicians need to analyze the execution results returned by each engineer, so their work efficiency is low
In this way, it is difficult or even impossible to judge and save the execution of each script

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
  • SQL (Structured Query Language)-based database management method and device
  • SQL (Structured Query Language)-based database management method and device
  • SQL (Structured Query Language)-based database management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0050] In a preferred implementation manner, in order to improve execution efficiency, when there are multiple database management task items, the corresponding multiple SQL scripts are executed in parallel with multiple threads.

[0051] In the situation based on the above two preferred implementation manners, after performing all the steps of S300-S302, the SQL-based database management method further includes the following steps S306 or S305:

[0052] S306 (S305), save the result after execution of each SQL script, and form a SQL script execution result set.

[0053] refer to figure 1 , which describes the configuration stage flow of the SQL-based database management method provided by the embodiment of the present invention, specifically as follows:

[0054] Step 101, classify database management application requirements, and determine a database management task item set.

[0055] Step 102, compile and debug corresponding SQL scripts according to each database management...

Embodiment 1

[0078] Example 1 Database service upgrade

[0079] Scenario description: Due to the upgrade of business requirements, the corresponding data of the database to be managed needs to be updated. For example, in this embodiment, the target of the upgrade includes the following items:

[0080] 1. Add a table;

[0081] 2. Add a field to a table.

[0082] Its implementation steps include the following configuration phases and operation phases, which are introduced as follows:

[0083] configuration phase

[0084] 1. Determine the database management task item set according to the application requirements:

[0085] Database management task item 1: add tables;

[0086] Database administration task item 2: Update tables.

[0087] 2. Write SQL scripts according to database management task items, for example:

[0088] AddTable.sql text content:

[0089] CREATE TABLE...;

[0090] UpdateTable.sql text content:

[0091] ALTER TABLE...;

[0092] 3. Configure the logical mapping fil...

Embodiment 1

[0103] This embodiment is generally applicable to the following situations:

[0104] No return set for task item.

[0105] SQL scripts only need to be run once.

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 an SQL (Structured Query Language)-based database management method and device. The method comprises the steps of: compiling a corresponding SQL script by aiming at each database management task item to form an SQL script set; establishing a logic mapping file of each database management task item with a corresponding SQL script; and deploying the SQL script set and the logic mapping file at a position available for access of a database management client side. According to the invention, by configuring the mapping relation between the database management task items andthe corresponding SQL scripts, the automatic batch execution and the result analysis and storage of the database management task items can be realized, so that manual interventions in a database management process can be reduced, the execution efficiency can be increased and the maintenance cost can be reduced.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a SQL-based database management method and device. Background technique [0002] Currently, in many computer application systems, databases based on SQL (Structured Query Language) language undertake the storage of system business data and the calculation of business logic. However, in the long-term operation of the system, there are problems of high cost and low efficiency in the maintenance and upgrading of the database system. E.g: [0003] Scenario 1: After a long period of on-site operation of the database system, due to the influence of various factors, there may be errors, redundancy, and inconsistencies in its business data. The common inspection and correction method is: Professional technicians write corresponding database scripts for each inspection and correction requirement, and the on-site engineering personnel execute these scripts in sequence in th...

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 NANJING ZNV SOFTWARE CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap