A database interface visualization protocol configuration method

Abstract

The present invention belongs to the field of databases, and specifically relates to a database interface visualization protocol configuration method, including: S1 receives the collected data of the collection end to generate first structure data; S2 receives the configuration instruction input by the user through the interactive interface, including the first data parsing structure of the first structure data, the standardized data parsing structure of the standardized storage structure information, and the mapping relationship between the first data parsing structure and the standardized data parsing structure; S3 calls the first data parsing structure, and the mapping relationship between the first data parsing structure and the standardized data parsing structure to obtain pre-processing parsing information; S4 displays the pre-processing parsing information, and if a confirmation signal is received when displaying the pre-processing parsing information, then go to S5; S5 processes the pre-processing parsing information into standardized storage structure information and saves it in a database. The present invention provides a database interface visualization protocol configuration method that can be convenient for enterprise managers to use.

Description

Technical Field

[0001] The invention belongs to the field of databases, and in particular relates to a database interface visualization protocol configuration method. 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 current databases all open various interfaces 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 actual users. The actual users should be the managers of the enterprise. Therefore, there is an urgent need for a database interface visualization protocol configuration method that can be convenient for enterprise managers to use. Summary of the invention

[0005] The technical problem solved by the present invention is to provide a database interface visualization protocol configuration method that can be conveniently used by enterprise managers.

[0006] The basic solution provided by the present invention is: a database interface visualization protocol configuration method, comprising:

[0007] S1 receives data collected by the collection end to generate first structure data;

[0008] S2 receives a configuration instruction input by a user through an interactive interface, wherein the configuration instruction includes a first data parsing structure of the first structure data, a standardized data parsing structure of the standardized storage structure information, and a mapping relationship between the first data parsing structure and the standardized data parsing structure;

[0009] S3 calls the first data parsing structure to parse the first structure data to obtain initial parsing information, and then calls the mapping relationship between the first data parsing structure and the standardized data parsing structure to process the initial parsing information to obtain pre-processing parsing information;

[0010] S4 displays the preprocessing and parsing information. If a confirmation signal is received when displaying the preprocessing and parsing information, go to S5;

[0011] S5 calls the standardized data parsing structure, processes the preprocessed parsing information into standardized storage structure information, and saves the standardized storage structure information into a database.

[0012] The advantages of the present invention are:

[0013] This method gradually processes the first structure data according to the configuration instructions input by the user to obtain pre-processing analysis information. In this way, the user can input the corresponding configuration relationship according to the specific structure and usage of the data collection work. In this way, the use of various personalized collection methods (such as clicking a button several times / several seconds, representing the input of certain specific information) will not affect the final stored data structure. This method will perform targeted processing on the first structure data according to the configuration relationship component, and can process data of different structures collected by multiple collection methods, greatly improving the scalability.

[0014] After obtaining the preprocessing parsing information, the preprocessing parsing information will be displayed 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. In this way, the user can confirm that the final database stores the data they want.

[0015] The collected data information stored in the database is information with 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.

[0016] Further, in S4, if a modification signal is received when displaying the preprocessing parsing information, go to S41;

[0017] The process also includes S41, prompting the user to input a new configuration instruction, and then proceeding to S2.

[0018] Receiving a modification signal 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 enter a new configuration instruction. At this time, displaying the information for entering the new configuration instruction to the user is equivalent to providing operation guidance to the user, so that the user can intuitively understand how to operate to get the result he wants.

[0019] Further, in S41, the prompting method is image, text and sound.

[0020] In this way, users can not only understand the prompt information, but also understand the specific content and operation method of the prompt.

[0021] Further, including S21, using a preset model to check the configuration instructions, if the test result is that there is no problem, go to S3; if the test result shows that there is a problem, go to S22; also including S22, prompting that the configuration instructions are wrong, and go to S2.

[0022] When users enter configuration instructions, they may enter incorrect instructions. For example, the desired mapping results cannot be obtained by using the collected information. At this time, a warning message pops up to allow users to modify the configuration instructions in time. In this way, some operations with obvious problems can be discovered and reminded in time. When this happens, the configuration instructions can be corrected in time due to the timely reminder. Compared with discovering problems in preprocessing and parsing information, the overall efficiency is greatly improved.

[0023] Furthermore, the method further includes S6, receiving a calling instruction input by a user, and retrieving corresponding data from a database according to the calling instruction.

[0024] Users can easily retrieve the data they need from the database.

[0025] Further, in S6, the calling instruction includes the data type and the data generation time.

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

[0027] Furthermore, in S6, a calculation instruction from the user is received, and according to the calculation instruction, the data retrieved from the database is subjected to corresponding calculation processing.

[0028] Users can perform operations on the data retrieved from the database to obtain the information they want. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 The present invention is a flowchart of a first embodiment of a method for configuring a database interface visualization protocol. DETAILED DESCRIPTION

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

[0031] Embodiment 1

[0032] It should be noted that the implementation of this method relies on a database interface visualization protocol configuration system, including a receiving module, an interaction module, a conversion module and a database module.

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

[0034] 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.

[0035] 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;

[0036] 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;

[0037] 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.

[0038] 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.

[0039] like Figure 1 As shown, a database interface visualization protocol configuration method includes:

[0040] S1 receives data collected by the collection end to generate first structure data;

[0041] S2 receives a configuration instruction input by a user through an interactive interface, wherein the configuration instruction includes a first data parsing structure of the first structure data, a standardized data parsing structure of the standardized storage structure information, and a mapping relationship between the first data parsing structure and the standardized data parsing structure;

[0042] S21, use the preset model to check the configuration instructions. If the check result shows that there is no problem, go to S3; if the check result shows that there is a problem, go to S22;

[0043] S22, prompts that the configuration command is wrong and goes to S2;

[0044] S3 calls the first data parsing structure to parse the first structure data to obtain initial parsing information, and then calls the mapping relationship between the first data parsing structure and the standardized data parsing structure to process the initial parsing information to obtain pre-processing parsing information;

[0045] S4 displays the preprocessing parsing information. If a confirmation signal is received when displaying the preprocessing parsing information, go to S5; if a modification signal is received when displaying the preprocessing parsing information, go to S41;

[0046] S41, prompting the user to input new configuration instructions in the form of images, text and sound, and then going to S2;

[0047] S5 calls the standardized data parsing structure, processes the preprocessed parsing information into standardized storage structure information, and saves the standardized storage structure information into a database.

[0048] The specific implementation process is as follows:

[0049] This method gradually processes the first structure data according to the configuration instructions input by the user to obtain pre-processing analysis information. In this way, the user can input the corresponding configuration relationship according to the specific structure and usage of the data collection work. In this way, the use of various personalized collection methods (such as clicking a button several times / several seconds, representing the input of certain specific information) will not affect the final stored data structure. This method will perform targeted processing on the first structure data according to the configuration relationship component, and can process data of different structures collected by multiple collection methods, greatly improving the scalability.

[0050] When users enter configuration instructions, they may enter incorrect instructions. For example, the desired mapping results cannot be obtained by using the collected information. At this time, a warning message pops up to allow users to modify the configuration instructions in time. In this way, some operations with obvious problems can be discovered and reminded in time. When this happens, the configuration instructions can be corrected in time due to the timely reminder. Compared with discovering problems in preprocessing and parsing information, the overall efficiency is greatly improved.

[0051] After obtaining the preprocessing parsing information, the preprocessing parsing information will be displayed 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. In this way, the user can confirm that the final database stores the data they want.

[0052] The collected data information stored in the database is information with 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.

[0053] Receiving a modification signal 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 enter a new configuration instruction. At this time, displaying the information for entering the new configuration instruction to the user is equivalent to providing operation guidance to the user, so that the user can intuitively understand how to operate to get the result he wants.

[0054] Embodiment 2

[0055] Different from the first embodiment, this embodiment further includes S6, which receives a calling instruction input by a user, and retrieves corresponding data from the database according to the calling instruction, and the retrieval instruction includes the data type and the data generation time; it also receives a calculation instruction from the user, and performs corresponding calculation processing on the data retrieved from the database according to the calculation instruction.

[0056] Users can easily retrieve the data they need from the database, and can also perform operations on the data retrieved from the database to obtain the information they want.

[0057] Embodiment 3

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

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

[0060] 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;

[0061] 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;

[0062] 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;

[0063] 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.

[0064] In S1, the character operation information is also collected through the collection module, and the character operation information includes expression, voice and action;

[0065] The process also includes: S51, creating a user portrait for the account according to the character operation information and the corresponding processing result of the interaction module, and updating the user portrait if the user portrait already exists;

