CN117934028A

CN117934028A - Processing method and system based on business data, computer equipment and storage medium

Info

Publication number: CN117934028A
Application number: CN202311764157.7A
Authority: CN
Inventors: 舒伟; 郭曼丽; 王静俊
Original assignee: Guangzhou Yangwang Xingkong Cloud Technology Co ltd
Current assignee: Guangzhou Yangwang Xingkong Cloud Technology Co ltd
Filing date: 2023-12-20
Publication date: 2024-04-26

Abstract

The application provides a processing method and a processing system based on service data, a computer device and a storage medium, wherein the processing method comprises the following steps: receiving a service analysis request; determining to acquire service data according to the service analysis request; inputting the service data and the service analysis request into a preset reporting calculation model, so that the preset reporting calculation model analyzes the service data and outputs an analysis result; and determining the associated data of the service according to the analysis result. The application analyzes and processes the business data by utilizing the preset report calculation model to determine the related data of the business, thereby avoiding the problem of slower efficiency of processing the business related data due to the need of manually processing a large amount of data to a certain extent, and having the advantages of high efficiency, high precision and high safety of processing the business related data.

Description

Processing method and system based on business data, computer equipment and storage medium

Technical Field

The invention relates to the technical field of artificial intelligence analysis data, in particular to a processing method and system based on service data, computer equipment and a storage medium.

Background

Business data refers to various data produced by an enterprise in performing business operations and management processes, including, but not limited to, customer data, sales data, inventory data, financial data, and the like. The data records daily business activities, transaction records and various business indexes of the enterprise, and has important significance for decision making and operation management of the enterprise.

Business data can help enterprises to know the demands and preferences of clients, so that products and services can be better positioned, market competitiveness is improved, and the enterprises can formulate more accurate sales strategies and product strategies by analyzing sales data, client data and the like, and sales efficiency and income are improved. Thus, businesses often need to sort and analyze business data over a period of time. And under different business data of enterprises, associating a plurality of businesses, and analyzing the associated business data to determine the relation between the businesses. In the prior art, if an enterprise needs to analyze the data connection between a service and another service, excel is used for data statistics analysis, and a large amount of data is usually required to be manually input and processed, so that the problem of slower efficiency of processing the service related data exists.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a processing method and system based on service data, a computer device, and a storage medium.

A business data based processing method, comprising:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

Inputting the service data and the service analysis request into a preset reporting calculation model, so that the preset reporting calculation model analyzes the service data and outputs an analysis result;

And determining the associated data of the service according to the analysis result.

In an embodiment, the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and before outputting the analysis result, the method further includes:

acquiring a preset analysis function and acquiring a data association expression of each service;

And constructing a preset report calculation model according to the preset analysis function and the data association expression of each service.

In an embodiment, before determining to acquire service data according to the service analysis request, the method further includes:

Analyzing the service analysis request to obtain a request analysis identifier;

detecting whether the request analysis identifier accords with a preset effective identifier;

When the request analysis identifier accords with the preset effective identifier, determining to acquire service data according to the service analysis request;

and when the request analysis identifier does not accord with the preset effective identifier, generating a service analysis request to fail.

In an embodiment, before the receiving the service analysis request, the method further includes:

receiving a service creation request, and analyzing the service creation request to obtain a service creation identifier;

And creating a corresponding service database according to the creation identifier.

In an embodiment, the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and outputs an analysis result, including:

analyzing the analysis request to obtain an analysis function, and processing the analysis function by using a regular expression to obtain an analysis function to be used;

Inputting the business data and the analysis function to be used into a preset reporting calculation model, so that the preset reporting calculation model detects whether the analysis function to be used is matched with the preset analysis function;

When the analysis function to be used is matched with the preset analysis function, determining the analysis function to be used as a target analysis function, analyzing the service data by utilizing the target analysis function through the preset reporting calculation model, and outputting an analysis result.

In an embodiment, the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and after outputting the analysis result, the method further includes:

Setting a report form template, wherein the report form template comprises a report form identifier, a report form name and a report form data source;

And extracting corresponding data from the analysis result, filling the data into the report table template, and visualizing the report table template.

In an embodiment, after extracting the corresponding data from the analysis result and filling the extracted corresponding data into the report table template and visualizing the report table template, the method further includes:

detecting whether the residence time of a cursor on the report table template at a preset hovering position is longer than preset time or not;

