CN110674195B - Form-based query method - Google Patents

Form-based query method Download PDF

Info

Publication number
CN110674195B
CN110674195B CN201910921361.2A CN201910921361A CN110674195B CN 110674195 B CN110674195 B CN 110674195B CN 201910921361 A CN201910921361 A CN 201910921361A CN 110674195 B CN110674195 B CN 110674195B
Authority
CN
China
Prior art keywords
query
index
indexes
result sample
sample table
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
Application number
CN201910921361.2A
Other languages
Chinese (zh)
Other versions
CN110674195A (en
Inventor
吴玉林
田恩辉
史艳庆
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN201910921361.2A priority Critical patent/CN110674195B/en
Publication of CN110674195A publication Critical patent/CN110674195A/en
Application granted granted Critical
Publication of CN110674195B publication Critical patent/CN110674195B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a form-based query method, and relates to the technical field of data query; summarizing and extracting the form information according to the query indexes of different dimensions, dynamically generating a query result sample table, establishing a query template through the query result sample table, screening summarized results meeting the query index conditions by using the query template, and analyzing and displaying according to the query result sample table; the method is innovative for index statistics results, can rapidly and simply obtain summary results of form indexes meeting the conditions according to the query result sample table, and displays the summary results according to the analyzed sample table, meanwhile, the statistics query result patterns can be organized according to the requirements, query templates can be stored according to users, the query templates can be used repeatedly after being stored, and the query templates can support operations such as modification and deletion, so that user experience is improved.

Description

Form-based query method
Technical Field
The invention discloses a form-based query method, and relates to the technical field of data query.
Background
Most of the systems used by enterprises only meet the daily business processing requirements of the enterprises, and simultaneously only provide report functions meeting the fixed format of the basic requirements. The daily work has various report forms, different enterprises have different requirements, and different report forms are needed at different times. Although the professional report tool can customize report formats and data sources, the requirements on personal professional skills are high, and the operation is complicated.
The invention discloses a form-based query method, which comprises the steps of carrying out induction and extraction of query indexes on form information according to different dimensions, dynamically generating a query result sample table, establishing a query template through the query result sample table, screening summarized results meeting query index conditions by using the query template, and carrying out analysis and display according to a query result sample table format; the method is innovative for index statistics results, can rapidly and simply obtain summary results of form indexes meeting the conditions according to the query result sample table, and displays the summary results according to the analyzed sample table, meanwhile, the statistics query result patterns can be organized according to the requirements, query templates can be stored according to users, the query templates can be used repeatedly after being stored, and the query templates can support operations such as modification and deletion, so that user experience is improved.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a query method based on a form, which completes information acquisition of service basic data through the form, flexibly counts and queries the service basic data, and can enable a user to freely define a report style and data which are required to be generated, thereby bringing good use experience for the user.
The specific scheme provided by the invention is as follows:
a form-based query method, which comprises the steps of carrying out induction and extraction of query indexes on form information according to different dimensions, dynamically generating a query result sample table,
and establishing a query template through a query result sample table, screening summarized results meeting query index conditions by using the query template, and analyzing and displaying according to the query result sample table.
In the method, an upper header and a left header of the query result sample table are dynamically generated, and the upper header and the left header are used for determining the ordering, the position and the grouping of query indexes in the query result sample table.
In the method, the query indexes are ordered: and ordering the query indexes according to the sequence of the query index numbers.
The method comprises the steps of grouping query indexes: the query indexes are grouped according to whether the query indexes have the upper-lower relation, and when one query index and all the query indexes ordered before the query index do not have the upper-lower relation any more, the query indexes are divided into a new query index group.
In the method, the query indexes in each query index group are traversed to determine the starting row, the starting column, the ending row and the ending column of each query index so as to determine the position of each query index.
In the method, a query template determines query index conditions through the intersection of the upper table head and the left table head of a query result sample table, and data meeting the query index conditions are screened and the results are summarized.
According to the method, the data corresponding to the query indexes in the summarized results are analyzed and displayed according to the sequence of the query indexes in the query result sample table.
A query system based on a form comprises an extraction generating unit and a query displaying unit,
the extraction generating unit carries out induction extraction of query indexes on the form information according to different dimensions, dynamically generates a query result sample table,
the query display unit establishes a query template through a query result sample table, screens summarized results meeting query index conditions by using the query template, and analyzes and displays the summarized results according to the query result sample table.
The invention has the advantages that:
the invention provides a form-based query method, which comprises the steps of carrying out induction and extraction of query indexes on form information according to different dimensions, dynamically generating a query result sample table, establishing a query template through the query result sample table, screening summarized results meeting query index conditions by using the query template, and carrying out analysis and display according to a query result sample table format; the method is innovative for index statistics results, can rapidly and simply obtain summary results of form indexes meeting the conditions according to the query result sample table, and displays the summary results according to the analyzed sample table, meanwhile, the statistics query result patterns can be organized according to the requirements, query templates can be stored according to users, the query templates can be used repeatedly after being stored, and the query templates can support operations such as modification and deletion, so that user experience is improved.
Drawings
FIG. 1 is a system interface diagram of the present invention;
FIG. 2 is a diagram of a query index interface specific to the system of the present invention;
FIG. 3 is a schematic flow chart of the method of the invention.
Detailed Description
The invention provides a form-based query method, which comprises the steps of carrying out induction extraction of query indexes on form information according to different dimensions, dynamically generating a query result sample table,
and establishing a query template through a query result sample table, screening summarized results meeting query index conditions by using the query template, and analyzing and displaying according to the query result sample table.
And simultaneously provides a form-based query system corresponding to the method, which comprises an extraction generating unit and a query display unit,
the extraction generating unit carries out induction extraction of query indexes on the form information according to different dimensions, dynamically generates a query result sample table,
the query display unit establishes a query template through a query result sample table, screens summarized results meeting query index conditions by using the query template, and analyzes and displays the summarized results according to the query result sample table.
The present invention will be further described with reference to the accompanying drawings and specific examples, which are not intended to be limiting, so that those skilled in the art will better understand the invention and practice it.
The method can be used for inquiring the form based on the ERP system, and the specific process is as follows:
summarizing and extracting the query indexes of the form information according to different dimensions, dynamically generating a query result sample table, wherein the dimensions can be terms of time, organization, basic information and the like, each item of information of the query indexes is contained in the query result sample table,
and establishing a query template through a query result sample table, screening data summarizing results meeting query index conditions by using the query template, and analyzing and displaying the summarizing results according to the format of the query indexes in the query result sample table.
In the process, the upper header and the left header of the query result sample table are dynamically generated, and are used for determining the sequence, the position and the grouping of the query indexes in the query result sample table,
wherein the upper header processing logic is dynamically generated: inquiring corresponding inquiry index information according to the selected inquiry index inner code list, wherein the inquiry index information comprises information such as index level, data table name, field name, index value, inquiry condition and the like,
such as querying basic information indexes of indexes, querying ZCH_CCFAZB, organizing organization indexes, querying XT_ZZGXHZDZ tables and the like,
the selected query indexes can be sequenced by using a bubbling sequencing method, the sequencing rule is based on the sequence of the query index numbers, the aim is to ensure that the data corresponding to the query index with the previous number is displayed first, the basic information index number is the query index number in the ZCH_CCFAZB table, the organization index number is the hierarchical coding of the ZZGXHZDZ table,
grouping query indexes: grouping according to whether there is upper and lower relation, dividing one index and all indexes in front into new index groups when there is no upper and lower relation, determining the index start level, end level and total number of indexes of each index group, judging whether the index is added with small list according to whether each index has lower index,
inquiring index position coordinates and determining: traversing the indexes in each index group to determine a starting row, a starting column, a terminating row and a terminating column of each index, and adding an aggregate index into the index group according to whether the indexes aggregate the attributes;
dynamically generating left header processing logic:
determining the starting line and the ending line of the first query index according to the line number occupied by the upper header,
each query index of the left header occupies one row, the cross-row and cross-column condition does not exist,
the start column and the end column of the left indicator are both the first columns,
query sample first cell processing logic:
the index name of the first cell of the query template is determined according to the index of the left header, if the index of the left side is an organization, the text of the first cell is the organization, if the index of the left side is basic information, the text is XX basic information,
the main code examples of the above procedure are as follows:
Figure BDA0002217675260000051
/>
Figure BDA0002217675260000061
/>
Figure BDA0002217675260000071
/>
Figure BDA0002217675260000081
/>
Figure BDA0002217675260000091
/>
Figure BDA0002217675260000101
the query template data area is crossed and determines query index conditions through the upper table head and the left table head of the query result sample table, data conforming to the query index conditions are screened, the query sql of the query template data area unit cells is generated by assembling the query index of the upper table head and the query index of the left table head according to configuration information, the sql is executed to obtain a data summarization result, and the main codes are as follows:
Figure BDA0002217675260000111
/>
Figure BDA0002217675260000121
/>
Figure BDA0002217675260000131
/>
Figure BDA0002217675260000141
/>
Figure BDA0002217675260000151
and analyzing and displaying the data corresponding to the query indexes in the summarized results according to the sequence of the query indexes in the query result sample table.
The system of the invention can carry out a query method based on a form on the basis of an ERP system, and referring to interfaces of fig. 1 and 2, the specific process is as follows:
the extraction generating unit carries out induction and extraction of query indexes on the form information according to different dimensions, dynamically generates a query result sample table, wherein the dimensions can be terms of time, organization, basic information and the like, each item of information of the query indexes is contained in the query result sample table,
the query display unit establishes a query template through the query result sample table, screens data summarizing results meeting the query index conditions by using the query template, and analyzes and displays the summarizing results according to the format of the query index in the query result sample table.
In the process, the extraction generating unit dynamically generates an upper header and a left header of the query result sample table, wherein the upper header and the left header are used for determining the sequence, the position and the grouping of the query indexes in the query result sample table,
wherein the upper header processing logic is dynamically generated: inquiring corresponding inquiry index information according to the selected inquiry index inner code list, wherein the inquiry index information comprises information such as index level, data table name, field name, index value, inquiry condition and the like,
such as querying basic information indexes of indexes, querying ZCH_CCFAZB, organizing organization indexes, querying XT_ZZGXHZDZ tables and the like,
the selected query indexes can be sequenced by using a bubbling sequencing method, the sequencing rule is based on the sequence of the query index numbers, the aim is to ensure that the data corresponding to the query index with the previous number is displayed first, the basic information index number is the query index number in the ZCH_CCFAZB table, the organization index number is the hierarchical coding of the ZZGXHZDZ table,
grouping query indexes: grouping according to whether there is upper and lower relation, dividing one index and all indexes in front into new index groups when there is no upper and lower relation, determining the index start level, end level and total number of indexes of each index group, judging whether the index is added with small list according to whether each index has lower index,
inquiring index position coordinates and determining: traversing the indexes in each index group to determine a starting row, a starting column, a terminating row and a terminating column of each index, and adding an aggregate index into the index group according to whether the indexes aggregate the attributes;
dynamically generating left header processing logic:
determining the starting line and the ending line of the first query index according to the line number occupied by the upper header,
each query index of the left header occupies one row, the cross-row and cross-column condition does not exist,
the start column and the end column of the left indicator are both the first columns,
query sample first cell processing logic:
the index name of the first cell of the query template is determined according to the index of the left header, if the index of the left side is an organization, the text of the first cell is the organization, if the index of the left side is basic information, the text is XX basic information,
the main code example of the process of dynamically generating the query result sample table by the extraction generating unit can refer to the corresponding position code generating example in the method of the invention;
the query template data area in the query display unit determines query index conditions through the intersection of the upper table head and the left table head of the query result sample table, and screens data conforming to the query index conditions, the query template data area unit cell query sql is generated by assembling the query index of the upper table head and the query index of the left table head according to configuration information, the sql is executed to obtain a data summarizing result, and the main codes can refer to corresponding position code generation examples in the method.
Table 1 shows ZCH_CCFA, table 2 shows ZCH_CCFAZB, table 3 shows ZCH_CCFAZDYZB,
TABLE 1
Figure BDA0002217675260000171
TABLE 2
Figure BDA0002217675260000172
TABLE 3 Table 3
Figure BDA0002217675260000181
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.

Claims (3)

1. A query method based on forms is characterized in that form information is subjected to induction extraction of query indexes according to different dimensions, a query result sample table is dynamically generated, an upper table header and a left table header of the query result sample table are dynamically generated, the upper table header and the left table header are used for determining the ordering, the position and the grouping of the query indexes in the query result sample table,
the query indexes are ordered according to the sequence of the query index numbers,
grouping query indexes: grouping according to whether the query indexes have the upper and lower relationships, dividing one query index into a new query index group when the query index and all the query indexes ordered before the query index have no upper and lower relationships any more,
traversing the query indexes in each query index group to determine a start row, a start column, a stop row and a stop column of each query index so as to determine the position of each query index;
establishing a query template through a query result sample table, and screening summarized results meeting query index conditions by using the query template, wherein the query template is used for determining the query index conditions through the intersection of the upper table head and the left table head of the query result sample table, and screening data meeting the query index conditions;
and analyzing and displaying according to the query result sample form.
2. The method of claim 1, wherein the analysis and display are performed on the data corresponding to the query indexes in the summarized results according to the sequence of the query indexes in the query result sample table.
3. A query system based on a form is characterized by comprising an extraction generating unit and a query displaying unit,
the extraction generating unit carries out induction and extraction of query indexes on the form information according to different dimensions, dynamically generates a query result sample table, dynamically generates an upper table header and a left table header of the query result sample table, wherein the upper table header and the left table header are used for determining the sequence, the position and the grouping of the query indexes in the query result sample table,
the extraction generating unit sorts the query indexes according to the sequence of the query index numbers,
grouping query indexes: grouping according to whether the query indexes have the upper and lower relationships, dividing one query index into a new query index group when the query index and all the query indexes ordered before the query index have no upper and lower relationships any more,
traversing the query indexes in each query index group to determine a start row, a start column, a stop row and a stop column of each query index so as to determine the position of each query index;
the query display unit establishes a query template through a query result sample table, and screens summarized results meeting query index conditions by using the query template: the query template cross-determines query index conditions through the upper header and the left header of the query result sample table, and screens data conforming to the query index conditions; and analyzing and displaying according to the query result sample form.
CN201910921361.2A 2019-09-27 2019-09-27 Form-based query method Active CN110674195B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910921361.2A CN110674195B (en) 2019-09-27 2019-09-27 Form-based query method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910921361.2A CN110674195B (en) 2019-09-27 2019-09-27 Form-based query method

Publications (2)

Publication Number Publication Date
CN110674195A CN110674195A (en) 2020-01-10
CN110674195B true CN110674195B (en) 2023-05-02

Family

ID=69079612

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910921361.2A Active CN110674195B (en) 2019-09-27 2019-09-27 Form-based query method

Country Status (1)

Country Link
CN (1) CN110674195B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112182349B (en) * 2020-09-14 2024-06-11 支付宝(杭州)信息技术有限公司 Query method, device and system for compliance files
CN112506942A (en) * 2020-10-29 2021-03-16 望海康信(北京)科技股份公司 Data combination query method, system and corresponding equipment and storage medium
CN113517047A (en) * 2021-06-08 2021-10-19 联仁健康医疗大数据科技股份有限公司 Medical data acquisition method and device, electronic equipment and storage medium

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7725328B1 (en) * 1996-10-30 2010-05-25 American Board Of Family Practice, Inc. Computer architecture and process of patient generation evolution, and simulation for computer based testing system
CN103064689A (en) * 2013-01-04 2013-04-24 大唐软件技术股份有限公司 Implementation method and system for dynamically generating report pages

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7725328B1 (en) * 1996-10-30 2010-05-25 American Board Of Family Practice, Inc. Computer architecture and process of patient generation evolution, and simulation for computer based testing system
CN103064689A (en) * 2013-01-04 2013-04-24 大唐软件技术股份有限公司 Implementation method and system for dynamically generating report pages

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
统计数据查询系统的设计与实现;何荣刚等;《计算机技术与发展》;20090210(第02期);全文 *

Also Published As

Publication number Publication date
CN110674195A (en) 2020-01-10

Similar Documents

Publication Publication Date Title
CN110674195B (en) Form-based query method
US5557787A (en) Table generating apparatus employing heading, layout, and table script data
CN110292775B (en) Method and device for acquiring difference data
WO2014070037A1 (en) Automated report generation method
CN106897285B (en) Data element extraction and analysis system and data element extraction and analysis method
WO2006138639A1 (en) Building of database queries from graphical operations
CN106528512B (en) A kind of EXCEL preliminary budget table automatic editing method
CN103164222A (en) Multidimensional modeling system and multidimensional modeling method
CN102708142A (en) Method and system for acquiring background data through structured query language (SQL) custom-made template
TWI410814B (en) System and method for technique document analysis, and patent analysis system
CN101419531B (en) Character input method and device in computer
CN111401014A (en) Multi-index multi-dimensional analysis method, system and construction method based on report
CN101751400A (en) System and method of technical data analysis and system of patent analysis
CN111291025B (en) Method for supporting multi-physical model conversion by logic model and storage device
CN102737030A (en) Patent document data outputting method, terminal and system
CN111191429A (en) System and method for automatic filling of data table
CN111190965A (en) Text data-based ad hoc relationship analysis system and method
CN111708814A (en) Data statistical method, device, equipment and medium
CN101470749A (en) System and method for Chinese character retrieval through etymon based on computer network
JP4736089B2 (en) Information processing apparatus, file data merging method, and file name assigning method
CN115906213A (en) Editing method and system of visual chess evaluation statistical model
CN107240150A (en) A kind of three-dimensional tube numeral dissolves drawing method
JP2016218747A (en) Apparatus, method, and program for mapping, and recording medium
CN104168354B (en) Contact person information processing method, device and mobile terminal based on immediate communication tool
CN114661704B (en) Data resource full life cycle management method, system, terminal and medium

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
TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20230411

Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong

Applicant after: Inspur Genersoft Co.,Ltd.

Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province

Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd.

GR01 Patent grant
GR01 Patent grant