CN111782651A - Visual editing method, device and equipment for data association relation and storage medium - Google Patents
Visual editing method, device and equipment for data association relation and storage medium Download PDFInfo
- Publication number
- CN111782651A CN111782651A CN202010612081.6A CN202010612081A CN111782651A CN 111782651 A CN111782651 A CN 111782651A CN 202010612081 A CN202010612081 A CN 202010612081A CN 111782651 A CN111782651 A CN 111782651A
- Authority
- CN
- China
- Prior art keywords
- association
- data table
- user
- editor
- editing
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000000007 visual effect Effects 0.000 title claims abstract description 35
- 238000012986 modification Methods 0.000 claims description 29
- 230000004048 modification Effects 0.000 claims description 29
- 230000006870 function Effects 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 4
- 238000012545 processing Methods 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 abstract description 4
- 238000012217 deletion Methods 0.000 description 8
- 230000037430 deletion Effects 0.000 description 8
- 239000007787 solid Substances 0.000 description 8
- 238000012800 visualization Methods 0.000 description 8
- 238000007726 management method Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000003993 interaction Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
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)
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to a data processing technology, and discloses a visual editing method of a data association relation, which comprises the following steps: displaying a main interface of an editor according to the login information of the user; acquiring an original data table, and displaying the original data table to an adding table interface of the editor in a list mode; selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode; selecting a data table to be associated from the data tables to be configured according to a user association instruction, and adding an association relation to the selected data table; and editing the association relation according to a user editing instruction, and displaying the edited association relation in a main interface of the editor. The invention also relates to a block chain technology, and the user information can be stored in the block chain. The invention can realize the function of editing the data association relationship in a graphical mode, which is simpler and easy to operate.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for visually editing a data association relationship, an electronic device, and a computer-readable storage medium.
Background
In big data application, logical association exists among a lot of data, logical association hidden behind the data can be mined through the data association, and the data is integrated according to the logical association, which is quite important for mining value of the big data.
The traditional database establishes the association relation for the data tables by writing codes to establish the main foreign key association between the data tables, but the method has the following defects: 1. the association relation can be correspondingly established only after the association relation among the data tables needs to be cleared, and the process of interaction with a user is lacked; 2. the incidence relation among the data tables is displayed in a data table form, so that a user cannot quickly and easily correspond to the incidence relation among the data tables; 3. when facing the needs of a large amount of data table configuration, the method is easy to make mistakes.
Disclosure of Invention
The invention provides a visual editing method and device for data association relation, electronic equipment and a computer readable storage medium, and mainly aims to provide a method which is simpler and easy to operate and can edit the data association relation in a graphical mode.
In order to achieve the above object, the present invention provides a method for visually editing a data association relationship, including:
displaying a main interface of an editor according to the login information of the user;
acquiring an original data table, and displaying the original data table to an adding table interface of the editor in a list mode;
selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode;
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and adding an association relation to the selected data table;
and editing the association relation according to a user editing instruction, and displaying the edited association relation in a main interface of the editor.
Optionally, the obtaining an original data table, and displaying the original data table to an add table interface of the editor in a list manner includes:
opening an adding table interface of the editor according to a user adding instruction;
and acquiring the original data table from a database, and displaying the original data table in a list mode on an adding table interface of the editor.
Optionally, the selecting a to-be-configured data table from the original data table, and graphically displaying the to-be-configured data table to a main interface of the editor includes:
screening a data table to be displayed from the original data table according to a user selection instruction to obtain a data table to be configured;
and displaying the data table to be configured to a main interface of the editor in a graphic mode by utilizing a preset editable object function.
Optionally, the selecting a data table to be associated from the data tables to be configured according to the user association instruction, and adding an association relationship to the selected data table includes:
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and displaying the data table to be associated to a newly-added table relation interface of the editor;
receiving an association type and an association expression input by a user, and adding an association relation to the association data table according to the association type and the association expression;
and displaying the association relation between the data tables to be associated in a main interface of the editor in a graphical mode.
Optionally, the editing the association relationship according to a user editing instruction, and displaying the edited association relationship in a main interface of the editor includes:
acquiring an incidence relation selected by a user according to the user editing instruction to obtain an incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
receiving modification information input by a user, and editing the incidence relation to be edited according to the modification information;
displaying the edited association relation in a main interface of the editor in a graphical mode.
In order to solve the above problem, the present invention further provides a device for visually editing a data association relationship, where the device includes:
the login module is used for displaying a main interface of the editor according to the login information of the user;
the data table display module is used for acquiring an original data table and displaying the original data table to an adding table interface of the editor in a list mode;
the data table selection module is used for selecting a data table to be configured from the original data table and displaying the data table to be configured to a main interface of the editor in a graphical mode;
the association relation adding module is used for selecting a data table needing association from the data tables to be configured according to the user association instruction and adding an association relation to the selected data table;
and the incidence relation editing module is used for editing the incidence relation according to a user editing instruction and displaying the edited incidence relation in a main interface of the editor.
Optionally, when the data table to be associated is selected from the data tables to be configured according to the user association instruction and an association relationship is added to the selected data table, the association relationship adding module executes the following operations:
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and displaying the data table to be associated to a newly-added table relation interface of the editor;
receiving an association type and an association expression input by a user, and adding an association relation to the association data table according to the association type and the association expression;
and displaying the association relation between the data tables to be associated in a main interface of the editor in a graphical mode.
Optionally, when the association relationship is edited according to a user editing instruction and the edited association relationship is displayed in a main interface of the editor, the association relationship editing module executes the following operations:
acquiring an incidence relation selected by a user according to the user editing instruction to obtain an incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
receiving modification information input by a user, and editing the incidence relation to be edited according to the modification information;
displaying the edited association relation in a main interface of the editor in a graphical mode.
In order to solve the above problem, the present invention also provides an electronic device, including:
a memory storing at least one instruction; and
and the processor executes the instructions stored in the memory to realize the visual editing method of the data association relation.
In order to solve the above problem, the present invention further provides a computer-readable storage medium storing a computer program, which is executed by a processor to implement the visual editing method for data association relationship described in any one of the above.
According to the embodiment of the invention, the main interface of the editor is displayed according to the login information of the user, so that the data security is improved; acquiring an original data table, displaying the original data table to an adding table interface of the editor in a list mode, and displaying the data table in a graph mode so as to be convenient for a user to understand; selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode without the need that a user wants to clear the association relation between the data tables in advance, so that the subsequent operation of the user is facilitated; selecting a data table to be associated from the data tables to be configured according to the user association instruction, and adding an association relation to the selected data table, so that the interaction process with the user is increased, and the user can quickly get on hand; and editing the association relationship according to a user editing instruction, and displaying the edited association relationship in a main interface of the editor, so that wrong association can be reduced, and complex relationships among data can be displayed in a more visual and clear manner. Therefore, the visual editing method and device for the data association relationship and the computer readable storage medium provided by the invention can realize the function of editing the data association relationship in a graphical mode, which is simpler and easy to operate.
Drawings
Fig. 1 is a schematic flowchart of a method for visually editing a data association relationship according to an embodiment of the present invention;
fig. 2 is a schematic flowchart of a user login method according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating a method for obtaining an original data table according to an embodiment of the present invention;
FIG. 4 is a flowchart illustrating a method for selecting a data table to be configured according to an embodiment of the present invention;
fig. 5 is a flowchart illustrating an add association method according to an embodiment of the present invention;
fig. 6 is a flowchart illustrating an edit association method according to an embodiment of the present invention;
fig. 7 is a schematic block diagram of a visual editing apparatus for data association provided in an embodiment of the present invention;
fig. 8 is a schematic internal structural diagram of an electronic device implementing a visual editing method for data association according to an embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The execution subject of the visual editing method for the data association relationship provided by the embodiment of the present application includes, but is not limited to, at least one of electronic devices such as a server and a terminal that can be configured to execute the method provided by the embodiment of the present application. In other words, the visual editing method for the data association relationship may be performed by software or hardware installed in the terminal device or the server device, and the software may be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.
Fig. 1 is a schematic flow chart of a method for visually editing a data association relationship according to an embodiment of the present invention. In this embodiment, the method for visually editing the data association relationship includes:
and S1, displaying the main interface of the editor according to the user login information.
Preferably, the user login information is a login ID and a login password input by the user at the system login interface.
In detail, referring to fig. 2, the displaying the main interface of the editor according to the user login information includes:
s11, receiving user login information input by a user on a login interface;
s12, comparing the user login information with the user information in the database to obtain a comparison result, wherein the comparison result comprises login success and login failure;
and S13, displaying the main interface of the editor when the comparison result is that the login is successful.
Furthermore, the editor is a computer system which can add, modify and delete the association relation among the data tables and graphically display the association relation among the data tables; the main interface of the editor is a web graphical interface which can display data tables and the association relation between the data tables and provide operation selection for a user in the editor.
It is emphasized that, in order to further ensure the privacy and security of the user information, the user information may also be stored in a node of a block chain.
The block chain referred by the application is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. The Blockchain (Blockchain) is essentially a decentralized database, which is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate the next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
For example, in the outpatient service relationship, the main interface of the editor displays data tables such as an outpatient prescription table, an employee information table, an outpatient expense list and the like in a graphic form of a rectangular frame, the names and important field names of the tables are displayed in the rectangular frame, the tables with the association relationship are connected by solid lines, the outpatient service relationship is displayed in a graphic form, the complex service relationship among the data can be clearly displayed in the main interface of the editor, and a user can also drag the data tables to any position to display the outpatient service relationship in a form which is easier to accept and understand by the user.
And S2, acquiring an original data table, and displaying the original data table to an adding table interface of the editor in a list mode.
In detail, referring to fig. 3, the S2 includes in detail:
s20, opening an adding table interface of the editor according to the adding instruction of the user;
s21, acquiring the original data table from the database, and displaying the original data table in a list mode on an adding table interface of the editor.
And e.g. displaying the table names of data tables such as an outpatient prescription table, an employee information table, an outpatient expense list, an accessory information table and the like on the additional table interface from top to bottom in sequence.
Further, the user adding instruction is a clicking operation of a user on an 'add table' button in a main interface of the editor; the original data table is a plurality of data tables stored in a database in advance, and the content of each data table mainly comprises a data table name, a data table alias, a plurality of fields and the like.
Preferably, the table adding interface of the editor is a visualization window for displaying the original data table in the order of letters and displaying the alias of the original data table, so as to facilitate the user to identify and enable the user to perform selection operation on the original data table.
S3, selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode.
In detail, referring to fig. 4, the S3 includes:
s30, screening a data table to be displayed from the original data table according to a user selection instruction to obtain a data table to be configured;
and S31, graphically displaying the data table to be configured to a main interface of the editor by using a preset editable object function.
In the embodiment of the present invention, the user selection instruction refers to a click operation performed by a user to check a single data table in the original data table in an add table interface of the editor, and a click operation performed by a "ok" button in the add table interface of the editor.
The editable object function is a function which is written based on Java language and displays data in a visual mode, and the data table to be configured can be used as a parameter and displayed in a graphical mode through the editable object function.
The step of displaying the data table to be configured in a graph form refers to that the data table to be configured is displayed in a graph form, such as a rectangle, and the alias and partial field of the data table are displayed in the rectangle, so that the display of the data table to be configured is more visual and concise. The data table graph in the main interface of the editor can be dragged to any position, so that a user can configure the relation view among the data tables in the most easily understood mode.
Preferably, when a user performs a check operation on a single data table in the original data table in the table adding interface of the editor, the check operation cannot be performed on the configured data table, so that the fault tolerance of system operation is improved. If the user checks the outpatient prescription table and the employee information table on the table adding interface of the editor and clicks the determination button, the system finds the outpatient prescription table and the employee information table in the database and displays the outpatient prescription table and the employee information table in the main interface by using a rectangular frame graphic identification.
And S4, selecting the data table to be associated from the data tables to be configured according to the user association instruction, and adding association relation to the selected data table.
In the embodiment of the present invention, the user association instruction refers to that a user selects a data table to be associated in a main interface of the editor, drags a connection line by pressing a mouse for a long time, and performs an association relationship establishment operation on the data table, and if the user operates the data table in which the association relationship already exists, an error is displayed to remind "association cannot be established repeatedly".
In detail, referring to fig. 5, the selecting a data table to be associated from the data tables to be configured according to the user association instruction, and adding an association relationship to the selected data table includes:
s41, selecting a data table to be associated from the data tables to be configured according to the user association instruction, and displaying the data table to be associated to a newly added table relation interface of the editor;
s42, receiving the association type and the association expression input by the user, and adding the association relation to the association data table according to the association type and the association expression;
and S43, displaying the association relation between the data tables to be associated in a graphic mode in the main interface of the editor.
The newly added table relation interface of the editor is a visual window which can display the data table to be associated and input associated information; the association type refers to an association mode of association relation between two data tables, and comprises full connection, left connection and right connection; the association expression is a connection condition for establishing an association relationship between two data tables, and is generally a logical relationship between two data tables.
Preferably, for the associated expression, the user may directly edit the associated expression through a keyboard, or may edit the associated expression by dragging the field of the to-be-associated data table through a mouse, so as to improve the operability of the user.
If a user wants to establish an association relationship between an outpatient table and an outpatient expense statement, the outpatient table can be clicked in a main interface, a connecting line is dragged to the outpatient expense statement without being held, at the moment, a newly added table relationship interface is opened, a patient ID field of the outpatient table and a payer ID field of the outpatient table are selected on the left side of the interface and dragged to an expression interface on the right side, full connection is selected in an association type pull-down list, clicking is confirmed, the association relationship is established between the outpatient table and the outpatient expense statement, and a solid connecting line is used for representing the association relationship in the main interface.
Preferably, the traditional database tool often establishes an association relationship between data tables by establishing an external key or adding a new intermediate table, and a user needs to determine a specific association between the data tables and the tables first, and then write an SQL statement for execution, thereby configuring the association relationship between the data tables. The invention adds the incidence relation to the data sheet through the graphical interface, has simple and easy operation mode, and can reduce the error rate.
And S5, editing the association relation according to a user editing instruction, and displaying the edited association relation in a main interface of the editor.
In detail, referring to fig. 6, the S5 includes:
s51, acquiring the incidence relation selected by the user according to the user editing instruction to obtain the incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
preferably, the user editing instruction comprises a click operation of selecting modification or deletion on a pre-constructed operation menu list interface after the user selects the incidence relation;
s52, receiving modification information input by a user, and editing the association relation to be edited according to the modification information;
the modification information comprises an editing type selected by a user, such as modification or deletion, and also comprises modification information input by the user, such as a modified associated expression and the like; the editing includes modification and deletion, and the association type, the association expression and the like of the association relation to be edited can be modified, or the association relation to be edited can be directly deleted.
And S53, displaying the edited association relation in a main interface of the editor in a graphical mode.
For example, if a user wants to modify or delete the association relationship between the outpatient table and the outpatient expense statement, a solid connection line between the outpatient table and the outpatient expense statement is clicked by a right mouse button in the main interface, an operation menu appears, the operation menu comprises modification and deletion, if the operation menu is clicked and deleted, the association relationship is deleted, and the solid connection line between the outpatient table and the outpatient expense statement disappears in the main interface; if the modification is clicked, a table relation editing interface appears, which is similar to the newly-added table relation interface, the expression and the association type can be modified in the interface, the field of the expression is changed into the name of the patient and the name of the payer, the association type is changed into left connection, and the like, the click is determined, the association relation is modified, and after the modification, the association relation is still displayed by solid connecting line graphic identification.
Further, after the original data table configures the association relationship according to the user association instruction and modifies the association relationship according to the user editing instruction, a graphical visualization scheme of the association relationship between the original data tables is formed and displayed in a main interface of the editor.
Preferably, in the embodiment of the present invention, modifying and deleting the association relationship are also performed in a graphical interface manner, so that a user can easily perform the above operations, and can modify and delete the association relationship repeatedly, whereas the conventional database tool needs to write SQL statements for execution, and if the association relationship between the data tables is disordered and the database is crashed due to repeated operations.
In detail, the graphic visualization scheme includes a plurality of data tables displayed in a graphic form, which are added through the step S3, and the association relationships among the data tables displayed in a graphic form, which are set through the steps S4 and S5.
Preferably, the graphic visualization scheme displays the complex association relationship stored among the plurality of data tables of the database in a simpler and more visual graphic manner, so that the user can understand the complex association relationship conveniently, the time of the user is saved, and the experience of the user is improved.
According to the embodiment of the invention, the main interface of the editor is displayed according to the login information of the user, so that the data security is improved; acquiring an original data table, displaying the original data table to an adding table interface of the editor in a list mode, and displaying the data table in a graph mode so as to be convenient for a user to understand; selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode without the need that a user wants to clear the association relation between the data tables in advance, so that the subsequent operation of the user is facilitated; selecting a data table to be associated from the data tables to be configured according to the user association instruction, and adding an association relation to the selected data table, so that the interaction process with the user is increased, and the user can quickly get on hand; and editing the association relationship according to a user editing instruction, and displaying the edited association relationship in a main interface of the editor, so that wrong association can be reduced, and complex relationships among data can be displayed in a more visual and clear manner. Therefore, the visual editing method and device for the data association relationship and the computer readable storage medium provided by the invention can realize the function of editing the data association relationship in a graphical mode, which is simpler and easy to operate.
Fig. 7 is a functional block diagram of the visual editing apparatus for data association according to the present invention.
The visual editing apparatus 100 for data association relationship according to the present invention may be installed in an electronic device. According to the realized functions, the visual editing device for the data association relationship can comprise a login module 101, a data table display module 102, a data table selection module 103, an association relationship adding module 104 and an association relationship editing module 105. A module according to the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the login module 101 is used for displaying a main interface of the editor according to the login information of the user
The data table display module 102 is configured to obtain an original data table, and display the original data table to an add table interface of the editor in a list manner;
the data table selection module 103 is configured to select a data table to be configured from the original data table, and graphically display the data table to be configured to a main interface of the editor;
the association relation adding module 104 is configured to select a data table to be associated from the data tables to be configured according to a user association instruction, and add an association relation to the selected data table;
the association editing module 105 is configured to edit the association according to a user editing instruction, and display the edited association in a main interface of the editor.
In detail, the specific implementation steps of each module of the visual editing device for the data association relationship are as follows:
the login module 101 is configured to display a main interface of the editor according to the login information of the user.
Preferably, the user login information is a login ID and a login password input by the user at the system login interface.
In detail, the displaying a main interface of an editor according to the user login information includes:
receiving user login information input by a user on a login interface;
comparing the user login information with user information in a database to obtain a comparison result, wherein the comparison result comprises login success and login failure;
when the comparison result is that the login is successful, displaying a main interface of the editor;
furthermore, the editor is a computer system which can add, modify and delete the association relation among the data tables and graphically display the association relation among the data tables; the main interface of the editor is a web graphical interface which can display data tables and the association relation between the data tables and provide operation selection for a user in the editor.
For example, in the outpatient service relationship, the main interface of the editor displays data tables such as an outpatient prescription table, an employee information table, an outpatient expense list and the like in a graphic form of a rectangular frame, the names and important field names of the tables are displayed in the rectangular frame, the tables with the association relationship are connected by solid lines, the outpatient service relationship is displayed in a graphic form, the complex service relationship among the data can be clearly displayed in the main interface of the editor, and a user can also drag the data tables to any position to display the outpatient service relationship in a form which is easier to accept and understand by the user.
The data table display module 102 is configured to obtain an original data table, and display the original data table to an add table interface of the editor in a list manner.
In detail, the data table display module performs the following operations:
opening an adding table interface of the editor according to a user adding instruction;
and acquiring the original data table from a database, and displaying the original data table in a list mode on an adding table interface of the editor.
And e.g. displaying the table names of data tables such as an outpatient prescription table, an employee information table, an outpatient expense list, an accessory information table and the like on the additional table interface from top to bottom in sequence.
Further, the user adding instruction is a clicking operation of a user on an 'add table' button in a main interface of the editor; the original data table is a plurality of data tables stored in a database in advance, and the content of each data table mainly comprises a data table name, a data table alias, a plurality of fields and the like.
Preferably, the table adding interface of the editor is a visualization window for displaying the original data table in the order of letters and displaying the alias of the original data table, so as to facilitate the user to identify and enable the user to perform selection operation on the original data table.
The data table selecting module 103 is configured to select a data table to be configured from the original data table, and graphically display the data table to be configured to a main interface of the editor.
In detail, the data table selection module specifically performs the following operations:
screening a data table to be displayed from the original data table according to a user selection instruction to obtain a data table to be configured;
and displaying the data table to be configured to a main interface of the editor in a graphic mode by utilizing a preset editable object function.
In the embodiment of the present invention, the user selection instruction refers to a click operation performed by a user to check a single data table in the original data table in an add table interface of the editor, and a click operation performed by a "ok" button in the add table interface of the editor.
The editable object function is a function which is written based on Java language and displays data in a visual mode, and the data table to be configured can be used as a parameter and displayed in a graphical mode through the editable object function.
The step of displaying the data table to be configured in a graph form refers to that the data table to be configured is displayed in a graph form, such as a rectangle, and the alias and partial field of the data table are displayed in the rectangle, so that the display of the data table to be configured is more visual and concise. The data table graph in the main interface of the editor can be dragged to any position, so that a user can configure the relation view among the data tables in the most easily understood mode.
Preferably, when a user performs a check operation on a single data table in the original data table in the table adding interface of the editor, the check operation cannot be performed on the configured data table, so that the fault tolerance of system operation is improved. If the user checks the outpatient prescription table and the employee information table on the table adding interface of the editor and clicks the determination button, the system finds the outpatient prescription table and the employee information table in the database and displays the outpatient prescription table and the employee information table in the main interface by using a rectangular frame graphic identification.
The association relation adding module 104 is configured to select a data table to be associated from the data tables to be configured according to the user association instruction, and add an association relation to the selected data table.
In the embodiment of the present invention, the user association instruction refers to that a user selects a data table to be associated in a main interface of the editor, drags a connection line by pressing a mouse for a long time, and performs an association relationship establishment operation on the data table, and if the user operates the data table in which the association relationship already exists, an error is displayed to remind "association cannot be established repeatedly".
In detail, the selecting a data table to be associated from the data tables to be configured according to the user association instruction and adding an association relationship to the selected data table includes:
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and displaying the data table to be associated to a newly-added table relation interface of the editor;
receiving an association type and an association expression input by a user, and adding an association relation to the association data table according to the association type and the association expression;
and displaying the association relation between the data tables to be associated in a main interface of the editor in a graphical mode.
The newly added table relation interface of the editor is a visual window which can display the data table to be associated and input associated information; the association type refers to an association mode of association relation between two data tables, and comprises full connection, left connection and right connection; the association expression is a connection condition for establishing an association relationship between two data tables, and is generally a logical relationship between two data tables.
Preferably, for the associated expression, the user may directly edit the associated expression through a keyboard, or may edit the associated expression by dragging the field of the to-be-associated data table through a mouse, so as to improve the operability of the user.
If a user wants to establish an association relationship between an outpatient table and an outpatient expense statement, the outpatient table can be clicked in a main interface, a connecting line is dragged to the outpatient expense statement without being held, at the moment, a newly added table relationship interface is opened, a patient ID field of the outpatient table and a payer ID field of the outpatient table are selected on the left side of the interface and dragged to an expression interface on the right side, full connection is selected in an association type pull-down list, clicking is confirmed, the association relationship is established between the outpatient table and the outpatient expense statement, and a solid connecting line is used for representing the association relationship in the main interface.
Preferably, the traditional database tool often establishes an association relationship between data tables by establishing an external key or adding a new intermediate table, and a user needs to determine a specific association between the data tables and the tables first, and then write an SQL statement for execution, thereby configuring the association relationship between the data tables. The invention adds the incidence relation to the data sheet through the graphical interface, has simple and easy operation mode, and can reduce the error rate.
The association editing module 105 is configured to edit the association according to a user editing instruction, and display the edited association in a main interface of the editor.
In detail, the association relation editing module specifically executes the following operations:
acquiring an incidence relation selected by a user according to the user editing instruction to obtain an incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
receiving modification information input by a user, and editing the incidence relation to be edited according to the modification information;
displaying the edited association relation in a main interface of the editor in a graphical mode.
Preferably, the user editing instruction comprises a click operation of selecting modification or deletion on a pre-constructed operation menu list interface after the user selects the association relation.
The modification information comprises an editing type selected by a user, such as modification or deletion, and also comprises modification information input by the user, such as a modified associated expression and the like; the editing includes modification and deletion, and the association type, the association expression and the like of the association relation to be edited can be modified, or the association relation to be edited can be directly deleted.
For example, if a user wants to modify or delete the association relationship between the outpatient table and the outpatient expense statement, a solid connection line between the outpatient table and the outpatient expense statement is clicked by a right mouse button in the main interface, an operation menu appears, the operation menu comprises modification and deletion, if the operation menu is clicked and deleted, the association relationship is deleted, and the solid connection line between the outpatient table and the outpatient expense statement disappears in the main interface; if the modification is clicked, a table relation editing interface appears, which is similar to the newly-added table relation interface, the expression and the association type can be modified in the interface, the field of the expression is changed into the name of the patient and the name of the payer, the association type is changed into left connection, and the like, the click is determined, the association relation is modified, and after the modification, the association relation is still displayed by solid connecting line graphic identification.
Further, after the original data table configures the association relationship according to the user association instruction and modifies the association relationship according to the user editing instruction, a graphical visualization scheme of the association relationship between the original data tables is formed and displayed in a main interface of the editor.
Preferably, in the embodiment of the present invention, modifying and deleting the association relationship are also performed in a graphical interface manner, so that a user can easily perform the above operations, and can modify and delete the association relationship repeatedly, whereas the conventional database tool needs to write SQL statements for execution, and if the association relationship between the data tables is disordered and the database is crashed due to repeated operations.
In detail, the graphic visualization scheme includes a plurality of data tables displayed in a graphic form and added by the data table selection module, and an association relationship between the data tables displayed in the graphic form and set by the association relationship addition module and the association relationship editing module.
Preferably, the graphic visualization scheme displays the complex association relationship stored among the plurality of data tables of the database in a simpler and more visual graphic manner, so that the user can understand the complex association relationship conveniently, the time of the user is saved, and the experience of the user is improved.
Fig. 8 is a schematic structural diagram of an electronic device implementing a visual editing method for data association according to the present invention.
The electronic device 1 may include a processor 10, a memory 11 and a bus, and may further include a computer program stored in the memory 11 and executable on the processor 10, such as a visual editing program 12 for data association.
The memory 11 includes at least one type of readable storage medium, which includes flash memory, removable hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disk, optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a removable hard disk of the electronic device 1. The memory 11 may also be an external storage device of the electronic device 1 in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device 1. The memory 11 may be used to store not only application software installed in the electronic device 1 and various types of data, such as codes of the visual editing program 12 for data association, but also temporarily store data that has been output or is to be output.
The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same or different functions, including one or more Central Processing Units (CPUs), microprocessors, digital Processing chips, graphics processors, and combinations of various control chips. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device 1 by running or executing programs or modules (for example, a visual editing program for executing data association, etc.) stored in the memory 11 and calling data stored in the memory 11.
The bus may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
Fig. 8 only shows an electronic device with components, and it will be understood by those skilled in the art that the structure shown in fig. 8 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than those shown, or some components may be combined, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and optionally, the network interface may include a wired interface and/or a wireless interface (such as a WI-FI interface, a bluetooth interface, etc.), which are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The visual editor program 12 of the data association stored in the memory 11 of the electronic device 1 is a combination of a plurality of instructions that, when executed in the processor 10, can implement:
displaying a main interface of an editor according to the login information of the user;
acquiring an original data table, and displaying the original data table to an adding table interface of the editor in a list mode;
selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode;
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and adding an association relation to the selected data table;
and editing the association relation according to a user editing instruction, and displaying the edited association relation in a main interface of the editor.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one 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, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any accompanying claims should not be construed as limiting the claim concerned.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms second, etc. are used to denote names, but not 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 (10)
1. A visual editing method for data association relationship is characterized by comprising the following steps:
displaying a main interface of an editor according to the login information of the user;
acquiring an original data table, and displaying the original data table to an adding table interface of the editor in a list mode;
selecting a data table to be configured from the original data table, and displaying the data table to be configured to a main interface of the editor in a graphical mode;
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and adding an association relation to the selected data table;
and editing the association relation according to a user editing instruction, and displaying the edited association relation in a main interface of the editor.
2. The method for visually editing data association relationship according to claim 1, wherein the obtaining an original data table and displaying the original data table to an add table interface of the editor in a list manner includes:
opening an adding table interface of the editor according to a user adding instruction;
and acquiring the original data table from a database, and displaying the original data table in a list mode on an adding table interface of the editor.
3. The method for visually editing data association relationship according to claim 1, wherein the selecting a data table to be configured from the original data table and graphically displaying the data table to be configured in a main interface of the editor comprises:
screening a data table to be displayed from the original data table according to a user selection instruction to obtain a data table to be configured;
and displaying the data table to be configured to a main interface of the editor in a graphic mode by utilizing a preset editable object function.
4. The visual editing method of data association relationship according to claim 1, wherein the selecting a data table to be associated from the data tables to be configured according to a user association instruction, and adding an association relationship to the selected data table, includes:
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and displaying the data table to be associated to a newly-added table relation interface of the editor;
receiving an association type and an association expression input by a user, and adding an association relation to the association data table according to the association type and the association expression;
and displaying the association relation between the data tables to be associated in a main interface of the editor in a graphical mode.
5. The method for visually editing data association relationship according to claim 1, wherein the editing the association relationship according to a user editing instruction and displaying the edited association relationship in a main interface of the editor comprises:
acquiring an incidence relation selected by a user according to the user editing instruction to obtain an incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
receiving modification information input by a user, and editing the incidence relation to be edited according to the modification information;
displaying the edited association relation in a main interface of the editor in a graphical mode.
6. An apparatus for visually editing data association relationship, the apparatus comprising:
the login module is used for displaying a main interface of the editor according to the login information of the user;
the data table display module is used for acquiring an original data table and displaying the original data table to an adding table interface of the editor in a list mode;
the data table selection module is used for selecting a data table to be configured from the original data table and displaying the data table to be configured to a main interface of the editor in a graphical mode;
the association relation adding module is used for selecting a data table needing association from the data tables to be configured according to the user association instruction and adding an association relation to the selected data table;
and the incidence relation editing module is used for editing the incidence relation according to a user editing instruction and displaying the edited incidence relation in a main interface of the editor.
7. The apparatus for visually editing data association relationship according to claim 6, wherein when the data table to be associated is selected from the data tables to be configured according to the user association instruction and an association relationship is added to the selected data table, the association relationship adding module performs the following operations:
selecting a data table to be associated from the data tables to be configured according to a user association instruction, and displaying the data table to be associated to a newly-added table relation interface of the editor;
receiving an association type and an association expression input by a user, and adding an association relation to the association data table according to the association type and the association expression;
and displaying the association relation between the data tables to be associated in a main interface of the editor in a graphical mode.
8. A visual editing apparatus for data association relationship according to claim 6, wherein when the association relationship is edited according to a user editing instruction and the edited association relationship is displayed in a main interface of the editor, the association relationship editing module performs the following operations:
acquiring an incidence relation selected by a user according to the user editing instruction to obtain an incidence relation to be edited, and displaying the incidence relation to be edited on a table relation editing interface;
receiving modification information input by a user, and editing the incidence relation to be edited according to the modification information;
displaying the edited association relation in a main interface of the editor in a graphical mode.
9. An electronic device, characterized in that the electronic device comprises:
a memory storing at least one instruction; and
a processor executing instructions stored in the memory to perform a method of visual editing of data associations according to any of claims 1 to 5.
10. A computer-readable storage medium, storing a computer program, wherein the computer program, when executed by a processor, implements a method for visually editing data associations according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010612081.6A CN111782651A (en) | 2020-06-30 | 2020-06-30 | Visual editing method, device and equipment for data association relation and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010612081.6A CN111782651A (en) | 2020-06-30 | 2020-06-30 | Visual editing method, device and equipment for data association relation and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111782651A true CN111782651A (en) | 2020-10-16 |
Family
ID=72761452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010612081.6A Pending CN111782651A (en) | 2020-06-30 | 2020-06-30 | Visual editing method, device and equipment for data association relation and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111782651A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112351081A (en) * | 2020-10-27 | 2021-02-09 | 上海博泰悦臻网络技术服务有限公司 | Data configuration method, device and medium for Internet of vehicles data and electronic equipment |
| CN113935487A (en) * | 2021-12-21 | 2022-01-14 | 广东粤港澳大湾区硬科技创新研究院 | Visual satellite fault diagnosis knowledge generation method, device and system |
| CN115827644A (en) * | 2023-02-13 | 2023-03-21 | 明度智云(浙江)科技有限公司 | Report generation method, system and server based on visual view configuration |
| CN117473171A (en) * | 2023-12-28 | 2024-01-30 | 江西省映尚科技有限公司 | Intelligent interconnection system and method based on digital content visualization |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN109002289A (en) * | 2017-06-07 | 2018-12-14 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus constructing data model |
| CN109697066A (en) * | 2018-12-28 | 2019-04-30 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN109739856A (en) * | 2018-12-28 | 2019-05-10 | 第四范式（北京）技术有限公司 | Method and system for the relationship established between tables of data |
-
2020
- 2020-06-30 CN CN202010612081.6A patent/CN111782651A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109002289A (en) * | 2017-06-07 | 2018-12-14 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus constructing data model |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN109697066A (en) * | 2018-12-28 | 2019-04-30 | 第四范式（北京）技术有限公司 | Realize the method and system of tables of data splicing and automatic training machine learning model |
| CN109739856A (en) * | 2018-12-28 | 2019-05-10 | 第四范式（北京）技术有限公司 | Method and system for the relationship established between tables of data |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112351081A (en) * | 2020-10-27 | 2021-02-09 | 上海博泰悦臻网络技术服务有限公司 | Data configuration method, device and medium for Internet of vehicles data and electronic equipment |
| CN112351081B (en) * | 2020-10-27 | 2022-03-25 | 上海博泰悦臻网络技术服务有限公司 | Data configuration method, device and medium for Internet of vehicles data and electronic equipment |
| CN113935487A (en) * | 2021-12-21 | 2022-01-14 | 广东粤港澳大湾区硬科技创新研究院 | Visual satellite fault diagnosis knowledge generation method, device and system |
| CN113935487B (en) * | 2021-12-21 | 2022-03-22 | 广东粤港澳大湾区硬科技创新研究院 | Visual satellite fault diagnosis knowledge generation method, device and system |
| CN115827644A (en) * | 2023-02-13 | 2023-03-21 | 明度智云(浙江)科技有限公司 | Report generation method, system and server based on visual view configuration |
| CN117473171A (en) * | 2023-12-28 | 2024-01-30 | 江西省映尚科技有限公司 | Intelligent interconnection system and method based on digital content visualization |
| CN117473171B (en) * | 2023-12-28 | 2024-05-24 | 江西省映尚科技有限公司 | Intelligent interconnection system and method based on digital content visualization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111782651A (en) | Visual editing method, device and equipment for data association relation and storage medium | |
| US9292625B2 (en) | Dynamic determination of pattern type and chart type for visual analytics | |
| US8239226B2 (en) | Methods and apparatus for combining properties and methods from a plurality of different data sources | |
| US8010940B2 (en) | Methods and apparatus for designing a workflow process using inheritance | |
| AU2014202725B2 (en) | Methods and apparatus for translating forms to native mobile applications | |
| US8224853B2 (en) | Methods and apparatus for updating a plurality of data fields in an electronic form | |
| EP3374855A1 (en) | Generation of an application from data | |
| US20130152038A1 (en) | Project management workflows | |
| US20080086716A1 (en) | Method and apparatus for information display with intermediate datasource access | |
| US11693873B2 (en) | Systems and methods for using entity/relationship model data to enhance user interface engine | |
| WO2023116216A1 (en) | Data visualization method and apparatus, and device and storage medium | |
| US7996758B2 (en) | Methods and apparatus for storing data associated with an electronic form | |
| US20070208777A1 (en) | Methods and apparatus for designing a workflow process using resource maps and process maps | |
| CN114185750A (en) | Process monitoring method, device, equipment and storage medium | |
| CN110889013A (en) | Data association method, device, server and storage medium based on XML | |
| US20070143305A1 (en) | Methods and apparatus for storing functions associated with an electronic form | |
| AU2015204370A1 (en) | A modelling system and method for modelling a process or system | |
| US8719704B2 (en) | Seamless integration of additional functionality into enterprise software without customization or apparent alteration of same | |
| WO2019085354A1 (en) | Excel system interface-based database linkage method, electronic device, and storage medium | |
| CN115237425A (en) | Code viewing method and device, computer equipment and storage medium | |
| CN109948251B (en) | CAD-based data processing method, device, equipment and storage medium | |
| KR102099362B1 (en) | Device and method for a data preparation using a micro service | |
| US20070130138A1 (en) | Methods and apparatus for storing a collaboratively designed workflow process | |
| CN108960433B (en) | Method and system for running machine learning modeling process | |
| CN112579165A (en) | Batch operation execution method and device, readable medium and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210203 Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.) Applicant after: Shenzhen saiante Technology Service Co.,Ltd. Address before: 1-34 / F, Qianhai free trade building, 3048 Xinghai Avenue, Mawan, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong 518000 Applicant before: Ping An International Smart City Technology Co.,Ltd. |
|
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |