CN111538746A - Information processing method, device, storage medium and equipment - Google Patents

Information processing method, device, storage medium and equipment Download PDF

Info

Publication number
CN111538746A
CN111538746A CN202010411266.0A CN202010411266A CN111538746A CN 111538746 A CN111538746 A CN 111538746A CN 202010411266 A CN202010411266 A CN 202010411266A CN 111538746 A CN111538746 A CN 111538746A
Authority
CN
China
Prior art keywords
data table
information
association
page
data
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
CN202010411266.0A
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.)
Beijing Mininglamp Software System Co ltd
Original Assignee
Beijing Mininglamp Software System 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 Beijing Mininglamp Software System Co ltd filed Critical Beijing Mininglamp Software System Co ltd
Priority to CN202010411266.0A priority Critical patent/CN111538746A/en
Publication of CN111538746A publication Critical patent/CN111538746A/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/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2452Query translation
    • G06F16/24522Translation of natural language queries to structured queries

Landscapes

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

Abstract

An embodiment of the application provides an information processing method, an information processing device, a storage medium and equipment, wherein the method comprises the following steps: receiving a first operation of a user on attribute information of a first data table displayed on a first page; responding to the first operation, and acquiring association information between the first data table and a second data table based on the attribute information of the first data table, wherein the second data table and the first data table have an association relation; and displaying the association information between the first data table and the second data table based on the first page. Therefore, the associated information can be intuitively and conveniently acquired, the operation is very simple, and the efficiency is improved.

Description

