Data acquisition method, device, apparatus and storage medium

Abstract

The application provides a data acquisition method and device, equipment and storage medium. It relates to the technical field of resource management. The method displays a first report configuration interface in response to a first operation input by a user, the first report configuration interface including a plurality of preset data dimensions and a plurality of preset data attributes; generates a first personalized report in response to a second operation of the user in the first report configuration interface for a first data dimension and a first data attribute, and displays a first report selection interface, the first report selection interface including the first personalized report and a plurality of preset reports; and acquires first data in a database using the first personalized report in response to a third operation of the user in the first report selection interface for the first personalized report, and outputs the first data. In this way, the flexibility of data acquisition is increased, and the user experience is improved.

Description

Technical Field

[0001] This application relates to the field of resource management technology, and in particular to a data acquisition method, apparatus, device and storage medium. Background Technology

[0002] With the continuous development of the internet, the amount of data generated is increasing, and a large amount of this data is usually stored in databases. When users need certain data, they can retrieve the data they need from the database.

[0003] Currently, data can be retrieved from a database by exporting data reports. Specifically, users can select a desired statistical report from a set of pre-defined reports, allowing the electronic device to retrieve the corresponding data from the database based on the report's content and export a data report containing the retrieved data in that report's format.

[0004] However, users may need to obtain various types of data, and the pre-set statistical reports in the existing technology may not include the statistical reports that users need, which makes the flexibility of obtaining data through statistical reports poor and affects the user experience. Summary of the Invention

[0005] This application provides a data acquisition method, apparatus, device, and storage medium to solve the problem of poor user experience caused by low data acquisition efficiency in the prior art.

[0006] Firstly, this application provides a data acquisition method, including:

[0007] Receive user input for the first operation to configure report content;

[0008] In response to the first operation, a first report configuration interface is displayed, which includes multiple preset data dimensions and multiple preset data attributes;

[0009] Receive a second operation from the user on the first report configuration interface for a first data dimension and a first data attribute, wherein the first data dimension is at least one of the plurality of preset data dimensions and the first data attribute is at least one of the plurality of preset data attributes;

[0010] In response to the second operation, a first personalized report is generated and a first report selection interface is displayed. The first report selection interface includes the first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports.

[0011] Receive a third operation from the user on the first personalized report in the first report selection interface;

[0012] In response to the third operation, the first data of the first data dimension and the first data attribute is obtained from the database using the first personalized report, and the first data is output in the form of a data report.

[0013] In one possible design, the first report configuration interface also includes a report name input box;

[0014] The second operation performed by the user on the first report configuration interface, targeting the first data dimension and the first data attribute, includes:

[0015] Receive the first personalized report name entered by the user in the report name input box;

[0016] The first personalized report name is stored in the database, and a target prompt message is displayed to indicate to the user that the first personalized report name has been successfully saved.

[0017] Receive the user's second operation on the first report configuration interface for the first data dimension and the first data attribute.

[0018] In one possible design, generating a first personalized report in response to the second operation includes:

[0019] Based on the first data dimension and the first data attribute, a corresponding query statement is generated. The query statement is used to retrieve the first data from the database based on the first data dimension and the first data attribute.

[0020] The query statement is stored in the database, and a correspondence is established between the query statement and the first personalized report name.

[0021] In one possible design, the first personalized report name and the query statement are stored in the configuration information main table, the first data dimension and the first data attribute are stored in the dimension attribute table, and the business name and the field corresponding to the business are stored in the business information dictionary table.

[0022] The step of retrieving the first data of the first data dimension and the first data attribute from the database using the first personalized report includes:

[0023] Based on the name of the first personalized report, retrieve the corresponding first data dimension and first data attribute from the dimension attribute table;

[0024] Based on the business name carried in the first data dimension and the business name carried in the first data attribute, obtain the corresponding target field in the business information dictionary table;

[0025] The first data is retrieved from the database based on the target field.

[0026] In one possible design, the first operation of receiving user input for configuring report content includes:

[0027] The second report selection interface is displayed. The second report selection interface includes the plurality of preset reports and configuration controls. The configuration controls are used to configure the report content. The plurality of preset reports include preset data degree and preset data attributes. The plurality of preset reports do not include the first personalized report.

[0028] Receive the first operation from the user on the configuration control.

[0029] In one possible design, the first report configuration interface further includes a feedback information input box, and the method further includes:

[0030] Receive a second data dimension and / or a second data attribute input by the user in the feedback information input box, wherein the second data dimension is a data dimension not included in the plurality of preset data dimensions, and the second data attribute is a data attribute not included in the plurality of preset data attributes;

[0031] Based on the second data dimension and / or the second data attribute, a request instruction is sent to the electronic device of the back-end technician. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

[0032] In one possible design, the method further includes:

[0033] Display the second report configuration interface, which includes the plurality of preset data dimensions, the plurality of preset data attributes, the second data dimension, and the second data attribute;

[0034] Receive the user's fourth operation on the second report configuration interface for the second data dimension and the second data attribute;

[0035] In response to the fourth operation, a second personalized report is generated and a third report selection interface is displayed. The third report selection interface includes the second personalized report and multiple preset reports. The content of the second personalized report is different from the content of the multiple preset reports.

[0036] Receive the user's fifth operation on the second personalized report in the third report selection interface;

[0037] In response to the fifth operation, the second personalized report is used in the database to obtain the second data corresponding to the second data dimension and the second data attribute, and the second data is output in the form of a data report.

[0038] Secondly, this application provides a data acquisition device, comprising:

[0039] The receiving module is used to receive user input for the first operation of configuring the report content;

