A database interface conversion system

Abstract

The present invention relates to the field of databases, and in particular to a database interface conversion system, comprising: a receiving module for receiving initial data information collected by a data collection terminal; an interactive module for receiving configuration instructions input by a user, and generating a configuration relationship component according to the configuration instructions; a conversion module for parsing the initial data information, obtaining initial parsing information, and then processing the initial parsing information into pre-processed parsing information that can be identified by a storage structure component; wherein the interactive module is also used to display the pre-processing parsing information, and if a confirmation signal is received when the interactive module displays the pre-processing parsing information, the conversion module calls the storage structure component to process the pre-processing parsing information into standardized storage structure information; and also includes a database module for storing standardized storage structure information. The present application provides a database interface conversion system that is convenient for enterprise managers to use.

Description

Technical Field

[0001] The invention relates to the field of databases, and in particular to a database interface conversion system. Background Art

[0002] A database is a "warehouse that organizes, stores and manages data according to data structures". It is a collection of large amounts of data that is stored in a computer for a long time, organized, shareable and uniformly managed. The database is a key link in the upgrade of enterprise informationization. During the upgrade of information management, enterprises will flexibly select various data acquisition terminals according to the enterprise's informationization stage, current technical level and their own needs. The information collected by various data acquisition terminals is stored in the database established by the enterprise itself. The enterprise's managers can improve the enterprise's production situation and realize the enterprise's information management by calling the relevant data in the database and using specific analysis methods.

[0003] However, in the above situation, the communication method between the data acquisition terminal and the database needs to be handled by professional personnel according to the actual situation each time, which seriously restricts the flexibility and convenience of the data acquisition terminal. For enterprise managers, they need to manage the enterprise flexibly according to market demand, and have different requirements for the type of data acquisition terminal at different times.

[0004] Although all current databases have various interfaces available to adapt to various situations, the existing interfaces are targeted at developers with professional knowledge. Professionals are required to find suitable interfaces and be familiar with the specific usage of the interfaces before they can use the acquisition terminal to collect data and upload them. However, developers are not the actual users. The actual users should be the managers of the company. Some managers of some companies (especially traditional companies) are not very good at computer operation. For these managers, the technical threshold makes it difficult for them to effectively process and upload data.

[0005] Therefore, there is an urgent need for a database interface conversion system that can be conveniently used by enterprise managers. Summary of the invention

[0006] The technical problem solved by the present invention is to provide a database interface conversion system which is convenient for enterprise managers to use.

[0007] The basic scheme provided by the present invention is:

[0008] A database interface conversion system, comprising:

[0009] A receiving module, used for receiving initial data information collected by a data collection terminal;

[0010] An interactive module, used to receive configuration instructions input by a user, and generate configuration relationship components according to the configuration instructions, wherein the configuration relationship components include an initial parsing component of initial data information and a standardized storage structure component of a database, and a mapping relationship between the two;

[0011] The conversion module is used to call the initial parsing component to parse the initial data information to obtain the initial parsing information, and then call the mapping relationship between the initial parsing component and the storage structure component to process the initial parsing information into pre-processed parsing information that can be recognized by the storage structure component;

[0012] The interactive module is also used to display the preprocessed parsing information. If the interactive module receives a confirmation signal when displaying the preprocessed parsing information, the conversion module calls the storage structure component to process the preprocessed parsing information into standardized storage structure information.

[0013] It also includes a database module for storing standardized storage structure information and calling it according to user needs.

[0014] The advantages of the present invention are:

[0015] 1. The initial data information collected by the collection end is the configuration relationship component generated according to the configuration instructions input by the user, and the pre-processing parsing information is gradually obtained. In this way, the user can input the corresponding configuration relationship according to the actual use of the collection end. In this way, the use of various personalized collection methods (such as clicking a button several times / several seconds to represent the input of a certain specific information) will not affect the final stored data structure.

[0016] 2. This system will carry out targeted processing on the initial data information according to the configuration relationship components, and can process data of different structures collected by various collection methods, which greatly improves the scalability.

[0017] 3. After obtaining the preprocessing parsing information, the conversion module will display the preprocessing parsing information to allow the user to check whether the preprocessing parsing information is the data type they want. If it is, the user can input a confirmation signal. After receiving the confirmation signal, the conversion module calls the storage structure component to process the preprocessing parsing information into standardized storage structure information; if not, the user can input a new configuration instruction through the interactive module to reprocess the collected information. In this way, the user can confirm that the final database module stores the data they want.

