CN114519099A - Method for providing visual interactive interface for database, electronic equipment and storage medium - Google Patents

Method for providing visual interactive interface for database, electronic equipment and storage medium Download PDF

Info

Publication number
CN114519099A
CN114519099A CN202111670168.XA CN202111670168A CN114519099A CN 114519099 A CN114519099 A CN 114519099A CN 202111670168 A CN202111670168 A CN 202111670168A CN 114519099 A CN114519099 A CN 114519099A
Authority
CN
China
Prior art keywords
entity
information
database
target
display area
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.)
Pending
Application number
CN202111670168.XA
Other languages
Chinese (zh)
Inventor
陈文钦
詹念怡
周奥鸽
司伟涛
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fulian Intelligent Workshop Zhengzhou Co Ltd
Original Assignee
Fulian Intelligent Workshop Zhengzhou Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fulian Intelligent Workshop Zhengzhou Co Ltd filed Critical Fulian Intelligent Workshop Zhengzhou Co Ltd
Priority to CN202111670168.XA priority Critical patent/CN114519099A/en
Publication of CN114519099A publication Critical patent/CN114519099A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/34Browsing; Visualisation therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9024Graphs; Linked lists
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/90335Query processing
    • G06F16/90344Query processing by using string matching techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/904Browsing; Visualisation therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention provides a method, electronic equipment and a computer readable storage medium for providing a visual interactive interface for a database, wherein the database comprises a plurality of entities, each entity has relevance with at least one other entity, the interface comprises an image display area and an information display area, and the method comprises the following steps: displaying a target entity and a first associated entity associated with the target entity in the image display area, wherein the information display area displays entity information of the target entity, and 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 entity information of the first associated entity in the information display area based on the fact that the first associated entity is marked as the central entity. The invention can realize the visual display of the entities and the incidence relation thereof in the database.

Description