[0066] S11, checking whether there is a user portrait, if so, performing instruction prediction and generating a predicted instruction based on the user portrait, real-time character operation information and configuration instructions received by the interaction module;

[0067] S12, checking whether there is a user portrait. If so, a satisfaction degree is determined based on the user portrait and real-time character operation information. The satisfaction degree is divided into N levels. When the result of the satisfaction degree determination is lower than the preset minimum satisfaction degree, a prediction instruction is displayed.

[0068] In S41, when prompting the user to input a new configuration instruction, a predicted instruction is also displayed.

[0069] The specific implementation process is as follows:

[0070] Although each user's specific usage needs are different, the user's personal usage habits and usage needs are relatively fixed. Through such a setting, when the user is operating, the user's character operation information (expression, voice and action) is collected, and then the user profile is made based on the character operation information and the corresponding processing results to understand the applicability of the configuration instructions corresponding to the user's character operation information and the user's personal satisfaction.

[0071] After the user portrait is generated, when the user performs subsequent operations, the command prediction and predicted command generation are performed based on the user portrait, real-time character operation information and received configuration commands. When the user is prompted to enter a new configuration command, the predicted command will be displayed together. Through the predicted command, the user can quickly complete the reset of the configuration command, which not only provides a better experience, but also effectively improves the efficiency of resetting the configuration command.

[0072] In addition, satisfaction can be judged based on user portraits and real-time character operation information. Satisfaction is divided into N levels (such as ten levels); when the result of the satisfaction judgment is lower than the preset minimum satisfaction (such as satisfaction level four, with obvious doubts and sighing voice, and scratching the head), the predicted instructions are displayed. In this way, when the analysis shows that the user satisfaction is low, relevant prompts can be given in time, which can improve the user experience and improve the operation efficiency.

[0073] 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 visualization protocol configuration method, characterized in that: include: S1 receives data collected by the collection end to generate first structure data; S2 receives a configuration instruction input by a user through an interactive interface, wherein the configuration instruction includes a first data parsing structure of the first structure data, a standardized data parsing structure of the standardized storage structure information, and a mapping relationship between the first data parsing structure and the standardized data parsing structure; S3: calling the first data parsing structure to parse the first structure data to obtain initial parsing information, and then calling the mapping relationship between the first data parsing structure and the standardized data parsing structure to process the initial parsing information to obtain pre-processing parsing information; S4 displays the preprocessing and parsing information. If a confirmation signal is received when displaying the preprocessing and parsing information, go to S5; S5 calls the standardized data parsing structure, processes the preprocessed parsing information into standardized storage structure information, and saves the standardized storage structure information into a database; In S1, character operation information is also collected, including expression, voice and action; The process also includes: S51, creating a user portrait for the account according to the character operation information and the corresponding processing result of the interaction module, and updating the user portrait if the user portrait already exists; S11, checking whether there is a user portrait, if so, performing instruction prediction and generating a predicted instruction based on the user portrait, real-time character operation information and configuration instructions received by the interaction module; S12, checking whether there is a user portrait. If so, a satisfaction degree is determined based on the user portrait and real-time character operation information. The satisfaction degree is divided into N levels. When the result of the satisfaction degree determination is lower than the preset minimum satisfaction degree, a prediction instruction is displayed. In S41, when prompting the user to input a new configuration instruction, a predicted instruction is also displayed; In S4, if a modification signal is received when displaying the preprocessing parsing information, go to S41; It also includes S41, prompting the user to input a new configuration instruction, and then going to S2; In S41, the prompting method is image, text and sound; Including S21, using a preset model to check the configuration instructions, if the test result is that there is no problem, go to S3; if the test result shows that there is a problem, go to S22; also including S22, prompting that the configuration instructions are wrong, and go to S2.

2. The method for configuring a database interface visualization protocol according to claim 1, characterized in that: The method further includes S6, receiving a calling instruction input by a user, and retrieving corresponding data from a database according to the calling instruction.

3. The database interface visualization protocol configuration method according to claim 2, characterized in that: In S6, the calling instruction includes the data type and the data generation time.

4. The database interface visualization protocol configuration method according to claim 3, characterized in that: In S6, a calculation instruction from the user is also received, and according to the calculation instruction, the data retrieved from the database is subjected to corresponding calculation processing.

Images