And when the stay time of the cursor at the preset hovering position is longer than the preset time, determining the visualized content at the hovering position according to the hovering position, and annotating and displaying the content.

A second aspect of the present application provides a service data based processing system, comprising:

The first receiving module is used for receiving a service analysis request;

the first determining module is used for determining to acquire service data according to the service analysis request;

The analysis module is used for inputting the service data and the service analysis request into a preset reporting calculation model so that the preset reporting calculation model analyzes the service data and outputs an analysis result;

And the second determining module is used for determining the associated data of the service according to the analysis result.

A third aspect of the application provides a computer device comprising a memory and a processor, said memory storing a computer program, characterized in that said processor when executing said computer program performs the steps of:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

The steps of the business data based processing method described in any of the above embodiments are implemented when the processor executes the computer program.

A fourth aspect of the present application provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

The computer program when executed by a processor implements the steps of the traffic data based processing method described in any of the embodiments above.

The technical scheme provided by the application can comprise the following beneficial effects:

Receiving a service analysis request; determining to acquire service data according to the service analysis request; inputting the service data and the service analysis request into a preset reporting calculation model, so that the preset reporting calculation model analyzes the service data and outputs an analysis result; and determining the associated data of the service according to the analysis result. The service data is analyzed and processed by using the preset reporting calculation model to determine the associated data of the service, so that the problem of low efficiency of processing the service associated data due to the fact that a large amount of data needs to be manually processed is solved to a certain extent, and the method has the advantages of high efficiency, high accuracy and high safety of processing the service associated data.

Drawings

FIG. 1 is a flow diagram of a business data based processing method in one embodiment;

FIG. 2 is a schematic diagram of a processing system based on business data in one embodiment;

FIG. 3 is a schematic diagram of the internal architecture of a computer device in one embodiment;

FIG. 4 is a logical schematic diagram of a business data table design of a database in one embodiment;

FIG. 5 is a schematic diagram of a page displaying an annotation page in one embodiment.

Detailed Description

The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.

Example 1

Referring to fig. 1, an embodiment of a processing method based on service data in an embodiment of the present application includes:

step 100, receiving a service analysis request;

In the embodiment of the application, the service analysis request can also be an application analysis request, and when a user needs to analyze data connection between a service/application and another service/application or analyze service data, the service analysis request needs to be sent to the system through the input device; at this point, the system receives a traffic analysis request. The service analysis request comprises a parameter to be queried, wherein the parameter to be queried is a service identifier of a service to be analyzed.

In this embodiment, the service analysis request may include a service identifier of a service to be analyzed; the service analysis request may further include a service identifier of the service to be analyzed, and the analysis request identifier is not specifically limited herein.

Step 110, determining to acquire service data according to the service analysis request;

In this embodiment, the system stores related data of each service. As shown in fig. 4 to 5, table construction logic in the system for storing related data of services or applications sequentially fills the related data of services or applications into corresponding tables according to a table form to form corresponding service data tables, where the corresponding service data tables are stored in corresponding databases (i.e. one service/application corresponds to one database). For example, if the system includes a first service/application and a second service/application, the first service/application data is stored in the first service/application database, and the second service/application is stored in the second service/application database.

And after the service request is analyzed, a service identifier can be obtained, a corresponding database is determined according to the service identifier, and corresponding service data is queried in the determined database so as to obtain the service data.

For example, when the service analysis request analysis determines that the service identifier is the first service, the first service identifier database is searched according to the first service identifier, and the first service identifier database is searched for the required first service part/all data.

In this embodiment, the business data may include order data, inventory data, transaction data, and basic information describing the customer, and may also include other business related data, which is not specifically limited herein.

In this embodiment, the service data is determined by the service identifier in the service analysis request, so as to ensure the accuracy of the adopted service data to a certain extent.

Step 120, inputting the service data and the service analysis request into a preset reporting calculation model, analyzing the service data by using the preset reporting calculation model, and outputting an analysis result;

After the service data is obtained in the step 110, the service data can be stored in an Excel table for convenient storage, and the service data is stored in a structured manner, so that the structure and the relation of the data can be clearly displayed, and the data processing and analysis are convenient; meanwhile, the working efficiency of inputting the service data into the preset calculation model can be improved, the accuracy and reliability of the data are ensured to a certain extent, and the service data are convenient to maintain.

