CN111104784B - Data integration method and related device - Google Patents
Data integration method and related device Download PDFInfo
- Publication number
- CN111104784B CN111104784B CN201911320767.1A CN201911320767A CN111104784B CN 111104784 B CN111104784 B CN 111104784B CN 201911320767 A CN201911320767 A CN 201911320767A CN 111104784 B CN111104784 B CN 111104784B
- Authority
- CN
- China
- Prior art keywords
- content value
- row
- template
- content
- 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.)
- Active
Links
- 230000010354 integration Effects 0.000 title claims abstract description 40
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000000694 effects Effects 0.000 abstract description 9
- 230000008569 process Effects 0.000 description 4
- 230000004308 accommodation Effects 0.000 description 3
- 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
- 238000004891 communication Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 1
- 230000002650 habitual effect 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
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 problem that the unified processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates can be inconvenient for operators to uniformly check. The method comprises the following steps: the method comprises the steps of obtaining a table template, recording one or more content items in a table head row of the table template, determining an analysis object corresponding to the table template, reading a first content value corresponding to the content items of the analysis object 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 corresponding to the analysis object and the associated content value in the second data source, filling the second content value into an expansion row in the table template, and obtaining 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 enterprise application systems to process various enterprise business data, and different form templates of existing enterprise application systems are associated with different data sources, i.e. the different data sources are in one-to-one correspondence with the different form templates, and the different form templates analyze the different data sources independently of each other in the application.
When processing data of different data sources on a form template, in real application, an enterprise application device can only process the data of different data sources on different form templates respectively, and cannot realize joint processing of different data sources on the same form template, so that the data presentation effect on a plurality of form templates may be inconvenient for operators to uniformly check.
Disclosure of Invention
The embodiment of the application provides a data integration method and a related device, which are used for solving the problem that the unified processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates can be inconvenient for operators to uniformly view.
A first aspect of the present application provides a data integration method, including:
obtaining a table template, wherein a header 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;
filling the first content value into a dynamic row in the form template;
determining, among the first content values, an associated content value that relates 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 filling the second content value into the expansion row in the table template to obtain the target table, the method further includes:
adding a row of table rows below the dynamic row of the table template;
and merging the cells corresponding to the header content items in the table row to obtain an expansion row.
Optionally, 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;
filling the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, the filling the second content value into the sub-table includes:
and filling the secondary table into the secondary table according to the generation time sequence law of the second content value.
Optionally, after the obtaining the target table, the method further includes:
and printing the target table.
A second aspect of the present application provides a data integration apparatus, including:
an obtaining unit, configured to obtain a table template, where a header 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 corresponding to the content item by the parsing object;
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 parsing object and the associated content value;
and the second filling unit is used for filling the second content value into the expansion row in the form template to obtain a target form.
Optionally, the dynamic row of the data integration device 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, the data integration device further includes:
an adding unit, configured to add a row of table rows below the dynamic row of the table template;
and the merging unit is used for merging the cells corresponding to the header content items in the table row to obtain an expansion row.
Optionally, the second filling unit is specifically configured to, when filling the second content value into the expansion row in the table template to obtain the target table:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
filling the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, the second filling unit is specifically configured to, when the second content value is filled into the sub-table:
and filling the secondary table into the secondary table according to the generation time sequence law of the second content value.
Optionally, the data integration device 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, including:
a processor, a memory, a bus, and an input/output device;
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 instructions stored therein, which 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, characterized in that the computer program product, when executed on a computer, causes the computer to perform the method according to any of the preceding first aspects.
From the above technical solutions, the embodiments of the present application have the following advantages:
according to the method and the device for processing the data in the form template, the expansion line can be added in the form template, the expansion line can be used for analyzing the data in the second data source, the data in different data sources are comprehensively displayed in the same form template, and the problem that joint processing of different data sources on the same form template cannot be achieved, and the data display effect on a plurality of form templates can be inconvenient for operators to uniformly view is solved.
Drawings
FIG. 1 is a schematic flow chart of a data integration method according to an embodiment of the present application;
FIG. 2 is a schematic flow chart of a data integration method according to an embodiment of the present disclosure;
FIG. 3 is a schematic diagram of a data integration device according to an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of another structure of the data integration device according to the embodiment of the disclosure;
fig. 5 is another schematic structural diagram of the data integration device in the embodiment of the application.
Detailed Description
The embodiment of the application provides a data integration method and a related device, which are used for solving the problem that the unified processing of different data sources on the same form template cannot be realized, and the data presentation effect on a plurality of form templates can be inconvenient for operators to uniformly view.
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 table template described in this embodiment of the present application is a table with a limited number of rows and columns, and the table header of the table template records one or more content items, i.e. for example, each column unit 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.
102. And determining an analysis object corresponding to the form template.
After the table template is obtained in step 101, the parsing object of the table template needs to be determined, and the process of determining the parsing object of the table template in this step may be to receive the parsing object input by the user or to receive a specified parsing object.
103. In the first data source, a first content value of the parsing object corresponding to the content item is read.
After determining the parsing object of the table template in step 102, in order to parse the first content value of the parsing object corresponding to the content item in the table template, the first content value is located in a 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 typically a table in which a first content value of an analysis object is pre-stored in advance.
104. The first content value is filled 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 determine the position of the first content value in the table template. The dynamic row refers to a row without 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 the first data source.
105. In the first content value, an associated content value is determined that relates to the second data source.
After the first content value is read in step 103, the first content value of the one or more items may be determined as an associated content value related to the second data source, the associated content value being a basis for a subsequent reading of data in the second data source.
106. In the second data source, a second content value of the parsing object corresponding to the associated content value is read.
After determining the associated content value of the table template in step 105, in order to parse the second content value corresponding to the associated content value, the second content value is located in a preset second data source, where 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 of second content values pre-stored with 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 line of the table template, so as to determine the position of the second content value in the table template. The expansion line refers to a line which is used for accommodating a second content value corresponding to the associated content value in the table template, and is added when the second content value needs to be filled in, and the data of the line is the second content value obtained by analyzing the associated content value in the second data source.
In the embodiment of the application, the expansion line exists in the form template, and can be used for analyzing the data in the second data source, so that the data in different data sources are comprehensively displayed in the same form template, and the problem that joint processing of different data sources on the same form template cannot be realized, and the data display effect on a plurality of form templates may be inconvenient for operators to uniformly view is solved.
Referring to fig. 2, another embodiment of the data integration method of the present application includes:
201. a table template is obtained, wherein a header row of the table template records one or more content items.
Specifically, the form template in the embodiment of the present application is a form with a limited number of rows and columns, where the number of rows and columns of the form is determined according to the actual situation, and the present invention is not limited thereto. The header of the table template records one or more content items, i.e. for example one content item per column unit in a first row of the table template, which may have a plurality of columns of existing content items. The content items in the embodiments of the present application are set in advance according to different requirements, and generally are not modified when the form template is used. The content items of the header rows of the form template may be modified and supplemented appropriately according to actual needs, and are not limited herein. For example: the first row of the form template has three columns written "travel", "date", "cause", respectively, as shown in Table 1 below:
| travel distance | Date of day | By reason of |
TABLE 1
202. And determining an analysis object corresponding to the form template.
After the table template is obtained in step 201, an analysis object of the table needs to be determined, and the process of determining the analysis object of the table template in this step may be to receive the analysis object input by the user or to receive a specified analysis object. It should be noted that the parsing object should be a parsing object that has a first content value pre-stored in the first data source. For example, it is determined that the parsing object corresponding to the table template is "Zhang Sano" or "Liqu", etc., and the first content value should be stored in the first data source.
203. In the first data source, a first content value of the parsing object corresponding to the 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 a 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 typically a table in which a first content value of an analysis object is pre-stored in advance. For example, "Zhang Sano" and "Lifour" have first content values pre-stored in a table of first data sources as follows Table 2:
| name of name | Travel distance | Date of day | By reason of | Remarks | …… |
| Zhang San | Shenzhen-Beijing | 2019.11.1—2019.11.4 | Meeting at meeting | …… | …… |
| Zhang San | Beijing-Wuhan | 2019.11.4—2019.11.8 | Before sale | …… | …… |
| Li Si | Shenzhen-Beijing | 2019.11.1—2019.11.4 | …… | …… | |
| Li Si | Beijing-Wuhan | 2019.11.4—2019.11.8 | Before sale | …… | …… |
TABLE 2
First, the contents of table 2 of the first data source are described, in table 2, the first row is a header row, the header row indicates a common attribute of a column where the table is located, in the table, "… …" indicates that there is data here, but what is specifically the data here is not the key point to be expressed in table 2, and the absence of data in a cell in the table indicates that there is no data corresponding to the cell. According to the pre-stored data of the first data source, if the analysis object determined in step 202 is "Zhang san", and the header line content items in the table template are "travel", "date", "event", the first content value in this step corresponds to: the stroke corresponds to two terms of 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 "event" corresponds to two items, "meeting" and "before sale".
It should be noted that, more information of the parsing object may also exist in the first data source, for example, the content items such as "remarks" in table 2 are not included in the form template; or there is more or less data information of the same parsing object than the desired content item in the form template, 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 way.
204. The first content value is filled 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 determine the position of the first content value in the table template. The dynamic row refers to a row in the table template, which has no specific corresponding data, i.e. the data of the row is the first content value obtained by analyzing the analysis object in the first data source, as shown in the second row of table 1 in step 201.
In this embodiment of the present application, the dynamic row specifically refers to a row under a header row of a table template, where the dynamic row is generally located under the header row in a habitual manner, 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 column number as the head row. When a plurality of rows of first content values exist in the form template and the first content values contain time and date data, the first content values can be ordered according to the sequence of the time and date data.
Table 3 below:
| travel distance | Date of day | By reason of |
| Shenzhen-Beijing | 2019.11.1—2019.11.4 | Meeting at meeting |
| Beijing-Wuhan | 2019.11.4—2019.11.8 | Before sale |
TABLE 3 Table 3
205. A row of table rows is added below the dynamic row of the table template.
The dynamic row in step 204 is used to hold the first content value, and then a row of table rows needs to be added below the dynamic row of the table template, and a row of table rows can be added below each row of dynamic row to create a container for holding the second content value in the subsequent step. For example, to add a row of table row examples under the first row of dynamic rows only, the following table 4 shows:
| travel distance | Date of day | By reason of |
| Shenzhen-Beijing | 2019.11.1—2019.11.4 | Meeting at meeting |
| Beijing-Wuhan | 2019.11.4—2019.11.8 | Before sale |
TABLE 4 Table 4
206. And merging the cells corresponding to the table head content items in the table row to obtain an expansion row.
After adding a row of table rows below the dynamic row of the table template in step 204, the table rows may be further combined, that is, the cells in the table rows corresponding to the table header content item of the table template are combined, to obtain an extended row of single cells. For example, the added table rows of table 4 are combined as shown in table 5 below:
TABLE 5
207. In the first content value, an associated content value is determined that relates to the second data source.
After the first content value is read in step 203, the first content value of the one or more items may be determined as an associated content value related to the second data source, the associated content value being the basis for the next reading of data in the second data source. For example, in table 3 of step 203, it is determined that the first content value "Shenzhen-Beijing" corresponding to the travel content item is the associated content value related to the second data source.
208. In the second data source, a second content value of the parsing object corresponding to the associated content value is read.
After determining the associated content value of the table template in step 205, in order to parse the second content value corresponding to the associated content value, the second content value is located in the preset second data source, where 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 of second content values pre-stored with associated content values. For example, the associated content value of the analysis object "Zhang three" is "Shenzhen-Beijing", and the second content value of "Shenzhen-Beijing" is pre-stored in the table of the second data source is as follows in table 6:
| name of name | Travel distance | Fee item | Amount of money | Remarks | Reference standard | …… |
| Zhang San | Shenzhen-Beijing | Accommodation for living in | 600 | …… | …… | |
| Zhang San | Shenzhen-Beijing | Dining and dining | 500 | Hospitality | …… | …… |
| Zhang San | Shenzhen-Beijing | Taxi | 100 | …… | …… | |
| Zhang San | Shenzhen-Beijing | Aircraft | 2000 | …… | …… |
TABLE 6
First, the contents of table 4 of the second data source are described, the first row in table 6 is a header row, the header row indicates the common attribute of the columns where the table is located, and "… …" in the table indicates that there is data here, but what is specifically the data here is not the key point to be expressed in table 2, and the absence of data in a cell in the table indicates that there is no data corresponding to the cell. 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 the step is the second content value of reading Zhangsan and Shenzhen-Beijing, and the second content value is: the "expense items" correspond to four items, "accommodation," "dining," "taxi," and "airplane"; the "amount" corresponds to four items "600", "500", "100", and "2000"; the remark corresponds to a term of "hospitality"; the reference standard corresponds to four terms "… …", respectively, 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 or may not be data in a column of the same content item, such as a column "remarked" in the example table of the second data source in this step, where the second data source is not limited in any way. In addition, in this step, the specified content item of the analysis object and the associated content may be read, and it is not necessary to read all the associated content, so as to increase the reading speed.
209. Creating a sub-table, wherein the table 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, where a header row of the sub-table may be provided with a content item corresponding to the second content value, so as to determine a type of the second content value, facilitate classification management and filling of the second content value, or may 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 sub-table template, and the sub-table template is not required to be created after the second content value is read, and can be directly called. It should be noted that the sub-table may also have dynamic rows and expanded rows, and is not limited herein according to actual use.
210. And filling the second content value 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, i.e. according to the content item of the header row of the sub-table, the dynamic row under the content item is correspondingly filled with the second content value. If there is no corresponding header line content item in the second content value, the second content value is discarded, for example, the second content value read in step 208 has the second content value corresponding to the "reference standard" content item, and the sub-table has no header line content item corresponding to the "reference standard", and the second content value corresponding to the "reference standard" content item is discarded. If a plurality of rows of second content values exist in the sub-table, the second content values can be sequentially ordered and filled into the sub-table according to the generation time sequence rule of the second content values. For example, in step 206, if the associated content value of the parsing object "Zhangsan" is "Shenzhen-Beijing", the second content value of the "Shenzhen-Beijing" pre-stored in the table of the second data source is filled into the sub-table, as shown in Table 7:
| fee item | Amount of money | Remarks |
| Accommodation for living in | 600 | |
| Dining and dining | 500 | Hospitality |
| Taxi | 100 | |
| Aircraft | 2000 |
TABLE 7
It should be noted that, if the second content value read in step 208 is the same as the 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-table into the expansion row to obtain the target table.
Filling the sub-table obtained in the step 210 into the expansion line in the step 206, so as to obtain the target table after the table template resolves the specified resolution 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, to obtain a paper version of the target form.
In the embodiment of the application, the expansion line exists in the form template, the expansion line can be used for analyzing the data in the second data source, the data of the second data source can be displayed in the expansion line in the form of a sub-form, the data in different data sources are comprehensively displayed in the same form template, and the problem that the joint processing of different data sources on the same form template cannot be realized, and the data display effect on a plurality of form templates can be inconvenient for operators to uniformly view is solved.
The data integration method of the embodiment of the present application is described above, and the data integration device of the present application is described below, referring to fig. 3, where an embodiment of the data integration device of the present application includes:
an obtaining unit 301, configured to obtain a table template, where a header 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 table template;
a first reading unit 303, configured to read, in a first data source, a first content value corresponding to the content item by the parsing object;
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 for determining an associated content value related to a second data source among the first content values;
a second reading unit 306, configured to read, in the second data source, a second content value corresponding to the parsing object and the associated content value;
and a second filling unit 307, configured to fill the second content value into an expansion row in the table template, so as to obtain a target table.
In this embodiment, the operations performed by the data integration device are similar to those performed in fig. 1, and are not described herein.
In the embodiment of the application, the expansion line exists in the form template, and can be used for analyzing the data in the second data source, so that the data in different data sources are comprehensively displayed in the same form template, and the problem that joint processing of different data sources on the same form template cannot be realized, and the data display effect on a plurality of form templates may be inconvenient for operators to uniformly view is 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 header 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 table template;
a first reading unit 403, configured to read, in a first data source, a first content value corresponding to the content item by the parsing object;
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, among 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 parsing object and the associated content value;
and a second filling unit 407, configured to fill the second content value into the expansion row in the table template to obtain a target table.
Optionally, the dynamic row of the data integration device 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, the data integration device further includes:
an adding unit 408, configured to add a row of table rows below the dynamic row of the table template;
and a merging unit 409, configured to merge cells corresponding to the header content item in the table row, to obtain an extended row.
Optionally, the second filling unit 407 is specifically configured to, when filling the second content value into the expansion line in the table template to obtain the target table:
creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value;
filling the second content value into the sub-table;
and filling the sub-table into the expansion row to obtain a target table.
Optionally, the second filling unit 407 is specifically configured to, when said filling the second content value into the sub-table:
and filling the secondary table into the secondary table according to the generation time sequence law of the second content value.
Optionally, the data integration device further includes:
and a printing unit 410 for printing the target form.
In this embodiment, the operations performed by the data integration device are similar to those performed in fig. 2, and are not described herein.
In the embodiment of the application, the expansion line exists in the form template, the expansion line can be used for analyzing the data in the second data source, the data of the second data source can be displayed in the expansion line in the form of a sub-form, the data in different data sources are comprehensively displayed in the same form template, and the problem that the joint processing of different data sources on the same form template cannot be realized, and the data display effect on a plurality of form templates can be inconvenient for operators to uniformly view is solved.
Another embodiment of the data integration device is described below with reference to fig. 5, which specifically includes:
the data integration apparatus 500 may include one or more central processing units (central processing units, CPU) 501 and a memory 505, where the memory 505 stores one or more application programs or data. Wherein the memory 505 may be volatile storage or persistent storage. The program stored in the memory 505 may include one or more modules, each of which may include a series of instruction operations in the data integration apparatus. Still further, the central processor 501 may be configured to communicate with the memory 505 and execute a series of instruction operations in the memory 505 on the data integration apparatus 500. The data integration device 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 cpu 501 may perform the operations performed in the embodiments shown in fig. 1 to 2, and will not be described herein.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in 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, random access memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Claims (8)
1. A method of data integration, comprising:
obtaining a table template, wherein a header 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;
filling the first content value into a dynamic row in the form template;
determining, among the first content values, an associated content value that relates to a second data source; the second data source and the first data source are different data sources;
reading a second content value corresponding to the analysis object and the associated content value in the second data source;
filling the second content value into an expansion row in the form template to obtain a target form; the expanding row refers to a row which is used for accommodating the second content value corresponding to the associated content value in the table template, and is added when the second content value needs to be filled in;
filling the second content value into an expansion row in the form template to obtain a target form, wherein the method comprises the following steps: creating a sub-table, wherein a table head row of the sub-table records a content item corresponding to the second content value; filling the second content value into the sub-table; and filling the sub-table into the expansion row to obtain a target table.
2. The data integration method of claim 1, wherein the dynamic row is located below the header row and the first content value of the dynamic row is located in the same column of the table template as the content item corresponding to the header row.
3. The data integration method of claim 1, wherein before filling the second content value into the expanded row in the form template to obtain the target form, the method further comprises:
adding a row of table rows below the dynamic row of the table template;
and merging the cells corresponding to the table head row content items in the table row to obtain an expansion row.
4. The data integration method of claim 1, wherein the populating the second content value into the sub-table comprises:
and filling the secondary table into the secondary table according to the generation time sequence law of the second content value.
5. The data integration method according to any one of claims 1 to 4, further comprising, after the obtaining the target table:
and printing the target table.
6. A data integration apparatus, comprising:
an obtaining unit, configured to obtain a table template, where a header 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 corresponding to the content item by the parsing object;
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; the second data source and the first data source are different data sources;
a second reading unit, configured to read, in the second data source, a second content value corresponding to the parsing object and the associated content value;
the second filling unit is used for filling the second content value into the expansion row in the form template to obtain a target form; the expanding row refers to a row which is used for accommodating the second content value corresponding to the associated content value in the table template, and is added when the second content value needs to be filled in;
the second filling unit is specifically configured to create a sub-table, where a header row of the sub-table records a content item corresponding to the second content value; filling the second content value into the sub-table; and filling the sub-table into the expansion row to obtain a target table.
7. A data integration apparatus, comprising:
a processor, a memory, a bus, and an input/output device;
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 5.
8. A computer storage medium having instructions stored therein, which when executed on a computer, cause the computer to perform the method of any of claims 1 to 5.
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 CN111104784A (en) | 2020-05-05 |
| CN111104784B true 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 (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2001264895A1 (en) * | 2000-06-21 | 2002-01-02 | Microsoft Corporation | System and method for integrating spreadsheets and word processing tables |
-
2019
- 2019-12-19 CN CN201911320767.1A patent/CN111104784B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
|---|---|
| CN111104784A (en) | 2020-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104536965B (en) | A kind of data query display systems under the conditions of big data and method | |
| CN106933836B (en) | Data storage method and system based on sub-tables | |
| CN107977396B (en) | Method and device for updating data table of KeyValue database | |
| CN110427604B (en) | Form integration method and device | |
| CN105260404A (en) | Time sequence data storage method and apparatus | |
| CN105550270B (en) | Data base query method and device | |
| CN107436872A (en) | A kind of processing method and processing device of isomeric data | |
| CN107391057A (en) | A kind of billing information management method, device and equipment | |
| US20220374406A1 (en) | KV Database Configuration Method, Query Method, Device, and Storage Medium | |
| CN112286907A (en) | Database configuration method and device, electronic equipment and readable storage medium | |
| CN111090803A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN111104784B (en) | Data integration method and related device | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| US20110246455A1 (en) | Data search device, data search method, and recording medium | |
| CN103593922A (en) | Method and system for improving invoice printing speed of network invoicing system client | |
| CN110597789B (en) | Automatic generation method, device and equipment of architecture diagram and computer readable storage medium | |
| US20190340179A1 (en) | Result set output criteria | |
| CN110019229B (en) | Database configuration system | |
| CN106845787A (en) | A kind of data method for automatically exchanging and device | |
| CN115409014A (en) | Document template generation method and device, computer equipment and storage medium | |
| CN102681883B (en) | Resource calling method and system in media asset searching and browsing system | |
| CN110781191B (en) | Processing method of layout data and server | |
| CN114169306A (en) | Method, device and equipment for generating electronic receipt and readable storage medium | |
| US20180357297A1 (en) | Rdb system | |
| JP2012141974A (en) | Rendering electronic documents having linked text boxes |
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 |