Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Relational database query method, device and equipment and storage medium

A query method and database technology, applied in relational database query methods, equipment and storage media, and device fields, can solve problems affecting the efficiency of programmer development and testing work, achieve rapid response to business needs, reduce workload, The effect of improving experience

Active Publication Date: 2019-05-03
PING AN TECH (SHENZHEN) CO LTD
View PDF10 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a relational database query method, device, equipment and storage medium, aiming to solve the problem that when the database structure changes, the programmer must manually modify the source code related to the database query statement in the current project, affecting The problem of the efficiency of programmer development and testing work

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
  • Relational database query method, device and equipment and storage medium
  • Relational database query method, device and equipment and storage medium
  • Relational database query method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0046] refer to figure 1 , figure 1 It is a schematic diagram of a device used for relational database query in the hardware operating environment involved in the solution of the embodiment of the present invention.

[0047] Such as figure 1 As shown, the device for relational database query may include: a processor 1001 , such as a CPU, a communication bus 1002 , a user interface 1003 , a network interface 1004 , and a memory 1005 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. Optionally, the network interface 1004 may include a standard...

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 relational database query method, device and equipment and a storage medium. The method comprises the steps that when it is detected that connection between a current projectand a database is successful, a database management system function is called to obtain an original data result set of the database; Reading metadata of the database from an original data result set,and generating a metadata model based on the metadata and through the database management system function; Creating and constructing a query function based on the metadata model; the structure of thedatabase is changed; a programmer does not need to modify a source code related to the database query statement in the current project; and the database can be queried by directly calling the construction query function, so that the workload of a programmer in development and testing is effectively reduced, meanwhile, the service requirement can be quickly responded, and the experience degree ofa user on project software is improved.

Description

technical field [0001] The invention relates to the field of computer information technology, in particular to a relational database query method, device, equipment and storage medium. Background technique [0002] A relational database is a database based on a relational model, which uses mathematical concepts and methods such as set algebra to process data in the database. Various entities in the real world and various links between entities are represented by relational models. The standard data query language SQL (Structured Query Language) is a language based on relational databases, which executes the retrieval and operation of data in relational databases. The relational model consists of three parts: relational data structure, relational operation set, and relational integrity constraints. A relational database is a database composed of multiple two-dimensional row-column tables that can be connected to each other. Therefore, every time a relational database is es...

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): G06F8/20G06F16/28G06F16/242G06F16/21
CPCY02D10/00
Inventor 邢方山
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products