CN110647566A - 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
- CN110647566A CN110647566A CN201910831011.7A CN201910831011A CN110647566A CN 110647566 A CN110647566 A CN 110647566A CN 201910831011 A CN201910831011 A CN 201910831011A CN 110647566 A CN110647566 A CN 110647566A
- Authority
- CN
- China
- Prior art keywords
- user
- partition
- module
- intelligent
- template
- 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.)
- Granted
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 a customer and a computer-readable storage medium.
Background
The modules are also commonly called Application Programming Interfaces (APIs), the modules are software programs written for realizing a certain requirement, and good modules can reduce the time and effort 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 form 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.
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 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 form 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 module and the form in the program, and respectively names the module set and the form set, thereby effectively improving the intelligent degree, preventing the occurrence of the phenomenon that the form is directly written in the module, simultaneously carrying out pairing in the module set through the requirement information of the user, and intelligently generating the form required by the user based on the form configuration operation of the user, not only further improving the intelligent import function of the form, but also improving the interactive feeling of the user. Therefore, the intelligent importing method, the intelligent importing device and the computer-readable storage medium of the template form provided by the invention can realize the efficient intelligent importing function of the template form.
Drawings
Fig. 1 is a schematic flowchart of 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 in a partition A of the distributed database, and storing the table set in a partition B of the distributed database.
In the 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 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 recorded content of the table, 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, which are assumed to be A, B. Furthermore, an adding program is added between the partitions A, B, the adding connecting program can be written in languages of 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, 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.
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 separately stored in the partition a, and simultaneously, the same storage binary number is used, the purpose of separate storage is faster in subsequent query, and the purpose of using the same storage binary number is to reduce 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 table usage, and then the table set and the header are separately stored based on the table, if the distributed database receives the table sets with 7 table usages, such as the enterprise accounting table, the enterprise government debt table, the land resource management table, the fixed asset inventory table, the enterprise new product development schedule, the personnel management table, and the product sales statistical table, the distributed database partitions the partition B into 7 storage areas and separately stores according to the table usage, and the distributed database only stores the table, the header and the note part of each table in the table set, the table of the product sales statistical table is the product sales statistical table, and the header includes the product number, the product name, the specification, the packaging mode, and the like, and the form body is the size of the record content of the form, is assumed to be 7 rows and 9 columns, and the note is the description of part of the form head and the form body, so that the distributed database only stores the form header, the form head and the note, wherein the form body is freely configured by a subsequent user.
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.
S2, receiving the requirement information of the user, 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 include 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 partition A includes 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.
S5, after the user selects one of the modules X, feeding back an interface, which is provided in the partition B and is available for user operation, to the user, and prompting the user to perform a table configuration operation, preferably, prompting the user to perform the table configuration operation to allow the user to select a table purpose, allow the user to freely combine a table title, a table header, and a table label, and finally prompting the user to configure a table body size, for example, the configured table body size is 5 rows and 7 columns.
S6, after the user completes 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, and prompts the user to perform 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 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 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 normally executed, and the distributed database sequentially calls tables from the partition B and configures the tables to the module X based on the generated SQL check program, thereby completing a table intelligent import 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 import apparatus 1 of the template table in some embodiments, for example, a hard disk of the intelligent import apparatus 1 of the template table. 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 Memory 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 executing program codes stored in the memory 11 or Processing data, such as executing the smart import 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 smart import apparatus 1 of the template form having the components 11 to 14 and the smart import program 01 of the template form, 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 smart import apparatus 1 of the template form, and may include fewer or more components than those shown, or combine some components, or 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 a distributed database, and storing the table set into a partition B of the distributed database.
In the 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 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 recorded content of the table, 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, which are assumed to be A, B. Furthermore, an adding program is added between the partitions A, B, the adding connecting program can be written in languages of 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, 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.
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 separately stored in the partition a, and simultaneously, the same storage binary number is used, the purpose of separate storage is faster in subsequent query, and the purpose of using the same storage binary number is to reduce 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 table usage, and then the table set and the header are separately stored based on the table, if the distributed database receives the table sets with 7 table usages, such as the enterprise accounting table, the enterprise government debt table, the land resource management table, the fixed asset inventory table, the enterprise new product development schedule, the personnel management table, and the product sales statistical table, the distributed database partitions the partition B into 7 storage areas and separately stores according to the table usage, and the distributed database only stores the table, the header and the note part of each table in the table set, the table of the product sales statistical table is the product sales statistical table, and the header includes the product number, the product name, the specification, the packaging mode, and the like, and the form body is the size of the record content of the form, is assumed to be 7 rows and 9 columns, and the note is the description of part of the form head and the form body, so that the distributed database only stores the form header, the form head and the note, wherein the form body is freely configured by a subsequent user.
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, first, the user selects the table purpose, then, the user freely combines the table header, the table heading and the table annotation, and finally, the user is prompted to configure the size of the table body, for example, the configured size of the table body 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 normally executed, and the distributed database sequentially calls tables from the partition B and configures the tables to the module X based on the generated SQL check program, thereby completing a table intelligent import 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.
Alternatively, in other embodiments, the smart import program of the template form may be further divided into one or more modules, and the 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 an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes 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 solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., 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 not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
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, 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.
2. The intelligent import method for template forms according to claim 1, wherein the set of modules comprises various software programs and remarked text information of the software programs.
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 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.
4. The intelligent import method of the template form according to claim 1 or 2, wherein the prompting the user to perform the form configuration operation 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 notes;
and prompting a user to configure the size of the form body, and finishing the form configuration operation.
5. The intelligent import method for template table according to claim 4, wherein 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.
6. 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, 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.
7. The intelligent import apparatus for template form according to claim 6, wherein the module set comprises various software programs and remark text information of the software programs.
8. The intelligent import apparatus for template form according to claim 6 or 7, wherein said storing the module set into one of the partitions A comprises:
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.
9. The apparatus for intelligent import of template forms according to claim 8, wherein said prompting a 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 notes;
and prompting a user to configure the size of the form body, and finishing the form configuration operation.
10. 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 5.
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 true CN110647566A (en) | 2020-01-03 |
| CN110647566B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021043091A1 (en) * | 2019-09-03 | 2021-03-11 | 平安科技（深圳）有限公司 | Intelligent import method and apparatus for template table, and electronic device and computer readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140006380A1 (en) * | 2012-06-29 | 2014-01-02 | International Business Machines Corporation | Efficient partitioned joins in a database with column-major layout |
| CN103605663A (en) * | 2013-10-22 | 2014-02-26 | 芜湖大学科技园发展有限公司 | General database checking and metadata loading method |
| US20140201129A1 (en) * | 2013-01-15 | 2014-07-17 | Amazon Technologies, Inc. | Efficient query processing using histograms in a columnar database |
| CN108241607A (en) * | 2018-01-22 | 2018-07-03 | 中国平安人寿保险股份有限公司 | Automatically imported method, server and the storage medium of test of heuristics case |
| CN108763505A (en) * | 2018-05-30 | 2018-11-06 | 平安普惠企业管理有限公司 | List data exchange method, device, computer equipment and storage medium |
| US10216768B1 (en) * | 2014-02-17 | 2019-02-26 | Amazon Technologies, Inc. | Table and index communications channels |
| CN109933311A (en) * | 2019-03-20 | 2019-06-25 | 青岛叁壹信息科技有限公司 | A kind of information system creation method and relevant apparatus |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9256219B2 (en) * | 2009-08-11 | 2016-02-09 | Fisher-Rosemount Systems, Inc. | System configuration using templates |
| CN106446019B (en) * | 2016-08-27 | 2019-09-17 | 南京安元科技有限公司 | A kind of software function treating method and 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 (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140006380A1 (en) * | 2012-06-29 | 2014-01-02 | International Business Machines Corporation | Efficient partitioned joins in a database with column-major layout |
| US20140201129A1 (en) * | 2013-01-15 | 2014-07-17 | Amazon Technologies, Inc. | Efficient query processing using histograms in a columnar database |
| CN103605663A (en) * | 2013-10-22 | 2014-02-26 | 芜湖大学科技园发展有限公司 | General database checking and metadata loading method |
| US10216768B1 (en) * | 2014-02-17 | 2019-02-26 | Amazon Technologies, Inc. | Table and index communications channels |
| CN108241607A (en) * | 2018-01-22 | 2018-07-03 | 中国平安人寿保险股份有限公司 | Automatically imported method, server and the storage medium of test of heuristics case |
| CN108763505A (en) * | 2018-05-30 | 2018-11-06 | 平安普惠企业管理有限公司 | List data exchange method, device, computer equipment and storage medium |
| CN109933311A (en) * | 2019-03-20 | 2019-06-25 | 青岛叁壹信息科技有限公司 | A kind of information system creation method and relevant apparatus |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021043091A1 (en) * | 2019-09-03 | 2021-03-11 | 平安科技（深圳）有限公司 | Intelligent import method and apparatus for template table, and electronic device and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110647566B (en) | 2023-04-14 |
| 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 | |
| JP6682638B2 (en) | Information input method, information input device, and information input system | |
| US20100211539A1 (en) | System and method for building a data warehouse | |
| CN111144731A (en) | Dynamic implementation method and device of workflow and computer readable storage medium | |
| CN107864301B (en) | Client label management method, system, computer equipment and storage medium | |
| CN110716951B (en) | Label configuration method, device and equipment convenient to configure and storage medium | |
| CN108345512A (en) | Data verification method, server and storage medium | |
| CN110334144B (en) | Message display method, device, computer equipment and storage medium | |
| CN109471857A (en) | Data modification method, device and storage medium based on SQL statement | |
| CN109544266B (en) | Product data pushing method, device and computer readable storage medium | |
| CN109271410B (en) | Bank receipt extraction method and device and computer readable storage medium | |
| US10803390B1 (en) | Method for the management of artifacts in knowledge ecosystems | |
| CN109254808A (en) | Interface call method, device and computer readable storage medium | |
| CN113127621B (en) | Method, device, equipment and storage medium for pushing dialogue module | |
| CN111339166A (en) | Word stock-based matching recommendation method, electronic device and storage medium | |
| CN110647566B (en) | Intelligent importing method and device of template table and computer readable storage medium | |
| US11151088B2 (en) | Systems and methods for verifying performance of a modification request in a database system | |
| CN113051389B (en) | Knowledge pushing method and device | |
| CN105100372A (en) | Conference recording method and mobile terminal | |
| CN111078564B (en) | UI test case management method, device, computer equipment and computer readable storage medium | |
| CN111598707A (en) | Page generation method and electronic equipment | |
| CN113343713B (en) | Intention recognition method and device, computer equipment and storage medium | |
| 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 | |
| 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 |