CN116611411A - Business system report generation method, device, equipment and storage medium - Google Patents
Business system report generation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN116611411A CN116611411A CN202310890267.1A CN202310890267A CN116611411A CN 116611411 A CN116611411 A CN 116611411A CN 202310890267 A CN202310890267 A CN 202310890267A CN 116611411 A CN116611411 A CN 116611411A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- user
- generating
- data entity
- 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
- 238000000034 method Methods 0.000 title claims abstract description 50
- 238000003860 storage Methods 0.000 title claims abstract description 18
- 238000004590 computer program Methods 0.000 claims description 16
- 238000012795 verification Methods 0.000 claims description 10
- 238000004806 packaging method and process Methods 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 5
- 238000013515 script Methods 0.000 abstract description 4
- 238000004891 communication Methods 0.000 description 8
- 238000013075 data extraction Methods 0.000 description 8
- 238000012545 processing Methods 0.000 description 7
- 230000005540 biological transmission Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 238000013486 operation strategy Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000001953 sensory effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- 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)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a device, equipment and a storage medium for generating a business system report. Comprising the following steps: acquiring a data entity table of a service system, and carrying out data association on each data entity table to generate a query constructor, wherein the data entity table comprises service system data, and the query constructor comprises data corresponding relations of each data entity table; generating a search sentence according to the query condition input by the user; and generating a business system report according to the search statement and the query constructor. By acquiring a plurality of data entity tables of the business system, generating a query constructor by carrying out data association on each data entity table, generating a search statement according to query conditions input by a user, acquiring the business system report corresponding to the query conditions through the search statement and the query constructor, and acquiring the business system report without re-writing a script when the business system is changed, thereby saving manpower, improving the efficiency of generating the business system report and ensuring the timeliness of report generation.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a method, an apparatus, a device, and a storage medium for generating a business system report.
Background
Reporting forms are very important functions in enterprise applications, and reporting forms are important means for reflecting system operation conditions and enterprise business data.
At present, a third-party report plug-in or a report code is written purely manually to generate a report of a business system, no matter whether the third-party plug-in or the report code is written manually, structured query language scripts are required to be written in advance, the data volume of the business system is huge, script files are required to be rewritten when the business system is changed, a great deal of labor is required to be consumed, and timeliness of report generation is also influenced while the business report generation efficiency is reduced.
Disclosure of Invention
The invention provides a business system report generation method, a device, equipment and a storage medium, which are used for realizing the generation of a business system report meeting the requirements of users.
According to one aspect of the present invention, there is provided a business system report generation method, the method comprising:
acquiring a data entity table of a service system, and carrying out data association on each data entity table to generate a query constructor, wherein the data entity table comprises service system data, and the query constructor comprises data corresponding relations of each data entity table;
generating a search sentence according to the query condition input by the user;
and generating a business system report according to the search statement and the query constructor.
Optionally, acquiring a data entity table of the service system includes: configuring a data interface according to configuration information, wherein the configuration information comprises target time and target address; data extraction is carried out on the service system through a data interface so as to obtain mirror image reports of each service system, wherein the mirror image reports of the service system comprise service system data; and packaging the mirror image report forms of the service systems respectively to generate data entity forms.
Optionally, performing data association on each data entity table to generate a query constructor includes: determining the same field in each data entity table, and determining the related data corresponding to the same field in each data entity table; and establishing a corresponding relation of each related data according to the same field, and generating a query constructor according to the corresponding relation.
Optionally, before generating the search term according to the query condition input by the user, the method further includes: acquiring a query request of a user, wherein the query request comprises user identity information; matching the user identity information with a preset user authority table, and when the matching is successful, determining that the user identity verification is passed and generating a query menu for the user to check, wherein the user authority table contains the identity information of the legal registered user; query conditions entered by a user based on a query menu are received.
Optionally, generating the search statement according to the query condition input by the user includes: obtaining a structured query language template; the user-entered query terms are combined with the structured query language template to generate a search statement.
Optionally, generating the business system report according to the search statement and the query constructor includes: analyzing the search statement to obtain a target keyword contained in the search statement; screening the query constructor through target keywords to obtain target data matched with the search statement; and generating a business system report according to the target data.
Optionally, the method further comprises: matching the user identity identification information with a preset user authority list, and when the matching fails, determining that the user identity verification fails and generating an unauthorized prompt; and displaying the no-authority prompt to a user.
According to another aspect of the present invention, there is provided a business system report generating apparatus, the apparatus comprising:
the query constructor generating module is used for acquiring the data entity table of the service system and carrying out data association on each data entity table to generate a query constructor, wherein the data entity table comprises service system data, and the query constructor comprises data corresponding relations of each data entity table;
the search statement generation module is used for generating a search statement according to the query condition input by the user;
and the business system report generation module is used for generating a business system report according to the search statement and the query constructor.
According to another aspect of the present invention, there is provided an electronic apparatus including:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform a business system report generation method according to any one of the embodiments of the present invention.
According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to implement a business system report generation method according to any of the embodiments of the present invention when executed.
According to the technical scheme, the service system report corresponding to the query conditions can be obtained through the search statement and the query constructor by obtaining the plurality of data entity tables of the service system and carrying out data association on each data entity table to generate the query constructor, so that labor is saved, the efficiency of generating the service system report is improved, and the timeliness of generating the report is ensured.
It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of a business system report generation method according to a first embodiment of the present invention;
FIG. 2 is a flowchart of another business system report generation method according to the second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a business system report generating device according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device for implementing a business system report generating method according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "first," and the like in the description and the claims of the present invention and the above-described drawings are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
Fig. 1 is a flowchart of a method for generating a business system report according to an embodiment of the present invention, where the method may be applied to a case where a user queries data in a business system report, and the method may be performed by a business system report generating device, where the business system report generating device may be implemented in a form of hardware and/or software, and the business system report generating device may be configured in a computer. As shown in fig. 1, the method includes:
s110, obtaining data entity tables of the service system, and carrying out data association on each data entity table to generate a query constructor.
The business system refers to a system for an enterprise to operate and manage and the like to meet business requirements, and the types of the business system can include: sales and marketing information systems, manufacturing and production information systems, financial and meeting information systems, human resource information systems and the like, a large amount of business data of enterprises are stored in business systems, and reliable reference can be provided for the enterprises to find economic growth points and optimize operation strategies by analyzing the business systems. The data entity table comprises service system data, the number of the data entity table is multiple, and the different data entity tables comprise different scenes and different types of service system data in the service system; the query constructor is a data structure generated by carrying out data association on each data entity table, and comprises data corresponding relations of each data entity table.
Optionally, acquiring a data entity table of the service system includes: configuring a data interface according to configuration information, wherein the configuration information comprises target time and target address; data extraction is carried out on the service system through a data interface so as to obtain mirror image reports of each service system, wherein the mirror image reports of the service system comprise service system data; and packaging the mirror image report forms of the service systems respectively to generate data entity forms.
Specifically, the configuration data interface refers to an interface for data transmission between the service system and the controller, and the configuration information refers to information for parameter configuration of the configuration data interface; the configuration information comprises a target event and a target address, wherein the target time refers to data extraction time, and the target address refers to data extraction address. After the data interface is configured through the configuration information, the configuration data interface can perform data extraction on the service system at the target time and the target address, the extracted data are mirror image data of a service system report, namely, the service system mirror image report, the mirror image data are data extracted from a data bypass after a service system data transmission channel is divided into an original data transmission path and a data bypass, the data bypass comprises service system data which are the same as the original data transmission path, namely, the service system mirror image report, the mirror image data can be obtained through the data bypass, the influence on the original data transmission path can be avoided, and the normal operation of the service system is ensured. And each data entity table can be generated by packaging each service system mirror image report, and the data entity table stores mirror image data of the service system. It should be noted that, by setting the target time, the timing or real-time data extraction of the service system can be realized, and the developer can set according to the type of the service system or the requirement of the user, where the user refers to the person who needs to check the report form of the service system.
Furthermore, the target time may be a time interval, that is, the configuration data interface may periodically extract service system image data according to the target time, and update the data entity table after each extraction is completed, so as to ensure that the data has timeliness.
Optionally, performing data association on each data entity table to generate a query constructor includes: determining the same field in each data entity table, and determining the related data corresponding to the same field in each data entity table; and establishing a corresponding relation of each related data according to the same field, and generating a query constructor according to the corresponding relation.
Specifically, the query constructor refers to a data structure generated after data association is performed on each data entity table, the controller may determine the same field in each data entity table, determine relevant data corresponding to the same field in each data entity table, and then establish a correspondence of relevant data in each data entity table according to the same field to generate the query constructor, where, for example, the same field may be a user a, the height of the user a is stored in the data entity table 1, the weight of the user a is stored in the data entity table 2, and the query constructor may be generated by establishing a correspondence between the height and weight data of the user a in the data entity table 1 and the data entity table 2. Furthermore, after the data entity table is updated, the query constructor also updates the corresponding relation of the related data so as to ensure the timeliness of the data, and the query constructor can clean and reassemble the data to better meet the query requirement of a user.
It should be noted that, because the corresponding relation of the latest related data is stored in the query constructor, the user's requirement can be responded more quickly, and the report generation efficiency of the business system is improved.
S120, generating a search statement according to the query condition input by the user.
Optionally, before generating the search term according to the query condition input by the user, the method further includes: acquiring a query request of a user, wherein the query request comprises user identity information; matching the user identity information with a preset user authority table, and when the matching is successful, determining that the user identity verification is passed and generating a query menu for the user to check, wherein the user authority table contains the identity information of the legal registered user; query conditions entered by a user based on a query menu are received.
Specifically, when a user wants to query, a query request is sent to the controller, the query request includes user identification information, after the controller receives the query request, the user identification information is matched with a preset user permission table to determine whether the user identification information is in the preset user permission table, if yes, the user is provided with query conditions, at this time, the controller can call a preset query preview data structure to generate a query menu, the controller can send the query menu to a user terminal connected with the controller for the user to check, and the user can input the query conditions through the query menu. Further, the user can set a search rule and a display rule through the query menu, wherein the search rule can be a keyword, and the display rule comprises a data ordering mode.
Optionally, generating the search statement according to the query condition input by the user includes: obtaining a structured query language template; the user-entered query terms are combined with the structured query language template to generate a search statement.
Specifically, after the user inputs the query condition, the controller combines the query condition input by the user with a preset structured query language template (Structured Query Language, SQL) to generate a search sentence, and the search sentence can be matched with the service system data meeting the query condition of the user.
S130, generating a business system report according to the search statement and the query constructor.
Optionally, generating the business system report according to the search statement and the query constructor includes: analyzing the search statement to obtain a target keyword contained in the search statement; screening the query constructor through target keywords to obtain target data matched with the search statement; and generating a business system report according to the target data.
Specifically, the controller can extract target keywords contained in the search statement through the SQL parser, the target keywords comprise table alias keywords and field keywords, table objects can be generated through the table alias keywords, the query constructor can be screened through the field keywords to obtain target data matched with the search statement, the field objects can be generated according to the target data, the table objects and the field objects have corresponding relations, for example, when the field keywords are "month report", the table keywords are table templates corresponding to the "month report", the field objects are mounted on the table objects according to the corresponding relations and can be assembled into query constructor objects, and finally, a dynamic page is generated through the query constructor to display a business system report to a user, so that the problem that the business system report cannot be generated and displayed in real time according to the production environment in the past can be solved.
The query condition input by the user is "user a", the controller will combine the query condition with the structured query language to generate a search sentence, the SQL parser will parse the search sentence to extract the keywords therein, the corresponding relationship between "user a" and related data can be obtained through the query builder, the controller will generate a business system report according to "user a" and the height and weight data in the data entity table 1 and the data entity table 2, and then the business system report will be displayed to the user through the user terminal, where the user terminal includes, but is not limited to, mobile terminal devices such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), and PMPs (portable multimedia players). By establishing the query constructor, not only can the business system report be dynamically rendered in real time, but also an application program interface (Application Programming Interface, API) is supported to be generated for a third party system to call, and the authority access can be configured.
According to the technical scheme, the service system report corresponding to the query conditions can be obtained through the search statement and the query constructor by obtaining the plurality of data entity tables of the service system and carrying out data association on each data entity table to generate the query constructor, so that labor is saved, the efficiency of generating the service system report is improved, and the timeliness of generating the report is ensured.
Example two
Fig. 2 is a flowchart of a business system report generating method according to a second embodiment of the present invention, where a process of generating a non-authority prompt is added on the basis of the first embodiment. The specific contents of steps S210, S230-S240 are substantially the same as those of steps S110-S130 in the first embodiment, so that a detailed description is omitted in this embodiment. As shown in fig. 2, the method includes:
s210, acquiring a data entity table of the service system, and carrying out data association on each data entity table to generate a query constructor.
The data entity table comprises service system data, and the query constructor comprises data corresponding relations of the data entity table.
Optionally, acquiring a data entity table of the service system includes: configuring a data interface according to configuration information, wherein the configuration information comprises target time and target address; data extraction is carried out on the service system through a data interface so as to obtain mirror image reports of each service system, wherein the mirror image reports of the service system comprise service system data; and packaging the mirror image report forms of the service systems respectively to generate data entity forms.
Optionally, performing data association on each data entity table to generate a query constructor includes: determining the same field in each data entity table, and determining the related data corresponding to the same field in each data entity table; and establishing a corresponding relation of each related data according to the same field, and generating a query constructor according to the corresponding relation.
S220, acquiring a query request of a user, judging whether the user identity information is matched with a preset user authority table, if so, executing S230-S240, otherwise, executing S250.
Optionally, before generating the search term according to the query condition input by the user, the method further includes: acquiring a query request of a user, wherein the query request comprises user identity information; matching the user identity information with a preset user authority table, and when the matching is successful, determining that the user identity verification is passed and generating a query menu for the user to check, wherein the user authority table contains the identity information of the legal registered user; query conditions entered by a user based on a query menu are received.
S230, generating a search statement according to the query condition input by the user.
Optionally, generating the search statement according to the query condition input by the user includes: obtaining a structured query language template; the user-entered query terms are combined with the structured query language template to generate a search statement.
S240, generating a business system report according to the search statement and the query constructor.
Optionally, generating the business system report according to the search statement and the query constructor includes: analyzing the search statement to obtain a target keyword contained in the search statement; screening the query constructor through target keywords to obtain target data matched with the search statement; and generating a business system report according to the target data.
S250, determining that the user identity verification fails and generating an unauthorized prompt; and displaying the no-authority prompt to a user.
Specifically, when the user identity information cannot be matched with the preset user authority table, the user is represented to have no access authority, at the moment, the controller determines that the user identity verification fails and generates an unauthorized prompt, and then the unauthorized prompt is displayed to the user, and at the moment, the user cannot acquire the business system report. Because the service data of the service system has privacy, by setting the user authority list, irrelevant personnel can be prevented from maliciously acquiring the service system data, and the safety of the service system data is further ensured.
According to the technical scheme, the multiple data entity tables of the business system are obtained, the query constructor is generated by carrying out data association on the data entity tables, the search statement is generated according to the query condition input by the user, the business system report corresponding to the query condition can be obtained through the search statement and the query constructor, the business system report can be obtained without re-writing a script when the business system is changed, manpower is saved, the efficiency of generating the business system report is improved, the timeliness of generating the report is ensured, the permission of the user can be confirmed through the query request, malicious acquisition of the business system data by irrelevant personnel can be avoided, and the data safety of the business system is further ensured.
Example III
Fig. 3 is a schematic structural diagram of a report generating device for a business system according to a third embodiment of the present invention. As shown in fig. 3, the apparatus includes: a query constructor generating module 310, configured to obtain a data entity table of the service system, and perform data association on each data entity table to generate a query constructor, where the data entity table includes service system data, and the query constructor includes a data correspondence of each data entity table; a search sentence generation module 320, configured to generate a search sentence according to a query condition input by a user; the business system report generation module 330 is configured to generate a business system report according to the search statement and the query builder.
Optionally, the query builder generation module 310 specifically includes: a data entity table acquisition unit for: configuring a data interface according to configuration information, wherein the configuration information comprises target time and target address; data extraction is carried out on the service system through a data interface so as to obtain mirror image reports of each service system, wherein the mirror image reports of the service system comprise service system data; and packaging the mirror image report forms of the service systems respectively to generate data entity forms.
Optionally, the query builder generation module 310 specifically includes: a query constructor generating unit configured to: determining the same field in each data entity table, and determining the related data corresponding to the same field in each data entity table; and establishing a corresponding relation of each related data according to the same field, and generating a query constructor according to the corresponding relation.
Optionally, the apparatus further comprises: the user permission matching module is used for: acquiring a query request of a user, wherein the query request comprises user identity information; matching the user identity information with a preset user authority table, and when the matching is successful, determining that the user identity verification is passed and generating a query menu for the user to check, wherein the user authority table contains the identity information of the legal registered user; query conditions entered by a user based on a query menu are received.
Optionally, the search term generation module 320 is specifically configured to: obtaining a structured query language template; the user-entered query terms are combined with the structured query language template to generate a search statement.
Optionally, the business system report generation module 330 is specifically configured to: analyzing the search statement to obtain a target keyword contained in the search statement; screening the query constructor through target keywords to obtain target data matched with the search statement; and generating a business system report according to the target data.
Optionally, the apparatus further comprises: the no-authority prompting module is used for: matching the user identity identification information with a preset user authority list, and when the matching fails, determining that the user identity verification fails and generating an unauthorized prompt; and displaying the no-authority prompt to a user.
According to the technical scheme, the service system report corresponding to the query conditions can be obtained through the search statement and the query constructor by obtaining the plurality of data entity tables of the service system and carrying out data association on each data entity table to generate the query constructor, so that labor is saved, the efficiency of generating the service system report is improved, and the timeliness of generating the report is ensured.
The business system report generating device provided by the embodiment of the invention can execute the business system report generating method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the executing method.
Example IV
Fig. 4 shows a schematic diagram of the structure of an electronic device 10 that may be used to implement an embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.
As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.
Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.
The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as a business system report generation method.
In some embodiments, a business system report generation method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. One or more of the steps of a business system report generation method described above may be performed when the computer program is loaded into RAM 13 and executed by processor 11. Alternatively, in other embodiments, processor 11 may be configured to perform a business system report generation method by any other suitable means (e.g., by means of firmware). Namely: acquiring a data entity table of a service system, and carrying out data association on each data entity table to generate a query constructor, wherein the data entity table comprises service system data, and the query constructor comprises data corresponding relations of each data entity table; generating a search sentence according to the query condition input by the user; and generating a business system report according to the search statement and the query constructor.
Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.
A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.
In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.
The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.
The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.
It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (10)
1. A business system report generation method is characterized by comprising the following steps:
acquiring a data entity table of a service system, and carrying out data association on each data entity table to generate a query constructor, wherein the data entity table comprises service system data, and the query constructor comprises data corresponding relations of each data entity table;
generating a search sentence according to the query condition input by the user;
and generating a business system report according to the search statement and the query constructor.
2. The method of claim 1, wherein the obtaining a data entity table of the service system comprises:
configuring a data interface according to configuration information, wherein the configuration information comprises target time and target address;
the data of the service system is extracted through the data interface to obtain mirror image reports of each service system, wherein the mirror image reports of the service system comprise service system data;
and packaging each service system mirror image report to generate each data entity table.
3. The method of claim 1, wherein said data correlating each of said data entity tables to generate a query builder comprises:
determining the same field in each data entity table, and determining related data corresponding to the same field in each data entity table;
and establishing a corresponding relation of each related data according to the same field, and generating the query constructor according to the corresponding relation.
4. The method of claim 1, further comprising, prior to said generating a search term based on the query criteria entered by the user:
acquiring a query request of a user, wherein the query request comprises user identity information;
matching the user identity information with a preset user authority table, and when the matching is successful, determining that the user identity verification is passed and generating a query menu for the user to check, wherein the user authority table contains the identity information of the legal registered user;
the query condition input by the user based on the query menu is received.
5. The method of claim 4, wherein generating a search term based on the query conditions entered by the user comprises:
obtaining a structured query language template;
the user-entered query terms are combined with the structured query language template to generate the search statement.
6. The method of claim 1, wherein the generating a business system report from the search statement and the query builder comprises:
analyzing the search statement to obtain a target keyword contained in the search statement;
screening the query constructor through the target keywords to obtain target data matched with the search statement;
and generating the business system report according to the target data.
7. The method according to claim 4, wherein the method further comprises:
matching the user identity information with a preset user authority list, and when the matching fails, determining that the user identity verification fails and generating an unauthorized prompt;
and displaying the non-authority prompt to a user.
8. A business system report generating device, comprising:
the query constructor generating module is used for acquiring data entity tables of the service system and carrying out data association on the data entity tables to generate a query constructor, wherein the data entity tables comprise service system data, and the query constructor comprises data corresponding relations of the data entity tables;
the search statement generation module is used for generating a search statement according to the query condition input by the user;
and the business system report generation module is used for generating a business system report according to the search statement and the query constructor.
9. An electronic device, the electronic device comprising:
at least one processor; and
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the method of any one of claims 1-7.
10. A computer storage medium storing computer instructions for causing a processor to perform the method of any one of claims 1-7 when executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310890267.1A CN116611411A (en) | 2023-07-20 | 2023-07-20 | Business system report generation method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310890267.1A CN116611411A (en) | 2023-07-20 | 2023-07-20 | Business system report generation method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116611411A true CN116611411A (en) | 2023-08-18 |
Family
ID=87680414
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310890267.1A Pending CN116611411A (en) | 2023-07-20 | 2023-07-20 | Business system report generation method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116611411A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117331926A (en) * | 2023-12-01 | 2024-01-02 | 太平金融科技服务（上海）有限公司 | Data auditing method and device, electronic equipment and storage medium |
| CN117892762A (en) * | 2024-03-14 | 2024-04-16 | 临沂美联重工有限公司 | Basic data query system and method for skid steer loader |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667966A (en) * | 2009-06-11 | 2010-03-10 | 中兴通讯股份有限公司 | Method and system for realizing far-end mirror image of router |
| US20170109435A1 (en) * | 2016-07-15 | 2017-04-20 | Hisense Co., Ltd. | Apparatus and method for searching for information |
| CN110597842A (en) * | 2019-07-22 | 2019-12-20 | 石化盈科信息技术有限责任公司 | Service data query method and system |
-
2023
- 2023-07-20 CN CN202310890267.1A patent/CN116611411A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101667966A (en) * | 2009-06-11 | 2010-03-10 | 中兴通讯股份有限公司 | Method and system for realizing far-end mirror image of router |
| US20170109435A1 (en) * | 2016-07-15 | 2017-04-20 | Hisense Co., Ltd. | Apparatus and method for searching for information |
| CN110597842A (en) * | 2019-07-22 | 2019-12-20 | 石化盈科信息技术有限责任公司 | Service data query method and system |
Non-Patent Citations (1)
| Title |
|---|
| 中国计算机学会计算机安全专业委员会: "信息与网络安全研究新进展 全国计算机安全学术交流会论文集 第25卷", 30 November 2020, 合肥：中国科学技术大学出版社, pages: 413 - 99 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117331926A (en) * | 2023-12-01 | 2024-01-02 | 太平金融科技服务（上海）有限公司 | Data auditing method and device, electronic equipment and storage medium |
| CN117331926B (en) * | 2023-12-01 | 2024-03-01 | 太平金融科技服务（上海）有限公司 | Data auditing method and device, electronic equipment and storage medium |
| CN117892762A (en) * | 2024-03-14 | 2024-04-16 | 临沂美联重工有限公司 | Basic data query system and method for skid steer loader |
| CN117892762B (en) * | 2024-03-14 | 2024-05-24 | 临沂美联重工有限公司 | Basic data query system and method for skid steer loader |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN116611411A (en) | Business system report generation method, device, equipment and storage medium | |
| CN111444287B (en) | Graph database construction method, associated information query method, device and computing equipment | |
| CN115587575A (en) | Data table creation method, target data query method, device and equipment | |
| CN108959294B (en) | Method and device for accessing search engine | |
| CN116932214A (en) | Instruction sending method and device, electronic equipment and computer storage medium | |
| CN115550413A (en) | Data calling method and device, service gateway and storage medium | |
| CN115454971A (en) | Data migration method and device, electronic equipment and storage medium | |
| CN113535768A (en) | Production monitoring method and device | |
| CN116566737B (en) | Permission configuration method and device based on SaaS platform and related equipment | |
| CN117076332B (en) | Test case testing method and device, electronic equipment and storage medium | |
| CN117150215B (en) | Assessment result determining method and device, electronic equipment and storage medium | |
| CN115840604B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN113220710B (en) | Data query method, device, electronic equipment and storage medium | |
| CN113297087A (en) | Test method and device | |
| CN117494216A (en) | Configuration method, device, equipment and medium of sensitive information | |
| CN118051670A (en) | Service recommendation method, device, equipment and medium | |
| CN114329197A (en) | Method, electronic device and program product for feeding back target data to user terminal | |
| CN117670236A (en) | Mobile-terminal-based to-be-handled flow approval method, device, equipment and medium | |
| CN114428891A (en) | Network resource processing method, device, system, equipment and storage medium | |
| CN116523325A (en) | Configuration method, device, equipment and medium of operation strategy | |
| CN117493443A (en) | Data processing method and device, electronic equipment and readable storage medium | |
| CN114936246A (en) | Redis data management method, device, equipment, storage medium and product | |
| CN116644223A (en) | Data query method, device, equipment and readable medium | |
| CN116319716A (en) | Information processing method, no-service system, electronic device, and storage medium | |
| CN116382640A (en) | Method, device, equipment and storage medium for managing micro-service |
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 |