Method for providing visual interactive interface for database, electronic equipment and storage medium
Technical Field
The present invention relates to the field of database technologies, and in particular, to a method, an electronic device, and a computer-readable storage medium for providing a visual interactive interface for a database.
Background
The knowledge-graph class database generally comprises a plurality of entities, and the entities have relevance. The interactive interface of the knowledge map database is generally provided with a search box for a user to search for required information. The user can input keywords in the search box for retrieval, and the retrieval result is generally presented according to items. The presentation of the query results in terms is relatively rigid and not straightforward.
Disclosure of Invention
In view of the foregoing, the present invention provides a method, an electronic device, and a computer-readable storage medium for providing a visual interactive interface for a database, which can visually display an entity and an entity association relationship in the database, and the entity association relationship has a good graphic presentation effect.
One embodiment of the present application provides a method for providing a visual interactive interface for a database, where the interface includes an image display area and an information display area, and the method includes: displaying a target entity and a first associated entity associated with the target entity in the image display area, wherein the information display area displays entity information of the target entity, and 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 entity information of the first associated entity in the information display area based on the fact that the first associated entity is marked as the central entity.
In an embodiment, the method further comprises: acquiring a retrieval string; and matching the corresponding target entity and the first associated entity associated with the target entity based on the search string.
In an embodiment, the method further comprises: and switching the entity information of the first associated entity displayed in the information display area to display the entity information of the target entity based on the fact that the first associated entity is marked as the central entity, or displaying the entity information of the first associated entity and the entity information of the target entity in the information display area.
In an embodiment, the interface further includes an output identifier, the output identifier is displayed in the information display area, and the method further includes; receiving an output instruction corresponding to the output identification; generating a document of the entity information of the central entity based on the output instruction; and outputting the document.
In one embodiment, the method further comprises: querying a second associated entity associated with the first associated entity based on the first associated entity being marked as the central entity; and displaying the first associated entity and the second associated entity in the image display area.
In an embodiment, the image display area further comprises a first attribute of the target entity and the first associated entity, the first attribute comprising a quantity.
In an embodiment, 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 associated entity, wherein the brief information is a part of the entity information.
In an embodiment, the method further comprises: 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.
In an embodiment, the method further comprises: and switching the first attribute of the target entity to be the first attribute associated with the brief information based on the name of the target entity or the name of the first associated entity.
In an embodiment, the method further comprises: 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 rest brief information corresponding to the first associated entity, and receiving a viewing instruction corresponding to another brief information; and switching the name of the first associated entity into two names for accepting the brief information of the viewing instruction.
In an embodiment, the method further comprises: receiving a revocation instruction corresponding to the target entity or the first associated entity; and 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.
In an embodiment, the method further comprises: receiving a movement instruction corresponding to the central entity; moving the central entity based on the movement instruction.
An embodiment of the present application provides a computer-readable storage medium, which stores computer instructions, and when the computer instructions are executed on an electronic device, the electronic device executes the above method for providing a visual interactive interface for a database.
An embodiment of the present application provides an electronic device, where the electronic device includes a processor and a memory, where 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 method for providing a visual interactive interface for a database.
The method, the electronic equipment and the computer-readable storage medium for providing the visual interactive interface for the database can visually display the target entity in the database and the associated entity associated with the target entity, have good graphic presentation effect of the association relation between the entities, can realize the dual mode of retrieving word strings and instructions to retrieve data in the database, and can also download the queried data.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a flowchart illustrating steps of a method for providing a visual interactive interface for a database, in accordance with an embodiment of the present invention.
FIGS. 2-18 are schematic diagrams illustrating display contents of an interactive interface according to an embodiment of the invention.
FIG. 19 is a functional block diagram of a visual interaction device in accordance with an embodiment of the present invention.
Fig. 20 is a schematic diagram of an electronic device according to an embodiment of the invention.
Description of main original symbols:
the interactive interface 11, the image presentation area 111, the information presentation area 112, the retrieval input area 113, the entity profile area 114, the target entity 120, the first associated entity 130, the second associated entity 140, the brief information 150, the visual interaction device 10, the providing module 101, the display module 102, the receiving module 103, the updating module 104, the electronic device 100, the memory 20, the processor 30, and the computer program 40.
Detailed Description
So that the manner in which the above recited objects, features and advantages of the present invention can be understood in detail, a more particular description of the invention, briefly summarized above, may be had by reference to the embodiments thereof which are illustrated in the appended drawings. In addition, the embodiments and features of the embodiments of the present application may be combined with each other without conflict.
In the following description, numerous specific details are set forth to provide a thorough understanding of the present invention, and the described embodiments are merely a subset of the embodiments of the present invention, rather than a complete embodiment. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.
The method for providing the visual interactive interface 11 for the database is applied to one or more electronic devices. An electronic device is a device capable of automatically performing numerical calculation and/or information processing according to a preset or stored instruction, and its hardware includes, but is not limited to, a Processor, a micro programmed Control Unit (MCU), an Application Specific Integrated Circuit (ASIC), a Programmable Gate Array (FPGA), a Digital Signal Processor (DSP), an embedded device, and the like.
The electronic device may be a desktop computer, an industrial computer, a notebook computer, a server, or other computing device. The electronic equipment can be in man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch panel or voice control equipment and the like.
FIG. 1 is a flowchart illustrating steps of an embodiment of a method for providing a visual interactive interface 11 for a database. The order of the steps in the flow chart may be changed and some steps may be omitted according to different needs.
Referring to fig. 1, a method of providing a visual interactive interface 11 for a database may include the following steps.
Step S11, displaying the target entity 120 and the first associated entity 130 associated with the target entity 120 in the image display area 111, and displaying 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.
In an embodiment, a database may include a plurality of entities, each entity having an association with at least one other entity. The database may be a knowledge graph database and the entities may be entities within the knowledge graph database. The interactive interface 11 may refer to a human-machine interface 11 of a 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 the target entity 120 has a semantic relationship with the central entity in the knowledge-graph.
In one embodiment, as shown in fig. 2, 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 a result of an instruction input by the user on the interactive interface 11, and 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 connection line is displayed between the target entity 120 and the first associated entity, as shown in fig. 2, a connection line with an arrow is set between an employee of the target entity 120 and a manufacturing site of the first associated entity 130, where the arrow points to the first associated entity 130 associated therewith from the target entity 120; or the first associated entity 130 is arranged annularly around the target entity 120, etc. The information display area 112 may be used to display entity information of the central entity, and 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. The entity information may include data information and attribute information, and if the target entity 120 is an employee, the data information includes department information, job number information, job entry date, and the like, for example, the data information is: and (4) department: manufacturing department, job number: h20211217, date of entry: 2019/06/11, the attribute information includes name, number, etc., for example, name: a1, name: a2, so the complete entity information is: name: a1, department: manufacturing department, job number: h20211217, date of entry: 2019/06/11, respectively; name: a2, department: manufacturing department, job number: h20211218, date of entry: 2019/06/11. The central entity "employee" is shown in fig. 2 as the target entity 120, and the information display area 112 is used for displaying entity information of the target entity 120 "employee". The image display area 111 may default to have a central entity when the interactive interface 11 is opened, or the image display area 111 may be blank when the interactive interface 11 is opened, and the corresponding central entity is displayed by receiving an instruction. In other embodiments, the entity information may be displayed together with the text information and the picture information, or only the picture information, so as to facilitate the reference.
Step S12, a marking instruction corresponding to the first associated entity 130 is received.
The marking instruction can be set according to actual requirements, for example, the marking instruction can be a double-click signal, a single-click signal or a voice instruction. Specifically, when the user double-clicks or single-clicks the first associated entity 130 through 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 designating the first associated entity 130.
Step S13, based on the marking instruction, marks the first associated entity 130 as the central entity.
The image presentation area 111 receives the double-click or single-click signal designating the first associated entity 130, and marks the first associated entity 130 as a central entity.
Step S14, displaying the entity information of the first associated entity 130 in the information display area 112 based on the first associated entity 130 being marked as the central entity.
When the first associated entity 130 is designated as a central entity, the information presentation area 112 may be updated, and the information presentation area 112 may be used to display entity information of the first associated entity 130, as shown in fig. 3. The target entity 120 is a central entity, and when the first associated entity 130 is designated as the central entity, the information display area 112 is updated, and the entity information that previously displays the target entity 120 is updated to display the entity information of the first associated entity 130, that is, the information display area 112 is updated from the one shown in fig. 2 to the one shown in fig. 3. For example, the entity information of the first associated entity 130 is: manufacturing: one or two places are displayed in the information display area 112. For ease of reading, there may also be a result or identification of the result in the information presentation area 112.
Further, the step of updating the information display area 112 includes: based on the fact that the first associated entity 130 is marked as a central entity, the entity information of the first associated entity 130 displayed in the information display area 112 is switched to display the entity information of the target entity 120, or the entity information of the first associated entity 130 and the entity information of the target entity 120 are displayed in the information display area 112.
In an embodiment, the information may be switched in the information presentation area 112, or after the information of the target entity 120 is presented and the first associated entity 130 is marked as a central entity, the information of the first associated entity 130 is added in the information presentation area 112.
In an embodiment, the method for providing the visual interactive interface 11 for the database may further include: acquiring a retrieval string; based on the search string, the corresponding target entity 120 and the first associated entity 130 associated with the target entity 120 are matched. In this embodiment, the target entity 120 and the first associated entity 130 associated with the target entity 120 can also be searched by inputting the search string. As shown in fig. 4, in order to facilitate the input of the search string, the interactive interface 11 is further provided with a search input area 113, and the search input area 113 allows the user to input the search string, and 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. 5. If the acquired search word string is not an entity in the knowledge graph, the search word string is not displayed, if the acquired search word string comprises at least two entities, one entity can be selected to be displayed, and an entity with a higher level is displayed, or both entities are displayed, and the relationship between the two entities is displayed.
Further, the visual interactive interface further includes an output identifier, and the output identifier is displayed in the information display area 112. The method of providing a visual interactive interface 11 for a database may further comprise: receiving an output instruction corresponding to the output identifier; generating a document of entity information of the central entity based on the output instruction; and outputting the document.
As shown in fig. 5, the output identifier may be an output button or an output typeface, such as displaying "export," so that, after clicking the identifier, the database may generate an EXCEL document or a PDF document from the information of the information presentation area 112 and output the generated document. If the target entity 120 is a document, the information display area 112 displays a plurality of specific documents, and sets each document to be previewable, and when the name of the document is clicked, the document can be previewed, and after the output identifier is clicked, the database can generate an EXCEL document or a PDF document from the information in the information display area 112, and output the generated document.
In one embodiment, based on the first associated entity 130 being marked as a central entity, a second associated entity 140 associated with the first associated entity 130 is queried; the first associated entity 130 and the second associated entity 140 are displayed in the image display area 111.
The second associated entity 140 may be displayed along with the first associated entity 130 at the same time as the first associated entity 130, or may be annularly arranged on the peripheral side of the first associated entity 130, the number of the second associated entities 140 may be one or more, and if there are more, the fan-shaped structures are annularly arranged on the peripheral side of the first associated entity 130. The number of second associated entities 140 is related to the number of first associated entities 130 for which the first associated entities 130 have a semantic relationship in the knowledge-graph. As shown in fig. 6, the target entity 120 is an employee, the first associated entity 130 is a manufacturing site, and the second associated entity 140 is a factory. The first and second associated entities 130, 140 shown in fig. 6 are shown with a connecting line with an arrow pointing from the first associated entity 130 to the second associated entity 140 associated therewith. Further, based on the semantic relationship in the knowledge-graph, the second associated entity 140 may also have a third associated entity associated therewith, the third associated entity may also have a fourth associated entity associated therewith, and so on, which interact in a manner similar to the interaction between the target entity 120 and the first associated entity 130, and the first associated entity 130 and the second associated entity 140.
In an embodiment, no matter the entities are arranged in a ring or in a line, the entities and the entities associated therewith may be set with different colors at the same time, 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, so that the distinction by color is facilitated and the association relationship between the entities is displayed more clearly.
In an embodiment, the image presentation area further comprises first attributes of the target entity 120 and the first associated entity 130. The first attribute may be a quantity, i.e. the number of included attributes. As shown in fig. 7, the target entity 120 and the first associated entity 130 each have a number displayed thereon, which is the number of profile information 150 respectively contained by the target entity 120 and the first associated entity 130. If the image display area displays a second associated entity 140, a third associated entity, etc., the number of the brief information 150 included in the corresponding associated entity is also displayed. The target entity 120 employee shown in fig. 7 contains 1677 pieces of profile information, and the first associated entity 130 manufacturer contains 2 pieces of profile information 150. The first attribute may partially obscure the corresponding entity, and as shown in fig. 7, the first attribute of the target entity 120 (e.g., employee) is 1677 (i.e., employee number is 1677), and the first attribute 1677 is partially obscured on the target entity 120, so that the first attribute of the target entity 120 can be directly viewed. The information display area 112 may display all the entity information, and when the displayed information exceeds the current page range, the information display area 112 displays a scroll bar, and the related information can be looked up by dragging the scroll bar.
In an embodiment, the method for providing the visual interactive interface 11 for the database may further include: receiving a viewing instruction corresponding to the target entity 120 or the first associated entity 130; based on the viewing instruction, profile information 150 corresponding to the target entity 120 or the first associated entity 130 is displayed, wherein the profile information 150 is a portion 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 is displayed, the brief information 150 is a part of the entity information, and the brief information 150 is the same kind of information, for example, as shown in fig. 7, if the target entity 120 is an employee, the brief information 150 is the name of the employee, if the first associated entity 130 is a manufacturing place, the brief information 150 is one place or two places included in the manufacturing place. To facilitate distinguishing the differences between the target entity 120, the first associated entity 130 and the brief information 150, the images of the target entity 120 and the first associated entity 130 may be set to be the same size, while the image of the brief information 150 is smaller than the images of the target entity 120 and the first associated entity 130, while the color of the brief information 150 is set to be the same as its corresponding entity color for easy reference. In fig. 7, receiving the viewing instruction of the employee of the target entity 120, the image display area 111 displays 1677 employee name information included in the employee of the target entity 120, because the number of employees is too large, only 6 employees a 1-a 6 are shown in the figure, meanwhile, an operation arrow is set on the target entity 120, receiving the instruction of the operation arrow, and the image display area 111 is turned forward or backward for easy reference, in other embodiments, the number of the brief information 150 displayed on one page may be set to 8, 10, etc., and meanwhile, the brief information 150 may be set to have the same or different distance from the target entity 120. The brief information 150 may be configured to be movable, and a drag command for the brief information 150 may be received, and the position of the brief information 150 may be moved in the image display area 111 following the command.
In an embodiment, the method for providing the visual interactive interface 11 for the database may further include: receiving a viewing instruction corresponding to a profile 150; the name of the target entity 120 or the name of the first associated entity 130 is switched to the name of the profile 150. For example, clicking on a1 in fig. 7, the name of the target entity 120 is switched to a1, as shown in fig. 8, and the information presentation area 112 is changed to have only the related information of a 1.
In an embodiment, the name of the target entity 120 or the name of the first associated entity 130 may also be switched to the name of the profile 150, and the first attribute of the target entity 120 may be switched to the first attribute associated with the profile 150. Since the target entity 120 and the first associated entity 130 display the information related to each other, when the target entity 120 is switched to the brief information 150, the first associated entity 130 also displays the information related to the brief information 150, as shown in fig. 8, since the target entity 120 is switched to employee a1, the first attribute of the target entity 120 is modified to 1, the first attribute of the manufacture place of the first associated entity 130 is modified to 1, and the information display area 112 is switched to the entity information of a 1. If a plurality of employee names are all A1, the first attribute of the target entity 120 is modified to the number of the employees with the same name, the attribute of the first associated entity 130 is correspondingly modified, and the information display area 112 simultaneously displays all the entity information with the name A1. At this point, a viewing instruction corresponding to the first associated entity 130 is received, and the profile 150 corresponding to the first associated entity 130 is displayed as information associated with the target entity 120A 1. For example, if employee A1 is department in the data information, the manufacturing site summary information 150 of the first related entity 130 is only displayed at one place, as shown in FIG. 9. If the target entity 120 is an employee, the manufacturing site displays brief information 150 having one or two locations, as shown in FIG. 10.
In one embodiment, a viewing instruction corresponding to the first associated entity 130 is received, and based on the viewing instruction, the profile information 150 corresponding to the first associated entity 130 is displayed, as shown in FIG. 10, the profile information 150 at the manufacturing site of the first associated entity 130 is displayed at one site and at two sites. Receiving a 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, as shown in fig. 11, when the viewing instruction is received at one location of the brief information 150, the name of the first associated entity 130 is switched from the manufacturing location to one location, since the central entity is the target entity 120, the information display area 112 is not changed, at this time, the first attribute of the target entity 120 is changed, that is, when one location is selected, the number of employees of the target entity 120 is changed to the number of employees belonging to the one location, which is changed 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 the viewing instruction and displays other brief information 150 corresponding to the first associated entity 130, as shown in fig. 12, only two brief information 150 are displayed at this time. When one of the remaining profiles 150 receives the viewing command, the name of the first associated entity 130 is switched to the two viewed profile names, and the first attribute of the target entity 120 is changed at the same time. As shown in fig. 13, the name of the first associated entity 130 is modified to be one or two, and at this time, the first attribute of the target entity 120 is changed to 1677, and since the manufacturing site includes only one or two, when both of them are selected, the number of employees is displayed as the number of all employees. The corresponding second associated entity 140 may also perform corresponding interaction, that is, the non-central entity may perform the above interaction manner, so as to filter the specific information.
In an embodiment, the method for providing the visual interactive interface 11 for the database may further include: receiving a revocation 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 presentation area 112 is switched to the information of the target entity 120.
The revocation instruction may be to restore the modified name between the first associated entity 130 and the target entity 120 to an initial state, as shown in fig. 14; or, the state is withdrawn to the previous step, for example, the state in fig. 13 is withdrawn to the state in fig. 11, and after the withdrawal instruction is received again, the state in fig. 11 is withdrawn to the initial state, so as to facilitate the subsequent review and search. The withdrawal instruction may be a voice instruction, such as receiving a voice "return" or "withdraw" to allow name exchange of the target entity 120 or the first associated entity 130. The withdrawal instruction can also be right click, and when the mouse is moved to a corresponding entity, the withdrawal operation can be carried out after the instruction of the right click is received.
Step S15, receiving a moving instruction corresponding to the central entity; based on the movement instruction, the central entity is moved.
In one embodiment, the image presentation area 111 may receive movement instructions corresponding to a central entity. The movement instruction may be an operation of long-clicking and moving the mouse or an operation of moving the mouse after left-clicking, and when the movement instruction corresponding to the center entity is received, the position of the center entity in the image display area 111 is moved.
In one embodiment, while moving the central entity, the associated entities move synchronously, and the positions of the associated entities relative to the central entity are not changed, while moving the non-target entity 120, the positions of the other associated entities are not changed, and only the position of the moved entity is changed; in another embodiment, when the central entity is moved, only the position of the central entity is moved, and the positions of the other associated entities are not changed.
Fig. 15 shows that the target entity 120 and the first associated entity 130 are arranged in a ring shape, the four first associated entities 130 form a ring structure and are arranged outside the target entity 120, and if the name of the first associated entity 130 needs to be viewed, the corresponding positions of the ring structure can be clicked to display, and fig. 16 shows a schematic diagram of all the four first associated entities 130, so that in order to view the entire view of the image display area 111, the position of pulling the target entity 120 can be integrally dragged to other positions of the image display area 111. If the contents of all the first associated entities 130 are directly viewed in fig. 15, the portion of the first associated entities 130 beyond the image display area 111 is not displayed. The connection between the first correlation entity 130 and the target entity 120 may not correspond to its ring structure at the target entity 120. When some first associated entities 130 do not need to be viewed, the mouse can be moved to the corresponding connecting line, and the corresponding first associated entities 130 can be turned off by receiving the deletion instruction of the mouse, and fig. 17 shows the view after the two first associated entities 130 of the document and the machine are turned off, at this time, the positions of the employees of the target entity 120 are dragged, and the positions of the first associated entities 130 are adjusted, and if the first associated entity 130 of the technical level is pushed alone, the positions of the employees can be adjusted alone, as shown in fig. 18.
In one embodiment, the interactive interface 11 may further include an entity profile area 114, the entity profile area 114 configured to list information for all entities and first attributes in the database. For example, as shown in FIG. 15, the entity profile area 114 displays content including "employee (1677), manufacturer (2), technical level (5), document (224), model (5)". I.e., the database contains 1677 employees 'information, 2 manufacturing departments' information, 5 technical levels of information, 224 documents of information, and 5 models of information. The user can display the corresponding entity in the image display area 111 by clicking the entity in the profile area, and the information of the entity is displayed in the information display area. The entity profile area 114 may present all of the entity information or only a portion of the entity information, which may be some of the entities that are queried with high frequency.
The method for providing the visual interactive interface 11 for the database can visually display the entities and the entity association relationship in the database, has good graphic presentation effect of the entity association relationship, can realize the retrieval of the data in the database in a double mode of search box and click interaction, and can also download the inquired data by a user.
FIG. 19 is a functional block diagram of a visual interaction device according to an embodiment of the present invention.
Referring to fig. 19, the visual interaction apparatus 10 is applied to an electronic device. The electronic device may be any one of a cell phone, a computer, a tablet, a server, etc., and the visual interaction apparatus 10 may include one or more modules that may be stored in a memory of the electronic device and configured to be executed by one or more processors to implement the present invention. For example, referring to fig. 10, the visual interaction apparatus 10 may include a providing module 101, a displaying module 102, a receiving module 103, and an updating module 104. The modules referred to in the embodiments of the present invention may be program segments that perform a specific function, and are more suitable than programs for describing the execution process of software in a processor.
It is understood that, corresponding to the embodiments of the method for providing a visual interactive interface for a database, the visual interactive apparatus 10 may include some or all of the functional modules shown in fig. 10, and the functions of the modules 101 to 104 will be described in detail below. It should be noted that the same noun terms and their specific explanations in the above embodiments of the method for providing a visual interactive interface for a database may also be applied to the following functional descriptions of the modules 101 to 104. For brevity and to avoid repetition, further description is omitted.
The providing module 101 is used for providing an interactive interface. In one embodiment, as shown in fig. 2, 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 a result of a user inputting an instruction on the interactive interface 11, and the image display area 111 may display a target entity and a first associated entity associated with the target entity.
In one embodiment, the interactive interface 11 may further include an entity profile area 114, the entity profile area 114 for listing information of all entities and the first attribute in the display database.
The display module 102 is configured to display the target entity and the at least one first associated entity in the image display area 111. The receiving module 103 is configured to receive an instruction corresponding to the interactive interface. The update module 104 is used for updating the image display area 111.
Displaying a target entity 120 and a first associated entity 130 associated with the target entity 120 in an image display area 111, and displaying entity information of the target entity 120 in an 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 update module 104 marks the first associated entity 130 as a 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.
The receiving module 103 obtains the search string; based on the search string, the corresponding target entity 120 and the first associated entity 130 associated with the target entity 120 are matched and displayed by the display module 102.
Based on the first associated entity 130 being marked as a central entity, the update module 104 switches the entity information of the first associated entity 130 displayed in the information display area to display 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.
The interface of the display module 102 further comprises an output identifier, the output identifier is displayed in the information display area, and the method further comprises the following steps; the receiving module 103 receives an output instruction corresponding to the output identifier; generating a document of entity information of the central entity based on the output instruction; and outputting the document.
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 queried; the display module 102 displays the first associated entity 130 and the second associated entity in the image display area 111.
In an embodiment, the image presentation area of the display module 102 further comprises a first attribute of the target entity 120 and the first associated entity 130. The first attribute includes a quantity.
In one embodiment, the receiving module 103 receives a viewing instruction corresponding to the target entity 120 or the first associated entity 130; based on the viewing instruction, the display module 102 displays at least one brief information corresponding to the target entity 120 or the first associated entity 130, wherein the brief information is a part of the entity information. The receiving module 103 receives a viewing 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.
In one embodiment, the first attribute of the target entity 120 or the first associated entity 130 is switched 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.
Based on the name of the first associated entity 130 being switched to the name of the brief information, the receiving module 103 receives the 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 rest of the brief information corresponding to the first associated entity 130, and the receiving module 103 receives the viewing instruction corresponding to another brief information; the update module 104 switches the name of the first associated entity 130 to two names of the profile information that accept the viewing instruction.
In an embodiment, the receiving module 103 receives a revocation 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 of the target entity 120 is switched to the information display area.
In one embodiment, the receiving module 103 receives a movement instruction corresponding to the central entity; based on the movement instruction, the update module 104 updates the position of the central entity in the image presentation area 111.
The visual interaction device can visually display the entity and the entity incidence relation in the database, the graphic presentation effect of the entity incidence relation is good, the data in the database can be retrieved in a double mode of search box and click interaction, and a user can also download the inquired data.
FIG. 20 is a diagram of an electronic device according to a preferred embodiment of the invention.
The electronic device 100 comprises a memory 20, a processor 30 and a computer program 40, such as the visual interaction means 10, stored in the memory 20 and executable on the processor 30. The processor 30, when executing the computer program 40, implements the steps of the above-described method embodiment for providing a visual interactive interface for a database, such as the steps S11-S15 shown in fig. 1. Alternatively, the processor 30, when executing the computer program 40, implements the functions of the modules in the above-mentioned visual interactive apparatus embodiment, such as the modules 101 to 104 in fig. 19.
In one embodiment, some of the modules (101-104) shown in fig. 10 may be executed by the processor 30, and another part may be executed by other hardware (e.g., a display screen, etc.). For example, the modules 101, 103-104 are executed by the processor 30.
Illustratively, the computer program 40 may be partitioned into one or more modules/units, which are 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 performing specific functions, the instruction segments describing the execution of the computer program 40 in the electronic device 100. For example, the computer program 40 may be divided into a providing module 101, a display module 102, a receiving module 103, and an updating module 104 in fig. 10. The specific functions of the modules are referred to the above embodiments.
The electronic device 100 may be a desktop computer, an industrial computer, a numerical control device, a server, or other computing device. Those skilled in the art will appreciate that the schematic diagram is merely an example of the electronic device 100 and does not constitute a limitation of the electronic device 100 and may include more or less components than those shown, or combine certain components, or different components, e.g., the electronic device 100 may also include input-output devices, network access devices, buses, etc.
The Processor 30 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. The general purpose processor may be a microprocessor or the processor 30 may be any conventional processor or the like, the processor 30 being the control center for the electronic device 100 and the various interfaces and lines connecting the various parts of the overall electronic device 100.
The memory 20 may be used to store the computer program 40 and/or the module/unit, and the processor 30 may implement various functions of the electronic device 100 by running or executing the computer program and/or the module/unit stored in the memory 20 and calling data stored in the memory 20. The memory 20 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data created according to the use of the electronic apparatus 100, and the like. In addition, the memory 20 may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other non-volatile solid state storage device.
The integrated modules/units of the electronic device 100 may be stored in a computer-readable storage medium if they are implemented in the form of software functional units and sold or used as separate products. Based on such understanding, all or part of the flow in the method according to the embodiments of the present invention may also be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and when the computer program is executed by a processor, the steps of the embodiments of the method may be implemented. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer readable medium may include: any entity or device capable of carrying computer program code, recording medium, U.S. disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution media, and the like. It should be noted that the computer readable medium may contain other components which may be suitably increased or decreased as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, in accordance with legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunications signals.
In the several embodiments provided in the present invention, it should be understood that the disclosed electronic device and method may be implemented in other manners. For example, the above-described embodiments of the electronic device are merely illustrative, and for example, the division of the unit is only one logical function division, and there may be other division ways in actual implementation.
In addition, functional units in the embodiments of the present invention may be integrated into the same processing unit, or each unit may exist alone physically, or two or more units are integrated into the same unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are, therefore, to be considered in all respects as illustrative and not restrictive. Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. The terms first, second, etc. are used to denote names, but not to denote any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims (14)