[0018] 4. The collected data information stored in the database module is information of a standardized storage structure, which is convenient for subsequent analysis without the need to redevelop or define new analysis methods based on new data structures.

[0019] In summary, the present application provides a database interface conversion system that is convenient for enterprise managers to use.

[0020] Furthermore, if the interaction module receives a modification signal when displaying the pre-processing parsing information, the interaction module prompts the user to input a new configuration instruction.

[0021] When the conversion module receives the modification signal, it means that the user believes that the pre-processed parsed information is not the data he wants, and the user wants to re-process the initial data information. However, using the existing configuration instructions will only get the same result, so the user needs to specify a new configuration instruction. At this time, the interactive module displays the information for inputting the new configuration instruction to the user, which is equivalent to providing the user with operation guidance, so that the user can intuitively understand how to operate in order to get the result he wants.

[0022] Furthermore, the interactive module prompts the user to input a new configuration instruction in the form of images, text and sound.

[0023] Not only can users understand the prompt information, but also the specific content and operation methods of the prompt.

[0024] Furthermore, the input of the configuration instruction is a visualization operation.

[0025] The interactive module is a configuration relationship component based on user needs. After the configuration instructions are visualized, the user's learning cost can be greatly reduced, allowing users to quickly get started with configuration.

[0026] Furthermore, the interactive module is also used to test the configuration instructions using a preset model, and if the test result shows that there is a problem, a warning message pops up.

[0027] When users enter configuration instructions, they may enter incorrect instructions. For example, the collected information cannot get the desired mapping results. At this time, the interactive module will pop up a warning message to allow users to modify the configuration instructions in time. Through such settings, the system can promptly discover and remind users of some operations that obviously have problems. When this happens, the configuration instructions can be corrected in time due to timely reminders. Compared with discovering problems in preprocessing and parsing information, the overall efficiency is greatly improved.

[0028] Furthermore, the interaction module is also used to receive a calling instruction input by a user, and retrieve corresponding data from the database module according to the calling instruction.

[0029] Users can easily retrieve the data they need from the database module through the interactive module.

[0030] Furthermore, the call instruction includes a data type and a data generation time.

[0031] It is convenient for users to accurately retrieve the data they need from the database.

[0032] Furthermore, the interaction module is also used to receive the user's operation instructions, and according to the operation instructions, perform corresponding operation processing on the data retrieved from the database module.

[0033] Users can use the interactive module to process the data retrieved from the database module and obtain the information they want. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 The following is a logic block diagram of a database interface conversion system embodiment 1 of the present invention. DETAILED DESCRIPTION

[0035] The following is further described in detail through specific implementation methods:

[0036] Embodiment 1

[0037] like Figure 1 As shown, a database interface conversion system includes a receiving module, an interaction module, a conversion module and a database module.

[0038] The receiving module is used to receive the initial data information collected by the data collection terminal;

[0039] The interactive module is used to receive the configuration instructions input by the user. In this embodiment, the configuration instructions are input in a visual operation. After the configuration instructions are visualized, the learning cost of the user can be greatly reduced, and the user can quickly get started with the configuration.

[0040] The interaction module is also used to generate a configuration relationship component according to the configuration instruction, wherein the configuration relationship component includes an initial parsing component of the initial data information and a standardized storage structure component of the database, and a mapping relationship between the two;

[0041] The conversion module is used to call the initial parsing component to parse the initial data information to obtain the initial parsing information, and then call the mapping relationship between the initial parsing component and the storage structure component to process the initial parsing information into pre-processed parsing information that can be recognized by the storage structure component;

[0042] The interactive module is also used to display preprocessed parsing information. If the interactive module receives a confirmation signal when displaying the preprocessed parsing information, the conversion module calls the storage structure component to process the preprocessed parsing information into standardized storage structure information; the database module is used to store standardized storage structure information and call it according to user needs.

[0043] If the interactive module receives a modification signal when displaying the preprocessing parsing information, the interactive module prompts the user to input a new configuration instruction. The interactive module prompts the user to input the new configuration instruction in the form of an image, text, and sound.

[0044] The specific implementation process is as follows:

[0045] When using this system, users can input configuration instructions through the interactive module according to the actual operation mode of the acquisition end and the final desired data.

[0046] For example, if the user's collection end is a terminal with a button, and the user needs to know the qualified rate of the product, the configuration instruction input by the user can include indicating whether a single product is qualified or not by pressing, and the server directly stores the qualified rate of the product. For example, pressing a button once means that the product is qualified, and pressing the button twice in succession means that there is a problem with the product; other different methods, such as the time of pressing or the combination of pressing different buttons, can also be used to indicate the type or location of the problem.

[0047] The user can input the corresponding configuration relationship according to the actual usage of the collection end. In this way, the user can use various personalized collection methods that meet the user's own usage habits without affecting the final stored data structure.

[0048] Afterwards, the conversion module will generate configuration relationship components according to the configuration instructions input by the user, specifically including the initial parsing component of the initial data information and the standardized storage structure component of the database, as well as the mapping relationship between the two.

[0049] During specific use, after the receiving module receives the initial data information (such as button pressing information) collected by the collection terminal, the conversion module calls the initial parsing component to parse the initial data information and obtains the initial parsing information (whether the product is qualified or not). Then, the conversion module calls the mapping relationship between the initial parsing component and the storage structure component, and processes the initial parsing information into pre-processed parsing information (such as product inspection pass rate) that can be recognized by the storage structure component.

[0050] This system will carry out targeted processing of the initial data information according to the configuration relationship components, and can process data of different structures collected by various collection methods, greatly improving the scalability.

[0051] Afterwards, the interactive module displays the preprocessing analysis information, and the user can understand the product's pass rate through the interactive module. If the user has no objection to the information, he can input a confirmation signal through the interactive module. After the interactive module receives the confirmation signal, the conversion module calls the storage structure component to process the preprocessing analysis information into standardized storage structure information, and then stores the standardized storage structure information into the database module for the convenience of subsequent user calls. In this system, the collected data information stored in the database module is information of a standardized storage structure, which is convenient for subsequent analysis without the need to redevelop or define a new analysis method based on a new data structure.

[0052] If the user disagrees with the information, or the information is not what the user wants, the user can input a modification signal through the interactive module. The interactive module receives the modification signal and prompts the user to input a new configuration instruction. In this case, it means that the user believes that the preprocessed parsed information is not the data he wants, and the user wants to reprocess the initial data information. However, using the existing configuration instructions will only get the same result, so the user needs to specify a new configuration instruction. At this time, the interactive module prompts the user to input the new configuration instruction information, which is equivalent to providing the user with operation guidance, so that the user can intuitively understand how to operate in order to get the result he wants.

[0053] Embodiment 2

[0054] Different from the first embodiment, the interactive module in this embodiment is also used to test the configuration instructions with a preset model. If the test result shows that there is a problem, a warning message pops up. When the user enters the configuration instruction, it is possible to enter the wrong instruction. For example, the desired mapping result cannot be obtained by using the collected information. At this time, the interactive module will pop up a warning message to allow the user to modify the configuration instruction in time. Through such a setting, for some operations that obviously have problems, the system can promptly discover and remind. When this happens, the configuration instruction can be corrected in time due to the timely reminder. Compared with discovering problems in the preprocessing parsing information, the overall efficiency is greatly improved.

[0055] In this embodiment, the interactive module is also used to receive a call instruction input by a user, and retrieve corresponding data from the database module according to the call instruction. The retrieval instruction includes a data type and a data generation time. The interactive module is also used to receive a calculation instruction from a user, and perform corresponding calculation processing on the data retrieved from the database module according to the calculation instruction. In this way, the user can perform calculation processing on the data retrieved from the database module through the interactive module to obtain the information he wants.

[0056] Embodiment 3

[0057] Different from the first embodiment, this embodiment further includes a login module, a collection module and an analysis module;

[0058] The login module is used for account login;

[0059] The acquisition module is used to collect character operation information, which includes expression, voice and action; the acquisition module includes a camera and a microphone;

[0060] The analysis module is used to create a user profile for the account based on the character operation information and the corresponding processing results of the interaction module;

[0061] The analysis module is also used to predict instructions and generate predicted instructions based on the user portrait, real-time character operation information and configuration instructions received by the interaction module; the analysis module is also used to judge satisfaction based on the user portrait and real-time character operation information, and the satisfaction is divided into N levels;

[0062] The interactive module is also used to display the prediction instruction when the result of the satisfaction judgment is lower than the preset minimum satisfaction; the interactive module is also used to display the prediction instruction when prompting the user to input a new configuration instruction.

[0063] The specific implementation process is as follows:

[0064] Although the specific usage requirements of each user are different, the user's personal usage habits and usage requirements are relatively fixed. Through such a setting, when the user is operating, the collection module will collect the user's character operation information (expression, voice and action), and then the analysis unit will make a user profile based on the character operation information and the corresponding processing results of the interaction module to understand the applicability of the configuration instructions corresponding to the user's character operation information and the user's personal satisfaction.