Information processing method, device, storage medium and equipment
Technical Field
The present application relates to the field of computer technologies, and in particular, to an information processing method, an information processing apparatus, a storage medium, and a device.
Background
With the rapid development of big data technology, how to facilitate business personnel to quickly analyze data is a key problem to be solved for big data application. When data analysis is performed by service personnel, the association relationship between data tables and the association relationship between fields of different data tables and other association information related to the data tables are often required to be obtained.
However, at present, this process usually requires a service person to manually write computer code to obtain the computer code according to requirements, for example, a Structured Query Language (SQL) is used to write a complex SQL statement to run in a database, which is very inconvenient to operate and has low efficiency.
Disclosure of Invention
In view of this, embodiments of the present application provide an information processing method, an apparatus, a storage medium, and a device, which can intuitively and conveniently acquire associated information, and are very simple to operate and improve efficiency.
The embodiment of the application mainly provides the following technical scheme:
in a first aspect, an embodiment of the present application provides an information processing method, including: receiving a first operation of a user on attribute information of a first data table displayed on a first page; responding to the first operation, and acquiring association information between the first data table and a second data table based on the attribute information of the first data table, wherein the second data table and the first data table have an association relation; and displaying the association information between the first data table and the second data table based on the first page.
In an exemplary embodiment, the presenting association information between the first data table and the second data table includes: and displaying the association information between the first data table and the second data table in a graphical mode.
In one exemplary embodiment, the association information includes: the incidence relation between the first data table and the second data table; the displaying the association information between the first data table and the second data table in a graphical way comprises: displaying the association relation between the first data table and the second data table as a first relation graph comprising a first graph identifier for representing the first data table, a second graph identifier for representing the second data table and a first connecting line for representing association rules between the tables; wherein the first graphic identifier comprises: identification information of the first data table; the second graphic identification includes: identification information of the second data table; the first connecting line connects the first graphic identifier and the second graphic identifier.
In an exemplary embodiment, the association information further includes: an association rule for associating the first data table with the second data table;
the method further comprises the following steps:
jumping from the first page to a second page in response to a second operation of the user on the first connection line; displaying detailed information of the association rule in the second page;
or, in response to a third operation of the user on the first connection line, displaying detailed information of the association rule on the first connection line or around the first connection line.
In an exemplary embodiment, the display style of the first graphic identifier is different from the display style of the second graphic identifier.
In one exemplary embodiment, the association information includes: the incidence relation between the fields in the first data table and the fields in the second data table;
the displaying the association information between the first data table and the second data table in a graphical way comprises: showing the incidence relation between the fields in the first data table and the fields in the second data table as a second relation graph comprising a plurality of third graphic identifications used for representing the fields in the first data table, a plurality of fourth graphic identifications used for representing the fields in the second data table and a second connecting line; the field represented by the third graphic identification connected with one end of the second connecting line and the field represented by the fourth graphic identification connected with the other end of the second connecting line have an incidence relation; each third graph mark comprises attribute information of a field in the first data table represented by the third graph mark; and each fourth graphic identifier contains the attribute information of the field in the second data table represented by the fourth graphic identifier.
In an exemplary embodiment, the association information further includes: an association rule for associating the first data table with the second data table;
the method further comprises the following steps:
jumping from the first page to a second page in response to a fourth operation by a user for the second connecting line; displaying detailed information of the association rule in the second page;
or, in response to a fifth operation by the user on the second connection line, displaying detailed information of the association rule on or around the second connection line.
In a second aspect, an embodiment of the present application provides a computer-readable storage medium, including: a stored program, wherein the electronic device where the storage medium is located is controlled to execute the steps of the information processing method in one or more of the above embodiments when the program runs.
In a third aspect, an embodiment of the present application provides an electronic device, including: at least one processor; and at least one memory, bus connected with the processor; the processor and the memory complete mutual communication through the bus; the processor is used for calling the program instructions in the memory so as to execute the steps of the information processing method in one or more of the embodiments.
In a fourth aspect, an embodiment of the present application provides an information processing apparatus, including: the receiving unit is used for receiving a first operation of a user on attribute information of a first data table displayed on a first page; the obtaining unit is used for responding to the first operation and obtaining the association information between the first data table and the second data table based on the attribute information of the first data table, wherein the second data table and the first data table have an association relation; and the first display unit is used for displaying the association information between the first data table and the second data table based on the first page.
According to the information processing method, the device, the storage medium and the equipment provided by the embodiment of the application, by displaying the attribute information of the data table on the first page, when a user needs to acquire the associated information between the first data table and the second data table, the user can perform a first operation on the attribute information of the first data table displayed on the first page, wherein the second data table and the first data table have an associated relationship; next, in response to the first operation, the association information between the first data table and the second data table may be obtained based on the attribute information of the first data table, and finally, the association information between the first data table and the second data table may be displayed based on the first page. Therefore, the associated information can be conveniently acquired without writing complex codes by a user, the efficiency can be improved, and the user experience can be improved.
Additional features and advantages of the application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the application. Other advantages of the present application may be realized and attained by the instrumentalities and combinations particularly pointed out in the specification and the drawings.
Drawings
The accompanying drawings are included to provide an understanding of the present disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the examples serve to explain the principles of the disclosure and not to limit the disclosure.
FIG. 1 is a schematic flow chart illustrating an information processing method according to an embodiment of the present application;
FIG. 2A is a schematic diagram of a first page in an embodiment of the present application;
FIG. 2B is a schematic diagram of a first relationship diagram in an embodiment of the present application;
FIG. 2C is another diagram of the first relationship diagram in the embodiment of the present application;
FIG. 2D is a diagram illustrating table information in an embodiment of the present application;
FIG. 2E is a diagram illustrating data contents of a table in an embodiment of the present application;
FIG. 2F is a diagram of a second page in an embodiment of the present application;
FIG. 3 is a schematic flow chart illustrating a data normalization process according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of an information processing apparatus in an embodiment of the present application;
fig. 5 is a schematic structural diagram of an electronic device in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application.
The embodiment of the application provides an information processing method. Fig. 1 is a schematic flow chart of an information processing method in an embodiment of the present application, and referring to fig. 1, the method may include:
step 101: receiving a first operation of a user on attribute information of a first data table displayed on a first page;
in an exemplary embodiment, the attribute information of the data table displayed in the first page may be, for example, a name, a number, description information, comment information, data real-time, update time, element information, and the like of the data table.
For example, the attribute information of the target table may be presented in a list in the first page, and then, when the user needs to obtain the association information, referring to fig. 2A, the user may operate on the attribute information 202 of the first data table in the attribute information 201 of the multiple data tables presented in the first page 200. In this way, a first operation of the user for attribute information of the first data table shown in the first page is received.
In an exemplary embodiment, the first operation may be a click operation, a hover operation, or the like.
In addition, when the number of the data tables is large, the data tables can be displayed on the first page in a paging mode, a user can perform input operation on the first page to perform fuzzy query by using the attribute information of the first data table, and then perform the first operation after the attribute information of the first data table is displayed in the current paging of the first page. Thus, the information acquisition efficiency can be greatly improved.
Step 102: responding to the first operation, and acquiring association information between the first data table and the second data table based on the attribute information of the first data table;
and the second data table and the first data table have an association relationship.
In an exemplary embodiment, the association information between the first data table and the second data table may include one or more of the following information: the data processing system comprises an association relation between a first data table and a second data table, an association rule for associating the first data table with the second data table, and an association relation between fields in the first data table and fields in the second data table.
For example, the first data table and the second data table may be associated in advance based on an association rule to obtain association information between the first data table and the second data table, and then the association relationship and the association rule are stored based on the attribute information of the first data table, so that after the attribute information of the first data table is obtained, the association information between the first data table and the second data table may be obtained according to the attribute information of the first data table, so as to be displayed to a user.
In practical applications, the association relationship may be, for example, a one-to-many relationship, a many-to-one relationship, or the like.
In an exemplary embodiment, one of the first data table and the second data table is a data source table, and the other of the first data table and the second data table is a target table obtained by performing data normalization processing on the data source table.
For example, taking a data normalization scenario as an example, as shown in fig. 3, assume that the normalization rule includes: the method comprises the steps of converting an identity conversion rule (for example, converting a field 'SFZH identity card number and an SFZHM identity card number' into a unified field 'GMSFFHM citizen identity number'), a NAME conversion rule (converting a field 'NAME NAME' into a unified field 'XM NAME') and a gender conversion rule (converting a field 'SEX gender' into a unified field 'XB gender'), then carrying out data standardization processing on a data source table 1, a data source table 2 and a data source table 3 by using the standardization rule to obtain a target table 1, wherein the target table 1 and the data source table 1, the data source table 2 and the data source table 3 have an association relationship, and the association rule is the standardization rule adopted for carrying out data standardization processing. Next, in the process of acquiring the associated information, if the first data table selected by the user is the target table 1, the second data table is the data source table 1, the data source table 2 and the data source table 3; if the first data table selected by the user is one of the data source table 1, the data source table 2 and the data source table 3, the second data table may be the target table 1, or may be the target table 1 and the other two of the data source table 1, the data source table 2 and the data source table 3.
For another example, taking the public security domain as an example, assume that the data table 4 includes 3 fields, which are: user identity, check-in time, check-out time; and assume that the data table 5 contains 3 fields, which are: user identity identification, consumption record and consumption place; then, there is an association relationship between the data table 4 and the data table 5, and the association rule is a field "user identity".
Step 103: and displaying the association information between the first data table and the second data table based on the first page.
In an exemplary embodiment, step 103 may comprise: and displaying the association information between the first data table and the second data table in a graphical mode. Therefore, the user can intuitively acquire the required associated information, and the user experience is improved.
In practical applications, depending on the content of the obtained association information, there may be, but is not limited to, the following three implementation manners for graphically displaying the association information between the first data table and the second data table:
in a first implementation manner, the association information to be displayed includes: in a specific implementation process of the association relationship between the first data table and the second data table, step 103 may include: the association between the first data table and the second data table is shown as a first relationship graph comprising a first graph identifier for representing the first data table, a second graph identifier for representing the second data table, and a first connection line for representing an association rule between the tables.
Wherein the first graphic identifier comprises: identification information of the first data table; the second graphic identification includes: identification information of the second data table; the first connecting line connects the first graphic identifier and the second graphic identifier.
In an exemplary embodiment, when the type of the association relationship between the first data table and the second data table is a one-to-many relationship, assuming that a one-to-two relationship is taken as an example, then the first relationship graph may be as shown in fig. 2B, with one first data table corresponding to two second data tables. Therefore, the association relationship between a plurality of data tables and one data table can be clearly shown.
In an exemplary embodiment, step 103 may comprise: and popping up a window on the first page, and displaying the first relation graph in the window to show the association relation between the first data table and the second data table.
For example, when the type of the association relationship between the first data table and the second data table is a one-to-one relationship, as shown in fig. 2C, a window 203 pops up on the first page 200, and the first relationship diagram 204 is displayed in the window 203.
In an exemplary embodiment, the identification information of the data table may be information capable of identifying the data table, such as a name of the data table.
In an exemplary embodiment, the appearance of the first graphical indicia may not be the same as the appearance of the second graphical indicia. For example, as shown in fig. 2C, the first graphical indicia may be a circle 2041, the second graphical indicia may be a rectangle 2042, and the first connecting line may be a directed arc 2043.
In an exemplary embodiment, the display pattern of the first graphic identifier and the display pattern of the second graphic identifier may be different. For example, the first graphic is identified as a highlight effect and the second graphic is identified as a non-highlight effect.
In other embodiments of the present application, after displaying the association relationship between the first data table and the second data table based on the first implementation, if the user needs to obtain an association rule for associating the first data table with the second data table, in a specific implementation process, step 103 may further include: jumping from the first page to the second page in response to a second operation of the user on the first connection line; and displaying the detailed information of the association rule in a second page.
In another embodiment of the present application, after displaying the association relationship between the first data table and the second data table based on the first implementation, if an association rule for associating the first data table with the second data table needs to be obtained, in a specific implementation process, step 103 may further include: in response to a third operation of the user with respect to the first connection line, detailed information of the association rule is presented on or around the first connection line.
In an exemplary embodiment, the third operation of the user with respect to the first connection line may be different from the second operation of the user with respect to the first connection line. For example, the third operation is a hover operation and the second operation is a click operation.
In other embodiments of the present application, after displaying the association relationship between the first data table and the second data table based on the first implementation, if the user needs to obtain the table information of the first data table or the data content of the first data table, in a specific implementation process, the step 103 may further include: and responding to the operation of the user on the first graphic identifier, and acquiring and displaying the table information of the first data table or the data content of the first data table based on the identification information of the first data table.
In an exemplary embodiment, different information may be presented according to different operations of the user on the first graphical identifier, for example, when the operation of the user on the first graphical identifier is a hovering operation, as shown in fig. 2D, table information of the first data table represented by the first graphical identifier is presented; when the operation of the user on the first graphic identifier is a click operation, as shown in fig. 2E, the data content of the first data table represented by the first graphic identifier is shown.
In an exemplary embodiment, the table information of the data table may be, for example, a table name, a coding scheme, a database type, a table building statement, and the like.
In a second implementation manner, the associated information to be displayed includes: in the implementation of the association relationship between the fields in the first data table and the fields in the second data table, step 103 may include: exposing associations between fields in the first data table and fields in the second data table to include: a plurality of third graphic identifiers for representing the fields in the first data table, a plurality of fourth graphic identifiers for representing the fields in the second data table, and a second relation graph of the second connecting lines.
The field represented by the third graphic identifier connected with one end of the second connecting line and the field represented by the fourth graphic identifier connected with the other end of the second connecting line have an incidence relation; each third graph mark comprises attribute information of a field in the first data table represented by the third graph mark; and each fourth graphic identifier contains the attribute information of the field in the second data table represented by the fourth graphic identifier.
For example, when there is an association relationship between field 1 in the first data table and fields 2 and 3 in the second data table, then the third graphical identifier representing the field 1 and the fourth graphical identifier representing the field 2 are connected by a second connection line, and the third graphical identifier representing the field 1 and the fourth graphical identifier representing the field 3 are connected by another second connection line.
In an exemplary embodiment, the attribute information of the field may include one or more of the following information: field name, field comment, field type. Of course, other embodiments may be included, and the embodiments of the present application are not particularly limited.
In an exemplary embodiment, as shown in fig. 2F, step 103 may include: jumping from the first page to the second page 205, a second relationship graph 206 is displayed in the second page 205 to show the association between the fields in the first data table and the fields in the second data table.
In an exemplary embodiment, the appearance of the third graphical indicia may be the same as the appearance of the fourth graphical indicia. For example, as shown in fig. 2F, the third graphical indicia may be a rectangle 2061, the fourth graphical indicia may be a rectangle 2062, and the second connecting line may be a undirected line 2063.
In an exemplary embodiment, the display pattern of the third graphic identifier and the display pattern of the third graphic identifier may be the same. For example, when the third graphical identifier is selected, the third graphical identifier and the fourth graphical identifier are both highlighted.
In other embodiments of the present application, after displaying the association relationship between the fields in the first data table and the fields in the second data table based on the second implementation manner, if the user needs to obtain the association rule for associating the first data table with the second data table, step 103 may further include: jumping from the first page to the second page in response to a fourth operation of the user on the second connecting line; and displaying the detailed information of the association rule in a second page.
In another embodiment of the present application, after displaying the association relationship between the fields in the first data table and the fields in the second data table based on the second implementation manner, if the user needs to obtain the association rule for associating the first data table with the second data table, step 103 may further include: in response to a fifth operation by the user for the second connection line, detailed information of the association rule is presented on or around the second connection line.
In an exemplary embodiment, the fourth operation of the user with respect to the second connection line and the fifth operation of the user with respect to the second connection line may be different. For example, the fifth operation is a hover operation, and the fourth operation is a click operation.
In a third implementation manner, the associated information to be displayed includes: in a specific implementation process, as shown in fig. 2F, the association relationship between the first data table and the second data table, the association relationship between the fields in the first data table and the fields in the second data table, and the association rule for associating the first data table with the second data table, step 103 may include: jump from the first page to the second page 205; the second relation diagram 206 is displayed in a first area of the second page 205, the first relation diagram 204 is displayed in a second area of the second page 205, and the association rule 207 for associating the first data table with the second data table is displayed in a third area of the second page.
Of course, besides the three implementation manners listed above, the graphical presentation of the association information between the first data table and the second data table may also be implemented in other manners, and here, the embodiment of the present application is not particularly limited.
In practical applications, the step 103 may exist and is not limited to include the following three embodiments according to different display positions of the associated information:
in a first embodiment, step 103 may comprise: and displaying the association information between the first data table and the second data table in the first page.
In a second embodiment, step 103 may comprise: creating a popup on a first page; and displaying the association information between the first data table and the second data table in a popup window.
In a third embodiment, step 103 may comprise: jumping from the first page to the second page, and displaying the associated information between the first data table and the second data table in the second page.
As can be seen from the above, in the information processing method provided in the embodiment of the present application, by displaying the attribute information of the data table on the first page, when a user needs to acquire the association information between the first data table and the second data table, the user may perform a first operation on the attribute information of the first data table displayed on the first page, where the second data table and the first data table have an association relationship; next, in response to the first operation, the association information between the first data table and the second data table may be obtained based on the attribute information of the first data table, and finally, the association information between the first data table and the second data table may be displayed based on the first page. Therefore, the associated information can be conveniently acquired without writing complex codes by a user, the efficiency can be improved, and the user experience can be improved.
Based on the foregoing embodiment, the following describes in detail the process of the information processing method in the embodiment of the present application, taking the first data table as the target table 3, the second data table as the data source table 1, and the association rule for associating the first data table with the second data table as the data standardization rule, "identity conversion rule, universal identifier conversion rule". Wherein, the data standardization processing is carried out on the data source table 1 according to the data standardization rule to obtain the target table 3.
Step 1: and loading a first page, and displaying the attribute information of the target tables in the first page in a list mode.
Step 2: when a user needs to query the association information of the target table 3 in the multiple target tables, such as the association relationship between the target table 3 and the data source table 1, as shown in fig. 2C, the user may click on the row where the attribute information 202 of the target table 3 is shown on the first page. Thus, the first operation of the user for the attribute information of the target table 3 is received.
And step 3: in response to a first operation of the user on the attribute information of the target table 3, as shown in fig. 2C, a window 203 pops up on the first page 200, and in the window 203, the association relationship between the target table 3 and the data source table 1 is shown as follows: a first relationship diagram 204, wherein the first relationship diagram 204 comprises: a first graphic identifier 2041, a second graphic identifier 2042, and a first connecting line 2043 connecting the first graphic identifier 2041 and the second graphic identifier 2042, wherein a table name "target table 3" is displayed in the first graphic identifier 2041; the second graphic identifier 2042 has the table name "data source table 1" displayed therein.
And 4, step 4: if the user needs to query the association information of the target table 3 in the multiple target tables at the same time, for example, when the association rule is used to associate the target table 3 with the data source table 1, and the association relationship between the fields in the target table 3 and the fields in the data source table 1, as shown in fig. 2C, the user may click on the first connection line 2043 in the first relationship diagram 204 displayed in the window 203.
And 5: in response to a click operation of the first connection line by the user, as shown in fig. 2F, jumping from the first page to the second page 205; in a first area of a second page 205, the association relationship between the fields in the target table 3 and the fields in the data source table 1 is shown as a second relationship diagram 206, the first relationship diagram 204 is displayed in a second area of the second page 205, and an association rule 207 "identity conversion rule, universal identifier conversion rule" is displayed in a third area of the second page; wherein the second relationship graph 206 includes: a plurality of third graphic identifiers 2061 for representing fields in the target table 3, a plurality of fourth graphic identifiers 2062 for representing fields in the data source table 1, and a second connecting line 2063; a field represented by the third graphic identifier 2061 connected to one end of the second connecting line 2063 and a field represented by the fourth graphic identifier 2062 connected to the other end of the second connecting line 2063 have an association relationship therebetween; each third graphic identifier 2061 includes attribute information of the fields in the target table 3 represented by the third graphic identifier; each fourth graphical identity 2062 includes attribute information for the fields in the data source table 1 that it represents.
Here, the attribute information of the field may be, for example, a field name, a field comment, a field type, and the like.
Step 6: if the user needs to obtain the data content of the target table 3, the user may click on the first detail button 2064 in the second relationship diagram 206, as shown in fig. 2F. In this way, the data content of the target table 3 as shown in fig. 2E, for example, 5 data records, can be displayed in the second page. Correspondingly, if the user needs to obtain the data content of the data source table 1, the user may click the second detail button 2065 in the second relationship diagram 206, as shown in fig. 2F. In this way, the data content of the data source table 1 can be displayed in the second page.
And 7: if the user needs to obtain the table information of the target table 3, as shown in fig. 2F, the user may click the first graphic identifier 2041 in the first relationship diagram 204. In this manner, the table information of the target table 3 as shown in fig. 2D can be displayed in the second page. Correspondingly, if the user needs to obtain the table information of the data source table 1, as shown in fig. 2F, the user may click the second graphic identifier 2042 in the first relationship diagram 204. In this manner, the table information of the data source table 1 can be displayed in the second page.
And 8: if the user needs to return to the first page to re-select the target table, the user may click on the query button 208 in the second page 205, as shown in FIG. 2F. In this manner, a jump may be made from the second page to the first page so that the user may reselect the attribute information of the other target table to view the correlation.
In addition, in order to facilitate the user to select the data table, the user may switch the resource type of the data table displayed on the first page, as shown in fig. 2F, and the user may operate the selection control 209 in the second page 205 to switch from the target table list to the data source table list.
The information processing method provided by the embodiment of the application can clearly show the incidence relation between the data source table and the target table, is easy to check the table information and the data content of the data source table and the target table, can check the detailed information of the standardization rule, is very simple to operate, reduces the time cost of a user, improves the efficiency and improves the user experience.
Based on the same inventive concept, the embodiment of the application provides an information processing device. Fig. 4 is a schematic structural diagram of an information processing apparatus in an embodiment of the present application, and referring to fig. 4, the apparatus 40 may include: a receiving unit 401, configured to receive a first operation of a user on attribute information of a first data table displayed on a first page; an obtaining unit 402, configured to, in response to a first operation, obtain association information between a first data table and a second data table based on attribute information of the first data table, where the second data table has an association relationship with the first data table; a first presentation unit 403, configured to present association information between the first data table and the second data table based on the first page.
In an exemplary embodiment, the first presentation unit is configured to present, in a graphical manner, association information between the first data table and the second data table.
In an exemplary embodiment, the association information between the first data table and the second data table may include: the incidence relation between the first data table and the second data table; the first display unit is used for displaying the association relationship between the first data table and the second data table into a first relationship diagram which comprises a first graphic identifier used for representing the first data table, a second graphic identifier used for representing the second data table and a first connecting line used for representing the association rule between the tables; wherein the first graphic identifier comprises: identification information of the first data table; the second graphic identification includes: identification information of the second data table; the first connecting line connects the first graphic identifier and the second graphic identifier.
In an exemplary embodiment, the association information between the first data table and the second data table further includes: an association rule for associating the first data table with the second data table;
the apparatus may further include: the second display unit is used for responding to a second operation of the user on the first connecting line, jumping from the first page to a second page, and displaying detailed information of the association rule in the second page; or, in response to a third operation of the user on the first connection line, the detailed information of the association rule is presented on or around the first connection line.
In an exemplary embodiment, the display style of the first graphic identifier is different from the display style of the second graphic identifier.
In an exemplary embodiment, the association information between the first data table and the second data table may include: the incidence relation between the fields in the first data table and the fields in the second data table;
the first display unit is used for displaying the association relationship between the fields in the first data table and the fields in the second data table into a second relationship graph which comprises a plurality of third graphic identifications used for representing the fields in the first data table, a plurality of fourth graphic identifications used for representing the fields in the second data table and a second connecting line; the field represented by the third graphic identifier connected with one end of the second connecting line and the field represented by the fourth graphic identifier connected with the other end of the second connecting line have an incidence relation; each third graph mark comprises attribute information of a field in the first data table represented by the third graph mark; and each fourth graphic identifier contains the attribute information of the field in the second data table represented by the fourth graphic identifier.
In an exemplary embodiment, the association information between the first data table and the second data table further includes: an association rule for associating the first data table with the second data table;
the apparatus may further include: the third display unit is used for responding to a fourth operation of the user for the second connecting line and jumping from the first page to the second page; displaying detailed information of the association rule in a second page; or, in response to a fifth operation by the user on the second connection line, the detailed information of the association rule is presented on or around the second connection line.
Based on the same inventive concept, the embodiment of the application provides electronic equipment. Fig. 5 is a schematic structural diagram of an electronic device in an embodiment of the present application, and referring to fig. 5, the electronic device 50 includes: at least one processor 501; and at least one memory 502, bus 503 connected to processor 501; the processor 501 and the memory 502 complete communication with each other through the bus 503; the processor 501 is used to call program instructions in the memory 502 to execute the steps of the information processing method in one or more of the above embodiments.
In practical applications, the Processor may be implemented by a Central Processing Unit (CPU), a microprocessor Unit (MPU), a Digital Signal Processor (DSP), a Field Programmable Gate Array (FPGA), or the like. The Memory may include volatile Memory in a computer readable storage medium, Random Access Memory (RAM), and/or nonvolatile Memory such as Read Only Memory (ROM) or Flash Memory (Flash RAM), and the Memory includes at least one Memory chip.
It should be noted that, in the embodiments of the present application, if the information processing method in one or more embodiments described above is implemented in the form of a software functional module and sold or used as a standalone product, it may also be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present application may be essentially implemented or portions thereof that contribute to the prior art may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling an electronic device (which may be a personal computer, a server, or a network device) to execute all or part of the methods of the embodiments of the present application.
Accordingly, based on the same inventive concept, embodiments of the present application further provide a computer-readable storage medium, where the computer-readable storage medium includes a stored program, and when the program runs, the electronic device where the storage medium is located is controlled to execute the steps of the information processing method in one or more embodiments described above.
In practical applications, the computer-readable storage medium may be, for example: ROM/RAM, magnetic disk, optical disk, etc.
Here, it should be noted that: the above description of the apparatus, electronic device or computer-readable storage medium embodiments is similar to the description of the method embodiments above, with similar beneficial effects as the method embodiments. For technical details not disclosed in the embodiments of the apparatus, the electronic device or the computer-readable storage medium of the present application, reference is made to the description of the embodiments of the method of the present application for understanding.
The present application describes embodiments, but the description is illustrative rather than limiting and it will be apparent to those of ordinary skill in the art that many more embodiments and implementations are possible within the scope of the embodiments described herein. Although many possible combinations of features are shown in the drawings and discussed in the detailed description, many other combinations of the disclosed features are possible. Any feature or element of any embodiment may be used in combination with or instead of any other feature or element in any other embodiment, unless expressly limited otherwise.
The present application includes and contemplates combinations of features and elements known to those of ordinary skill in the art. The embodiments, features and elements disclosed in this application may also be combined with any conventional features or elements to form a unique inventive concept as defined by the claims. Any feature or element of any embodiment may also be combined with features or elements from other inventive aspects to form yet another unique inventive aspect, as defined by the claims. Thus, it should be understood that any of the features shown and/or discussed in this application may be implemented alone or in any suitable combination. Accordingly, the embodiments are not limited except as by the appended claims and their equivalents. Furthermore, various modifications and changes may be made within the scope of the appended claims.
Further, in describing representative embodiments, the specification may have presented the method and/or process as a particular sequence of steps. However, to the extent that the method or process does not rely on the particular order of steps set forth herein, the method or process should not be limited to the particular sequence of steps described. Other orders of steps are possible as will be understood by those of ordinary skill in the art. Therefore, the particular order of the steps set forth in the specification should not be construed as limitations on the claims. Further, the claims directed to the method and/or process should not be limited to the performance of their steps in the order written, and one skilled in the art can readily appreciate that the sequences may be varied and still remain within the spirit and scope of the embodiments of the present application.
It will be understood by those of ordinary skill in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable storage media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.

