CN114398860A - Multi-table aggregation method based on DSL layout engine - Google Patents
Multi-table aggregation method based on DSL layout engine Download PDFInfo
- Publication number
- CN114398860A CN114398860A CN202111447588.1A CN202111447588A CN114398860A CN 114398860 A CN114398860 A CN 114398860A CN 202111447588 A CN202111447588 A CN 202111447588A CN 114398860 A CN114398860 A CN 114398860A
- Authority
- CN
- China
- Prior art keywords
- component
- aggregation
- metadata
- sub
- 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.)
- Pending
Links
- 230000002776 aggregation Effects 0.000 title claims abstract description 47
- 238000004220 aggregation Methods 0.000 title claims abstract description 47
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000009877 rendering Methods 0.000 claims abstract description 7
- 238000013507 mapping Methods 0.000 claims description 18
- 238000006116 polymerization reaction Methods 0.000 claims description 18
- 101100221542 Bacillus subtilis (strain 168) comN gene Proteins 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 8
- 238000004064 recycling Methods 0.000 claims description 6
- 230000004931 aggregating effect Effects 0.000 claims description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000011143 downstream manufacturing Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/26—Government or public services
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- Marketing (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Primary Health Care (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a multi-table aggregation method based on a DSL layout engine. On the basis of a layout engine based on a dynamic rendering form, multi-form aggregation is carried out on the layout engine to form a form, repeated data are removed, uploading materials are integrated, a user can declare and run only once, and government affair reform and innovation such as online declaration, one-network management, online next window acceptance and one-time running are achieved.
Description
Technical Field
The invention relates to a multi-table aggregation method based on a DSL layout engine.
Background
Currently, most application scenarios have implemented electronic filing of forms in government services. And the masses submit repeated data for the form information filling and submit the same material by running different departments each time, thereby causing great troubles to the masses, prolonging the transaction time and having low efficiency.
Disclosure of Invention
The invention aims to realize one-time filling and submission of repeated data and one-time submission of repeated materials, so that a multi-table aggregation method based on a DSL layout engine is provided, a layout engine based on a dynamic rendering form is taken as a basis, multi-table aggregation is carried out on the layout engine to form a form, repeated data is removed, uploaded materials are integrated, a user can make only one-time declaration and one-time running, and government affair reform and innovation such as one-time declaration, one-time internet handling, one-time running and the like are realized.
In order to achieve the purpose, the technical scheme of the invention is as follows: a multi-table aggregation method based on a DSL layout engine is characterized in that the DSL layout engine is used as a basis, metadata for multi-table aggregation is constructed, the metadata is rendered into an aggregation form, and the form participating in aggregation, namely a sub-form, is backfilled after being filled, and the method specifically comprises the following implementation steps:
s1, selecting forms to be aggregated, and configuring the aggregation sequence of the corresponding forms to form a precondition before aggregation;
step S2, respectively processing the forms according to the selected forms and the aggregation sequence, carrying out component classification on the form 1, matching the form 2 according to the form 1, aggregating the same components and generating metadata of corresponding mapping relations, putting different components into a list, circularly processing the form, and the like till the form n is processed;
step S3, processing the unaggregated components, wherein the names of the forms are grouped titles, and the unaggregated components in the corresponding tables are classified under the corresponding grouped titles;
step S4, integrating data of the aggregated component and the non-aggregated component to form renderable metadata, and then rendering the data into a form according to the DSL layout engine;
and step S5, after the aggregation form is filled, distributing the data of the sub-forms according to the mapping relation of the aggregation components, and performing the following process according to the distributed data by related departments.
In an embodiment of the present invention, step S2 is implemented as follows:
circularly participating in the aggregated form list, and starting to perform component classification on a first form, namely the table 1, and generating a component class set; recycling the component list2 of the second form, namely the table 2, and recycling the component class set comList, judging whether the codes and titles of the components 1, namely the com1 in the list2 are consistent with the codes and titles of the components N, namely the comN in the comList list, if so, judging that the current com1 can be aggregated to the comN, namely, generating aggregated component unit data, generating the mapping relation between the com1 and the comN of the second form, namely, aggregated component metadata, and if not, generating a single-form component data list, and putting the com1 into the single-form component data list, namely, generating the single-form component metadata; and repeating the steps until the step of the table n, finally generating aggregation form component metadata, single-form component metadata and aggregation component mapping relation metadata, and generating an aggregation form according to the metadata and the DSL layout engine.
In an embodiment of the present invention, step S5 is implemented as follows:
the method comprises the steps of filling a polymerization form to generate filling data, inquiring data of sub-form components involved according to a component mapping relation of the polymerization form, circulating a sub-form component list and a polymerization form component list, assigning a filling value of the polymerization form component to the sub-form component when the information of the current sub-form component exists in the component mapping relation of the polymerization form, repeating the steps until the sub-form component is circulated, and finishing assignment, wherein the assignment is finished, and the process of distributing the sub-forms of the polymerization form is realized.
Compared with the prior art, the invention has the following beneficial effects: the invention discloses a multi-table aggregation method based on a DSL layout engine, which is characterized in that multi-table aggregation is carried out on the basis of the layout engine based on a dynamic rendering form to form a form, repeated data is removed, and uploaded materials are integrated, so that a user can declare and run only once, and government reform and innovation such as online declaration, one-network communication, online window acceptance and one-time running are realized.
Drawings
FIG. 1 is an overall flow chart of the method of the present invention.
FIG. 2 is a schematic diagram of a form aggregation process according to the present invention.
Detailed Description
The technical scheme of the invention is specifically explained below with reference to the accompanying drawings.
As shown in fig. 1, the present invention relates to a multi-table aggregation method based on a DSL layout engine, which constructs metadata for multi-table aggregation based on the DSL layout engine, renders the metadata into an aggregation form, and backfills the form (hereinafter collectively referred to as a sub-form) participating in aggregation after the metadata is filled, and the principle is as follows:
selecting forms needing to be aggregated, and configuring the aggregation sequence of the corresponding forms to form a precondition before aggregation;
step two, respectively processing the forms according to the selected forms and the aggregation sequence, wherein the form 1 is subjected to component classification, the form 2 is subjected to matching according to the form 1, the same components are aggregated, metadata of corresponding mapping relations are generated, different components are placed in a list, the form is processed in a circulating mode, and the like until the form n is processed;
step three, processing the unaggregated components, taking the form name as a grouping title, and enabling the unaggregated components in the table to be under the grouping title;
performing data integration on the aggregated component and the non-aggregated component to form renderable metadata, and then performing data rendering to form a form according to a DSL layout engine;
after the aggregation form is filled, distributing data of the sub-forms according to the mapping relation of the aggregation components, and performing downstream processing by related departments according to the distributed data;
the scheme of multi-table aggregation can be solved based on the five steps, wherein the second step and the fifth step are the core of the whole scheme, and the specific steps are as follows:
as shown in fig. 2, looping through the list of forms participating in aggregation, starting to perform component classification on the first form and generating a component class set; recycling a component list2 of a second form and recycling a component class set comList, judging whether the codes and titles of a component 1 (hereinafter, referred to as a component 1) in the list2 are consistent with those of a component N (hereinafter, referred to as a comN) in the comList list, if so, judging that the current component 1 can be aggregated to the comN, namely, generating aggregated table unit data, generating a mapping relation between the component 1 of the second form and the comN, namely, aggregated component metadata, and if not, generating a single-form component data list, and putting the component 1 into the single-form component data list, namely, generating single-form component metadata; and repeating the steps until the form n is reached, finally generating aggregate form component metadata, single form component metadata and aggregate component mapping relation metadata, and generating an aggregate form according to the metadata and the DSL layout engine.
The method comprises the steps of filling a polymerization form to generate filling data, inquiring data of sub-form components involved according to a component mapping relation of the polymerization form, circulating a sub-form component list and a polymerization form component list, assigning a filling value of the polymerization form component to the sub-form component when the information of the current sub-form component exists in the component mapping relation of the polymerization form, repeating the steps until the sub-form component is circulated, and finishing assignment, wherein the assignment is finished, and the process of distributing the sub-forms of the polymerization form is realized.
After the aggregated form filling data is distributed to the sub-forms, the sub-forms can display the filled data by accessing, so that the filling is only carried out once, and the sub-forms are distributed to related departments, namely, the related departments can carry out business examination and verification or transaction according to the filled data, thereby facilitating the filling of users and solving the problem that the related departments receive repeated data or files.
The above are preferred embodiments of the present invention, and all changes made according to the technical scheme of the present invention that produce functional effects do not exceed the scope of the technical scheme of the present invention belong to the protection scope of the present invention.
Claims (3)
1. A multi-table aggregation method based on a DSL layout engine is characterized in that the method is implemented by constructing metadata of multi-table aggregation on the basis of the DSL layout engine, rendering the metadata into an aggregation form, and backfilling the form participating in aggregation, namely a sub-form, after filling, and comprises the following concrete implementation steps:
s1, selecting forms to be aggregated, and configuring the aggregation sequence of the corresponding forms to form a precondition before aggregation;
step S2, respectively processing the forms according to the selected forms and the aggregation sequence, carrying out component classification on the form 1, matching the form 2 according to the form 1, aggregating the same components and generating metadata of corresponding mapping relations, putting different components into a list, circularly processing the form, and the like till the form n is processed;
step S3, processing the unaggregated components, wherein the names of the forms are grouped titles, and the unaggregated components in the corresponding tables are classified under the corresponding grouped titles;
step S4, integrating data of the aggregated component and the non-aggregated component to form renderable metadata, and then rendering the data into a form according to the DSL layout engine;
and step S5, after the aggregation form is filled, distributing the data of the sub-forms according to the mapping relation of the aggregation components, and performing the following process according to the distributed data by related departments.
2. The DSL layout engine-based multi-table aggregation method of claim 1, wherein step S2 is implemented as follows:
circularly participating in the aggregated form list, and starting to perform component classification on a first form, namely the table 1, and generating a component class set; recycling the component list2 of the second form, namely the table 2, and recycling the component class set comList, judging whether the codes and titles of the components 1, namely the com1 in the list2 are consistent with the codes and titles of the components N, namely the comN in the comList list, if so, judging that the current com1 can be aggregated to the comN, namely, generating aggregated component unit data, generating the mapping relation between the com1 and the comN of the second form, namely, aggregated component metadata, and if not, generating a single-form component data list, and putting the com1 into the single-form component data list, namely, generating the single-form component metadata; and repeating the steps until the step of the table n, finally generating aggregation form component metadata, single-form component metadata and aggregation component mapping relation metadata, and generating an aggregation form according to the metadata and the DSL layout engine.
3. The DSL layout engine-based multi-table aggregation method according to claim 2, wherein step S5 is implemented as follows:
the method comprises the steps of filling a polymerization form to generate filling data, inquiring data of sub-form components involved according to a component mapping relation of the polymerization form, circulating a sub-form component list and a polymerization form component list, assigning a filling value of the polymerization form component to the sub-form component when the information of the current sub-form component exists in the component mapping relation of the polymerization form, repeating the steps until the sub-form component is circulated, and finishing assignment, wherein the assignment is finished, and the process of distributing the sub-forms of the polymerization form is realized.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111447588.1A CN114398860A (en) | 2021-12-01 | 2021-12-01 | Multi-table aggregation method based on DSL layout engine |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111447588.1A CN114398860A (en) | 2021-12-01 | 2021-12-01 | Multi-table aggregation method based on DSL layout engine |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114398860A true CN114398860A (en) | 2022-04-26 |
Family
ID=81225219
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111447588.1A Pending CN114398860A (en) | 2021-12-01 | 2021-12-01 | Multi-table aggregation method based on DSL layout engine |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114398860A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116562255A (en) * | 2023-07-11 | 2023-08-08 | 北京国电通网络技术有限公司 | Form information generation method, form information generation device, electronic equipment and computer readable medium |
-
2021
- 2021-12-01 CN CN202111447588.1A patent/CN114398860A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116562255A (en) * | 2023-07-11 | 2023-08-08 | 北京国电通网络技术有限公司 | Form information generation method, form information generation device, electronic equipment and computer readable medium |
| CN116562255B (en) * | 2023-07-11 | 2023-09-19 | 北京国电通网络技术有限公司 | Form information generation method, form information generation device, electronic equipment and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108563796A (en) | Data compressing method, device and the electronic equipment of block chain | |
| CN107145537B (en) | Table data importing method and system | |
| US8301650B1 (en) | Bloom filter compaction | |
| CN103473325A (en) | System and method for generating test case data | |
| CN110837501A (en) | User-defined form system, form manufacturing method and storage medium | |
| CN105630590A (en) | Business information processing method and device | |
| CN109657075A (en) | A kind of digital resource adduction relationship recording method and system | |
| CN114398860A (en) | Multi-table aggregation method based on DSL layout engine | |
| CN107622102A (en) | Entity card number generation method and terminal device | |
| CN113672204A (en) | Interface document generation method, system, electronic equipment and storage medium | |
| CN101702219A (en) | Method for generating material information and device thereof | |
| CN106469141B (en) | A kind of ECN inspection methods based on Excel and TeamCenter | |
| CN104468751A (en) | Self-defining method for business process nodes in cloud sea operating system | |
| CN102959539B (en) | Item recommendation method during a kind of repeat in work and system | |
| CN106610929A (en) | Method and device for typesetting digital publishing structured content file | |
| CN106708822A (en) | File storage method and device | |
| CN110555023A (en) | Data storage method and device based on credit contract | |
| CN104636397B (en) | Resource allocation methods, calculating accelerated method and device for Distributed Calculation | |
| CN110163564A (en) | Method, system and the storage medium of item service are generated based on item model | |
| CN107391533A (en) | Generate the method and device of graphic data base Query Result | |
| CN116610633A (en) | Electronic file archiving method, device, medium and system in airport construction engineering | |
| CN109615261A (en) | A kind of digital resource income distribution method and storage medium | |
| CN109947702A (en) | Index structuring method and device, electronic equipment | |
| CN104935647B (en) | A kind of sharing files method and device | |
| CN104267967A (en) | Method and device for generating program codes of software |
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 |