In this embodiment, the service data is input into a preset reporting calculation model in the form of being stored in an excel table, and then the analysis request is also input into the preset reporting calculation model. Analyzing the analysis request by a preset reporting calculation model to obtain an analysis function required to be utilized by a user, and processing the analysis function through a regular expression to determine the analysis function to be used. When determining that the analysis function to be used is determined in the preset reporting machine selection model, the preset reporting calculation model further analyzes the service data by using the analysis function to be used so as to obtain a corresponding analysis result, and outputs the analysis result.

In this embodiment, the preset report calculation model is further provided with a data association expression of each service.

In this embodiment, the preset report calculation model may be a weighted average model or a machine learning model, which is not specifically limited herein.

And 130, determining the associated data of the service according to the analysis result.

After the analysis result is output in a preset report calculation model, determining the associated data of the service according to the analysis result requires determining the source, the data type, the data definition and the like of the data in the analysis result; and further, the data sources, the data types and the data definitions in the analysis result are subjected to descriptive statistics, association analysis, regression analysis or other processes so as to determine the association and rule among the data in the analysis result.

The beneficial effects achieved in the embodiment of the application are as follows:

1. In this embodiment, a service analysis request is received; determining to acquire service data according to the service analysis request; inputting the service data and the service analysis request into a preset reporting calculation model, so that the preset reporting calculation model analyzes the service data and outputs an analysis result; and determining the associated data of the service according to the analysis result. The application analyzes and processes the business data by utilizing the preset report calculation model to determine the related data of the business, thereby avoiding the problem of slower efficiency of processing the business related data due to the need of manually processing a large amount of data to a certain extent, and having the advantages of high efficiency, high precision and high safety of processing the business related data.

Customizing: autonomous development means that enterprises can design and customize financial reporting systems according to their own needs and business processes. Thus, the system can be ensured to be completely matched with the specific requirements and the workflow of the enterprise, and the working efficiency is improved.

Third, data security control: by establishing services and maintaining data on internal servers, enterprises are able to better control and protect the security of financial data. Compared with the use of third party software or cloud services, the internal server can provide higher data privacy and security, and reduce risks of data leakage and infringement.

Network independence: the financial reporting system established using the internal server is independent of external network connections. This means that the system can continue to run and access data even if the network is interrupted or affected by other external factors, ensuring continued availability of financial information for the enterprise.

5. Cost control: autonomously developing a financial reporting system can help enterprises reduce software licensing and usage costs. Compared with purchasing business software or subscribing cloud services, enterprises only need to put into development and maintenance resources, and long-term operation cost is reduced.

6. Adaptivity: enterprises can flexibly adjust and upgrade according to business requirements by independently developing the financial statement system. As businesses evolve and change, new functionality may be added, interfaces modified, or system capacity expanded as needed to accommodate changing financial management needs.

Example two

In this embodiment, another embodiment of the processing method based on service data in the embodiment of the present application includes:

Step 200, receiving a service creation request, and analyzing the service creation request to obtain a service creation identifier;

in this embodiment, when a user opens or prepares to open a service, an input device is used to input a service creation request to the system, where the service creation request includes a service creation identifier, a service creation requirement, and a service right. After the system receives the service creation request, the system analyzes the service creation request to obtain the service creation identifier, the service creation requirement and the service authority. Specific:

1. Receiving a request: receiving a service creation request from an input device, wherein the service creation request comprises a service creation request method, a service creation request path, a service creation request header and a service creation request body; the service creation request body comprises information such as a service creation identifier, a service creation requirement, a service authority and the like.

2. Resolving a request: analyzing the received request, extracting key information in the request, wherein the extracted key information comprises a request path, a service creation identifier, a service creation requirement, a service authority and the like.

The system records the whole process, including request information, processing process, result and the like, while analyzing the service creation request so as to facilitate subsequent monitoring, debugging and auditing; handling of abnormal situations, logging, etc., to ensure availability and stability of the system.

And step 201, creating a corresponding service database according to the creation identifier.

After the service creation identifier is acquired, a corresponding service database is created by using the service creation identifier. Specifically, the name of the database is set by the service creation identifier, and then a table corresponding to the service is created for the database. Such that each service or application has an independent database.

For example, after parsing the service creation request, the routing process is further performed: and routing the request to a corresponding processing program or resource according to the information such as the path and the parameters of the request. And then processing the request: and according to the routing result, executing service processing logic or calling corresponding service to process the request to construct a corresponding service database.