[0040] The display module is used to respond to the first operation and display a first report configuration interface, which includes multiple preset data dimensions and multiple preset data attributes.

[0041] The receiving module is further configured to receive a second operation by the user on the first report configuration interface for the first data dimension and the first data attribute, wherein the first data dimension is at least one of the plurality of preset data dimensions and the first data attribute is at least one of the plurality of preset data attributes;

[0042] The processing module is used to generate a first personalized report in response to the second operation;

[0043] The display module is also used to display a first report selection interface, which includes the first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports.

[0044] The receiving module is also used to receive a third operation performed by the user on the first personalized report in the first report selection interface.

[0045] The processing module is further configured to respond to the third operation by using the first personalized report to obtain the first data of the first data dimension and the first data attribute from the database, and output the first data in the form of a data report.

[0046] In one possible design, the first report configuration interface further includes a report name input box; the receiving module is also used to receive a first personalized report name entered by the user in the report name input box.

[0047] The processing module is also used to store the first personalized report name in the database;

[0048] The display module is also used to display target prompt information, which is used to prompt the user that the first personalized report name has been saved successfully;

[0049] The receiving module is specifically used to receive the user's second operation on the first data dimension and the first data attribute in the first report configuration interface.

[0050] In one possible design, the processing module is specifically used to generate a corresponding query statement based on the first data dimension and the first data attribute. The query statement is used to retrieve the first data from the database based on the first data dimension and the first data attribute. The query statement is stored in the database, and a correspondence is established between the query statement and the first personalized report name.

[0051] In one possible design, the first personalized report name and the query statement are stored in a configuration information master table, the first data dimension and the first data attribute are stored in a dimension attribute table, and the business name and the corresponding field are stored in a business information dictionary table. Specifically, the processing module is used to retrieve the corresponding first data dimension and the first data attribute from the dimension attribute table based on the name of the first personalized report; retrieve the corresponding target field from the business information dictionary table based on the business name carried in the first data dimension and the business name carried in the first data attribute; and retrieve the first data from the database based on the target field.

[0052] In one possible design, the display module is further configured to display a second report selection interface, which includes the plurality of preset reports and configuration controls. The configuration controls are used to configure the report content. The plurality of preset reports include preset data degree and preset data attributes. The plurality of preset reports do not include the first personalized report.

[0053] The receiving module is specifically used to receive the first operation performed by the user on the configuration control.

[0054] In one possible design, the first report configuration interface further includes a feedback information input box, and the receiving module is further configured to receive a second data dimension and / or a second data attribute input by the user in the feedback information input box, wherein the second data dimension is a data dimension not included in the plurality of preset data dimensions, and the second data attribute is a data attribute not included in the plurality of preset data attributes;

[0055] The processing module is further configured to send a request instruction to the electronic device of the back-end technician based on the second data dimension and / or the second data attribute. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

[0056] In one possible design, the display module is further configured to display a second report configuration interface, the second report interface including the plurality of preset data dimensions, the plurality of preset data attributes, the second data dimension, and the second data attribute;

[0057] The receiving module is also used to receive a fourth operation by the user on the second report configuration interface for the second data dimension and the second data attribute;

[0058] The processing module is also configured to generate a second personalized report in response to the fourth operation.

[0059] The display module is also used to display a third report selection interface, which includes the second personalized report and multiple preset reports. The content of the second personalized report is different from the content of the multiple preset reports.

[0060] The receiving module is also used to receive a fifth operation performed by the user on the second personalized report in the third report selection interface.

[0061] The processing module is further configured to respond to the fifth operation by using the second personalized report in the database to obtain the second data corresponding to the second data dimension and the second data attribute, and output the second data in the form of a data report.

[0062] Thirdly, embodiments of this application provide an electronic device, including: at least one processor and a memory; the memory stores computer execution instructions; the at least one processor executes the computer execution instructions stored in the memory, causing the at least one processor to perform the data acquisition method as described in the first aspect and various possible designs of the first aspect.

[0063] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions. When a processor executes the computer-executable instructions, it implements the data acquisition method described in the first aspect and various possible designs of the first aspect.

[0064] Fifthly, embodiments of this application provide a computer program product, including a computer program that, when executed by a processor, implements the data acquisition method described in the first aspect and various possible designs of the first aspect.

[0065] The data acquisition method, apparatus, device, and storage medium provided in this application involve receiving a first operation input by a user for configuring report content; responding to the first operation, displaying a first report configuration interface, which includes multiple preset data dimensions and multiple preset data attributes; receiving a second operation from the user on the first report configuration interface regarding the first data dimension and the first data attribute, wherein the first data dimension is at least one of the multiple preset data dimensions, and the first data attribute is at least one of the multiple preset data attributes; responding to the second operation, generating a first personalized report and displaying a first report selection interface, which includes the first personalized report and multiple preset reports, the content of which is different from the content of the multiple preset reports; receiving a third operation from the user on the first report selection interface regarding the first personalized report; and responding to the third operation, using the first personalized report to retrieve first data of the first data dimension and the first data attribute from a database, and outputting the first data in the form of a data report. Thus, when the pre-set report does not meet the user's requirements, the electronic device can display a report configuration interface based on the user's operation, allowing the user to independently select the required data dimensions and data attributes in the displayed report configuration interface to create a personalized report specific to that user. This allows electronic devices to use personalized reports to retrieve data for corresponding dimensions and attributes from the database, making the retrieved data more aligned with user needs, increasing the flexibility of data retrieval, and improving the user experience. Attached Figure Description

[0066] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.

