Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Method and device for quickly initializing system database, and storage medium

A database and initialization technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of prone to errors, large workload, complicated operation, etc., so as to reduce the data error rate and improve the initialization efficiency. Effect

Active Publication Date: 2018-08-21
PING AN TECH (SHENZHEN) CO LTD
View PDF12 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, when a certain system A is created for a certain period of time, more database schema definition language (Data Definition Language, DDL) statements will be compiled. At this time, if another database of system B with the same type or part of the same functions is initialized, Developers need to manually collect all the DDL statements stored in system A, and change their schema (owner), authorized users and other information for system B to use. The workload is heavy and the operation is very cumbersome. In addition, the manual operation It is also very easy to make mistakes in the process

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 device for quickly initializing system database, and storage medium
  • Method and device for quickly initializing system database, and storage medium
  • Method and device for quickly initializing system database, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] Such as figure 1 Shown is an application environment diagram of a preferred embodiment of the electronic device 1 of the present invention. The QIS database system 10 is applied to the electronic device 1 . The electronic device 1 is connected to multiple clients 3 via a network 2 . The network 2 may be a network such as a local area network, a wide area network, or a metropolitan area network, and may be a wired network or a wireless network. The client 3 can be a desktop computer, a notebook, a tablet computer, a mobile phone, or other terminal devices that can communicate with the electronic device 1 through the network 2 .

[0048] Such as figure 2 shown, is figure 1 A schematic diagram of a preferred embodiment of the electronic device 1 . The electronic device 1 includes, but is not limited to, a memory 11 , a processor 12 and a fast initialization system database system 10 stored on the memory 11 and operable on the processor 12 . The electronic device 1 i...

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 provides a method for quickly initializing a system database, and is applied to an electronic device. The method comprises the following steps that: scanning database table names corresponding to all DDL (Data Definition Language) script files in a historical system database, and obtaining the DDL script files of which the database table forms are the same; combining the obtained DDLscript files of which the database table forms are the same into a DDL statement file; and revising the feature information of the combined DDL statement file, and generating an initialized databasescript corresponding to a target system. By use of the method, the initialization efficiency of the database is improved, and a data error rate is lowered. The invention also provides an electronic device and a computer readable storage medium.

Description

technical field [0001] The invention relates to the application field of database management, in particular to a method and device for quickly initializing a system database. Background technique [0002] At present, systems of the same type or some systems with the same functions have similar business logic, which can also be understood as: the above-mentioned systems need to create the same table structure in different databases. For example, when a certain system A is created for a certain period of time, more database schema definition language (Data Definition Language, DDL) statements will be compiled. At this time, if another database of system B with the same type or part of the same functions is initialized, Developers need to manually collect all the DDL statements stored in system A, and change their schema (owner), authorized users and other information for system B to use. The workload is heavy and the operation is very cumbersome. In addition, the manual operat...

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/211
Inventor 张勋沈毅王刚
Owner PING AN TECH (SHENZHEN) 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
Eureka Blog
Learn More
PatSnap group products