Self-service access method, system and device and storage medium

Abstract

The invention discloses a self-service access method, system and device and a storage medium. The method comprises the following steps: acquiring a data set; creating a model table based on the data set; and performing access configuration on the model table, so that the model table supports SQL statement access, index access and excel template access. According to the method, the response timeliness of data personnel to the access demand is improved, the access efficiency is improved, the personnel cost is reduced, the access process is standardized, and access knowledge is precipitated.

Description

Technical Field

[0001] The present invention relates to the technical field of enterprise data processing, and in particular to a self-service data acquisition method, system, device and storage medium. Background Art

[0002] In their daily work, data personnel of operators have fixed notification reports and temporary statistical reports, which usually require them to learn professional data acquisition knowledge. If the data changes, they need to re-sort the caliber, which takes a long time to acquire data. Therefore, a device that can quickly acquire data and standardize the process is urgently needed. Summary of the invention

[0003] In view of the shortcomings existing in the above problems, the present invention provides a self-service data retrieval method, system, device and storage medium.

[0004] To achieve the above object, the present invention provides a self-service data acquisition method, comprising:

[0005] Get the dataset;

[0006] Creating a model table based on the data set;

[0007] The model table is configured for data acquisition so that the model table supports data acquisition through SQL statements, indicators and Excel templates.

[0008] Preferably, obtaining the data set includes:

[0009] Obtained from a relational database;

[0010] Obtained from big data database;

[0011] Obtained from the interface; and

[0012] Customized data import.

[0013] Preferably, creating a model table based on the data set includes

[0014] By combining tables in corresponding datasets; or

[0015] Customize excel templates.

[0016] Preferably, configuring data acquisition for the model table includes dragging the model table to a designated area or associating multiple tables through a dedicated data acquisition designer.

[0017] The present invention also provides a self-service number acquisition system, comprising:

[0018] The acquisition module is used to obtain the data set;

[0019] A creation module, used for creating a model table based on the data set;

[0020] The configuration module is used to configure data acquisition for the model table so that the model table supports data acquisition using SQL statements, indicators and Excel templates.

[0021] Preferably, obtaining the data set includes:

[0022] Obtained from a relational database;

[0023] Obtained from big data database;

[0024] Obtained from the interface; and

[0025] Customized data import.

[0026] Preferably, creating a model table based on the data set includes

[0027] By combining tables in corresponding datasets; or

[0028] Customize excel templates.

[0029] Preferably, configuring data acquisition for the model table includes dragging the model table to a designated area or associating multiple tables through a dedicated data acquisition designer.

[0030] The present invention also provides a device, comprising at least one processing unit and at least one storage unit, wherein the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit executes the above method.

[0031] The present invention also provides a storage medium storing a computer program executable by an electronic device, and when the program runs on the electronic device, the electronic device executes the above method.

[0032] Compared with the prior art, the present invention has the following beneficial effects:

[0033] The present invention improves the timeliness of data personnel's response to data acquisition needs, improves data acquisition efficiency, reduces personnel costs, standardizes data acquisition processes, and accumulates data acquisition knowledge. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] Figure 1 It is a flow chart of the self-service data acquisition method of the present invention. DETAILED DESCRIPTION

[0035] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0036] Reference Figure 1 The present invention provides a self-service data acquisition method, comprising:

[0037] Get data sets. The data sources support common relational databases and big data databases such as mysql\oracle\photendb\goldendb\clickhouse. It also supports obtaining data through interfaces and supporting customized data import. You can directly obtain table models through data sources, or upload personal table models to obtain data sets.

[0038] Create a model table based on the dataset;

[0039] Configure data acquisition for the model table so that the model table supports data acquisition using SQL statements, indicators, and Excel templates.

[0040] Specifically, data acquisition configuration for the model table includes dragging the model table to the specified area or associating multiple tables through a dedicated data acquisition designer. It supports nearly 20 calculation methods such as sum, count, maximum value, minimum value, variance, deduplication count, date conversion, etc., and supports virtual field settings.

[0041] Furthermore, you can directly retrieve data by writing SQL and directly input the SQL data retrieval scope.

[0042] It supports various defined indicators for data acquisition. Just select the indicator.

[0043] Supports data acquisition using excel templates, upload excel templates, modify cell formulas, set styles, etc. through online excel editors. Set the basic data caliber, select the required data model, and after dragging and dropping the configuration, immediately fill the required data into the excel editor and display the summarized data in real time.

[0044] In this embodiment, sharing of all acquired data, mobile phone push, email sending, etc. are supported.

[0045] Example

[0046] A certain operator has many data acquisition requirements, many of which are repeated, and the data acquisition process is long. It is impossible to automatically acquire data independently. The data acquisition process often takes 3-5 days. Through the present invention, the data acquisition process can be compressed to 1-2 hours.

[0047] The present invention also provides a self-service number acquisition system, comprising:

[0048] The acquisition module is used to obtain the data set;

[0049] Create a module to create a model table based on the data set;

[0050] The configuration module is used to configure data acquisition for the model table so that the model table supports data acquisition using SQL statements, indicators, and Excel templates.

[0051] The present invention also provides a device, comprising at least one processing unit and at least one storage unit, wherein the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit executes the above method.

[0052] The present invention also provides a storage medium storing a computer program executable by an electronic device. When the program runs on the electronic device, the electronic device executes the above method.

[0053] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A self-service data acquisition method, characterized in that: include: Get the dataset; Creating a model table based on the data set; The model table is configured for data acquisition so that the model table supports data acquisition through SQL statements, indicators and Excel templates.

2. The self-service number acquisition method according to claim 1, characterized in that: Obtaining the dataset includes: Obtained from a relational database; Obtained from big data database; Obtained from the interface; and Customized data import.

3. The self-service number acquisition method according to claim 2, characterized in that: Creating a model table based on the data set includes By combining tables in corresponding datasets; or Customize excel templates.

4. The self-service number acquisition method according to claim 3, characterized in that: Configuring data acquisition for the model table includes dragging the model table to a designated area or associating multiple tables through a dedicated data acquisition designer.

5. A self-service data retrieval system, characterized in that: include: The acquisition module is used to obtain the data set; A creation module, used for creating a model table based on the data set; The configuration module is used to configure data acquisition for the model table so that the model table supports data acquisition using SQL statements, indicators and Excel templates.

6. The self-service number retrieval system according to claim 5, characterized in that: Obtaining the dataset includes: Obtained from a relational database; Obtained from big data database; Obtained from the interface; and Customized data import.

7. The self-service number retrieval system according to claim 6, characterized in that: Creating a model table based on the data set includes By combining tables in corresponding datasets; or Customize excel templates.

8. The self-service number retrieval system according to claim 7, characterized in that: Configuring data acquisition for the model table includes dragging the model table to a designated area or associating multiple tables through a dedicated data acquisition designer.

9. A device, characterized in that: The method comprises at least one processing unit and at least one storage unit, wherein the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit executes the method according to any one of claims 1 to 4.

10. A storage medium, characterized in that: It stores a computer program executable by an electronic device. When the program runs on the electronic device, the electronic device executes the method according to any one of claims 1 to 4.

Images