As shown in fig. 4, after the service database is constructed, a table of service corresponding functions is added in the database. The design logic of the business data table of the database comprises additional data and endorsements. The additional data comprises judging whether the corresponding element unit data in the service data table has marks or files; when a mark or fill exists, data can be additionally imported; in the process of importing additional data, firstly inquiring whether the data to be updated is two or more, and when only one piece of data is inquired, directly adding the data to update the service data table; when no mark or fill is present, the data is imported directly.

In this embodiment, the stored annotation logic in the service data table is:

The annotations include old annotations, periodic annotations, and imported data annotations. The old annotations comprise non-time period annotations and time period annotations, the non-time period annotations are placed in the static data table, and the time period annotations are stored in another static data table. The periodic annotation is to record annotation information first and then to import the recorded annotation information into the corresponding table; and importing the data annotation into the original data table for record preservation, and finally importing the data in the original data table into the corresponding database table.

In this embodiment, the process of importing the data annotation in the correspondence table includes:

1. an annotation field is determined, and whether the annotation field exists is detected.

2. When the annotation field is present in the table. And analyzing the service identification of the formula.

3. And inquiring all the data according to the service identification, performing de-duplication processing on all the data, and splicing the annotation field content.

In this embodiment, when visualization is performed, the import data annotation priority is greater than the periodic annotation priority, which is greater than the old annotation priority. For example: when the periodic annotation does not exist, the corresponding old annotation is visualized; when the period annotation exists, the period annotation is visualized.

A table, i.e. a data source. The page can manage the field, and the data can be imported through the page and added in batches. Data is added to the correspondence table, for example:

the service correspondence table may be as shown in table 1:

TABLE 1

Belongs to the month	Collection/payment	Money item	First exchange Rate	Second exchange rate	Third exchange Rate
						date	TradeType	cionType	Exrate-1	Exrate-2	Exrate-3
t	s	s	f	f	f
						Mark	Fill	Fill	Fill	Mark	Mark
2023.2.28	Collecting money	Renminbi (RMB)	1.00	2.00	2.00
						2023.2.28	Payment	Renminbi (RMB)	1.00	4.00	4.00
2023.2.28	Collecting money	Renminbi (RMB)	16666.00	5.00	5.00

1. Data are imported in table 1 above:

custom lines: the first row represents field remarks, the second row represents table fields, and the third row represents field types. The supported types are t time, s character string and f floating point type.

2. Data is added. On the basis of the import, a fourth line is added to indicate whether to add an update, the field of mark is used as a sphere condition, and the field of fill mark is used as data to be updated.

3. Annotating. An annotation is an annotation that serves as an interpretation of the presentation report data. The annotation of each summary data is based on a combination of annotations of all the detail data from which this summary data was counted.

Each service or application has an independent database such that the degree of coupling between the services or applications is reduced. Each business or application can be independently developed, deployed and maintained without relying on other applications. Each service or application has an independent database, and can be better evolved and expanded autonomously. The team can independently decide the mode, type, structure, etc. of the database without being affected by other applications. The independent database can better protect the security and privacy of the data because each business or application has independent database access rights and data encryption measures. The independent database can better support the expansibility of the application. Each application can independently expand the capacity and performance of the database according to its own needs and load conditions to meet the ever-increasing business needs.

Step 202, receiving a service analysis request;

In this embodiment, step 202 is similar to step 100 in the above embodiment, and is not repeated here.

Step 203, analyzing the service analysis request to obtain a request analysis identifier;

In order to ensure the validity and security of the service analysis request to a certain extent, that is, the source and identity of the service analysis request can be verified through authentication, unauthorized users or entities are prevented from accessing sensitive data or performing sensitive operations, and only authorized users or entities can access restricted data.

Therefore, when the system receives the service analysis request, the service analysis request needs to be parsed to obtain the corresponding request analysis identifier, where the request analysis identifier includes the request identity, the request page identifier, and the routing information, and provides a data basis for the detection in step 204.

Step 204, detecting whether the request analysis identifier accords with a preset effective identifier; when the request analysis identifier does not conform to the preset valid identifier, executing step 205; when the request analysis identifier meets the preset valid identifier, step 206 is executed.

In this embodiment, the preset valid identifier is an authorized identifier, that is, if the user has operation or inquiry or analysis authority on the page, the user identity is determined to be the preset valid identifier. The preset effective identifiers comprise all user identities with certain page information, and the user identities are stored in a preset effective identifier table. As shown in the preset valid identification table (table 2).