[0067] Figure 1 A flowchart illustrating a data acquisition method provided in an embodiment of this application;

[0068] Figure 2 A schematic diagram illustrating the display of a first report configuration interface on an electronic device provided in an embodiment of this application;

[0069] Figure 3 A schematic diagram illustrating the correspondence between stored tables provided in an embodiment of this application;

[0070] Figure 4 This is a schematic flowchart illustrating a method for configuring reports, as provided in an embodiment of this application.

[0071] Figure 5 A flowchart illustrating the process of generating a new report is provided for an embodiment of this application;

[0072] Figure 6A flowchart illustrating the process of adding a new data dimension and a new data attribute, provided for an embodiment of this application;

[0073] Figure 7 This is a schematic diagram of the structure of a test case management device provided in an embodiment of this application;

[0074] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application.

[0075] The accompanying drawings have illustrated specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to specific embodiments. Detailed Implementation

[0076] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.

[0077] It should be noted that the collection, storage, use, processing, transmission, provision, and disclosure of financial data or user data involved in the technical solution of this application all comply with the provisions of relevant laws and regulations and do not violate public order and good morals. The user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use, and processing of related data must comply with relevant laws, regulations, and standards, and corresponding operation entry points are provided for users to choose to authorize or refuse.

[0078] In fields such as finance, business data generated during user transactions is stored in databases, which can also store user identity information and other data. Business systems can retrieve and analyze this data from the database to better serve users.

[0079] Currently, when acquiring data from electronic devices, the required data can be exported from a database using data reports. Electronic devices can pre-store multiple statistical reports, which include the dimensions and attributes of the data to be acquired. When acquiring data through a business system, users can select the statistical report that meets their requirements from multiple reports, retrieve the corresponding data from the database using the dimensions and attributes specified in that report, and then export the data as a data report.

[0080] However, the data dimensions and attributes in the pre-stored statistical reports in electronic devices are fixed, while the dimensions and attributes required by users when obtaining data may be diverse. Therefore, there may not be any statistical reports that meet the requirements in the pre-stored statistical reports in electronic devices, which makes the flexibility of obtaining data through statistical reports poor, and the obtained data may not be the data that users want, affecting the user experience.

[0081] Based on this, embodiments of this application provide a data acquisition method. When acquiring data, users can select the required data dimensions and attributes from multiple preset data dimensions and attributes displayed to create a personalized report. In this way, electronic devices can acquire the required data in the specified dimensions and attributes based on the user-configured personalized report, realizing personalized report configuration and improving the flexibility of data acquisition from the database. This makes the data acquired from the database using personalized reports more aligned with user needs, thus enhancing the user experience.

[0082] The technical solution of this application and how the technical solution of this application solves the above-mentioned technical problems are described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will now be described with reference to the accompanying drawings.

[0083] Figure 1 This is a flowchart illustrating a data acquisition method provided in an embodiment of this application. The data acquisition method can be executed by software and / or hardware devices. For example, the hardware device can be a data acquisition apparatus, which can be an electronic device or a processing chip within an electronic device. For example, please refer to [link to example]. Figure 1 As shown, the data acquisition method may include:

[0084] S101, Receive user input for the first operation of configuring report content.

[0085] For example, the first operation input by the user can be the first operation performed on the second report selection interface. When the user needs to retrieve data from the data, they can operate the electronic device so that the electronic device can display the second report selection interface according to the user's operation. The second report selection interface includes multiple preset reports and configuration controls. The configuration controls are controls used to configure the report content. The multiple preset reports include preset data as degrees and preset data attributes. The multiple preset reports do not include the first personalized report.

[0086] When the combination of data dimensions and data attributes in multiple preset reports does not meet the user's requirements, the user can click the configuration control. The electronic device can receive the user's operation on the configuration control, that is, receive the user's input for the first operation to configure the report content.

[0087] S102. In response to the first operation, the first report configuration interface is displayed, which includes multiple preset data dimensions and multiple preset data attributes.

[0088] The first report configuration interface can be used to customize report settings.

[0089] For example, in response to the first operation, the electronic device displays a first report configuration interface (see [reference]). Figure 2 As shown, Figure 2 This is a schematic diagram of the electronic device displaying the first report configuration interface provided in the embodiments of this application.

[0090] like Figure 2 As shown in Figure a, the second report selection interface includes preset report 1, preset report 2, preset report 3, preset report 4, preset report 5, a configuration control, and a confirmation control. The confirmation control is used to confirm the preset report selected by the user. When the user clicks the configuration control, the electronic device can respond to the user's click operation and display as shown below. Figure 2 The first report configuration interface is shown as b in the figure.

[0091] like Figure 2 The first report configuration interface shown in b can include data dimension 1, data dimension 2, data dimension 3, data dimension 4, ..., data dimension n, data attribute 1, data attribute 2, data attribute 3, data attribute 4, ..., data attribute m, and may also include a confirmation control.

[0092] The embodiments in this application are only for reference. Figure 2 This example is provided for illustration and does not constitute any limitation.

[0093] S103. Receive the user's second operation on the first report configuration interface for the first data dimension and the first data attribute, wherein the first data dimension is at least one of a plurality of preset data dimensions and the first data attribute is at least one of a plurality of preset data attributes.

[0094] Based on the above Figure 2 Taking the first report configuration interface shown as b in the example, the first data dimension can be one or more of the n data dimensions shown in the first report configuration interface, and the first data attribute can be one or more of the m data attributes shown in the first report configuration interface. This application embodiment does not limit the number of first data dimensions and first data attributes.

[0095] For example, users can in the above Figure 2 In the interface shown in b, data dimension 1, data dimension 2, and data dimension 3 are selected as the first data dimension, and data attribute 2, data attribute 3, and data attribute 4 are selected as the first data attribute. This embodiment of the application does not limit this.

[0096] For example, when the electronic device displays the first report configuration interface, the user can select the desired data dimension and data attribute from multiple data dimensions and multiple data attributes in the first report configuration interface. The electronic device can receive a second operation from the user regarding the first data dimension and the first data attribute.

[0097] S104. In response to the second operation, generate a first personalized report and display a first report selection interface. The first report selection interface includes the first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports.

[0098] For example, when an electronic device generates a first personalized report in response to a second operation, the electronic device can generate a corresponding query statement based on a first data dimension and a first data attribute. The query statement is used to retrieve first data from the database based on the first data dimension and the first data attribute. The query statement is stored in the database, and a correspondence is established between the query statement and the name of the first personalized report.

[0099] By storing the query statements in the database, users can directly use these statements to retrieve data when using the personalized registration feature, thus improving the speed of data retrieval.

[0100] For example, the first personalized report name may be stored in a database, and the method of storing the first personalized report name in the database may include the following two possible implementations:

[0101] In one possible implementation, a naming rule for personalized reports can be pre-defined. For example, the name of the personalized report can be set using the time the personalized report was created and the identity information of the creator. This application does not limit this aspect.

[0102] In another possible implementation, the first personalized report name is generated based on the user's actions before the user selects the first data dimension and the first data attribute.

[0103] For example, the first report configuration interface also includes a report name input box. When the electronic device displays the first report configuration interface, the user can enter the name of the first personalized report in the report name input box. The electronic device can receive the first personalized report name entered by the user; store the first personalized report name in the database; and display a target prompt message to indicate to the user that the first personalized report name has been successfully saved. For example, the target prompt message can be displayed on the first report configuration interface through a pop-up window or other means.

[0104] It should be noted that when a user sees the target prompt information, they can select the first data dimension and the first data attribute in the first report configuration interface. The electronic device can receive the user's second operation on the first data dimension and the first data attribute in the first report configuration interface.

[0105] In this way, by naming personalized registration forms by entering personalized report names in the interface, the names of personalized reports become easier for users to recognize and manage, further enhancing the flexibility of report design.

[0106] For example, when an electronic device generates a first personalized report, it can automatically jump to and display a first report selection interface. The first report selection interface is similar to the second report selection interface described in the above steps. The difference between the first and second report selection interfaces is that, in addition to multiple preset reports, the first report selection interface also includes a first personalized report.

[0107] S105. Receive the user's third operation on the first personalized report from the first report selection interface.

[0108] For example, when the electronic device displays the first report selection interface, if the user wants to obtain data using the first personalized report, they can select the first personalized report in the first report selection interface, and the electronic device can receive the user's third operation on the first personalized report.

[0109] S106. In response to the third operation, use the first personalized report to obtain the first data of the first data dimension and the first data attribute from the database, and output the first data in the form of a data report.

[0110] In this embodiment of the application, the electronic device can use the query statements corresponding to the first data dimension and the first data attribute to query the first data under the first data dimension and the first data attribute in the database, and output the first data in the form of a data report.

[0111] For example, the data report may include the data volume of the first data, the content of the first data, the first data dimension, the first data attribute, etc. The embodiments of this application do not specifically limit the data report.

[0112] Therefore, the data acquisition method provided in this application embodiment allows electronic devices to provide users with a configuration interface for configuring personalized reports, enabling users to configure the required personalized reports in the configuration interface. This makes the data obtained using the user-configured personalized reports more in line with the user's needs, thereby improving the user experience.

[0113] In this embodiment, the configuration information master table, dimension attribute table, and business information dictionary table can be stored in an electronic device or database, as shown in the following examples. Figure 3 As shown, Figure 3 This is a schematic diagram illustrating the correspondence between stored tables provided in an embodiment of this application.

[0114] like Figure 3 As shown, the configuration information main table can include the table name, report name, and the corresponding query statement for the report. The dimension attribute table can include the table name, dimension category, dimension main table information, attribute category, attribute source information, and the indirect relationship between the attribute and the dimension. The business information dictionary table can include the table name, data table name, and field names.

[0115] There is a many-to-many relationship between the configuration information master table and the dimension attribute table, and a many-to-many relationship between the dimension attribute table and the business information dictionary table.

[0116] like Figure 3 As shown, the configuration information main table can be used to store the system's pre-embedded report body information and user-defined report information, including primary key information, report name information, report statistical dimension flags, applicable query statements for the report, report creation information, and the latest modification information of the report, etc.

[0117] Dimension attribute tables can be used to store data dimension information (time, region, organization, event, etc.) and data attribute information that users can choose from. Dimensions and attributes can have a one-to-many relationship, and the association between dimensions and attributes (direct association and indirect association) can also be stored.

[0118] The business information dictionary table can be used to store all business-related table and field information in the business system, providing data foundation support for the dimension attribute table.

[0119] In this embodiment, the first personalized report name and query statement can be stored in the configuration information main table, the first data dimension and the first data attribute can be stored in the dimension attribute table, and the business name and the corresponding field can be stored in the business information dictionary table.

[0120] For example, when an electronic device uses a first personalized report to retrieve first data of a first data dimension and a first data attribute from a database, the electronic device can retrieve the corresponding first data dimension and first data attribute from the dimension attribute table based on the name of the first personalized report; retrieve the corresponding target field from the business information dictionary table based on the business name carried in the first data dimension and the business name carried in the first data attribute; and retrieve the first data from the database based on the target field.

[0121] In this way, user-customized reports can retrieve the corresponding data from the database.

[0122] In this embodiment of the application, the multiple data dimensions and multiple data attributes displayed in the first report configuration interface may not include the data dimensions and / or data attributes required by the user.

[0123] For example, in addition to the content described in the above embodiments, the first report configuration interface may also include a feedback information input box. When the first report configuration interface does not include the data dimensions and / or data attributes required by the user, the user can input a second data dimension and / or a second data attribute in the feedback information input box. The electronic device can receive the second data dimension and / or the second data attribute input by the user in the feedback information input box, and send a request instruction to the electronic device of the back-end technician according to the second data dimension and / or the second data attribute. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

[0124] The second data dimension is a data dimension not included in the multiple preset data dimensions, and the second data attribute is a data attribute not included in the multiple preset data attributes.

[0125] Understandably, when an electronic device sends a request instruction carrying a second data dimension and / or a second data attribute to the electronic device of a back-end technician, the back-end technician's electronic device can display a prompt message to remind the back-end technician to design the data dimension and / or data attribute required by the user.

[0126] In this way, through feedback, back-end technical staff can promptly understand users' needs for data dimensions and / or data attributes, thereby designing the data dimensions and / or data attributes that users require. This allows users to choose from more dimensions and attributes, improving the user experience.

[0127] Once the back-end technical staff has designed the second data dimension and / or second data attribute, they can upload the second data dimension and / or second data attribute to the report configuration interface for display.

[0128] For example, the electronic device can display a second report configuration interface, which includes multiple preset data dimensions, multiple preset data attributes, a second data dimension, and a second data attribute. When a user needs to personalize a report using the second data dimension and the second data attribute, the user can select the second data dimension and the second data attribute in the second report configuration interface. The electronic device can receive a fourth operation from the user in the second report configuration interface regarding the second data dimension and the second data attribute, and in response to the fourth operation, generate a second personalized report and display a third report selection interface. The third report selection interface includes the second personalized report and multiple preset reports, the content of which is different from the content of the multiple preset reports.

[0129] When a user wants to retrieve data from the database using the second personalized report, the user can select the second personalized report in the third report selection interface. The electronic device can receive the user's fifth operation on the second personalized report in the third report selection interface, and respond to the fifth operation by using the second personalized report to retrieve the second data corresponding to the second data dimension and the second data attribute from the database, and output the second data in the form of a data report.

[0130] In this way, when the back-end technical staff designs the data dimensions and data attributes required by the user, the user can set up personalized reports through the new data dimensions and data attributes, and use the personalized reports to retrieve data from the database.

[0131] To facilitate understanding of the user configuration report in the data acquisition method provided in this application embodiment, the method for creating the user configuration report is described in detail below. (See also...) Figure 4 As shown, Figure 4 This is a schematic flowchart illustrating a method for configuring reports, as provided in an embodiment of this application.

[0132] like Figure 4 As shown, the method for configuring this report may include the following steps:

[0133] S401, Begin.

[0134] The electronic device can display the report selection interface described in the above embodiments, such as the second report selection interface.

[0135] S402. Determine whether to use pre-embedded reports.

[0136] The embedded reports can be multiple preset reports as described in the above embodiments, and this application embodiment does not limit this.

[0137] The electronic device can determine whether to use pre-embedded reports based on the user's operation. For example, the electronic device can determine whether to use pre-embedded reports based on the user's operation on the second report selection interface. If the user selects pre-embedded reports on the second report interface, it is determined that pre-embedded reports are used, and the following step S403 is executed; if the user selects to configure reports on the second report interface, it is determined that pre-embedded reports are not used, and the electronic device can display a report configuration interface, such as the first report configuration interface.

[0138] S403, Select the data dimension for the report.

[0139] For example, when a user selects a pre-embedded report, they can choose the required data dimension from among the multiple data dimensions corresponding to the selected pre-embedded report.

[0140] S404. Determine whether the data dimensions and / or data attributes required by the user are included.

[0141] For example, when an electronic device displays a report configuration interface, it can determine whether the interface contains the data dimensions and / or data attributes requested by the user based on the user's actions. If the electronic device receives a user's action of selecting data dimensions and data attributes in the report configuration interface, it indicates that the interface contains the data dimensions and / or data attributes requested by the user. If the electronic device receives a user's action of adding data dimensions and / or data attributes in the report configuration interface, it indicates that the interface does not contain the data dimensions and / or data attributes requested by the user.

[0142] S405, Configure data dimensions and data attributes.

[0143] For example, the methods for configuring data dimensions and data attributes can be found in the above embodiments, and will not be repeated here.

[0144] After configuring the data dimensions and data attributes, personalized reports can be generated.

[0145] S406. Add new data dimensions and / or new data attributes.

[0146] For example, adding new data dimensions and / or new data attributes can be referred to in the above embodiments, and will not be repeated here.

[0147] S407, End.

[0148] In this way, when selecting reports, users can choose data attributes and data dimensions according to their own needs, instead of being limited to fixed combinations of data dimensions and data attributes, allowing users to obtain the data they need from the database more flexibly.

[0149] Figure 5 This is a schematic diagram of a process for generating a new report, provided as an embodiment of this application.

[0150] It should be noted that the front-end interface refers to the interface displayed by the electronic device. The interface displayed by the electronic device may differ depending on the step being executed. This application embodiment does not limit the content of the front-end interface of the electronic device. The background service can be a service that allows the electronic device to perform the operations input by the user on the front-end interface, such as the processor of the electronic device. This application embodiment does not limit this.

[0151] like Figure 5 As shown, generating a new report may include the following steps:

[0152] Step 1: The front-end interface transmits the main information of the newly added report to the back-end service.

[0153] Users can enter the main information for a new report in the front-end interface. The main information can include the report name, etc.

[0154] Step 2: The backend service processes the main information of the newly added report and saves the main information of the newly added report in the database.

[0155] When the backend service processes the main information of newly added reports, it can obtain information such as user name, organization information, and creation time to facilitate the differentiation of newly added reports in the future.

[0156] Step 3: The database returns a message to the backend service indicating that the main information has been successfully saved.

[0157] Step 4: The backend service returns a message to the frontend interface to prompt the user to proceed with the next configuration step.

[0158] The next configuration step involves configuring the data dimensions and attributes for newly added reports. Users can select the required data dimensions and attributes in the front-end interface, as described in the examples above, and will not be repeated here.

[0159] Users can select and configure pre-embedded data dimensions and attributes. After making their selections, they can submit the selected data dimensions and attributes to the backend service for data processing.

[0160] Step 5: The front-end interface transmits the data dimensions and data attributes selected by the user to the back-end service.

[0161] Step 6: The backend service processes the data dimensions and data attributes selected by the user, generates the corresponding query statement, and configures the query statement in the database.

[0162] The backend service performs logical processing based on the data dimensions and attributes selected by the user, generates corresponding query statements, and stores the query statements in the database.

[0163] Step 7: The database returns a message to the backend service indicating that the newly added report has been successfully saved.

[0164] Step 8: The backend service returns a message to the frontend interface indicating that the new report configuration is complete, prompting the user to use the new report to query data.

[0165] Furthermore, regarding the process of designing new data dimensions and attributes based on user feedback as described in the above embodiments, the process can be found in [link to relevant documentation]. Figure 6 As shown, Figure 6 This is a flowchart illustrating the process of adding a new data dimension and a new data attribute, as provided in an embodiment of this application.

[0166] It should be noted that, Figure 6 The front-end interface described herein refers to the front-end interface of the electronic device used by the back-end technicians, the back-end service refers to the back-end service of the electronic device used by the back-end technicians, and the database can be a shared database of the electronic device used by the back-end technicians and the user's electronic device.

[0167] like Figure 6 As shown, adding new data dimensions and new data attributes can include the following steps:

[0168] Step 1: The front-end interface transmits the information of the newly added data dimensions and the information of the newly added data attributes to the back-end service.

[0169] The front-end interface can display the source information and field information of the data to be configured, including data table information and fields, such as the table information and fields for adding data dimensions, and the table information and fields for adding data attributes.

[0170] Backend technical staff can select the required dimension information (table information) and attribute information (field information) on the frontend interface.

[0171] Step 2: The backend service processes the information of the newly added data dimensions and the newly added data attributes, and saves the information of the newly added data dimensions and the newly added data attributes in the database.

[0172] The backend service can process information and store it in statistical analysis dimensions and attribute tables.

[0173] Step 3: The database returns a message indicating that the data was saved successfully to the backend service.

[0174] Step 4: The backend service returns a message to the frontend interface to prompt the backend technical staff to perform the next configuration step.

[0175] For example, backend technicians can synchronize newly added data dimensions and attributes to users' electronic devices via the database, so that the newly added data dimensions and attributes are displayed on the users' electronic devices.

[0176] In summary, the data acquisition method provided in this application embodiment supports users in manually configuring the data dimensions and attributes of reports through page configuration, which is no longer limited to fixed combinations of dimensions and attributes, thus improving the user experience.

[0177] Figure 7 This is a schematic diagram of the structure of a test case management device 70 provided in an embodiment of this application. For example, please refer to [link / reference]. Figure 7 As shown, the test case management device 70 may include:

[0178] The receiving module is used to receive user input for the first operation of configuring report content.

[0179] Display module 702 is used to respond to the first operation and display the first report configuration interface, which includes multiple preset data dimensions and multiple preset data attributes.

[0180] The receiving module 701 is also used to receive a second operation by the user on the first report configuration interface for the first data dimension and the first data attribute, wherein the first data dimension is at least one of a plurality of preset data dimensions and the first data attribute is at least one of a plurality of preset data attributes.

[0181] Processing module 703 is used to generate a first personalized report in response to the second operation.

[0182] The display module 702 is also used to display a first report selection interface, which includes a first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports.

[0183] The receiving module 701 is also used to receive a third operation by the user on the first personalized report in the first report selection interface.

[0184] The processing module 703 is also used to respond to the third operation by using the first personalized report to obtain the first data of the first data dimension and the first data attribute from the database, and output the first data in the form of a data report.

[0185] In one possible design, the first report configuration interface also includes a report name input box; the receiving module 701 is also used to receive the first personalized report name entered by the user in the report name input box.

[0186] The processing module 703 is also used to store the first personalized report name in the database.

[0187] The display module 702 is also used to display target prompt information, which is used to prompt the user that the first personalized report name has been saved successfully.

[0188] The receiving module 701 is specifically used to receive the user's second operation on the first data dimension and the first data attribute in the first report configuration interface.

[0189] In one possible design, the processing module 703 is specifically used to generate a corresponding query statement based on the first data dimension and the first data attribute. The query statement is used to retrieve the first data from the database based on the first data dimension and the first data attribute. The query statement is stored in the database, and a correspondence is established between the query statement and the first personalized report name.

[0190] In one possible design, the first personalized report name and query statement are stored in the configuration information master table, the first data dimension and first data attribute are stored in the dimension attribute table, and the business name and the corresponding field are stored in the business information dictionary table. The processing module 703 is specifically used to obtain the corresponding first data dimension and first data attribute from the dimension attribute table based on the name of the first personalized report; to obtain the corresponding target field from the business information dictionary table based on the business name carried in the first data dimension and the business name carried in the first data attribute; and to obtain the first data from the database based on the target field.

[0191] In one possible design, the display module 702 is also used to display a second report selection interface, which includes multiple preset reports and configuration controls. The configuration controls are used to configure the report content. The multiple preset reports include preset data degree and preset data attributes. The multiple preset reports do not include the first personalized report.

[0192] The receiving module 701 is specifically used to receive the user's first operation on the configuration control.

[0193] In one possible design, the first report configuration interface also includes a feedback information input box. The receiving module 701 is also used to receive a second data dimension and / or a second data attribute input by the user in the feedback information input box. The second data dimension is a data dimension not included in a plurality of preset data dimensions, and the second data attribute is a data attribute not included in a plurality of preset data attributes.

[0194] The processing module 703 is further configured to send a request instruction to the electronic device of the back-end technician based on the second data dimension and / or the second data attribute. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

[0195] In one possible design, the display module 702 is also used to display a second report configuration interface, which includes multiple preset data dimensions, multiple preset data attributes, a second data dimension, and a second data attribute.

[0196] The receiving module 701 is also used to receive a fourth operation by the user on the second report configuration interface for the second data dimension and the second data attribute.

[0197] The processing module 703 is also used to generate a second personalized report in response to the fourth operation.

[0198] The display module 702 is also used to display a third report selection interface, which includes a second personalized report and multiple preset reports. The content of the second personalized report is different from the content of the multiple preset reports.

[0199] The receiving module 701 is also used to receive the user's fifth operation on the second personalized report in the third report selection interface.

[0200] The processing module 703 is also used to respond to the fifth operation by using the second personalized report to retrieve the second data corresponding to the second data dimension and the second data attribute from the database, and output the second data in the form of a data report.

[0201] The data acquisition device provided in this application embodiment can execute the technical solution of the data acquisition method in any of the above embodiments. Its implementation principle and beneficial effects are similar to those of the data acquisition method. Please refer to the implementation principle and beneficial effects of the data acquisition method. It will not be repeated here.

[0202] It should be noted that the division of the various modules in the above device is merely a logical functional division. In actual implementation, they can be fully or partially integrated into a single physical entity, or they can be physically separated. These modules can be implemented entirely in software via processing element calls; they can be fully implemented in hardware; or some modules can be implemented in software via processing element calls, while others are implemented in hardware. Each module can be a separate processing element, or it can be integrated into a chip within the device. Alternatively, it can be stored as program code in the device's memory, and its functions can be called and executed by a processing element. Furthermore, these modules can be fully or partially integrated together, or they can be implemented independently. The processing element here can be an integrated circuit with signal processing capabilities. During implementation, each step of the above method or each of the above modules can be completed through integrated logic circuits in the processor element or through software instructions.

[0203] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. Figure 8 As shown, the electronic device may include: a transceiver 81, a processor 82, and a memory 83.

[0204] Processor 82 executes computer execution instructions stored in memory, causing processor 82 to perform the scheme in the above embodiments. Processor 82 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.

[0205] The memory 83 is connected to the processor 82 via the system bus and completes communication between them. The memory 83 is used to store computer program instructions.

[0206] Transceiver 81 can be used to obtain the task to be run and its configuration information.

[0207] The system bus can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The system bus can be divided into address bus, data bus, control bus, etc. For ease of representation, only one thick line is used in the diagram, but this does not indicate that there is only one bus or one type of bus. Transceivers are used to enable communication between database access devices and other computers (e.g., clients, read-write libraries, and read-only libraries). Memory may include random access memory (RAM) and may also include non-volatile memory.

[0208] This application also provides a chip for executing instructions, which is used to execute the data acquisition method described in the above embodiments.

[0209] This application also provides a computer-readable storage medium storing computer instructions that, when executed on a computer, cause the computer to perform the data acquisition method described in the above embodiments.

[0210] This application also provides a computer program product, which includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium, and when the at least one processor executes the computer program, it can implement the technical solution of the data acquisition method in the above embodiments.

[0211] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple modules may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be indirect coupling or communication connection through some interfaces, devices, or modules, and may be electrical, mechanical, or other forms.

[0212] The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to implement the solution of this embodiment according to actual needs.

[0213] Furthermore, the functional modules in the various embodiments of this application can be integrated into one processing unit, or each module can exist physically separately, or two or more modules can be integrated into one unit. The unit composed of the above modules can be implemented in hardware or in the form of hardware plus software functional units.

[0214] The integrated modules described above, implemented as software functional modules, can be stored in a computer-readable storage medium. These software functional modules, stored in a storage medium, include several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) or processor to execute some steps of the methods of the various embodiments of this application.

[0215] It should be understood that the aforementioned processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. A general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly manifested as being executed by a hardware processor, or executed by a combination of hardware and software modules within the processor.

[0216] The memory may include high-speed RAM, and may also include non-volatile storage (NVM), such as at least one disk storage device, and may also be a USB flash drive, external hard drive, read-only memory, disk or optical disc, etc.

[0217] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.

[0218] The aforementioned storage medium can be implemented from any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The storage medium can be any available medium accessible to general-purpose or special-purpose computers.