Claims (10)

1. An information processing method comprising:
receiving a first operation of a user on attribute information of a first data table displayed on a first page;
responding to the first operation, and acquiring association information between the first data table and a second data table based on the attribute information of the first data table, wherein the second data table and the first data table have an association relation;
and displaying the association information between the first data table and the second data table based on the first page.
2. The method of claim 1, wherein the presenting the association information between the first data table and the second data table comprises:
and displaying the association information between the first data table and the second data table in a graphical mode.
3. The method of claim 2, wherein the association information comprises: the incidence relation between the first data table and the second data table;
the displaying the association information between the first data table and the second data table in a graphical way comprises: displaying the association relation between the first data table and the second data table as a first relation graph comprising a first graph identifier for representing the first data table, a second graph identifier for representing the second data table and a first connecting line for representing association rules between the tables;
wherein the first graphic identifier comprises: identification information of the first data table; the second graphic identification includes: identification information of the second data table; the first connecting line connects the first graphic identifier and the second graphic identifier.
4. The method of claim 3, wherein the association information further comprises: an association rule for associating the first data table with the second data table;
the method further comprises the following steps:
jumping from the first page to a second page in response to a second operation of the user on the first connection line; displaying detailed information of the association rule in the second page;
or, in response to a third operation of the user on the first connection line, displaying detailed information of the association rule on the first connection line or around the first connection line.
5. The method of claim 3, wherein the first graphical indicia is displayed in a different manner than the second graphical indicia.
6. The method of claim 2, wherein the association information comprises: the incidence relation between the fields in the first data table and the fields in the second data table;
the displaying the association information between the first data table and the second data table in a graphical way comprises:
showing the incidence relation between the fields in the first data table and the fields in the second data table as a second relation graph comprising a plurality of third graphic identifications used for representing the fields in the first data table, a plurality of fourth graphic identifications used for representing the fields in the second data table and a second connecting line;
the field represented by the third graphic identification connected with one end of the second connecting line and the field represented by the fourth graphic identification connected with the other end of the second connecting line have an incidence relation; each third graph mark comprises attribute information of a field in the first data table represented by the third graph mark; and each fourth graphic identifier contains the attribute information of the field in the second data table represented by the fourth graphic identifier.
7. The method of claim 6, wherein the association information further comprises: an association rule for associating the first data table with the second data table;
the method further comprises the following steps:
jumping from the first page to a second page in response to a fourth operation by a user for the second connecting line; displaying detailed information of the association rule in the second page;
or, in response to a fifth operation by the user on the second connection line, displaying detailed information of the association rule on or around the second connection line.
8. A computer-readable storage medium, comprising: a stored program, wherein the electronic device where the storage medium is located is controlled to execute the steps of the information processing method according to any one of claims 1 to 7 when the program is executed.
9. An electronic device, comprising:
at least one processor;
and at least one memory, bus connected with the processor;
the processor and the memory complete mutual communication through the bus; the processor is adapted to call program instructions in the memory to perform the steps of the information processing method as claimed in any one of claims 1 to 7.
10. An information processing apparatus comprising:
the receiving unit is used for receiving a first operation of a user on attribute information of a first data table displayed on a first page;
the obtaining unit is used for responding to the first operation and obtaining the association information between the first data table and the second data table based on the attribute information of the first data table, wherein the second data table and the first data table have an association relation;
and the first display unit is used for displaying the association information between the first data table and the second data table based on the first page.
CN202010411266.0A 2020-05-15 2020-05-15 Information processing method, device, storage medium and equipment Pending CN111538746A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010411266.0A CN111538746A (en) 2020-05-15 2020-05-15 Information processing method, device, storage medium and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010411266.0A CN111538746A (en) 2020-05-15 2020-05-15 Information processing method, device, storage medium and equipment

