CN101261641A - Data loading method after filling report forms - Google Patents
Data loading method after filling report forms Download PDFInfo
- Publication number
- CN101261641A CN101261641A CNA2008100890737A CN200810089073A CN101261641A CN 101261641 A CN101261641 A CN 101261641A CN A2008100890737 A CNA2008100890737 A CN A2008100890737A CN 200810089073 A CN200810089073 A CN 200810089073A CN 101261641 A CN101261641 A CN 101261641A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- cell
- attribute
- fill
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a databank loading method used after report filling, in particular to a process method for writing data filled in reports into relational databanks according to a proper rule, belonging to the computer information processing technique field. The method firstly adopts a nonlinear report generation method to design a report template; then datasheets and fields which are needed to be written with the data are defined; secondly, updating property is arranged on the cell-table of the report, and after expanding calculation and filling in are carried out to the report, the data on the report is written into the databank-table after calculation according to the updating property. The databank loading method provided by the invention has the advantages that the databank-tables can be coupled freely and expanded automatically; both data loading and unloading are allowed, the loading and unloading are irrelevant and one loading can be against more unloading, etc.
Description
Technical field
The invention belongs to technical field of computer information processing, relate to a kind of method of data input after report fill-in, be specifically related to a kind of disposal route that can write relational database by rule of reason through the data on the form after filling in.
Background technology
Filling report forms is very common business demand, itself is not purpose yet fill in, and the data of filling in is carried out analysis and utilization be only purpose.Under present technological means, could make things convenient for utilization after generally data need being write the relational database open, that data structure has professional meaning.Therefore, data loading is very important processing links in the filling report forms process.
Traditional solution of filling in generally has following three kinds of mode deal with data warehouse-in:
1. employing intermediate file, the result who fills in is write an intermediate data file (often being exactly directly to use EXCEL to make a report on), some scheme of making a report on generally can provide more a small amount of statistical summaries based on these intermediate files, still must will dump in the relational database after the data structureization but will utilize fully then.And non-structured data are changed into the structural data that can embody business rule is the very work of difficulty, does not have method in common, need write corresponding program for every kind of form and handle.
2. write fixing data structure, the data structure that the scheme of making a report on provides a kind of " omnipotent " writes the data of filling in, its data structure usually is to have only " row number ", " row number ", " numerical value " three fields (or similar), though claiming, this scheme can put in storage automatically, but just physically data have been write database, data structure does not embody business rule fully, the work that still will change once more when using in the future.
3. the data structure that in advance design will be preserved according to business rule, the form that will fill in according to Data Structure Design then, each data that will fill in cell all has the field of unique correspondence database, just can directly be write as structurized data like this when warehouse-in.This warehouse-in mechanism is comparatively reasonable, but form must be according to Data Structure Design, and storehouse table corresponding relation is too simple, causes form freely to draw, and simple several inflexible table samples can only be provided, and is difficult to meet consumers' demand.
The subject matter of above-mentioned these warehouse-in modes is to solve the database table that can embody business rule and the coupling contradiction between the form cell, thereby causes the cooperation difficulty of Report Form Design or data loading.
Summary of the invention
The objective of the invention is to fill in the defective of warehouse-in scheme, the data loading problem after a kind of novel dynamic base table correlating method is handled filling report forms is provided at traditional data.
Technical scheme of the present invention is as follows, and a kind of method of data input after report fill-in comprises the steps:
(1) report form template that adopts the nonlinear report generating method design to fill in;
(2) determine database table data need be write and on field;
(3) in some cell of report form template, the renewal attribute is set;
(4) expansion accounting report upgrades attribute and will be expanded together as the attribute of cell and duplicate, and fills in data then in its cell;
(5) write in the database table after according to upgrading attribute the data computation on the form.
Further, in the method for above-mentioned data input after report fill-in, the nonlinear report generating method in the step (1) comprises the steps:
The data set that need use when (1) determining the form computing, and name respectively;
(2) determine that in static statement some cell is the expansion lattice, promptly initiatively expands the cell that duplicates, and its propagation direction is set;
(3) the left nominative and the last nominative of all cells are set, i.e. the expansion lattice that when vertical and horizontal are expanded, need follow of this cell;
(4) in each cell, insert operation expression.
Further, in the method for above-mentioned data input after report fill-in, database table can be a plurality of in the step (2), from identical or different databases; And the data set that is used to design report form template in these database tables and the step (1) is irrelevant.
Further, in the method for above-mentioned data input after report fill-in, renewal attribute in the step (3) be one by a plurality of updated data tables and more newer field and the array that constitutes of renewal expression formula of correspondence with it, updated data table and more newer field is from established data table in the step (1) and field wherein, upgrading expression formula then is a cell operation expression (often can be the structure that only takes out certain cell value) that meets the nonlinear report generating method rule.
Further, in the method for above-mentioned data input after report fill-in, at each the cell that upgrades attribute is arranged in the step (5), calculate the renewal expression formula that it upgrades the more newer field correspondence on each updated data table in attribute, result of calculation is written in the tables of data as the record that the record value of field forms corresponding updated data table.
Further, in the method for above-mentioned data input after report fill-in, when the record that will calculate in step (5) writes updated data table, if judge that according to primary key former being recorded in the tables of data exists, then generate the UPDATE statement and revise former record, insert a new record otherwise will generate I NSERT statement.
Beneficial effect of the present invention is: make the data input after report fill-in method have following ability:
(1) any coupling, automatic expansion
Renewal attribute in this method can be defined on any cell, and updated data table and field also without any restriction, have been guaranteed the cell of form and any coupling between the database table column like this.Simultaneously, expansion and accounting report time renewal attribute can be duplicated by automatic expansion together in step (4).
(2) have, make a return journey irrelevant, one go more
Data in this method on the form are to be calculated by nonlinear report generating method, thereby have the source; In the step (5) when preserving data and the scale value of being indifferent to cell on the form whether be modified, do not examine or check the computing method (being Data Source) of cell value yet, and can will be saved in a plurality of updated data tables simultaneously with a collection of scale value, thereby accomplish that Data Source and whereabouts are irrelevant, and the many places whereabouts can be arranged.
Description of drawings
Fig. 1 is for adopting the report form template that is used to fill in of nonlinear report generating method design.
Fig. 2 be the report form template of Fig. 1 calculate expansion the result.
Fig. 3 is the result after the form process of Fig. 2 is filled in.
Fig. 4 is the process flow diagram of the method for the invention.
Embodiment
The concrete case that provides below in conjunction with accompanying drawing is described in detail the present invention.
Example: master-slave mode multi-source fill in table design, fill in and the warehouse-in process.
1. the report form template that adopts the nonlinear report generating method design to fill in
The report form template of design as shown in Figure 1.
Wherein C4 and B10 vertically expand lattice, and the left nominative of B4, B6, B7, B8, B9, B10 all is set to C4, thereby form principal and subordinate's form.
The specific implementation of nonlinear report generating method can be referring to Chinese patent application 200710064704.5, and its step that generates form is as follows:
The data set that need use when (1) determining the form computing, and name respectively;
(2) determine that in static statement some cell is the expansion lattice, promptly initiatively expands the cell that duplicates, and its propagation direction is set;
(3) the left nominative and the last nominative of all cells are set, i.e. the expansion lattice that when vertical and horizontal are expanded, need follow of this cell;
(4) in each cell, insert operation expression;
(5) form is expanded and calculated the actual form after obtaining generating.
2. determine database table data need be write and on field
If tables of data that writes and structure thereof are:
Create table " CONTRACT " (---contracts card
" CONTRACTNO " CHAR (20),---contract number
" CUSTOMERID " CHAR (10),---Customer ID
" AMOUNT " DECIMAL (16,2),---the amount of money
" FINISHED " CHAR (1),---whether finish
" PAYAMOUNT " DECIMAL (16,2)---amount of money paid altogether
" PAYMENT " CHAR (1),---Payment Methods
" SIGNDATE " TIMESTAMP,---signing the date
" TRANSPORTDATE " TIMESTAMP,---Shipping Date
" TRANSPORT " CHAR (10),---harbour
" TRANSPORTMETHOD " CHAR (1),---means of transportation
" SALESMAN " CHAR (10),---salesman
)；
The field that needs to upgrade has:
CONTRACTNO，CUSTOMERID，AMOUNT，PAYMENT，SIGNDATE，TRANSPORTDATE，TRANSPORT，TRANSPORTMETHOD，SALESMAN。
Create table " CONTRACTDETAIL " (---contract detail list
" CONTRACTNO " CHAR (20),---contract number
" PRODUCTID " CHAR (10),---product IDs
" AMOUNT " DECIMAL (16,2),---the amount of money
" PRICE " DECIMAL (16,2),---unit price
" QUANTITY " DECIMAL (16),---sales volume
" QUANTITYUNIT " CHAR (10)---unit of quantity
)；
The field that needs to upgrade is:
CONTRACTNO，PRODUCTID，AMOUNT，PRICE，QUANTITY，QUANTITYUNIT。
3. in some cell of report form template, the renewal attribute is set
It is as follows that the renewal attribute is set on C4:
It is as follows that the renewal attribute is set on B10:
4. expansion accounting report upgrades attribute and will be expanded together as the attribute of cell and duplicate, and fills in data then in its cell
Form after the calculating expansion as shown in Figure 2.
For sake of convenience, represent to expand cell on the form of back, the cell before capitalization is then represented to expand on the form with lowercase.Examination has C4 and the renewal attribute change situation of B10 lattice after expansion of upgrading attribute.
The C4 lattice are extended to 1 lattice c4 (promptly in fact keeping intact, not expansion), and its renewal attribute then still is:
B10 lattice expansions lattice 10 lattice: b10, b11 ..., b19, the renewal attribute of each lattice will be expanded and be calculated as:
The b10 lattice
The b11 lattice
And the like, note the C4 lattice of CONTRACTNO field correspondence wherein owing in fact be not expanded, so b10, b11 ..., the b19 expression formula of upgrading this field correspondence in the attribute still is c4.
Revise thereon then customer name/means of transportation/signing date/delivery harbour/Shipping Date, and the data such as unit price of product, and the record of newly-increased a kind of product, the result revised as shown in Figure 3.
5. write in the database table after according to upgrading attribute the data computation on the form
Data with existing in the binding data storehouse, C4 are extended to 1 c4, upgrade attribute according to it and will generate following 1 SQL statement:
update?contract
set?amount＝17200，customerid＝′6′，contractno＝′quiee0010′，
payment＝null，salesman＝null，signdate＝?′2007-02-01
00:00:00 ', transport=' PORT OF SHANGHAI ', transportdate=' 2007-02-03
00:00:00′，transportmethod?＝′2′
where?contractno＝′quiee0010′
B10 be expanded repeat into b10, b11 ..., these 10 cells of b19, wherein be filled with valid data in 3 of b10, b11, the b12 correspondence row, upgrade attribute according to it and will generate following 3 SQL statement respectively:
update?contractdetail
set?amount＝6000，contractno＝′quiee0010′，price＝1000.00，
Productid=' 4 ', quantity=6.0, quantityunit=' ton '
where?contractno＝′quiee0010′and?product?id＝′4′
update?contractdetail
set?amount＝4800，contractno＝′quiee0010′，price＝2400.00，
Productid=' 5 ', quantity=2.0, quantityunit=' ton '
where?contractno＝′quiee0010′and?productid＝′5′
insert?into?contractdetail
(contractno，productid，amount，price，quantity，quantityunit)
Values (' quiee0010 ', ' 1 ', 6400,800.00,8.0, ' ton ')
Carry out these several SQL statement and can correctly finish the in-stockroom operation of data.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.
Claims (6)
1. the method for a data input after report fill-in comprises the steps:
(1) report form template that adopts the nonlinear report generating method design to fill in;
(2) determine database table data need be write and on field;
(3) in some cell of report form template, the renewal attribute is set;
(4) expansion accounting report upgrades attribute and is expanded together as the attribute of cell and duplicates, and fills in data then in its cell;
(5) write in the database table after according to upgrading attribute the data computation on the form.
2. the method for data input after report fill-in as claimed in claim 1, it is characterized in that: the nonlinear report generating method in the step (1) comprises the steps:
The data set that need use when (1) determining the form computing, and name respectively;
(2) determine that in static statement some cell is the expansion lattice, promptly initiatively expands the cell that duplicates, and its propagation direction is set;
(3) the left nominative and the last nominative of all cells are set, i.e. the expansion lattice that when vertical and horizontal are expanded, need follow of this cell;
(4) in each cell, insert operation expression.
3. the method for data input after report fill-in as claimed in claim 1 or 2 is characterized in that: database table is a plurality of in the step (2), from identical or different databases; And the data set that is used to design report form template in these database tables and the step (1) is irrelevant.
4. the method for data input after report fill-in as claimed in claim 1 or 2, it is characterized in that: the renewal attribute in the step (3) be one by a plurality of updated data tables and more newer field and the array that constitutes of renewal expression formula of correspondence with it, updated data table and more newer field is from established data table in the step (1) and field wherein, upgrading expression formula is a cell operation expression that meets the nonlinear report generating method rule.
5. the method for data input after report fill-in as claimed in claim 1 or 2, it is characterized in that: at each the cell that upgrades attribute is arranged in the step (5), calculate the renewal expression formula that it upgrades the more newer field correspondence on each updated data table in attribute, result of calculation is written in the tables of data as the record that the record value of field forms corresponding updated data table.
6. the method for data input after report fill-in as claimed in claim 5, it is characterized in that: when the record that will calculate in step (5) writes updated data table, if judge that according to primary key former being recorded in the tables of data exists, then generate the UPDATE statement and revise former record, insert a new record otherwise will generate the INSERT statement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100890737A CN101261641B (en) | 2007-04-18 | 2008-04-17 | Data loading method after filling report forms |
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200710097822 CN101046825A (en) | 2007-04-18 | 2007-04-18 | Method for data input after report fill-in |
| CN200710097822.6 | 2007-04-18 | ||
| CN2008100890737A CN101261641B (en) | 2007-04-18 | 2008-04-17 | Data loading method after filling report forms |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101261641A true CN101261641A (en) | 2008-09-10 |
| CN101261641B CN101261641B (en) | 2011-06-22 |
Family
ID=38771433
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200710097822 Pending CN101046825A (en) | 2007-04-18 | 2007-04-18 | Method for data input after report fill-in |
| CN2008100890737A Expired - Fee Related CN101261641B (en) | 2007-04-18 | 2008-04-17 | Data loading method after filling report forms |
Family Applications Before (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200710097822 Pending CN101046825A (en) | 2007-04-18 | 2007-04-18 | Method for data input after report fill-in |
Country Status (1)
| Country | Link |
|---|---|
| CN (2) | CN101046825A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020032A (en) * | 2012-12-28 | 2013-04-03 | 无锡城市云计算中心有限公司 | Report generation method in cloud computing system |
| CN103020089A (en) * | 2011-09-27 | 2013-04-03 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for importing data in EXCEL file to database |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261622B (en) * | 2008-05-12 | 2011-12-07 | 金蝶软件（中国）有限公司 | Data dividing method and apparatus |
| CN101277272B (en) * | 2008-05-16 | 2010-12-15 | 北京航空航天大学 | Method for implementing magnanimity broadcast data warehouse-in |
| CN102004790A (en) * | 2010-12-09 | 2011-04-06 | 向心力信息技术股份有限公司 | Method for exporting high-throughput data report |
| CN102722512B (en) * | 2011-12-30 | 2018-03-16 | 新奥特（北京）视频技术有限公司 | A kind of method in database client remote maintenance display data storehouse |
| CN102722514B (en) * | 2011-12-30 | 2017-11-10 | 新奥特（北京）视频技术有限公司 | A kind of method that Remote Dynamic creates database |
| CN102982439A (en) * | 2012-11-12 | 2013-03-20 | 中国电子科技集团公司第十五研究所 | Method for generating electronic document and electronic document generating system |
| CN112015623B (en) * | 2020-08-27 | 2024-04-12 | 百度时代网络技术（北京）有限公司 | Report data processing method, device, equipment and readable storage medium |
| CN112257401B (en) * | 2020-12-22 | 2021-03-19 | 畅捷通信息技术股份有限公司 | Adaptive expansion method and device of data object and storage medium |
-
2007
- 2007-04-18 CN CN 200710097822 patent/CN101046825A/en active Pending
-
2008
- 2008-04-17 CN CN2008100890737A patent/CN101261641B/en not_active Expired - Fee Related
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020089A (en) * | 2011-09-27 | 2013-04-03 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for importing data in EXCEL file to database |
| CN103020032A (en) * | 2012-12-28 | 2013-04-03 | 无锡城市云计算中心有限公司 | Report generation method in cloud computing system |
| CN103020032B (en) * | 2012-12-28 | 2016-09-14 | 无锡城市云计算中心有限公司 | Report form generation method in cloud computing system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101261641B (en) | 2011-06-22 |
| CN101046825A (en) | 2007-10-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101261641B (en) | Data loading method after filling report forms | |
| Plattner et al. | In-memory data management: technology and applications | |
| CN100568237C (en) | Report form template in the multidimensional enterprise software system generates method and system | |
| CN103577590A (en) | Data query method and system | |
| CN103902439B (en) | The management method of a kind of test case, Apparatus and system | |
| CN105184542A (en) | Enterprise resource plan real time management method and system based on material stock state | |
| Bala et al. | A Fine‐Grained Distribution Approach for ETL Processes in Big Data Environments | |
| US20140244573A1 (en) | Data warehouse with cloud fact table | |
| US20060130002A1 (en) | Requirement defining method, method for developing software, and method for changing requirement word, and newly defining method | |
| US20160154830A1 (en) | Systems and methods for data integration | |
| CN107391611A (en) | A kind of process model generation method of the General ETL Tool based on workflow | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| US20100293450A1 (en) | System and method for simulating discrete financial forecast calculations | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| Prifti et al. | A Capex Opex Simultaneous Robust Optimizer: Process Simulation-based Generalized Framework for Reliable Economic Estimations | |
| CN111913962A (en) | Multi-dimensional annual detailed fund planning system and method | |
| CN102779092B (en) | Quote check system and quote inspection method | |
| Gill et al. | An open source ETL tool-medium and small scale enterprise ETL (MaSSEETL) | |
| Karkošková | Architectural Design of Metadata Management Tool | |
| CN112381228B (en) | Knowledge system construction and application method based on business | |
| CN112711412B (en) | Universal business plan compiling method and platform | |
| Prakash et al. | Requirements Engineering for Data Warehousing | |
| Aghazada | Arrangement and Modulation of ETL Process in the Storage | |
| Narandžić et al. | The challenge of an Extraction-Transformation-Loading tool selection | |
| Bȩbel et al. | Managing multiple real and simulation business scenarios by means of a multiversion data warehouse |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20110622 Termination date: 20190417 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |