Method, electronic device and storage medium for providing visual interactive interface for database

By providing a visual interactive interface for knowledge graph databases, a visual display of entities and relationships is achieved, which solves the problem of non-intuitive interactive interfaces in existing technologies and improves user interaction experience and data retrieval efficiency.

CN114519099BActive Publication Date: 2025-09-12FUTAIHUA PRECISION ELECTRONICS (ZHENGZHOU) CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202111670168.X
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-12-31
Publication Date
2025-09-12
Estimated Expiration
2041-12-31

AI Technical Summary

Technical Problem

The query results of the interactive interface of existing knowledge graph databases are presented in a relatively rigid and non-intuitive entry format, resulting in a poor user interaction experience.

Method used

Provides a visual interactive interface that displays the target entity and its related entities in the image display area and displays entity information in the information display area. It supports interactive operations such as marking, retrieval, output and movement to achieve visual display of entity association relationships.

Benefits of technology

The graphical presentation of database entities and relationships has been improved. Users can search data through both search strings and interactive commands, enhancing the user experience.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114519099B_ABST
    Figure CN114519099B_ABST
Patent Text Reader

Abstract

The present invention provides a method, electronic device, and computer-readable storage medium for providing a visual interactive interface for a database. The database includes multiple entities, each entity having an association with at least one other entity. The interface includes an image display area and an information display area. The method comprises: displaying a target entity and a first associated entity associated with the target entity in the image display area, and displaying entity information of the target entity in the information display area, wherein the target entity is marked as a central entity; receiving a marking instruction corresponding to the first associated entity; marking the first associated entity as the central entity based on the marking instruction; and displaying the entity information of the first associated entity in the information display area based on the marking of the first associated entity as the central entity. The present invention can realize the visual display of entities and their associations in a database.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of database technology, and in particular to a method, electronic device, and computer-readable storage medium for providing a visual interactive interface for a database. Background Art

[0002] Knowledge graph databases typically include multiple entities, each of which is interconnected. The interactive interface of a knowledge graph database typically features a search box for users to find the information they need. Users can enter keywords in the search box to perform a search, and search results are typically presented as entries. This entry-based presentation of query results is relatively rigid and not intuitive. Summary of the Invention

[0003] In view of the above, the present invention provides a method, electronic device and computer-readable storage medium for providing a visual interactive interface for a database, which can realize the visual display of entities and entity relationships in the database, and the graphical presentation effect of entity relationships is good.

[0004] One embodiment of the present application provides a method for providing a visual interactive interface for a database, the interface including an image display area and an information display area, the method including: displaying a target entity and a first associated entity associated with the target entity in the image display area, and displaying entity information of the target entity in the information display area, wherein the target entity is marked as a central entity; receiving a marking instruction corresponding to the first associated entity; marking the first associated entity as the central entity based on the marking instruction; and displaying the entity information of the first associated entity in the information display area based on the first associated entity being marked as the central entity.

[0005] In one embodiment, the method further includes: obtaining a search string; and matching the corresponding target entity and the first associated entity associated with the target entity based on the search string.

[0006] In one embodiment, the method also includes: based on the first associated entity being marked as the central entity, switching the entity information of the first associated entity displayed in the information display area to displaying the entity information of the target entity, or displaying the entity information of the first associated entity and the entity information of the target entity in the information display area.

[0007] In one embodiment, the interface further includes an output identifier, which is displayed in the information display area, and the method further includes: receiving an output instruction corresponding to the output identifier; generating a document of the entity information of the central entity based on the output instruction; and outputting the document.

[0008] In one embodiment, the method further includes: based on the first associated entity being marked as the central entity, querying a second associated entity associated with the first associated entity; and displaying the first associated entity and the second associated entity in the image display area.

[0009] In one embodiment, the image display area further includes first attributes of the target entity and the first associated entity, and the first attributes include quantity.

[0010] In one embodiment, the method further includes: receiving a viewing instruction corresponding to the target entity or the first associated entity; and displaying at least one brief information corresponding to the target entity or the first associated entity based on the viewing instruction, wherein the brief information is part of the entity information.

[0011] In one embodiment, the method further includes: receiving a viewing instruction corresponding to the brief information; and switching the name of the target entity or the name of the first associated entity to the name of the brief information.

[0012] In one embodiment, the method further includes: switching the name of the target entity or the name of the first associated entity to the name of the brief information, and switching the first attribute of the target entity to the first attribute associated with the brief information.

[0013] In one embodiment, the method further includes: based on switching the name of the first associated entity to the name of the brief information, receiving a viewing instruction corresponding to the first associated entity after the name is changed; based on the viewing instruction, displaying the remaining brief information corresponding to the first associated entity, receiving a viewing instruction corresponding to another brief information; switching the name of the first associated entity to the names of two brief information that accept the viewing instruction.