TABLE 2

As can be seen from the above table 2, when the request identity, the request page and the routing information extracted from the analysis identifier in the service analysis request are in one-to-one correspondence with those in table 1, it can be determined whether the analysis identifier meets the preset valid identifier, and when the system determines that the request analysis identifier does not meet the preset valid identifier, it indicates that the service analysis request has passed the own authority, and step 205 is executed; when the system determines that the request analysis identifier meets the preset valid identifier, it indicates that the service analysis request is within the authority of the user identity, and step 206 is performed.

For example, the system authenticates the request for each page, each request needs to carry the parameter service ID/application ID. When authentication is carried out, firstly checking whether a user logs in, if so, caching all menus, then checking the service/application authority, and finally checking whether the page has the authority.

In this embodiment, the effective identifier may be 1 or true; the present invention is not particularly limited herein.

Step 205, generating a service analysis request fails.

To ensure that the requestor is entitled to access the requested data or perform the requested operation, it helps to protect the confidentiality and integrity of the data, preventing the data from being compromised or tampered with. When the request for business analysis has passed the authority of the user identity, the user identity is not authorized to acquire the result of business analysis, and the system directly informs the user that the request has no authority.

Step 206, determining to acquire service data according to the service analysis request;

in this embodiment, step 206 is similar to step 110 in the above embodiment, and is not repeated here.

Step 207, acquiring a preset analysis function and collecting data association expressions of each service;

the data to be reported can be rapidly calculated and analyzed through the preset reporting calculation model, so that the time for manually calculating and arranging the data is shortened, and the reporting efficiency is further improved. And the analysis function and rules are defined by the preset reporting calculation model to calculate and analyze the data, so that human errors and subjective speculation are avoided to a certain extent, and the accuracy of the data is ensured as much as possible.

In this embodiment, the preset report calculation model includes at least one preset report table, and the preset report table is used to store the service data input into the preset report calculation model. The preset report table comprises preset report table identifiers, preset report table fields and preset report table unit cells. Wherein, the preset analysis function is set according to the preset report table field and the preset report table unit cell.

Specifically, setting the analysis functions of the first cells and the second cells in the preset report table as summation analysis functions, determining the first fields corresponding to the first cells and the second fields corresponding to the second cells in the preset report table, and combining the first fields and the second fields with the summation functions to form the summation analysis functions.

For example, when the first field is "a", the second field is "B", and the summation function is sum (x, y), then the summation analysis function is sum (a, B).

In this embodiment, after the preset analysis function is set, the data association expression of each service needs to be further acquired, so as to provide a data base for step 214.

In this embodiment, the service association data may be obtained from a local database of the system, or may be obtained from a user through an input device, which is not limited herein.

In this embodiment, the preset analysis function may include at least one analysis function of a summing function, a conditional summing function, an averaging function, a conditional averaging function, a maximum taking function, a minimum taking function, a counting function, a conditional counting function, a deduplication counting function, or a conditional deduplication counting function, and may further include other analysis functions, which are not specifically limited herein.

And step 208, constructing a preset reporting calculation model according to the preset analysis function and the data association expression of each service.

In order to improve accuracy and reliability of data, eliminate data loss, reduce redundant information, and unify data formats, so that the data is easier to analyze, ensure consistency of the data, reduce data processing cost, and the like, the preset analysis function and the acquired service related data are cleaned and arranged before a preset report calculation model is constructed, so that usability of the preset analysis function and the service related data is ensured.

In this embodiment, a weighted average model is used to construct a basic preset reporting calculation model, and the detailed process of constructing the preset reporting calculation model is as follows:

1. determining weights: first, a weight for each data item needs to be determined.

2. Calculating a weighted average: each data item is multiplied by its corresponding weight and the results are added to obtain a weighted average.

3. Determining an initial preset reporting calculation model, and fusing a corresponding preset analysis function and a data association expression of each service into the initial preset reporting calculation model to form the preset reporting calculation model.

For example, if there is a set of data {2,3,4,5}, the corresponding weight is {0.1,0.2,0.3,0.4}, the weighted average is calculated as: (20.1+30.2+40.3+50.4)/(0.1+0.2+0.3+0.4).

In this embodiment, the determining weights in the preset report calculation model may be determined according to factors such as importance, time interval, or frequency of the data items.

