CN110647566B - Intelligent importing method and device of template table and computer readable storage medium - Google Patents
Intelligent importing method and device of template table and computer readable storage medium Download PDFInfo
- Publication number
- CN110647566B CN110647566B CN201910831011.7A CN201910831011A CN110647566B CN 110647566 B CN110647566 B CN 110647566B CN 201910831011 A CN201910831011 A CN 201910831011A CN 110647566 B CN110647566 B CN 110647566B
- Authority
- CN
- China
- Prior art keywords
- user
- partition
- module
- program
- intelligent
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an artificial intelligence technology, and discloses an intelligent importing method of a template form, which comprises the following steps: receiving a module set and a table set, wherein the module set is stored in a partition A, the table set is stored in a partition B, the requirement information of a user is received, one or more modules which are the same as the requirement information are returned in the score partition A, after the user selects the module X, an interface which can be operated by the user is provided and fed back to the user, the user is prompted to carry out table configuration operation, after the user finishes the table configuration operation, an SQL check program is generated, a table is automatically called from the partition B according to the SQL check program and is configured in the module X, and the intelligent table import of the template is finished. The invention also provides an intelligent importing device of the template form and a computer readable storage medium. The invention can realize the high-efficiency import function of the template form.
Description
Technical Field
The invention relates to the technical field of artificial intelligence, in particular to a method and a device for intelligently grading life insurance of customers and a computer-readable storage medium.
Background
The modules are also called Application Programming Interface (API), and the modules are software programs written for realizing a certain requirement, so that the good modules can reduce the time and energy input ratio of a user, improve the cohesion of the whole development system, and reduce the occurrence probability of accidental abnormal conditions, thereby improving the maintainability and expansibility of the system. With the increasing large scale of software in recent years, more complex implementation requirements or implementation purposes are often written in advance for direct calling by users, so that the software is more convenient for the users. However, undeniably, a complex module often needs to call a plurality of tables, such as a stock price prediction module, even dozens of tables in a database need to be used in the whole software writing process, and in order to facilitate the module calling, in most cases, the tables in the module are directly written in the software and are not opened for users.
Disclosure of Invention
The invention provides an intelligent importing method and device of a template form and a computer readable storage medium, and mainly aims to receive demand information of a user and then accurately call and intelligently import the form based on the demand information.
In order to achieve the above object, the present invention provides an intelligent importing method of a template form, including:
receiving a module set and a table set, storing the module set into a partition A of a distributed database, and storing the table set into a partition B of the distributed database;
receiving the requirement information of a user, and inquiring whether the module set in the partition A comprises the requirement information of the user;
if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure, and prompting the user to input the requirement information again;
if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules;
after a user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, and prompting the user to carry out table configuration operation;
and after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
Optionally, the module set includes various software programs and remark text information of the software programs.
Optionally, the storing the module set into one of the partitions a includes:
and storing the various modules in a first storage area of the partition A, and storing the text information remarked by the various modules in a second storage area of the partition A.
Optionally, the prompting the user to perform a table configuration operation includes:
prompting a user to select corresponding table use according to self requirements;
when the table usage is selected, prompting a user to freely combine the table question, the table header and the table annotation;
and prompting a user to configure the size of the form body, and finishing the form configuration operation.
Optionally, the determining whether the SQL checking program is abnormal includes:
checking whether the grammar spelling of the SQL language in the SQL check program is correct or not;
checking whether the table object queried by the SQL language exists.
In addition, in order to achieve the above object, the present invention further provides an intelligent import apparatus for a template form, the apparatus including a memory and a processor, the memory storing therein an intelligent import program for a template form that is executable on the processor, the intelligent import program for a template form, when executed by the processor, implementing the steps of:
receiving a module set and a table set, storing the module set into a partition A of a distributed database, and storing the table set into a partition B of the distributed database;
receiving the requirement information of a user, and inquiring whether the module set in the partition A comprises the requirement information of the user;
if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure and prompting the user to re-input the requirement information;
if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules;
after a user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, and prompting the user to carry out table configuration operation;
and after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
Optionally, the module set includes various software programs and remark text information of the software programs.
Optionally, the storing the module set into one of the partitions a includes:
and storing the various modules in a first storage area of the partition A, and storing the text information remarked by the various modules in a second storage area of the partition A.
Optionally, the prompting the user to perform a table configuration operation includes:
prompting a user to select corresponding table use according to self requirements;
when the table usage is selected, prompting a user to freely combine the table question, the table header and the table notes;
and prompting a user to configure the size of the form body, and finishing the form configuration operation.
In addition, to achieve the above object, the present invention also provides a computer readable storage medium, which stores thereon an intelligent import program of a template form, the intelligent import program of the template form being executable by one or more processors to implement the steps of the intelligent import method of the template form as described above.
The invention separates the modules and the forms in the program, and respectively names the modules and the forms as the module set and the form set, thereby effectively improving the intelligence degree, preventing the occurrence of the phenomenon of directly writing the forms in the modules, simultaneously carrying out pairing in the module set through the requirement information of the user, and intelligently generating the forms required by the user based on the form configuration operation of the user, not only further improving the intelligent import function of the forms, but also improving the interactive feeling of the user. Therefore, the intelligent template table importing method, the intelligent template table importing device and the computer readable storage medium can realize an efficient intelligent template table importing function.
Drawings
Fig. 1 is a flowchart illustrating an intelligent importing method of a template form according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of binary storage of modules and text messages according to an embodiment of the present invention;
fig. 3 is a schematic internal structural diagram of an intelligent importing apparatus for template forms according to an embodiment of the present invention;
fig. 4 is a schematic module diagram of an intelligent import procedure of a template table in an intelligent import apparatus for a template table according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The invention provides an intelligent importing method of a template form. Fig. 1 is a schematic flow chart of a method for intelligently importing a template form according to an embodiment of the present invention. The method may be performed by an apparatus, which may be implemented by software and/or hardware.
In this embodiment, the method for intelligently importing the template form includes:
s1, receiving a module set and a table set, storing the module set into a partition A of a distributed database, and storing the table set into a partition B of the distributed database.
In a preferred embodiment of the present invention, the module set includes various modules and text information remarked for the various modules, and the various modules are software programs written for realizing different requirements, so that the module set is preferably a code set capable of realizing the various modules, and the code set can be written by using programming languages such as C + +, JAVA, python, and the like. If the module set can be based on the living needs of the user, the module set can comprise a two-dimension code quick scanning module, an account expenditure income recording module, a license plate recognition module, a stock price prediction module and other modules under different living needs of the user. Furthermore, the text information is a table for remarking various modules to meet what requirements and what specifications are needed, for example, the module a meets the requirement for license plate recognition, the license plate recognition uses a convolutional neural network, the convolutional neural network needs to perform convolution operation, and the convolution operation needs to call a table which can be configured by a user, so that the text information remarks that the module a meets the requirement for license plate recognition and needs a plurality of tables which can be configured by the user.
Preferably, the form set is divided according to form scale and form usage, wherein the form usage comprises an enterprise accounting form, an enterprise government external debt form, a land resource management form, a fixed asset checking and checking form, an enterprise new product research and development schedule, a personnel management form and the like, and a product sales statistical form; the table scale comprises a table question, a table header, a table body and a table note, wherein the table question of the product sales statistical table is the product sales statistical table, the table header comprises product numbers, product names, specifications, packaging modes and the like, the table body is the size of the table record content, and the table note is the description of part of the table header and the table body.
Preferably, the distributed database is a product of combining a database technology and a network technology, and has the characteristics of high flexibility and high expansibility.
Preferably, the distributed database is randomly partitioned from the computer storage medium into two partitions, assuming that the two partitions are A, B. Furthermore, an adding program is added between the partitions A, B, the adding connecting program can be written by using languages such as C + +, JAVA and the like, and the function is that when one of the partitions is read, content is added, content is deleted and the like, the connecting program immediately inputs the content of the partition into the cache region, so that the management of the partition content can be improved more quickly, and if the content in the partition a is read, the connecting program inputs the content of the partition B into the cache region.
Preferably, the various modules are stored in a first storage area in the partition a, the text information of the various module notes is stored in a second storage area of the partition a, and the various modules and the text information of the various module notes are stored separately in the partition a, and at the same time, the same storage binary number is used, the separate storage is for a purpose of faster subsequent query, and the use of the same storage binary number is for a purpose of reducing memory consumption, as shown in fig. 2 of the specification.
Further, the table set is stored in the partition B, the storage rule is that the table set is partitioned based on the use of the table, and then the table set and the header are separately stored, if the distributed database receives the table set with 7 table uses, including the enterprise accounting table, the enterprise government debt table, the land resource management table, the fixed asset inventory check and inventory table, the enterprise new product development schedule table, the personnel management table, and the product sales statistics table, the distributed database partitions the partition B into 7 storage areas and separately stores the table uses, and the distributed database only stores the table, the header, and the note part of each table in the table set, where the table of the product sales statistics table is the product sales statistics table, the header includes the product number, the product name, the specification, the packaging mode, and the like, the header is the size of the table record content, the column is assumed to be 7 rows and 9 columns, the note is the description of part of the header and the body, and the table is only stored in the distributed database, and the table notes are freely configured for users.
Preferably, the interface for user operation allows the user to select which form to use first, and then allows the user to combine the form header, form header and form label freely, and finally prompts the user to configure the form body.
S2, receiving the requirement information of the user, and inquiring whether the module set in the partition A comprises the requirement information of the user
If the received demand information of the user is stock price prediction, the invention inquires whether the text information of the module set in the partition A comprises the stock price prediction required by the user.
S3, if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure and prompting the user to re-input the requirement information
Preferably, the user is prompted to re-input the required information, and the failed text information can be called in a language broadcasting or screen display mode.
S4, if the module set in the subarea A comprises the requirement information of the user, returning one or more modules meeting the requirement information, and prompting the user to select one module from the one or more modules
Preferably, if the received demand information of the user is stock price prediction, the invention returns all modules capable of realizing the stock price prediction, and feeds back the text information of all modules capable of realizing the stock price prediction to the user in a screen or voice mode, and prompts tables of what specifications are needed by each module of the user, such as a module B needing 3 stock price fluctuation tables, a module C needing 4 stock price fluctuation tables, a module C needing 3 corporate government debt tables and the like.
And S5, after the user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, preferably prompting the user to perform table configuration operation, firstly enabling the user to select table purposes, then enabling the user to freely combine the table header, the table label and the table note, and finally prompting the user to configure the size of the table body, wherein the configured size of the table body is 5 rows and 7 columns.
S6, after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, and prompts the user to carry out the table configuration operation again if the SQL check program is abnormal
Preferably, after receiving the table configuration operation of the user, the distributed database generates an SQL check program based on the configured table, where the SQL check program is generated by an SQL Language, which is also called Structured Query Language (Structured Query Language), and the SQL Language is a database Query and programming Language for accessing data and querying, updating, and managing a relational database system. Preferably, the determining whether the SQL checking program is abnormal includes: checking whether grammar spelling of SQL language in an SQL check program is correct or not, checking whether a table object inquired by the SQL check program exists or not, if the SQL check program needs to inquire whether a land resource management table exists or not, if the grammar spelling is wrong or the object inquired by the SQL check program does not exist, throwing out program exception.
And S7, if the SQL check program is not abnormal, automatically calling a form from the partition B according to the SQL check program and configuring the form into the module X, so as to complete intelligent introduction of the form of the template.
Preferably, if the SQL check program is not abnormal, it is proved that the generated SQL check program can be executed normally, and the distributed database sequentially calls tables from the partition B and configures the tables into the module X based on the generated SQL check program, thereby completing the intelligent table importing function of the module. If the user requirement of the module X is stock price prediction, a table for placing stock fluctuation data is needed, so the invention calls the table for placing the stock fluctuation data based on the configuration information of the user, detects the area of the module X where the table needs to be placed through a program, and automatically configures the table into the area, thereby preventing the table in the module from being directly written into a body, a head and the like with fixed size, greatly increasing the operability of different modules, and improving the flexibility and the expandability.
The invention also provides an intelligent importing device of the template form. Fig. 3 is a schematic diagram illustrating an internal structure of an intelligent template form importing apparatus according to an embodiment of the present invention.
In this embodiment, the intelligent importing apparatus 1 of the template form may be a PC (Personal Computer), a terminal device such as a smart phone, a tablet Computer, or a mobile Computer, or may be a server. The intelligent importing device 1 of the template table at least comprises a memory 11, a processor 12, a communication bus 13 and a network interface 14.
The memory 11 includes at least one type of readable storage medium, which includes a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, and the like. The memory 11 may be an internal storage unit of the intelligent importing apparatus 1 of the template form in some embodiments, for example, a hard disk of the intelligent importing apparatus 1 of the template form. The memory 11 may also be an external storage device of the template form Smart entry device 1 in other embodiments, such as a plug-in hard disk provided on the template form Smart entry device 1, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. Further, the memory 11 may also include both an internal storage unit of the smart import apparatus 1 of the template table and an external storage device. The memory 11 may be used to store not only application software installed in the smart import apparatus 1 of the template form and various types of data, such as the code of the smart import program 01 of the template form, but also temporarily store data that has been output or is to be output.
The processor 12 may be a Central Processing Unit (CPU), a controller, a microcontroller, a microprocessor or other data Processing chip in some embodiments, and is used for running program codes stored in the memory 11 or Processing data, such as executing the intelligent import program 01 of the template table.
The communication bus 13 is used to realize connection communication between these components.
The network interface 14 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), typically used to establish a communication link between the apparatus 1 and other electronic devices.
Optionally, the apparatus 1 may further comprise a user interface, which may comprise a Display (Display), an input unit such as a Keyboard (Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or a display unit, is used to display information processed in the smart import apparatus 1 of the template form and to display a visual user interface.
Fig. 3 shows only the intelligent import apparatus 1 having the components 11 to 14 and the template form of the intelligent import program 01, and it will be understood by those skilled in the art that the structure shown in fig. 1 does not constitute a limitation of the intelligent import apparatus 1 of the template form, and may include fewer or more components than those shown in the drawing, or may combine some components, or may arrange different components.
In the embodiment of the apparatus 1 shown in fig. 3, the memory 11 stores an intelligent import program 01 of a template table; the processor 12 executes the smart import program 01 of the template table stored in the memory 11 to implement the following steps:
the method comprises the steps of firstly, receiving a module set and a table set, storing the module set into a partition A of the distributed database, and storing the table set into a partition B of the distributed database.
In a preferred embodiment of the present invention, the module set includes various modules and text information remarked for the various modules, and the various modules are software programs written for realizing different requirements, so that the module set is preferably a code set capable of realizing the various modules, and the code set can be written by using programming languages such as C + +, JAVA, python, and the like. If the module set can be based on the living needs of the user, the module set can comprise a two-dimension code quick scanning module, an account expenditure income recording module, a license plate recognition module, a stock price prediction module and other modules under different living needs of the user. Furthermore, the text information is a table for remarking various modules to meet what requirements and what specifications are needed, for example, the module a meets the requirement for license plate recognition, the license plate recognition uses a convolutional neural network, the convolutional neural network needs to perform convolution operation, and the convolution operation needs to call a table which can be configured by a user, so that the text information remarks that the module a meets the requirement for license plate recognition and needs a plurality of tables which can be configured by the user.
Preferably, the form set is divided according to form scale and form usage, wherein the form usage comprises enterprise accounting form, enterprise government debt form, land resource management form, fixed asset checking and checking form, enterprise new product development schedule, personnel management form and the like, and product sales statistical form; the table scale comprises a table question, a table header, a table body and a table note, wherein the table question of the product sales statistical table is the product sales statistical table, the table header comprises product numbers, product names, specifications, packaging modes and the like, the table body is the size of the table record content, and the table note is the description of part of the table header and the table body.
Preferably, the distributed database is a product of combining a database technology and a network technology, and has the characteristics of high flexibility and high expansibility.
Preferably, the distributed database is randomly partitioned from the computer storage medium into two partitions, assuming that the two partitions are A, B. Furthermore, an adding program is added between the partitions A, B, the adding connecting program can be written by using languages such as C + +, JAVA and the like, and the function is that when one of the partitions is read, content is added, content is deleted and the like, the connecting program immediately inputs the content of the partition into the cache region, so that the management of the content of the partition can be improved more quickly, and if the content in the partition A is read, the connecting program inputs the content of the partition B into the cache region.
Preferably, the various modules are stored in a first storage area in the partition a, the text information of the various module notes is stored in a second storage area of the partition a, and the various modules and the text information of the various module notes are stored separately in the partition a, and at the same time, the same storage binary number is used, the separate storage is for a purpose of faster subsequent query, and the use of the same storage binary number is for a purpose of reducing memory consumption, as shown in fig. 2 of the specification.
Further, the table set is stored in the partition B, the storage rule is that the table set is partitioned based on the use of the table, and then the table set and the header are separately stored, if the distributed database receives the table set with 7 table uses, including the enterprise accounting table, the enterprise government debt table, the land resource management table, the fixed asset inventory check and inventory table, the enterprise new product development schedule table, the personnel management table, and the product sales statistics table, the distributed database partitions the partition B into 7 storage areas and separately stores the table uses, and the distributed database only stores the table, the header, and the note part of each table in the table set, where the table of the product sales statistics table is the product sales statistics table, the header includes the product number, the product name, the specification, the packaging mode, and the like, the header is the size of the table record content, the column is assumed to be 7 rows and 9 columns, the note is the description of part of the header and the body, and the table is only stored in the distributed database, and the table notes are freely configured for users.
Preferably, the interface for user operation firstly allows the user to select which form to use, then allows the user to freely combine the form header, form header and form label, and finally prompts the user to configure the form body.
Step two, receiving the requirement information of the user, and inquiring whether the module set in the partition A comprises the requirement information of the user
If the received demand information of the user is stock price prediction, the invention inquires whether the text information of the module set in the partition A comprises the stock price prediction required by the user.
Step three, if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure and prompting the user to re-input the requirement information
Preferably, the user is prompted to re-input the required information, and the failed text information can be called in a language broadcasting or screen display mode.
Step four, if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules
Preferably, if the received demand information of the user is stock price prediction, the invention returns all modules capable of realizing the stock price prediction, and feeds back the text information of all modules capable of realizing the stock price prediction to the user in a screen or voice mode, and prompts tables of what specifications are needed by each module of the user, such as a module B needing 3 stock price fluctuation tables, a module C needing 4 stock price fluctuation tables, a module C needing 3 corporate government debt tables and the like.
Step five, after the user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, and prompting the user to carry out table configuration operation
Preferably, the user is prompted to perform the table configuration operation to allow the user to select the table purpose, then allow the user to freely combine the table header, the table body and the table notes, and finally prompt the user to configure the table body size, for example, the configured table body size is 5 rows and 7 columns.
Step six, after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, and prompts the user to carry out the table configuration operation again if the SQL check program is abnormal
Preferably, after receiving the table configuration operation of the user, the distributed database generates an SQL check program based on the configured table, where the SQL check program is generated by an SQL Language, the SQL Language is also called Structured Query Language (Structured Query Language), and the SQL Language is a database Query and programming Language for accessing data and querying, updating, and managing a relational database system. Preferably, the determining whether the SQL checking program is abnormal includes: checking whether grammar spelling of SQL language in an SQL check program is correct or not, checking whether a table object inquired by the SQL check program exists or not, if the SQL check program needs to inquire whether a land resource management table exists or not, if the grammar spelling is wrong or the object inquired by the SQL check program does not exist, throwing out program exception.
And seventhly, if the SQL check program is not abnormal, automatically calling a form from the partition B according to the SQL check program and configuring the form into the module X, and finishing intelligent import of the form of the template.
Preferably, if the SQL check program is not abnormal, it is proved that the generated SQL check program can be executed normally, and the distributed database sequentially calls tables from the partition B and configures the tables into the module X based on the generated SQL check program, thereby completing the intelligent table importing function of the module. If the user requirement realized by the module X is stock price prediction, a table for placing stock fluctuation data is needed, so that after the table for placing the stock fluctuation data is called based on the configuration information of the user, the area in the module X, in which the table needs to be placed, is detected through a program, and the table is automatically configured into the area, so that the table in the module can be prevented from being directly written and killed into a body, a head and the like with fixed sizes, the operability of different modules is greatly increased, and the flexibility and the expandability are improved.
Alternatively, in other embodiments, the intelligent importing program of the template form may also be divided into one or more modules, and one or more modules are stored in the memory 11 and executed by one or more processors (in this embodiment, the processor 12) to implement the present invention.
For example, referring to fig. 4, a schematic diagram of a program module of an intelligent import program of a template table in an embodiment of an intelligent import apparatus of a template table according to the present invention is shown, in this embodiment, the intelligent import program of a template table may be divided into a data receiving module 10, a requirement information matching module 20, a table configuration module 30, and a table intelligent import module 40, which exemplarily:
the data receiving module 10 is configured to: receiving a module set and a table set, storing the module set into a partition A of a distributed database, and storing the table set into a partition B of the distributed database.
The requirement information matching module 20 is configured to: receiving demand information of a user, inquiring whether a module set in the partition A comprises the demand information of the user, if the module set in the partition A does not comprise the demand information of the user, returning a message of module call failure, and prompting the user to input the demand information again, if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules.
The table configuration module 30 is configured to: and after the user selects one of the modules X, feeding the interface for the user to operate back to the user, and prompting the user to perform table configuration operation.
The intelligent table importing module 40 is configured to: and after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
The functions or operation steps implemented by the data receiving module 10, the requirement information matching module 20, the table configuration module 30, the intelligent table importing module 40 and other program modules when executed are substantially the same as those of the above embodiments, and are not described herein again.
Furthermore, an embodiment of the present invention further provides a computer-readable storage medium, where an intelligent import program of a template table is stored on the computer-readable storage medium, where the intelligent import program of the template table is executable by one or more processors to implement the following operations:
receiving a module set and a table set, storing the module set into a partition A of a distributed database, and storing the table set into a partition B of the distributed database.
Receiving demand information of a user, inquiring whether a module set in the partition A comprises the demand information of the user, if the module set in the partition A does not comprise the demand information of the user, returning a message of module call failure, and prompting the user to input the demand information again, if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules.
And after the user selects one of the modules X, feeding the interface for the user to operate back to the user, and prompting the user to perform table configuration operation.
And after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
It should be noted that the above-mentioned numbers of the embodiments of the present invention are merely for description, and do not represent the merits of the embodiments. And the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising a … …" does not exclude the presence of another identical element in a process, apparatus, article, or method that comprises the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention or portions thereof contributing to the prior art may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) as described above and includes several instructions for enabling a terminal device (which may be a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, and all equivalent structures or equivalent processes performed by the present invention or directly or indirectly applied to other related technical fields are also included in the scope of the present invention.
Claims (9)
1. A method for intelligently importing a template form is characterized by comprising the following steps:
receiving a module set and a table set, storing the module set into a partition A of a distributed database, storing the table set into a partition B of the distributed database, and adding a program between the partitions A, B;
receiving the requirement information of a user, and inquiring whether the module set in the partition A comprises the requirement information of the user;
if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure, and prompting the user to input the requirement information again;
if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules;
after a user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, and prompting the user to carry out table configuration operation, wherein the interface comprises a function of prompting the user to select a corresponding table purpose according to the requirement of the user;
and after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
2. The intelligent importing method of the template form according to claim 1, wherein the module set includes a software program and remark text information of the software program.
3. The method of intelligent import of template forms of claim 2, wherein storing the set of modules into partition a of a distributed database comprises:
and storing the software program in a first storage area of the partition A, and storing the text information remarked by the software program in a second storage area of the partition A.
4. The method for intelligently importing template forms according to claim 1, wherein the determining whether the SQL checking program is abnormal comprises:
checking whether the grammar spelling of the SQL language in the SQL check program is correct or not;
checking whether the table object queried by the SQL language exists.
5. An intelligent import apparatus of a template form, the apparatus comprising a memory and a processor, the memory storing an intelligent import program of the template form, the intelligent import program being executable on the processor, the intelligent import program of the template form implementing the following steps when being executed by the processor:
receiving a module set and a table set, storing the module set into a partition A of a distributed database, storing the table set into a partition B of the distributed database, and adding a program between the partitions A, B;
receiving the requirement information of a user, and inquiring whether the module set in the partition A comprises the requirement information of the user;
if the module set in the partition A does not comprise the requirement information of the user, returning a message of module calling failure, and prompting the user to input the requirement information again;
if the module set in the partition A comprises the demand information of the user, returning one or more modules meeting the demand information, and prompting the user to select one module from the one or more modules;
after a user selects one of the modules X, feeding back an interface which is provided by the distributed database in the partition B and can be operated by the user to the user, and prompting the user to carry out table configuration operation, wherein the interface comprises a function of prompting the user to select a corresponding table purpose according to the requirement of the user;
and after the user finishes the table configuration operation, the distributed database generates an SQL check program based on the table configuration operation, judges whether the SQL check program is abnormal or not, prompts the user to carry out the table configuration operation again if the SQL check program is abnormal, and automatically calls a table from the partition B according to the SQL check program and configures the table into the module X if the SQL check program is not abnormal, so as to finish the intelligent table import of the template.
6. The intelligent importing device for the template form, as recited in claim 5, wherein the set of modules includes a software program and remark text information of the software program.
7. The intelligent import apparatus for template form according to claim 5 or 6, wherein said storing the module set into one of the partitions A comprises:
and storing the software program in a first storage area of the partition A, and storing the text information remarked by the software program in a second storage area of the partition A.
8. The apparatus for intelligent import of template forms according to claim 5, wherein said prompting the user to perform form configuration operations comprises:
prompting a user to select corresponding table use according to self requirements;
when the table usage is selected, prompting a user to freely combine the table question, the table header and the table annotation;
and prompting a user to configure the size of the form body, and finishing the form configuration operation.
9. A computer-readable storage medium, wherein the computer-readable storage medium has stored thereon an intelligent import program of a template form, the intelligent import program of the template form being executable by one or more processors to implement the steps of the intelligent import method of the template form according to any one of claims 1 to 4.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910831011.7A CN110647566B (en) | 2019-09-03 | 2019-09-03 | Intelligent importing method and device of template table and computer readable storage medium |
| PCT/CN2020/112342 WO2021043091A1 (en) | 2019-09-03 | 2020-08-30 | Intelligent import method and apparatus for template table, and electronic device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910831011.7A CN110647566B (en) | 2019-09-03 | 2019-09-03 | Intelligent importing method and device of template table and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110647566A CN110647566A (en) | 2020-01-03 |
| CN110647566B true CN110647566B (en) | 2023-04-14 |
Family
ID=68991525
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910831011.7A Active CN110647566B (en) | 2019-09-03 | 2019-09-03 | Intelligent importing method and device of template table and computer readable storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN110647566B (en) |
| WO (1) | WO2021043091A1 (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110647566B (en) * | 2019-09-03 | 2023-04-14 | 平安科技（深圳）有限公司 | Intelligent importing method and device of template table and computer readable storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108763505A (en) * | 2018-05-30 | 2018-11-06 | 平安普惠企业管理有限公司 | List data exchange method, device, computer equipment and storage medium |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9256219B2 (en) * | 2009-08-11 | 2016-02-09 | Fisher-Rosemount Systems, Inc. | System configuration using templates |
| US9355146B2 (en) * | 2012-06-29 | 2016-05-31 | International Business Machines Corporation | Efficient partitioned joins in a database with column-major layout |
| US8949224B2 (en) * | 2013-01-15 | 2015-02-03 | Amazon Technologies, Inc. | Efficient query processing using histograms in a columnar database |
| CN103605663B (en) * | 2013-10-22 | 2017-02-15 | 芜湖大学科技园发展有限公司 | General database checking and metadata loading method |
| US10216768B1 (en) * | 2014-02-17 | 2019-02-26 | Amazon Technologies, Inc. | Table and index communications channels |
| CN106446019B (en) * | 2016-08-27 | 2019-09-17 | 南京安元科技有限公司 | A kind of software function treating method and apparatus |
| CN108241607A (en) * | 2018-01-22 | 2018-07-03 | 中国平安人寿保险股份有限公司 | Automatically imported method, server and the storage medium of test of heuristics case |
| CN109933311A (en) * | 2019-03-20 | 2019-06-25 | 青岛叁壹信息科技有限公司 | A kind of information system creation method and relevant apparatus |
| CN110647566B (en) * | 2019-09-03 | 2023-04-14 | 平安科技（深圳）有限公司 | Intelligent importing method and device of template table and computer readable storage medium |
-
2019
- 2019-09-03 CN CN201910831011.7A patent/CN110647566B/en active Active
-
2020
- 2020-08-30 WO PCT/CN2020/112342 patent/WO2021043091A1/en active Application Filing
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108763505A (en) * | 2018-05-30 | 2018-11-06 | 平安普惠企业管理有限公司 | List data exchange method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110647566A (en) | 2020-01-03 |
| WO2021043091A1 (en) | 2021-03-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110764942B (en) | Multi-kind data verification method, device, computer system and readable storage medium | |
| CN101102565B (en) | A processing method, device and equipment of user data in communication terminal | |
| CN107864301B (en) | Client label management method, system, computer equipment and storage medium | |
| CN110457363B (en) | Query method, device and storage medium based on distributed database | |
| WO2019085474A1 (en) | Calculation engine implementing method, electronic device, and storage medium | |
| CN108765087B (en) | Order asynchronous processing method, server and storage medium | |
| CN108345512A (en) | Data verification method, server and storage medium | |
| CN109471857A (en) | Data modification method, device and storage medium based on SQL statement | |
| CN109271410B (en) | Bank receipt extraction method and device and computer readable storage medium | |
| CN108874464B (en) | Automatic scanning assembly method and device for middleware and storage medium | |
| CN110457346B (en) | Data query method, device and computer readable storage medium | |
| CN112637305B (en) | Data storage and query method, device, equipment and medium based on cache | |
| CN110647316B (en) | Method and device for generating universal business object, computer equipment and storage medium | |
| CN109254808A (en) | Interface call method, device and computer readable storage medium | |
| CN110837531B (en) | Data source read-write separation method and device and computer readable storage medium | |
| CN110647566B (en) | Intelligent importing method and device of template table and computer readable storage medium | |
| CN113268500A (en) | Service processing method and device and electronic equipment | |
| CN113051389B (en) | Knowledge pushing method and device | |
| CN109785867B (en) | Double-recording flow configuration method and device, computer equipment and storage medium | |
| CN109992980B (en) | User authority multi-model management method | |
| CN110647666B (en) | Intelligent matching method and device for templates and formulas and computer readable storage medium | |
| CN112269473B (en) | Man-machine interaction method and system based on flexible scene definition | |
| CN115510052A (en) | Dynamic form and database-based dynamic verification method and system | |
| CN115186151A (en) | Resume screening method, device, equipment and storage medium | |
| CN114548886A (en) | Part management method, device and system and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |