CN116226811A - Method, device, equipment and computer storage medium for data acquisition - Google Patents

Method, device, equipment and computer storage medium for data acquisition Download PDF

Info

Publication number
CN116226811A
CN116226811A CN202310077896.2A CN202310077896A CN116226811A CN 116226811 A CN116226811 A CN 116226811A CN 202310077896 A CN202310077896 A CN 202310077896A CN 116226811 A CN116226811 A CN 116226811A
Authority
CN
China
Prior art keywords
data
association table
sub
tables
acquiring
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
Application number
CN202310077896.2A
Other languages
Chinese (zh)
Inventor
黄文英
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
CCB Finetech Co Ltd
Original Assignee
CCB Finetech Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by CCB Finetech Co Ltd filed Critical CCB Finetech Co Ltd
Priority to CN202310077896.2A priority Critical patent/CN116226811A/en
Publication of CN116226811A publication Critical patent/CN116226811A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/30Authentication, i.e. establishing the identity or authorisation of security principals
    • G06F21/31User authentication
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24553Query execution of query operations
    • G06F16/24558Binary matching operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Probability & Statistics with Applications (AREA)
  • Computer Hardware Design (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Storage Device Security (AREA)

Abstract

The application discloses a method, a device, equipment and a computer storage medium for acquiring data, belonging to the technical field of databases of big data. The method comprises the following steps: receiving request information for acquiring target product data sent by a target application; inquiring data corresponding to the request information from a database according to the request information; and sending authorization information for authorizing access to the data to the target application under the condition that the database is queried to comprise the data corresponding to the request information, wherein the authorization information is used for the target application to acquire the data from the database according to the authorization information. The method and the device can authorize the target application based on the request information for acquiring the target product data sent by the target application, and allow the target application to directly access the database, so that the timeliness for acquiring the data is improved.

Description

Method, device, equipment and computer storage medium for data acquisition
Technical Field
The application belongs to the technical field of databases of big data, and particularly relates to a method, a device, equipment and a computer storage medium for acquiring data.
Background
At present, the target application often needs to acquire data through a database in an operating system, when the target application needs to acquire the data in the database, the target application needs to copy the data in the database firstly due to limited access, then load the copied data to the target application for use, and unload the data after the use is completed, so that the step of acquiring the data by the target application is complicated and takes a long time. As the time-consuming requirements are now increasing, there is a need to optimize the operating system.
Disclosure of Invention
The embodiment of the application provides a method, a device, equipment and a computer storage medium for acquiring data, which can improve timeliness of an operating system based on optimization of the operating system.
In a first aspect, an embodiment of the present application provides a method for acquiring data, including:
receiving request information for acquiring target product data sent by a target application;
inquiring data corresponding to the request information from a database according to the request information;
and sending authorization information for authorizing access to the data to the target application under the condition that the database is queried to comprise the data corresponding to the request information, wherein the authorization information is used for the target application to acquire the data from the database according to the authorization information.
Optionally, after receiving the request information for acquiring the product data sent by the target application, the method further includes:
acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table;
counting the data of a plurality of sub-tables in the first association table to obtain a counting result;
and storing the statistical result into the database.
Optionally, the counting according to the data of the first association table to obtain a counting result includes:
inquiring the number of sub-tables in the first association table;
if the number of sub-tables in the first association table is smaller than the preset value, acquiring the data of the first association table;
if the number of the sub-tables in the first association table is greater than or equal to a preset value, splitting the first association table to obtain a plurality of sub-tables;
randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value;
acquiring data of the second association table;
and counting the data of the first association table and the data of the second association table to obtain a counting result.
Optionally, the randomly selecting a preset number of sub-tables for re-association to obtain a second association table includes:
inquiring the character length of each sub-table in the randomly selected preset number of sub-tables;
and associating at least one sub-table with smaller character segment length in the preset number with the sub-table with the longest character segment length to obtain a second association table.
Optionally, the method further comprises:
counting the first time of the target application for acquiring the data from the database according to the authorization information;
counting a second time for obtaining a counting result according to the data of the first association table and the data of the second association table;
calculating a sum of the first time and the second time;
and generating prompt information for expanding the capacity of the operating system under the condition that the sum of the first time and the second time is larger than the preset time.
In a second aspect, an embodiment of the present application provides an apparatus for acquiring data, including:
the receiving module is used for receiving request information which is sent by the target application and used for acquiring target product data;
the query module is used for querying data corresponding to the request information from a database according to the request information;
and the sending module is used for sending authorization information for authorizing access to the data to the target application under the condition that the data corresponding to the request information is included in the database, so that the target application can acquire the data from the database according to the authorization information.
Optionally, after the receiving module receives the request information for acquiring the product data sent by the target application, the apparatus further includes:
the acquisition module is further used for acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table;
the statistics module is used for carrying out statistics on the data of the plurality of sub-tables in the first association table to obtain a statistics result;
and the storage module is used for storing the statistical result into the database.
Optionally, the statistics module performs statistics according to the data of the first association table to obtain a statistics result, including:
the query module is also used for querying the number of sub-tables in the first association table;
the acquisition module is further used for acquiring the data of the first association table if the number of the sub-tables in the first association table is smaller than a preset value;
the splitting module is used for splitting the first association table to obtain a plurality of sub-tables if the number of the sub-tables in the first association table is greater than or equal to a preset value;
the association module is used for randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value;
the acquisition module is also used for acquiring the data of the second association table;
and the statistics module is used for carrying out statistics on the data of the first association table and the data of the second association table to obtain a statistics result.
Optionally, the association module randomly selects a preset number of sub-tables for re-association to obtain a second association table, which includes:
the query module is used for further querying the character length of each sub-table in the randomly selected preset number of sub-tables;
and the association module is further used for associating at least one sub-table with smaller character segment length in the preset number with the sub-table with the longest character segment length to obtain a second association table.
Optionally, the apparatus further comprises:
the statistics module is also used for counting the first time when the target application acquires the data from the database according to the authorization information;
the statistics module is also used for counting a second time for obtaining a statistics result according to the data of the first association table and the data of the second association table;
the calculating module is used for calculating the sum of the first time and the second time;
the generating module is used for generating prompt information for expanding the capacity of the operating system under the condition that the sum of the first time and the second time is larger than the preset time.
In a third aspect, an embodiment of the present application provides an electronic device, including:
a processor and a memory storing computer program instructions;
the processor, when executing the computer program instructions, is configured to perform the method for data acquisition described in the first aspect.
In a fourth aspect, embodiments of the present application provide a computer storage medium having stored thereon computer program instructions which, when executed by a processor, implement a method for data acquisition according to the first aspect.
According to the method, the device, the equipment and the computer storage medium for acquiring the data, after the database receives the request information for acquiring the data sent by the target application, when corresponding information is queried in the database, the target application is directly sent with the authorization information for authorizing access, and the target application is allowed to directly access the required data according to the authorization information.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described, and it is possible for a person skilled in the art to obtain other drawings according to these drawings without inventive effort.
Fig. 1 is a flowchart of a method for data acquisition according to an embodiment of the present application.
Fig. 2 is a flow chart of a method for counting association table data according to an embodiment of the present application.
Fig. 3 is a schematic diagram of an apparatus for data acquisition according to an embodiment of the present application.
Fig. 4 is a schematic hardware structure of an electronic device according to an embodiment of the present application.
Detailed Description
Features and exemplary embodiments of various aspects of the present application are described in detail below to make the objects, technical solutions and advantages of the present application more apparent, and to further describe the present application in conjunction with the accompanying drawings and the detailed embodiments. It should be understood that the specific embodiments described herein are intended to be illustrative of the application and are not intended to be limiting. It will be apparent to one skilled in the art that the present application may be practiced without some of these specific details. The following description of the embodiments is merely intended to provide a better understanding of the present application by showing examples of the present application.
It is noted that relational terms such as first and second, and the like are 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. Moreover, 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 … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
It should be noted that, in the embodiment of the present application, the data acquisition, storage, use, processing, etc. all conform to relevant regulations of national laws and regulations.
In order to solve the problems in the prior art, embodiments of the present application provide a method, an apparatus, a device, and a computer storage medium for data acquisition. The method for acquiring data provided in the embodiment of the present application will be first described below.
As the competition of the financial market becomes more and more vigorous, the growth pattern of traditional commercial banks using the difference of interest as the main income source is difficult to be sustained, and for this reason, various banks research and develop product factories suitable for the present line of features. The core idea of the product factory design is to divide various products in banking business into different product lines and product groups according to product characteristics and business processes, simultaneously deconstruct a plurality of standardized and structured applications, product conditions and product configuration parameters, and rapidly design and develop saleable products meeting market demands in an assembling mode. Currently, the different applications are typically individually configured by the product factory with the available products conforming to their business scenarios. In the big data age, the operation system is built by various enterprises in the financial market, and the operation system provides data access, storage, calculation, security management, resource management and other services for the data analysis of various products.
Therefore, after the application sends a request for acquiring the product data to the operating system in the product factory, the operating system acquires the data in the association table of the corresponding product data to calculate, and because a plurality of sub-tables may exist in the association table and are associated together, the time for the operating system to acquire the data in the association table also becomes long, so that the timeliness of acquiring the data is also poor. When the operation system finishes calculating and stores the data into the database, the application needs to copy the data in the database in the operation system, then load the copied data into the application for use, and unload the data after the use is finished.
Therefore, how to make the application built in the product factory obtain the product data required by the application with high efficiency is a problem to be solved.
Fig. 1 is a flow chart of a method for data acquisition according to an embodiment of the present application.
In some embodiments, as shown in fig. 1, a method of data acquisition includes:
s10: and receiving request information which is sent by a target application and used for acquiring target product data.
The bank or finance company is used as a credit intermediary and is a transfer station for the inflow and outflow of funds, so that for the flow of funds, the upstream is the process of inputting funds into the bank or finance company by various institutions, companies, individuals and social groups, the downstream is the process of issuing loans to the individuals or institutions by the bank or finance company, the bank or finance company often uses the application in the product factory as the outlet of the funds output, and the application generated by the product factory can be a component. For example, the application component of the credit card or debit card service may be an application component of the product factory, and the corresponding product data may be data related to the number of users of the credit card, the amount of use, and the like, which are not described herein.
When a bank or a finance company wants to acquire the related data of a product, the request information to be acquired is input into the product, and then the request information is sent to an operation system by the product, for example, xx-land xx bank wants to inquire the total number of new users registered by a certain type of today's credit card, a worker inputs the requirement for counting the total number of the today's credit card into the credit card application, and the credit card application sends the request to the operation system after receiving the request.
S11: and according to the request information, inquiring data corresponding to the request information from a database.
After receiving a request sent by a target application to acquire target product data, the operating system queries whether the data corresponding to the request exists in the database, and it is conceivable that the database in the operating system serves as a data center and may cover data related to a plurality of products.
S12: and sending authorization information for authorizing access to the data to the target application under the condition that the database is queried to comprise the data corresponding to the request information, wherein the authorization information is used for the target application to acquire the data from the database according to the authorization information.
After the operating system inquires that the product data corresponding to the request information exists in the database, the target application making the request is authorized, and the target application is allowed to directly access the database to acquire the required data.
In this embodiment, after the operating system receives the request information for obtaining the target product data sent by the target application, when the corresponding product data is queried in the database, the method for directly allowing the target application to directly access the database to obtain the required data by directly authorizing the target application is optimized, so that the complicated steps that the operating system firstly extracts the information from the database and then the target application copies the information and installs the information in the application for use in the conventional method are optimized, and therefore, the timeliness of obtaining the data by the target application can be improved.
In some embodiments, after receiving the request information for obtaining the product data sent by the target application, the method further includes:
s101: and acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table.
When the operating system receives a request sent by a target application to acquire target product data, the operating system may need to count the product data, so that the operating system needs to configure corresponding operations first, wherein the operations are a most basic configuration unit in the operating system and are the smallest execution program, and it is conceivable that the operating system configures different operations to execute according to different requirements. The job is used as the minimum execution program, and each job has a unique association table, so that the corresponding job must be acquired in order to acquire the association table corresponding to the target product.
It is conceivable that the job of the operating system configuration includes a first job, and the first job includes a first association table, and the first association table includes a plurality of sub-tables having association relations. Continuing taking the example that the operating system receives the total number of the new user which is required to be registered by the xx bank today by a certain credit card program, the operating system configures an operation about the new user which is required to be registered by the credit card program for the demand, and the operating system acquires an association table under the operation through the operation, wherein the association table comprises a plurality of sub-tables, for example, a first sub-table is name information of the new user which is required to be registered by the credit card program today, a second sub-table is information such as identity information, contact information, address and the like of the new user, a third sub-table is information such as amount of money of the new user which is required to apply the credit card, and a fourth sub-table is a staff of the bank and a number of a working counter when the new user handles the registration service.
S102: and counting the data of a plurality of sub-tables in the first association table to obtain a counting result.
And the operation in the operation system is counted according to the self association table data to obtain a counting result. Continuing taking the counting target credit card program as an example of the total number of new users registered today, after the operation acquires the data of the association table, summing all users in the first sub-table, and counting the summation result.
S103: and storing the statistical result into the database.
After statistics of the related data are counted, the operation in the operation system stores the statistics in the database so that the target application can acquire the data.
By the method, the operating system optimizes the steps that the target program needs to paste the data in the database and then load the data into the program in the prior art, and adopts the method that the target program is authorized to allow the target program to directly access the database, so that the step of acquiring the data from the database is simplified, and the data acquisition efficiency is improved.
Fig. 2 is a flow chart illustrating a method for counting association table data according to an embodiment of the present application.
In some embodiments, as shown in fig. 2, the counting according to the data of the first association table, to obtain a counting result, includes:
s1021: and inquiring the number of sub-tables in the first association table.
After determining the first job and the first association table in the first job, the operating system queries the number of sub-tables in the first association table.
S1022: if the number of sub-tables in the first association table is smaller than the preset value, acquiring the data of the first association table.
If the number of the sub-tables in the first association table is smaller than the preset value, the data in the first association table is directly acquired for later statistics, and it is conceivable that the preset value can be set manually according to different requirements, and details are not repeated here. In this embodiment, the preset value may be 5.
S1023: if the number of the sub-tables in the first association table is greater than or equal to a preset value, the first association table is split to obtain a plurality of sub-tables.
If the number of the sub-tables in the first association table is greater than or equal to the preset value, splitting the first association table into a plurality of sub-tables.
Please continue to refer to the previous example of registering the total number of new users today by the statistics target credit card program, based on the example, the number of sub-tables in the first association table is 5, so that the association table needs to be split, the association relation from the first sub-table to the fifth sub-table is released, and the sub-tables are separated and independent.
S1024: and randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value.
After the first association table is split to obtain a plurality of sub-tables, a preset number of sub-tables smaller than a preset numerical value are randomly selected, and re-association is carried out on the sub-tables. Continuing taking the total number of new users registered today by the statistics target credit card program as an example, splitting the total number into 5 sub-tables, randomly selecting 2 sub-tables for re-association, and then re-associating the rest 3 sub-tables to obtain two second association tables. It is conceivable that the number of sub-tables in the association table may be more than 5, possibly 6, 7 or more, so that 2 or 3 or 4 sub-tables may be randomly selected for association upon re-association. The re-associated second association table is still in the first job.
S1025: and acquiring the data of the second association table.
And directly acquiring data of the second association table after re-associating the sub-table to obtain the second association table. It is conceivable that, when acquiring the data of the plurality of second association tables, the data may be acquired entirely, or may be acquired pertinently according to the request information, which is not described herein.
S1026: and counting the data of the first association table and the data of the second association table to obtain a counting result.
And counting the data of the first association table and the second association table in the two cases to obtain a statistical result, and then storing the statistical result in a database.
According to the method for obtaining the second association table by re-associating the sub-tables with the preset number smaller than the preset number after the first association table with the sub-table number larger than or equal to the preset number is split to obtain the plurality of sub-tables through inquiring the sub-table number in the first association table, the operation speed of the operation system is higher when the data is obtained because the number of the sub-tables in the second association table is smaller than that of the sub-tables in the first association table, and therefore the efficiency of obtaining the data of the association table to be counted by the operation system can be improved, and finally the efficiency of obtaining the data of the whole target program is improved.
In some embodiments, the randomly selecting a preset number of sub-tables for re-association to obtain a second association table includes:
s10241: inquiring the character length of each sub-table in the randomly selected preset number of sub-tables.
It is conceivable that there is a certain rule of association when re-associating a plurality of sub-tables. Firstly, after a preset number of sub-tables are selected, inquiring the character length of each preset number of sub-tables, wherein the character length can be directly obtained from the tables.
S10242: and associating at least one sub-table with smaller character segment length in the preset number with the sub-table with the longest character segment length to obtain a second association table.
Secondly, a sub-table in which the character length is smaller is associated with the sub-table in which the character length is longest.
By the association method in the embodiment, when the data in the second association table is acquired, the sub-table with small character length is associated with the sub-table with long character length, so that the running speed of the system can be improved, and the efficiency of the data of the association table is improved.
In some embodiments, the method further comprises:
s10261: and counting the first time of the target application for acquiring the data from the database according to the authorization information.
Since a process is required to obtain data from the database after the target application is authorized, the first time for the target application to obtain data from the database according to the authorization information can be counted.
S10262: and counting a second time for counting according to the data of the first association table and the data of the second association table to obtain a counting result.
Since a certain time is also required for the process of counting the data after the data of the first association table and the data of the second association table are acquired, the second time for obtaining the statistical result through the association table data can be counted.
S10263: and calculating the sum of the first time and the second time.
S10264: and generating prompt information for expanding the capacity of the operating system under the condition that the sum of the first time and the second time is larger than the preset time.
After the sum of the first time and the second time is obtained, judging whether the sum of the first time and the second time is larger than the preset time, if so, indicating that the preset timeliness requirement is not met after the optimization of the operating system, and generating prompt information for expanding the capacity of the operating system. It is conceivable that the operating rate of the operating system can be increased after the capacity of the operating system is expanded, so that the timeliness of the operating system can be improved.
As an implementation manner, in order to improve timeliness of an operating system, the embodiment of the application provides optimization for the operating system from three aspects, namely splitting and re-associating an association table in the operating system, and definitely associating a sub-table with smaller characters with a sub-table with longer character length; second, allowing the target program to directly access the database to acquire data; thirdly, it is proposed to expand the capacity of the operating system. The three optimization modes are respectively optimized from various angles such as the running speed of the system and the time for acquiring data by the target program, so that the requirement on timeliness can be met.
Fig. 3 is a schematic diagram of an apparatus for data acquisition according to an embodiment of the present application.
In some embodiments, as shown in fig. 3, an apparatus for data acquisition is provided in an embodiment of the present application, including:
a receiving module 100, configured to receive request information sent by a target application to obtain target product data;
a query module 200, configured to query, from a database, data corresponding to the request information according to the request information;
and the sending module 300 is configured to send, when it is queried that the database includes data corresponding to the request information, authorization information for authorizing access to the data to the target application, so that the target application obtains the data from the database according to the authorization information.
In some embodiments, after the receiving module receives the request information for obtaining the product data sent by the target application, the apparatus further includes:
the acquisition module is further used for acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table;
the statistics module is used for carrying out statistics on the data of the plurality of sub-tables in the first association table to obtain a statistics result;
and the storage module is used for storing the statistical result into the database.
In some embodiments, the statistics module performs statistics according to the data of the first association table to obtain a statistics result, including:
the query module is also used for querying the number of sub-tables in the first association table;
the acquisition module is further used for acquiring the data of the first association table if the number of the sub-tables in the first association table is smaller than a preset value;
the splitting module is used for splitting the first association table to obtain a plurality of sub-tables if the number of the sub-tables in the first association table is greater than or equal to a preset value;
the association module is used for randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value;
the acquisition module is also used for acquiring the data of the second association table;
and the statistics module is also used for carrying out statistics on the data of the first association table and the data of the second association table to obtain a statistics result.
In some embodiments, the association module randomly selects a preset number of sub-tables for re-association to obtain a second association table, including:
the query module is used for further querying the character length of each sub-table in the randomly selected preset number of sub-tables;
and the association module is further used for associating at least one sub-table with smaller character segment length in the preset number with the sub-table with the longest character segment length to obtain a second association table.
In some embodiments, the apparatus further comprises:
the statistics module is also used for counting the first time when the target application acquires the data from the database according to the authorization information;
the statistics module is also used for counting a second time for obtaining a statistics result according to the data of the first association table and the data of the second association table;
the calculating module is used for calculating the sum of the first time and the second time;
the generating module is used for generating prompt information for expanding the capacity of the operating system under the condition that the sum of the first time and the second time is larger than the preset time.
The device of the foregoing embodiment is configured to implement the corresponding method for acquiring data in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which is not described herein.
Fig. 4 is a schematic hardware structure of an electronic device according to an embodiment of the present application.
The electronic device may comprise a processor 301 and a memory 302 storing computer program instructions.
In particular, the processor 301 may include a Central Processing Unit (CPU), or an application specific integrated circuit (Application Specific Integrated Circuit, ASIC), or may be configured to implement one or more integrated circuits of embodiments of the present application.
Memory 302 may include mass storage for data or instructions. By way of example, and not limitation, memory 302 may comprise a Hard Disk Drive (HDD), floppy Disk Drive, flash memory, optical Disk, magneto-optical Disk, magnetic tape, or universal serial bus (Universal Serial Bus, USB) Drive, or a combination of two or more of the foregoing. Memory 302 may include removable or non-removable (or fixed) media, where appropriate. Memory 302 may be internal or external to the integrated gateway disaster recovery device, where appropriate. In a particular embodiment, the memory 302 is a non-volatile solid-state memory.
In particular embodiments, memory 302 includes Read Only Memory (ROM). The ROM may be mask programmed ROM, programmable ROM (PROM), erasable PROM (EPROM), electrically Erasable PROM (EEPROM), electrically rewritable ROM (EAROM), or flash memory, or a combination of two or more of these, where appropriate.
The memory may include Read Only Memory (ROM), random Access Memory (RAM), magnetic disk storage media devices, optical storage media devices, flash memory devices, electrical, optical, or other physical/tangible memory storage devices. Thus, in general, the memory comprises one or more tangible (non-transitory) computer-readable storage media (e.g., memory devices) encoded with software comprising computer-executable instructions and when the software is executed (e.g., by one or more processors) it is operable to perform the operations described with reference to the method according to the first aspect of the present application.
The processor 301 implements the method of any of the above embodiments by reading and executing computer program instructions stored in the memory 302.
In one example, the electronic device may also include a communication interface 303 and a bus 310. In which, as shown in fig. 4, the processor 301, the memory 302, and the communication interface 303 are connected to each other by a bus 310 and complete communication with each other.
The communication interface 303 is mainly used to implement communication between each module, device, unit and/or apparatus in the embodiments of the present application.
Bus 310 includes hardware, software, or both that couple the components of the online data flow billing device to each other. By way of example, and not limitation, the buses may include an Accelerated Graphics Port (AGP) or other graphics bus, an Enhanced Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), a HyperTransport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an infiniband interconnect, a Low Pin Count (LPC) bus, a memory bus, a micro channel architecture (MCa) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a video electronics standards association local (VLB) bus, or other suitable bus, or a combination of two or more of the above. Bus 310 may include one or more buses, where appropriate. Although embodiments of the present application describe and illustrate a particular bus, the present application contemplates any suitable bus or interconnect.
The electronic device of the foregoing embodiment is configured to implement the corresponding data acquisition method in any of the foregoing embodiments, and has the beneficial effects of the corresponding method embodiment, which is not described herein.
In addition, in combination with the method for acquiring data in the above embodiment, the embodiment of the application may be implemented by providing a computer storage medium. The computer storage medium has stored thereon computer program instructions; the computer program instructions, when executed by a processor, implement a method of data acquisition of any of the above embodiments.
Those of ordinary skill in the art will appreciate that: the discussion of any of the embodiments above is merely exemplary and is not intended to suggest that the scope of the application (including the claims) is limited to these examples; the technical features of the above embodiments or in the different embodiments may also be combined within the idea of the present application, the steps may be implemented in any order, and there are many other variations of the different aspects of the embodiments of the present application as described above, which are not provided in detail for the sake of brevity.
The functional blocks shown in the above-described structural block diagrams may be implemented in hardware, software, firmware, or a combination thereof. When implemented in hardware, it may be, for example, an electronic circuit, an Application Specific Integrated Circuit (ASIC), suitable firmware, a plug-in, a function card, or the like. When implemented in software, the elements of the present application are the programs or code segments used to perform the required tasks. The program or code segments may be stored in a machine readable medium or transmitted over transmission media or communication links by a data signal carried in a carrier wave. A "machine-readable medium" may include any medium that can store or transfer information. Examples of machine-readable media include electronic circuitry, semiconductor memory devices, ROM, flash memory, erasable ROM (EROM), floppy disks, CD-ROMs, optical disks, hard disks, fiber optic media, radio Frequency (RF) links, and the like. The code segments may be downloaded via computer networks such as the internet, intranets, etc.
It should also be noted that the exemplary embodiments mentioned in this application describe some methods or apparatuses based on a series of steps or apparatuses. However, the present application is not limited to the order of the above-described steps, that is, the steps may be performed in the order mentioned in the embodiments, may be different from the order in the embodiments, or several steps may be performed simultaneously.
Aspects of the present application are described above with reference to flowchart illustrations and/or block diagrams of methods, apparatus (means) and computer program products according to embodiments of the application. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, enable the implementation of the functions/acts specified in the flowchart and/or block diagram block or blocks. Such a processor may be, but is not limited to being, a general purpose processor, a special purpose processor, an application specific processor, or a field programmable logic circuit. It will also be understood that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware which performs the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In the foregoing, only the specific embodiments of the present application are described, and it will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the apparatus, modules and units described above may refer to the corresponding processes in the foregoing method embodiments, which are not repeated herein. It should be understood that the scope of the present application is not limited thereto, and any person skilled in the art can easily conceive various equivalent modifications or substitutions within the technical scope of the present application, which are intended to be included in the scope of the present application.

