CN112115189A - Multi-table data processing method and device and electronic equipment - Google Patents
Multi-table data processing method and device and electronic equipment Download PDFInfo
- Publication number
- CN112115189A CN112115189A CN202010797546.XA CN202010797546A CN112115189A CN 112115189 A CN112115189 A CN 112115189A CN 202010797546 A CN202010797546 A CN 202010797546A CN 112115189 A CN112115189 A CN 112115189A
- Authority
- CN
- China
- Prior art keywords
- data
- information
- metadata
- index
- basic tables
- 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
- 238000003672 processing method Methods 0.000 title abstract description 6
- 238000012545 processing Methods 0.000 claims abstract description 71
- 238000000034 method Methods 0.000 claims abstract description 24
- 238000004364 calculation method Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 238000001914 filtration Methods 0.000 description 5
- 238000010276 construction Methods 0.000 description 4
- 238000004590 computer program Methods 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003032 molecular docking Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method and a device for processing multi-table data and electronic equipment, wherein the processing method comprises the following steps: acquiring data source information of a plurality of basic tables and metadata information in the basic tables; obtaining incidence relations among a plurality of basic tables according to the metadata information and the configuration information, generating an index data set and incidence relations among the basic tables according to the data source information and the metadata information, wherein the index data set comprises a plurality of index information used for responding to user operation to perform data processing on the metadata and the service data in the basic tables; providing an index dataset; and receiving operation information of the user on the selected index information, acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information, and providing the corresponding metadata and service data for the user. By applying the invention, the service personnel for defining the index only needs to select the index data set without paying attention to the processing logic of the data source end, thereby reducing the technical threshold for defining the index.
Description
Technical Field
The embodiment of the invention relates to the field of index data processing, in particular to a method and a device for processing multi-table data and electronic equipment.
Background
The existing indexes define the way of docking data sources is usually to directly dock database table data, and the data quality and the data distribution are not fully considered.
At present, business personnel who define indexes are more concerned about result data after the indexes are defined and executed, and the source of the data, the quality and the distribution condition of the data are often not informed or cannot be mastered in a full scale. And the collection, fusion and processing of data should be the work of data development group personnel, so that it is obviously inappropriate that business personnel pay attention to the quality and distribution condition of data in the index definition stage.
Disclosure of Invention
The embodiment of the invention aims to provide a method and a device for processing multi-table data and electronic equipment, which are used for solving the problem that index definition is difficult for existing business personnel.
In order to achieve the above object, the embodiments of the present invention mainly provide the following technical solutions:
in a first aspect, an embodiment of the present invention provides a method for processing multi-table data, including: acquiring data source information of a plurality of basic tables and metadata information in the basic tables; obtaining incidence relations among the plurality of basic tables according to the metadata information and the configuration information, and generating an index data set according to the data source information, the metadata information and the incidence relations, wherein the index data set comprises a plurality of index information used for responding to user operation to perform data processing on the metadata and the service data in the plurality of basic tables; providing the set of metric data; and receiving operation information of a user on the selected index information, acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information, and providing the corresponding metadata and service data for the user.
According to an embodiment of the present invention, the data source information includes database information of the plurality of base table storage data; the metadata information includes column name information, data type information, and business meaning information of the plurality of base tables.
According to an embodiment of the present invention, generating an index dataset according to the data source information, the metadata information and the association relationship includes: providing an initialization dataset; establishing a data source corresponding relation between a database storing data in the plurality of basic tables and the initialization data set according to the data source information; establishing a corresponding relation between the initialization data set and metadata in the plurality of basic tables according to the metadata information; and generating the index data set according to the data source corresponding relation between the database storing data in the plurality of basic tables and the initialization data set, the corresponding relation between the initialization data set and the metadata in the plurality of basic tables and the incidence relation.
According to an embodiment of the present invention, obtaining corresponding metadata and service data from the plurality of base tables according to the operation information and the selected metric information includes: extracting the data acquisition condition and the processing information of the target service data in the operation information; acquiring the target service data and the target metadata from the plurality of basic tables according to the acquired data conditions and the selected index information; and processing the target service data according to the processing information of the target service data, and providing the processing result of the target service data and the target metadata for the user.
In a second aspect, an embodiment of the present invention further provides a device for processing multi-table data, including: the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring data source information of a plurality of basic tables and metadata information in the basic tables; the control processing module is used for obtaining the incidence relation among the plurality of basic tables according to the metadata information and the configuration information and generating an index data set according to the data source information, the metadata information and the incidence relation, wherein the index data set comprises a plurality of index information used for responding to user operation to perform data processing on the metadata and the service data in the plurality of basic tables; the control processing module is further used for providing the index data set, receiving operation information of a user on selected index information, and acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information; and the providing module is used for providing the corresponding metadata and the service data to the user.
According to an embodiment of the present invention, the data source information includes database information of the plurality of base table storage data; the metadata information includes column name information, data type information, and business meaning information of the plurality of base tables.
According to one embodiment of the invention, the control processing module is configured to provide an initialization data set; establishing a data source corresponding relation between a database storing data in the plurality of basic tables and the initialization data set according to the data source information; establishing a corresponding relation between the initialization data set and metadata in the plurality of basic tables according to the metadata information; and generating the index data set according to the data source corresponding relation between the database storing data in the plurality of basic tables and the initialization data set, the corresponding relation between the initialization data set and the metadata in the plurality of basic tables and the incidence relation.
According to an embodiment of the present invention, the control processing module is configured to extract an acquisition data condition and processing information of target service data in the operation information; and acquiring the target service data and the target metadata from the plurality of basic tables according to the acquired data conditions and the selected index information.
In a third aspect, an embodiment of the present invention further provides an electronic device, including: at least one processor and at least one memory; the memory is to store one or more program instructions; the processor is configured to execute one or more program instructions to perform the method for processing multi-table data according to the first aspect.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium containing one or more program instructions, where the one or more program instructions are used to execute the processing method of the multi-table data according to the first aspect.
The technical scheme provided by the embodiment of the invention at least has the following advantages:
according to the method, the device and the electronic equipment for processing the multi-table data, provided by the embodiment of the invention, a service person for defining the index only needs to select the index data set without paying attention to the processing logic of the data source end, so that the technical threshold for defining the index is reduced; the definition of the index data set has the advantages of reducing the complexity of system construction, guaranteeing the real-time performance of data, reducing the difficulty of index definition and the like; the index data set contains basic table information distributed in different storage systems, data do not need to be synchronized to a unified storage system, the construction of a synchronization function and the occupation of storage system resources are reduced, meanwhile, the data can be obtained in real time, and the real-time performance is guaranteed.
Drawings
FIG. 1 is a flowchart of a method for processing multi-table data according to an embodiment of the present invention.
Fig. 2 is a block diagram of a processing apparatus for multi-table data according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention is provided for illustrative purposes, and other advantages and effects of the present invention will become apparent to those skilled in the art from the present disclosure.
In the following description, for purposes of explanation and not limitation, specific details are set forth such as particular system structures, interfaces, techniques, etc. in order to provide a thorough understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In the description of the present invention, it is to be understood that the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
FIG. 1 is a flowchart of a method for processing multi-table data according to an embodiment of the present invention. As shown in fig. 1, the method for processing multi-table data according to the embodiment of the present invention includes:
s1: data source information of the base tables and metadata information in the base tables are obtained.
In this embodiment, the basic table may be a table for storing business data, such as a financial record table stored in Excel. The financial record file may be a balance record file for a specific time period. Such as a year a and month B ledger file. Accordingly, the plurality of base tables may be financial records of between 1 month and 12 months of 2019.
In one embodiment of the present invention, the data source information includes database information of a plurality of base tables storing data, i.e., in which databases the plurality of base tables are stored. In this embodiment, the database of the base table store may be a relational database, a NoSQL type, or a big data storage system. These databases store the business meaning represented by the fields in the underlying tables.
The metadata information includes column name information, data type information, and business meaning information of the plurality of base tables. For example, a certain column name in the basic table is replay _ DT, the data type is DATE, and the corresponding service meaning is "return DATE"; for example, the column name in the base table is BEGIN _ PRINCIPAL, the data type is NUMBER, and the corresponding service meaning is "initial remaining principal".
S2: and obtaining the incidence relation among the plurality of basic tables according to the metadata information and the configuration information of the plurality of basic tables, and generating an index data set according to the data source information, the metadata information and the incidence relation among the plurality of basic tables. Wherein the index data set includes a plurality of index information for data processing of the metadata and the business data in the plurality of base tables in response to a user operation.
In one example of the present invention, an employee information table and a department information table are selected as base tables. The employee information table records the name, sex, age, mobile phone number and department number of each employee. The department information table records a department number, a department name and department service content information. The present example provides an index information for acquiring corresponding information from an employee information table and a department information table according to a given condition to merge, acquiring information of a department a employee from a database corresponding to the employee information table, and acquiring department information of the department a from a database corresponding to the department information table, where the merged table includes a department number of the department a, a department name (i.e., department a), business content information of the department a, names, genders, ages, and mobile phone numbers of respective employees of the department a.
In this embodiment, it is necessary to generate an index data set for a service worker to operate according to the data source information and the metadata information of the multiple base tables, where the index data set provides related operation options such as a screening condition for obtaining specific data from the multiple data tables. Illustratively, the index dataset provides an operational option to obtain office supply expenditure details from the financial balance record table of between 1 and 6 months in 2019.
In an embodiment of the present invention, step S2 specifically includes:
s2-1: an initialization data set is provided. In the initial state, the data set may be empty.
S2-2: and establishing a data source corresponding relation between the databases for storing data in the plurality of basic tables and the initialization data set according to the data source information, and ensuring that the initialization data set can obtain which database the data in each basic table is stored in. When the selected data is required to be obtained from a certain basic table, the data can be directly obtained from the database corresponding to the selected data.
S2-3: and establishing the corresponding relation between the initialization data set and the metadata in the plurality of basic tables according to the metadata information.
Specifically, a table for storing source data is designated in a source library as a basic table, a system automatically pulls metadata information of the basic table from the source library, field information in the metadata information is defaulted as a business meaning of an index data column, a developer can modify or replace the business meaning by using more standard or professional terms, and finally, which fields in the basic table can be designated as the index data column.
Taking the example of an oracle database, the oracle database can define 1000 fields at most in one table, if the table is not enough, a new table needs to be built, the rest fields are put into a second table, and then the corresponding records use the same primary key.
When the amount of data stored in a table is too large, for example, reaches the level of tens of millions or billions, which may affect the performance of the query, the table may be split according to a certain dimension in the table, for example, one table in a month, and the naming mode refers to: tablename + 202007. Since different base tables may use different software or different versions of the same software, the corresponding relationship between the system and the metadata in the base tables needs to be established.
S2-4: and generating an index data set according to the data source corresponding relation between the database for storing data in the plurality of basic tables and the initialization data set, the corresponding relation between the initialization data set and the metadata in the plurality of basic tables and the incidence relation between the plurality of basic tables.
In a specific example of the present invention, when defining an index data set, a relevant base table related to an index is first specified, which generally refers to a data source table used in current index calculation, and an association relationship and an association manner between the base tables are configured.
In the case of multiple tables, fields and association modes used in association between the basic table and the basic table are configured, such as left connection, inner connection, right connection and full connection, and in consideration of performance, limitation of the database on the number of table fields, data magnitude and the like, the same data model may be divided into multiple tables by using a horizontal processing mode, and the tables are subjected to library division and table division by using a vertical processing mode. Wherein, the internal connection is a one-to-one mapping relation, for example, two tables can be displayed only if they have; the left connection is that all data of the left table are displayed, the right table data only display the common part, and no corresponding part can only be displayed in a blank state; the right connection is exactly the opposite of the left connection, i.e. all data of the right table is shown, and the left table data only shows the common part; full concatenation is to look up all the data in the left and right tables, but remove duplicate data from both tables.
And screening and filtering the data of the basic table, and setting filtering logic, for example, if the age field value is negative and does not accord with the logic, filtering can be performed, and other similar service scenes exist, and the value can be in a certain range, and filtering can also be performed in the process, so that the data quality is controlled as much as possible, and the accuracy of index calculation is ensured.
For another example, some basic tables store multiple types of data, and there is no correlation between the types, and a certain index only focuses on one type of data, and at this time, the data type field can be used to filter the data; and finally, marking the name or the identification for the current data set.
S3: an index data set is provided. The index data set is provided to the service operator, for example by means of a terminal device.
S4: and receiving operation information of the user on the selected index information, acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information, and providing the corresponding metadata and service data for the user.
In one embodiment of the present invention, step S4 includes: extracting the data acquisition condition and the processing information of the target service data in the operation information; acquiring target service data and target metadata from a plurality of basic tables according to the acquired data conditions and the selected index information; and processing the target service data according to the processing information of the target service data, and providing the processing result of the target service data and the target metadata for the user.
Specifically, business personnel select a data set according to the name of the data set, and then configure related information of indexes, such as the name, dimension, classification and description of the indexes, on the basis of the selected data set, the related information in the data set can be still modified, such as modifying an association mode, adding a filtering condition and the like; and finally, configuring calculation logic, namely listing fields which are already appointed and configured with service meanings according to a basic table contained in the data set, editing calculation modes among the fields, such as addition, subtraction, multiplication, division, aggregation function, exponential function, logarithmic function and the like, and using a calculation formula formed by combining the service meanings and calculation symbols when displaying.
According to the multi-table data processing method provided by the embodiment of the invention, a service person for defining the indexes only needs to select the index data set without paying attention to the processing logic of the data source end, so that the technical threshold of defining the indexes is reduced; the definition of the index data set has the advantages of reducing the complexity of system construction, guaranteeing the real-time performance of data, reducing the difficulty of index definition and the like; the index data set contains basic table information distributed in different storage systems, data do not need to be synchronized to a unified storage system, the construction of a synchronization function and the occupation of storage system resources are reduced, meanwhile, the data can be obtained in real time, and the real-time performance is guaranteed.
Fig. 2 is a block diagram of a processing apparatus for multi-table data according to an embodiment of the present invention. As shown in fig. 2, the apparatus for processing multi-table data according to the embodiment of the present invention includes an obtaining module 100, a control processing module 200, and a providing module 300.
The obtaining module 100 is configured to obtain data source information of a plurality of base tables and metadata information in the plurality of base tables. The control processing module 200 is configured to obtain an association relationship between the plurality of basic tables according to the metadata information and the configuration information, and generate an index data set according to the data source information, the metadata information, and the association relationship, where the index data set includes a plurality of pieces of index information for performing data processing on the metadata and the service data in the plurality of basic tables in response to a user operation. The control processing module 200 is further configured to provide an index data set, receive operation information of a user on selected index information, and obtain corresponding metadata and service data from a plurality of basic tables according to the operation information and the selected index information. The providing module 300 is used for providing corresponding metadata and service data to the user.
In one embodiment of the invention, the data source information comprises database information of a plurality of basic table storage data; the metadata information includes column name information, data type information, and business meaning information of the plurality of base tables.
In one embodiment of the invention, the control processing module 200 is used to provide an initialization data set; establishing a data source corresponding relation between a database for storing data in a plurality of basic tables and an initialized data set according to data source information; establishing a corresponding relation between an initialization data set and metadata in a plurality of basic tables according to the metadata information; and generating an index data set according to the data source corresponding relation between the database for storing data in the plurality of basic tables and the initialization data set, and the corresponding relation and incidence relation between the initialization data set and the metadata in the plurality of basic tables.
In an embodiment of the present invention, the control processing module 200 is configured to extract the obtaining data condition and the processing information of the target service data in the operation information; and acquiring target service data and target metadata from the plurality of basic tables according to the acquired data conditions and the selected index information.
It should be noted that, a specific implementation of the apparatus for processing multi-table data in the embodiment of the present invention is similar to a specific implementation of the method for processing multi-table data in the embodiment of the present invention, and specific reference is specifically made to the description of the method for processing multi-table data, and details are not repeated for reducing redundancy.
In addition, other configurations and functions of the multi-table data processing apparatus according to the embodiment of the present invention are known to those skilled in the art, and are not described in detail for reducing redundancy.
An embodiment of the present invention further provides an electronic device, including: at least one processor and at least one memory; the memory is to store one or more program instructions; the processor is configured to execute one or more program instructions to perform the method for processing multi-table data according to the first aspect.
The embodiments disclosed herein provide a computer-readable storage medium, in which computer program instructions are stored, and when the computer program instructions are run on a computer, the computer is caused to execute the processing method of multi-table data described above.
In an embodiment of the invention, the processor may be an integrated circuit chip having signal processing capability. The Processor may be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component.
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 modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The processor reads the information in the storage medium and completes the steps of the method in combination with the hardware.
The storage medium may be a memory, for example, which may be volatile memory or nonvolatile memory, or which may include both volatile and nonvolatile memory.
The nonvolatile 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.
The volatile Memory may be a Random Access Memory (RAM) which serves as an external cache. By way of example and not limitation, many forms of RAM are available, such as Static random access memory (Static RAM, SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (ddr Data Rate SDRAM), Enhanced SDRAM (ESDRAM), synchlink DRAM (SLDRAM), and Direct Rambus RAM (DRRAM).
The storage media described in connection with the embodiments of the invention are intended to comprise, without being limited to, these and any other suitable types of memory.
Those skilled in the art will appreciate that the functionality described in the present invention may be implemented in a combination of hardware and software in one or more of the examples described above. When software is applied, the corresponding functionality may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
The above-mentioned embodiments, objects, technical solutions and advantages of the present invention are further described in detail, it should be understood that the above-mentioned embodiments are only 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 on the basis of the technical solutions of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method for processing multi-table data, comprising:
acquiring data source information of a plurality of basic tables and metadata information in the basic tables;
obtaining incidence relations among the plurality of basic tables according to the metadata information and the configuration information, and generating an index data set according to the data source information, the metadata information and the incidence relations, wherein the index data set comprises a plurality of index information used for responding to user operation to perform data processing on the metadata and the service data in the plurality of basic tables;
providing the set of metric data;
and receiving operation information of a user on the selected index information, acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information, and providing the corresponding metadata and service data for the user.
2. The method of claim 1, wherein the data source information includes database information of the base table storage data; the metadata information includes column name information, data type information, and business meaning information of the plurality of base tables.
3. The method of claim 1, wherein generating an index dataset from the data source information, the metadata information, and the association comprises:
providing an initialization dataset;
establishing a data source corresponding relation between a database storing data in the plurality of basic tables and the initialization data set according to the data source information;
establishing a corresponding relation between the initialization data set and metadata in the plurality of basic tables according to the metadata information;
and generating the index data set according to the data source corresponding relation between the database storing data in the plurality of basic tables and the initialization data set, the corresponding relation between the initialization data set and the metadata in the plurality of basic tables and the incidence relation.
4. The method for processing multi-table data according to claim 1, wherein obtaining corresponding metadata and service data from the plurality of base tables according to the operation information and the selected metric information comprises:
extracting the data acquisition condition and the processing information of the target service data in the operation information;
acquiring the target service data and the target metadata from the plurality of basic tables according to the acquired data conditions and the selected index information;
and processing the target service data according to the processing information of the target service data, and providing the processing result of the target service data and the target metadata for the user.
5. An apparatus for processing multi-table data, comprising:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring data source information of a plurality of basic tables and metadata information in the basic tables;
the control processing module is used for obtaining the incidence relation among the plurality of basic tables according to the metadata information and the configuration information and generating an index data set according to the data source information, the metadata information and the incidence relation, wherein the index data set comprises a plurality of index information used for responding to user operation to perform data processing on the metadata and the service data in the plurality of basic tables; the control processing module is further used for providing the index data set, receiving operation information of a user on selected index information, and acquiring corresponding metadata and service data from the plurality of basic tables according to the operation information and the selected index information;
and the providing module is used for providing the corresponding metadata and the service data to the user.
6. The apparatus for processing multi-table data according to claim 5, wherein the data source information includes database information of the plurality of base table storage data; the metadata information includes column name information, data type information, and business meaning information of the plurality of base tables.
7. The apparatus for processing multi-table data according to claim 5, wherein said control processing module is configured to provide an initialization data set; establishing a data source corresponding relation between a database storing data in the plurality of basic tables and the initialization data set according to the data source information; establishing a corresponding relation between the initialization data set and metadata in the plurality of basic tables according to the metadata information; and generating the index data set according to the data source corresponding relation between the database storing data in the plurality of basic tables and the initialization data set, the corresponding relation between the initialization data set and the metadata in the plurality of basic tables and the incidence relation.
8. The device for processing multi-table data according to claim 5, wherein the control processing module is configured to extract the obtaining data condition and the processing information of the target service data in the operation information; and acquiring the target service data and the target metadata from the plurality of basic tables according to the acquired data conditions and the selected index information.
9. An electronic device, characterized in that the electronic device comprises: at least one processor and at least one memory;
the memory is to store one or more program instructions;
the processor, configured to execute one or more program instructions to perform the method for processing multi-table data according to any one of claims 1-4.
10. A computer-readable storage medium containing one or more program instructions for performing the method of processing multi-table data according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010797546.XA CN112115189A (en) | 2020-08-10 | 2020-08-10 | Multi-table data processing method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010797546.XA CN112115189A (en) | 2020-08-10 | 2020-08-10 | Multi-table data processing method and device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112115189A true CN112115189A (en) | 2020-12-22 |
Family
ID=73804704
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010797546.XA Pending CN112115189A (en) | 2020-08-10 | 2020-08-10 | Multi-table data processing method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112115189A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101706911A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for implementing service-oriented index model in business intelligence system |
| CN110414259A (en) * | 2018-04-28 | 2019-11-05 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for constructing data element, realizing data sharing |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件***有限公司 | Data processing method and device, storage medium and electronic device |
| CN111367989A (en) * | 2020-06-01 | 2020-07-03 | 北京江融信科技有限公司 | Real-time data index calculation system and method |
-
2020
- 2020-08-10 CN CN202010797546.XA patent/CN112115189A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101706911A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for implementing service-oriented index model in business intelligence system |
| CN110414259A (en) * | 2018-04-28 | 2019-11-05 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for constructing data element, realizing data sharing |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件***有限公司 | Data processing method and device, storage medium and electronic device |
| CN111367989A (en) * | 2020-06-01 | 2020-07-03 | 北京江融信科技有限公司 | Real-time data index calculation system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110674228B (en) | Data warehouse model construction and data query method, device and equipment | |
| US10747762B2 (en) | Automatic generation of sub-queries | |
| CN107016001B (en) | Data query method and device | |
| CN101308490A (en) | Dynamic report generation method and platform | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN111522817A (en) | Table content mapping system, method and non-transitory storage medium | |
| CN103678591A (en) | Device and method for automatically executing multi-service receipt statistical treatment | |
| CN109947797B (en) | Data inspection device and method | |
| CN112115189A (en) | Multi-table data processing method and device and electronic equipment | |
| CN115857929A (en) | Resource data processing method and device, computer equipment and storage medium | |
| CN110008264B (en) | Data acquisition method and device of cost accounting system | |
| CN113450197A (en) | Hanging account self-balancing result checking method and device | |
| CN110196877B (en) | Data display method, device, computer equipment and storage medium | |
| CN114510534B (en) | Data synchronization method, device, equipment and storage medium | |
| CN113642309B (en) | Data comparison method and related device | |
| US8812512B2 (en) | Bitemporal relational databases and methods of manufacturing and use | |
| CN118052214A (en) | Report automatic generation method, device, computer equipment and storage medium | |
| CN112579634A (en) | Data query method, device, storage medium and equipment | |
| CN114996406A (en) | Standing book generation method and device, storage medium and electronic equipment | |
| CN117350831A (en) | Data processing method and device in cross-border scene, computer equipment and storage medium | |
| CN117251458A (en) | Data processing method, device, electronic equipment and storage medium | |
| CN118227359A (en) | Method and device for checking resource application problem, computer equipment and storage medium | |
| CN117575761A (en) | Resource management method, device, computer equipment and storage medium | |
| CN116401323A (en) | Index data processing method and device and computer equipment |
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 |