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

Database table creating method and device, computer equipment and readable storage medium

A database and data source technology, applied in the computer field, can solve the problems of unsatisfactory database table creation efficiency, cumbersome operation process, low efficiency, etc., achieving effective and accurate data support, flexible implementation process, and saving labor costs.

Pending Publication Date: 2019-05-28
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF0 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the above scheme of creating database tables, on the one hand, operations such as script writing and script execution require human participation, which requires a lot of labor costs and is not efficient; on the other hand, after the database table is created, such as encountering When the change needs to modify some table fields in the database table, or when there is a need for sub-database and sub-table due to the large amount of data, the developer needs to rewrite the relevant SQL script, and submit the event to the operation and maintenance personnel for the operation and maintenance It is performed by personnel, the operation process is more cumbersome, the flexibility is poor, and the operation efficiency is low
[0004] For the problem of unsatisfactory database table creation efficiency in related technologies, no effective solution has been proposed so far

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 creating method and device, computer equipment and readable storage medium
  • Database table creating method and device, computer equipment and readable storage medium
  • Database table creating method and device, computer equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0065] The method for creating a database table provided by the present invention will be described below in conjunction with the accompanying drawings.

[0066] figure 1 An optional schematic flow chart of the method for creating a database table of the present invention, such as figure 1 As shown, the method may include the following steps:

[0067] S01. Extract the header field information in the data source file as the first field information.

[0068] In this embodiment, the database table can be created according to the content of the file as the data source, wherein the file as the data source (also referred to as the data source file) is preferably an Office Microsoft Office Excel file (such as: AA_01.xlsx ), of course, other types of files can also be selected as the data source file according to actual needs.

[0069] Multiple header fields may be included in the data source file, for example, an Excel file related to loan customer information, where the header fi...

Embodiment 2

[0103] Based on the method for creating a database table provided in the first embodiment above, a device for creating a database table is provided in this embodiment, specifically, Figures 2 to 3 An optional structural block diagram of the database table creation device is shown, the database table creation device is divided into one or more program modules, one or more program modules are stored in a storage medium, and are controlled by one or more processors to complete the present invention. The program module referred to in the present invention refers to a series of computer program instruction segments that can complete specific functions, and is more suitable than the program itself to describe the execution process of the creation device of the database table in the storage medium. The following description will specifically introduce the programs of this embodiment. function of the module.

[0104] Such as figure 2 As shown, the creation device 20 of the databas...

Embodiment 3

[0132] This embodiment also provides a computer device, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a rack server, a blade server, a tower server, or a cabinet server (including an independent server, or A server cluster composed of multiple servers), etc. Such as Figure 4 As shown, the computer device 40 of this embodiment at least includes but is not limited to: a memory 41 and a processor 42 that can communicate with each other through a system bus, such as Figure 4 shown. It should be pointed out that, Figure 4 Only computer device 40 is shown having components 41-42, but it should be understood that implementing all of the illustrated components is not a requirement and that more or fewer components may instead be implemented.

[0133] In this embodiment, the memory 41 (that is, a readable storage medium) includes a flash memory, a hard disk, a multimedia card, a card-type memory (for example, SD or DX memory, etc.), random acc...

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 for creating a database table, which comprises the following steps of: extracting header field information in a data source file as first field information; determining the data type and length of each column value corresponding to each header field in the data source file as the data type and length of each column value corresponding to the first field; determining an index rule according to services related to the data source file; And creating a database table according to the first field information, the data type and length of each column value corresponding to the first field, and the index rule. The content needed by the data table is automatically obtained, the data table is created, the problem that in the prior art, the database table creating efficiency is not ideal can be solved, and the database table creating efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a database table creation method, device, computer equipment and readable storage medium. Background technique [0002] At present, the way to create a database table is usually that the developer writes the SQL script related to the database table locally and exports it, then submits the event corresponding to the creation of the database table to the operation and maintenance personnel. After the operation and maintenance personnel receive the event, Execute SQL scripts related to database tables in its production environment to create database tables. [0003] In the above scheme of creating database tables, on the one hand, operations such as script writing and script execution require human participation, which requires a lot of labor costs and is not efficient; on the other hand, after the database table is created, such as encountering When the change needs to modify so...

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): G06F16/22
Inventor 艾明李琳徐志成
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
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

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