Claims (10)

1. A method of data acquisition, comprising:
receiving request information for acquiring target product data sent by a target application;
inquiring data corresponding to the request information from a database according to the request information;
and sending authorization information for authorizing access to the data to the target application under the condition that the database is queried to comprise the data corresponding to the request information, wherein the authorization information is used for the target application to acquire the data from the database according to the authorization information.
2. The method for acquiring data according to claim 1, wherein after receiving the request information for acquiring the product data sent by the target application, the method further comprises:
acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table;
counting the data of a plurality of sub-tables in the first association table to obtain a counting result;
and storing the statistical result into the database.
3. The method of claim 2, wherein the counting according to the data of the first association table to obtain a statistical result includes:
inquiring the number of sub-tables in the first association table;
if the number of sub-tables in the first association table is smaller than the preset value, acquiring the data of the first association table;
if the number of the sub-tables in the first association table is greater than or equal to a preset value, splitting the first association table to obtain a plurality of sub-tables;
randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value;
acquiring data of the second association table;
and counting the data of the first association table and the data of the second association table to obtain a counting result.
4. A method for obtaining data according to claim 3, wherein the randomly selecting a predetermined number of sub-tables for re-association to obtain a second association table comprises:
inquiring the character length of each sub-table in the randomly selected preset number of sub-tables;
and associating at least one sub-table with smaller character segment length in the preset number with the sub-table with the longest character segment length to obtain a second association table.
5. A method of data acquisition according to claim 3, further comprising:
counting the first time of the target application for acquiring the data from the database according to the authorization information;
counting a second time for obtaining a counting result according to the data of the first association table and the data of the second association table;
calculating a sum of the first time and the second time;
and generating prompt information for expanding the capacity of the operating system under the condition that the sum of the first time and the second time is larger than the preset time.
6. An apparatus for data acquisition, comprising:
the receiving module is used for receiving request information which is sent by the target application and used for acquiring target product data;
the query module is used for querying data corresponding to the request information from a database according to the request information;
and the sending module is used for sending authorization information for authorizing access to the data to the target application under the condition that the data corresponding to the request information is included in the database, so that the target application can acquire the data from the database according to the authorization information.
7. The apparatus of claim 6, wherein after the receiving module receives the request information for obtaining the product data sent by the target application, the apparatus further comprises:
the acquisition module is further used for acquiring data of an association table corresponding to the target product, wherein the association table comprises a first association table;
the statistics module is used for carrying out statistics on the data of the plurality of sub-tables in the first association table to obtain a statistics result;
and the storage module is used for storing the statistical result into the database.
8. The apparatus of claim 7, wherein the statistics module performs statistics according to the data of the first association table to obtain statistics, comprising:
the query module is also used for querying the number of sub-tables in the first association table;
the acquisition module is further used for acquiring the data of the first association table if the number of the sub-tables in the first association table is smaller than a preset value;
the splitting module is used for splitting the first association table to obtain a plurality of sub-tables if the number of the sub-tables in the first association table is greater than or equal to a preset value;
the association module is used for randomly selecting a preset number of sub-tables to re-associate to obtain a second association table, wherein the preset number is smaller than a preset numerical value;
the acquisition module is also used for acquiring the data of the second association table;
and the statistics module is also used for carrying out statistics on the data of the first association table and the data of the second association table to obtain a statistics result.
9. An electronic device, the device comprising: a processor and a memory storing computer program instructions;
the processor, when executing the computer program instructions, implements a method of data acquisition as claimed in any one of claims 1-5.
10. A computer storage medium having stored thereon computer program instructions which, when executed by a processor, implement a method of data acquisition as claimed in any one of claims 1 to 5.
CN202310077896.2A 2023-01-16 2023-01-16 Method, device, equipment and computer storage medium for data acquisition Pending CN116226811A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310077896.2A CN116226811A (en) 2023-01-16 2023-01-16 Method, device, equipment and computer storage medium for data acquisition

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310077896.2A CN116226811A (en) 2023-01-16 2023-01-16 Method, device, equipment and computer storage medium for data acquisition

Publications (1)

Publication Number Publication Date
CN116226811A true CN116226811A (en) 2023-06-06

Family

ID=86578003

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310077896.2A Pending CN116226811A (en) 2023-01-16 2023-01-16 Method, device, equipment and computer storage medium for data acquisition

Country Status (1)

Country Link
CN (1) CN116226811A (en)

Similar Documents

Publication Publication Date Title
CN109063985B (en) Business risk decision method and device
US11023889B2 (en) Enhanced merchant identification using transaction data
CN107122369B (en) Service data processing method, device and system
CN109344154B (en) Data processing method, device, electronic equipment and storage medium
CN108388512B (en) Data processing method and server
WO2022193594A1 (en) Card binding method, terminal device, authentication server and storage medium
US20200052975A1 (en) Adaptive learning system with a product configuration engine
CN112686746A (en) Credit flow configuration method, device and equipment
WO2022041834A1 (en) Transaction data processing method and apparatus
CN115145587A (en) Product parameter checking method and device, electronic equipment and storage medium
CN110704486A (en) Data processing method, device, system, storage medium and server
WO2021120760A1 (en) Method and device for issuing electronic invoice employing blockchain
CN112950191A (en) Service data processing method and device based on fee refunding service and computer equipment
CN110909212B (en) Bank identification code matching method and equipment
CN110147984B (en) Service sending target processing method and device
CN116226811A (en) Method, device, equipment and computer storage medium for data acquisition
CN111523849A (en) Resource transaction auditing method and device and server
CN115809265A (en) Risk customer screening method and device based on robot flow automation
CN116527758B (en) Method, device, equipment, storage medium and product for generating universal identifier
CN113450112B (en) Data checking method, device, electronic equipment and storage medium
TWI777865B (en) Service summon system and method using voice command
CN117710027B (en) Block chain-based point transaction settlement method, device, equipment and medium
CN115858531A (en) Configuration method, device, equipment, medium and product of structured parameter table
CN116010682A (en) Data query method and device, equipment, medium and product thereof
CN113393312A (en) Invoice data statistical method and related equipment thereof

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