[0065] After the user portrait is generated, when the user performs subsequent operations, the command prediction and predicted command are generated based on the user portrait, real-time character operation information and configuration instructions received by the interactive module. When the interactive module prompts the user to enter a new configuration instruction, the predicted instruction will be displayed at the same time. Through the predicted instruction, the user can quickly complete the reset of the configuration instruction, which not only provides a better experience, but also effectively improves the efficiency of resetting the configuration instruction.

[0066] In addition, the analysis module can judge the satisfaction level based on the user portrait and real-time character operation information, and the satisfaction level is divided into N levels (such as ten levels); when the result of the satisfaction judgment is lower than the preset minimum satisfaction level (such as the satisfaction level is four, the expression shows obvious doubts and sighs, and there is also a scratching action), the interaction module displays the predicted instructions. In this way, when the analysis shows that the user satisfaction level is low, relevant prompts can be given in a timely manner, which can improve the user experience and improve the operation efficiency.

[0067] The above is only an embodiment of the present invention. The common sense such as the known specific structure and characteristics in the scheme is not described in detail here. The ordinary technicians in the relevant field know all the common technical knowledge in the technical field of the invention before the application date or priority date, can obtain all the existing technologies in the field, and have the ability to apply the conventional experimental means before that date. The ordinary technicians in the relevant field can improve and implement this scheme in combination with their own abilities under the enlightenment given by this application. Some typical known structures or known methods should not become obstacles for ordinary technicians in the relevant field to implement this application. It should be pointed out that for those skilled in the art, without departing from the structure of the present invention, several deformations and improvements can be made, which should also be regarded as the protection scope of the present invention, which will not affect the effect of the implementation of the present invention and the practicality of the patent. The protection scope required by this application shall be based on the content of its claims, and the specific implementation methods and other records in the specification can be used to interpret the content of the claims.

Claims

1. A database interface conversion system, characterized in that: include: A receiving module, used for receiving initial data information collected by a data collection terminal; An interactive module, used to receive configuration instructions input by a user, and generate configuration relationship components according to the configuration instructions, wherein the configuration relationship components include an initial parsing component of initial data information and a standardized storage structure component of a database, and a mapping relationship between the two; The interactive module is also used to test the configuration instructions using a preset model. If the test result shows that there is a problem, a warning message will pop up; The interactive module is also used to receive a call instruction input by a user, and retrieve corresponding data from the database module according to the call instruction; wherein the retrieval instruction includes a data type and a data generation time; the interactive module is also used to receive a calculation instruction from a user, and perform corresponding calculation processing on the data retrieved from the database module according to the calculation instruction; The conversion module is used to call the initial parsing component to parse the initial data information to obtain the initial parsing information, and then call the mapping relationship between the initial parsing component and the storage structure component to process the initial parsing information into pre-processed parsing information that can be recognized by the storage structure component; The interactive module is also used to display the preprocessed parsing information. If the interactive module receives a confirmation signal when displaying the preprocessed parsing information, the conversion module calls the storage structure component to process the preprocessed parsing information into standardized storage structure information. It also includes a database module for storing standardized storage structure information and calling it according to user needs; It also includes a login module, a collection module and an analysis module; the login module is used to log in to an account; the collection module is used to collect character operation information, which includes expressions, voices and actions; the collection module includes a camera and a microphone; the analysis module is used to create a user portrait for the account based on the character operation information and the corresponding processing results of the interaction module; the analysis module is also used to predict instructions and generate predicted instructions based on the user portrait, real-time character operation information and configuration instructions received by the interaction module; the analysis module is also used to judge satisfaction based on the user portrait and real-time character operation information, and the satisfaction is divided into N levels; the interaction module is also used to display the predicted instructions when the result of the satisfaction judgment is lower than the preset minimum satisfaction; the interaction module is also used to display the predicted instructions when prompting the user to enter a new configuration instruction.

2. The database interface conversion system according to claim 1, characterized in that: If the interaction module receives a modification signal when displaying the pre-processing parsing information, the interaction module prompts the user to input a new configuration instruction.

3. The database interface conversion system according to claim 2, characterized in that: The interactive module prompts the user to input new configuration instructions in the form of images, text and sound.

4. The database interface conversion system according to claim 1, characterized in that: The input of the configuration instructions is a visual operation.

Images