CN111752925A - Visual data management method - Google Patents
Visual data management method Download PDFInfo
- Publication number
- CN111752925A CN111752925A CN202010603592.1A CN202010603592A CN111752925A CN 111752925 A CN111752925 A CN 111752925A CN 202010603592 A CN202010603592 A CN 202010603592A CN 111752925 A CN111752925 A CN 111752925A
- Authority
- CN
- China
- Prior art keywords
- data
- data table
- information
- version
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 53
- 238000013523 data management Methods 0.000 title claims abstract description 34
- 230000000007 visual effect Effects 0.000 title claims abstract description 31
- 230000008859 change Effects 0.000 claims abstract description 32
- 238000012986 modification Methods 0.000 claims abstract description 15
- 230000004048 modification Effects 0.000 claims abstract description 15
- 238000012217 deletion Methods 0.000 claims abstract description 13
- 230000037430 deletion Effects 0.000 claims abstract description 13
- 238000007792 addition Methods 0.000 claims abstract description 5
- 230000008569 process Effects 0.000 claims description 25
- 230000001360 synchronised effect Effects 0.000 claims description 7
- 238000007726 management method Methods 0.000 abstract description 10
- 238000012384 transportation and delivery Methods 0.000 abstract description 4
- 238000012545 processing Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 9
- 238000011161 development Methods 0.000 description 5
- 230000014509 gene expression Effects 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000011160 research Methods 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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)
- Quality & Reliability (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a visual data management method, which comprises the following steps: receiving and executing addition, deletion, modification or search operation oriented to the data table based on the control panel; and synchronizing the data change and the operation information in the corresponding operation to the corresponding operation log and the corresponding version data table, and automatically generating a version number corresponding to the data change in the version data table. The beneficial effect of this application includes: at the initial stage of project implementation, the recording of the operation content, the operator and the operation time of any data operation by a user can be realized only through simple modeling work, the full version data of the corresponding version number is generated when the data is changed, and the user can perform query statistics or other extension processing based on the version data and/or log records. The flexible and changeable configuration and the extremely small workload not only meet the requirements of users on the data full life cycle management, but also greatly improve the speed of project implementation delivery.
Description
Technical Field
The application relates to the technical field of data table management, in particular to a visual data management method which is used for convenient and visual automatic data management.
Background
From the current customer projects and market research and analysis, it can be found that the demands of users for data fine management are more and more vigorous, but enterprise management software in the market lacks a visual configuration management component integrating operation log recording and version data generation processing, and users need to do a large amount of secondary development work if needing to realize data life cycle management and version data management, and the work needs to consume a large amount of manpower and time both as a first party of the customer and as a second party of an implementer, so that the project cost is increased, and the delivery time is delayed.
Disclosure of Invention
The method integrates data operation logs, version data control and a data full life cycle, and realizes visual data management by adopting operation based on a control panel; a user or implementation can automatically realize a complex secondary data development function only through simple data table configuration, and the project delivery efficiency is greatly improved.
The application provides a visual data management method, which comprises the following steps: receiving and executing addition, deletion, modification or search operation oriented to the data table based on the control panel; and synchronizing the data change and the operation information in the corresponding operation to the corresponding operation log and the corresponding version data table, and automatically generating a version number corresponding to the data change in the version data table.
In one or more embodiments, the operational information includes: adding, deleting, modifying and checking operation, operators and operation time.
In one or more embodiments, the version data table is configured to associate a data table storing latest data and an operation log corresponding to the data table, and to dynamically save all historical data and corresponding operation information of the corresponding data table; the operation log is used for storing data changes corresponding to the data table and corresponding operation information.
In one or more embodiments, the control panel includes an add-on function option to perform an add-on operation, the add-on operation including: acquiring an input data set and a name thereof; acquiring input operator information; automatically generating a new number and automatically recording the operation time; and after the new operation is confirmed, triggering the process of synchronizing the data change and the operation information in the new operation to the operation log comprises the following steps: the operation log records the newly added data set, the name of the data set, the newly added number, the operator information, the operation time and the operation type.
In one or more embodiments, the control panel further includes a delete function option to perform a delete operation, the delete operation including: acquiring deleted data in a data table; acquiring corresponding operator information; automatically recording the operation time; and after the deletion operation is confirmed, the process of triggering the data change and the operation information in the deletion operation to be synchronized to the operation log comprises the following steps: the operation log records deleted data, operator information, operation time, and operation type.
In one or more embodiments, the control panel further includes a modify function option to perform a modify operation, the modify operation including: acquiring modified field information in a data table; comparing the modified field information with corresponding historical field information, and summarizing different items of the field information; acquiring input operator information; automatically recording the operation time; and after the modification operation is confirmed, the process of triggering the data change and the operation information in the modification operation to be synchronized to the operation log comprises the following steps: and recording the summarized items and historical field information, modified field information, operator information, operation time and operation types corresponding to the items by the operation log.
In one or more embodiments, the process of synchronizing the data change and the operation information in the corresponding operation to the corresponding version data table includes: acquiring the table name of the corresponding data table and the table name of the corresponding operation log, and further acquiring the table name of the version data table; acquiring all field information under a corresponding data table; judging whether a corresponding version data table exists according to the version data table name; if the corresponding version data table does not exist, automatically creating a new version data table and carrying out upgrading operation; if the corresponding version data table exists, further judging whether the corresponding field information in the corresponding version data table of the field information is changed, and if so, performing upgrading operation; the table name of the version data table consists of a table name corresponding to the data table and a table name corresponding to the operation log; the upgrade operation includes generating a version number and a complete data set corresponding to the data change.
In one or more embodiments, the field information includes: field number, field name, field type, and associated description.
In one or more embodiments, the control panel further includes a search function option for performing a search operation, where the search operation includes obtaining and displaying data according to input information, where the data includes a corresponding data table, a corresponding version data table, and an operation log associated with the version data table; the input information includes: a field number, a field name, and/or an associated description.
In one or more embodiments, the data management method further comprises: establishing a data table model, wherein the data table model comprises a data table name and a corresponding name; configuring field information corresponding to a data table, and recording a field number, a field name, a field type and a related description contained in the data table under a corresponding data table name; and configuring a function calling component of the operation log and a function calling component of the version data table so that when corresponding operations are executed through the operation panel, the operation log and the version record table execute the corresponding operations at proper time.
The beneficial effect of this application includes: at the initial stage of project implementation, the recording of the operation content, the operator and the operation time of any data operation by a user can be realized only through simple modeling work, the full version data of the corresponding version number is generated when the data is changed, and the user can perform query statistics or other extension processing based on the version data and/or log records. The flexible and changeable configuration and the extremely small workload not only meet the requirements of users on the data full life cycle management, but also greatly improve the speed of project implementation delivery.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art that other embodiments can be obtained by using the drawings without creative efforts.
FIG. 1 is a workflow diagram of visual data management of the present application;
FIG. 2 is a diagram illustrating dictionary information configuration for a data table of the present application;
FIG. 3 is a diagram illustrating field attribute configuration for a data table of the present application;
FIG. 4 is a schematic diagram of a version data table of the present application;
FIG. 5 is a complete workflow diagram of the visual data management of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the following embodiments of the present application are described in further detail with reference to the accompanying drawings.
It should be noted that all expressions using "search" and "second" in the embodiments of the present application are used to distinguish two entities with the same name but different names or different parameters, and it is understood that "search" and "second" are merely for convenience of expression and should not be understood as limitations to the embodiments of the present application, and they are not described in any more detail in the following embodiments.
The method for managing the visual data is provided for facilitating data management of users and reducing secondary development work of the users on the data.
Fig. 1 is a flowchart illustrating a visual data management process according to the present application. In one embodiment of the present application, a visualization data management method includes: step 100, receiving and executing addition, deletion, modification or check operations oriented to a data table based on a control panel; step 200, synchronizing the data change and the operation information in the corresponding operation to the corresponding operation log and the corresponding version data table, and automatically generating the version number corresponding to the data change in the version data table.
Specifically, the operation information includes: adding, deleting, modifying and checking operation, operators and operation time. The version data table is configured with a data table for storing the latest data in an associated manner and an operation log corresponding to the data table, and is further used for calling the specific content of the operation log; the version data table is further used for dynamically storing all historical data and corresponding operation information of the corresponding data table, and the operation log is used for storing data changes and corresponding operation information of the corresponding data table. More specifically, the change of the data saved in the operation log is a change process of the data, for example, data a is modified into data B.
As described above, while the user manages the data table through the visual operation panel, the background automatically generates the corresponding operation log and version data table to record the data change, history data and operation information in the corresponding operation. According to the method and the device, secondary automatic development of data is realized, visual operation is simple and visual, and great convenience is brought to the management of a user on the data.
In a further embodiment, the control panel includes an add-on function option to perform an add-on operation, the add-on operation including: acquiring an input data set and a name thereof; acquiring input operator information; automatically generating a new number and automatically recording the operation time; and after the new operation is confirmed, triggering the process of synchronizing the data change and the operation information in the new operation to the operation log comprises the following steps: the operation log records the newly added data set, the name of the data set, the newly added number, the operator information, the operation time and the operation type.
Specifically, the user clicks a new button in the operation panel to jump to a new interface. The add-on interface will provide the user in the form of a table to enter the data set to be added and the corresponding name. The input format of the data set is consistent with the format when the data table is established, and the data set comprises field numbers, field types and related descriptions; the corresponding name of the data set is a user-defined Chinese name for facilitating the management of the user. After the user inputs the related new data, the background synchronizes the data change and the operation information in the new operation to the operation log by clicking the save button.
Preferably, the user needs to input operator information while inputting the related new data; more preferably, when the user does not input the operator information, the user cannot save the newly added data.
In a further embodiment, the control panel further comprises: a delete function option to perform a delete operation, the delete operation comprising: acquiring deleted data in a data table; acquiring corresponding operator information; automatically recording the operation time; and after the deletion operation is confirmed, the process of triggering the data change and the operation information in the deletion operation to be synchronized to the operation log comprises the following steps: the operation log records deleted data, operator information, operation time, and operation type.
Specifically, a user can select a field to be deleted and then click a delete button to execute deletion operation; the delete operation can only delete the entire field, including the field number, field name, field type, and associated description.
In a further embodiment, the control panel further comprises: a modify function option to perform a modify operation, the modify operation comprising: acquiring modified field information in a data table; comparing the modified field information with corresponding historical field information, and summarizing different items of the field information; acquiring input operator information; automatically recording the operation time; and after the modification operation is confirmed, the process of triggering the data change and the operation information in the modification operation to be synchronized to the operation log comprises the following steps: and recording the summarized items and historical field information, modified field information, operator information, operation time and operation types corresponding to the items by the operation log.
Specifically, the history data corresponding to the modified field information is stored in the version record table. In the modification operation, the data change of the operation log record is as follows: the field name a of the field number a is modified to b.
As above, in the process of adding, deleting, modifying and checking by the user, the background can automatically record corresponding data changes and operation information; therefore, the traceability of the data is better, and the later management is more convenient. In the process of adding, deleting, modifying and checking, the generation and recording process of the version data table is as follows:
in the operation of adding, deleting, changing and checking, the version record table is generated later than the operation log, namely, the data change is recorded first, and then the historical data is recorded.
In a further embodiment, after an addition operation, a deletion operation, or a modification operation or confirmation is performed, a background triggers a process of synchronizing data change and operation information in a corresponding operation to a corresponding version data table, the process including: acquiring the table name of the corresponding data table and the table name of the corresponding operation log, and further acquiring the table name of the version data table; acquiring all field information under a corresponding data table; judging whether a corresponding version data table exists according to the version data table name; if the version data table does not exist, automatically creating a new version data table and carrying out upgrading operation; if yes, further judging whether the corresponding field information (history information) in the corresponding version data table of the field information is changed, and if so, performing upgrading operation; the table name of the version data table consists of a table name corresponding to the data table and a table name corresponding to the operation log; the upgrade operation includes generating a version number and a complete data set corresponding to the data change. Wherein the field information includes: field number, field name, field type, and associated description.
As described above, the version data table records a complete data set including all historical data, and data changes recorded by the operation log are matched, so that a user can comprehensively view existing data, a change process of the existing data, and corresponding operation information.
In a further embodiment, the control panel further comprises: a lookup function option to perform a lookup operation, the lookup operation comprising: acquiring and displaying data according to input information, wherein the data comprises a corresponding data table, a corresponding version data table and an operation log associated with the version data table; the input information includes: a field number, a field name, and/or an associated description.
As described above, the method and the device can realize visual data management (operations such as addition, deletion, modification, and search) through the control surface, and meanwhile, the background can also generate an operation log and a version record report to record data changes and operator information in related operations, thereby realizing automatic secondary development of data and greatly facilitating data management work of users.
This application not only easy operation, but the configuration process is also very simple, and the configuration process includes: establishing a data table model, wherein the data table model comprises data table names and corresponding names (Chinese paraphrases); configuring field information corresponding to a data table, and recording field numbers, field names, field types and related descriptions contained in the data table under corresponding data table names; and configuring a function calling component of the operation log and a function calling component of the version data table so that when corresponding operations are executed through the operation panel, the operation log and the version record table execute the corresponding operations at proper time.
As the method of the application does not need to configure the version record table in advance, the workload of modeling in the early period of the user is reduced.
Specifically, the specific format of the created data table may be determined according to the specific working condition. All the field information under the configuration field table is divided into: dictionary information configuration and field attribute information configuration. The dictionary information configuration comprises configuration field numbers, field names, field types and relevant descriptions. The field attribute configuration comprises the following steps: the corresponding attribute field is entered under a specific field number and field name, such as field length, field type, and whether the field may be empty. The following description is made with reference to the accompanying drawings.
Fig. 2 is a schematic diagram illustrating dictionary information configuration for a data table of the present application. In one embodiment of the present application, the dictionary information of the data table includes: table name of the data table, field number under the table name, field name corresponding to each field number, field type and related description. As shown in fig. 2, in order to perform data management on a document, a dictionary information configuration example is used in the process of establishing a data table; wherein the table name of the established data table is MDMXTZDB; the configured field numbers are MDMXTZDB _ ZDBH and MDMXTZDB _ ZDMC, which respectively represent the document number and the document name; wherein, the field type of the document number is as follows: VARCHAR (40), the field type of the document name is: VARCHAR (100); and the document number is explained as the name of the database table in the related description; the document name is a Chinese paraphrase of the database table. Correspondingly, the configuration process of the field attribute information is as follows:
fig. 3 is a schematic diagram illustrating field attribute configuration of a data table according to the present application. Specifically, fig. 3 shows the attribute configuration of mdmxzdb _ ZDBH (document number), and the corresponding table name is mdmzfw. In the following, line 1 under the field number shows that the configuration object of the field attribute is mdmxzdb _ ZDBH (document number), and the description specifically explains that the document number is the document table number to which the field mdmxzdb _ ZDBH (document number) belongs. The field attribute number column, field attribute name (chinese name), field attribute length, field type, and whether it can be empty are configured with mdmxzdb _ ZDBH (document number) at lines 2 to 6 of the field number, respectively. The field type in the field name is different from the field type under the table name in that the field type under the table name records the variable attribute of the field, such as the character string type Char or integer Int; the field types in the field name are as follows: passwords, account numbers, etc. Whether the field can be empty or not is configured to be a check direction, and after checking, the column where the field name is located can have no data, that is, no field value. However, when the field name includes a field value such as a password that cannot be null, the background automatically identifies whether the check field is not allowed to be null. As can be seen from fig. 3, the attribute configuration is actually a further configuration of specific fields in the dictionary information configuration.
As above, the establishment of a complete data table model is completed through the configuration of dictionary information and the configuration of field attribute information. In the process of configuring dictionary information, determining the name of a data table and the content in the data table; and configuring field attribute information, and then performing further attribute configuration on the specific content.
Fig. 4 is a schematic diagram of a version data table of the present application. In one embodiment of the present application, the format of the version data table is consistent with the format of the previously established data table, including: field number, field name, field type, and associated description. Specifically, the version data table records information such as the version number, the operation type, the internal code value, the version name, the version number, the version generation time, and the version operator of the operation log. As can be seen from the version data table shown in fig. 4, the main function of the version data table is to associate the data table with the corresponding operation log, and mainly record the relevant content of the operation log. And searching the corresponding version data table through the data table name, namely realizing the check of the corresponding operation log. The version data table records history data of all data in the data, and the operation log records data change processes of all data in the data table, so that the data can be comprehensively managed by using the version data table and the operation log; in addition, the operation log and the version record table in the method are automatically generated, and the method can greatly facilitate data management work of users.
Fig. 5 is a complete workflow diagram of the visualization data management of the present application. The complete workflow includes: configuring a data table, configuring fields of the data table, integrating functions, generating an operation log and recording data change and operation information; generating a version data table to record data change and operation information; and performing data query based on the operation log and/or the version data table.
In another embodiment of the present application, a storage medium is further provided, where the storage medium stores a program corresponding to one of the visual data management methods in all the embodiments.
In another embodiment of the present application, a visual data management system is further provided, where the visual data management system includes a background server and one or more end hosts; the background server stores a program corresponding to the visual data management method in all the embodiments; one or more terminal hosts call the program to realize the visual management of the data by receiving the control panel issued by the background server.
The foregoing are exemplary embodiments of the present disclosure, but it should be noted that various changes and modifications could be made herein without departing from the scope of the present disclosure as defined by the appended claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements disclosed in the embodiments of the present application may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated.
It should be understood that, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly supports the exception. It should also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items.
The numbers of the disclosed embodiments in the embodiments of the present application are merely for description and do not represent the merits of the embodiments.
Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure (including the claims) of the embodiments of the application is limited to these examples; within the context of the embodiments of the present application, also features in the above embodiments or in different embodiments may be combined and there are many other variations of the different aspects of the embodiments of the present application as described above, which are not provided in detail for the sake of brevity. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of the embodiments of the present application are intended to be included within the scope of the embodiments of the present application.
Claims (10)
1. A visual data management method, comprising:
receiving and executing addition, deletion, modification or search operation oriented to the data table based on the control panel;
and synchronizing the data change and the operation information in the corresponding operation to the corresponding operation log and the corresponding version data table, and automatically generating a version number corresponding to the data change in the version data table.
2. The visual data management method of claim 1, wherein the operational information comprises: adding, deleting, modifying and checking operation, operators and operation time.
3. The visual data management method of claim 1, wherein the version data table is configured to associate a data table storing latest data and its corresponding operation log, and to dynamically save all historical data and corresponding operation information of the corresponding data table; the operation log is used for storing data changes corresponding to the data table and corresponding operation information.
4. The visual data management method of claim 1 wherein the control panel includes an add-on function option to perform an add-on operation, the add-on operation comprising:
acquiring an input data set and a name thereof;
acquiring input operator information;
automatically generating a new number and automatically recording the operation time; and
after the new operation is confirmed, the process of triggering the data change and the operation information in the new operation to be synchronized to the operation log comprises the following steps:
the operation log records the newly added data set, the name of the data set, the newly added number, the operator information, the operation time and the operation type.
5. The visual data management method of claim 4, wherein the control panel further comprises a delete function option to perform a delete operation, the delete operation comprising:
acquiring deleted data in a data table;
acquiring corresponding operator information;
automatically recording the operation time; and
after the deletion operation is confirmed, the process of triggering the data change and the operation information in the deletion operation to be synchronized to the operation log comprises the following steps:
the operation log records deleted data, operator information, operation time, and operation type.
6. The visual data management method of claim 5, wherein the control panel further includes a modify function option to perform a modify operation, the modify operation comprising:
acquiring modified field information in a data table;
comparing the modified field information with corresponding historical field information, and summarizing different items of the field information;
acquiring input operator information;
automatically recording the operation time; and
after the modification operation is confirmed, the process of triggering the data change and the operation information in the modification operation to be synchronized to the operation log comprises the following steps:
and recording the summarized items and historical field information, modified field information, operator information, operation time and operation types corresponding to the items by the operation log.
7. The visual data management method of claim 6, wherein the process of synchronizing the data changes and operation information in the corresponding operations to the corresponding version data table comprises:
acquiring the table name of the corresponding data table and the table name of the corresponding operation log, and further acquiring the table name of the version data table;
acquiring all field information under a corresponding data table;
judging whether a corresponding version data table exists according to the version data table name;
if the corresponding version data table does not exist, automatically creating a new version data table and carrying out upgrading operation;
if the corresponding version data table exists, further judging whether the corresponding field information in the corresponding version data table of the field information is changed, and if so, performing upgrading operation;
the table name of the version data table consists of a table name corresponding to the data table and a table name corresponding to the operation log; the upgrade operation includes generating a version number and a complete data set corresponding to the data change.
8. The visual data management method of claim 7, wherein the field information comprises: field number, field name, field type, and associated description.
9. The visual data management method of claim 8, wherein the control panel further comprises a lookup function option to perform a lookup operation, the lookup operation comprising: acquiring and displaying data according to input information, wherein the data comprises a corresponding data table, a corresponding version data table and an operation log associated with the version data table; the input information includes: a field number, a field name, and/or an associated description.
10. A visual data management method as claimed in claim 1 wherein said data management method further comprises:
establishing a data table model, wherein the data table model comprises a data table name and a corresponding name;
configuring field information corresponding to a data table, and recording a field number, a field name, a field type and a related description contained in the data table under a corresponding data table name;
and configuring a function calling component of the operation log and a function calling component of the version data table so that when corresponding operations are executed through the operation panel, the operation log and the version record table execute the corresponding operations at proper time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010603592.1A CN111752925B (en) | 2020-06-29 | 2020-06-29 | Visual data management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010603592.1A CN111752925B (en) | 2020-06-29 | 2020-06-29 | Visual data management method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111752925A true CN111752925A (en) | 2020-10-09 |
| CN111752925B CN111752925B (en) | 2024-05-14 |
Family
ID=72677944
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010603592.1A Active CN111752925B (en) | 2020-06-29 | 2020-06-29 | Visual data management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111752925B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112214492A (en) * | 2020-10-20 | 2021-01-12 | 上海核工程研究设计院有限公司 | Method for recording and inquiring modification condition of S3D model |
| CN112232768A (en) * | 2020-10-16 | 2021-01-15 | 广州助蜂网络科技有限公司 | Merchant data processing method based on full life cycle management |
| CN112597179A (en) * | 2021-03-03 | 2021-04-02 | 北京视界云天科技有限公司 | Log information analysis method and device |
| CN112712410A (en) * | 2020-12-29 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Marketing product configuration method and device for automobile finance company |
| WO2022160599A1 (en) * | 2021-01-28 | 2022-08-04 | 长鑫存储技术有限公司 | Data monitoring method and apparatus for specification management system, computer device, and computer readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436962A (en) * | 2008-12-04 | 2009-05-20 | 金蝶软件（中国）有限公司 | Log management method and system |
| WO2019232832A1 (en) * | 2018-06-06 | 2019-12-12 | 平安科技（深圳）有限公司 | Data monitoring method and device, computer device, and storage medium |
-
2020
- 2020-06-29 CN CN202010603592.1A patent/CN111752925B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101436962A (en) * | 2008-12-04 | 2009-05-20 | 金蝶软件（中国）有限公司 | Log management method and system |
| WO2019232832A1 (en) * | 2018-06-06 | 2019-12-12 | 平安科技（深圳）有限公司 | Data monitoring method and device, computer device, and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 邹艳红;刘雯;黄望;陈佳音;毛先成;: "面向矿床三维动态建模的地质勘探数据库增量更新方法", 地质学刊, no. 03 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112232768A (en) * | 2020-10-16 | 2021-01-15 | 广州助蜂网络科技有限公司 | Merchant data processing method based on full life cycle management |
| CN112214492A (en) * | 2020-10-20 | 2021-01-12 | 上海核工程研究设计院有限公司 | Method for recording and inquiring modification condition of S3D model |
| CN112214492B (en) * | 2020-10-20 | 2023-07-14 | 上海核工程研究设计院股份有限公司 | Recording and inquiring method for S3D model modification condition |
| CN112712410A (en) * | 2020-12-29 | 2021-04-27 | 山东浪潮通软信息科技有限公司 | Marketing product configuration method and device for automobile finance company |
| WO2022160599A1 (en) * | 2021-01-28 | 2022-08-04 | 长鑫存储技术有限公司 | Data monitoring method and apparatus for specification management system, computer device, and computer readable storage medium |
| CN112597179A (en) * | 2021-03-03 | 2021-04-02 | 北京视界云天科技有限公司 | Log information analysis method and device |
| CN112597179B (en) * | 2021-03-03 | 2021-10-15 | 北京视界云天科技有限公司 | Log information analysis method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111752925B (en) | 2024-05-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111752925B (en) | Visual data management method | |
| US11405468B2 (en) | Forming activity streams across heterogeneous applications | |
| US11429600B2 (en) | Loading queries using search points | |
| US11620117B2 (en) | Systems and methods for code clustering analysis and transformation | |
| US11651012B1 (en) | Coding commands using syntax templates | |
| US20240020162A1 (en) | Workflow selection | |
| US20140181154A1 (en) | Generating information models in an in-memory database system | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN102323940A (en) | Configuration platform implementation method, configuration platform and system based on database | |
| CN112015412A (en) | Device and method for generating business model based on form engine | |
| CN109241384B (en) | Scientific research information visualization method and device | |
| CN110941629B (en) | Metadata processing method, apparatus, device and computer readable storage medium | |
| CN105719049B (en) | Method and system for realizing intelligent log | |
| CN116708335A (en) | Message sending control method and device | |
| CN110532058B (en) | Management method, device and equipment of container cluster service and readable storage medium | |
| CN104537012B (en) | Data processing method and device | |
| US10365925B2 (en) | Merging applications | |
| CN111125045B (en) | Lightweight ETL processing platform | |
| CN116339715A (en) | Front-end page construction method and device, electronic equipment and storage medium | |
| CN108470047B (en) | Remote platform monitoring system based on Internet of Things | |
| CN112799638B (en) | Non-invasive rapid development method, platform, terminal and storage medium | |
| CN117008890B (en) | Extended application development system and method | |
| CN114327414B (en) | Method for implementing trigger capable of being plugged in and unplugged from node and computer readable storage medium | |
| US20230035835A1 (en) | System and method of a modular framework for configuration and reuse of web components | |
| CN116126820A (en) | Method, device and equipment for processing spring boot project operation log |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20240412 Address after: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant after: Inspur Genersoft Co.,Ltd. Country or region after: China Address before: 250100 Room 102, 1st floor, R & D building, 2877 Kehang Road, Suncun Town, high tech Zone, Jinan City, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. Country or region before: China |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |