CN114237798A - Data processing method, device, server and storage medium - Google Patents
Data processing method, device, server and storage medium Download PDFInfo
- Publication number
- CN114237798A CN114237798A CN202111562411.6A CN202111562411A CN114237798A CN 114237798 A CN114237798 A CN 114237798A CN 202111562411 A CN202111562411 A CN 202111562411A CN 114237798 A CN114237798 A CN 114237798A
- Authority
- CN
- China
- Prior art keywords
- target
- billboard
- field
- information
- dimension
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9038—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Human Computer Interaction (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application is applicable to the technical field of artificial intelligence, and provides a data processing method, a device, a server and a storage medium, wherein the method comprises the following steps: when the operation of confirming the kanban configuration is detected, generating a kanban attribute configuration interface and receiving kanban attribute information input by a user on the kanban attribute configuration interface; generating a main interactive interface according to the billboard attribute information; receiving a target chart control selected by a user on a main interactive interface, and a target dimension field and a target measurement field selected by aiming at the target chart control; generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from a target data source according to the data query statement; and according to the target dimension field, the target measurement field and the extracted data, performing data filling on the initial chart corresponding to the target chart control to obtain the target billboard. The method and the device can improve the efficiency of analyzing the service data.
Description
Technical Field
The present application relates to the field of artificial intelligence technologies, and in particular, to a data processing method, an apparatus, a server, and a storage medium.
Background
Business Intelligence (BI) mainly utilizes some data technologies to mine the rules hidden behind and the reasons behind the summary phenomenon from the data to guide the development of Business.
In the related art, business personnel often need to visually compare and analyze a large amount of business data in a data billboard mode. Since the data signboards meeting the requirements are usually obtained by technical processing by technicians, business personnel need to submit the related requirements of the signboards to the technicians, and then the technicians manufacture the signboards meeting the requirements, which generally requires a time period of more than one week. Resulting in inefficient analysis of the traffic data.
Disclosure of Invention
In view of this, embodiments of the present application provide a data processing method, an apparatus, a server, and a storage medium, so as to solve the problem in the related art that the efficiency of analyzing service data is low.
A first aspect of an embodiment of the present application provides a data processing method, including:
when the operation of billboard configuration confirmation is detected, a billboard attribute configuration interface is generated, and billboard attribute information input by a user on the billboard attribute configuration interface is received, wherein the billboard attribute information comprises identification information of a target data source;
generating a main interactive interface according to the billboard attribute information, wherein the main interactive interface comprises a chart control group, a dimension field set and a measurement field set, and the dimension field set and the measurement field set belong to a target data source;
receiving a target chart control selected by a user on a main interactive interface, and a target dimension field and a target measurement field selected by aiming at the target chart control;
generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from a target data source according to the data query statement;
and according to the target dimension field, the target measurement field and the extracted data, performing data filling on the initial chart corresponding to the target chart control to obtain the target billboard.
Further, if the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, the main interactive interface further includes a plurality of page configuration sub-interfaces;
and each page configuration sub-interface is used for receiving page configuration information input aiming at the corresponding billboard page.
Further, receiving a target chart control selected by a user on the main interactive interface and a target dimension field and a target measurement field selected by the user aiming at the target chart control, wherein the steps comprise:
and aiming at each page configuration sub-interface, receiving a control identification of a target chart control, a dimension identification of a target dimension field aiming at the corresponding target chart control and a measurement identification of a target measurement field, which are input on the corresponding page configuration sub-interface by a user.
Further, receiving a target chart control selected by a user on the main interactive interface and a target dimension field and a target measurement field selected by the user aiming at the target chart control, wherein the steps comprise:
and on each page configuration sub-interface, receiving a target chart control selected by a user according to the corresponding page configuration sub-interface execution control operation, receiving a target dimension field selected by the user according to the selected target chart control execution dimension operation, and receiving a target measurement field selected by the user according to the selected target chart control execution measurement operation.
Further, the method further comprises:
when the fact that the release state of the target billboard is changed into the state needing to be released is detected, an access link used for being linked to the target billboard is generated;
and when an access request aiming at the access link is detected, determining the identity of the requester, and if the identity of the requester does not belong to the authorized user identity set, presenting the fuzzy processed target billboard to the requester.
Further, the method further comprises:
when the identity identifier of the requester does not belong to the authorized user identifier set, if a continuous access request of the requester is detected, sending the continuous access request to a target terminal for authorization permission;
and when the permission indication information sent by the target terminal is received, the target billboard is presented to the requester.
Further, the method further comprises:
when a data source construction operation is detected, receiving measurement information input by a user and a plurality of main dimension information aiming at the measurement information, wherein each main dimension information comprises sub-dimension information respectively;
combining to obtain a plurality of granularity information aiming at the measurement information according to the plurality of main dimension information and the sub-dimension information included in each main dimension information;
and for each piece of granularity information, extracting the measurement data corresponding to the corresponding granularity information from a preset storage server, and correspondingly storing the extracted measurement data and the corresponding granularity information into a target data source.
A second aspect of an embodiment of the present application provides a data processing apparatus, including:
the information presentation unit is used for generating a billboard attribute configuration interface and receiving billboard attribute information input by a user on the billboard attribute configuration interface when a billboard configuration confirmation operation is detected, wherein the billboard attribute information comprises identification information of a target data source;
the system comprises an information generation unit, a main interaction interface and a target data source, wherein the information generation unit is used for generating the main interaction interface according to the billboard attribute information, the main interaction interface comprises a chart control group, a dimension field set and a measurement field set, and the dimension field set and the measurement field set belong to the target data source;
the information receiving unit is used for receiving a target chart control selected by a user on the main interactive interface, and a target dimension field and a target measurement field selected by aiming at the target chart control;
the data query unit is used for generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from a target data source according to the data query statement;
and the billboard generation unit is used for performing data filling on the initial chart corresponding to the target chart control according to the target dimension field, the target measurement field and the extracted data to obtain the target billboard.
Further, if the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, the main interactive interface further includes a plurality of page configuration sub-interfaces; and each page configuration sub-interface is used for receiving page configuration information input aiming at the corresponding billboard page.
Further, the information receiving unit is specifically configured to: and aiming at each page configuration sub-interface, receiving a control identification of a target chart control, a dimension identification of a target dimension field aiming at the corresponding target chart control and a measurement identification of a target measurement field, which are input on the corresponding page configuration sub-interface by a user.
Further, the information receiving unit is specifically configured to: and on each page configuration sub-interface, receiving a target chart control selected by a user according to the corresponding page configuration sub-interface execution control operation, receiving a target dimension field selected by the user according to the selected target chart control execution dimension operation, and receiving a target measurement field selected by the user according to the selected target chart control execution measurement operation.
Further, the device also comprises a link generation unit and a billboard presentation unit.
The link generation unit is used for generating an access link for linking to the target billboard when detecting that the release state of the target billboard is changed into a state needing to be released;
and the billboard presentation unit is used for determining the identity of the requester when detecting an access request for the access link, and presenting the fuzzed target billboard to the requester if the identity of the requester does not belong to the authorized user identity set.
Further, the device also comprises a license requesting unit and a content presenting unit.
The authorization request unit is used for sending a continuous access request to a target terminal for authorization permission if the continuous access request of the requester is detected when the identity identifier of the requester does not belong to the authorized user identifier set;
and the content presentation unit is used for presenting the target billboard to the requester when the permission indication information sent by the target terminal is received.
Further, the device also comprises an operation detection unit, an information combination unit and an object construction unit.
The data source construction method comprises an operation detection unit, a data source construction unit and a data source construction unit, wherein the operation detection unit is used for receiving measurement information input by a user and a plurality of main dimension information aiming at the measurement information when a data source construction operation is detected, and each main dimension information comprises sub-dimension information;
the information combination unit is used for combining to obtain a plurality of granularity information aiming at the measurement information according to the plurality of main dimension information and the sub-dimension information included in each main dimension information;
and the target construction unit is used for extracting the measurement data corresponding to the corresponding granularity information from the preset storage server aiming at each granularity information, and correspondingly storing the extracted measurement data and the corresponding granularity information into the target data source.
A third aspect of embodiments of the present application provides a server, which includes a memory, a processor, and a computer program stored in the memory and executable on the server, and when the processor executes the computer program, the processor implements the steps of the data processing method provided in the first aspect.
A fourth aspect of embodiments of the present application provides a computer-readable storage medium, in which a computer program is stored, and the computer program, when executed by a processor, implements the steps of the data processing method provided by the first aspect.
The data processing method, the data processing device, the server and the storage medium provided by the embodiment of the application have the following beneficial effects: the business personnel can obtain the data billboard meeting the requirement by configuring the required billboard form and the required data on the configuration interface, can realize the flexible configuration of the required data billboard, and is beneficial to improving the efficiency of analyzing the business data.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required to be used in the embodiments or the related technical descriptions will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.
Fig. 1 is a flowchart of an implementation of a data processing method provided in an embodiment of the present application;
FIG. 2 is a flow chart of an implementation for presenting a generated target billboard provided by an embodiment of the present application;
FIG. 3 is a flow chart of another implementation of a data processing method provided by an embodiment of the present application;
fig. 4 is a block diagram of a data processing apparatus according to an embodiment of the present application;
fig. 5 is a block diagram of a server according to an embodiment of the present disclosure.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The embodiment of the application can acquire and process related data based on an artificial intelligence technology. Among them, Artificial Intelligence (AI) is a theory, method, technique and application system that simulates, extends and expands human Intelligence using a digital computer or a machine controlled by a digital computer, senses the environment, acquires knowledge and uses the knowledge to obtain the best result.
The artificial intelligence infrastructure generally includes technologies such as sensors, dedicated artificial intelligence chips, cloud computing, distributed storage, big data processing technologies, operation/interaction systems, mechatronics, and the like. The artificial intelligence software technology mainly comprises a computer vision technology, a robot technology, a biological recognition technology, a voice processing technology, a natural language processing technology, machine learning/deep learning and the like.
In the embodiment of the application, the efficiency of analyzing the business data is improved based on the artificial intelligence technology.
The data processing method according to the embodiment of the present application may be executed by a server. When the data processing method is executed by the server, the execution subject is the server.
It should be noted that the server may include, but is not limited to, a server, a computer, a mobile phone, a tablet, a wearable smart device, and the like. The server may be an independent server, or may be a cloud server that provides basic cloud computing services such as a cloud service, a cloud database, cloud computing, a cloud function, cloud storage, a web service, cloud communication, a middleware service, a domain name service, a security service, a Content Delivery Network (CDN), and a big data and artificial intelligence platform.
Referring to fig. 1, fig. 1 shows a flowchart of an implementation of a data processing method according to an embodiment of the present application, including:
The billboard attribute information comprises identification information of a target data source. The target data source may be a variety of data sources. The data in the target data source is available for use in generating the desired data slate. In practice, the billboard attribute information may further include at least one of: name of billboard, number of billboard pages, and set of authorized user identifications. The name of the signboard is generally the name of a data signboard. The number of billboard pages described above is typically the number of pages of the data billboard. In practice, the data billboard can include multiple billboard pages, and each billboard page presents a portion of the content of the data billboard. The authorized user identifiers in the authorized user identifier set are used for indicating the identifiers of the users who can view the data billboard.
The bulletin board attribute configuration interface is generally an interface for configuring attributes of a data bulletin board.
The kanban configuration confirming operation is generally an operation for determining the configuration of the data kanban. For example, the operation may be an operation of clicking a preset hardware key, or an operation of clicking a preset software key.
In this embodiment, the execution body may detect the kanban configuration confirmation operation. For example, if the execution body can directly interact with the user, the execution body can detect the kanban configuration confirmation operation through a sensor installed in the execution body. For another example, if the execution main body interacts with the user through the user terminal, the execution main body may detect the kanban configuration confirmation operation through the user terminal.
After detecting the kanban configuration confirmation operation, the execution main body may generate a kanban attribute configuration interface and display the generated kanban attribute configuration interface. In this way, the user can enter kanban attribute information on the kanban attribute configuration interface.
And 102, generating a main interactive interface according to the billboard attribute information.
The main interactive interface comprises a chart control group, a dimension field set and a measurement field set. The set of dimension fields and the set of metric fields belong to the target data source. It should be noted that the dimension field in the dimension field set is generally a field name of a field of a certain dimension. The metric field in the metric field set above generally refers to the field name of the field of a certain metric.
The dimension generally refers to an angle of observation data, such as a country angle, a year angle, a product category angle, a gender angle, an age angle, and the like. The metric is typically a statistical value observed by the aggregation, and may be, for example, sales, rate of decline, loss, etc. Refers to a measure of the data in a dimension. For example, the dimension may be china, usa, millet cell phones, and the metric may be sales volume.
In practice, the chart controls in the chart control group may include, but are not limited to: pie chart controls, histogram controls, scatter chart controls, radar chart controls, and funnel chart controls. In practical application, each chart control in the chart control group corresponds to an initial chart. For example, the pie chart control corresponds to an initial pie chart, and the radar chart control corresponds to an initial radar chart.
In practice, the main interactive interface is generally an interface for interacting with a user to generate a data billboard desired by the user. The main interactive interface can present each chart control in the chart control group, can also present the field name of each dimension field in the target data source, and can also present the field name of each measurement field in the target data source.
Here, the execution body may extract names of all dimension fields in the target data source to obtain the dimension field set and extracts names of all measurement fields to obtain the measurement field set by using the identification information of the target data source in the kanban attribute information. Then, the execution body may render the obtained dimension field set, the obtained measurement field set, and the obtained graph control group according to a preset rendering manner to generate the main interactive interface.
And 103, receiving a target chart control selected by a user on the main interactive interface, and a target dimension field and a target measurement field selected by aiming at the target chart control.
The target chart control is usually a selected chart control. The target dimension field is typically a selected dimension field. The target metric field is typically a selected metric field.
Here, the user may directly select the target chart control according to the content presented by the main interactive interface, and select the target dimension field and the target measurement field for the target chart control. In this way, the execution difficult body can obtain the target chart control, the target dimension field, and the target metric field.
As an example, the target chart control may be obtained by receiving a control identifier of the target chart control input by a user, the target dimension field may be obtained by receiving a dimension identifier of the target dimension field input by the user, and the target measurement field may be obtained by receiving a measurement identifier of the target measurement field input by the user.
And 104, generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from a target data source according to the data query statement.
Here, the execution body may obtain a main dimension to which the target dimension field belongs by using the target dimension field, write a preset query template by using the main dimension, the target dimension field in the main dimension, and the target metric field, and generate a data query statement by combining the preset query template. Then, the execution subject may search for data matching the target dimension field and the target metric field from the target data source by using the generated data query statement.
For example, if the target dimension field is "2021 year", "brand a mobile phone" and "brand B mobile phone", and if the target metric field is "sales volume", the execution subject may extract data adapted to the target dimension field and the target metric field from the target data source, so as to obtain sales volume of the brand a mobile phone of 2021 year and sales volume of the brand B mobile phone of 2021 year.
And 105, performing data filling on the initial chart corresponding to the target chart control according to the target dimension field, the target measurement field and the extracted data to obtain the target billboard.
Wherein the target kanban is generally a generated data kanban.
Here, the execution body may fill the data obtained by the query into the initial chart corresponding to the target chart control, so as to obtain the target kanban. It is noted that, by default, the target kanban generated typically has one kanban page.
According to the method provided by the embodiment, the business personnel can obtain the data billboard meeting the requirement by configuring the required billboard form and the required data on the configuration interface, so that the required data billboard can be flexibly configured, and the efficiency of analyzing the business data is improved.
In some optional implementation manners of this embodiment, if the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, the main interactive interface further includes a plurality of page configuration sub-interfaces.
And each page configuration sub-interface is used for receiving page configuration information input aiming at the corresponding billboard page. The page configuration information is generally information for configuring a billboard page. In practice, the page configuration information may include, but is not limited to: page title, page size.
In practical application, when the number of the kanban pages is N, the main interactive interface may include N page configuration sub-interfaces, and one page configuration sub-interface is used to perform information configuration on one kanban page.
Here, the kanban attribute information further includes a kanban page number indicating that there are a plurality of kanban pages, and the finally generated data kanban is a data kanban including a plurality of kanban pages. It should be noted that, when the resulting data billboard including a plurality of billboard pages is presented, the presentation may be a split-screen presentation or a layered presentation.
In some optional implementations, the receiving the target chart control selected by the user in the main interactive interface and the target dimension field and the target metric field selected for the target chart control may include: and aiming at each page configuration sub-interface, receiving a control identification of a target chart control, a dimension identification of a target dimension field aiming at the corresponding target chart control and a measurement identification of a target measurement field, which are input on the corresponding page configuration sub-interface by a user.
The control id of the target chart control is usually identification information for indicating the target chart control. E.g., may be the name of the target chart control. For example, it may be a pie chart. The dimension identifier of the target dimension field is usually identification information for indicating the target dimension field. For example, the number of the target dimension field may be, for example, 001. The metric identifier of the target metric field is usually identification information for indicating the target dimension. E.g., can be the sequence number of the target dimension field, e.g., can be No. 1.
Here, when the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, there are a plurality of page configuration sub-interfaces on the main interactive interface. At this time, for each page configuration sub-interface, the execution main body may receive a control identifier of the target chart control, a dimension identifier of the target dimension field for the target chart control, and a measurement identifier of the target measurement field, which are input on the page configuration sub-interface by the user. Here, the desired controls, metrics, and dimensions can be obtained by entering the identification on each sub-interface. The operation is convenient, and the user experience is promoted.
In some optional implementations, the receiving a target chart control selected by a user in a main interactive interface and a target dimension field and a target metric field selected for the target chart control includes: and on each page configuration sub-interface, receiving a target chart control selected by a user according to the corresponding page configuration sub-interface execution control operation, receiving a target dimension field selected by the user according to the selected target chart control execution dimension operation, and receiving a target measurement field selected by the user according to the selected target chart control execution measurement operation. The control operation is generally an operation for dragging and selecting a chart control. The dimension operation is generally an operation for dragging a selected dimension field. The above-described metric operation is generally an operation for dragging a selection metric field.
Here, when the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, there are a plurality of page configuration sub-interfaces on the main interactive interface. At this time, for each page configuration sub-interface, the execution main body may receive a target chart control dragged to the page configuration sub-interface by the user according to the corresponding page configuration sub-interface execution control operation, may also receive a target dimension field dragged to the page configuration sub-interface by the user according to the target chart control execution dimension operation, and may also receive a target measurement field dragged to the page configuration sub-interface by the user according to the target chart control execution dimension operation.
Here, the user can select a desired chart control, dimension field, and measurement field by performing a drag operation. The operation is convenient, and the user experience is promoted.
Referring to fig. 2, fig. 2 is a flowchart of an implementation for presenting a generated target billboard according to an embodiment of the present application.
Here, after the target kanban is generated, the user can set the distribution status of the target kanban to a status that needs to be distributed. At this point, the execution agent may detect the change in the publication status and generate an access link for linking to the target kanban. In this way, other users may access the target billboard through the access link.
The requesting party may be a terminal or a server.
Here, when receiving an access request from a certain requestor, if the execution principal finds that the id of the requestor does not belong to the authorized user id set, at this time, the requestor does not have access right, and the execution principal may present only the obfuscated target kanban to the user. So as to protect the privacy of the content of the target billboard.
In some optional implementations, the data processing method may further include the following steps.
Step one, when the identity identification of the requester does not belong to the authorized user identification set, if the continuous access request of the requester is detected, the continuous access request is sent to the target terminal for authorization permission.
The target terminal is generally a terminal of a user configured to generate the target billboard. The above-mentioned continued access request is generally information for requesting continued access to the target kanban.
Here, if the requester continues to send the request for continued access when the id of the requester does not belong to the authorized user id set, the executing entity may send the request for continued access to the target terminal to allow authorization through the target terminal, for example, may allow authorization through some authorization setup message on the target terminal.
And step two, when the permission indication information sent by the target terminal is received, the target billboard is presented to the requester.
The permission indication information is generally information indicating that the user is authorized.
Here, the execution agent may receive information indicating whether authorization is transmitted from the target terminal. If the permission indication information is received, permission authorization is represented, and otherwise, non-authorization is represented. Upon receiving the permission indication information, the execution principal may present the original target kanban to the requestor. Thus, the target signboard can be managed more flexibly and practically.
Referring to fig. 3, fig. 3 is a flowchart illustrating an implementation of a data processing method according to an embodiment of the present disclosure. The data processing method provided by this embodiment may include the following steps:
Wherein each main dimension information comprises sub-dimension information respectively. The metric information is generally information indicating a metric. For example, the metric information may be "sales". The primary dimension information is generally information indicating a primary dimension, and may be, for example, "year", "product category", "country". Wherein the main dimension is a dimension with a larger particle size than the sub-dimension. For example, the primary dimension may be year, and the sub-dimensions included in the primary dimension may be 2021 years, 2020 years, and so on.
The data source building operation is generally an operation for determining a building data source. The embodiment does not limit the specific implementation form of the data source construction operation.
Here, the user can perform a data source construction operation. The execution subject can detect the data source construction operation and receive the measurement information input by the user and a plurality of main dimension information aiming at the measurement information.
Here, the execution body may use a plurality of pieces of main dimension information, and the sub-dimension information included in each piece of main dimension information may be arranged and combined to obtain a plurality of pieces of granularity information.
For example, if there are n pieces of main dimension information, there are n pieces of main dimensions. If Mi denotes the number of sub-dimensions in the ith main dimension, Q particle sizes can be combined, where Q is M1 × M2 × … × Mi × … × Mn.
For example, if there are 2 pieces of main dimension information, there are 2 pieces of main dimensions. If the sub-dimension information included in the first main dimension information is 2020 and 2021, and the sub-dimension information included in the second main dimension information is brand a mobile phone and brand B mobile phone, 4 granularities can be obtained by combining, where 4 is 2 × 2. And the obtained 4 pieces of granularity information are respectively: the year 2020-brand a mobile phone-sales volume, the year 2020-brand B mobile phone-sales volume, the year 2021-brand a mobile phone-sales volume, and the year 2021-brand B mobile phone-sales volume.
And 303, extracting the measurement data corresponding to the corresponding granularity information from a preset storage server according to each granularity information, and correspondingly storing the extracted measurement data and the corresponding granularity information into a target data source.
The preset storage server is generally a preset server for storing data. The preset storage server generally stores a large amount of data.
Here, the execution body may extract, for each piece of granularity information, metric data corresponding to the granularity information from a preset storage server, and store the extracted metric data in the target data source in correspondence with the granularity information. In this way, the target data source can be constructed.
It should be noted that the obtained target data source is constructed based on the dimension required by the user, and in the subsequent data use process, only data needs to be extracted from the target data source, so that the data query efficiency can be improved.
The billboard attribute information comprises identification information of the target data source.
And 305, generating a main interactive interface according to the billboard attribute information.
The main interactive interface comprises a chart control group, a dimension field set and a measurement field set, wherein the dimension field set and the measurement field set belong to a target data source.
And step 306, receiving a target chart control selected by the user on the main interactive interface, and a target dimension field and a target measurement field selected by aiming at the target chart control.
And 307, generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from a target data source according to the data query statement.
And 308, according to the target dimension field, the target measurement field and the extracted data, performing data filling on the initial chart corresponding to the target chart control to obtain the target billboard.
In the present embodiment, the specific operations of steps 304-308 are substantially the same as the operations of steps 101-105 in the embodiment shown in fig. 1, and are not repeated herein.
The embodiment can realize that the granularity is established in advance according to the data required by the user, and the association storage is established between each granularity and the granularity data, so that the data source is established. The data are searched from the target data source with less data volume, and the required data are searched from massive data in the related technology.
Referring to fig. 4, fig. 4 is a block diagram of a data processing apparatus 400 according to an embodiment of the present disclosure. The data processing apparatus in this embodiment comprises units for performing the steps in the embodiments corresponding to fig. 1-3. Please refer to fig. 1-3 and the related descriptions of the embodiments corresponding to fig. 1-3. For convenience of explanation, only the portions related to the present embodiment are shown. Referring to fig. 4, the data processing apparatus 400 includes:
the information presentation unit 401 is configured to generate a billboard attribute configuration interface when a billboard configuration confirmation operation is detected, and receive billboard attribute information input by a user on the billboard attribute configuration interface, where the billboard attribute information includes identification information of a target data source;
the information generating unit 402 is configured to generate a main interactive interface according to the billboard attribute information, where the main interactive interface includes a chart control group, a dimension field set, and a measurement field set, and the dimension field set and the measurement field set belong to a target data source;
an information receiving unit 403, configured to receive a target chart control selected by a user on a main interactive interface, and a target dimension field and a target metric field selected for the target chart control;
a data query unit 404, configured to generate a data query statement according to the target dimension field and the target metric field, and extract data adapted to the target dimension field and the target metric field from the target data source according to the data query statement;
and a billboard generation unit 405, configured to perform data filling on the initial chart corresponding to the target chart control according to the target dimension field, the target measurement field, and the extracted data, so as to obtain the target billboard.
As an embodiment of the application, if the billboard attribute information further includes the number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, the main interactive interface further includes a plurality of page configuration sub-interfaces; and each page configuration sub-interface is used for receiving page configuration information input aiming at the corresponding billboard page.
As an embodiment of the present application, the information receiving unit 403 is specifically configured to: and aiming at each page configuration sub-interface, receiving a control identification of a target chart control, a dimension identification of a target dimension field aiming at the corresponding target chart control and a measurement identification of a target measurement field, which are input on the corresponding page configuration sub-interface by a user.
As an embodiment of the present application, the information receiving unit 403 is specifically configured to: and on each page configuration sub-interface, receiving a target chart control selected by a user according to the corresponding page configuration sub-interface execution control operation, receiving a target dimension field selected by the user according to the selected target chart control execution dimension operation, and receiving a target measurement field selected by the user according to the selected target chart control execution measurement operation.
As an embodiment of the present application, the apparatus further includes a link generation unit and a billboard presentation unit (not shown in the figure). The link generation unit is used for generating an access link for linking to the target billboard when detecting that the release state of the target billboard is changed into a state needing to be released. And the billboard presentation unit is used for determining the identity of the requester when detecting an access request for the access link, and presenting the fuzzed target billboard to the requester if the identity of the requester does not belong to the authorized user identity set.
As an embodiment of the present application, the apparatus further includes a license requesting unit and a content presenting unit (not shown in the figure). The authorization request unit is used for sending a continuous access request to a target terminal for authorization permission if the continuous access request of the requester is detected when the identity of the requester does not belong to the authorized user identity set. And the content presentation unit is used for presenting the target billboard to the requester when the permission indication information sent by the target terminal is received.
As an embodiment of the present application, the apparatus further includes an operation detection unit, an information combination unit, and an object construction unit (not shown in the figure). The data source construction method comprises an operation detection unit, a data source construction unit and a data source construction unit, wherein the operation detection unit is used for receiving measurement information input by a user and a plurality of main dimension information aiming at the measurement information when a data source construction operation is detected, and each main dimension information comprises sub-dimension information. And the information combination unit is used for combining the multiple pieces of granularity information aiming at the measurement information according to the multiple pieces of main dimension information and the sub-dimension information included in each piece of main dimension information. And the target construction unit is used for extracting the measurement data corresponding to the corresponding granularity information from the preset storage server aiming at each granularity information, and correspondingly storing the extracted measurement data and the corresponding granularity information into the target data source.
According to the device provided by the embodiment, the business personnel can obtain the data billboard meeting the requirement by configuring the required billboard form and the required data on the configuration interface, so that the required data billboard can be flexibly configured, and the efficiency of analyzing the business data is improved.
It should be understood that, in the structural block diagram of the data processing apparatus shown in fig. 4, each unit is used to execute each step in the embodiment corresponding to fig. 1 to fig. 3, and each step in the embodiment corresponding to fig. 1 to fig. 3 has been explained in detail in the above embodiment, and specific reference is made to the relevant description in the embodiment corresponding to fig. 1 to fig. 3 and fig. 1 to fig. 3, which is not repeated herein.
Fig. 5 is a block diagram of a server according to another embodiment of the present application. As shown in fig. 5, the server 500 of this embodiment includes: a processor 501, a memory 502 and a computer program 503, such as a program of a data processing method, stored in the memory 502 and executable on the processor 501. The processor 501 executes the computer program 503 to implement the steps in the embodiments of the data processing methods, such as the steps 101 to 105 shown in fig. 1. Alternatively, when the processor 501 executes the computer program 503, the functions of the units in the embodiment corresponding to fig. 4, for example, the functions of the units 401 to 405 shown in fig. 4, are implemented, for which reference is specifically made to the relevant description in the embodiment corresponding to fig. 4, which is not described herein again.
Illustratively, the computer program 503 may be divided into one or more units, which are stored in the memory 502 and executed by the processor 501 to accomplish the present application. One or more elements may be a series of computer program instruction segments capable of performing certain functions, which are used to describe the execution of computer program 503 in server 500. For example, the computer program 503 may be divided into an information presenting unit, an information generating unit, an information receiving unit, a data querying unit, and a billboard generating unit, and the specific functions of each unit are as described above.
The server may include, but is not limited to, a processor 501, a memory 502. Those skilled in the art will appreciate that fig. 5 is merely an example of a server 500, and does not constitute a limitation on server 500, and may include more or fewer components than shown, or some components in combination, or different components, e.g., a turntable device may also include input output devices, network access devices, buses, etc.
The Processor 501 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage 502 may be an internal storage unit of the server 500, such as a hard disk or a memory of the server 500. The memory 502 may also be an external storage device of the server 500, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), etc. provided on the server 500. Further, memory 502 may also include both internal storage units of server 500 and external storage devices. The memory 502 is used for storing computer programs and other programs and data required by the turntable device. The memory 502 may also be used to temporarily store data that has been output or is to be output.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated module, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in a computer readable storage medium. The computer readable storage medium may be non-volatile or volatile. Based on such understanding, all or part of the flow in the method of the embodiments described above can be realized by a computer program, which can be stored in a computer readable storage medium and can realize the steps of the embodiments of the methods described above when the computer program is executed by a processor. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable storage medium may include: any entity or device capable of carrying computer program code, recording medium, U.S. disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution media, and the like. It should be noted that the computer readable storage medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable storage media that does not include electrical carrier signals and telecommunications signals in accordance with legislation and patent practice.
The above embodiments are only used to illustrate the technical solutions of the present application, and not to limit the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present application and are intended to be included within the scope of the present application.
Claims (10)
1. A method of data processing, the method comprising:
when the kanban configuration confirmation operation is detected, generating a kanban attribute configuration interface, and receiving kanban attribute information input by a user on the kanban attribute configuration interface, wherein the kanban attribute information comprises identification information of a target data source;
generating a main interactive interface according to the billboard attribute information, wherein the main interactive interface comprises a chart control group, a dimension field set and a measurement field set, and the dimension field set and the measurement field set belong to the target data source;
receiving a target chart control selected by a user on the main interactive interface, and a target dimension field and a target measurement field selected aiming at the target chart control;
generating a data query statement according to the target dimension field and the target measurement field, and extracting data matched with the target dimension field and the target measurement field from the target data source according to the data query statement;
and according to the target dimension field, the target measurement field and the extracted data, performing data filling on the initial chart corresponding to the target chart control to obtain the target billboard.
2. The data processing method of claim 1, wherein if the billboard attribute information further includes a number of billboard pages, and the number of billboard pages indicates that there are a plurality of billboard pages, then the main interactive interface further includes a plurality of page configuration sub-interfaces;
and each page configuration sub-interface is used for receiving page configuration information input aiming at the corresponding billboard page.
3. The data processing method of claim 2, wherein the receiving the target chart control selected by the user at the main interactive interface and the target dimension field and the target metric field selected for the target chart control comprises:
and aiming at each page configuration sub-interface, receiving a control identification of a target chart control, a dimension identification of a target dimension field aiming at the corresponding target chart control and a measurement identification of a target measurement field, which are input on the corresponding page configuration sub-interface by a user.
4. The data processing method of claim 2, wherein the receiving the target chart control selected by the user at the main interactive interface and the target dimension field and the target metric field selected for the target chart control comprises:
and on each page configuration sub-interface, receiving a target chart control selected by a user according to the corresponding page configuration sub-interface execution control operation, receiving a target dimension field selected by the user according to the selected target chart control execution dimension operation, and receiving a target measurement field selected by the user according to the selected target chart control execution measurement operation.
5. The data processing method of claim 1, wherein the method further comprises:
when the fact that the release state of the target billboard is changed into a state needing to be released is detected, an access link used for being linked to the target billboard is generated;
and when an access request aiming at the access link is detected, determining the identity of a requester, and if the identity of the requester does not belong to an authorized user identity set, presenting the fuzzy processed target billboard to the requester.
6. The data processing method of claim 5, wherein the method further comprises:
when the identity of the requester does not belong to the authorized user identity set, if a continuous access request of the requester is detected, sending the continuous access request to a target terminal for authorization permission;
and when the permission indication information sent by the target terminal is received, the target billboard is presented to the requester.
7. The data processing method according to any one of claims 1 to 6, characterized in that the method further comprises:
when a data source construction operation is detected, receiving measurement information input by a user and a plurality of main dimension information aiming at the measurement information, wherein each main dimension information comprises sub-dimension information respectively;
combining to obtain a plurality of granularity information aiming at the measurement information according to the plurality of main dimension information and the sub-dimension information included in each main dimension information;
and for each piece of granularity information, extracting the measurement data corresponding to the corresponding granularity information from a preset storage server, and correspondingly storing the extracted measurement data and the corresponding granularity information into the target data source.
8. A data processing apparatus, characterized in that the apparatus comprises:
the system comprises an information presentation unit, a target data source identification unit and a display unit, wherein the information presentation unit is used for generating a billboard attribute configuration interface when a billboard configuration confirmation operation is detected, and receiving billboard attribute information input by a user on the billboard attribute configuration interface, wherein the billboard attribute information comprises identification information of the target data source;
the information generating unit is used for generating a main interactive interface according to the billboard attribute information, wherein the main interactive interface comprises a chart control group, a dimension field set and a measurement field set, and the dimension field set and the measurement field set belong to the target data source;
the information receiving unit is used for receiving a target chart control selected by a user on the main interactive interface and a target dimension field and a target measurement field selected by aiming at the target chart control;
the data query unit is used for generating a data query statement according to the target dimension field and the target metric field, and extracting data matched with the target dimension field and the target metric field from the target data source according to the data query statement;
and the billboard generation unit is used for performing data filling on the initial chart corresponding to the target chart control according to the target dimension field, the target measurement field and the extracted data to obtain the target billboard.
9. A server comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the steps of the method according to any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111562411.6A CN114237798A (en) | 2021-12-20 | 2021-12-20 | Data processing method, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111562411.6A CN114237798A (en) | 2021-12-20 | 2021-12-20 | Data processing method, device, server and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114237798A true CN114237798A (en) | 2022-03-25 |
Family
ID=80759254
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111562411.6A Pending CN114237798A (en) | 2021-12-20 | 2021-12-20 | Data processing method, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114237798A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114995931A (en) * | 2022-05-03 | 2022-09-02 | 远光软件股份有限公司 | Display method and device of project bulletin board, storage medium and computer equipment |
-
2021
- 2021-12-20 CN CN202111562411.6A patent/CN114237798A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114995931A (en) * | 2022-05-03 | 2022-09-02 | 远光软件股份有限公司 | Display method and device of project bulletin board, storage medium and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268253B (en) | Interface code generation method and terminal equipment | |
| CN109062780B (en) | Development method of automatic test case and terminal equipment | |
| US11210426B2 (en) | Tracing objects across different parties | |
| CN107862425B (en) | Wind control data acquisition method, device and system and readable storage medium | |
| CN111488995B (en) | Method, device and system for evaluating joint training model | |
| CN112163412B (en) | Data verification method and device, electronic equipment and storage medium | |
| CN111367965B (en) | Target object determining method, device, electronic equipment and storage medium | |
| CN110659206A (en) | Simulation architecture establishing method, device, medium and electronic equipment based on microservice | |
| CN111638908A (en) | Interface document generation method and device, electronic equipment and medium | |
| CN108255967B (en) | Method and device for calling storage process, storage medium and terminal | |
| CN112017007A (en) | User behavior data processing method and device, computer equipment and storage medium | |
| WO2016188334A1 (en) | Method and device for processing application access data | |
| CN111523679A (en) | Feature binning method, device and readable storage medium | |
| CN114239026A (en) | Information desensitization conversion processing method, device, computer equipment and storage medium | |
| CN114237798A (en) | Data processing method, device, server and storage medium | |
| CN116069838A (en) | Data processing method, device, computer equipment and storage medium | |
| US20220164377A1 (en) | Method and apparatus for distributing content across platforms, device and storage medium | |
| CN114298699B (en) | Method for generating and acquiring non-homogeneous general evidence and device | |
| CN115563942A (en) | Contract generation method and device, electronic equipment and computer readable medium | |
| CN111078569B (en) | Method and device for testing optical character recognition application and storage medium | |
| CN113935847A (en) | Online process risk processing method, device, server and medium | |
| CN113190562A (en) | Report generation method and device and electronic equipment | |
| CN113486222A (en) | Display method of power data display interface, user terminal, server and system | |
| CN112100534A (en) | Information processing method, device, medium and electronic equipment in page sharing | |
| CN107368597B (en) | Information output method and device |
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 |