[0014] In one embodiment, the method further includes: receiving a withdrawal instruction corresponding to the target entity or the first associated entity; switching the name of the target entity or the first associated entity to the name of the target entity or the name of the first associated entity, and switching the information display area to the information of the target entity.

[0015] In one embodiment, the method further includes: receiving a movement instruction corresponding to the central entity; and moving the central entity based on the movement instruction.

[0016] An embodiment of the present application provides a computer-readable storage medium, which stores computer instructions. When the computer instructions are executed on an electronic device, the electronic device executes the above-mentioned method of providing a visual interactive interface for a database.

[0017] An embodiment of the present application provides an electronic device, which includes a processor and a memory, wherein the memory is used to store instructions, and the processor is used to call the instructions in the memory, so that the electronic device executes the above-mentioned method of providing a visual interactive interface for a database.

[0018] The above-mentioned method, electronic device and computer-readable storage medium for providing a visual interactive interface for a database can visually display the target entity in the database and the related entities associated with the target entity. The graphical presentation of the relationship between entities is good, and data in the database can be retrieved in a dual manner through search strings and instructions. Users can also download the queried data. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0020] Figure 1 This is a flowchart of the steps of a method for providing a visual interactive interface for a database in one embodiment of the present invention.

[0021] Figures 2 to 18 It is a schematic diagram of display content of an interactive interface in one embodiment of the present invention.

[0022] Figure 19 FIG. 4 is a functional module diagram of a visual interaction device in one embodiment of the present invention.

[0023] Figure 20 FIG. 1 is a schematic diagram of an electronic device according to an embodiment of the present invention.

[0024] Description of main original symbols:

[0025] Interactive interface 11, image display area 111, information display area 112, search input area 113, entity profile area 114, target entity 120, first associated entity 130, second associated entity 140, brief information 150, visual interaction device 10, providing module 101, display module 102, receiving module 103, updating module 104, electronic device 100, memory 20, processor 30, computer program 40. DETAILED DESCRIPTION

[0026] In order to more clearly understand the above-mentioned objects, features and advantages of the present invention, the present invention is described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the absence of conflict, the embodiments of the present application and the features therein can be combined with each other.

[0027] The following description sets forth many specific details to facilitate a full understanding of the present invention. The embodiments described are only some embodiments of the present invention, not all embodiments. All other embodiments derived by persons of ordinary skill in the art based on the embodiments of the present invention without inventive effort are within the scope of protection of the present invention.

[0028] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used in the specification of the present invention herein are only for the purpose of describing specific embodiments and are not intended to limit the present invention.

[0029] The method of providing a visual interactive interface 11 for a database of the present invention is applied to one or more electronic devices. An electronic device is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions. Its hardware includes but is not limited to a processor, a microprogrammed control unit (MCU), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA), a digital signal processor (DSP), an embedded device, etc.

[0030] Electronic devices can be computing devices such as desktop computers, industrial computers, laptops, servers, etc. Electronic devices can interact with users through keyboards, mice, remote controls, touchpads, or voice control devices.

[0031] Figure 1 This is a flowchart of an embodiment of a method for providing a visual interactive interface 11 for a database according to the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.

[0032] See Figure 1 As shown, the method for providing a visual interactive interface 11 for a database may include the following steps.

[0033] Step S11 : Display the target entity 120 and the first associated entity 130 associated with the target entity 120 in the image display area 111 , and display the entity information of the target entity 120 in the information display area 112 , wherein the target entity 120 is marked as a central entity.

[0034] In one embodiment, a database may include multiple entities, each of which is associated with at least one other entity. The database may be a knowledge graph database, and the entity may refer to an entity within the knowledge graph database. The interactive interface 11 may refer to the human-computer interaction interface 11 of the database. The number of first associated entities 130 associated with the target entity 120 may be one or more, which is related to the number of first associated entities 130 that have a semantic relationship between the target entity 120 and the central entity in the knowledge graph.

[0035] In one embodiment, if Figure 2 As shown, the interactive interface 11 may include an image display area 111 and an information display area 112. The image display area 111 may be used to display the result of the user inputting a command on the interactive interface 11. The image display area 111 may display the target entity 120 and the first associated entity 130 associated with the target entity 120. For example, a connecting line is displayed between the target entity 120 and the first associated entity, as shown in FIG. Figure 2 As shown, Figure 2 As shown in FIG, a connecting line with an arrow is provided between the target entity 120, Employee, and the first associated entity 130, Manufacturing Department. The arrow points from the target entity 120 to the first associated entity 130 associated therewith. Alternatively, the first associated entity 130 is arranged in a ring around the target entity 120. The information display area 112 can be used to display entity information of the central entity. Since the target entity 120 is marked as the central entity, the information display area 112 displays the entity information of the target entity 120. Entity information may include data information and attribute information. For example, if the target entity 120 is an employee, the data information includes department information, work number information, joining date, etc. For example, the data information is: Department: Manufacturing Department 1, Work Number: H20211217, Joining Date: 2019 / 06 / 11, and the attribute information includes name, quantity, etc. For example, Name: A1, Name: A2, so the complete entity information is: Name: A1, Department: Manufacturing Department 1, Work Number: H20211217, Joining Date: 2019 / 06 / 11; Name: A2, Department: Manufacturing Department 1, Work Number: H20211218, Joining Date: 2019 / 06 / 11. Figure 2The central entity "Employee" is shown as the target entity 120, and the information display area 112 is used to display the entity information of the target entity 120 "Employee". The image display area 111 can be a default central entity when the interactive interface 11 is opened, or it can be blank when the interactive interface 11 is opened and display the corresponding central entity upon receiving a command. In other embodiments, the entity information can also be displayed using both text and image information, or only image information, for easier reference.