In this embodiment, the method may further realize that the method has important roles in analyzing the unified data format of the service/application data, realizing data visualization, facilitating data comparison and analysis, simplifying the programming process, improving the working efficiency, realizing data sharing, and the like by constructing the preset reporting calculation model.

Step 209, inputting the service data and the service analysis request into a preset report calculation model, analyzing the service data by using the preset report calculation model, and outputting an analysis result;

In this embodiment, the service data and the service analysis request are input into the preset reporting calculation model, so that the preset reporting calculation model analyzes the service data, and the output analysis result may be similar to step 120 in the above embodiment, so that repetition is avoided and no further description is given here. This can also be accomplished by the following steps 2091 to 2093, see steps 2091 to 2093 for a detailed description.

Step 2091, analyzing the analysis request to obtain an analysis function, and processing the analysis function by using a regular expression to obtain an analysis function to be used;

In this embodiment, the analysis request further includes an analysis function identifier, and then the analysis request is parsed to determine the analysis function identifier, and then an analysis function corresponding to the query is further determined in the dictionary according to the analysis function identifier, and a database operation instruction statement (for example, sql statement) is assembled by using a regular expression and an analysis formula; and taking the database operation instruction statement formed by final assembly as an analysis function to be used.

Step 2092, inputting the service data and the analysis function to be used into a preset reporting calculation model, and detecting whether the analysis function to be used is matched with the preset analysis function by using the preset reporting calculation model;

In order to detect whether the service analysis request is legal in a preset reporting calculation model, after inputting an analysis function to be used into the preset reporting calculation model, the preset reporting calculation model detects whether the analysis function to be used can be matched with a certain preset analysis function; when the analysis function to be used can be successfully matched with a certain preset analysis function, the analysis function to be used is indicated to be legally used in a preset reporting calculation model; when the analysis function to be used cannot be matched with any preset analysis function, the analysis function to be used is indicated to be illegally used in a preset report calculation model.

And 2093, when the to-be-used analysis function is matched with the preset analysis function, determining the to-be-used analysis function as a target analysis function, analyzing the service data by using the target analysis function by using the preset report calculation model, and outputting an analysis result.

In this embodiment, when the to-be-used analysis function is matched with the preset analysis function, it indicates that the to-be-used analysis function can be used in the preset reporting calculation model, and then the preset reporting calculation model uses the to-be-used analysis function to analyze the service data, so as to obtain a corresponding analysis result, and outputs the analysis result.

Step 210, obtaining a report table template, wherein the report table template comprises a report table identifier, a report table name and a report table data source;

In order to improve standardization, definition, emphasis prominence, comparability and update maintainability of data, thereby better supporting business decision and data analysis, a report template is set, and the report template is specific:

1. determining a template requirement: first, the requirements of the report template are explicitly collected, including the data to be presented, the format of the data, the layout, etc. This helps to provide a well-defined direction for subsequent template designs.

2. Designing a template layout: and designing the layout of the report according to the requirements. The arrangement and the position of elements such as a title, a data column, notes and the like are determined. The layout is ensured to be concise and clear, and is easy to read and understand.

3. Defining a data column: according to the requirement, defining the data column to be displayed. The name, data type, data format, etc. of each column of data are determined. The data columns are ensured to be matched with the service demands, and the data content can be accurately reflected.

4. Defining a style and a format: styles and formats, such as fonts, colors, alignment, etc., are set for each element in the template. The visual effect of the template is clear and attractive, and the visual effect meets the visual specification of enterprises or teams.

5. Adding formulas and calculation: formulas and calculations may be added to the templates to calculate and aggregate the data, if desired. The accuracy of the formula and the accuracy of the calculation result are ensured.

6. Testing and adjusting: and after the template design is completed, testing and adjusting are performed. And the display effect of the templates on different devices and browsers is consistent, and the data display is accurate. And carrying out necessary adjustment and optimization on the template according to the test result.

Step 211, extracting corresponding data from the analysis result, filling the data into the report table template, and visualizing the report table template.

And correspondingly filling the acquired analysis results into a report template, improving the data understanding, highlighting the data key points, enhancing the data relevance, improving the reporting effect, promoting the data communication, adapting to different requirements and the like, providing a more efficient and more visual data display and analysis tool for enterprises, visualizing the report template, and improving the intuitiveness of the user for acquiring the analysis result data.

212, Detecting whether the stay time of a cursor on the report table template at a preset hovering position is longer than a preset time;