Publications (1)

Publication Number Publication Date
CN111538746A true CN111538746A (en) 2020-08-14

Family

ID=71973901

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010411266.0A Pending CN111538746A (en) 2020-05-15 2020-05-15 Information processing method, device, storage medium and equipment

Country Status (1)

Country Link
CN (1) CN111538746A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111125203A (en) * 2019-12-12 2020-05-08 广东电网有限责任公司 Data association display method and related device based on scheduling operation early reporting system
CN115328326A (en) * 2022-07-26 2022-11-11 北京达美盛软件股份有限公司 Form configuration method and system based on VR

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106095948A (en) * 2016-06-13 2016-11-09 网易(杭州)网络有限公司 The querying method of form, device and equipment
US20170364582A1 (en) * 2016-06-17 2017-12-21 Alibaba Group Holding Limited Method, apparatus, and system for identifying data tables
CN107871278A (en) * 2017-08-04 2018-04-03 平安普惠企业管理有限公司 The method and storage medium of server, customer relationship network display
CN110166379A (en) * 2019-04-18 2019-08-23 北京字节跳动网络技术有限公司 Processing method, device, electronic equipment and the storage medium of flow table
CN110619100A (en) * 2019-06-18 2019-12-27 北京无限光场科技有限公司 Method and apparatus for acquiring data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106095948A (en) * 2016-06-13 2016-11-09 网易(杭州)网络有限公司 The querying method of form, device and equipment
US20170364582A1 (en) * 2016-06-17 2017-12-21 Alibaba Group Holding Limited Method, apparatus, and system for identifying data tables
CN107871278A (en) * 2017-08-04 2018-04-03 平安普惠企业管理有限公司 The method and storage medium of server, customer relationship network display
CN110166379A (en) * 2019-04-18 2019-08-23 北京字节跳动网络技术有限公司 Processing method, device, electronic equipment and the storage medium of flow table
CN110619100A (en) * 2019-06-18 2019-12-27 北京无限光场科技有限公司 Method and apparatus for acquiring data

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111125203A (en) * 2019-12-12 2020-05-08 广东电网有限责任公司 Data association display method and related device based on scheduling operation early reporting system
CN115328326A (en) * 2022-07-26 2022-11-11 北京达美盛软件股份有限公司 Form configuration method and system based on VR