[0036] Step S12: Receive a marking instruction corresponding to the first associated entity 130.

[0037] The marking instruction can be set according to actual needs, for example, the marking instruction can be a double-click signal, a single-click signal, or a voice command, etc. Specifically, when the user double-clicks or single-clicks the first associated entity 130 with the mouse, a double-click or single-click signal is generated, and the image display area 111 receives the double-click or single-click signal of the designated first associated entity 130.

[0038] Step S13: Based on the marking instruction, mark the first associated entity 130 as a central entity.

[0039] The image display area 111 receives a double-click or single-click signal of the designated first associated entity 130 and marks the first associated entity 130 as a central entity.

[0040] Step S14 : Based on the first associated entity 130 being marked as a central entity, the entity information of the first associated entity 130 is displayed in the information display area 112 .

[0041] When the first associated entity 130 is designated as the central entity, the information display area 112 may be updated. The information display area 112 may be used to display entity information of the first associated entity 130, such as Figure 3 As shown. The target entity 120 is the central entity. When the first associated entity 130 is designated as the central entity, the information display area 112 is updated from the entity information of the target entity 120 previously displayed to the entity information of the first associated entity 130. That is, the information display area 112 is updated from Figure 2 Updates shown are Figure 3 For example, if the entity information of the first associated entity 130 is: Manufacturing location: location 1 and location 2, the information display area 112 will display location 1 and location 2. For easier reading, the information display area 112 may also have a RESULTS or result label.

[0042] Furthermore, the step of updating the information display area 112 includes: based on the first associated entity 130 being marked as the central entity, switching the entity information of the first associated entity 130 displayed in the information display area 112 to displaying the entity information of the target entity 120, or displaying the entity information of the first associated entity 130 and the entity information of the target entity 120 in the information display area 112.

[0043] In one embodiment, information can be switched in the information display area 112 , or after the target entity 120 information is displayed and the first associated entity 130 is marked as the central entity, information of the first associated entity 130 is added to the information display area 112 .

[0044] In one embodiment, the method for providing a visual interactive interface 11 for a database may further include: obtaining a search string; and matching the corresponding target entity 120 and the first associated entity 130 associated with the target entity 120 based on the search string. In this embodiment, the target entity 120 and the first associated entity 130 associated with the target entity 120 may also be searched by inputting the search string. Figure 4 As shown, in order to facilitate the input of the search string, the interactive interface 11 is further provided with a search input area 113, which allows the user to input the search string. After matching the corresponding target entity 120 and the first associated entity 130, the search string is displayed in the image display area 111, as shown in FIG. Figure 5 If the retrieved search string is not an entity in the knowledge graph, it will not be displayed. If the retrieved string contains at least two entities, one of them can be displayed, and the entity with a higher level can be displayed, or both entities can be displayed, and the relationship between the two entities can be displayed.

[0045] Furthermore, the visual interactive interface also includes an output identifier, which is displayed in the information display area 112. The method for providing a visual interactive interface 11 for a database may further include: receiving an output instruction corresponding to the output identifier; generating a document based on the entity information of the central entity based on the output instruction; and outputting the document.

[0046] like Figure 5 As shown, the output indicator can be an output button or the word "output", such as "Export". After clicking the indicator, the database can generate an EXCEL document or PDF document from the information in the information display area 112 and output the generated document. If the target entity 120 is a document, the information display area 112 displays multiple specific documents, and each document is set to preview. Clicking the document name can preview the document. After clicking the output indicator, the database can generate an EXCEL document or PDF document from the information in the information display area 112 and output the generated document.

[0047] In one embodiment, based on the first associated entity 130 being marked as a central entity, the second associated entity 140 associated with the first associated entity 130 is searched; and the first associated entity 130 and the second associated entity 140 are displayed in the image display area 111 .