the specific process of detecting the residence time of the cursor on the reporting template at the preset hovering position is as follows:

1. Determining a preset position: first, a preset position where the cursor needs to stay needs to be determined. This may be achieved by setting a specific coordinate point on the page, such as a button or a center point of a specific area.

2. Monitoring a mouse event: in order to detect the dwell time of the cursor at the preset position, the entry and exit events of the mouse need to be monitored. In JavaScript, the addeventlist method can be used to listen for these events. Triggering mouseenter an event when the mouse enters a preset position; when the mouse leaves the preset position, a mouseleave event is triggered.

3. Entry and exit times were recorded: when the mouse entering event is monitored, the current time (in milliseconds) is recorded as the point of time of the cursor entering. Also, when a mouse departure event is monitored, the current time is recorded as a point of time at which the cursor departs.

4. Calculating the residence time: by comparing the entering time and the leaving time, the residence time of the cursor at the preset position can be calculated. The dwell time can be obtained by subtracting the entry time from the exit time in milliseconds.

After the time that the cursor stays at the preset hovering position is calculated, whether the time that the cursor stays at the preset hovering position is larger than the preset time or not is detected, so that the user can be determined to use the annotation content corresponding to the preset hovering position to be displayed.

And 213, determining visualized content at the hovering position according to the hovering position when the stay time of the cursor at the preset hovering position is longer than the preset time, and annotating and displaying the content.

For better understanding, processing and use of data by the user, and by emphasizing key information in the annotation, the user's attention can be drawn to help the user find the data points that need attention faster. Then the content visualized on the hover position is displayed on the hover position, which may be accomplished by drawing an annotation box on the hover position, displaying annotation text, etc. This may provide additional information about the cell content, helping the user to better understand the data. For example, for certain specific situations or special requirements, annotations may explain the source of the data, the method of calculation, important precautions, etc.

Specifically, determining the content visualized on the hover position according to the hover position includes the following steps:

1. Determining a hover position: when a mouse hovers over a location in a data table, specific coordinates of the location need to be determined. This may be accomplished by listening for a hover event of the mouse, triggering a corresponding hover event when the mouse hovers over the table, and recording the current mouse position.

2. Obtaining cell information: according to the hovering position of the mouse, cell information corresponding to the position needs to be acquired. This may determine the cell corresponding to the hover position by querying the column and row information of the table.

3. The annotation information is obtained: if the cell has an annotation, annotation information needs to be acquired. This can be accomplished by querying the annotation properties of the cells.

In this embodiment, in order to realize the visual contents on the hover position, it is necessary to ensure that the layout and style of the form are correct, and that the style and position of the annotation frame and the annotation text are correct. At the same time, it is also necessary to process the movement event of the mouse, ensure that the visual content is updated when the mouse moves, and clear when the mouse leaves the form.

And 214, determining the associated data of the service according to the analysis result.

In this embodiment, step 214 is similar to step 130 in the above embodiment, and is not repeated here.

Example III

In this embodiment, as shown in fig. 2, a processing system based on service data is provided, including:

A first receiving module 301, configured to receive a service analysis request;

A first determining module 302, configured to determine to obtain service data according to the service analysis request;

The analysis module 303 is configured to input the service data and the service analysis request into a preset reporting calculation model, analyze the service data with the preset reporting calculation model, and output an analysis result;

and the second determining module 304 is configured to determine association data of the service according to the analysis result.

In this embodiment, the first receiving module 301 receives the service analysis request and sends the service analysis request to the first determining module 302 and the analyzing module 303. The first determining module 302 determines to obtain service data according to the service analysis request, and finally sends the service data to the analyzing module 303. The analysis module 303 inputs the service data and the service analysis request into a preset report calculation model, analyzes the service data by using the preset report calculation model, outputs an analysis result, and finally sends the analysis result to the second determination module 304; the second determining module 304 determines the associated data of the service according to the analysis result. The service data is analyzed and processed by using the preset reporting calculation model to determine the associated data of the service, so that the problem of low efficiency of processing the service associated data due to the fact that a large amount of data needs to be manually processed is solved to a certain extent, and the method has the advantages of high efficiency, high accuracy and high safety of processing the service associated data.

In an embodiment, the service data based processing system may further include: the system comprises a first setting module, a construction module, an analysis module, a first detection module, a second determination module, a generation module, a second receiving module, a creation module, a second setting module, a first visualization module, a second detection module and a second visualization module.

