CN110851618A - Management method and device of table data - Google Patents
Management method and device of table data Download PDFInfo
- Publication number
- CN110851618A CN110851618A CN201910992368.3A CN201910992368A CN110851618A CN 110851618 A CN110851618 A CN 110851618A CN 201910992368 A CN201910992368 A CN 201910992368A CN 110851618 A CN110851618 A CN 110851618A
- Authority
- CN
- China
- Prior art keywords
- terminal
- parameter
- target
- user
- parameters
- 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/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/36—Creation of semantic tools, e.g. ontology or thesauri
- G06F16/367—Ontology
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
- G06F16/9577—Optimising the visualization of content, e.g. distillation of HTML documents
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)
- Life Sciences & Earth Sciences (AREA)
- Animal Behavior & Ethology (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a management method of table data. The method comprises the following steps: receiving newly added original form data of a first user at a first terminal; according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal; determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal; a multi-dimensional table is created that is an entity based on the target parameters. The method and the device solve the technical problem that the cost for constructing each aspect of the knowledge graph is high due to the fact that a large amount of manual operation, reasoning, retrieval and the like are needed for determining the target entity.
Description
Technical Field
The present application relates to the field of table data management, and in particular, to a method and an apparatus for managing table data.
Background
The internet is moving from the document web, which contains only web pages and hyperlinks between web pages, to the data web, which contains a large number of data describing various entities and rich relationships between entities. Under the background, search engine companies such as Google, Baidu and Saogue construct the knowledge graph on the basis of the search engine companies.
A knowledge graph is essentially a semantic network, and is a graph-based data structure, consisting of nodes and edges. In the knowledge-graph, each node represents an "entity" existing in the real world, and each edge is a "relationship" between entities. Knowledge-graphs are the most efficient way to represent relationships.
But the process of building the knowledge graph consumes enormous costs, including technical costs, team costs, and organizational costs. The technology comprises the cost of knowledge extraction, the cost of knowledge storage, the cost of knowledge inference, the cost of knowledge retrieval, the cost of operation and maintenance and the cost of updating. The team cost includes the recruitment cost and the education cost. The organization cost includes planning cost, matching cost among departments (other departments are required to participate in data marking, data arrangement and the like), communication cost and the like.
Aiming at the problem of high cost in all aspects of knowledge graph construction in the related technology, no effective solution is provided at present.
Disclosure of Invention
The application mainly aims to provide a method and a device for managing table data so as to solve the problem that the cost for constructing a knowledge graph is high in all aspects.
In order to achieve the above object, according to one aspect of the present application, there is provided a method of managing a multi-dimensional table.
The management method of the table data comprises the following steps: receiving newly added original form data of a first user at a first terminal; according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal; determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal; a multi-dimensional table is created that is an entity based on the target parameters.
Further, the receiving of the original form data newly added by the first user at the first terminal includes: monitoring whether a newly added form operation of a first user exists in a newly added interface of a first terminal; if yes, storing newly added original form data and receiving title type data input by a user; and generating a newly added record of the original form data according to the title type data, and outputting the newly added record in a function list interface of the first terminal.
Further, retrieving the parameter to be defined in the original form data according to the first management operation of the first user at the first terminal includes: monitoring whether a function list interface of a first terminal has a parameter retrieval operation of a first user; and if the parameter exists, retrieving the parameter to be defined in the original table data, and outputting the parameter at the first terminal.
Further, according to a second management operation of the first user at the first terminal, determining a target parameter in the to-be-defined parameter includes: monitoring whether a parameter selection operation of a first user exists in a parameter interface to be defined of a first terminal; and if so, determining a target parameter in the parameters to be defined.
Further, after creating the multidimensional table based on the target parameter as the entity, the method further includes: monitoring whether a parameter association operation of a first user exists in a parameter interface to be associated of a first terminal; if yes, taking the first target parameter in the multi-dimensional table as a query condition, and taking the second target parameter except the first target parameter as a query target; and constructing a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between the parameters of the second target.
Further, after the association relationship between the query condition and the query target and the association relationship between the query condition and the questions in the question bank are constructed, the method further comprises the following steps: receiving a first question pair input by a second user at a second terminal; determining a first query condition of the first question pair according to the first incidence relation; determining a first query target of the first query condition according to the second incidence relation; and outputting the first query target at the second terminal.
Further, after the association relationship between the query condition and the query target and the association relationship between the query condition and the questions in the question bank are constructed, the method further comprises the following steps: receiving a first question pair input by a second user at a second terminal; determining a first query target of the first question pair according to a third association relation; and outputting the first query target at the second terminal.
In order to achieve the above object, according to another aspect of the present application, there is provided a management apparatus of table data.
The management device of table data according to the application comprises: the receiving module is used for receiving original form data newly added by a first user at a first terminal; the first management module is used for retrieving the parameters to be defined in the original form data according to the first management operation of a first user at a first terminal and outputting the parameters at the first terminal; the second management module is used for determining a target parameter in the to-be-defined parameter according to a second management operation of the first user on the first terminal; a creating module for creating a multi-dimensional table based on the target parameter as an entity.
Further, the method also comprises the following steps: the third management module is used for monitoring whether the parameter association operation of the first user exists in the parameter interface to be associated of the first terminal; if yes, taking the first target parameter in the multi-dimensional table as a query condition, and taking the second target parameter except the first target parameter as a query target; and the relation construction module is used for constructing a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between the second target parameters.
Further, the method also comprises the following steps: the question receiving module is used for receiving a first question pair input by a second user at a second terminal; the query module is used for determining a first query condition of the first question pair according to the first incidence relation; determining a first query target of the first query condition according to the second incidence relation; and the output module is used for outputting the first query target at the second terminal.
In the embodiment of the application, a form data management mode is adopted, and original form data newly added by a first user at a first terminal is received; according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal; determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal; creating a multi-dimensional table that is an entity based on the target parameter; the method achieves the aim of determining corresponding parameters as target entities in the original form data only by a small amount of operation, thereby realizing the technical effect of reducing the cost of constructing all aspects of the knowledge graph, and further solving the technical problem of higher cost of constructing all aspects of the knowledge graph caused by the fact that a large amount of manual operation, reasoning, retrieval and the like are needed to determine the target entities.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this application, serve to provide a further understanding of the application and to enable other features, objects, and advantages of the application to be more apparent. The drawings and their description illustrate the embodiments of the invention and do not limit it. In the drawings:
FIG. 1 is a flow chart of a method for managing table data according to a first embodiment of the present application;
FIG. 2 is a flow chart of a table data management method according to a second embodiment of the present application;
FIG. 3 is a flow chart of a table data management method according to a third embodiment of the present application;
FIG. 4 is a flowchart illustrating a table data management method according to a fourth embodiment of the present application;
FIG. 5 is a flow chart of a table data management method according to a fifth embodiment of the present application;
FIG. 6 is a flowchart illustrating a table data management method according to a sixth embodiment of the present application;
FIG. 7 is a flowchart illustrating a table data management method according to a seventh embodiment of the present application;
fig. 8 is a schematic structural diagram of a table data management apparatus according to a first embodiment of the present application;
fig. 9 is a schematic structural diagram of a management apparatus for table data according to a second embodiment of the present application;
fig. 10 is a schematic structural diagram of a table data management apparatus according to a third embodiment of the present application;
fig. 11 is a diagram of an original handset parameter table according to a third embodiment of the present application;
FIG. 12 is one of the state diagrams of the first terminal interface according to the preferred embodiment of the present application;
FIG. 13 is a second schematic diagram illustrating a state of the first terminal interface in accordance with the preferred embodiment of the present application;
FIG. 14 is one of the state diagrams of a second terminal interface according to the preferred embodiment of the present application;
FIG. 15 is a second schematic diagram illustrating the state of a second terminal interface in accordance with the preferred embodiment of the present application;
FIG. 16 is a third schematic diagram illustrating a state of a second terminal interface in accordance with a preferred embodiment of the present application;
fig. 17 is a fourth schematic view of the state of the second terminal interface according to the preferred embodiment of the present application.
Detailed Description
In order to make the technical solutions better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only partial embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and claims of this application and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the application described herein may be used. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In this application, the terms "upper", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal", and the like indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings. These terms are used primarily to better describe the invention and its embodiments and are not intended to limit the indicated devices, elements or components to a particular orientation or to be constructed and operated in a particular orientation.
Moreover, some of the above terms may be used to indicate other meanings besides the orientation or positional relationship, for example, the term "on" may also be used to indicate some kind of attachment or connection relationship in some cases. The specific meanings of these terms in the present invention can be understood by those skilled in the art as appropriate.
Furthermore, the terms "mounted," "disposed," "provided," "connected," and "sleeved" are to be construed broadly. For example, it may be a fixed connection, a removable connection, or a unitary construction; can be a mechanical connection, or an electrical connection; may be directly connected, or indirectly connected through intervening media, or may be in internal communication between two devices, elements or components. The specific meanings of the above terms in the present invention can be understood by those of ordinary skill in the art according to specific situations.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
According to an embodiment of the present invention, there is provided a method for managing table data, as shown in fig. 1, the method includes steps S100 to S106 as follows:
step S100, receiving newly added original form data of a first user at a first terminal;
the first user refers to a background manager, and the first terminal may be a computer, a mobile phone, or the like. The raw form data may be a cell phone parameter form, a video search form, a city business trip form, a food store form, and the like.
The manager can upload the original form data to a database in the server through the first terminal, and then a series of management is realized.
Preferably, as shown in fig. 2, the receiving of the original form data added by the first user at the first terminal includes:
s200, monitoring whether a newly added form operation of a first user exists in a newly added interface of a first terminal;
step S202, if the new table data exists, storing the newly added original table data, and receiving the title type data input by the user;
and step S204, generating a newly added record of the original form data according to the title type data, and outputting the newly added record in a function list interface of the first terminal.
In this embodiment, the above-mentioned mobile phone parameter table shown in fig. 11 is taken as an example:
the administrator opens the application processing software on the computer and enters the add-on interface, as shown in fig. 12, which includes the add-on option, the search bar, and the history generated by the previously imported form (in the function list interface).
The newly added form operation of the first user means that a manager clicks a newly added option to call an uploading interface, and then the title type is input in the interface: collecting parameters and models, inquiring a heating film and the like, and selecting a table format type: excel, the mobile phone parameter table data can be uploaded to a database of a server for storage by clicking uploading, finally, the server generates a new record according to the title type and the format type, and outputs the new record in a function list interface of the first terminal.
In some embodiments, when the server generates a new record according to the title type and the format type, options such as downloading, editing, deleting and the like are also configured in the record, and a manager can download, edit and delete the original form data by clicking the options.
Step S102, according to a first management operation of a first user at a first terminal, searching out parameters to be defined in the original form data, and outputting the parameters at the first terminal;
preferably, as shown in fig. 3, the retrieving the parameter to be defined in the original form data according to the first management operation of the first user at the first terminal, and outputting at the first terminal includes:
monitoring whether a function list interface of a first terminal has a parameter retrieval operation of a first user;
and if the parameter exists, retrieving the parameter to be defined in the original table data, and outputting the parameter at the first terminal.
In this embodiment, when the server generates a new record according to the title type and the format type, a parameter retrieval option is further configured in the record, as shown in fig. 12, by clicking the option (i.e., a parameter retrieval operation), the manager monitors that the operation exists, and then the server can perform parameter retrieval in a table stored in the database, retrieve all relevant parameters in the table, that is, parameters to be defined, and simultaneously display the interface of the parameters to be defined on the first terminal, thereby providing a guarantee for determining the target parameters.
All relevant parameters can be automatically determined in the table only by a small amount of operation, a large amount of manual operation, reasoning and retrieval are not needed, and the cost for constructing all aspects of the knowledge graph is reduced.
In this embodiment, different tables are stored in the database in a structural storage manner.
Step S104, determining a target parameter in the to-be-defined parameters according to a second management operation of a first user at a first terminal;
preferably, as shown in fig. 4, according to a second management operation of the first user at the first terminal, the determining the target parameter in the to-be-defined parameter includes:
s400, monitoring whether a parameter selection operation of a first user exists in a parameter interface to be defined of the first terminal;
step S402, if the parameters exist, determining target parameters in the parameters to be defined.
In this embodiment, after the first terminal displays the interface of the parameter to be defined, the manager may screen the parameter in the interface. As shown in fig. 12, all the parameter tags retrieved from the mobile phone parameter table include: model, 2K screen resolution, 4G +, NFC tag, etc.; the manager can select or delete a certain tag through a parameter selection operation (clicking on the tag), so that the manager can select a parameter which is considered important as a target parameter, and does not select the parameter when the manager is unimportant.
Corresponding parameters can be determined in the parameters to be defined as target parameters only by a small amount of operation, a large amount of manual operation, reasoning and retrieval are not needed, and the cost for constructing the knowledge graph is reduced.
And step S106, creating a multi-dimensional table which is an entity based on the target parameters.
The server receives the target parameters selected at the first terminal, and re-creates the original mobile phone parameter table according to the target parameters to obtain a multi-dimensional table; and technical support can be provided for subsequent problem association through the multi-dimensional table.
Preferably, as shown in fig. 5, after creating the multidimensional table that is an entity based on the target parameter, the method further includes:
s500, monitoring whether a parameter association operation of a first user exists in a parameter interface to be associated of a first terminal;
step S502, if the query condition exists, the first target parameter in the multidimensional table is used as the query condition, and the second target parameter except the first target parameter is used as the query target;
step S504, a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between parameters of the second target are established.
After the multi-dimensional table is created, the manager can establish the association relationship among the parameters through the parameter association operation. As shown in fig. 13, the administrator clicks the FAQ management to enter an FAQ editing interface, in which the administrator can set standard questions such as: inquiring mobile phone parameters; it is also possible to select a previously created multi-dimensional table as an answer to the question and set the corresponding parameters as query targets or query conditions.
In the process, the server needs to receive and determine the set problems according to the operation of personnel and stores the problems in a problem library; then, establishing a management relation among parameters according to the set query target and the set query condition; in this embodiment, the collected parameters of the mobile phone are used as the query target, the signals of the mobile phone are used as the query conditions, the first association relationship between the query target and the query conditions is established, the second association relationship between the question and the query conditions is established, and the third association relationship between the collected parameters is established.
According to an embodiment of the present invention, as shown in fig. 6, after constructing a first association relationship between a query condition and a query target, a second association relationship between the query condition and a question in a question bank, and a third association relationship between second target parameters, the method further includes:
step S600, receiving a first question pair input by a second user at a second terminal;
step S602, determining a first query condition of the first question pair according to a first incidence relation;
step S604, determining a first query target of the first query condition according to a second incidence relation;
step S606, outputting the first query target at the second terminal.
The second user is an inquirer, and the second terminal can be a mobile phone or a computer, preferably a mobile phone, and is convenient to carry; in this embodiment, after associating the question with the multidimensional table, the association relationship is set in the question-answering robot, as shown in fig. 14, with reference to the first association relationship and the second association relationship, when an inquirer inputs a word "inquire mobile phone parameters" of one question in the question pair, the question-answering robot automatically searches for the other question in the question pair, and continuously asks "what the mobile phone model is", the inquirer inputs the word "MSPLUS" according to the question, and the question-answering robot outputs all collection parameters meeting the conditions as answers according to the model.
In this embodiment, the inquirer can also directly ask the model number, as shown in fig. 15, such as: and if the person wants to search the mobile phone parameters of the 103BL model, the question and answer robot directly outputs corresponding collection parameters as answers according to the model.
Preferably, as shown in fig. 7, after constructing a first association relationship between the query condition and the query target, a second association relationship between the query condition and a question in the question bank, and a third association relationship between parameters of the second target, the method further includes:
step S700, receiving a first question pair input by a second user at a second terminal;
step S702, determining a first query target of the first question pair according to a third association relation;
step S704, outputting the first query target at the second terminal.
The second user is an inquirer, and the second terminal can be a mobile phone or a computer, preferably a mobile phone, and is convenient to carry; in this embodiment, after associating the questions with the multidimensional table, the association relationship is set in the question-answering robot, as shown in fig. 16 to 17, referring to the third association relationship, when an inquirer inputs a question "inquiring mobile phone parameters that mobile phone parameters support NFC or inquiring mobile phone parameters that mobile phone parameters do not support NFC" in a question pair, the question-answering robot outputs all collection parameters that meet the conditions as answers according to the collection parameters. The application of the robot for question answering based on the multi-dimensional table is realized, and the search precision can be improved.
From the above description, it can be seen that the present invention achieves the following technical effects:
in the embodiment of the application, a form data management mode is adopted, and original form data newly added by a first user at a first terminal is received; according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal; determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal; creating a multi-dimensional table that is an entity based on the target parameter; the method achieves the aim of determining corresponding parameters as target entities in the original form data only by a small amount of operation, thereby realizing the technical effect of reducing the cost of constructing all aspects of the knowledge graph, and further solving the technical problem of higher cost of constructing all aspects of the knowledge graph caused by the fact that a large amount of manual operation, reasoning, retrieval and the like are needed to determine the target entities.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowcharts, in some cases, the steps illustrated or described may be performed in an order different than presented herein.
According to an embodiment of the present invention, there is also provided an apparatus for implementing the above method for managing table data, as shown in fig. 8, the apparatus including:
a receiving module 10, configured to receive original form data newly added by a first user at a first terminal;
the first user refers to a background manager, and the first terminal may be a computer, a mobile phone, or the like. The raw form data may be a cell phone parameter form, a video search form, a city business trip form, a food store form, and the like.
The manager can upload the original form data to a database in the server through the first terminal, and then a series of management is realized.
According to an embodiment of the present invention, preferably, the receiving of the original form data newly added by the first user at the first terminal includes:
monitoring whether a newly added form operation of a first user exists in a newly added interface of a first terminal;
if yes, storing newly added original form data and receiving title type data input by a user;
and generating a newly added record of the original form data according to the title type data, and outputting the newly added record in a function list interface of the first terminal.
In this embodiment, the above-mentioned mobile phone parameter table shown in fig. 11 is taken as an example:
the administrator opens the application processing software on the computer and enters the add-on interface, as shown in fig. 12, which includes the add-on option, the search bar, and the history generated by the previously imported form (in the function list interface).
The newly added form operation of the first user means that a manager clicks a newly added option to call an uploading interface, and then the title type is input in the interface: collecting parameters and models, inquiring a heating film and the like, and selecting a table format type: excel, the mobile phone parameter table data can be uploaded to a database of a server for storage by clicking uploading, finally, the server generates a new record according to the title type and the format type, and outputs the new record in a function list interface of the first terminal.
In some embodiments, when the server generates a new record according to the title type and the format type, options such as downloading, editing, deleting and the like are also configured in the record, and a manager can download, edit and delete the original form data by clicking the options.
A first management module 20, configured to retrieve, according to a first management operation of a first user at a first terminal, a parameter to be defined in the original form data, and output the parameter at the first terminal;
preferably, according to an embodiment of the present invention, retrieving the parameter to be defined in the original form data according to a first management operation of the first user at the first terminal, and outputting at the first terminal includes:
monitoring whether a function list interface of a first terminal has a parameter retrieval operation of a first user;
and if the parameter exists, retrieving the parameter to be defined in the original table data, and outputting the parameter at the first terminal.
In this embodiment, when the server generates a new record according to the title type and the format type, a parameter retrieval option is further configured in the record, as shown in fig. 12, by clicking the option (i.e., a parameter retrieval operation), the manager monitors that the operation exists, and then the server can perform parameter retrieval in a table stored in the database, retrieve all relevant parameters in the table, that is, parameters to be defined, and simultaneously display the interface of the parameters to be defined on the first terminal, thereby providing a guarantee for determining the target parameters.
All relevant parameters can be automatically determined in the table only by a small amount of operation, a large amount of manual operation, reasoning and retrieval are not needed, and the cost for constructing all aspects of the knowledge graph is reduced.
In this embodiment, different tables are stored in the database in a structural storage manner.
A second management module 30, configured to determine a target parameter from the to-be-defined parameters according to a second management operation of the first user at the first terminal;
according to an embodiment of the present invention, preferably, determining the target parameter in the to-be-defined parameter according to a second management operation of the first user at the first terminal includes:
monitoring whether a parameter selection operation of a first user exists in a parameter interface to be defined of a first terminal;
and if so, determining a target parameter in the parameters to be defined.
In this embodiment, after the first terminal displays the interface of the parameter to be defined, the manager may screen the parameter in the interface. As shown in fig. 12, all the parameter tags retrieved from the mobile phone parameter table include: model, 2K screen resolution, 4G +, NFC tag, etc.; the manager can select or delete a certain tag through a parameter selection operation (clicking on the tag), so that the manager can select a parameter which is considered important as a target parameter, and does not select the parameter when the manager is unimportant.
Corresponding parameters can be determined in the parameters to be defined as target parameters only by a small amount of operation, a large amount of manual operation, reasoning and retrieval are not needed, and the cost for constructing the knowledge graph is reduced.
A creating module 40 for creating a multi-dimensional table based on the target parameter as an entity.
The server receives the target parameters selected at the first terminal, and re-creates the original mobile phone parameter table according to the target parameters to obtain a multi-dimensional table; and technical support can be provided for subsequent problem association through the multi-dimensional table.
According to the embodiment of the present invention, as shown in fig. 9, it is preferable that:
a third management module 50 for
Monitoring whether a parameter association operation of a first user exists in a parameter interface to be associated of a first terminal;
if yes, taking the first target parameter in the multi-dimensional table as a query condition, and taking the second target parameter except the first target parameter as a query target;
a relationship building module 60 for
And constructing a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between the parameters of the second target.
After the multi-dimensional table is created, the manager can establish the association relationship among the parameters through the parameter association operation. As shown in fig. 13, the administrator clicks the FAQ management to enter an FAQ editing interface, in which the administrator can set standard questions such as: inquiring mobile phone parameters; it is also possible to select a previously created multi-dimensional table as an answer to the question and set the corresponding parameters as query targets or query conditions.
In the process, the server needs to receive and determine the set problems according to the operation of personnel and stores the problems in a problem library; then, establishing a management relation among parameters according to the set query target and the set query condition; in this embodiment, the collected parameters of the mobile phone are used as the query target, the signals of the mobile phone are used as the query conditions, the first association relationship between the query target and the query conditions is established, the second association relationship between the question and the query conditions is established, and the third association relationship between the collected parameters is established.
According to the embodiment of the present invention, as shown in fig. 10, it is preferable that:
the question receiving module 70 is provided with a question receiving module,
the first question pair input by the second user at the second terminal is received;
query module 80 for
Determining a first query condition of the first question pair according to the first incidence relation;
determining a first query target of the first query condition according to the second incidence relation;
an output module 90 for
And outputting the first query target at the second terminal.
The second user is an inquirer, and the second terminal can be a mobile phone or a computer, preferably a mobile phone, and is convenient to carry; in this embodiment, after associating the question with the multidimensional table, the association relationship is set in the question-answering robot, as shown in fig. 14, with reference to the first association relationship and the second association relationship, when an inquirer inputs a word "inquire mobile phone parameters" of one question in the question pair, the question-answering robot automatically searches for the other question in the question pair, and continuously asks "what the mobile phone model is", the inquirer inputs the word "MSPLUS" according to the question, and the question-answering robot outputs all collection parameters meeting the conditions as answers according to the model.
In this embodiment, the inquirer can also directly ask the model number, as shown in fig. 15, such as: and if the person wants to search the mobile phone parameters of the 103BL model, the question and answer robot directly outputs corresponding collection parameters as answers according to the model.
According to the embodiment of the present invention, after constructing the first association relationship between the query condition and the query target, the second association relationship between the query condition and the question in the question bank, and the third association relationship between the second target parameters, the method further comprises:
receiving a first question pair input by a second user at a second terminal;
determining a first query target of the first question pair according to a third association relation;
and outputting the first query target at the second terminal.
The second user is an inquirer, and the second terminal can be a mobile phone or a computer, preferably a mobile phone, and is convenient to carry; in this embodiment, after associating the questions with the multidimensional table, the association relationship is set in the question-answering robot, as shown in fig. 16 to 17, referring to the third association relationship, when an inquirer inputs a question "inquiring mobile phone parameters that mobile phone parameters support NFC or inquiring mobile phone parameters that mobile phone parameters do not support NFC" in a question pair, the question-answering robot outputs all collection parameters that meet the conditions as answers according to the collection parameters. The application of the robot for question answering based on the multi-dimensional table is realized, and the search precision can be improved.
From the above description, it can be seen that the present invention achieves the following technical effects:
in the embodiment of the application, a form data management mode is adopted, and original form data newly added by a first user at a first terminal is received; according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal; determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal; creating a multi-dimensional table that is an entity based on the target parameter; the method achieves the aim of determining corresponding parameters as target entities in the original form data only by a small amount of operation, thereby realizing the technical effect of reducing the cost of constructing all aspects of the knowledge graph, and further solving the technical problem of higher cost of constructing all aspects of the knowledge graph caused by the fact that a large amount of manual operation, reasoning, retrieval and the like are needed to determine the target entities.
It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and they may alternatively be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, or fabricated separately as individual integrated circuit modules, or fabricated as a single integrated circuit module from multiple modules or steps. Thus, the present invention is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present application and is not intended to limit the present application, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present application shall be included in the protection scope of the present application.
Claims (10)
1. A method for managing table data, comprising:
receiving newly added original form data of a first user at a first terminal;
according to a first management operation of a first user at a first terminal, retrieving parameters to be defined from the original form data, and outputting the parameters at the first terminal;
determining a target parameter in the parameters to be defined according to a second management operation of a first user at a first terminal;
a multi-dimensional table is created that is an entity based on the target parameters.
2. The method of claim 1, wherein receiving the original form data added by the first user at the first terminal comprises:
monitoring whether a newly added form operation of a first user exists in a newly added interface of a first terminal;
if yes, storing newly added original form data and receiving title type data input by a user;
and generating a newly added record of the original form data according to the title type data, and outputting the newly added record in a function list interface of the first terminal.
3. The method according to claim 1, wherein retrieving the parameter to be defined in the raw form data according to the first management operation of the first user at the first terminal, and outputting at the first terminal comprises:
monitoring whether a function list interface of a first terminal has a parameter retrieval operation of a first user;
and if the parameter exists, retrieving the parameter to be defined in the original table data, and outputting the parameter at the first terminal.
4. The management method according to claim 1, wherein determining the target parameter among the parameters to be defined according to the second management operation of the first user at the first terminal comprises:
monitoring whether a parameter selection operation of a first user exists in a parameter interface to be defined of a first terminal;
and if so, determining a target parameter in the parameters to be defined.
5. The method of claim 1, wherein creating a multidimensional table that is an entity based on the target parameter further comprises:
monitoring whether a parameter association operation of a first user exists in a parameter interface to be associated of a first terminal;
if yes, taking the first target parameter in the multi-dimensional table as a query condition, and taking the second target parameter except the first target parameter as a query target;
and constructing a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between the parameters of the second target.
6. The method for managing according to claim 5, wherein after constructing the first association relationship between the query condition and the query object, the second association relationship between the query condition and the questions in the question bank, and the third association relationship between the second object parameters, further comprising:
receiving a first question pair input by a second user at a second terminal;
determining a first query condition of the first question pair according to the first incidence relation;
determining a first query target of the first query condition according to the second incidence relation;
and outputting the first query target at the second terminal.
7. The method for managing according to claim 5, wherein after constructing the first association relationship between the query condition and the query object, the second association relationship between the query condition and the questions in the question bank, and the third association relationship between the second object parameters, further comprising:
receiving a first question pair input by a second user at a second terminal;
determining a first query target of the first question pair according to a third association relation;
and outputting the first query target at the second terminal.
8. An apparatus for managing table data, comprising:
the receiving module is used for receiving original form data newly added by a first user at a first terminal;
the first management module is used for retrieving the parameters to be defined in the original form data according to the first management operation of a first user at a first terminal and outputting the parameters at the first terminal;
the second management module is used for determining a target parameter in the to-be-defined parameter according to a second management operation of the first user on the first terminal;
a creating module for creating a multi-dimensional table based on the target parameter as an entity.
9. The management apparatus according to claim 8, further comprising:
a third management module for
Monitoring whether a parameter association operation of a first user exists in a parameter interface to be associated of a first terminal;
if yes, taking the first target parameter in the multi-dimensional table as a query condition, and taking the second target parameter except the first target parameter as a query target;
a relationship building module for
And constructing a first association relation between the query condition and the query target, a second association relation between the query condition and the questions in the question bank, and a third association relation between the parameters of the second target.
10. The management apparatus according to claim 8, further comprising:
a question receiving module for receiving the question,
the first question pair input by the second user at the second terminal is received;
query module for
Determining a first query condition of the first question pair according to the first incidence relation;
determining a first query target of the first query condition according to the second incidence relation;
output module for
And outputting the first query target at the second terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910992368.3A CN110851618B (en) | 2019-10-18 | 2019-10-18 | Management method and device for form data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910992368.3A CN110851618B (en) | 2019-10-18 | 2019-10-18 | Management method and device for form data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110851618A true CN110851618A (en) | 2020-02-28 |
| CN110851618B CN110851618B (en) | 2023-09-26 |
Family
ID=69597675
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910992368.3A Active CN110851618B (en) | 2019-10-18 | 2019-10-18 | Management method and device for form data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110851618B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170228372A1 (en) * | 2016-02-08 | 2017-08-10 | Taiger Spain Sl | System and method for querying questions and answers |
| CN109902087A (en) * | 2019-02-02 | 2019-06-18 | 上海奔影网络科技有限公司 | For the data processing method and device of question and answer, server |
| CN110222049A (en) * | 2019-05-07 | 2019-09-10 | 北京来也网络科技有限公司 | Data processing method and device based on more wheel dialogues |
-
2019
- 2019-10-18 CN CN201910992368.3A patent/CN110851618B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170228372A1 (en) * | 2016-02-08 | 2017-08-10 | Taiger Spain Sl | System and method for querying questions and answers |
| CN109902087A (en) * | 2019-02-02 | 2019-06-18 | 上海奔影网络科技有限公司 | For the data processing method and device of question and answer, server |
| CN110222049A (en) * | 2019-05-07 | 2019-09-10 | 北京来也网络科技有限公司 | Data processing method and device based on more wheel dialogues |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110851618B (en) | 2023-09-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11086289B2 (en) | Control interface for metric definition specification for assets driven by search-derived asset tree hierarchy | |
| CN104572889B (en) | A kind of search word recommends methods, devices and systems | |
| CN102460431B (en) | Behavior and the system and method for context data analysis | |
| DE112019006389T5 (en) | Automated training and selection of models for document analysis | |
| US20210224488A1 (en) | Business graph engine for connection recommendations | |
| CN103412951A (en) | Individual-photo-based human network correlation analysis and management system and method | |
| CN102880687A (en) | Personal interactive data retrieval method and system based on tag technology | |
| CN111506569B (en) | Data storage method and device and electronic device | |
| CN110119473A (en) | A kind of construction method and device of file destination knowledge mapping | |
| CN115757689A (en) | Information query system, method and equipment | |
| CN105893636A (en) | Historical sharing recording method and device | |
| CN112766936A (en) | Intelligent customer service processing method and system | |
| Kalantari et al. | Automatic spatial metadata systems–the case of Australian urban research infrastructure network | |
| CN103699590B (en) | The method and server of graphic tutorial problem solution are provided | |
| JP2006119911A (en) | Human resource retrieval system, human resource registration device, human resource retrieval device, human resource registration method, human resoruce retrieval method, program and storage medium | |
| CN103034728B (en) | Social network academic resources interaction platform is utilized to carry out the method for information interaction | |
| CN110851618A (en) | Management method and device of table data | |
| CN107402748A (en) | Information processing method and device for communications applications | |
| US9542457B1 (en) | Methods for displaying object history information | |
| CN110062112A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN116089490A (en) | Data analysis method, device, terminal and storage medium | |
| US20220237185A1 (en) | Intelligent data enrichment using knowledge graph | |
| CN112860725A (en) | SQL automatic generation method and device, storage medium and electronic equipment | |
| Cheng et al. | Extensions of GAP‐tree and its implementation based on a non‐topological data model | |
| Lim et al. | Tabu search embedded simulated annealing for the shortest route cut and fill problem |
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 |