[0048] The second associated entity 140 can be displayed along with the first associated entity 130 at the same time as the first associated entity 130 is displayed, or can be arranged in a ring around the first associated entity 130. The number of second associated entities 140 can be one or more. If there are more than one, multiple fan-shaped structures are arranged in a ring around the first associated entity 130. The number of second associated entities 140 is related to the number of first associated entities 130 that have a semantic relationship with the first associated entity 130 in the knowledge graph. Figure 6 As shown, the target entity 120 is an employee, the first associated entity 130 is a manufacturing department, and the second associated entity 140 is a factory department. Figure 6 As shown in FIG, a connecting line with an arrow is shown between the first associated entity 130 and the second associated entity 140, with the arrow pointing from the first associated entity 130 to the second associated entity 140 associated with it. Furthermore, based on the semantic relationship in the knowledge graph, the second associated entity 140 may also have a third associated entity related to it, and the third associated entity may also have a fourth associated entity associated with it, and so on. The interaction between them is similar to the interaction between the target entity 120 and the first associated entity 130, and the interaction between the first associated entity 130 and the second associated entity 140.

[0049] In one embodiment, regardless of whether the entities are arranged in a ring or a line, different colors can be set for the entity and the entities associated with it. That is, the color of the first associated entity 130 is the same as the color of the line between the first associated entity 130 and the target entity 120, thereby facilitating distinction by color and displaying the association relationship between the entities more clearly.

[0050] In one embodiment, the image display area further includes the first attributes of the target entity 120 and the first associated entity 130. The first attribute may be quantity, that is, the number of attributes included. Figure 7 As shown, numbers are displayed on the target entity 120 and the first associated entity 130. These numbers represent the number of brief information 150 contained in the target entity 120 and the first associated entity 130, respectively. If the image display area also displays a second associated entity 140, a third associated entity, etc., the number of brief information 150 contained in each associated entity is also displayed on the corresponding associated entity. Figure 7The target entity 120 employee shown in FIG contains 1677 pieces of brief information, and the first associated entity 130 manufacturing department contains 2 pieces of brief information 150. The first attribute can partially mask the corresponding entity, such as Figure 7 As shown, the first attribute of the target entity 120 (e.g., employee) is 1677 (i.e., the number of employees is 1677). This first attribute 1677 is partially obscured by the target entity 120, allowing the first attribute of the target entity 120 to be directly viewed. The information display area 112 can display all entity information. When the displayed information exceeds the current page range, the information display area 112 displays a scroll bar, which can be dragged to view related information.

[0051] In one embodiment, the method for providing a visual interactive interface 11 for a database may further include: receiving a view instruction corresponding to the target entity 120 or the first associated entity 130; based on the view instruction, displaying brief information 150 corresponding to the target entity 120 or the first associated entity 130, wherein the brief information 150 is part of the entity information. That is, by clicking or double-clicking the location of the target entity 120 or the first associated entity 130, the brief information 150 of the target entity 120 or the first associated entity 130 will be displayed, and the brief information 150 is part of the entity information, and the brief information 150 is the same type of information, such as Figure 7 As shown, if target entity 120 is an employee, brief information 150 is the employee's name. If first associated entity 130 is a manufacturing department, brief information 150 is the first and second departments within the manufacturing department. To easily distinguish between target entity 120, first associated entity 130, and brief information 150, the images of target entity 120 and first associated entity 130 can be set to the same size, while the image of brief information 150 can be smaller than the images of target entity 120 and first associated entity 130. The color of brief information 150 can also be set to the same color as its corresponding entity for easier reference. Figure 7 In the example, when a viewing instruction is received for the employees of the target entity 120, the image display area 111 displays the name information of 1677 employees of the target entity 120. Due to the large number of employees, only 6 employees A1 to A6 are shown in the figure. At the same time, an operation arrow is set on the target entity 120. When an instruction for the operation arrow is received, the image display area 111 is flipped forward or backward for easy reference. In other embodiments, the number of brief information 150 displayed on a page can be set to 8, 10, etc., and the distance between the brief information 150 and the target entity 120 can also be set to be the same or different. The brief information 150 can also be set to be movable. When a drag instruction is received for a brief information 150, the position of the brief information 150 can be moved in the image display area 111 according to the instruction.

[0052] In one embodiment, the method for providing a visual interactive interface 11 for a database may further include: receiving a viewing instruction corresponding to a brief information 150; switching the name of the target entity 120 or the name of the first associated entity 130 to the name of the brief information 150. For example, clicking Figure 7 In A1, the name of the target entity 120 is switched to A1, such as Figure 8 As shown, at the same time, the information display area 112 is changed to only the relevant information of A1.

