CN110597842B - Service data query method and system - Google Patents
Service data query method and system Download PDFInfo
- Publication number
- CN110597842B CN110597842B CN201910662523.5A CN201910662523A CN110597842B CN 110597842 B CN110597842 B CN 110597842B CN 201910662523 A CN201910662523 A CN 201910662523A CN 110597842 B CN110597842 B CN 110597842B
- Authority
- CN
- China
- Prior art keywords
- query
- data
- field
- report
- user
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a service data query method and a service data query system. The method comprises the following steps: creating a form data set, and enabling the data set to store a plurality of associated data objects, a plurality of fields corresponding to each data object and service data corresponding to each field; creating a query report based on the data object and the field, and enabling the query report to store the field serving as a query item; binding the unit cell of the row or column of each field in the query report with the business data corresponding to the field in the form data set; acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query sentence corresponding to the query instruction based on a preset query language grammar rule; and inquiring service data corresponding to the field to be inquired in the inquiry report by utilizing the inquiry statement, and outputting an inquiry result. The service data query method provided by the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
Description
Technical Field
The present invention relates to the field of computer software technologies, and in particular, to a service data query method and system.
Background
Enterprises generate large amounts of form data during production operations, which are mostly stored in business databases. When a certain data volume is reached or more query conditions are met, a long time is usually required for querying the required data from the service database, and a plurality of inconveniences are brought to statistics summarization work of each department.
Currently, structured Query Language (SQL) is commonly used to query business data. However, the existing SQL sentences need to be completely written manually by programmers, and when the query conditions are more, a large number of SQL sentences need to be written for a long time, which not only increases the workload of the programmers, but also reduces the service data query efficiency.
Therefore, it is desirable to provide a service data query method and system capable of solving the above-mentioned problems.
Disclosure of Invention
The technical problems to be solved by the invention are as follows: the existing SQL sentences are required to be completely written manually by programmers, and when the query conditions are more, a large number of SQL sentences are required to be written for a long time, so that the workload of the programmers is increased, and the service data query efficiency is also reduced.
In order to solve the technical problems, the invention provides a service data query method and a service data query system.
According to one aspect of the present invention, there is provided a service data query method, including:
creating a form data set, and enabling the data set to store a plurality of associated data objects, a plurality of fields corresponding to each data object and service data corresponding to each field;
creating a query report based on the data object and the field, and enabling the query report to store the field as a query item;
binding the unit grid of the row or the column of each field in the query report with the business data corresponding to the field in the form data set;
acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query sentence corresponding to the query instruction based on a preset query language grammar rule;
and inquiring service data corresponding to the field to be inquired in the inquiry report by utilizing the inquiry statement, and outputting an inquiry result.
In a preferred embodiment of the invention, the data object and the field are selected from a service database in response to a selection instruction entered by a user.
In a preferred embodiment of the present invention, further comprising: and processing the data of the query result according to the data processing instruction input by the user.
In a preferred embodiment of the present invention, the data processing includes one or more of sorting, grouping, co-locating, and drilling.
In a preferred embodiment of the present invention, further comprising: and setting the permission for the query report according to the permission instruction input by the user.
In a preferred embodiment of the invention, the rights include access rights and operation rights.
According to another aspect of the present invention, there is provided a service data query system, including:
a form data set creation unit configured to create a form data set and store the data set with a plurality of associated data objects, a plurality of fields corresponding to each data object, and service data corresponding to each field;
a query report creation unit configured to create a query report based on the data object and the field, and to store the query report with the field as a query item;
the data binding unit is configured to bind the unit grid of the row or the column of each field in the query report with the business data corresponding to the field in the form data set;
the query sentence generation unit is configured to acquire a query instruction which is input by a user and comprises a field to be queried, and automatically generate a query sentence corresponding to the query instruction based on a preset query language grammar rule;
and the data query unit is configured to query the service data corresponding to the field to be queried in the query report by utilizing the query statement and output a query result.
In a preferred embodiment of the invention, the data object and the field are selected from a service database in response to a selection instruction entered by a user.
In a preferred embodiment of the present invention, further comprising: and the data processing unit is configured to process the data of the query result according to the data processing instruction input by the user.
In a preferred embodiment of the present invention, the data processing includes one or more of sorting, grouping, co-locating, and drilling.
In a preferred embodiment of the present invention, further comprising: and the permission setting unit is configured to set permissions for the query report according to permission instructions input by a user.
In a preferred embodiment of the invention, the rights include access rights and operation rights.
One or more embodiments of the above-described solution may have the following advantages or benefits compared to the prior art:
by applying the service data query method provided by the embodiment of the invention, as a programmer only needs to input the query language grammar rule into the query statement generation unit in advance, the query statement generation unit can automatically generate the query statement corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction including the field to be queried input by the user. In the service data query method, only the step of generating the grammar rule of the query language needs the participation of SQL sentences or query sentences written by other query languages, so that the service data query method of the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the invention, and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention, without limitation to the invention. In the drawings:
fig. 1 shows a flow chart of a service data query method according to a first embodiment of the present invention;
fig. 2 is a flow chart of a service data query method according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a service data query system according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a service data query system according to a fourth embodiment of the present invention.
Detailed Description
The following will describe embodiments of the present invention in detail with reference to the drawings and examples, thereby solving the technical problems by applying technical means to the present invention, and realizing the technical effects can be fully understood and implemented accordingly. It should be noted that, as long as no conflict is formed, each embodiment of the present invention and each feature of each embodiment may be combined with each other, and the formed technical solutions are all within the protection scope of the present invention.
In order to solve the technical problems that in the prior art, SQL sentences are required to be written by programmers completely by hand, and when the query conditions are more, a large number of SQL sentences are required to be written for a long time, the workload of the programmers is increased, and the service data query efficiency is reduced.
Example 1
Fig. 1 shows a flow chart of a service data query method according to a first embodiment of the present invention.
As shown in fig. 1, the service data query method according to the first embodiment of the present invention mainly includes the following steps S101 to S105.
In step S101, a form data set is created, and the data set is made to hold a plurality of associated data objects, a plurality of fields corresponding to each data object, and service data corresponding to each field. The form dataset is used as a data source for querying the report.
Preferably, the data objects and fields are selected from the service database in response to a selection instruction entered by a user.
Specifically, based on the data that the user wants to present, an associated data object and a plurality of fields corresponding to each data object are selected from the service database according to a selection instruction input by the user, wherein each field corresponds to service data. A form dataset is created based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
Here, for ease of understanding, description will be given by taking inquiry of business trip cancellation application data as an example.
First, three associated data objects, which are "business reimbursement", "accommodation fee" and "traffic fee", respectively, are selected from the business database according to a first selection instruction input by the user based on business reimbursement application data that the user wants to present. Then, according to a second selection instruction input by the user, the "bill number", "business trip place" and "business trip" fields are selected from the "business trip reimbursement" data object, the "accommodation date" and "accommodation amount" fields are selected from the "accommodation expense" data object, and the "traffic date" and "traffic expense" fields are selected from the "traffic expense" data object. Here, it should be noted that each field corresponds to service data. Finally, a form dataset is created for the business trip application based on the selected data objects, the fields corresponding to each data object, and the business data corresponding to each field.
Because the form dataset of the embodiment of the invention is created based on the data that the user wants to present, i.e., which data the user wants to present in the query report, the corresponding data objects and fields are selected from the business database, each field corresponding to business data. Therefore, the creation of the form data set in the embodiment of the invention can realize the customization according to the user requirements.
In step S102, a query report is created based on the data object and the field, and the query report is saved with the field as a query item.
Query reports are mainly divided into five types: a detail report, a unit report, a floating line report, a floating column report and a floating line report. The detail report is a report with fixed header, and the data of the report is displayed in a mode that the whole row is automatically extended downwards. The unit report forms are report forms in which the report forms display data in a unit cell mode, and the header of the report forms and the displayed data are fixed. The floating line report is a report with a fixed header, and the data of the report is displayed in a manner of automatically expanding the line downwards (similar to a detail report, but floating lines can set floating conditions, which are a component part of a floating line report). The floating column report is a report in which the report format displays data in a manner that column is automatically extended to the right. The floating line and column report forms are report forms in which the report forms display data in a mode of automatic downward expansion and automatic rightward expansion.
When the query report is created, different types of query reports can be created according to different instructions input by a user. In addition, the form style of the query report can be customized according to the instruction input by the user. For example, the form style may be obtained by importing Excel, may be obtained by importing templates, or may be defined by itself according to requirements, etc.
Specifically, a query report is created based on the user selected data objects and fields, as shown in Table 1 below:
TABLE 1
The query items in the query report are fields of the data object selected by the user, namely, data which the user wants to display in the query report.
In step S103, for each field in the query report, the cell in the row or column where the field is located and the service data corresponding to the field in the form data set are bound.
Specifically, for the "document number" field in the query report, binding the cell of the column where the field is located to the service data corresponding to the "document number" field in the document data set. That is, after the data binding is performed, the cell in the column of the "document number" in the query report displays only the service data related to the document number in the document data set. And binding the unit cells of the column where the field is positioned to the business data corresponding to the business place field in the form data set aiming at the business place field in the query report. That is, after the data binding is performed, the cells in the column of the "business trip place" in the query report only display the business data related to the business trip place in the form data set. And the like, until the cells of the columns of the fields in the query report are bound to the service data corresponding to the fields in the form data set.
Here, it is to be noted that whether to bind the cells of the row where the field is located and the service data corresponding to the field in the form data set or bind the cells of the column where the field is located and the service data corresponding to the field in the form data set is decided according to the created form style. For example, according to the created table style of the table 1, it can be determined that the cells of the column where the field is located and the service data corresponding to the field in the form data set are bound.
In step S104, a query instruction including a field to be queried input by a user is acquired, and a query sentence corresponding to the query instruction is automatically generated based on a preset query language grammar rule.
Specifically, when the user wants to query the related data with document number 001, the user inputs a query instruction including "document number 001", and after the query statement generation unit obtains the query instruction input by the user, the query statement generation unit automatically generates a query statement corresponding to the query instruction based on a preset query language grammar rule.
Here, it should be noted that the query statement in the embodiment of the present invention is not limited to the SQL statement. When a user wants to query service data by using other query languages except SQL (structured query language) sentences, the query sentence generation unit can automatically generate query sentences corresponding to query instructions based on preset query language grammar rules after acquiring query instructions which are input by the user and comprise fields to be queried only by inputting the grammar rules of the query languages into the query sentence generation unit in advance.
In step S105, the query statement is used to query the query report for the service data corresponding to the field to be queried, and the query result is output.
Specifically, the service data corresponding to "document number 001" is queried in the query report by using the query statement generated above, and the query result is output, as shown in table 2 below.
TABLE 2
Based on this, the query for the business data can be completed.
By applying the service data query method provided by the first embodiment of the invention, as a programmer only needs to input the query language grammar rule into the query statement generation unit in advance, the query statement generation unit can automatically generate the query statement corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction including the field to be queried input by the user. In the service data query method of the embodiment, only the step of generating the grammar rule of the query language needs the participation of SQL sentences or query sentences written by other query languages, so that the service data query method of the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
Example two
Fig. 2 shows a flow chart of a service data query method according to a second embodiment of the present invention.
As shown in fig. 2, the service data query method according to the second embodiment of the present invention mainly includes steps S101 to S107. Since steps S101 to S105 are the same as those of the first embodiment, the detailed description of steps S106 and S107 will be omitted.
In step S106, the query result is processed according to the data processing instruction input by the user.
Preferably, the data processing includes one or more of sorting, grouping, co-locating, and drilling.
Here, the packet includes an independent packet and a logical packet. Independent grouping refers to grouping the result data meeting the conditions into a group according to the data processing instruction input by the user. For example, when the user inputs a condition that "traffic cost is greater than 80", the data of the rows (i.e., the first row and the third row) where "traffic cost is 200" and "traffic cost is 100" in the query report form are divided into one group. Logical groupings are pointer pairs that are grouped into groups of identical data in the query result. For example, when the user inputs a condition that "accommodation amount is 200", data on a line (i.e., a first line and a second line) on which "accommodation amount is 200" in the query report is divided into one group.
Through carrying out data processing to the inquiry result, can make things convenient for the user to look over data, effectively improve work efficiency.
In step S107, rights are set for the query report according to the rights instruction input by the user.
Here, the sequence numbers of the above steps do not indicate the sequence of the steps, but are merely for convenience of description. For example, step S107 is performed after step S103 and before step S104, that is, after data binding is performed on each field in the query report, and before a query statement corresponding to the query instruction is generated, step S107 is performed.
Preferably, the rights include access rights and operation rights. Here, it should be noted that the operation authority is mainly used for controlling the operation of the user on the query report, for example, the operation of modifying, saving, submitting, printing, etc. the user may be controlled. In addition, the operation authority can also be used for controlling which data of the query report forms are operated by the user.
By setting the authority of the query report, the access and operation authority of the user can be flexibly controlled, and the security of the query report data is effectively ensured.
By applying the service data query method provided by the second embodiment of the invention, as a programmer only needs to input the query language grammar rule into the query statement generation unit in advance, the query statement generation unit can automatically generate the query statement corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction including the field to be queried input by the user. In the service data query method of the embodiment, only the step of generating the grammar rule of the query language needs the participation of SQL sentences or query sentences written by other query languages, so that the service data query method of the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
In addition, by processing the data of the query result and setting the authority of the query report, the working efficiency of the user can be effectively improved, and the safety of the query report data is ensured.
Correspondingly, the embodiment of the invention also provides a service data query system.
Example III
Fig. 3 is a schematic structural diagram of a service data query system according to a third embodiment of the present invention.
As shown in fig. 3, the service data query system according to the third embodiment of the present invention mainly includes: a form dataset creation unit 101, a query report creation unit 102, a data binding unit 103, a query statement generation unit 104, and a data query unit 105.
Specifically, the form data set creation unit 101 is configured to create a form data set, and to cause the data set to hold a plurality of associated data objects, a plurality of fields corresponding to each data object, and service data corresponding to each field.
Preferably, the data objects and fields are selected from the service database in response to a selection instruction entered by a user.
The query report creating unit 102 is configured to create a query report based on the data object and the field, and to save the query report with the field as a query item.
The data binding unit 103 is configured to bind, for each field in the query report, a cell in which the field is located in a row or a column and service data corresponding to the field in the form data set.
The query sentence generating unit 104 is configured to obtain a query instruction including a field to be queried input by a user, and automatically generate a query sentence corresponding to the query instruction based on a preset query language grammar rule.
And the data query unit 105 is configured to query the service data corresponding to the field to be queried in the query report by utilizing the query statement and output a query result.
The details of the operations in the above modules may be found in the above description of the method of the present invention with reference to fig. 1, and will not be described in detail herein.
By applying the service data query system provided by the third embodiment of the invention, due to the arrangement of the query statement generation unit, a programmer only needs to input the query language grammar rule into the query statement generation unit in advance, and the query statement generation unit can automatically generate the query statement corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction including the field to be queried input by the user. In the service data system of the embodiment, only the step of generating the grammar rule of the query language needs the participation of SQL sentences or query sentences written by other query languages, so that the service data query system of the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
Example IV
Fig. 4 is a schematic structural diagram of a service data query system according to a fourth embodiment of the present invention.
As shown in fig. 4, the service data query system according to the fourth embodiment of the present invention mainly includes: a form dataset creation unit 101, a query report creation unit 102, a data binding unit 103, a query statement generation unit 104, a data query unit 105, a data processing unit 106, and a right setting unit 107. Since the form dataset creation unit 101, the query report creation unit 102, the data binding unit 103, the query statement generation unit 104, and the data query unit 105 are the same as those of the third embodiment, the detailed description of the data processing unit 106 and the authority setting unit 107 is omitted.
The data processing unit 106 is configured to process data on the query result according to a data processing instruction input by a user.
Preferably, the data processing includes one or more of sorting, grouping, co-locating, and drilling.
Here, the packet includes an independent packet and a logical packet. Independent grouping refers to grouping the result data meeting the conditions into a group according to the data processing instruction input by the user. For example, when the user inputs a condition that "traffic cost is greater than 80", the data of the rows (i.e., the first row and the third row) where "traffic cost is 200" and "traffic cost is 100" in the query report form are divided into one group. Logical groupings are pointer pairs that are grouped into groups of identical data in the query result. For example, when the user inputs a condition that "accommodation amount is 200", data on a line (i.e., a first line and a second line) on which "accommodation amount is 200" in the query report is divided into one group.
And a permission setting unit 107 configured to set permissions for the query report according to permission instructions input by the user.
Here, it is to be noted that the authority setting unit 107 is connected to the data binding unit 103. After each field in the query report is bound with data, the permission is set for the query report according to the permission instruction input by the user.
Preferably, the rights include access rights and operation rights. Here, it should be noted that the operation authority is mainly used for controlling the operation of the user on the query report, for example, the operation of modifying, saving, submitting, printing, etc. the user may be controlled. In addition, the operation authority can also be used for controlling which data of the query report forms are operated by the user.
The details of the operations in the above modules may be found in the above description of the method of the present invention in conjunction with fig. 2, and will not be described in detail herein.
By applying the service data query system provided by the fourth embodiment of the invention, due to the arrangement of the query statement generation unit, a programmer only needs to input the query language grammar rule into the query statement generation unit in advance, and the query statement generation unit can automatically generate the query statement corresponding to the query instruction based on the preset query language grammar rule after acquiring the query instruction including the field to be queried input by the user. In the service data query system of the embodiment, only the step of generating the grammar rule of the query language needs the participation of SQL sentences or query sentences written by other query languages, so that the service data query system of the embodiment of the invention can effectively reduce the workload of programmers and improve the service data query efficiency.
In addition, by setting the data processing unit to realize data processing of the query result and setting the authority setting unit to realize authority setting of the query report, the working efficiency of the user can be effectively improved, and the safety of the query report data is ensured.
It will be appreciated by those skilled in the art that the modules or steps of the invention described above may be implemented in a general purpose computing device, they may be centralized on a single computing device, or distributed over a network of computing devices, or they may alternatively be implemented in program code executable by computing devices, such that they may be stored in a memory device and executed by computing devices, or they may be separately fabricated as individual integrated circuit modules, or multiple modules or steps within them may be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
Although the embodiments of the present invention are disclosed above, the embodiments are only used for the convenience of understanding the present invention, and are not intended to limit the present invention. Any person skilled in the art can make any modification and variation in form and detail without departing from the spirit and scope of the present disclosure, but the scope of the present disclosure is still subject to the scope of the present disclosure as defined by the appended claims.
Claims (10)
1. A business data query method, comprising:
creating a form data set, and enabling the data set to store a plurality of associated data objects, a plurality of fields corresponding to each data object, and service data corresponding to each field, wherein the data objects and the fields are selected from a service database in response to a selection instruction input by a user, the associated data objects and the plurality of fields corresponding to each data object are selected from the service database according to the selection instruction input by the user based on data which the user wants to display, each field corresponds to the service data, and the form data set is created based on the selected data objects, the fields corresponding to each data object, and the service data corresponding to each field;
creating a query report based on the data object and the field, and enabling the query report to store the field as a query item;
binding the unit grid of the row or the column of each field in the query report with the business data corresponding to the field in the form data set;
acquiring a query instruction which is input by a user and comprises a field to be queried, and automatically generating a query sentence corresponding to the query instruction based on a preset query language grammar rule;
and inquiring service data corresponding to the field to be inquired in the inquiry report by utilizing the inquiry statement, and outputting an inquiry result.
2. The service data query method of claim 1, further comprising: and processing the data of the query result according to the data processing instruction input by the user.
3. The business data query method of claim 2, wherein the data processing includes one or more of ordering, grouping, co-query, and drilling.
4. The service data query method of claim 1, further comprising: and setting the permission for the query report according to the permission instruction input by the user.
5. The service data query method according to claim 4, wherein the rights include access rights and operation rights.
6. A business data query system, comprising:
a form data set creation unit configured to create a form data set and store the data set with a plurality of associated data objects, a plurality of fields corresponding to each data object, and service data corresponding to each field, the data objects and the fields being selected from a service database in response to a selection instruction input by a user, the associated data objects and the plurality of fields corresponding to each data object being selected from the service database in accordance with a selection instruction input by the user based on data that the user wants to present, wherein each field corresponds to service data, and the form data set is created based on the selected data objects, the fields corresponding to each data object, and the service data corresponding to each field;
a query report creation unit configured to create a query report based on the data object and the field, and to store the query report with the field as a query item;
the data binding unit is configured to bind the unit grid of the row or the column of each field in the query report with the business data corresponding to the field in the form data set;
the query sentence generation unit is configured to acquire a query instruction which is input by a user and comprises a field to be queried, and automatically generate a query sentence corresponding to the query instruction based on a preset query language grammar rule;
and the data query unit is configured to query the service data corresponding to the field to be queried in the query report by utilizing the query statement and output a query result.
7. The business data query system of claim 6, further comprising: and the data processing unit is configured to process the data of the query result according to the data processing instruction input by the user.
8. The business data query system of claim 7, wherein the data processing includes one or more of ordering, grouping, co-indexing, and drilling.
9. The business data query system of claim 6, further comprising: and the permission setting unit is configured to set permissions for the query report according to permission instructions input by a user.
10. The business data query system of claim 9, wherein the rights include access rights and operational rights.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910662523.5A CN110597842B (en) | 2019-07-22 | 2019-07-22 | Service data query method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910662523.5A CN110597842B (en) | 2019-07-22 | 2019-07-22 | Service data query method and system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110597842A CN110597842A (en) | 2019-12-20 |
CN110597842B true CN110597842B (en) | 2023-10-03 |
Family
ID=68852873
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910662523.5A Active CN110597842B (en) | 2019-07-22 | 2019-07-22 | Service data query method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110597842B (en) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111309708B (en) * | 2020-02-16 | 2022-07-19 | 苏州浪潮智能科技有限公司 | Database read-only user data query method and device |
CN111476015B (en) * | 2020-04-10 | 2024-01-05 | 北京字节跳动网络技术有限公司 | Document processing method and device, electronic equipment and storage medium |
CN113760943A (en) * | 2020-06-16 | 2021-12-07 | 北京京东乾石科技有限公司 | Business report processing method and device |
CN111897856A (en) * | 2020-07-31 | 2020-11-06 | 平安普惠企业管理有限公司 | Supervision message generation method and device, electronic equipment and readable storage medium |
CN112052242B (en) * | 2020-09-02 | 2024-06-04 | 平安科技(深圳)有限公司 | Data query method, device, electronic equipment and storage medium |
CN112287647A (en) * | 2020-10-28 | 2021-01-29 | 中国农业银行股份有限公司 | Report processing method and system |
CN113342821B (en) * | 2021-06-29 | 2023-04-07 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
CN116611411A (en) * | 2023-07-20 | 2023-08-18 | 太平金融科技服务(上海)有限公司深圳分公司 | Business system report generation method, device, equipment and storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
CN109189799A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, computer equipment and storage medium |
CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7310637B2 (en) * | 2004-05-05 | 2007-12-18 | International Business Machines Corporation | Dynamic database access via standard query language and abstraction technology |
-
2019
- 2019-07-22 CN CN201910662523.5A patent/CN110597842B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
CN109189799A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Business datum querying method, device, computer equipment and storage medium |
Non-Patent Citations (1)
Title |
---|
基于字符串解析的智能查询方法及其应用;史国友等;《大连海事大学学报》;20050315(第01期);全文 * |
Also Published As
Publication number | Publication date |
---|---|
CN110597842A (en) | 2019-12-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110597842B (en) | Service data query method and system | |
US20210117437A1 (en) | Data model transformation | |
CN100555288C (en) | A kind of method and system of visiting distinct type data-base | |
US8812950B2 (en) | Spreadsheet software services | |
CN110543303A (en) | Visual business platform | |
CN106407170A (en) | Rapid generation method and system for data report | |
CN102779040A (en) | Method and device for generating user-defined form | |
CN104133772A (en) | Automatic test data generation method | |
US20060136810A1 (en) | Electronic form generator | |
CN105487864A (en) | Method and device for automatically generating code | |
CN106844307B (en) | System and method for converting Excel into Word based on mark | |
CN101308490A (en) | Dynamic report generation method and platform | |
US20150066977A1 (en) | Method and system for managing digital resources | |
CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
CN110781183B (en) | Processing method and device for incremental data in Hive database and computer equipment | |
CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
CN107403111A (en) | HIVE data desensitization method and device | |
CN108829884A (en) | data mapping method and device | |
CN110377892A (en) | A kind of government intelligence form templat designing system | |
CN103164573A (en) | Product data management (PDM) design system | |
US20030233343A1 (en) | System and method for generating custom business reports for a WEB application | |
Zhang et al. | Single-machine scheduling problems with a learning effect matrix | |
CN105468570B (en) | A kind of document synthesis methods of exhibiting and device | |
CN112825068B (en) | Data blood margin generation method and device | |
CN202143092U (en) | Message processing system |
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 |