[0219] An exemplary storage medium is coupled to a processor, enabling the processor to read information from and write information to the storage medium. Alternatively, the storage medium can be an integral part of the processor. The processor and storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and storage medium can exist as discrete components in an electronic control unit or main control device.

[0220] Those skilled in the art will understand that all or part of the steps of the above-described method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When executed, the program performs the steps of the above-described method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disks, or optical disks.

[0221] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features therein. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of this application.

Claims

1. A data acquisition method, characterized in that, include: Receive user input for the first operation to configure report content; In response to the first operation, a first report configuration interface is displayed, which includes multiple preset data dimensions and multiple preset data attributes; Receive a second operation from the user on the first report configuration interface for a first data dimension and a first data attribute, wherein the first data dimension is at least one of the plurality of preset data dimensions and the first data attribute is at least one of the plurality of preset data attributes; In response to the second operation, a first personalized report is generated and a first report selection interface is displayed. The first report selection interface includes the first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports. Receive a third operation from the user on the first personalized report in the first report selection interface; In response to the third operation, the first data of the first data dimension and the first data attribute is obtained from the database using the first personalized report, and the first data is output in the form of a data report; The first report configuration interface also includes a feedback information input box, and further includes: Receive a second data dimension and / or a second data attribute input by the user in the feedback information input box, wherein the second data dimension is a data dimension not included in the plurality of preset data dimensions, and the second data attribute is a data attribute not included in the plurality of preset data attributes; Based on the second data dimension and / or the second data attribute, a request instruction is sent to the electronic device of the back-end technician. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

2. The method according to claim 1, characterized in that, The first report configuration interface also includes a report name input box; The second operation performed by the user on the first report configuration interface, targeting the first data dimension and the first data attribute, includes: Receive the first personalized report name entered by the user in the report name input box; The first personalized report name is stored in the database, and a target prompt message is displayed to indicate to the user that the first personalized report name has been successfully saved. Receive the user's second operation on the first report configuration interface for the first data dimension and the first data attribute.

3. The method according to claim 2, characterized in that, The response to the second operation, generating a first personalized report, includes: Based on the first data dimension and the first data attribute, a corresponding query statement is generated. The query statement is used to retrieve the first data from the database based on the first data dimension and the first data attribute. The query statement is stored in the database, and a correspondence is established between the query statement and the first personalized report name.

4. The method according to claim 3, characterized in that, The first personalized report name and the query statement are stored in the configuration information main table, the first data dimension and the first data attribute are stored in the dimension attribute table, and the business name and the fields corresponding to the business are stored in the business information dictionary table. The step of retrieving the first data of the first data dimension and the first data attribute from the database using the first personalized report includes: Based on the name of the first personalized report, retrieve the corresponding first data dimension and first data attribute from the dimension attribute table; Based on the business name carried in the first data dimension and the business name carried in the first data attribute, obtain the corresponding target field in the business information dictionary table; The first data is retrieved from the database based on the target field.

5. The method according to claim 1, characterized in that, The first operation of receiving user input for configuring report content includes: The second report selection interface is displayed. The second report selection interface includes the plurality of preset reports and configuration controls. The configuration controls are used to configure the report content. The plurality of preset reports include preset data degree and preset data attributes. The plurality of preset reports do not include the first personalized report. Receive the first operation from the user on the configuration control.

6. The method according to claim 1, characterized in that, The method further includes: Display the second report configuration interface, which includes the plurality of preset data dimensions, the plurality of preset data attributes, the second data dimension, and the second data attribute; Receive the user's fourth operation on the second report configuration interface for the second data dimension and the second data attribute; In response to the fourth operation, a second personalized report is generated and a third report selection interface is displayed. The third report selection interface includes the second personalized report and multiple preset reports. The content of the second personalized report is different from the content of the multiple preset reports. Receive the user's fifth operation on the second personalized report in the third report selection interface; In response to the fifth operation, the second personalized report is used in the database to obtain the second data corresponding to the second data dimension and the second data attribute, and the second data is output in the form of a data report.

7. A data acquisition device, characterized in that, include: The receiving module is used to receive user input for the first operation of configuring the report content; The display module is used to respond to the first operation and display a first report configuration interface, which includes multiple preset data dimensions and multiple preset data attributes. The receiving module is further configured to receive a second operation by the user on the first report configuration interface for the first data dimension and the first data attribute, wherein the first data dimension is at least one of the plurality of preset data dimensions and the first data attribute is at least one of the plurality of preset data attributes; The processing module is used to generate a first personalized report in response to the second operation; The display module is also used to display a first report selection interface, which includes the first personalized report and multiple preset reports. The content of the first personalized report is different from the content of the multiple preset reports. The receiving module is also used to receive a third operation performed by the user on the first personalized report in the first report selection interface. The processing module is further configured to respond to the third operation by using the first personalized report to obtain the first data of the first data dimension and the first data attribute from the database, and output the first data in the form of a data report; The first report configuration interface also includes a feedback information input box. The receiving module is further configured to receive a second data dimension and / or a second data attribute input by the user in the feedback information input box. The second data dimension is a data dimension not included in the plurality of preset data dimensions, and the second data attribute is a data attribute not included in the plurality of preset data attributes. The processing module is further configured to send a request instruction to the electronic device of the back-end technician based on the second data dimension and / or the second data attribute. The request instruction carries the second data dimension and / or the second data attribute and is used to request the back-end technician to design the second data dimension and / or the second data attribute.

8. An electronic device, characterized in that, include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory to implement the method as described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1-6.

10. A computer program product, characterized in that, Includes a computer program that, when executed by a processor, implements the method as described in any one of claims 1-6.

Images