[0053] In one embodiment, the name of the target entity 120 or the name of the first associated entity 130 may be switched to the name of the brief information 150, and the first attribute of the target entity 120 may be the first attribute associated with the brief information 150. Since the information associated with the target entity 120 and the first associated entity 130 is displayed, when the target entity 120 is switched to the brief information 150, the first associated entity 130 is also displayed as the information associated with the brief information 150. Figure 8 As shown, since the target entity 120 is switched to employee A1, the first attribute of the target entity 120 is modified to 1, and the first attribute of the first associated entity 130 Manufacturing Department is also modified to 1, and the information display area 112 is switched to the entity information of A1. If there are multiple employees named A1, the first attribute of the target entity 120 is modified to the number of duplicate employees, and the attribute of the first associated entity 130 is also modified accordingly, and the information display area 112 displays all entity information with the name A1 at the same time. At this time, the review instruction corresponding to the first associated entity 130 is received, and the brief information 150 corresponding to the first associated entity 130 is displayed as information associated with the target entity 120A1. For example, if the department in the information of employee A1 is Manufacturing Department, the brief information 150 of the first associated entity 130 Manufacturing Department is displayed only once, as shown in the following example. Figure 9 If the target entity 120 is an employee, the brief information 150 displayed in the manufacturing department will have one and two, such as Figure 10 shown.

[0054] In one embodiment, a viewing instruction corresponding to the first associated entity 130 is received, and based on the viewing instruction, the brief information 150 corresponding to the first associated entity 130 is displayed, such as Figure 10 As shown, the first associated entity 130 is displayed with the brief information 150 of the manufacturing location 1 and 2. Upon receiving the viewing instruction corresponding to a brief information 150, the name of the first associated entity 130 is switched to the name of the brief information 150, such as Figure 11As shown, when a location in the brief information 150 receives a view instruction, the name of the first associated entity 130 is switched from the manufacturing location to the location. Since the central entity is the target entity 120, the information display area 112 does not change. At this time, the first attribute of the target entity 120 changes. That is, when a location is selected, the number of employees of the target entity 120 changes to the number of employees belonging to the location, changing from 1677 to 852. After the name of the first associated entity 130 is switched to the name of the brief information 150, the first associated entity 130 receives a view instruction and displays other brief information 150 corresponding to the first associated entity 130, such as Figure 12 As shown, only two of the brief information 150 are displayed. One of the remaining brief information 150 receives the inspection instruction, and the name of the first associated entity 130 is switched to the two inspected brief names, and the first attribute of the target entity 120 is changed at the same time. Figure 13 As shown, the name of the first associated entity 130 is changed to "One" or "Two." At this point, the first attribute of the target entity 120 changes to 1677. Since the Manufacturing Department only includes "One" and "Two," when both "One" and "Two" are selected, the number of employees displayed is the total number of employees. The corresponding second associated entity 140 can also be interacted with accordingly. This means that non-central entities can also use the aforementioned interaction methods to facilitate filtering of specific information.

[0055] In one embodiment, the method for providing a visual interactive interface 11 for a database may also include: receiving a withdrawal instruction corresponding to the target entity 120 or the first associated entity 130; the name of the target entity 120 or the first associated entity 130 is switched to the name of the target entity 120 or the name of the first associated entity 130, and the information display area 112 is switched to the information of the target entity 120.

[0056] The revocation instruction may be to restore the first associated entity 130 and the target entity 120 after the name is changed to the initial state, such as Figure 14 As shown; or retreat to the previous step, for example, from Figure 13 The status in the withdrawn to Figure 11 The state of receiving the withdrawal instruction again is Figure 11 The state in the current state is retracted to the initial state to facilitate subsequent retrieval. The retraction command can be a voice command. For example, receiving the voice command "return" or "retract" can change the name of the target entity 120 or the first associated entity 130. The retraction command can also be a right-click command. When the mouse is moved over the corresponding entity and a right-click command is received, the retraction operation can be performed.

[0057] Step S15: receiving a movement instruction corresponding to the central entity; and moving the central entity based on the movement instruction.

[0058] In one embodiment, the image display area 111 can receive a movement instruction corresponding to the central entity. The movement instruction can be an operation such as a long-press click and move operation or a left-click and move operation. When the movement instruction corresponding to the central entity is received, the position of the central entity in the image display area 111 is moved.

[0059] In one embodiment, when the central entity is moved, the entities associated with it also move synchronously, and the positions of the associated entities relative to the central entity remain unchanged. When the non-target entity 120 is moved, the positions of the other associated entities remain unchanged, and only the position of the entity being moved changes. In another embodiment, when the central entity is moved, only the position of the central entity moves, and the positions of the other associated entities remain unchanged.

[0060] Figure 15 As shown in the figure, the target entity 120 and the first associated entities 130 are arranged in a ring shape. Four first associated entities 130 form a ring structure and are arranged outside the target entity 120. If you need to view the name of the first associated entity 130, you can click the corresponding position of the ring structure to display it. Figure 16 As shown in FIG, four first associated entities 130 are all displayed. In order to facilitate viewing of the entire view of the image display area 111, the position of the target entity 120 can be dragged to another position in the image display area 111. Figure 15 The content of all first related entities 130 can be directly viewed in the image display area 111. The part of the first related entity 130 that exceeds the image display area 111 is not displayed. The connection line between the first related entity 130 and the target entity 120 may not correspond to the ring structure of the target entity 120. When you do not need to view some first related entities 130, you can move the mouse to the corresponding connection line. When you receive the delete command of the mouse, you can close the corresponding first related entity 130. Figure 17 The view shown in FIG is after the two first associated entities 130, Document and Model, have been turned off. At this time, the position of the first associated entity 130 has been adjusted by dragging the position of the target entity 120, Employee. If the first associated entity 130, Technical Level, is dragged alone, its position can be adjusted independently, as shown in FIG. Figure 18 shown.

[0061] In one embodiment, the interactive interface 11 may further include an entity profile area 114, which is used to list and display information about all entities and first attributes in the database. Figure 15As shown, the entity profile area 114 displays content including "employee (1677), manufacturing department (2), technical level (5), document (224), machine model (5)". That is, the database contains information on 1677 employees, information on 2 manufacturing departments, information on 5 technical levels, information on 224 documents, and information on 5 machine models. The user can click on the corresponding entity in the profile area to display the entity in the image display area 111, and the information display area will also display the entity information. The entity profile area 114 can display all entity information or only part of the entity information. The part of the entity information may be some frequently queried entities.

[0062] The above method of providing a visual interactive interface 11 for a database can visualize the entities and entity relationships in the database. The graphical presentation of entity relationships is good, and data in the database can be retrieved in a dual manner through a search box and click interaction. Users can also download the queried data.

[0063] Figure 19 This is a functional module diagram of an embodiment of a visual interaction device of the present invention.

[0064] See Figure 19 As shown, the visual interaction device 10 is applied to an electronic device. The electronic device can be any one of a mobile phone, a computer, a tablet, a server, etc. The visual interaction device 10 can include one or more modules, and the one or more modules can be stored in the memory of the electronic device and configured to be executed by one or more processors to complete the present invention. For example, see Figure 10 As shown, the visual interaction device 10 may include a providing module 101, a display module 102, a receiving module 103 and an updating module 104. The module referred to in the embodiment of the present invention may be a program segment that performs a specific function and is more suitable for describing the execution process of software in a processor than a program.

[0065] It is understandable that, corresponding to the various embodiments of the above-mentioned method for providing a visual interactive interface for a database, the visual interactive device 10 may include Figure 10 The functions of modules 101 to 104 will be described in detail below, including some or all of the functional modules shown in FIG. It should be noted that the same nouns and their specific explanations in the various embodiments of the method for providing a visual interactive interface for a database can also be applied to the following description of the functions of modules 101 to 104. To save space and avoid repetition, they will not be repeated here.

[0066] The providing module 101 is used to provide an interactive interface. In one embodiment, Figure 2As shown, the interactive interface 11 may include an image display area 111 and an information display area 112. The image display area 111 may be used to display the result of the user inputting the command on the interactive interface 11. The image display area 111 may display the target entity and the first associated entity associated with the target entity.

[0067] In one embodiment, the interactive interface 11 may further include an entity introduction area 114 , which is used to list and display information about all entities and first attributes in the database.

[0068] The display module 102 is used to display the target entity and at least one first associated entity in the image display area 111. The receiving module 103 is used to receive instructions corresponding to the interactive interface. The updating module 104 is used to update the image display area 111.

[0069] The target entity 120 and the first associated entity 130 associated with the target entity 120 are displayed in the image display area 111, and the entity information of the target entity 120 is displayed in the information display area, wherein the target entity 120 is marked as a central entity; the receiving module 103 receives a marking instruction corresponding to the first associated entity 130; based on the marking instruction, the updating module 104 marks the first associated entity 130 as the central entity; based on the first associated entity 130 being marked as the central entity, the display module 102 displays the entity information of the first associated entity 130 in the information display area.

[0070] The receiving module 103 obtains a search string; based on the search string, matches the corresponding target entity 120 and the first associated entity 130 associated with the target entity 120 , and displays them by the display module 102 .

[0071] Based on the first associated entity 130 being marked as the central entity, the updating module 104 switches the entity information of the first associated entity 130 displayed in the information display area to the entity information of the target entity 120 , or displays the entity information of the first associated entity 130 and the entity information of the target entity 120 in the information display area.

[0072] The interface of the display module 102 also includes an output identifier, which is displayed in the information display area. The method also includes: the receiving module 103 receives an output instruction corresponding to the output identifier; based on the output instruction, generates a document for the entity information of the central entity; and outputs the document.

[0073] In one embodiment, based on the first associated entity 130 being marked as a central entity, a second associated entity associated with the first associated entity 130 is searched; and the display module 102 displays the first associated entity 130 and the second associated entity in the image display area 111 .