Similar Documents

Publication Publication Date Title
CN108804299A (en) Application exception processing method and processing device
CN109299129A (en) Data query method, apparatus, computer equipment and the storage medium of natural language
CN113268500B (en) Service processing method and device and electronic equipment
CN111538746A (en) Information processing method, device, storage medium and equipment
WO2021189766A1 (en) Data visualization method and related device
CN108052310A (en) A kind of data processing method and server based on business model description information
US20220309534A1 (en) Information pushing method and electronic device utilizing method
US11531706B2 (en) Graph search using index vertices
CN111858617A (en) User searching method and device, computer readable storage medium and electronic equipment
CN116737137A (en) Business process generation method, device, computer equipment and storage medium
CN112329409A (en) Cell color conversion method and device and electronic equipment
CN109815299A (en) Method, apparatus, equipment and the storage medium of the visual representation of object set are provided
CN109120783A (en) Information acquisition method and device, mobile terminal and computer readable storage medium
CN109255081B (en) Portal service navigation method and system based on cloud platform
CN114463033A (en) Data screening method and device, electronic equipment and storage medium
CN114675767A (en) Information acquisition method and device, electronic equipment and storage medium
CN114446425A (en) Information pushing method and device, electronic equipment and storage medium
US20160267093A1 (en) Geolocation and practice setting based training filtering
CN109299439B (en) Digital extraction method and apparatus, storage medium, and electronic apparatus
CN110569459A (en) statistical method and device for webpage information
CN115904572B (en) Template creation method, calling method, program product, system and device
CN111078960B (en) Method and system for realizing real-time retrieval of power dispatching system equipment
CN116303743A (en) Data blood edge analysis method, device, computer equipment and storage medium
CN118095241A (en) Method and related device for generating custom template
CN105138143A (en) Method and device for obtaining term database

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
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20200814