1. A method of providing a visual interactive interface for a database, the interface comprising an image presentation area and an information presentation area, the method comprising:
displaying a target entity and a first associated entity associated with the target entity in the image display area, wherein the information display area displays entity information of the target entity, and 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 entity information of the first associated entity in the information display area based on the fact that the first associated entity is marked as the central entity.
2. A method of providing a visual interactive interface for a database as recited in claim 1, said method further comprising:
acquiring a retrieval string;
and matching a corresponding target entity and the first associated entity associated with the target entity based on the search string.
3. A method of providing a visual interactive interface for a database as recited in claim 1, said method further comprising:
and switching the entity information of the first associated entity displayed in the information display area to display the entity information of the target entity based on the fact that the first associated entity is marked as the central entity, or displaying the entity information of the first associated entity and the entity information of the target entity in the information display area.
4. The method for providing a visual interactive interface for a database in accordance with claim 1,
the interface further comprises an output identifier, the output identifier is displayed in the information display area, and the method further comprises the following steps;
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.
5. A method of providing a visual interactive interface for a database as recited in claim 1, said method further comprising:
querying a second associated entity associated with the first associated entity based on the first associated entity being marked as the central entity;
and displaying the first associated entity and the second associated entity in the image display area.
6. The method of any of claims 1 to 5, wherein the image display area further comprises a first attribute of the target entity and the first associated entity, the first attribute comprising a quantity.
7. A method of providing a visual interactive interface for a database as recited in claim 6, the method further comprising:
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 associated entity, wherein the brief information is a part of the entity information.
8. A method of providing a visual interactive interface for a database as recited in claim 7, the method further comprising:
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.
9. A method of providing a visual interactive interface for a database as recited in claim 8, the method further comprising:
and switching the first attribute of the target entity to be the first attribute associated with the brief information based on the name of the target entity or the name of the first associated entity.
10. A method of providing a visual interactive interface for a database as recited in claim 8, the method 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 rest brief information corresponding to the first associated entity, and receiving a viewing instruction corresponding to another brief information;
and switching the name of the first associated entity into two names for accepting the brief information of the viewing instruction.
11. A method of providing a visual interactive interface for a database as recited in claim 8, the method further comprising:
receiving a revocation instruction corresponding to the target entity or the first associated entity;
and 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.
12. A method of providing a visual interactive interface for a database as recited in claim 1, said method further comprising:
receiving a movement instruction corresponding to the central entity;
moving the central entity based on the movement instruction.
13. A computer readable storage medium storing computer instructions which, when run on an electronic device, cause the electronic device to perform the method of providing a visual interactive interface for a database of any of claims 1 to 12.
14. An electronic device comprising a processor and a memory, the memory storing instructions, the processor being configured to invoke the instructions in the memory to cause the electronic device to perform the method of providing a visual interactive interface for a database of any one of claims 1 to 12.
CN202111670168.XA 2021-12-31 2021-12-31 Method for providing visual interactive interface for database, electronic equipment and storage medium Pending CN114519099A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111670168.XA CN114519099A (en) 2021-12-31 2021-12-31 Method for providing visual interactive interface for database, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111670168.XA CN114519099A (en) 2021-12-31 2021-12-31 Method for providing visual interactive interface for database, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN114519099A true CN114519099A (en) 2022-05-20

