CN111104784A - Data integration method and related device - Google Patents
Data integration method and related device Download PDFInfo
- Publication number
- CN111104784A CN111104784A CN201911320767.1A CN201911320767A CN111104784A CN 111104784 A CN111104784 A CN 111104784A CN 201911320767 A CN201911320767 A CN 201911320767A CN 111104784 A CN111104784 A CN 111104784A
- Authority
- CN
- China
- Prior art keywords
- content value
- row
- content
- template
- data
- 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
- 230000010354 integration Effects 0.000 title claims abstract description 38
- 238000000034 method Methods 0.000 title claims abstract description 38
- 238000004590 computer program Methods 0.000 claims description 3
- 238000004220 aggregation Methods 0.000 claims 2
- 230000002776 aggregation Effects 0.000 claims 2
- 230000000694 effects Effects 0.000 abstract description 9
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- RZVHIXYEVGDQDX-UHFFFAOYSA-N 9,10-anthraquinone Chemical compound C1=CC=C2C(=O)C3=CC=CC=C3C(=O)C2=C1 RZVHIXYEVGDQDX-UHFFFAOYSA-N 0.000 description 2
- 230000004308 accommodation Effects 0.000 description 2
- 235000013361 beverage Nutrition 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Document Processing Apparatus (AREA)
Abstract
The embodiment of the application discloses a data integration method, which is used for solving the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates is inconvenient for operators to view in a unified manner. The method in the embodiment of the application comprises the following steps: the method comprises the steps of obtaining a table template, wherein one or more content items are recorded in a table head row of the table template, determining an analysis object corresponding to the table template, reading a first content value of the analysis object corresponding to the content item in a first data source, filling the first content value into a dynamic row in the table template, determining an associated content value related to a second data source in the first content value, reading a second content value of the analysis object corresponding to the associated content value in the second data source, and filling the second content value into an expansion row in the table template to obtain a target table.
Description
Technical Field
The embodiment of the application relates to the field of computer data processing, in particular to a data integration method and a related device.
Background
Various form templates are often used in an enterprise application system to process various enterprise business data, different form templates of the existing enterprise application system are associated with different data sources, that is, different data sources correspond to different form templates one to one, and different form templates are independent from each other in application to analyze different data sources.
When data of different required data sources are processed on a form template, an enterprise application device in practical application can only process the data of the different data sources on the different form templates respectively, joint processing of the different data sources on the same form template cannot be realized, and data presentation effects on a plurality of form templates are inconvenient for operators to view in a unified manner.
Disclosure of Invention
The embodiment of the application provides a data integration method and a related device, which are used for solving the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates is inconvenient for operators to view in a unified manner.
A first aspect of the present application provides a data integration method, including:
acquiring a table template, wherein a table head row of the table template records one or more content items;
determining an analysis object corresponding to the form template;
reading a first content value of the analysis object corresponding to the content item in a first data source;
populating dynamic rows in the table template with the first content values;
determining, in the first content value, an associated content value related to a second data source;
reading a second content value corresponding to the analysis object and the associated content value in the second data source;
and filling the second content value into an expansion row in the form template to obtain a target form.
Optionally, the dynamic row is located below the header row, and the first content value of the dynamic row and the content item corresponding to the header row are located in the same column of the table template.
Optionally, before the second content value is filled into an expansion row in the form template to obtain the target form, the method further includes:
adding a row of table rows below the dynamic rows of the table template;
and merging the cells corresponding to the header content items in the table rows to obtain expanded rows.
Optionally, the filling the second content value into an expansion row in the table template to obtain a target table, including:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
populating the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, said populating said sub-table with said second content value comprises:
and filling the sub-table according to the generation time sequence rule of the second content value.
Optionally, after the obtaining the target table, the method further includes:
printing the target form.
A second aspect of the present application provides a data integration apparatus, including:
the acquisition unit is used for acquiring a table template, wherein a table head row of the table template records one or more content items;
the first determining unit is used for determining an analysis object corresponding to the form template;
a first reading unit, configured to read, in a first data source, a first content value of the analysis object corresponding to the content item;
a first filling unit, configured to fill the first content value into a dynamic row in the table template;
a second determining unit, configured to determine, among the first content values, an associated content value related to a second data source;
a second reading unit, configured to read, in the second data source, a second content value corresponding to the association content value of the analysis object;
and the second filling unit is used for filling the second content value into the expansion row in the form template to obtain the target form.
Optionally, the dynamic row of the data integration apparatus is located below the header row, and the content items corresponding to the first content value of the dynamic row and the header row are located in the same column of the table template.
Optionally, the data integration apparatus further includes:
an adding unit, configured to add a row of table rows below the dynamic rows of the table template;
and the merging unit is used for merging the cells corresponding to the header content items in the table rows to obtain expanded rows.
Optionally, when the second filling unit fills the second content value into the expansion row in the table template to obtain the target table, the second filling unit is specifically configured to:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
populating the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, when the second filling unit fills the second content value into the sub-table, the second filling unit is specifically configured to:
and filling the sub-table according to the generation time sequence rule of the second content value.
Optionally, the data integration apparatus further includes:
and the printing unit is used for printing the target table.
A third aspect of the present application provides a data integration apparatus, comprising:
the system comprises a processor, a memory, a bus and input and output equipment;
the processor is connected with the memory and the input and output equipment;
the bus is respectively connected with the processor, the memory and the input and output equipment;
the processor performs the method of any of the preceding first aspects.
A fourth aspect of the present application provides a computer storage medium having stored therein instructions that, when executed on a computer, cause the computer to perform the method of any of the preceding first aspects.
A fifth aspect of the present application provides a computer program product, which, when executed on a computer, causes the computer to perform the method of any of the preceding first aspects.
According to the technical scheme, the embodiment of the application has the following advantages:
the form template can be additionally provided with the expansion rows, the expansion rows can be used for analyzing data in a second data source, the data in different data sources can be displayed in the same form template in a comprehensive mode, and the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effects on a plurality of form templates are inconvenient for operators to view in a unified mode are solved.
Drawings
FIG. 1 is a schematic flow chart illustrating a data integration method according to an embodiment of the present application;
FIG. 2 is another schematic flow chart illustrating a data integration method according to an embodiment of the present application;
FIG. 3 is a schematic structural diagram of a data integration apparatus according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of a data integration apparatus according to an embodiment of the present application;
fig. 5 is another schematic structural diagram of a data integration apparatus in the embodiment of the present application.
Detailed Description
The embodiment of the application provides a data integration method and a related device, which are used for solving the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates is inconvenient for operators to view in a unified manner.
Referring to fig. 1, an embodiment of a data integration method in the present application includes:
101. a form template is obtained, wherein a header of the form template records one or more content items.
The form template in the embodiments of the present application is a form with a limited number of rows and columns, and the header of the form template records one or more content items, i.e. for example, each column unit in the first row of the form template records one content item, and the first row may have a plurality of columns and a plurality of content items.
102. And determining the analysis object corresponding to the form template.
After the form template is obtained in step 101, the parsing object of the form template needs to be determined, and the process of determining the parsing object of the form template in this step may be to receive a parsing object input by a user, or to receive a specified parsing object.
103. In a first data source, a first content value of a parse object corresponding to a content item is read.
After the parsing object of the table template is determined in step 102, in order to parse out the first content value of the parsing object corresponding to the content item in the table template, the first content value is located in the preset first data source, and at this time, the first content value of the parsing object corresponding to the content item needs to be read in the preset first data source. The first data source is generally a table pre-storing a first content value of the parsed object.
104. The first content value is populated into a dynamic row in the form template.
After obtaining the first content value corresponding to the content item of the parsing object in the table template in step 103, the first content value needs to be filled into a dynamic row in the table template, so as to clarify the position of the first content value in the table template. The dynamic row is a row which originally has no specific corresponding data in the form template, and the data of the row is a first content value obtained by analyzing an analysis object in a first data source.
105. In the first content value, an associated content value associated with the second data source is determined.
After reading the first content value in step 103, the first content value of one or more items may be determined as an associated content value related to the second data source, the related content value being a basis for reading data in the second data source next.
106. And reading a second content value of the analysis object corresponding to the associated content value in a second data source.
After the associated content value of the table template is determined in step 105, in order to parse out the second content value corresponding to the associated content value, the second content value is located in the preset second data source, and at this time, the second content value corresponding to the associated content value needs to be read in the preset second data source. The second data source is typically a table pre-stored with second content values for the associated content.
107. And filling the second content value into an expansion row in the form template to obtain the target form.
After obtaining the second content value corresponding to the associated content value in step 106, the second content value needs to be filled into the expansion row of the form template, so as to clarify the position of the second content value in the form template. The expansion row is a row used for containing a second content value corresponding to the associated content value in the form template, and is an increased row when the second content value needs to be filled in, and the data of the row is the second content value obtained by analyzing the associated content value in the second data source.
In the embodiment of the application, the form template has an expansion row which can be used for analyzing data in a second data source, so that the data in different data sources are integrated in the same form template to be displayed, and the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effects on a plurality of form templates are inconvenient for operators to view in a unified manner are solved.
Referring to fig. 2, another embodiment of the data integration method of the present application includes:
201. a form template is obtained, wherein a header row of the form template records one or more content items.
Specifically, the table template in the embodiment of the present application is a table with a limited number of rows and columns, and the number of rows and columns of the specific table is determined according to the actual situation and is not limited herein. The header of the table template records one or more content items, i.e. for example, each column of cells in the first row of the table template records one content item, and the first row may have a plurality of columns of existing content items. The content items in the embodiment of the application are set in advance according to different requirements of the form template, and are not modified when the form template is used. The content items in the header row of the table template may be modified and supplemented as needed, and are not limited herein. For example: the first row of the form template has three columns, which are written with "trip", "date" and "reason", respectively, as in table 1 below:
| stroke control | Date | Affair principles |
TABLE 1
202. And determining the analysis object corresponding to the form template.
After the form template is obtained in step 201, an analysis object of the form needs to be determined, and the process of determining the analysis object of the form template in this step may be to receive an analysis object input by a user, or to receive a specified analysis object. It should be noted that the parsing object is a parsing object pre-stored with a first content value in a first data source. For example, it is determined that the parsing object corresponding to the form template is "zhang san" or "lie si", and the first content value should be stored in the first data source by "zhang san" or "lie si".
203. In a first data source, a first content value of a parse object corresponding to a content item is read.
After determining the parsing object of the table template in step 202, in order to parse out the first content value of the parsing object corresponding to the content item in the table template, the first content value is located in the preset first data source, and at this time, the first content value of the parsing object corresponding to the content item needs to be read in the preset first data source. The first data source is generally a table pre-storing a first content value of the parsed object. For example, "zhang san" and "lie si" have first content values pre-stored in the table of the first data source as shown in table 2 below:
| name (I) | Stroke control | Date | Affair principles | Remarks for note | …… |
| Zhang three | Shenzhen-Beijing | 2019.11.1—2019.11.4 | Conference for meeting | …… | …… |
| Zhang three | Beijing-Wuhan Dynasty | 2019.11.4—2019.11.8 | Before sale | …… | …… |
| Li four | Shenzhen-Beijing | 2019.11.1—2019.11.4 | …… | …… | |
| Li four | Beijing-Wuhan Dynasty | 2019.11.4—2019.11.8 | Before sale | …… | …… |
TABLE 2
The contents of table 2 of the first data source will be described, where the first row in table 2 is a header row, the header row indicates the common attribute of the column where the table is located, and "… …" in the table indicates that data exists here, but the data is not the important point to express in this table 2, and the absence of data in a cell in the table indicates that the data corresponding to the cell is absent. From the pre-stored data of the first data source, if the analysis object determined in step 202 is "zhang san" and the table template contains the header row content items of "trip", "date" and "incident", the first content value in this step corresponds to: the 'journey' corresponds to two items 'Shenzhen-Beijing' and 'Beijing-Wuhan'; the "date" corresponds to two items "2019.11.1-2019.11.4" and "2019.11.4-2019.11.8"; the "affairs' account is corresponding to two items of" meeting "and" before sale ".
It should be noted that there may be more information of the parsing object in the first data source, for example, the content item having "remark" in table 2 is not in the table template; or there is more or less data information of the same parsing object in the table template than the required content item, and there may or may not be data in the column of the same content item, and no limitation is made to the first data source in any form.
204. The first content value is populated into a dynamic row in the form template.
After obtaining the first content value corresponding to the content item of the parsing object in the table template in step 203, the first content value needs to be filled into a dynamic row in the table template, so as to clarify the position of the first content value in the table template. The dynamic row is a row in the table template that originally has no specific corresponding data, that is, as shown in the second row in table 1 in step 201, the data of the row is the first content value obtained by analyzing the analysis object in the first data source.
The dynamic row in the embodiment of the present application specifically refers to a row below a header row of a table template, and it is generally customary to locate the dynamic row below the header row, and the first content value of the dynamic row and the content item corresponding to the header row are located in the same column of the table template. When the first content value read in step 203 is filled into the table template, the number of rows of the table template is not enough, and the number of rows is automatically added, and the number of rows has the same number of columns as the number of head rows. When multiple rows of first content values exist in the table template and the first content values contain data with time and date, the first content values can be sorted according to the sequence of the data with the time and date.
As in table 3 below:
| stroke control | Date | Affair principles |
| Shenzhen-Beijing | 2019.11.1—2019.11.4 | Conference for meeting |
| Beijing-Wuhan Dynasty | 2019.11.4—2019.11.8 | Before sale |
TABLE 3
205. A row of table rows is added below the dynamic rows of the table template.
The dynamic rows in step 204 are used to hold the first content value, and a table row is added below the dynamic rows of the table template, and a table row can be added below each dynamic row to create a container for holding the second content value in the subsequent step. For example, to add a row of table behavior just under the first row of dynamic rows, as shown in table 4 below:
| stroke control | Date | Affair principles |
| Shenzhen-Beijing | 2019.11.1—2019.11.4 | Conference for meeting |
| Beijing-Wuhan Dynasty | 2019.11.4—2019.11.8 | Before sale |
TABLE 4
206. And merging the cells corresponding to the header content items in the table rows to obtain the expanded rows.
After adding a row of table rows below the dynamic row of the table template in step 204, the table rows may be further merged, that is, the cells in the table rows corresponding to the header content item of the table template are merged to obtain an expanded row of a single cell. For example, the table rows added to table 4 are merged as shown in table 5 below:
TABLE 5
207. In the first content value, an associated content value associated with the second data source is determined.
After reading the first content value in step 203, the first content value of one or more items may be determined as an associated content value related to the second data source, the related content value being a basis for reading data in the second data source next. For example, in Table 3 of step 203, it is determined that the first content value "Shenzhen-Beijing" corresponding to the tour content item is the associated content value associated with the second data source.
208. And reading a second content value of the analysis object corresponding to the associated content value in a second data source.
After determining the associated content value of the table template in step 205, in order to parse out the second content value corresponding to the associated content value, the second content value is located in the preset second data source, and at this time, the second content value corresponding to the associated content value needs to be read in the preset second data source. The second data source is typically a table pre-stored with second content values associated with the content values. For example, the associated content value of the parsing object "zhang san" is "shenzhen-beijing", and the second content value pre-stored in the table of the second data source is as follows in table 6:
| name (I) | Stroke control | Expense item | Amount of money | Remarks for note | Reference standard | …… |
| Zhang three | Shenzhen-Beijing | Accommodation device | 600 | …… | …… | |
| Zhang three | Shenzhen-Beijing | Food and |
500 | Hospitality (sic) | …… | …… |
| Zhang three | Shenzhen-Beijing | Taxi | 100 | …… | …… | |
| Zhang three | Shenzhen-Beijing | Aircraft with a flight control device | 2000 | …… | …… |
TABLE 6
The contents of table 4 of the second data source will be described first, where the first row in table 6 is the header row, the header row indicates the common attribute of the column where the table is located, and "… …" in the table indicates that data exists here, but the data is not the important point to express in table 2, and the absence of data in a cell in the table indicates that the data corresponding to the cell is absent. According to the pre-stored data of the second data source, the second content value corresponding to the analysis object and the associated content value read in this step is the second content value read in "zhang san" and "shenzhen-beijing", and the second content value is: the 'expense items' correspond to four items 'lodging', 'dining', 'taxi', and 'plane'; "amount" corresponds to four items "600", "500", "100", and "2000"; the remarks correspond to a waiting; the reference standard corresponds to four items, "… …" and so on.
It should be noted that there may be more information of the parsing object in the second data source, or there may be more or less data information of the same parsing object in the table template than the required content item, and there may be data in the column of the same content item, or there may not be data, such as the column "remarked" in the example table of the second data source in this step, and the second data source is not limited in any way. In addition, in this step, reading may be performed with respect to the analysis object and the specified content item of the related content, and it is not necessary to read all the related content, so as to increase the reading speed.
209. And creating a sub-table, wherein the head row of the sub-table records the content item corresponding to the second content value.
In order to accommodate the second content value, the second content value may be accommodated by creating a sub-table, and a header row of the sub-table may be provided with a content item for recording the second content value, so as to clarify the type of the second content value, facilitate the classification management filling of the second content value, or not only have the content item corresponding to the second content value. In practical application, the sub-table can also be used as a form of a sub-table template, and the sub-table template is not required to be created after the second content value is read, and is directly called. It should be noted that the sub-table may also have a dynamic row and an expansion row, and is used according to an actual situation, and is not limited herein.
210. The second content value is filled into the sub-table.
After obtaining the sub-table in step 209 and obtaining the second content value in step 208, the second content value may be correspondingly filled into the sub-table, that is, according to the content item of the header row of the sub-table, the dynamic row below the content item is correspondingly filled with the second content value. If there is a header row content item with no corresponding second content value, the filling of the second content value is abandoned, for example, if the second content value read in step 208 has a second content value corresponding to the content item of "reference standard", and there is no header row content item corresponding to the "reference standard" in the sub-table, the filling of the second content value corresponding to the content item of "reference standard" in the sub-table is abandoned. If multiple lines of second content values exist in the sub-table, the second content values can be sequentially filled in the sub-table according to the generation time sequence of the second content values. For example, according to step 206, if the associated content value of the parsing object "zhang san" is "shenzhen-beijing", "shenzhen-beijing" fills the sub-table with the second content value pre-stored in the table of the second data source, as shown in table 7:
| expense item | Amount of money | Remarks for note |
| Accommodation device | 600 | |
| Food and |
500 | Hospitality (sic) |
| Taxi | 100 | |
| Aircraft with a flight control device | 2000 |
TABLE 7
It should be noted that, if the second content value read in step 208 is the same as the preset content item of the sub-table, the second content value may be directly filled into the sub-table, so as to reduce the steps of data interaction and improve the efficiency.
211. And filling the sub-tables into the expansion rows to obtain the target table.
And filling the sub-table obtained in the step 210 into the expansion row in the step 206 to obtain the target table after the table template analyzes the specified analysis object. For example, as shown in table 8:
TABLE 8
212. The target table is printed.
After the target form is obtained in step 211, the target form may be printed, that is, table 8 in step 211 is printed, so as to obtain a paper-based target form.
In the embodiment of the application, an expansion row exists in the form template, the expansion row can be used for analyzing data in a second data source, the data in the second data source can be displayed in the expansion row in a sub-form mode, the data in different data sources can be displayed in the same form template in a comprehensive mode, and the problems that joint processing of different data sources on the same form template cannot be achieved, and the data display effects on a plurality of form templates are not convenient for operators to view in a unified mode are solved.
The data integration method in the embodiment of the present application is described above, and the data integration apparatus in the present application is described below with reference to fig. 3, where an embodiment of the data integration apparatus in the present application includes:
an obtaining unit 301, configured to obtain a table template, where a table head row of the table template records one or more content items;
a first determining unit 302, configured to determine an analysis object corresponding to the form template;
a first reading unit 303, configured to read, in a first data source, a first content value of the parsing object corresponding to the content item;
a first filling unit 304, configured to fill the first content value into a dynamic row in the table template;
a second determining unit 305, configured to determine, among the first content values, an associated content value related to a second data source;
a second reading unit 306, configured to read, in the second data source, a second content value corresponding to the analysis object and the associated content value;
a second filling unit 307, configured to fill the second content value into the expansion row in the table template to obtain a target table.
In the embodiment of the present application, the operations performed by the data integration apparatus are similar to those performed in fig. 1, and are not described herein again.
In the embodiment of the application, the form template has an expansion row which can be used for analyzing data in a second data source, so that the data in different data sources are integrated in the same form template to be displayed, and the problems that joint processing of different data sources on the same form template cannot be realized, and the data presentation effects on a plurality of form templates are inconvenient for operators to view in a unified manner are solved.
Referring to fig. 4, another embodiment of the data integration apparatus of the present application includes:
an obtaining unit 401, configured to obtain a table template, where a table head row of the table template records one or more content items;
a first determining unit 402, configured to determine an analysis object corresponding to the form template;
a first reading unit 403, configured to read, in a first data source, a first content value of the analysis object corresponding to the content item;
a first filling unit 404, configured to fill the first content value into a dynamic row in the table template;
a second determining unit 405, configured to determine, from the first content values, an associated content value related to a second data source;
a second reading unit 406, configured to read, in the second data source, a second content value corresponding to the association content value of the analysis object;
a second filling unit 407, configured to fill the second content value into an expansion row in the table template to obtain a target table.
Optionally, the dynamic row of the data integration apparatus is located below the header row, and the content items corresponding to the first content value of the dynamic row and the header row are located in the same column of the table template.
Optionally, the data integration apparatus further includes:
an adding unit 408, configured to add a row of table rows below the dynamic row of the table template;
a merging unit 409, configured to merge cells in the table row corresponding to the header content item to obtain an expanded row.
Optionally, when the second filling unit 407 fills the second content value into the expansion row in the table template to obtain the target table, the second filling unit is specifically configured to:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
populating the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, when the second filling unit 407 fills the second content value into the sub-table, it is specifically configured to:
and filling the sub-table according to the generation time sequence rule of the second content value.
Optionally, the data integration apparatus further includes:
a printing unit 410 for printing the target table.
In the embodiment of the present application, the operations performed by the data integration apparatus are similar to those performed in fig. 2, and are not described herein again.
In the embodiment of the application, an expansion row exists in the form template, the expansion row can be used for analyzing data in a second data source, the data in the second data source can be displayed in the expansion row in a sub-form mode, the data in different data sources can be displayed in the same form template in a comprehensive mode, and the problems that joint processing of different data sources on the same form template cannot be achieved, and the data display effects on a plurality of form templates are not convenient for operators to view in a unified mode are solved.
Another embodiment of the data integration apparatus is described below with reference to fig. 5, which specifically includes:
the data integration apparatus 500 may include one or more Central Processing Units (CPUs) 501 and a memory 505, where one or more applications or data are stored in the memory 505. Memory 505 may be volatile storage or persistent storage, among others. The program stored in memory 505 may include one or more modules, each of which may include a series of instructions operating on a data manipulation device. Further, the central processor 501 may be configured to communicate with the memory 505 to execute a series of instruction operations in the memory 505 on the data integration apparatus 500. The data integration apparatus 500 may also include one or more power supplies 502, one or more wired or wireless network interfaces 503, one or more input-output interfaces 504, and/or one or more operating systems, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. The central processing unit 501 may perform the operations performed in the embodiments shown in fig. 1 to fig. 2, and details thereof are not repeated herein.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and various other media capable of storing program codes.
Claims (10)
1. A method for data integration, comprising:
acquiring a table template, wherein a table head row of the table template records one or more content items;
determining an analysis object corresponding to the form template;
reading a first content value of the analysis object corresponding to the content item in a first data source;
populating dynamic rows in the table template with the first content values;
determining, in the first content value, an associated content value related to a second data source;
reading a second content value corresponding to the analysis object and the associated content value in the second data source;
and filling the second content value into an expansion row in the form template to obtain a target form.
2. The data integration method of claim 1, wherein the dynamic row is located below the header row, and the content item of the first content value of the dynamic row and the content item corresponding to the header row are located in a same column of the table template.
3. The data integration method of claim 1, wherein before populating the second content value into an expansion row in the form template to obtain a target form, the method further comprises:
adding a row of table rows below the dynamic rows of the table template;
and merging the cells corresponding to the header content items in the table rows to obtain expanded rows.
4. The data integration method of claim 3, wherein populating the second content value into an expansion row in the form template to obtain a target form, comprises:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
populating the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
5. The data integration method of claim 4, wherein the populating the sub-table with the second content value comprises:
and filling the sub-table according to the generation time sequence rule of the second content value.
6. The data integration method according to any one of claims 1 to 5, further comprising, after the obtaining of the target table:
printing the target form.
7. A data aggregation apparatus, comprising:
the acquisition unit is used for acquiring a table template, wherein a table head row of the table template records one or more content items;
the first determining unit is used for determining an analysis object corresponding to the form template;
a first reading unit, configured to read, in a first data source, a first content value of the analysis object corresponding to the content item;
a first filling unit, configured to fill the first content value into a dynamic row in the table template;
a second determining unit, configured to determine, among the first content values, an associated content value related to a second data source;
a second reading unit, configured to read, in the second data source, a second content value corresponding to the association content value of the analysis object;
and the second filling unit is used for filling the second content value into the expansion row in the form template to obtain the target form.
8. A data aggregation apparatus, comprising:
the system comprises a processor, a memory, a bus and input and output equipment;
the processor is connected with the memory and the input and output equipment;
the bus is respectively connected with the processor, the memory and the input and output equipment;
the processor performs the method of any one of claims 1 to 6.
9. A computer storage medium having stored therein instructions that, when executed on a computer, cause the computer to perform the method of any one of claims 1 to 6.
10. A computer program product, characterized in that the computer program product, when executed on a computer, causes the computer to perform the method according to any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911320767.1A CN111104784B (en) | 2019-12-19 | 2019-12-19 | Data integration method and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911320767.1A CN111104784B (en) | 2019-12-19 | 2019-12-19 | Data integration method and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111104784A true CN111104784A (en) | 2020-05-05 |
| CN111104784B CN111104784B (en) | 2024-03-12 |
Family
ID=70423053
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911320767.1A Active CN111104784B (en) | 2019-12-19 | 2019-12-19 | Data integration method and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111104784B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050050088A1 (en) * | 2000-06-21 | 2005-03-03 | Microsoft Corporation | System and method for integrating spreadsheets and word processing tables |
| CN106897389A (en) * | 2017-01-24 | 2017-06-27 | 深圳市评估王信息科技有限公司 | Generate the device and method of report |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN108804401A (en) * | 2018-06-14 | 2018-11-13 | 南京云帐房网络科技有限公司 | A kind of merging method and device of report form template |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN110427604A (en) * | 2019-08-15 | 2019-11-08 | 北京明略软件系统有限公司 | Table integration method and device |
-
2019
- 2019-12-19 CN CN201911320767.1A patent/CN111104784B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050050088A1 (en) * | 2000-06-21 | 2005-03-03 | Microsoft Corporation | System and method for integrating spreadsheets and word processing tables |
| CN106897389A (en) * | 2017-01-24 | 2017-06-27 | 深圳市评估王信息科技有限公司 | Generate the device and method of report |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN108804401A (en) * | 2018-06-14 | 2018-11-13 | 南京云帐房网络科技有限公司 | A kind of merging method and device of report form template |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN110427604A (en) * | 2019-08-15 | 2019-11-08 | 北京明略软件系统有限公司 | Table integration method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111104784B (en) | 2024-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10789231B2 (en) | Spatial indexing for distributed storage using local indexes | |
| CN106469140A (en) | A kind of report generating system and its method | |
| CN111538774B (en) | Data storage and display method, system, equipment and storage medium | |
| US11238215B2 (en) | Systems and methods for generating social assets from electronic publications | |
| CN110427604B (en) | Form integration method and device | |
| CN108280056A (en) | A kind of Excel file analytic method | |
| US9773061B2 (en) | Data distributed search system, data distributed search method, and management computer | |
| CN110869924A (en) | Method and apparatus for generating a customized digital file having variable data | |
| CN112286907A (en) | Database configuration method and device, electronic equipment and readable storage medium | |
| CN106156075B (en) | A kind of method and device of report generation and displaying | |
| US20150206098A1 (en) | System and method of loading plant species for transportation | |
| US11531706B2 (en) | Graph search using index vertices | |
| CN111104784A (en) | Data integration method and related device | |
| US20190340179A1 (en) | Result set output criteria | |
| EP3633514B1 (en) | Data exchange system, data exchange method, and data exchange program | |
| CN102681883B (en) | Resource calling method and system in media asset searching and browsing system | |
| CN113742529A (en) | Multi-table front-end processing method and device | |
| CN114003661A (en) | Offline data entry method and device, electronic equipment and storage medium | |
| US9898493B2 (en) | Runtime generation of a mapping table for uploading data into structured data marts | |
| CN112632266B (en) | Data writing method and device, computer equipment and readable storage medium | |
| CN114169306A (en) | Method, device and equipment for generating electronic receipt and readable storage medium | |
| US20230067107A1 (en) | Managing vertex level access in a graph via user defined tag rules | |
| US11615237B2 (en) | Processing method for presenting indicator hierarchy and classification of data in spreadsheet | |
| CN114416238B (en) | Intelligent configuration method for instrument panel based on dynamic layout technology | |
| CN111368113B (en) | Commodity data display method, system, medium and 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |