CN115062082A - Data acquisition method and device, storage medium and computer equipment - Google Patents
Data acquisition method and device, storage medium and computer equipment Download PDFInfo
- Publication number
- CN115062082A CN115062082A CN202210760261.8A CN202210760261A CN115062082A CN 115062082 A CN115062082 A CN 115062082A CN 202210760261 A CN202210760261 A CN 202210760261A CN 115062082 A CN115062082 A CN 115062082A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- field
- target
- acquisition
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application provides a data acquisition method, a data acquisition device, a storage medium and computer equipment. The method comprises the following steps: displaying a configuration page of the acquisition request; the acquisition request comprises source data address information, a data primary screening condition and data integration logic; generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user; acquiring an initial data set based on a source data acquisition instruction; generating a data integration instruction according to data integration logic configured by a user; and integrating the initial data set according to the data integration instruction to generate a data report. According to the method and the device, the required data report can be obtained only by configuring on the front-end page according to the requirements of the user, the redevelopment of the data processing flow is not required to be carried out when the requirements are changed every time, the development period is shortened, and the cost of data acquisition is saved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data acquisition method and apparatus, a storage medium, and a computer device.
Background
In many reporting systems, data is often acquired from a plurality of different data sources, and a data report capable of being displayed on a front-end interface of the reporting system is finally output after a series of data processing. For different requirements, the final contents to be displayed in the data report may have larger differences, and developers need to develop different data processing flows according to real-time requirements, so that the development workload is larger, and the cost of data acquisition is higher.
Disclosure of Invention
The embodiment of the application provides a data acquisition method, a data acquisition device, a storage medium and computer equipment, which can shorten the development period of data acquisition and save the data acquisition cost.
In a first aspect, the present application provides a data acquisition method, including:
displaying a configuration page of the acquisition request; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
acquiring an initial data set based on the source data acquisition instruction;
generating a data integration instruction according to data integration logic configured by a user;
and integrating the initial data set according to the data integration instruction to generate a data report.
In one embodiment, when the obtaining request further includes a report ID, the method further includes:
binding the data report with the report ID;
identifying field information of each data in the data report;
generating an optional field list based on the field information;
and establishing an association relationship between the optional field list and the data report for storage.
In one embodiment, the method further comprises:
acquiring a data display request; the data display request comprises a report ID;
determining a target data report according to the report ID;
acquiring an optional field list corresponding to the target data report;
displaying an optional field list of the target data report;
acquiring a target field selected by a user in the selectable field list;
and screening and displaying data corresponding to the target field in the target data report.
In one embodiment, if the number of the target fields selected by the user in the selectable fields is more than two, the step of screening and displaying the data corresponding to the target fields in the target data report includes:
screening data corresponding to the target field in the target data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the method further comprises:
identifying field information of each data in the data report;
generating an optional field list based on the field information;
displaying the selectable field list;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the data report for display.
In one embodiment, if the number of target fields selected by the user in the selectable fields is more than two, the step of screening and displaying the data corresponding to the target fields in the data report includes:
screening data corresponding to the target field in the data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the data integration logic comprises at least one of aggregation logic, sorting logic, and screening logic.
In a second aspect, the present application further provides a data acquisition apparatus, including:
the configuration page display module is used for displaying the configuration page of the acquisition request; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
the first instruction generation module is used for generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
an initial data set acquisition module, configured to acquire an initial data set based on the source data acquisition instruction;
the second instruction generation module is used for generating a data integration instruction according to the data integration logic configured by the user;
and the data report generating module is used for integrating the initial data set according to the data integration instruction to generate a data report.
In a third aspect, the present application also provides a storage medium having stored therein computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to perform the steps of the data acquisition method according to any one of the above embodiments.
In a fourth aspect, the present application further provides a computer device, comprising: one or more processors, and a memory;
the memory has stored therein computer-readable instructions which, when executed by the one or more processors, perform the steps of the data acquisition method of any one of the embodiments described above.
According to the technical scheme, the embodiment of the application has the following advantages:
the data acquisition method, the device, the storage medium and the computer equipment realize that the acquisition request can be dynamically configured by displaying a configuration page of the acquisition request on a front-end page, a user (i.e. a developer) inputs source data address information, a data primary screening condition and data integration logic on the configuration page, automatically generates a source data acquisition instruction according to the input source data address information and the data primary screening condition, acquires an initial data set based on the source data acquisition instruction, generates a data integration instruction according to the input data integration logic, integrates the initial data set according to the data integration instruction, finally generates a data report meeting the user requirement, can acquire the required data report only by configuring on the front-end page according to the requirement of the user, does not need to redevelop a data processing flow when the requirement is changed every time, the development period is shortened, and the cost of data acquisition is saved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art 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 that other drawings can be obtained according to the drawings without inventive exercise.
FIG. 1 is a schematic flow chart diagram of a data acquisition method in one embodiment;
FIG. 2 is a schematic flow chart of a data acquisition method according to another embodiment;
FIG. 3 is a flow chart illustrating steps included in the data acquisition method according to an embodiment;
FIG. 4 is a schematic flow chart diagram illustrating a data acquisition method in accordance with yet another embodiment;
FIG. 5 is a block diagram of a data acquisition device in one embodiment;
FIG. 6 is an internal block diagram of a computer device that is a server in one embodiment;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
An embodiment of the present application provides a data obtaining method, as shown in fig. 1, the method includes steps S101 to S105, where:
and step S101, displaying a configuration page of the acquisition request.
The acquisition request comprises source data address information, a data primary screening condition and data integration logic. The source data address information is source address information of source data, and for example, the source data address information may be a database address, or a data table address in some database(s), and the user may configure the source data address information on the configuration page of the acquisition request to select the source data address of the data acquisition. The data primary screening condition is a condition for primary screening from the source data address, and only the data meeting the data primary screening condition under the source data address is obtained. The data integration logic is an execution logic for integrating the data obtained by the preliminary screening, and specifically, the data integration logic may configure an integration mode, a dimension, and an integration index. Displaying the acquisition request configuration page means displaying a page for configuring the acquisition request on a front-end interface, and a user triggers data acquisition by configuring the acquisition request on the configuration page.
In one embodiment, the data integration logic includes at least one of aggregation logic, sorting logic, and screening logic.
And step S102, generating a source data acquisition instruction according to the source data address information and the data primary screening condition configured by the user.
The source data acquisition instruction is an instruction which is automatically generated by the computer equipment according to source data address information configured by a user and a data primary screening condition and is used for triggering source data acquisition.
Step S103, acquiring an initial data set based on the source data acquisition instruction.
The initial data set is a set of source data which are acquired from a source data address and meet a data primary screening condition, and the computer equipment executes a source data acquisition instruction to acquire the initial data set.
And step S104, generating a data integration instruction according to the data integration logic configured by the user.
Wherein the data integration instruction is an instruction for integrating the initial data set automatically generated by the computer device according to the data integration logic configured by the user.
And S105, integrating the initial data set according to the data integration instruction to generate a data report.
The data acquisition method provided by the application realizes dynamic configuration of the acquisition request by displaying the configuration page of the acquisition request on the front-end page, and a user inputs address information of source data, a data primary screening condition and data integration logic on the configuration page, automatically generating a source data acquisition instruction according to the input source data address information and the data primary screening condition, acquiring an initial data set based on the source data acquisition instruction, the data integration instruction is generated according to the input data integration logic, the initial data set is integrated according to the data integration instruction, the data report meeting the user requirements is finally generated, the required data report can be obtained only by configuring on the front-end page according to the user requirements, the redevelopment of the data processing flow is not needed when the requirements are changed every time, the development period is shortened, and the cost for acquiring data is saved.
In one embodiment, as shown in fig. 2, when the obtaining request further includes a report ID, the method further includes steps S201 to S204, where:
step S201, binding the data report with the report ID.
The user can define a report ID for the finally obtained data report when configuring the obtaining request, and after the data report is generated, the data report and the report ID are bound, so that the report can be directly inquired and obtained through the report ID when the report is obtained again in the follow-up process.
Step S202, identifying the field information of each data in the data report.
The screened and obtained data in the application refers to data records, a plurality of field information may exist in one data record, and one field information includes a field name and a field value.
In step S203, an optional field list is generated based on the field information.
And generating an optional field list according to the identified field information of all the data in the data report, wherein the optional field list comprises all the existing field names in the data report.
And step S204, establishing an association relation between the optional field list and the data report and storing the association relation.
By establishing the association relationship between the generated data report and the optional field list and then storing the data report, when data of a certain field name in the data report needs to be directly acquired subsequently, the report ID and the field of the data report can be directly selected to be acquired, and the acquisition efficiency of the subsequent data in recycling is improved.
In one embodiment, as shown in fig. 3, the method further includes steps S301 to S306, wherein:
step S301, acquiring a data display request; the data presentation request includes a report ID.
The data display request is a request input through a front-end page, the report form ID of the data report form to be displayed can be input in the front-end page, and the corresponding data report form is requested to be displayed in the page.
Step S302, determining a target data report according to the report ID.
And the computer equipment determines the data report selected by the user as a target data report according to the report ID in the data display request.
Step S303, acquiring an optional field list corresponding to the target data report.
And acquiring the corresponding optional field list based on the incidence relation between the target data report and the optional field list.
And step S304, displaying the optional field list of the target data report.
And displaying the optional field list of the target data report in the front-end page for the user to select the fields which the user wants to show.
In step S305, a target field selected by the user in the selectable field list is obtained.
The target field is a field selected by the user from the optional field list in the front page, and the target field may include one or more fields.
And step S306, screening the data corresponding to the target field in the target data report and displaying the data.
In this embodiment, a user inputs a data display request including a report ID on a page, and selects a target data report, so that a computer device can automatically retrieve and display an optional field list of the target data report, and the user selects fields in the optional field list on the page, so that data desired to be displayed at present can be dynamically screened, and flexibility of data acquisition is improved.
In one embodiment, if the number of the target fields selected by the user in the selectable fields is more than two, the step of displaying the data corresponding to the target fields in the filtered target data report includes:
screening data corresponding to the target field in the target data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
The method includes that a user can configure different display formats for different fields in advance, for example, different font colors, different shading colors and the like, when the user selects more than two target fields through a selectable field list, a computer device screens out data corresponding to the target fields in a target data report, and displays the data of the target fields on a page in a display format corresponding to each target field according to the preset display format corresponding to each field, for example, the target fields comprise fields A and fields B, the display format of the fields A is a red font, the display format of the fields B is a blue font, the screened data of the fields A is displayed as the red font in the page, the data of the fields B is displayed as the blue font in the page, and the user can visually distinguish the data of the different fields.
In one embodiment, as shown in fig. 4, the method further includes steps S401 to S405, wherein:
step S401, identifying field information of each data in the data report.
The screened and obtained data in the application refers to data records, a plurality of field information may exist in one data record, and one field information includes a field name and a field value.
In step S402, an optional field list is generated based on the field information.
And generating an optional field list according to the identified field information of all the data in the data report, wherein the optional field list comprises all the existing field names in the data report.
Step S403, displaying a selectable field list.
And displaying the selectable field list of the data report in the front-end page for the user to select the fields which the user wants to show.
In step S404, a target field selected by the user in the selectable field list is obtained.
The target field is a field selected by the user from the optional field list in the front page, and the target field may include one or more fields.
And S405, screening and displaying data corresponding to the target field in the data report.
In this embodiment, the computer device generates and displays the selectable field list by identifying the field information of each data in the generated data report, and the user selects the field in the selectable field list on the page, so that the data which is desired to be displayed at present can be dynamically screened, and the flexibility of data acquisition is improved.
In one embodiment, if the number of target fields selected by the user in the selectable fields is more than two, the step of displaying the data corresponding to the target fields in the filtered data report includes:
screening data corresponding to the target field in the data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
The user may configure different display formats for different fields in advance, for example, configure different font colors, different shading colors, and the like, when the user selects more than two target fields through the selectable field list, the computer device filters out data corresponding to the target fields in the data report, and displays the data of each target field on the page in the display format corresponding to each target field according to the preset display format corresponding to each field, for example, the target field includes a field a and a field B, the display format of the field a is a red font, the display format of the field B is a blue font, the filtered data of the field a is displayed as a red font in the page, the data of the field B is displayed as a blue font in the page, and the user can visually distinguish the data of different fields.
It should be understood that, although the steps in the flowcharts related to the embodiments as described above are sequentially displayed as indicated by arrows, the steps are not necessarily performed sequentially as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the embodiments described above may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the execution order of the steps or stages is not necessarily sequential, but may be rotated or alternated with other steps or at least a part of the steps or stages in other steps.
The following describes a data acquisition apparatus provided in an embodiment of the present application, and the data acquisition apparatus described below and the data acquisition method described above may be referred to correspondingly.
As shown in fig. 5, an embodiment of the present application further provides a data obtaining apparatus 500, including:
a configuration page display module 501, configured to display an acquisition request configuration page; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
a first instruction generating module 502, configured to generate a source data obtaining instruction according to source data address information and a data preliminary screening condition configured by a user;
an initial data set obtaining module 503, configured to obtain an initial data set based on the source data obtaining instruction;
a second instruction generating module 504, configured to generate a data integration instruction according to a data integration logic configured by a user;
and a data report generating module 505, configured to integrate the initial data set according to the data integration instruction, and generate a data report.
In one embodiment, when the obtaining request further includes a report ID, the data obtaining apparatus further includes:
the binding module is used for binding the data report with the report ID;
the first identification module is used for identifying field information of each data in the data report;
the first list generating module is used for generating an optional field list based on the field information;
and the association module is used for establishing an association relationship between the optional field list and the data report and storing the association relationship.
In one embodiment, the data acquisition device further comprises:
the display request acquisition module is used for acquiring a data display request; the data display request comprises a report ID;
the target data report determining module is used for determining a target data report according to the report ID;
the list acquisition module is used for acquiring an optional field list corresponding to the target data report;
the first list display module is used for displaying an optional field list of the target data report;
the first field acquisition module is used for acquiring a target field selected by a user in the selectable field list;
and the first field screening module is used for screening the data corresponding to the target field in the target data report and displaying the data.
In one embodiment, when the number of the target fields selected by the user in the selectable fields is more than two, the first field screening is also used for screening the data corresponding to the target fields in the target data report; determining the display format of each target field according to the corresponding relation between the preset field and the display format; and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the data acquisition apparatus further includes:
the second identification module is used for identifying field information of each data in the data report;
the second list generating module is used for generating an optional field list based on the field information;
the second list display module is used for displaying the selectable field list;
the second field acquisition module is used for acquiring a target field selected by a user in the selectable field list;
and the second field screening module is used for screening the data corresponding to the target field in the data report and displaying the data.
In one embodiment, when the number of the target fields selected by the user in the selectable fields is more than two, the second field screening module is used for screening the data corresponding to the target fields in the data report; determining the display format of each target field according to the corresponding relation between the preset field and the display format; and displaying the data of each target field according to the display format corresponding to each target field.
The division of the modules in the data acquisition apparatus is merely for illustration, and in other embodiments, the data acquisition apparatus may be divided into different modules as needed to complete all or part of the functions of the data acquisition apparatus. The modules in the data acquisition device can be wholly or partially implemented by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, the present application further provides a storage medium having computer-readable instructions stored therein, which when executed by one or more processors, cause the one or more processors to perform the steps of:
displaying an acquisition request configuration page; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
acquiring an initial data set based on a source data acquisition instruction;
generating a data integration instruction according to data integration logic configured by a user;
and integrating the initial data set according to the data integration instruction to generate a data report.
In one embodiment, the computer readable instructions when executed by the processor further implement the steps of:
binding the data report with the report ID;
identifying field information of each data in the data report;
generating an optional field list based on the field information;
and establishing an association relation between the optional field list and the data report for storage.
In one embodiment, the computer readable instructions when executed by the processor further implement the steps of:
acquiring a data display request; the data display request comprises a report ID;
determining a target data report according to the report ID;
acquiring an optional field list corresponding to a target data report;
displaying an optional field list of the target data report;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the target data report for display.
In one embodiment, the computer readable instructions when executed by the processor further implement the steps of:
screening data corresponding to the target field in the target data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the computer readable instructions when executed by the processor further implement the steps of:
identifying field information of each data in the data report;
generating an optional field list based on the field information;
displaying the selectable field list;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the data report for display.
In one embodiment, the computer readable instructions when executed by the processor further implement the steps of:
screening data corresponding to the target field in the data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the present application further provides a computer device having computer-readable instructions stored therein, which when executed by the one or more processors, perform the steps of:
displaying an acquisition request configuration page; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
acquiring an initial data set based on a source data acquisition instruction;
generating a data integration instruction according to data integration logic configured by a user;
and integrating the initial data set according to the data integration instruction to generate a data report.
In one embodiment, the processor, when executing the computer readable instructions, further performs the steps of:
binding the data report with the report ID;
identifying field information of each data in the data report;
generating an optional field list based on the field information;
and establishing an association relationship between the optional field list and the data report for storage.
In one embodiment, the processor, when executing the computer readable instructions, further performs the steps of:
acquiring a data display request; the data display request comprises a report ID;
determining a target data report according to the report ID;
acquiring an optional field list corresponding to a target data report;
displaying an optional field list of the target data report;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the target data report for display.
In one embodiment, the processor, when executing the computer readable instructions, further performs the steps of:
screening data corresponding to the target field in the target data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
In one embodiment, the processor, when executing the computer readable instructions, further performs the steps of:
identifying field information of each data in the data report;
generating an optional field list based on the field information;
displaying a list of selectable fields;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the data report for display.
In one embodiment, the processor when executing the computer readable instructions further performs the steps of:
screening data corresponding to the target field in the data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
Illustratively, in one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 6. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operating system and the computer program to run on the non-volatile storage medium. The database of the computer device is used for storing data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data acquisition method.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 7. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a data acquisition method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the configurations shown in fig. 6 and 7 are merely block diagrams of portions of configurations related to aspects of the present application, and do not constitute limitations on the computing devices to which aspects of the present application may be applied, as particular computing devices may include more or less components than shown, or combine certain components, or have a different arrangement of components.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases involved in the embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless explicitly specified otherwise.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, the embodiments may be combined as needed, and the same and similar parts may be referred to each other.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for data acquisition, the method comprising:
displaying a configuration page of the acquisition request; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
acquiring an initial data set based on the source data acquisition instruction;
generating a data integration instruction according to data integration logic configured by a user;
and integrating the initial data set according to the data integration instruction to generate a data report.
2. The data acquisition method according to claim 1, wherein when the acquisition request further includes a report ID, the method further comprises:
binding the data report with the report ID;
identifying field information of each data in the data report;
generating an optional field list based on the field information;
and establishing an association relation between the optional field list and the data report for storage.
3. The data acquisition method of claim 2, further comprising:
acquiring a data display request; the data display request comprises a report ID;
determining a target data report according to the report ID;
acquiring an optional field list corresponding to the target data report;
displaying an optional field list of the target data report;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the target data report for display.
4. The data acquisition method according to claim 3, wherein if the number of target fields selected by the user in the selectable fields is two or more, the step of screening and displaying the data corresponding to the target fields in the target data report comprises:
screening data corresponding to a target field in the target data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
5. The data acquisition method of claim 1, further comprising:
identifying field information of each data in the data report;
generating an optional field list based on the field information;
displaying the selectable field list;
acquiring a target field selected by a user in the selectable field list;
and screening the data corresponding to the target field in the data report for display.
6. The method according to claim 5, wherein if the number of the target fields selected by the user in the selectable fields is two or more, the step of screening and displaying the data corresponding to the target fields in the data report comprises:
screening data corresponding to the target field in the data report;
determining the display format of each target field according to the corresponding relation between the preset field and the display format;
and displaying the data of each target field according to the display format corresponding to each target field.
7. The data acquisition method of any one of claims 1 to 6, wherein the data integration logic comprises at least one of aggregation logic, sorting logic, and screening logic.
8. A data acquisition apparatus, comprising:
the configuration page display module is used for displaying the configuration page of the acquisition request; the acquisition request comprises source data address information, a data primary screening condition and data integration logic;
the first instruction generation module is used for generating a source data acquisition instruction according to source data address information and a data primary screening condition configured by a user;
an initial data set acquisition module, configured to acquire an initial data set based on the source data acquisition instruction;
the second instruction generation module is used for generating a data integration instruction according to the data integration logic configured by the user;
and the data report generating module is used for integrating the initial data set according to the data integration instruction to generate a data report.
9. A storage medium, characterized by: the storage medium has stored therein computer-readable instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of the data acquisition method of any one of claims 1 to 7.
10. A computer device, comprising: one or more processors, and a memory;
the memory has stored therein computer-readable instructions that, when executed by the one or more processors, perform the steps of the data acquisition method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210760261.8A CN115062082A (en) | 2022-06-30 | 2022-06-30 | Data acquisition method and device, storage medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210760261.8A CN115062082A (en) | 2022-06-30 | 2022-06-30 | Data acquisition method and device, storage medium and computer equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115062082A true CN115062082A (en) | 2022-09-16 |
Family
ID=83204572
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210760261.8A Pending CN115062082A (en) | 2022-06-30 | 2022-06-30 | Data acquisition method and device, storage medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115062082A (en) |
-
2022
- 2022-06-30 CN CN202210760261.8A patent/CN115062082A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020253059A1 (en) | Method and apparatus for implementing multi-stage linkage drop-down box, and computer device | |
| CN110110174B (en) | Data visualization page generation, monitoring and display method, browser and server | |
| CN110442341B (en) | Interface configuration method and device of application program and terminal equipment | |
| AU2017101867A4 (en) | Method, apparatus, terminal and storage medium of data displaying | |
| CN114115844A (en) | Page generation method and device, computer equipment and storage medium | |
| CN112433712A (en) | Report display method and device, computer equipment and storage medium | |
| CN114238808A (en) | Page display method and device, computer equipment and storage medium | |
| CN112559576A (en) | Data display method, system, device, storage medium and electronic equipment | |
| CN115857929A (en) | Resource data processing method and device, computer equipment and storage medium | |
| CN115062082A (en) | Data acquisition method and device, storage medium and computer equipment | |
| CN114756293A (en) | Service processing method, device, computer equipment and storage medium | |
| CN111797125A (en) | Report creating method and device, electronic equipment and computer readable storage medium | |
| CN111191057A (en) | User-defined retrieval method and device, electronic equipment and storage medium thereof | |
| CN117112654B (en) | City data display method, device, computer equipment and storage medium | |
| CN111736825B (en) | Information display method, device, equipment and storage medium | |
| CN114816172B (en) | Personnel scheduling interaction processing method and device and electronic equipment | |
| CN114461298A (en) | Interface technology standard document generation method and system | |
| CN117271449A (en) | Batch file generation method, apparatus, device, storage medium and program product | |
| CN117389605A (en) | Service interface configuration method, device, equipment, storage medium and program product | |
| CN106934555B (en) | Workflow organization method and device, computer equipment and storage medium | |
| CN114661803A (en) | Database service interface publishing method, system, computer equipment and storage medium | |
| CN117522296A (en) | Auditing flow generation method, auditing flow generation device, computer equipment and storage medium | |
| CN117555521A (en) | Business requirement development method, device, computer equipment and storage medium | |
| CN116881594A (en) | View updating method, device, computer equipment and storage medium | |
| CN114610745A (en) | Main data processing method and device, computer equipment and storage medium |
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 |