CN111078671A - Method, device, equipment and medium for modifying data table field - Google Patents
Method, device, equipment and medium for modifying data table field Download PDFInfo
- Publication number
- CN111078671A CN111078671A CN201911320788.3A CN201911320788A CN111078671A CN 111078671 A CN111078671 A CN 111078671A CN 201911320788 A CN201911320788 A CN 201911320788A CN 111078671 A CN111078671 A CN 111078671A
- Authority
- CN
- China
- Prior art keywords
- annotation information
- current
- data table
- field
- fields
- 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
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/217—Database tuning
-
- 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
Abstract
The embodiment of the invention discloses a method, a device, equipment and a medium for modifying a data table field. The method comprises the following steps: obtaining annotation information of each data table in a database, and constructing an annotation information base; extracting annotation information from an annotation information base as current annotation information, and searching whether the annotation information same as the current annotation information exists in each data table; if the annotation information identical to the current annotation information exists, updating the field corresponding to the current annotation information in each data table according to the corresponding relation between the current annotation information and the reference field; and extracting the next annotation information as the current annotation information, and repeating the operation until all the annotation information is extracted from the annotation information base. The embodiment of the invention can change the fields of the same comment information stored in the data table according to the comment information corresponding to the fields, and can complete the change of the fields of the same comment information in each data table at one time, thereby effectively realizing the field unification under the same comment information.
Description
Technical Field
The embodiment of the invention relates to the technical field of information processing, in particular to a method, a device, equipment and a medium for modifying a database field.
Background
The data definition language is used for executing tasks of the database, and performing operations such as creating, deleting and modifying the database and various objects in the database. For example: creating a database or a database object, modifying the database or the database object, modifying table definitions, fields, comments and the like; all definitions on a database table definition can be modified through the data definition language. Usually, a graphical interface client provided by a third party is adopted to view the definition of the table structure, and a table definition language is generated according to the field name and the field annotation of each field to execute, so that the aim of modifying the table structure is fulfilled.
The defects of the scheme are as follows: the manual selection of which table to modify is needed each time, only one table can be modified at a time, the same comments corresponding to different fields in the database table cannot be modified all at one time, and the efficiency of modifying the fields of the database table is low.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a medium for modifying fields of a data table, which can unify the corresponding relation between release information and the fields in different data tables.
In a first aspect, an embodiment of the present invention provides a method for modifying a field of a data table, including:
obtaining annotation information of each data table in a database, and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database;
extracting annotation information from the annotation information base to serve as current annotation information, and searching whether the annotation information which is the same as the current annotation information exists in each data table of the database;
if the annotation information identical to the current annotation information exists in at least two data tables, updating a field corresponding to the current annotation information in each data table according to the corresponding relation between the current annotation information and a reference field;
and extracting the next annotation information from the annotation information base as the current annotation information, and repeating the operation until all the annotation information is extracted from the annotation information base.
Optionally, before the updating the field corresponding to the current comment information in each data table according to the correspondence between the current comment information and the reference field, the method further includes:
acquiring a check identifier of the corresponding relation between the current comment information and the field in the data table;
and taking the field corresponding to the corresponding relation with the qualified inspection identification as a reference field.
Optionally, updating the field corresponding to the current annotation information in each data table according to the correspondence between the current annotation information and the reference field, including:
acquiring fields corresponding to the current annotation information in other data tables of a database;
and modifying fields corresponding to the current annotation information in other data tables of the database into the reference fields according to the corresponding relation between the current annotation information and the reference fields.
Optionally, the method further includes:
acquiring fields corresponding to current annotation information in data tables of other databases;
and modifying the field corresponding to the current annotation information in the data tables of the other databases into the reference field according to the corresponding relation between the current annotation information and the reference field.
Optionally, obtaining annotation information of each data table in the database, and constructing an annotation information base according to the annotation information, including:
obtaining annotation information of each data table in the database;
carrying out duplicate removal processing on the annotation information of each data table in the database; and constructing an annotation information base according to the duplicate removal result.
In a second aspect, an embodiment of the present invention provides an apparatus for modifying a field of a data table, including:
the construction module is used for acquiring annotation information of each data table in the database and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database;
the searching module is used for extracting annotation information from the annotation information base to serve as current annotation information, and searching whether the annotation information which is the same as the current annotation information exists in each data table of the database;
the updating module is used for updating the field corresponding to the current annotation information in each data table according to the corresponding relation between the current annotation information and the reference field if the annotation information which is the same as the current annotation information exists in at least two data tables;
and the extracting module is used for extracting the next annotation information from the annotation information base as the current annotation information and repeating the operation until all the annotation information is extracted from the annotation information base.
Optionally, the method further includes:
the acquisition module is used for acquiring the check identifier of the corresponding relation between the current comment information and the field in the data table;
and the determining module is used for taking the field corresponding to the corresponding relation which is qualified by the inspection identification as a reference field.
Optionally, the update module is specifically configured to:
acquiring fields corresponding to the current annotation information in other data tables of a database;
and modifying fields corresponding to the current annotation information in other data tables of the database into the reference fields according to the corresponding relation between the current annotation information and the reference fields.
Optionally, the update module is further configured to:
acquiring fields corresponding to current annotation information in data tables of other databases;
and modifying the field corresponding to the current annotation information in the data tables of the other databases into the reference field according to the corresponding relation between the current annotation information and the reference field.
Optionally, the building block is specifically configured to:
obtaining annotation information of each data table in the database;
carrying out duplicate removal processing on the annotation information of each data table in the database; and constructing an annotation information base according to the duplicate removal result.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method for modifying a data table field of any of the embodiments of the present invention.
In a fourth aspect, the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for modifying a data table field according to any one of the embodiments of the present invention.
The method comprises the steps that current annotation information is selected from a constructed annotation information base, whether annotation information with the same name as the current annotation information exists in each data table is searched, and if the current annotation information exists in at least two data tables, all fields corresponding to the current annotation information in the data tables are updated according to the corresponding relation between the current annotation information and a reference field; and after the field corresponding to the current annotation information is updated, selecting next annotation information in the annotation information base in a traversing manner as the current annotation information, and repeatedly executing the operation until all the annotation information in the annotation information base is extracted. The embodiment of the invention can change the fields of the same comment information stored in the data table according to the comment information corresponding to the fields, and can complete the change of the fields of the same comment information in each data table at one time, thereby effectively realizing the field unification under the same comment information.
Drawings
FIG. 1 is a flowchart illustrating a method for modifying fields of a data table according to a first embodiment of the present invention;
FIG. 2 is a flowchart illustrating a method for modifying fields of a data table according to a second embodiment of the present invention;
FIG. 3 is a flowchart of an apparatus for modifying fields in a data table according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device in a fourth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart illustrating a method for modifying a data table field according to a first embodiment of the present invention. The embodiment can be applied to the case of unifying fields with the same annotation information in different data tables. The method can be executed by a data table field modifying device, which can be implemented in hardware and/or software and can be configured in an electronic device. The method specifically comprises the following steps:
s110, obtaining annotation information of each data table in the database, and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database.
In this embodiment, each field stored in the database corresponds to unique annotation information, and a plurality of data tables containing different fields are generated according to the corresponding relationship between each field and the annotation information thereof; the comment information of the field is interpretation information corresponding to the field in the data table, and is mainly used for describing the content contained in the field. In this embodiment, the comment information of the fields representing the same meaning may be different; therefore, one field and the comment information are in a many-to-one relationship, that is, a plurality of fields may correspond to the same comment information; for example, when the comment information is "gender", the corresponding field may be "sex" or "gender", and since both of them indicate gender, when the field corresponding to the comment information is stored, it appears that the same comment information can correspond to a plurality of different fields.
In order to ensure that the same annotation information corresponds to a unique field, the fields stored in the data table need to be subjected to unification treatment; the annotation information needs to be stored in a library, so that the same annotation information can be found out from different data tables according to the annotation information stored in the library, and effective unification of a plurality of different fields under the same annotation information can be realized.
S120, extracting one piece of annotation information from the annotation information base to serve as current annotation information, and searching whether the annotation information identical to the current annotation information exists in each data table of the database.
In this embodiment, in the constructed annotation information base, one piece of annotation information is sequentially selected to perform the same-name lookup from the data table, and whether the annotation information with the same name as the selected current annotation information exists in all the data tables in the database is searched; the current annotation information selected in the annotation information base is queried, so that a complex process of querying one data sheet is avoided, only the annotation information counted in the annotation information base is needed to be queried in sequence, and the query speed can be effectively improved.
If the query result shows that the annotation information identical to the current annotation information exists in the at least two data tables, indicating that the current annotation information corresponds to the at least two fields, then S130 is executed, which is to make the same annotation information correspond to the same fields, so that it is not necessary to know whether the two fields are identical, and both the two fields need to be changed; if the query result shows that only one data table exists in each data table in the database to store the current annotation information, the current annotation information is only corresponding to one field, and therefore the field does not need to be changed.
And S130, updating the field corresponding to the current comment information in each data table according to the corresponding relation between the current comment information and the reference field.
In this embodiment, because the annotation information stored in each data table of the database may correspond to a plurality of different fields, if the fields in the data tables need to be unified, the fields of the same annotation information in each data table need to be standardized based on an accurate correspondence between the annotation information and the fields; the reference field is a standardized field corresponding to the current comment information and can be obtained by the following method: selecting a field corresponding to current comment information from other files as a reference field; manually defining a field corresponding to the current comment information, writing the corresponding relation between the current comment information and the field into a data table, and searching the reference field from the data table through the corresponding relation; and thirdly, determining the reference field by acquiring the test identification of the corresponding relation between the current comment information and the field in the data table.
And S140, extracting the next annotation information from the annotation information base as the current annotation information, and repeating the operation until all the annotation information is extracted from the annotation information base.
In this embodiment, after the field corresponding to the first selected current annotation information is updated, the next annotation information needs to be sequentially selected from the annotation information library as the current annotation information, so as to update the field corresponding to the annotation information with the same name as the current annotation information according to the corresponding relationship between the current annotation information and the corresponding reference field; and repeating the steps of S120, S130 and S140 to operate until all the annotation information stored in the annotation information base is extracted in a traversing manner.
The method comprises the steps that current annotation information is selected from a constructed annotation information base, whether annotation information with the same name as the current annotation information exists in each data table is searched, and if the current annotation information exists in at least two data tables, all fields corresponding to the current annotation information in the data tables are updated according to the corresponding relation between the current annotation information and a reference field; and after the field corresponding to the current annotation information is updated, selecting next annotation information in the annotation information base in a traversing manner as the current annotation information, and repeatedly executing the operation until all the annotation information in the annotation information base is extracted. The embodiment of the invention can change the fields of the same comment information stored in the data table according to the comment information corresponding to the fields, and can complete the change of the fields of the same comment information in each data table at one time, thereby effectively realizing the field unification under the same comment information.
Example two
Fig. 2 is a flowchart illustrating a method for modifying a data table field according to a second embodiment of the present invention. The embodiment is further expanded and optimized on the basis of the embodiment, and can be combined with any optional alternative in the technical scheme. As shown in fig. 2, the method includes:
s210, obtaining annotation information of each data table in the database, and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database.
S220, extracting one piece of annotation information from the annotation information base to serve as the current annotation information, and searching whether the annotation information identical to the current annotation information exists in each data table of the database.
In this embodiment, the current comment information is selected from the comment information base, and the same name is searched, and if the comment information identical to the current comment information exists in at least two data tables, S230 is executed; if only one data table in each queried data table has current annotation information, the situation that the current annotation information is not duplicated in each data table with the selected current annotation information is shown, the next annotation information is selected again as the current annotation information, and the operation of querying under the same name is repeatedly executed.
S230, acquiring a checking identifier of the corresponding relation between the current comment information and the field in the data table; and taking the field corresponding to the corresponding relation which is identified as qualified by the inspection as a reference field.
In this embodiment, the corresponding relationship between the fields in each data table and the annotation information needs to be checked, and the corresponding relationship between the fields in each data table and the annotation information is marked after the checking; for example, it may be pass, fail; the accuracy of the corresponding relation between the annotation information and the field can be distinguished according to the inspection mark, so that the reference field corresponding to the current annotation information can be selected according to the inspection mark of the corresponding relation between the annotation information and the field at the later stage, and the accuracy of the reference field can be effectively ensured.
And S240, updating the field corresponding to the current comment information in each data table according to the corresponding relation between the current comment information and the reference field.
And S250, extracting the next annotation information from the annotation information base as the current annotation information, and repeating the operation until all the annotation information is extracted from the annotation information base.
Optionally, updating the field corresponding to the current annotation information in each data table according to the correspondence between the current annotation information and the reference field, including:
acquiring fields corresponding to current annotation information in other data tables of the database;
and modifying the field corresponding to the current annotation information in other data tables of the database into the reference field according to the corresponding relation between the current annotation information and the reference field.
In the embodiment, the field corresponding to the same comment information as the current comment information is modified, and different fields of the same comment information are standardized into one field; the unification treatment of different fields can be realized through the reference fields based on the verification qualification, all the fields corresponding to the current comment information in the data table are modified into the reference fields, and the effect of field unification is achieved.
Optionally, the method further includes:
acquiring fields corresponding to current annotation information in data tables of other databases;
and modifying the field corresponding to the current annotation information in the data tables of other databases into the reference field according to the corresponding relation between the current annotation information and the reference field.
In this embodiment, a field having the same annotation information in the data tables of other databases except the database corresponding to the reference field may be modified according to the determined reference field; the method not only overcomes the limitation that only one field can be modified at one time in the traditional field modification method, but also can modify fields in data tables of a plurality of databases simultaneously by modifying the databases in a cross-database manner, thereby greatly improving the field modification efficiency.
Optionally, obtaining annotation information of each data table in the database, and constructing an annotation information base according to the annotation information, including:
obtaining annotation information of each data table in a database;
carrying out duplicate removal processing on the annotation information of each data table in the database; and constructing an annotation information base according to the duplicate removal result.
In this embodiment, all annotation information in each data table of the database may be duplicated, and when constructing the annotation information base, only one annotation information base needs to be stored for the same annotation information; therefore, the annotation information acquired from the data table of the database needs to be subjected to deduplication processing, and the storage space of the annotation information is effectively ensured.
According to the embodiment of the invention, the field corresponding to the corresponding relation with qualified inspection identification can be used as the reference field according to the inspection identification of the corresponding relation between the current annotation information and the field in the acquired data table; by selecting the field corresponding to the corresponding relation qualified by manual inspection as the reference field, the accuracy of the reference field is effectively ensured. The modification of fields in data tables of a plurality of databases simultaneously can be realized through the modification of the determined reference fields across databases.
EXAMPLE III
Fig. 3 is a flowchart of a device for modifying fields in a data table according to a third embodiment of the present invention, which is applicable to unifying fields with the same annotation information in different data tables. The device is configured in the electronic equipment, and can realize the modification method of the data table field in any embodiment of the application.
The device specifically comprises the following steps:
the construction module 310 is configured to obtain annotation information of each data table in the database, and construct an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database;
a searching module 320, configured to extract one piece of annotation information from the annotation information base as current annotation information, and search whether there is annotation information that is the same as the current annotation information from each data table of the database;
an updating module 330, configured to update a field corresponding to the current annotation information in each data table according to a corresponding relationship between the current annotation information and a reference field if there is annotation information that is the same as the current annotation information in at least two data tables;
the extracting module 340 is configured to extract next annotation information from the annotation information base as current annotation information, and repeat the above operations until all annotation information is extracted from the annotation information base.
Optionally, on the basis of the above apparatus, the apparatus further includes:
the acquisition module is used for acquiring the check identifier of the corresponding relation between the current comment information and the field in the data table;
and the determining module is used for taking the field corresponding to the corresponding relation which is qualified by the inspection identification as a reference field.
Optionally, on the basis of the foregoing apparatus, the update module 330 is specifically configured to:
acquiring fields corresponding to the current annotation information in other data tables of a database;
and modifying fields corresponding to the current annotation information in other data tables of the database into the reference fields according to the corresponding relation between the current annotation information and the reference fields.
Optionally, on the basis of the foregoing apparatus, the updating module 330 is further configured to:
acquiring fields corresponding to current annotation information in data tables of other databases;
and modifying the field corresponding to the current annotation information in the data tables of the other databases into the reference field according to the corresponding relation between the current annotation information and the reference field.
Optionally, on the basis of the foregoing apparatus, the building module 310 is specifically configured to:
obtaining annotation information of each data table in the database;
carrying out duplicate removal processing on the annotation information of each data table in the database; and constructing an annotation information base according to the duplicate removal result.
By the data table field modifying device, the fields of the same annotation information stored in the data table can be modified according to the annotation information corresponding to the fields, the modification of the fields of the same annotation information in each data table can be completed at one time, and the field unification under the same annotation information can be effectively realized.
The modification device for the data table field provided by the embodiment of the invention can execute the modification method for the data table field provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
Example four
Fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention, as shown in fig. 4, the electronic device includes a processor 410, a memory 420, an input device 430, and an output device 440; the number of the processors 410 in the electronic device may be one or more, and one processor 410 is taken as an example in fig. 4; the processor 410, the memory 420, the input device 430 and the output device 440 in the electronic apparatus may be connected by a bus or other means, and the bus connection is exemplified in fig. 4.
The memory 420 serves as a computer-readable storage medium for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the modification method of the data table fields in the embodiment of the present invention. The processor 410 executes various functional applications and data processing of the electronic device by executing software programs, instructions and modules stored in the memory 420, that is, implements the modification method of the data table fields provided by the embodiment of the present invention.
The memory 420 may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. Further, the memory 420 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device. In some examples, memory 420 may further include memory located remotely from processor 410, which may be connected to an electronic device over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 430 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the electronic apparatus, and may include a keyboard, a mouse, and the like. The output device 440 may include a display device such as a display screen.
EXAMPLE five
The present embodiments provide a storage medium containing computer-executable instructions for implementing a method for modifying data table fields provided by embodiments of the present invention when executed by a computer processor.
Of course, the storage medium provided by the embodiment of the present invention contains computer-executable instructions, and the computer-executable instructions are not limited to the method operations described above, and may also perform related operations in the modification method of the data table field provided by any embodiment of the present invention.
From the above description of the embodiments, it is obvious for those skilled in the art that the present invention can be implemented by software and necessary general hardware, and certainly, can also be implemented by hardware, but the former is a better embodiment in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
It should be noted that, in the embodiment of the above search apparatus, each included unit and module are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method for modifying a data table field, the method comprising:
obtaining annotation information of each data table in a database, and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database;
extracting annotation information from the annotation information base to serve as current annotation information, and searching whether the annotation information which is the same as the current annotation information exists in each data table of the database;
if the annotation information identical to the current annotation information exists in at least two data tables, updating a field corresponding to the current annotation information in each data table according to the corresponding relation between the current annotation information and a reference field;
and extracting the next annotation information from the annotation information base as the current annotation information, and repeating the operation until all the annotation information is extracted from the annotation information base.
2. The method according to claim 1, wherein before said updating a field corresponding to said current comment information in each of said data tables according to a correspondence between said current comment information and a reference field, said method further comprises:
acquiring a check identifier of the corresponding relation between the current comment information and the field in the data table;
and taking the field corresponding to the corresponding relation with the qualified inspection identification as a reference field.
3. The method according to claim 1, wherein the updating a field corresponding to the current annotation information in each data table according to the correspondence between the current annotation information and a reference field comprises:
acquiring fields corresponding to the current annotation information in other data tables of a database;
and modifying fields corresponding to the current annotation information in other data tables of the database into the reference fields according to the corresponding relation between the current annotation information and the reference fields.
4. The method of claim 1, further comprising:
acquiring fields corresponding to current annotation information in data tables of other databases;
and modifying the field corresponding to the current annotation information in the data tables of the other databases into the reference field according to the corresponding relation between the current annotation information and the reference field.
5. The method of claim 1, wherein the obtaining annotation information of each data table in the database and constructing an annotation information base according to the annotation information comprises:
obtaining annotation information of each data table in the database;
carrying out duplicate removal processing on the annotation information of each data table in the database; and constructing an annotation information base according to the duplicate removal result.
6. An apparatus for modifying fields of a data table, the apparatus comprising:
the construction module is used for acquiring annotation information of each data table in the database and constructing an annotation information base according to the annotation information; the annotation information base comprises annotation information corresponding to all fields in each data table in the database;
the searching module is used for extracting annotation information from the annotation information base to serve as current annotation information, and searching whether the annotation information which is the same as the current annotation information exists in each data table of the database;
the updating module is used for updating the field corresponding to the current annotation information in each data table according to the corresponding relation between the current annotation information and the reference field if the annotation information which is the same as the current annotation information exists in at least two data tables;
and the extracting module is used for extracting the next annotation information from the annotation information base as the current annotation information and repeating the operation until all the annotation information is extracted from the annotation information base.
7. The apparatus of claim 6, further comprising:
the acquisition module is used for acquiring the check identifier of the corresponding relation between the current comment information and the field in the data table;
and the determining module is used for taking the field corresponding to the corresponding relation which is qualified by the inspection identification as a reference field.
8. The apparatus of claim 6, wherein the update module is specifically configured to:
acquiring fields corresponding to the current annotation information in other data tables of a database;
and modifying fields corresponding to the current annotation information in other data tables of the database into the reference fields according to the corresponding relation between the current annotation information and the reference fields.
9. An electronic device, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement a method of modifying a data table field as claimed in any one of claims 1 to 5.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method of modifying a data table field according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911320788.3A CN111078671A (en) | 2019-12-19 | 2019-12-19 | Method, device, equipment and medium for modifying data table field |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911320788.3A CN111078671A (en) | 2019-12-19 | 2019-12-19 | Method, device, equipment and medium for modifying data table field |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111078671A true CN111078671A (en) | 2020-04-28 |
Family
ID=70315977
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911320788.3A Pending CN111078671A (en) | 2019-12-19 | 2019-12-19 | Method, device, equipment and medium for modifying data table field |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111078671A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113032360A (en) * | 2021-03-04 | 2021-06-25 | 四川瀚库智数科技有限公司 | Method for inferring database field meaning |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050065958A1 (en) * | 2003-09-19 | 2005-03-24 | International Business Machines Corporation | Expanding the scope of an annotation to an entity level |
| CN106407404A (en) * | 2016-09-22 | 2017-02-15 | 成都快乐家网络技术有限公司 | A data storage method, a data management method and system, a database and a client |
| CN108241499A (en) * | 2018-01-05 | 2018-07-03 | 金行家（深圳）文化传播有限公司 | Update method, device and the computer readable storage medium of field value annotation |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
| CN110110067A (en) * | 2018-01-08 | 2019-08-09 | 深圳市明源软件股份有限公司 | A kind of database annotation method, apparatus and terminal device |
-
2019
- 2019-12-19 CN CN201911320788.3A patent/CN111078671A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050065958A1 (en) * | 2003-09-19 | 2005-03-24 | International Business Machines Corporation | Expanding the scope of an annotation to an entity level |
| CN106407404A (en) * | 2016-09-22 | 2017-02-15 | 成都快乐家网络技术有限公司 | A data storage method, a data management method and system, a database and a client |
| CN108241499A (en) * | 2018-01-05 | 2018-07-03 | 金行家（深圳）文化传播有限公司 | Update method, device and the computer readable storage medium of field value annotation |
| CN110110067A (en) * | 2018-01-08 | 2019-08-09 | 深圳市明源软件股份有限公司 | A kind of database annotation method, apparatus and terminal device |
| CN109144997A (en) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | Data correlation method, device and storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113032360A (en) * | 2021-03-04 | 2021-06-25 | 四川瀚库智数科技有限公司 | Method for inferring database field meaning |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10055509B2 (en) | Constructing an in-memory representation of a graph | |
| US10237295B2 (en) | Automated event ID field analysis on heterogeneous logs | |
| JP6042974B2 (en) | Data management apparatus, data management method, and non-temporary recording medium | |
| CN112115313B (en) | Regular expression generation and data extraction methods, devices, equipment and media | |
| CN110737689A (en) | Data standard conformance detection method, device, system and storage medium | |
| EP3706012A1 (en) | Data selection system and data selection method | |
| CN111914020A (en) | Data synchronization method and device and data query method and device | |
| CN111047434B (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN115860717A (en) | Fault diagnosis method and device based on knowledge graph and electronic equipment | |
| CN105302827B (en) | A kind of searching method and equipment of event | |
| CN113761285A (en) | Metadata generation system based on multi-source data | |
| CN114172793B (en) | Network configuration knowledge graph construction method and device | |
| CN111078671A (en) | Method, device, equipment and medium for modifying data table field | |
| CN111858581A (en) | Page query method and device, storage medium and electronic equipment | |
| CN107644103B (en) | Method and system for storing traceable information source information | |
| CN112860811B (en) | Method and device for determining data blood relationship, electronic equipment and storage medium | |
| CN114579580A (en) | Data storage method and data query method and device | |
| CN113553458A (en) | Data export method and device in graph database | |
| CN109542986B (en) | Element normalization method, device, equipment and storage medium of network data | |
| CN110457705B (en) | Method, device, equipment and storage medium for processing point of interest data | |
| CN111858607A (en) | Data processing method and device, electronic equipment and computer readable medium | |
| CN111985188A (en) | Data conversion method, device, terminal and storage medium | |
| CN112115125A (en) | Database access object name resolution method and device and electronic equipment | |
| US11886459B2 (en) | Data management system and data management method | |
| JP7171905B2 (en) | Electronic map search method, device, equipment and medium |
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 |