Family

ID=81597341

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111670168.XA Pending CN114519099A (en) 2021-12-31 2021-12-31 Method for providing visual interactive interface for database, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN114519099A (en)

Similar Documents

Publication Publication Date Title
US8341528B2 (en) Managing the content of shared slide presentations
KR101811464B1 (en) Spin control user interface for selecting options
US8823710B2 (en) Large scale data visualization with interactive chart
US6519584B1 (en) Dynamic display advertising
US20180004399A1 (en) Presenting object properties
KR101794373B1 (en) Temporary formatting and charting of selected data
DE202017106558U1 (en) Application extension for generating automatic search queries
AU2017216247B2 (en) Systems and methods for using entity/relationship model data to enhance user interface engine
JP2007265031A (en) Dictionary content processor, content display system and content display method
EP2524300A1 (en) Apparatus and method for constructing data applications in an unstructured data environment
US9135234B1 (en) Collaborative generation of digital content with interactive reports
US7743079B1 (en) Managing data across a semantic data view and a presentation data view
CN112422754A (en) Intelligent voice configuration method and device, terminal equipment and storage medium
US8869048B2 (en) Declarative and multi-mode wizard framework
CN114519099A (en) Method for providing visual interactive interface for database, electronic equipment and storage medium
CN115543523A (en) Product description system and method based on augmented reality and artificial intelligence
CN112765946B (en) Chart display method and device and electronic equipment
JPH1040247A (en) Data processor
US10782947B2 (en) Systems and methods of diagram transformation
JP2001255976A (en) Notebook having tab including command registry and method for operating its display
CN112084252A (en) Multi-data linkage interaction method and device
JPH04223564A (en) Method of reading out computer information
JP2009157538A (en) Activity management apparatus, system and program
JPH02300917A (en) Key word input system
Zhang et al. Design of an online teaching and research communication APP based on computer algorithms

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