Unlock instant, AI-driven research and patent intelligence for your innovation.

A database access low code generation middleware system

A code generation and database technology, applied in the low-code field, can solve problems affecting project stability and availability, lack of database access systems, etc., to achieve the effect of saving time and effort, saving data increase, and saving time

Pending Publication Date: 2021-02-09
上海宝旗信息科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Most of the database access systems currently on the market need to write data access codes every time they access the database. The amount of code for adding, deleting, and modifying data is huge, and the algorithm functions for searching, paging, and sorting with multiple fields and conditions occupy a lot of program space. A lot of time spent by staff, frequent code modification will affect the stability and usability of the project, and the traditional database access system is lacking, therefore, a database access low code generation middleware system is proposed to solve the above problems

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
  • A database access low code generation middleware system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0020] see figure 1 , the present invention provides a technical solution:

[0021] A low-code generation middleware system for database access, including a database 1, a middleware system 2, a database access code package 3, and a system item 4, wherein the database 1 includes a definition table 101, an index 102, a foreign key 103, and a view 104, storage mode 105 and table structure 106, and the definition table 101 contains the read and write methods of definition index 102, foreign key 103, view 104, storage mode 105 and table structure 106, this setting is convenient for middleware system 2 to read , the database access code package 3 includes an access log 301, a retrieval algorithm function 302, a sorting algorithm function 303, and a paging algorithm function 304. This setting is convenient for accessing and operating the database 1. The middleware system 2 accesses the definition table 101 to identify content such as index 102, foreign key 103, view 104, storage mod...

Embodiment 2

[0023] The same parts of Embodiment 2 and Embodiment 1 will not be described in detail. The difference is that when the search algorithm function 302 fails to access the database 1, it will output "database access code package 3 needs to be updated", and the database access code package 3 will send feedback information to the middle Software system 2, middleware system 2 accesses database 1 and updates database access code package 3, system project 4 judges through access log 301 and calls retrieval algorithm function 302 again when accessing database 1 fails, and directly outputs "insufficient authority" or "database 1 exception" , to avoid infinite loops and reduce resource usage.

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 relates to the technical field of low codes, in particular to a database access low code generation middleware system, which comprises a database, a middleware system, a database accesscode packet and a system project, and is characterized in that the database comprises a definition table, indexes, foreign keys, views, a storage mode and a table structure; by the set retrieval algorithm function, a sorting algorithm function and a paging algorithm function, the functions of retrieval, paging and sorting according to various fields and various conditions in a system project are realized, so that the time of programmers is greatly saved; the application software can directly add the database access code packet into the system project for compiling or adding reference for use,data access codes do not need to be written again, a large number of codes used for data addition, deletion and modification can be saved, access recording is achieved through the set access log. Themiddleware system calls the access log as a reference, so that the time required for generating the database access code packet is saved.

Description

technical field [0001] The invention relates to the field of low-code technology, in particular to a low-code generation middleware system for database access. Background technique [0002] Low-code development platform (LCDP) is a development platform that can quickly generate applications without coding (0 code) or with a small amount of code. An approach to application development through visualization (refer to Visual Programming Language), which enables developers with different experience levels to create web and mobile applications through a graphical user interface, using drag-and-drop components and model-driven logic, so , there is a growing need for a low-code generation middleware system for database access. [0003] Most of the database access systems currently on the market need to write data access codes every time they access the database. The amount of code for adding, deleting, and modifying data is huge, and the algorithm functions for searching, paging, ...

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/30G06F9/54
CPCG06F8/30G06F9/546G06F2209/547
Inventor 曹臻睿冯坚波苏群
Owner 上海宝旗信息科技有限公司