[0074] In one embodiment, the image display area of ​​the display module 102 further includes first attributes of the target entity 120 and the first associated entity 130. The first attribute includes quantity.

[0075] In one embodiment, the receiving module 103 receives a view instruction corresponding to the target entity 120 or the first associated entity 130. Based on the view instruction, the display module 102 displays at least one brief information corresponding to the target entity 120 or the first associated entity 130, where the brief information is a portion of the entity information. The receiving module 103 receives a view instruction corresponding to a brief information; the name of the target entity 120 or the name of the first associated entity 130 in the display module 102 is switched to the name of the brief information.

[0076] In one embodiment, based on the name of the target entity 120 or the name of the first associated entity 130 being switched to the name of the brief information, the first attribute of the target entity 120 or the first associated entity 130 is switched.

[0077] Based on the name of the first associated entity 130 being switched to the name of the brief information, the receiving module 103 receives a viewing instruction corresponding to the first associated entity 130 after the name is changed; based on the viewing instruction, the display module 102 displays the remaining brief information corresponding to the first associated entity 130, and the receiving module 103 receives a viewing instruction corresponding to another brief information; the updating module 104 switches the name of the first associated entity 130 to the names of the two brief information that receive the viewing instructions.

[0078] In one embodiment, the receiving module 103 receives a withdrawal instruction corresponding to the target entity 120 or the first associated entity 130; the name of the target entity 120 or the first associated entity 130 is switched to the name of the target entity 120 or the name of the first associated entity 130, and the update information display area is switched to the information of the target entity 120.

[0079] In one embodiment, the receiving module 103 receives a movement instruction corresponding to the central entity; based on the movement instruction, the updating module 104 updates the position of the central entity in the image display area 111 .

[0080] The above-mentioned visual interaction device can visualize the entities and entity relationships in the database. The graphical presentation of the entity relationships is good, and data in the database can be retrieved in a dual way through the search box and click interaction. Users can also download the queried data.

[0081] Figure 20 FIG. 1 is a schematic diagram of a preferred embodiment of an electronic device of the present invention.

[0082] The electronic device 100 includes a memory 20, a processor 30, and a computer program 40 stored in the memory 20 and executable on the processor 30, such as the visual interaction device 10. When the processor 30 executes the computer program 40, the steps of the above-mentioned method for providing a visual interactive interface for a database are implemented, such as Figure 1 Alternatively, when the processor 30 executes the computer program 40, the functions of each module in the above-mentioned visual interaction device embodiment are realized, for example Figure 19 Modules 101 to 104 in .

[0083] In one embodiment, Figure 10 Some of the modules (101-104) shown may be executed by the processor 30, while others may be executed by other hardware (such as a display screen, etc.). For example, the processor 30 executes modules 101 and 103-104.

[0084] For example, the computer program 40 may be divided into one or more modules / units, one or more modules / units being stored in the memory 20 and executed by the processor 30 to implement the present invention. One or more modules / units may be a series of computer program instruction segments capable of implementing specific functions, and the instruction segments are used to describe the execution process of the computer program 40 in the electronic device 100. For example, the computer program 40 may be divided into Figure 10 The providing module 101, the display module 102, the receiving module 103 and the updating module 104 in the embodiment of the present invention are shown in the above embodiment for the specific functions of each module.

[0085] The electronic device 100 may be a computing device such as a desktop computer, an industrial computer, a numerical control device, or a server. Those skilled in the art will appreciate that the schematic diagram is merely an example of the electronic device 100 and does not limit the electronic device 100 . The electronic device 100 may include more or fewer components than shown, or may combine certain components or different components. For example, the electronic device 100 may also include input and output devices, network access devices, buses, and the like.

[0086] The processor 30 may be a central processing unit (CPU), other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA), other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or processor 30 or any conventional processor. The processor 30 is the control center of the electronic device 100 and connects various parts of the entire electronic device 100 using various interfaces and lines.

[0087] The memory 20 can be used to store computer programs 40 and / or modules / units. The processor 30 implements various functions of the electronic device 100 by running or executing the computer programs and / or modules / units stored in the memory 20 and accessing data stored in the memory 20. The memory 20 may mainly include a program storage area and a data storage area. The program storage area may store an operating system and at least one application required for a function (such as a sound playback function, an image playback function, etc.); the data storage area may store data created based on the use of the electronic device 100. In addition, the memory 20 may include high-speed random access memory and non-volatile memory, such as a hard disk, internal memory, a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, at least one disk storage device, a flash memory device, or other non-volatile solid-state storage device.

[0088] If the modules / units integrated in the electronic device 100 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium, and when the computer program is executed by the processor, it can implement the steps of the above-mentioned various method embodiments. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device capable of carrying computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disk, computer memory, read-only memory (ROM), random access memory (RAM), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media do not include electric carrier signals and telecommunication signals.

