CN114064638A - Information processing method, device, equipment and storage medium - Google Patents
Information processing method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN114064638A CN114064638A CN202111260484.XA CN202111260484A CN114064638A CN 114064638 A CN114064638 A CN 114064638A CN 202111260484 A CN202111260484 A CN 202111260484A CN 114064638 A CN114064638 A CN 114064638A
- Authority
- CN
- China
- Prior art keywords
- information
- tables
- determining
- target
- 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
- 230000010365 information processing Effects 0.000 title claims abstract description 39
- 238000003672 processing method Methods 0.000 title claims abstract description 26
- 238000013507 mapping Methods 0.000 claims abstract description 93
- 238000000034 method Methods 0.000 claims description 43
- 230000015654 memory Effects 0.000 claims description 32
- 230000000750 progressive effect Effects 0.000 claims description 8
- 238000012545 processing Methods 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2468—Fuzzy queries
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Automation & Control Theory (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention relates to an information processing method, an information processing device, information processing equipment and a storage medium, wherein the information processing method comprises the following steps: acquiring attribute information of a plurality of tables and associated information between each table, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables; determining the category information of each table according to the attribute information; generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information; and determining field information corresponding to the target main table according to the mapping relation. Therefore, the information of the main table and the information of the auxiliary table can be visually associated in the data dictionary according to the mapping relation, the fields shared by the two tables can be quickly matched, the matched field information is displayed, the required field information does not need to be searched in the two tables respectively, and the information processing efficiency is improved.
Description
Technical Field
The embodiment of the invention relates to the field of data warehouses, data lakes and data middleboxes, in particular to an information processing method, device, equipment and storage medium.
Background
In the field of data warehousing: there are many associative tables, and tables in different libraries may be logically related to each other, having fields with the same meaning. And the field information of the tables is often stored dispersedly in each table. In order to more conveniently query the field information of the association table, an intuitive and fast query and display method is needed.
In the prior art, the main table and the sub table are usually in different databases, the stored information corresponding to the fields is also different, the specific associated information of a certain field needs to be checked in many times in the service, the information is distributed in different database data tables, the field information needs to be acquired from the databases corresponding to the two tables respectively, the corresponding relation between the main table and the sub table is not intuitive, and the method for acquiring the field information is low in efficiency.
Disclosure of Invention
In view of this, in order to solve the technical problem of low efficiency of acquiring field information, embodiments of the present invention provide an information processing method, apparatus, device, and storage medium.
In a first aspect, an embodiment of the present invention provides an information processing method, including:
acquiring attribute information of a plurality of tables and associated information between each table, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
determining the category information of each table according to the attribute information;
generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information;
and determining field information corresponding to the target main table according to the mapping relation.
In one possible embodiment, the determining the category information of each table according to the attribute information includes:
dividing the table into subject domains in a progressive form according to the attribute information and a first preset rule;
and determining the category information of each table according to the theme domain.
In one possible embodiment, the method further comprises:
determining field information corresponding to the target main table in the mapping relation by adopting a fuzzy search method;
and retrieving the attribute information of each table by adopting a fuzzy search method, and determining the associated information.
In a possible embodiment, the generating a mapping relationship between the primary table and the secondary table according to the association information and the category information includes:
acquiring a table name and/or a library name of each table;
and generating a mapping relation of the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information and a second preset rule.
In one possible embodiment, the method further comprises:
generating a corresponding mapping table by the main table and the auxiliary table according to the mapping relation;
and storing the mapping table into a data dictionary.
In a possible implementation manner, the determining, according to the mapping relationship, field information corresponding to the target primary table includes:
determining a target secondary table corresponding to the target primary table according to the mapping relation;
and integrating the fields of the target main table and the fields of the target auxiliary table to obtain the field information corresponding to the target main table.
In one possible embodiment, the method further comprises:
storing field information collected from one or more of the target secondary tables in a field information table of the target primary table;
and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
In one possible embodiment, the method further comprises:
and displaying the field information according to a preset form.
In a second aspect, an embodiment of the present invention provides an information processing apparatus, including:
the device comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring attribute information of a plurality of tables and association information between each table, and the association information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
the determining module is used for determining the category information of each table according to the attribute information;
the generation module is further used for generating a mapping relation between the main table and the auxiliary table according to the association information and the category information;
the determining module is further configured to determine field information corresponding to the target master table according to the mapping relationship.
In a third aspect, an embodiment of the present invention provides an apparatus, including: a processor and a memory, the processor being configured to execute an information processing program stored in the memory to implement the information processing method of any one of the above first aspects.
In a fourth aspect, an embodiment of the present invention provides a storage medium, where one or more programs are stored, and the one or more programs are executable by one or more processors to implement the information processing method according to any one of the first aspects.
According to the information processing scheme provided by the embodiment of the invention, the attribute information of a plurality of tables and the associated information between each table are obtained, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables; determining the category information of each table according to the attribute information; generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information; and determining field information corresponding to the target main table according to the mapping relation. The method has the advantages that the field information of the main table and the field information of the auxiliary table can be automatically matched according to the mapping relation between the main table and the auxiliary table, classification is carried out on the tables in a subject domain mode, the efficiency of positioning the required tables is higher, automatic classification of the tables by built-in rules is supported, the labor classification cost is reduced, and the field information required to be checked can be visually and quickly displayed.
Drawings
Fig. 1 is a schematic flowchart of an information processing method according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating another information processing method according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of an information processing apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
For the convenience of understanding of the embodiments of the present invention, the following description will be further explained with reference to specific embodiments, which are not to be construed as limiting the embodiments of the present invention.
Fig. 1 is a schematic flow chart of an information processing method according to an embodiment of the present invention, and as shown in fig. 1, the method specifically includes:
s11, obtaining attribute information of a plurality of tables and association information between each table, wherein the association information is used for indicating the relationship between a main table and a secondary table in the plurality of tables.
The information processing method provided by the embodiment of the invention is applied to the data dictionary, the information can be field information of a table in a database, and the processing method can comprise the steps of acquiring and displaying the field information according to the data dictionary. The data dictionary is characterized in that a large number of data tables are classified in a subject domain mode, retrieval is carried out in a fuzzy search mode, a corresponding relation between a main table and an auxiliary table is established, the corresponding relation is recorded into the data dictionary, fields shared by the two tables are matched according to the corresponding relation, and finally field information of the matched main table is displayed.
In this embodiment, the attribute information is used to indicate information that can represent the attribute of the table in each table, and the attribute information of the table can be determined by retrieving the information in the table, extracting keywords, topics of the table, and the like in the table (for example, the attribute information may be a character string such as fengxian, risk, yingxiao, mark, and the like extracted in the table). The tables having the same attribute information have association information therebetween, the association information may be used to indicate a relationship between the primary table and the secondary table, the association relationship between the primary table and the secondary table in the tables having the same attribute information may be determined according to the association information, the association information may be set in advance by a user (for example, the a table and the B table have the same attribute information, the user sets the a table as the primary table, and the B table as the secondary table of the a table), or the association information may be determined according to a preset association rule, where the attribute information of the primary table includes attribute information of the secondary table (for example, the a table attribute information is fengxian and yingxiao, the B table is yingxiao, the a table is determined as the primary table according to the association rule, and the B table is the secondary table of the a table).
Specifically, field information in all tables is retrieved in a fuzzy search mode, key information which can represent attributes of the tables is obtained from the field information, the attribute information of the tables is obtained, and the association information between each table is determined according to a preset association rule or a relation preset by a user.
And S12, determining the category information of each table according to the attribute information.
In this embodiment, a classification rule is preset, where the classification rule is used to determine corresponding category information (for example, the attribute information includes fengxian and/or risk, and the category information is a risk class) according to the attribute information of each table, and the category information is used to indicate a domain to which the information in each table belongs.
Specifically, the category information corresponding to each attribute information is determined according to a classification rule, and the tables with the same attribute information are divided into the same category to obtain the category information of each table.
And S13, generating the mapping relation between the main table and the auxiliary table according to the association information and the category information.
In this embodiment, the mapping relationship is used to indicate a relationship between the primary table and the secondary table, each primary table corresponds to one or more secondary tables in the mapping relationship, and the primary table and the secondary table belonging to the same category information are stored in a mapping manner to obtain the mapping relationship, where the mapping relationship may be: major table- > minor table.
Specifically, the tables are classified according to the category information, and the tables with the associated information in each category are generated into a mapping relation. The representation of the mapping information may include a graphic, a table, a name of a table, and the like.
And S14, determining the field information corresponding to the target main table according to the mapping relation.
In this embodiment, the target primary table is a table that needs to match the corresponding secondary table and acquire the field information, the secondary table corresponding to the target primary table is found from the mapping relationship, the field information in the secondary table is acquired, and the field information of the primary table and the field information of the secondary table are integrated to obtain the field information corresponding to the target primary table.
According to the information processing method provided by the embodiment of the invention, attribute information of a plurality of tables and associated information between each table are obtained, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables; determining the category information of each table according to the attribute information; generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information; and determining field information corresponding to the target main table according to the mapping relation. The method and the device have the advantages that the mapping relation between the main table and the auxiliary table is generated according to the attribute information of the tables, the required field information is quickly searched according to the mapping relation, the required field information does not need to be searched in the two tables respectively, the built-in rules are supported to automatically classify the tables, and the efficiency of searching the field information in the data dictionary is improved.
Fig. 2 is a schematic flow chart of another information processing method according to an embodiment of the present invention, and as shown in fig. 2, the method specifically includes:
s21, obtaining attribute information of a plurality of tables and association information between each table, wherein the association information is used for indicating the relationship between a main table and a secondary table in the plurality of tables.
In this embodiment, the same contents as those in step S11 of fig. 1 are specifically described with reference to step S11, which is not repeated herein for brevity.
And S22, dividing the table into subject fields in a progressive form according to the attribute information and a first preset rule.
In this embodiment, a first preset rule is preset, where the first preset rule is used to indicate a classification rule of a table, the rule should be a rule agreed in a company or an organization, and belongs to a logical classification, and the first preset rule may include determining a topic domain of the table according to attribute information of each table, and dividing the table into a primary topic domain and a secondary topic domain in a progressive manner according to the topic domain. The topic field may include the topic of the table, as well as the logic of the table. The current default theme may include marketing domain, trading domain, customer domain, public domain, user action domain, customer domain, risk domain.
For example, we can consider a table with a table name containing a "fengxian" or "risk" string as belonging to the risk domain and a table with a "yingxiao" or "mark" string as belonging to the marketing domain.
In an optional implementation manner of this embodiment, we may automatically classify the table according to the classification rule provided by the user, or the user may automatically classify the table on the page.
And S23, determining the category information of each table according to the theme domain.
In the present embodiment, tables belonging to the same topic domain have the same category information. The category information is information for indicating a topic domain to which the content in each table belongs.
Specifically, the category information corresponding to each table is determined according to the topic domain to which each table belongs, and the tables belonging to the same topic domain are divided into the same category to obtain the category information of each table.
S24, acquiring the table name and/or the library name of each table; and generating a mapping relation of the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information and a second preset rule.
In this embodiment, a second preset rule is preset, where the second preset rule is used to indicate a rule for generating a mapping relationship, and the second preset rule may include dividing tables of the same category information into a main table and an auxiliary table, mapping the main table and the auxiliary table corresponding to the table of the same category according to association information, where one main table may correspond to one or more auxiliary tables, and mapping and storing the mapping relationship in the form of a table name according to a table name and/or a library name of each table to obtain the mapping relationship, where the mapping relationship may be: main table- > auxiliary table, the table name and library name can be set by the user, or the name of each table itself.
For example, according to the second preset rule, if the library name of a secondary table is abc and the table name is table _0, the table name of the corresponding primary table is t _ abc _ table _ 0. According to such rules, mapping relationships are entered.
In an alternative of this embodiment, the primary table and the secondary table may be mapped and stored according to a second preset rule according to the remark of the table, the position of the table, and other information of the table, in addition to the table name and/or the library name.
S25, generating a corresponding mapping table by the primary table and the secondary table according to the mapping relation; and storing the mapping table into a data dictionary.
In this embodiment, the primary table and the secondary table may generate a corresponding mapping table according to the mapping relationship, and the generated mapping table is used as a basis for the primary table to collect the secondary table information, and the mapping relationship is displayed on a page. The presentation method may be a table (e.g., mysql, MongoDB, etc. arbitrary database stores). The mapping table may be stored in the server and the data dictionary in various forms, may be a configuration file, or other storage forms.
And S26, determining a target secondary table corresponding to the target primary table according to the mapping relation.
In this embodiment, the target primary table is a table that needs to perform field information acquisition, the target secondary table is a secondary table mapped by the target primary table in the mapping relationship, and the target primary table and the target secondary table mapped by the target primary table are retrieved in the mapping relationship.
And S27, integrating the fields of the target primary table and the fields of the target secondary table to obtain the field information corresponding to the target primary table.
In this embodiment, the integrating may include collecting field information in the target primary table and the target secondary table, where a field in the primary table is derived from the secondary table, and then each secondary table collects corresponding field information and integrates all the field information into the information of the primary table, and the integrating manner may be to extract the field information of the primary table and the corresponding secondary table, extract the required field information, and integrate the field information to obtain the field information corresponding to the target primary table. For example, because the information in the primary table is synchronized from the secondary table, the partial fields of the primary table, i.e., from the secondary table, have five fields, namely (a, b, c, d, e), for one primary table, and four fields, namely (a, b, c, f), for the secondary table. Then we compare the fields of the two tables, and consider that (a, b, c) three fields in the primary table are from the secondary table, and then we select all the information about these three fields in the secondary table, and include it in the table information of the primary table, then save it, and show the integrated information on the page.
In an optional method of the embodiment of the present invention, field information collected from one or more of the target secondary tables is stored in a field information table of the target primary table; and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
In this embodiment, a field information table corresponding to each primary table is preset, and the field information table is used for storing field information of the secondary table acquired from the association relationship. That is, the field information in the main table is cached in the field information table of the main table after being collected from the associated sub-table once, and the field information can be obtained from the field information table in each subsequent query, so that the query efficiency can be improved, and the situation that the field information of the main table runs out of each sub-table to be collected every time is seen is avoided.
Further, the table structure information change of the sub table includes: the field information of the table is changed (for example, the field name, the field alias, the field length, the field type, the field attribute, the field remark and the like), the field is added, the field is deleted, and the field information table of the main table can automatically execute the updating operation according to the preset updating rule.
For example, if the attribute information and the category information of the secondary table are changed or the secondary table is deleted directly, the mapping relationship between the corresponding field information table and the primary table- > the secondary table also performs an update or deletion operation.
And S28, displaying the field information according to a preset form.
In this embodiment, a preset form is preset, which can be set according to the requirements of the user, and the preset form is used for indicating a way of interacting with the user, so that the user can conveniently and simply view the field information. And the display modes comprise tables, relational maps and the like.
In an optional method of the embodiment of the present invention, the attribute information of each table and the association information of each table may be retrieved in a form of fuzzy search; and determining a target secondary table corresponding to the target primary table according to the mapping relation in a fuzzy search mode, and retrieving and integrating field information.
According to the information processing method provided by the embodiment of the invention, the attribute information of a plurality of tables, the association information among the tables and the table name and/or the library name of each table are obtained; dividing the table into subject domains in a progressive form according to the attribute information and a first preset rule; determining category information of each table according to the subject field; generating a mapping relation between the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information; and determining field information corresponding to the target main table according to the mapping relation, and displaying the field information. The method and the device realize that the tables are classified according to the form of the subject domain and generate the mapping relation between the main table and the auxiliary table, and quickly integrate the required field information according to the mapping relation without respectively searching the required field information in the two tables, thereby improving the efficiency of searching the field information in the data dictionary and the experience of users.
Fig. 3 is a schematic structural diagram of an information processing apparatus according to an embodiment of the present invention, and as shown in fig. 3, the apparatus specifically includes:
an obtaining module 31, configured to obtain attribute information of a plurality of tables and association information between each table, where the association information is used to indicate a relationship between a primary table and a secondary table in the plurality of tables;
a determining module 32, configured to determine category information of each table according to the attribute information;
the generating module 33 is further configured to generate a mapping relationship between the primary table and the secondary table according to the association information and the category information;
the determining module 32 is further configured to determine, according to the mapping relationship, field information corresponding to the target primary table.
In a possible embodiment, the determining module 32 is specifically configured to divide the table into subject fields in a progressive form according to the attribute information and according to a first preset rule; and determining the category information of each table according to the theme domain.
In a possible embodiment, the determining module 32 is specifically configured to determine, in the mapping relationship, field information corresponding to the target primary table by using a fuzzy search method; and retrieving the attribute information of each table by adopting a fuzzy search method, and determining the associated information.
In a possible embodiment, the obtaining module 31 is specifically configured to obtain a table name and/or a library name of each table;
the generating module 33 is specifically configured to generate a mapping relationship between the primary table and the secondary table according to a second preset rule, according to the association information, the table name and/or the library name of each table, and the category information.
In a possible implementation manner, the generating module 33 is specifically configured to generate a corresponding mapping table from the primary table and the secondary table according to the mapping relationship; and storing the mapping table into a data dictionary.
In a possible implementation manner, the determining module 32 is specifically configured to determine, according to the mapping relationship, a target secondary table corresponding to the target primary table; and integrating the fields of the target main table and the fields of the target auxiliary table to obtain the field information corresponding to the target main table.
In a possible embodiment, the generating module 33 is specifically configured to store the field information collected from one or more target secondary tables in the field information table of the target primary table;
and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
In a possible embodiment, the generating module 33 is specifically configured to display the field information according to a preset form.
The information processing apparatus provided in this embodiment may be an apparatus as shown in fig. 3, and may execute all the steps of the information processing method shown in fig. 1 and fig. 2, so as to achieve the technical effect of the information processing method shown in fig. 1 and fig. 2, and for brevity, please refer to the description related to fig. 1 and fig. 2, which is not described herein again.
Fig. 4 is a schematic structural diagram of an apparatus according to an embodiment of the present invention, where the apparatus 400 shown in fig. 4 includes: at least one processor 401, memory 402, at least one network interface 404, and other user interfaces 403. The various components in device 400 are coupled together by a bus system 405. It is understood that the bus system 405 is used to enable connection communication between these components. The bus system 405 includes a power bus, a control bus, and a status signal bus in addition to a data bus. For clarity of illustration, however, the various buses are labeled as bus system 405 in fig. 4.
The user interface 403 may include, among other things, a display, a keyboard, or a pointing device (e.g., a mouse, trackball, touch pad, or touch screen, among others.
It will be appreciated that memory 402 in embodiments of the invention may be either volatile memory or nonvolatile memory, or may include both volatile and nonvolatile memory. The non-volatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable PROM (EEPROM), or a flash Memory. Volatile Memory can be Random Access Memory (RAM), which acts as external cache Memory. By way of illustration and not limitation, many forms of RAM are available, such as Static random access memory (Static RAM, SRAM), Dynamic Random Access Memory (DRAM), Synchronous Dynamic random access memory (Synchronous DRAM, SDRAM), Double Data Rate Synchronous Dynamic random access memory (ddr Data Rate SDRAM, ddr SDRAM), Enhanced Synchronous SDRAM (ESDRAM), synchlronous SDRAM (SLDRAM), and Direct Rambus RAM (DRRAM). The memory 402 described herein is intended to comprise, without being limited to, these and any other suitable types of memory.
In some embodiments, memory 402 stores the following elements, executable units or data structures, or a subset thereof, or an expanded set thereof: an operating system 4021 and application programs 4022.
The operating system 4021 includes various system programs, such as a framework layer, a core library layer, a driver layer, and the like, and is configured to implement various basic services and process hardware-based tasks. The application programs 4022 include various application programs, such as a Media Player (Media Player), a Browser (Browser), and the like, for implementing various application services. A program for implementing the method according to the embodiment of the present invention may be included in the application 4022.
In this embodiment of the present invention, by calling a program or an instruction stored in the memory 402, specifically, a program or an instruction stored in the application 4022, the processor 401 is configured to execute the method steps provided by the method embodiments, for example, including:
acquiring attribute information of a plurality of tables and associated information between each table, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
determining the category information of each table according to the attribute information;
generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information;
and determining field information corresponding to the target main table according to the mapping relation.
In one possible implementation, dividing the table into subject domains in a progressive form according to the attribute information and a first preset rule;
and determining the category information of each table according to the theme domain.
In a possible implementation manner, a fuzzy search method is adopted to determine field information corresponding to a target main table in the mapping relation;
and retrieving the attribute information of each table by adopting a fuzzy search method, and determining the associated information.
In one possible implementation, a table name and/or a library name of each table is obtained;
and generating a mapping relation of the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information and a second preset rule.
In a possible implementation manner, the primary table and the secondary table generate corresponding mapping tables according to the mapping relationship;
and storing the mapping table into a data dictionary.
In a possible implementation manner, a target secondary table corresponding to the target primary table is determined according to the mapping relation;
and integrating the fields of the target main table and the fields of the target auxiliary table to obtain the field information corresponding to the target main table.
In one possible embodiment, the field information collected from one or more target secondary tables is stored in the field information table of the target primary table;
and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
In one possible embodiment, the field information is presented in a preset form.
The method disclosed in the above embodiments of the present invention may be applied to the processor 401, or implemented by the processor 401. The processor 401 may be an integrated circuit chip having signal processing capabilities. In implementation, the steps of the above method may be performed by integrated logic circuits of hardware or instructions in the form of software in the processor 401. The Processor 401 may be a general-purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, or discrete hardware components. The various methods, steps and logic blocks disclosed in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present invention may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software elements in the decoding processor. The software elements may be located in ram, flash, rom, prom, or eprom, registers, among other storage media that are well known in the art. The storage medium is located in the memory 402, and the processor 401 reads the information in the memory 402 and completes the steps of the method in combination with the hardware.
It is to be understood that the embodiments described herein may be implemented in hardware, software, firmware, middleware, microcode, or any combination thereof. For a hardware implementation, the Processing units may be implemented within one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), general purpose processors, controllers, micro-controllers, microprocessors, other electronic units configured to perform the functions described herein, or a combination thereof.
For a software implementation, the techniques described herein may be implemented by means of units performing the functions described herein. The software codes may be stored in a memory and executed by a processor. The memory may be implemented within the processor or external to the processor.
The apparatus provided in this embodiment may be the apparatus shown in fig. 4, and may execute all the steps of the information processing method shown in fig. 1-2, so as to achieve the technical effect of the information processing method shown in fig. 1-2, and for brevity, it is described with reference to fig. 1-2, which is not described herein again.
The embodiment of the invention also provides a storage medium (computer readable storage medium). The storage medium herein stores one or more programs. Among others, the storage medium may include volatile memory, such as random access memory; the memory may also include non-volatile memory, such as read-only memory, flash memory, a hard disk, or a solid state disk; the memory may also comprise a combination of memories of the kind described above.
When one or more programs in the storage medium are executable by one or more processors to implement the above-described information processing method executed on the information processing apparatus side.
The processor is configured to execute the information processing program stored in the memory to realize the following steps of the information processing method executed on the information processing apparatus side:
acquiring attribute information of a plurality of tables and associated information between each table, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
determining the category information of each table according to the attribute information;
generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information;
and determining field information corresponding to the target main table according to the mapping relation.
In one possible implementation, dividing the table into subject domains in a progressive form according to the attribute information and a first preset rule;
and determining the category information of each table according to the theme domain.
In a possible implementation manner, a fuzzy search method is adopted to determine field information corresponding to a target main table in the mapping relation;
and retrieving the attribute information of each table by adopting a fuzzy search method, and determining the associated information.
In one possible implementation, a table name and/or a library name of each table is obtained;
and generating a mapping relation of the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information and a second preset rule.
In a possible implementation manner, the primary table and the secondary table generate corresponding mapping tables according to the mapping relationship;
and storing the mapping table into a data dictionary.
In a possible implementation manner, a target secondary table corresponding to the target primary table is determined according to the mapping relation;
and integrating the fields of the target main table and the fields of the target auxiliary table to obtain the field information corresponding to the target main table.
In one possible embodiment, the field information collected from one or more target secondary tables is stored in the field information table of the target primary table;
and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
In one possible embodiment, the field information is presented in a preset form.
Those of skill would further appreciate that the various illustrative components and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied in hardware, a software module executed by a processor, or a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are merely exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (11)
1. An information processing method characterized by comprising:
acquiring attribute information of a plurality of tables and associated information between each table, wherein the associated information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
determining the category information of each table according to the attribute information;
generating a mapping relation between the main table and the auxiliary table according to the associated information and the category information;
and determining field information corresponding to the target main table according to the mapping relation.
2. The method of claim 1, wherein determining the category information for each of the tables based on the attribute information comprises:
dividing the table into subject domains in a progressive form according to the attribute information and a first preset rule;
and determining the category information of each table according to the theme domain.
3. The method according to claim 1 or 2, characterized in that the method further comprises:
determining field information corresponding to the target main table in the mapping relation by adopting a fuzzy search method;
and retrieving the attribute information of each table by adopting a fuzzy search method, and determining the associated information.
4. The method according to claim 1, wherein the generating the mapping relationship between the primary table and the secondary table according to the association information and the category information comprises:
acquiring a table name and/or a library name of each table;
and generating a mapping relation of the main table and the auxiliary table according to the association information, the table name and/or the library name of each table and the category information and a second preset rule.
5. The method of claim 4, further comprising:
generating a corresponding mapping table by the main table and the auxiliary table according to the mapping relation;
and storing the mapping table into a data dictionary.
6. The method according to claim 1, wherein the determining field information corresponding to the target primary table according to the mapping relationship includes:
determining a target secondary table corresponding to the target primary table according to the mapping relation;
and integrating the fields of the target main table and the fields of the target auxiliary table to obtain the field information corresponding to the target main table.
7. The method of claim 5 or 6, further comprising:
storing field information collected from one or more of the target secondary tables in a field information table of the target primary table;
and when the table structure information of the secondary table is changed, updating the field information table and the data dictionary according to the table structure information.
8. The method of claim 1, further comprising:
and displaying the field information according to a preset form.
9. An information processing apparatus characterized by comprising:
the device comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring attribute information of a plurality of tables and association information between each table, and the association information is used for indicating the relationship between a main table and an auxiliary table in the plurality of tables;
the determining module is used for determining the category information of each table according to the attribute information;
the generation module is further used for generating a mapping relation between the main table and the auxiliary table according to the association information and the category information;
the determining module is further configured to determine field information corresponding to the target master table according to the mapping relationship.
10. An apparatus, comprising: a processor and a memory, the processor being configured to execute an information processing program stored in the memory to implement the information processing method of any one of claims 1 to 8.
11. A storage medium storing one or more programs executable by one or more processors to implement the information processing method according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111260484.XA CN114064638B (en) | 2021-10-27 | 2021-10-27 | Information processing method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111260484.XA CN114064638B (en) | 2021-10-27 | 2021-10-27 | Information processing method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114064638A true CN114064638A (en) | 2022-02-18 |
| CN114064638B CN114064638B (en) | 2024-07-02 |
Family
ID=80235605
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111260484.XA Active CN114064638B (en) | 2021-10-27 | 2021-10-27 | Information processing method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114064638B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190034486A1 (en) * | 2017-07-31 | 2019-01-31 | International Business Machines Corporation | Joining two data tables on a join attribute |
| US20200073989A1 (en) * | 2018-09-05 | 2020-03-05 | Sap Se | Identification, and query, of semantically-related database tables |
| CN111046035A (en) * | 2019-10-29 | 2020-04-21 | 三盟科技股份有限公司 | Data automation processing method, system, computer equipment and readable storage medium |
| WO2021164425A1 (en) * | 2020-02-19 | 2021-08-26 | 京东方科技集团股份有限公司 | Method and device for data processing, electronic device, and storage medium |
| CN113468160A (en) * | 2021-07-23 | 2021-10-01 | 杭州数梦工场科技有限公司 | Data management method and device and electronic equipment |
-
2021
- 2021-10-27 CN CN202111260484.XA patent/CN114064638B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190034486A1 (en) * | 2017-07-31 | 2019-01-31 | International Business Machines Corporation | Joining two data tables on a join attribute |
| US20200073989A1 (en) * | 2018-09-05 | 2020-03-05 | Sap Se | Identification, and query, of semantically-related database tables |
| CN111046035A (en) * | 2019-10-29 | 2020-04-21 | 三盟科技股份有限公司 | Data automation processing method, system, computer equipment and readable storage medium |
| WO2021164425A1 (en) * | 2020-02-19 | 2021-08-26 | 京东方科技集团股份有限公司 | Method and device for data processing, electronic device, and storage medium |
| CN113468160A (en) * | 2021-07-23 | 2021-10-01 | 杭州数梦工场科技有限公司 | Data management method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114064638B (en) | 2024-07-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2018072071A1 (en) | Knowledge map building system and method | |
| JP4005425B2 (en) | Search result ranking change processing program, search result ranking change processing program recording medium, and content search processing method | |
| US6832350B1 (en) | Organizing and categorizing hypertext document bookmarks by mutual affinity based on predetermined affinity criteria | |
| US9208435B2 (en) | Dynamic creation of topical keyword taxonomies | |
| JP5333216B2 (en) | Information presentation system, information presentation method, and information presentation program | |
| KR101502671B1 (en) | Online analysis and display of correlated information | |
| KR970705795A (en) | PARALLEL PROCESSING SYSTEM FOR TRAVERSING A DATA BASE FOR DATABASE SEARCH | |
| US20080059432A1 (en) | System and method for database indexing, searching and data retrieval | |
| RU2010114245A (en) | GENERAL MODEL EDITING SYSTEM | |
| KR101441219B1 (en) | Automatic association of informational entities | |
| CN111400323A (en) | Data retrieval method, system, device and storage medium | |
| US8799314B2 (en) | System and method for managing information map | |
| TW201820181A (en) | Method and device for processing the accumulation searching | |
| CN114328983A (en) | Document fragmenting method, data retrieval device and electronic equipment | |
| JP5351123B2 (en) | Document search keyword presentation device and document search keyword presentation program | |
| US20080256055A1 (en) | Word relationship driven search | |
| US20140280050A1 (en) | Term searching based on context | |
| CN114064638B (en) | Information processing method, device, equipment and storage medium | |
| KR20010095215A (en) | Method for retrieving data on internet through constructing site information database | |
| US10911592B2 (en) | Method and system for defining an offlinable model graph | |
| WO2019090836A1 (en) | Organization name retrieval method, device and equipment, and storage medium | |
| CN117290302B (en) | Directory separation method, apparatus, computer device and storage medium | |
| JP2002024231A (en) | Method and system for providing information and recording medium with recorded information providing program | |
| CN116127098A (en) | Knowledge graph construction method and device | |
| JP2000132439A (en) | System for retrieving file stored in hard disk of personal computer |
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 | ||
| GR01 | Patent grant |