The first setting module is used for acquiring a preset analysis function and collecting data association expressions of each service;

and the construction module is used for constructing a preset reporting calculation model according to the preset analysis function and the data association expression of each service.

The analysis module is used for analyzing the service analysis request to obtain a request analysis identifier;

The first detection module is used for detecting whether the request analysis identifier accords with a preset effective identifier or not;

The second determining module is further configured to determine to obtain service data according to the service analysis request when the first detecting module determines that the request analysis identifier meets the preset valid identifier;

And the generating module is used for generating a service analysis request failure when the first detecting module determines that the request analysis identifier does not accord with the preset effective identifier.

The second receiving module is used for receiving a service creation request and analyzing the service creation request to acquire a service creation identifier;

and the creation module is used for creating a corresponding service database according to the creation identifier.

The second setting module is used for obtaining a report table template, wherein the report table template comprises a report table identifier, a report table name and a report table data source;

And the first visualization module is used for extracting corresponding data from the analysis result, filling the corresponding data into the report form template and visualizing the report form template.

The second detection module is used for detecting whether the residence time of the cursor on the report table template at the preset hovering position is longer than the preset time;

and the second visualization module is used for determining the visualized content at the hovering position according to the hovering position and annotating and displaying the content when the second detection module determines that the stay time of the cursor at the preset hovering position is longer than the preset time.

In an embodiment, the analysis module 303 may include an analysis unit, a detection unit, and an analysis unit.

The analysis unit is used for analyzing the analysis request to obtain an analysis function, and the analysis function is processed by using a regular expression to obtain an analysis function to be used;

The detection unit is used for inputting the service data and the analysis function to be used into a preset reporting calculation model, and detecting whether the analysis function to be used is matched with the preset analysis function or not by utilizing the preset reporting calculation model;

And the analysis unit is used for determining the analysis function to be used as a target analysis function when the detection unit determines that the analysis function to be used is matched with the preset analysis function, analyzing the service data by utilizing the target analysis function through the preset reporting calculation model and outputting an analysis result.

For specific limitations on the business data-based processing system, reference may be made to the limitation of the cargo access data processing method hereinabove, and no further description is given here. The various elements of the business data based processing system described above may be implemented in whole or in part by software, hardware, and combinations thereof. The units can be embedded in hardware or independent of a processor in the computer equipment, and can also be stored in a memory in the computer equipment in a software mode, so that the processor can call and execute the operations corresponding to the units.

Example IV

In this embodiment, a computer device is provided. The internal structure thereof can be shown in fig. 3. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program, and is deployed with a database for storing relevant data of business data. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The network interface of the computer device is used to communicate with other computer devices in which application software is deployed. The computer program is executed by a processor to implement a method of processing based on business data. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

It will be appreciated by those skilled in the art that the structure shown in FIG. 3 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.

In one embodiment, a computer device is provided comprising a memory storing a computer program and a processor that when executing the computer program performs the steps of:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

In an embodiment, the computer program may further implement the steps of the service data based processing method described in any of the above embodiments when executed by a processor.

Example five

In this embodiment, there is provided a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.

Claims

1. A business data based processing method, comprising:

Receiving a service analysis request;

Determining to acquire service data according to the service analysis request;

2. The method according to claim 1, wherein the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and before outputting the analysis result, the method further comprises:

3. The method of claim 1, wherein prior to determining to acquire service data based on the service analysis request, the method further comprises:

Analyzing the service analysis request to obtain a request analysis identifier;

4. The method of claim 1, wherein prior to receiving the traffic analysis request, the method further comprises:

5. The method according to claim 2, wherein the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and outputting an analysis result includes:

Inputting the business data and the analysis function to be used into a preset reporting calculation model, and detecting whether the analysis function to be used is matched with the preset analysis function or not by utilizing the preset reporting calculation model;

6. The method according to any one of claims 1 to 5, wherein the inputting the service data and the service analysis request into a preset report calculation model, so that the preset report calculation model analyzes the service data, and after outputting the analysis result, the method further includes:

Obtaining a report table template, wherein the report table template comprises a report table identifier, a report table name and a report table data source;

7. The method of claim 6, wherein after extracting corresponding data from the analysis result and filling the data into the report table template, and visualizing the report table template, the method further comprises:

8. A business data based processing system, comprising:

The first receiving module is used for receiving a service analysis request;

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.

10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.