[0089] In the several embodiments provided by the present invention, it should be understood that the disclosed electronic devices and methods can be implemented in other ways. For example, the electronic device embodiments described above are merely illustrative. For example, the division of units is only one logical function division, and actual implementation may employ other division methods.

[0090] In addition, the functional units in the various embodiments of the present invention may be integrated into the same processing unit, each unit may exist physically separately, or two or more units may be integrated into the same unit. The above-mentioned integrated units may be implemented in the form of hardware or hardware plus software functional modules.

[0091] It will be apparent to those skilled in the art that the present invention is not limited to the details of the exemplary embodiments described above and that the invention can be embodied in other specific forms without departing from the spirit or essential characteristics of the invention. Therefore, the embodiments should be considered in all respects as illustrative and non-limiting. Furthermore, it should be understood that the term "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. Terms such as "first" and "second" are used to designate names and do not imply any particular order.

[0092] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not limiting. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention may be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention.

Claims

1. A method for providing a visual interactive interface for a database, wherein the interface includes an image display area and an information display area, the method comprising: Displaying a target entity and a first associated entity associated with the target entity in the image display area, and displaying entity information of the target entity in the information display area, wherein the target entity is marked as a central entity, and the image display area further includes first attributes of the target entity and the first associated entity; receiving a marking instruction corresponding to the first associated entity; Based on the marking instruction, marking the first associated entity as the central entity; Based on the first associated entity being marked as the central entity, displaying the entity information of the first associated entity in the information display area; The method further comprises: receiving a viewing instruction corresponding to the target entity or the first associated entity; Based on the viewing instruction, displaying at least one brief information corresponding to the target entity or the first related entity in the image display area, wherein the brief information is a part of the entity information; receiving a viewing instruction corresponding to the brief information; Switching the name of the target entity or the name of the first associated entity to the name of the brief information; Based on the name of the target entity or the name of the first associated entity being switched to the name of the brief information, the first attribute of the target entity or the first attribute of the first associated entity is switched to the first attribute associated with the brief information.

2. The method for providing a visual interactive interface for a database according to claim 1, further comprising: Get the search string; Based on the search string, a corresponding target entity and the first associated entity associated with the target entity are matched.

3. The method for providing a visual interactive interface for a database according to claim 1, further comprising: Based on the first associated entity being marked as the central entity, the entity information of the first associated entity displayed in the information display area is switched to displaying the entity information of the target entity, or the entity information of the first associated entity and the entity information of the target entity are displayed in the information display area.

4. The method for providing a visual interactive interface for a database according to claim 1, wherein: The interface further includes an output identifier, and the output identifier is displayed in the information display area. The method further includes: receiving an output instruction corresponding to the output identifier; Based on the output instruction, generating a document from the entity information of the central entity; Output the document.

5. The method for providing a visual interactive interface for a database according to claim 1, further comprising: Based on the first associated entity being marked as the central entity, querying a second associated entity associated with the first associated entity; The first related entity and the second related entity are displayed in the image display area. 6 . The method for providing a visual interactive interface for a database according to claim 1 , wherein the first attribute comprises quantity.

7. The method for providing a visual interactive interface for a database as claimed in claim 1, further comprising: Based on the name of the first associated entity being switched to the name of the brief information, receiving a viewing instruction corresponding to the first associated entity after the name is changed; Based on the viewing instruction, displaying the remaining brief information corresponding to the first associated entity, and receiving a viewing instruction corresponding to another brief information; The name of the first associated entity is switched to two names of brief information that accept the viewing instruction.

8. The method for providing a visual interactive interface for a database as claimed in claim 1, further comprising: receiving a withdrawal instruction corresponding to the target entity or the first associated entity; The name of the target entity or the first associated entity is switched to the name of the target entity or the name of the first associated entity, and the information display area is switched to the information of the target entity.

9. The method for providing a visual interactive interface for a database according to claim 1, further comprising: receiving a movement instruction corresponding to the central entity; Based on the movement instruction, the central entity is moved.

10. A computer-readable storage medium storing computer instructions, which, when executed on an electronic device, enables the electronic device to execute the method for providing a visual interactive interface for a database according to any one of claims 1 to 9.

11. An electronic device comprising a processor and a memory, wherein the memory is used to store instructions, and the processor is used to call the instructions in the memory, so that the electronic device executes the method for providing a visual interactive interface for a database according to any one of claims 1 to 9.

Citation Information

Patent Citations

  • Data retrieval and visualization system based on knowledge graph

    CN108920716A

  • Method, device, apparatus and computer readable storage medium for generating knowledge map

    CN109271525A

  • A knowledge graph construction method and a data processing device

    CN109766445A

  • Association map display method and device, computer equipment and storage medium

    CN110377667A