CN110196877B - Data display method, device, computer equipment and storage medium - Google Patents
Data display method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110196877B CN110196877B CN201810939592.1A CN201810939592A CN110196877B CN 110196877 B CN110196877 B CN 110196877B CN 201810939592 A CN201810939592 A CN 201810939592A CN 110196877 B CN110196877 B CN 110196877B
- Authority
- CN
- China
- Prior art keywords
- data
- service
- service table
- data display
- display
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000005457 optimization Methods 0.000 claims abstract description 54
- 238000004590 computer program Methods 0.000 claims description 16
- 238000012545 processing Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 6
- QVGXLLKOCUKJST-UHFFFAOYSA-N atomic oxygen Chemical compound [O] QVGXLLKOCUKJST-UHFFFAOYSA-N 0.000 description 4
- 229910052760 oxygen Inorganic materials 0.000 description 4
- 239000001301 oxygen Substances 0.000 description 4
- 238000013500 data storage Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 230000010076 replication Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Information Transfer Between Computers (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a data display method, a data display device, computer equipment and a storage medium, which effectively improve data exposable and user experience. The method comprises the following steps: receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, the data display object corresponds to a target service table in a service system, the target service table comprises a first service table and a second service table, the first service table records service data of the service system, and the second service table records service data after data optimization; if the data display type is the data optimization display type, displaying the second business table according to a preset display view; and if the data display type is the data actual display type, displaying the first service table according to a preset display view.
Description
Technical Field
The present application relates to the field of computers, and in particular, to a data display method, apparatus, computer device, and storage medium.
Background
With the rapid development of the financial industry, various financial services are continuously developed, wherein the financial loan service is the most explosive, and various financial loan modes, corresponding packages and other services are different. In the face of huge customer groups, the business data are very much owned, and in the data environment with huge business data information quantity, the integration of the business data is a very important ring, wherein, how to optimize and display the data is paid more and more attention.
At present, a data display method is proposed, in the method, acquired data is directly displayed, the acquired data is actually recorded before being presented to a user, however, the data often has more problems, dirty data (DIRTY DATA) appears in the data, and the data which cannot be removed is removed, so that the due data cannot be presented; yet another is that the user is presented with business data that the user is not concerned or willing to see, since the presentation data is not separated from the actual data.
Disclosure of Invention
Based on the above, it is necessary to provide a data display method, device, computer equipment and storage medium, which can display data which a user wants to see, so that the displayed data is due data or data which the user is more concerned with, and effectively improve the data exposable property and user experience.
A data presentation method comprising:
Receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, and the data display object corresponds to a target service table in a service system;
Determining a target service table corresponding to the data display object, wherein the target service table comprises a first service table and a second service table, the first service table records service data of a service system, and the second service table records service data after data optimization;
if the data display type is the data optimization display type, displaying the second business table according to a preset display view;
and if the data display type is the data actual display type, displaying the first service table according to a preset display view.
A data presentation device, comprising:
the receiving module is used for receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, and the data display object corresponds to the service system;
the determining module is used for determining a target service table corresponding to the data display object in the data display request received by the receiving module, wherein the service system corresponds to the target service table, the target service table comprises a first service table and a second service table, the first service table records service data of the service system, and the second service table records service data after data optimization;
The display module is used for displaying the second service table according to the preset display view if the data display type is the data optimization display type; and if the data display type is the actual data display type, displaying the first service table according to the preset display view.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the data presentation method described above when the computer program is executed.
A computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of the data presentation method described above.
In summary, a data display method, a device, a computer device and a storage medium are provided, when service data is displayed, source data or data of which the source data is optimized are displayed according to the requirements of a user, namely, a data display request, and data which the user wants to see can be displayed, so that the displayed data is due data or data which the user is more concerned with, and the data display performance and user experience are effectively improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments of the present application will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic view of an application environment of a data presentation method according to the present application;
FIG. 2 is a flow chart of one embodiment of a data presentation method of the present application;
FIG. 3 is a schematic diagram of another embodiment of the data display method of the present application;
FIG. 4 is a schematic diagram illustrating an embodiment of step S50 in FIG. 3;
FIG. 5 is a schematic diagram illustrating an embodiment of step S52 in FIG. 4;
FIG. 6 is a schematic diagram of a data display device according to an embodiment of the present application;
FIG. 7 is a schematic view of another embodiment of the data display device of the present application;
FIG. 8 is a schematic diagram of a computer device according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
The data display method provided by the application can be applied to an application environment as shown in fig. 1, wherein a user side, namely computer equipment/terminal equipment/and the like can carry out data communication with a server side, namely a server through a network. In the application, a user side can receive a data display request of a user, the data display request comprises a data display object and a data display type, a target service table corresponding to the data display object is determined, wherein the target service table comprises a first service table and a second service table, the first service table records service data fed back by a service system, the second service table records service data subjected to data optimization, the data display object corresponds to a service system, and the service system corresponds to the target service table; according to the data display type, displaying one of the target service tables according to a preset display view, namely, displaying the second service table according to the preset display view if the data display type is the data optimization display type; and if the data display type is the actual data display type, displaying the first service table according to the preset display view. That is, in the application, when the service data is displayed, the source data is displayed according to the requirement of the user, namely the data display request, or the data of which the source data is optimized can be displayed, so that the displayed data is due data or data which is more concerned by the user, and the data display performance and user experience are effectively improved. The client may be, but not limited to, various computer devices or terminal devices with information processing capability and display capability, such as various personal computers, notebook computers, smartphones, tablet computers, and the like, and is not particularly limited. The server, that is, the server may be implemented by an independent server or a server cluster formed by a plurality of servers, where the server is used to provide the server of the service system, and in some practical application scenarios, the user side may perform data connection with the service system provided by one or more server sides, so as to obtain service data of the service system. Embodiments of the present application are described below:
in an embodiment, as shown in fig. 2, a data display method is provided, and the method is applied to the user terminal in fig. 2 for illustration, and includes the following steps:
S10, receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, and the data display object corresponds to a target service data table in a service system;
The data display request is a request initiated by a user to a user terminal according to display requirements, the data display request comprises a data display object and a data display type, the data display object corresponds to a target service table in a service system, and the data display object is used for selecting service data of the target service table of the specific service system to be displayed.
In this scheme, the service system refers to a service system corresponding to various service types, and the service system is a system for collecting and recording service data of the service types. For example, the service types may be service systems corresponding to loan service types, and other service types may be referred to, for example, service systems corresponding to insurance service types, which is not particularly limited. The specific service types under the loan service types can be small loan, home e loan, oxygen loan and other services, the specific service types under the insurance service types can be accident insurance, endowment insurance, child insurance and other insurance services, and the service data generated by the service types under different service types are generally managed by the corresponding service system due to huge user volume and huge generated service data. For example, the service data generated by the home credit is typically managed by a home credit service system, and the service data generated by the oxygen credit is typically managed by an oxygen credit service system; for another example, business data generated by an accident risk is managed by an accident risk business system, and business data generated by a child risk is managed by a child risk business system. It can be seen that, in some application scenarios, the service system may use the server that provides the service type as the service system in the present application, or may use a specific service that provides the service type as the service system in the present application, which is not limited in detail. As shown in the environment schematic diagram of fig. 1, the service end is used as the service system, and the user end can implement data interfacing with one or more service systems.
The data display type refers to the display mode of the service data of the service system, and one display mode refers to the display of the source data, namely the non-optimized service data; a display mode refers to displaying data after data optimization of service data, namely data after data optimization of source data.
S20, determining a target service table corresponding to the data display object, wherein the service system corresponds to the target service table, the target service table comprises a first service table and a second service table, the first service table records service data of the service system, and the second service table records the service data after data optimization;
As known from step S10, the data display object corresponds to the target service table in the service system, so that the target service table corresponding to the data display object can be determined. The target service table refers to a data table used for storing and recording service data of the same service type in the service system. The target service table comprises a first service table and a second service table, wherein the first service table records the service data fed back by the service system, and the second service table records the service data after data optimization. The first service table of the home e-credit service in the home e-credit service system stores service data of the home e-credit service, and the second service table of the home e-credit service in the home e-credit service system stores optimized service data of the home e-credit service. The first business table of the accident risk business in the accident risk business system stores business data of the accident risk business, and the second business table of the accident risk business in the accident risk business system stores business data of the accident risk business after data optimization. The above data optimization means that the service system administrator performs optimization operation on the service data, for example, the service system administrator clears invalid service data, or hides part of the service data, or modifies the service data. Taking the loan business category as an example, the accumulated repayment state of the customer for the last 12 months can be fully optimized as a "normal state". It should be noted that, besides the optimization operation that the user optimizes the service data according to the actual situation or the actual requirement, the optimization operation that the service system performs the optimization by itself may be exemplified by, but not limited to, optimizing the service data with incorrect or invalid data format of the service data. In other words, in this embodiment, under each service system, the service data providing a specific service type is allocated with a first service table and a second service table, that is: the service data of the service type under each service system is recorded and stored corresponding to a first service table and a second service table respectively, the first service table and the second service table under each service type are associated and used for storing and recording the service data of the same service type, and the difference is that the first service record and store the source data of the service data and the second service table record and store the source data after data optimization. For ease of understanding, a practical example will be described again here, taking the insurance service category as an example, for example: the home e credit service system corresponds to the home e credit service, and corresponds to the first service table a1 and the second service table a2; the small loan service system corresponds to the small loan service, the small loan service system corresponds to the first service table b1 and the second service table b2, and if the data display object in the data display request is the home loan service system, the target service table under the home loan service system, namely the home loan service system corresponds to the first service table a1 and the second service table a2, is determined.
S30, if the data display type is the data optimization display type, displaying the second business table according to a preset display view;
In the present application, the two display modes are indicated by a data display type, specifically, the data optimization display type and the data actual display type are respectively indicated by the two display modes, and the data optimization display type and the data actual display type can be correspondingly indicated by different characters, character strings, numbers or combinations thereof in a data display request, for example, the data optimization display type can be indicated by 0, and the data actual display type can be indicated by 1. And if the data display type is the data optimization display type, displaying the second service table according to a preset display view.
And S40, if the data display type is the data actual display type, displaying the first service table according to a preset display view.
And similarly, if the data display type indicates the data actual display type, displaying the first service table according to a preset display view.
In the scheme, a corresponding target service table is determined according to the data display object in the data display request, and one of the target service tables is further displayed according to a preset display view according to the data display type in the data display request.
As can be seen from the above technical solution, the present application provides a data display method, in which a data display request of a user is received, where the data display request includes a data display object and a data display type, and the data display object corresponds to a service system; determining a target service table corresponding to the data display object, wherein the target service table comprises a first service table and a second service table, the first service table records service data of a service system, the second service table records service data after data optimization, and the service system corresponds to the target service table; and displaying one of the target service tables according to the data display type and a preset display view. Therefore, when the service data is displayed, the source data or the data of which the source data is subjected to data optimization is displayed according to the requirements of the user, namely the data display request, so that the data which the user wants to see can be displayed, the displayed data is due data or data which the user is more concerned with, and the data display performance and the user experience are effectively improved.
In an embodiment, the first service table or the second service table may be displayed according to a preset display view, so long as the user can see the service data of the first service table or the second service table through the preset display view. Illustratively, the first service table or the second service table is directly displayed in a table-like form; the first service table or the second service table is illustratively displayed in a manner of graphic controls, and each control in the graphic controls corresponds to a data characteristic in service data in the first service table or the second service table, wherein the data characteristic includes, but is not limited to, a data type, a data format and the like, for example, digital data and service type data are displayed by different graphic controls, and the method is not particularly limited. It can be understood that different service data display modes of preset display views are provided, so that the diversity of schemes is improved.
Referring to fig. 3, in an embodiment, before step S20, that is, before determining the target service table corresponding to the data display object, the method specifically includes the following steps:
S40, acquiring service data of a service system;
The service data of the service system needs to be acquired before the service data of the service system is displayed. In the actual application scenarios, two kinds of application scenarios are mainly divided: one is that the user end has established data butt-joint relation with each service system of the service end, at this time, the user end is used as a terminal for unified management, and receives the service data fed back by each service system of the service end, such as the service data reported by the small loan, home e loan and oxygen loan service systems. Therefore, the user side can acquire the data in time when the user side needs to acquire the service data of the service system, so that the overall processing efficiency is improved; the service system receives the service data from the user terminal, and sends the service data to the service system. Therefore, the user side can not intensively acquire a large amount of data, and acquire the service data of a certain service system according to actual requirements, so that the processing pressure of the user side can be reduced.
S50, respectively recording the service data into a first service table and a second service table;
in the scheme, after service data of a service system are acquired, the service data are respectively recorded in a first service table and a second service table.
It should be noted that in the first application scenario in step S40, since the service data actively uploaded by each service system of the server side, that is, the service data includes service data under multiple service systems, in this embodiment, the service data is respectively and correspondingly recorded in the first service table and the second service table corresponding to the service systems.
S60, receiving an optimization operation aiming at service data in a second service table;
After the service data is recorded in the second service table, the user may perform an optimization operation on the service data in the second service table, where the optimization operation includes, but is not limited to, operations of deleting, adding, modifying, rounding, and the like, on the service data in the second service table. In addition, the optimization operation may be other optimization operations, for example, copy operation, etc., and the specific data optimization operation is determined by the user according to the actual situation or the actual requirement, which is not limited herein. Correspondingly, in the scheme, the optimization operation of the user on the service data in the second service table can be received. It should be noted that, besides the optimization operation that the user optimizes the service data in the second service table according to the actual situation or the actual requirement, the system may also perform the optimization operation by itself, for example, the invalid service data in the second service table is cleared, the invalid service data may be configured by itself, for example, the loan service type may be taken as an example, and the accumulated repayment state of the customer in the last 12 months may be fully optimized to be a "normal state", which is not specifically limited.
And S70, optimizing the service data in the second service table according to the optimization operation.
It may be appreciated that, after receiving an optimization operation performed by the user for optimizing the service data in the second service table, the service data in the second service table may be optimized according to the optimization operation, which is not described herein. It should be noted that the above step sequence number does not limit the execution sequence of the steps, and the specific execution sequence may be determined by logic between the steps.
Therefore, in the scheme, the service data in the second service table can be optimized in a self-defined manner, if the data display type is the data optimized display type, the second service table is displayed according to the preset display view, that is, the service data required by the user can be displayed in a self-defined manner, the data which the user wants to see can be presented, the displayed data is due data or data which the user is more concerned with, and the data display performance and user experience are effectively improved. On the other hand, because the data in the second service table is optimized, the actual source data is still stored and recorded in the second service table, the true service data is effectively recorded and stored, and the service data in the second service table can be acquired at any time, so that the source data is acquired.
In an embodiment, the first service table and the second service table respectively include M records, each record in the M records includes N fields, wherein M, N is a positive integer, M and N are greater than or equal to 1, N fields in each record in the first service table and the second service table are allocated with a joint primary key, the joint primary key in the first service table is the same as the joint primary key in the same record in the second service table, and the joint primary key is used for identifying N fields in each record in the first service table and the second service table. That is, for the first service table and the second service table are in the same data storage format, each of the first service table and the second service table has M records, each record has N fields, where a primary key formed by one field is called a single primary key, and a primary key formed by a plurality of fields is called a joint primary key, it should be understood that by establishing a joint primary key by the N fields, service data of some fields in the records can be stored in an associated manner, and fields that establish a relationship with the joint primary key have a one-to-one correspondence with the joint primary key. Taking a medium-sized e-credit of a loan service category as an example, each of the above-mentioned M records is used for recording service data of a customer's e-credit, and each of the fields in the records is used for recording a specific record of the service data of the e-credit, for example, a loan date, a repayment date, an overdue cumulative date, and the like of the e-credit. By the method, when the user side needs to call the service data of the field corresponding to the joint primary key, only the joint primary key is required to be called, and the mode of searching each field is not required, so that the query capability of the service data is improved.
Referring to fig. 4, in an embodiment, in step S50, the service data is recorded in the first service table and the second service table, including the following steps:
s51, classifying and counting the service data according to the data type;
In the application, after the service data of the service system is obtained in step S11, the service data is classified and counted according to the data type. It should be understood that the service data in the service system has different data types, for example, the service data related to the small loan includes, but is not limited to, service data corresponding to data types of a plurality of different fields such as "loan date", "borrower", "planned repayment date", "actual repayment date", "overdue date", "accumulated repayment status of 12 months last by customer", etc. Therefore, in the scheme, the service data can be classified and counted according to the data types to divide the data types in the service data, and it can be seen that the classification and counting refers to the classification and counting according to the data types of the fields in the data storage formats of the first service table and the second service table.
In some embodiments, in combination with the foregoing embodiments, the first service table and the second service table respectively include M records, where each record in the M records includes N fields, and in this embodiment, classification statistics are performed on the service data according to data types of the N fields, that is, in the foregoing classification statistics, classification statistics are performed on the service data in consideration of data storage formats of the first data table and the second data table.
S52, correspondingly recording the classified and counted service data into each field forming the combined main key in the first service table and the second service table.
After the classification statistics of the service data, it can be determined that the acquired service data belongs to the fields forming the joint primary key in the first service table and the second service table, so that the classified and counted service data is correspondingly recorded in each field forming the joint primary key in the first service table and the second service table. The corresponding recording refers to recording the data types of the classified and counted service data into positions corresponding to the fields of the combined main key in the first service table and the second service table according to the composition fields of the combined main key.
In the scheme, the business data is classified by the data type, the business data is pre-counted based on the combined main key, and because the combined main key is established according to the classifying requirement of the data type of the business data, the counted business data not only reduces the number of generated statistic result records, but also pre-classifies the data to be checked in the query page in advance, and does not need to be classified in a program, thereby improving the statistic speed and efficiency of the business data, and simultaneously improving the data query efficiency and speed when the business data is displayed later. Meanwhile, the combined primary key is established according to logic classifying the data types of the service data, so that the statistical efficiency is improved, and the accuracy of the statistical result is not influenced.
Referring to fig. 5, in step S52, the service data after the categorization and statistics is recorded in each field of the first service table and the second service table that form the joint primary key, which includes:
S521, recording the classified and counted business data into each field forming a joint main key in a first business table;
s522, the first service table is copied to obtain a second service table.
That is, in the scheme, the service data after classification statistics is directly recorded in the first service table, then the first service table is directly subjected to table replication to obtain the service table identical to the first service table, and the service table obtained by replication is directly used as the second service table. Therefore, the number of times of establishing the service table and recording the same service data at one time can be reduced by the copying mode, the calculated amount of data inquiry and the like of the user terminal can be reduced, the power consumption of the user terminal is reduced, and the overall processing efficiency can be improved.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present application.
In an embodiment, a data display device is provided, where the data display device corresponds to the data display method in the foregoing embodiment one by one. As shown in fig. 6, the data display device 60 includes a receiving module 601, a determining module 602, and a display module 603. The functional modules are described in detail as follows:
The receiving module 601 is configured to receive a data display request of a user, where the data display request includes a data display object and a data display type, and the data display object corresponds to a service system;
The determining module 602 is configured to determine a target service table corresponding to the data display object in the data display request received by the receiving module 601, where the service system corresponds to the target service table, and the target service table includes a first service table in which service data of the service system is recorded and a second service table in which service data after data optimization is recorded;
The display module 603 is configured to display the second service table determined by the determining module 602 according to the preset display view if the data display type is the data optimization display type; and if the data display type is the actual data display type, displaying the first service table of the determining module 602 according to the preset display view.
In one embodiment, as shown in fig. 7, the data presentation device 60 further includes:
an obtaining module 604, configured to obtain service data of a service system before determining a target service table corresponding to the data display object;
The recording module 605 is configured to record the service data acquired by the acquiring module 604 into the first service table and the second service table respectively;
The receiving module 601 is further configured to: receiving an optimization operation for service data in a second service table;
the optimizing module 606 is configured to optimize the service data in the second service table according to the optimizing operation received by the receiving module 601.
In an embodiment, the first service table and the second service table respectively include M records, each record in the M records includes N fields, wherein M, N is a positive integer, M and N are greater than or equal to 1, N fields in each record in the first service table and the second service table are assigned a joint primary key, the joint primary key in the first service table is the same as the joint primary key in the same record in the second service table, and the joint primary key is used for identifying N fields in each record in the first service table and the second service table.
In one embodiment, the recording module 605 is specifically configured to:
classifying and counting the business data according to the data type;
And correspondingly recording the classified and counted service data into each field forming the combined main key in the first service table and the second service table.
In an embodiment, the recording module 605 is configured to record the classified and counted service data into each field of the first service table and the second service table that forms the joint primary key, and includes:
the listing module 605 is configured to:
the classified and counted business data are recorded in each field forming a joint primary key in a first business table;
the first service table is replicated to obtain a second service table.
The application provides a data display device, which can display source data or optimized data of the source data according to the requirement of a user, namely, a data display request when the service data is displayed, and can display the data which the user wants to see, so that the displayed data is due data or data which the user is more concerned with, and the data display performance and user experience are effectively improved.
For specific limitations of the data display device, reference may be made to the above limitation of the data display method, and no further description is given here. The various modules in the data presentation device described above may be implemented in whole or in part in software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a terminal, and the internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. The display screen is used for displaying the first service table or the second service table in the embodiment of the method, the input device is used for receiving service data and optimizing operation of a user, and the processor of the computer equipment is used for providing calculation and control capability. 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. 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 for communicating with an external service end through network connection. The computer program is executed by a processor to implement the steps of the data presentation method in the method embodiments described above.
In one embodiment, a computer device is provided comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of when executing the computer program:
Receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, and the data display object corresponds to a target service table in a service system;
Determining a target service table corresponding to the data display object, wherein the target service table comprises a first service table and a second service table, the first service table records service data of a service system, and the second service table records service data after data optimization;
if the data display type is the data optimization display type, displaying the second business table according to a preset display view;
and if the data display type is the data actual display type, displaying the first service table according to a preset display view.
It should be noted that, for other steps or details implemented when the processor executes the computer program, reference may be made to the steps of the data display method in the foregoing method embodiment, and the detailed description is not repeated here.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
Receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, and the data display object corresponds to a target service table in a service system;
Determining a target service table corresponding to the data display object, wherein the target service table comprises a first service table and a second service table, the first service table records service data of a service system, and the second service table records service data after data optimization;
if the data display type is the data optimization display type, displaying the second business table according to a preset display view;
and if the data display type is the data actual display type, displaying the first service table according to a preset display view.
Similarly, it should be noted that, for other steps or details of the implementation of the computer program when executed by the processor, reference may be made to the steps of the data display method in the foregoing method embodiment, and the detailed description is not repeated here.
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.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present application, and not for limiting the same; although the application has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application.
Claims (7)
1.A data presentation method, comprising:
Receiving a data display request of a user, wherein the data display request comprises a data display object and a data display type, the data display object corresponds to a target service table in a service system, and the service system corresponds to different service types;
determining a target service table corresponding to the data display object, wherein the target service table comprises a first service table and a second service table, the first service table records service data of the service system, and the second service table records the service data after data optimization;
If the data display type is the data optimization display type, displaying the second service table according to a preset display view;
If the data display type is the actual data display type, displaying the first business table according to the preset display view;
Before determining the target service table corresponding to the data display object, the method further comprises:
Acquiring the service data of the service system;
respectively recording the service data into the first service table and the second service table;
Receiving an optimization operation for the service data in the second service table, wherein the optimization operation comprises deleting, adding and modifying the service data in the second service table and rounding digital data;
optimizing the service data in the second service table according to the optimization operation;
wherein the second service table is copied by the first service table;
The first service table and the second service table respectively comprise M records, each of the M records comprises N fields, wherein M, N is a positive integer, M and N are greater than or equal to 1, the N fields in each of the first service table and the second service table are distributed with a joint primary key, the joint primary key of the first service table is the same as that of the same record in the second service table, and the joint primary key is used for identifying the N fields in each of the first service table and the second service table.
2. The data display method as claimed in claim 1, wherein said recording the service data into the first service table and the second service table respectively includes:
classifying and counting the service data according to the data type;
And correspondingly recording the service data subjected to the classification statistics into each field forming the combined main key in the first service table and the second service table.
3. The data display method according to claim 2, wherein the recording the service data after the categorizing statistics into each field of the first service table and the second service table that forms the joint primary key includes:
The business data subjected to the classification statistics are recorded in each field forming the combined main key in the first business table;
and copying the first service table to obtain the second service table.
4. A data presentation device, comprising:
The system comprises a receiving module, a processing module and a processing module, wherein the receiving module is used for receiving a data display request of a user, the data display request comprises a data display object and a data display type, the data display object corresponds to a service system, and the service system corresponds to different service types;
the determining module is used for determining a target service table corresponding to the data display object in the data display request received by the receiving module, wherein the service system corresponds to the target service table, the target service table comprises a first service table and a second service table, the first service table records service data of the service system, and the second service table records the service data after data optimization;
The display module is used for displaying the second service table determined by the determination module according to a preset display view if the data display type is the data optimization display type; if the data display type is the actual data display type, displaying the first service table determined by the determining module according to the preset display view;
Wherein, the data presentation device still includes:
the acquisition module is used for acquiring the service data of the service system before determining a target service table corresponding to the data display object;
the recording module is used for recording the service data acquired by the acquisition module into the first service table and the second service table respectively;
the receiving module is further configured to: receiving an optimization operation for the service data in the second service table, wherein the optimization operation comprises deleting, adding and modifying the service data in the second service table and rounding digital data;
The optimizing module is used for optimizing the service data in the second service table according to the optimizing operation received by the receiving module;
wherein the second service table is copied by the first service table;
The first service table and the second service table respectively comprise M records, each of the M records comprises N fields, wherein M, N is a positive integer, M and N are greater than or equal to 1, the N fields in each of the first service table and the second service table are distributed with a joint primary key, the joint primary key of the first service table is the same as that of the same record in the second service table, and the joint primary key is used for identifying the N fields in each of the first service table and the second service table.
5. The data presentation device of claim 4, wherein the listing module is specifically configured to:
classifying and counting the service data according to the data type;
And correspondingly recording the service data subjected to the classification statistics into each field forming a combined main key in the first service table and the second service table.
6. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the data presentation method according to any of claims 1 to 3 when the computer program is executed.
7. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the data presentation method according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810939592.1A CN110196877B (en) | 2018-08-17 | 2018-08-17 | Data display method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810939592.1A CN110196877B (en) | 2018-08-17 | 2018-08-17 | Data display method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110196877A CN110196877A (en) | 2019-09-03 |
| CN110196877B true CN110196877B (en) | 2024-05-07 |
Family
ID=67751400
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810939592.1A Active CN110196877B (en) | 2018-08-17 | 2018-08-17 | Data display method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110196877B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112396491A (en) * | 2020-11-18 | 2021-02-23 | 深圳壹账通智能科技有限公司 | Benefit display method and device, terminal equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009146084A (en) * | 2007-12-13 | 2009-07-02 | Mitsubishi Electric Corp | Table management device |
| CN105550314A (en) * | 2015-12-14 | 2016-05-04 | Tcl集团股份有限公司 | Data statistics method, device and system based on combined major key |
| CN107038200A (en) * | 2016-12-15 | 2017-08-11 | 平安科技（深圳）有限公司 | Business data processing method and system |
| CN108197297A (en) * | 2018-01-23 | 2018-06-22 | 正方软件股份有限公司 | Method for exhibiting data and system |
-
2018
- 2018-08-17 CN CN201810939592.1A patent/CN110196877B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2009146084A (en) * | 2007-12-13 | 2009-07-02 | Mitsubishi Electric Corp | Table management device |
| CN105550314A (en) * | 2015-12-14 | 2016-05-04 | Tcl集团股份有限公司 | Data statistics method, device and system based on combined major key |
| CN107038200A (en) * | 2016-12-15 | 2017-08-11 | 平安科技（深圳）有限公司 | Business data processing method and system |
| CN108197297A (en) * | 2018-01-23 | 2018-06-22 | 正方软件股份有限公司 | Method for exhibiting data and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110196877A (en) | 2019-09-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9460311B2 (en) | Method and system for on-the-fly anonymization on in-memory databases | |
| CN108599973B (en) | Log association method, device and equipment | |
| CN111177302A (en) | Business document processing method and device, computer equipment and storage medium | |
| US20240126817A1 (en) | Graph data query | |
| US20150317336A1 (en) | Data reconstruction | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN110196877B (en) | Data display method, device, computer equipment and storage medium | |
| CN111522881B (en) | Service data processing method, device, server and storage medium | |
| CN112527839A (en) | Multi-source data processing method, system, equipment and storage medium | |
| US11966489B2 (en) | Data certification process for cloud database platform | |
| CN111753141B (en) | Data management method and related equipment | |
| CN111143461A (en) | Mapping relation processing system and method and electronic equipment | |
| CN115293685A (en) | Logistics order state tracking method, device, equipment and storage medium | |
| CN112035471B (en) | Transaction processing method and computer equipment | |
| CN110851446B (en) | Data table generation method and device, computer equipment and storage medium | |
| CN114610803A (en) | Data processing method and device, electronic equipment and storage medium | |
| US11138174B2 (en) | Electronic database and method for forming same | |
| CN111723129A (en) | Report generation method, report generation device and electronic equipment | |
| US11829367B2 (en) | Data certification process for updates to data in cloud database platform | |
| US11392587B1 (en) | Rule generation and data certification onboarding process for cloud database platform | |
| CN115423595B (en) | File information processing method and device, computer equipment and storage medium | |
| CN112860755B (en) | Service identifier generation method, device, computer equipment and medium | |
| CN112860694B (en) | Service data processing method, device and equipment | |
| US20240232421A1 (en) | Data Certification Process for Cloud Database Platform | |
| CN115629958A (en) | Universal field level automatic checking method and device for different service interfaces |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |