CN111460037A - Financial data query method and device - Google Patents
Financial data query method and device Download PDFInfo
- Publication number
- CN111460037A CN111460037A CN202010259988.9A CN202010259988A CN111460037A CN 111460037 A CN111460037 A CN 111460037A CN 202010259988 A CN202010259988 A CN 202010259988A CN 111460037 A CN111460037 A CN 111460037A
- Authority
- CN
- China
- Prior art keywords
- data
- determining
- target data
- query
- financial
- 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
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000005192 partition Methods 0.000 claims abstract description 65
- 238000003860 storage Methods 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 13
- 230000006870 function Effects 0.000 description 15
- 238000010586 diagram Methods 0.000 description 12
- 238000012545 processing Methods 0.000 description 12
- 238000004891 communication Methods 0.000 description 7
- 238000005457 optimization Methods 0.000 description 6
- 239000000872 buffer Substances 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000003203 everyday effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
-
- 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/2228—Indexing structures
-
- 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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a financial data query method and a device, wherein the data query method comprises the following steps: receiving a query request including a time condition; determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the record table is a corresponding relation between a pre-established time period for storing data and the partition table; and performing data query on the financial database according to the partition table where the determined target data is located. The invention inquires and loads data according to time, is not limited by time and total loading flow, only has a relation with the data volume in the cache time period, but has no relation with the total data volume, thereby meeting the business requirements of high-speed mass data loading and inquiry.
Description
Technical Field
The invention relates to a data processing technology, in particular to a financial data query method and device.
Background
In the prior art, the PC side webpage or the mobile side webpage has the problem of slow data query and loading. With the development of financial science and technology, the informatization of banking business is deep, banks are the origin places of big data, and the system becomes slow under the support of the traditional structure in the face of data with magnitude order growth.
In the prior art, the implementation mode for optimizing mass data query and loading mainly has the following form.
Performance optimization through the web front end. The front-end data loading speed directly affects the viewing experience of a user, and the front-end optimization generally reduces HTTP requests and performs initial processing on resource data, for example, making a picture into a sprite, reducing the loading times of a DOM (Document Object Model, DOM), avoiding redirection, and the like. The most famous optimization scheme of the web front end is 35 jades of Yahoo, and the web front end optimization has the defects that the optimization mode is too scattered depending on page developers, namely each page needs corresponding optimization by the developers.
The Content Delivery Network (CDN) is accelerated through the Content Delivery Network, and avoids bottlenecks and links that may affect page loading speed and stability on the internet, so that Content transmission is faster and more stable. However, the financial system is very much concerned about the security and privacy of data, and generally does not want to give the source file to a third-party service company, but rather makes the source file and the position of the server completely belong to the control of the financial system so as to avoid the loss caused by data leakage and embezzlement.
Disclosure of Invention
In order to solve at least one problem in the prior art, an embodiment of the present invention provides a financial data query method, where the method includes:
receiving a query request including a time condition;
determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the recording table is the corresponding relation between the time period for storing data and the partition table;
and performing data query on the financial database according to the partition table where the determined target data is located.
In the embodiment of the present invention, the determining the partition table where the target data is located according to the time condition in the query request and the pre-established record table includes:
determining the time period of the target data according to the time condition;
and determining a partition table where the target data is located according to the determined time period and the record table.
In the embodiment of the present invention, the method further includes:
judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and inquiring the financial data in the temporary table;
and determining the target data is not in the temporary table, and determining the partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
In the embodiment of the present invention, the method further includes:
generating a data source loading file according to the time sequence and the preset loading file configuration condition;
and establishing a financial database according to the data source loading file.
In the embodiment of the present invention, the preset configuration condition of the loading file includes: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
Meanwhile, the invention also provides a financial data inquiry device, which comprises:
a request receiving module, configured to receive a query request including a time condition;
the partition table determining module is used for determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the recording table is the corresponding relation between the time period for storing data and the partition table;
and the query module is used for performing data query in the financial database according to the partition table where the determined target data is located.
In an embodiment of the present invention, the partition table determining module includes:
a time period determining unit for determining a time period of the target data according to the time condition;
and the partition table determining unit is used for determining the partition table where the target data is located according to the determined time period and the recording table.
In the embodiment of the present invention, the apparatus further includes:
the judging module is used for judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and performing financial data query in the temporary table by the query module;
and determining that the target data is not in the temporary table, wherein the query module determines a partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
In the embodiment of the present invention, the apparatus further includes:
the loading module is used for generating a data source loading file according to the time sequence and the preset loading file configuration condition;
and the database establishing module is used for establishing a financial database according to the data source loading file.
In the embodiment of the present invention, the preset configuration condition of the loading file includes: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
Meanwhile, the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor realizes the method when executing the computer program.
Meanwhile, the invention also provides a computer readable storage medium, and a computer program for executing the method is stored in the computer readable storage medium.
The invention inquires and loads data according to time, is not limited by time and total loading flow, only has a relation with the data volume in the partition table in the cache time period, but has no relation with the total data volume, thereby meeting the business requirements of high-speed mass data loading and inquiry. The mass data query realized by the invention is carried out on the basis of data loading, and the loading and the query can be simultaneously used in a distributed mass data processing product, so that the problem of slow loading can be solved.
In order to make the aforementioned and other objects, features and advantages of the invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for querying financial data according to the present disclosure;
FIG. 2 is a block diagram of a financial data querying device according to the present disclosure;
fig. 3 is a schematic diagram of an electronic device in an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, 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 invention.
As shown in fig. 1, the financial data query method provided by the present invention includes:
step S101, receiving a query request including a time condition;
step S102, determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the recording table is the corresponding relation between the time period for storing data and the partition table;
and step S103, performing data query in a financial database according to the partition table where the determined target data is located.
In one embodiment of the present invention, file directories are required to be generated according to a time sequence, in this example, files are generated by storing in a corresponding directory according to the time sequence, the size of the generated file supports two configurations, namely, the number of records or time timeout, when any condition is triggered, a next file can be generated, and the generated file is used as a query or loading data source. That is, in the embodiment of the present invention, the preset configuration condition of the loading file includes: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
In the embodiment of the present invention, the method further includes: generating a data source loading file according to the time sequence and the preset loading file configuration condition; and establishing a financial database according to the data source loading file.
When data is inquired or loaded, data is inquired from the generated file according to the time condition summarized by the inquiry request, so that the method is basically not limited by time and total loading flow, only has a relation with the data volume in the file in a time period, but has no relation with the total data volume, and therefore, the method can meet the business requirements of high-speed mass data loading and inquiry.
In the embodiment of the present invention, the determining the partition table where the target data is located according to the time condition in the query request and the pre-established record table includes:
determining the time period of the target data according to the time condition;
and determining a partition table where the target data is located according to the determined time period and the record table.
In the embodiment of the invention, the corresponding relation between the time period of the stored data and the partition table is recorded by using the record table, namely the index relation between the time information of the data and the storage position is established, so that the storage position of the inquired target data can be determined according to time.
In one embodiment of the present invention, the relational database is used to implement the function of the above-mentioned record table, and other relational databases are also applicable to an operating system adopting a hardware environment and adopting a standard server, and an index is established on the table according to a service requirement.
In an embodiment of the present invention, the method for querying data further includes:
judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and inquiring the financial data in the temporary table;
and determining the target data is not in the temporary table, and determining the partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
According to the time information in the query instruction, whether the target data is located in a temporary table for caching data is determined, in one embodiment of the invention, the target data is in an hour unit, and several hours can be configured according to requirements. Also, a primary key index needs to be built on the temporary table.
After the index is established, the data transfer interface is called again by the loading program module in the embodiment of the invention, namely, the data is transferred to the partition table. In the embodiment of the present invention, to improve query performance, cache-divided partitions are merged, and in this embodiment, data of a cache time period generated every hour is merged into time period data stored according to days, that is, data of a partition of every hour is merged into data of a partition of every day, so that a large partition service table in a unit of one day is formed. And the merging is to select triggering in the night every day with small traffic and check whether the current cache data is completely exchanged to the corresponding partition of the partition table.
When the invention is implemented, the actual calling time setting can be customized according to the requirement. When a business starts to be inquired, the system calls the distributed middleware through a business program, the middleware is transmitted to a database for storing massive financial data, the database judges whether the inquiry is in a temporary table or a partition table according to calling time conditions and judges which temporary tables and partition tables are inquired, and the judgment is based on the relation between a record table and an inquiry time period, and the record table records which data are in the distributed table and which data are in the temporary tables. That is, when the query time period includes the temporary table time period, the temporary table is queried according to the given time period, that is, the temporary table query interface is called; when the query time period comprises the partition table time period, the partition table is queried according to the given time period, namely, a partition table query interface is called, and then the two result sets are combined. The cache table query is characterized in that the cache table query is performed by full table scanning or main key index scanning due to small data volume, and the partition table has indexes and partition design, so that the query accuracy and rapidity are ensured.
Meanwhile, the present invention also provides a financial data query apparatus, as shown in fig. 2, the data query apparatus includes:
a request receiving module 201, configured to receive a query request including a time condition;
a partition table determining module 202, configured to determine a partition table where the target data is located according to a time condition in the query request and a pre-established record table; the recording table is the corresponding relation between the time period for storing data and the partition table;
and the query module 203 is used for performing data query on the financial database according to the partition table where the determined target data is located.
In the embodiment of the invention, the partition table determining module comprises:
a time period determining unit for determining a time period of the target data according to the time condition;
and the partition table determining unit is used for determining the partition table where the target data is located according to the determined time period and the recording table.
In the embodiment of the present invention, the apparatus further includes:
the judging module is used for judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and performing financial data query in the temporary table by the query module;
and determining that the target data is not in the temporary table, wherein the query module determines a partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
In the embodiment of the present invention, the apparatus further includes:
the loading module is used for generating a data source loading file according to the time sequence and the preset loading file configuration condition;
and the database establishing module is used for establishing a financial database according to the data source loading file.
In the embodiment of the present invention, the preset configuration condition of the loading file includes: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
The data query method and the device are basically not limited by time and total loading flow, only have a relation with the data volume in the cache time period, and have no relation with the total data volume, so that the data query method and the device can meet the business requirements of high-speed mass data loading and query. The mass data query of the invention is carried out on the basis of data loading, and the loading and the query can be simultaneously used in a distributed mass data processing product, thereby solving the problem of slow loading. The invention can ensure the safety and the privacy of data.
The data loading mode adopts a mode that a loading program module processes loading files according to a time directory. In this embodiment, the unit of hour is used, several hours can be configured according to the requirement, and after caching data of several hours, the loader module calls the interface for establishing the index again to establish the index in a unified manner, and caches data of each time period by using the temporary table. In the embodiment, the index function is realized by using the relational database, and other relational databases are also applicable to an operating system, adopt a standard server in a hardware environment, and establish an index on the table according to business requirements. In order to ensure the validity of data (for example, to ensure that the data is not duplicated or unique), a primary key index is required to be established on the temporary table, and under the above conditions, the loading effect generated by comparing billions of schemes of directly storing the data into the ordinary table and directly inserting the temporary table and transferring the data into the partition table is compared.
The embodiment of the invention also provides electronic equipment which can be a desktop computer, a tablet computer, a mobile terminal and the like, and the embodiment is not limited thereto. In this embodiment, the electronic device may refer to the foregoing embodiments, and the contents thereof are incorporated herein, and repeated descriptions thereof are omitted.
Fig. 3 is a schematic block diagram of a system configuration of an electronic apparatus 600 according to an embodiment of the present invention. As shown in fig. 3, the electronic device 600 may include a central processor 100 and a memory 140; the memory 140 is coupled to the central processor 100. Notably, this diagram is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one embodiment, the financial data query function may be integrated into the central processor 100. The central processor 100 may be configured to control as follows:
receiving a query request including a time condition;
determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the recording table is the corresponding relation between the time period for storing data and the partition table;
and performing data query on the financial database according to the partition table where the determined target data is located.
In another embodiment, the financial data inquiry apparatus may be configured separately from the central processor 100, for example, the financial data inquiry apparatus may be configured as a chip connected to the central processor 100, and the financial data inquiry function is realized by the control of the central processor.
As shown in fig. 3, the electronic device 600 may further include: communication module 110, input unit 120, audio processing unit 130, display 160, power supply 170. It is noted that the electronic device 600 does not necessarily include all of the components shown in fig. 3; furthermore, the electronic device 600 may also comprise components not shown in fig. 3, which may be referred to in the prior art.
As shown in fig. 3, the central processor 100, sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, the central processor 100 receiving input and controlling the operation of the various components of the electronic device 600.
The memory 140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 100 may execute the program stored in the memory 140 to realize information storage or processing, etc.
The input unit 120 provides an input to the cpu 100, the input unit 120 is, for example, a key or a touch input device, the power source 170 is used to supply power to the electronic apparatus 600, the display 160 is used to display a display object such as an image and a text, and the display may be, for example, an L CD display, but is not limited thereto.
The memory 140 may be a solid state memory such as Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 140 may also be some other type of device. Memory 140 includes buffer memory 141 (sometimes referred to as a buffer). The memory 140 may include an application/function storage section 142, and the application/function storage section 142 is used to store application programs and function programs or a flow for executing the operation of the electronic device 600 by the central processing unit 100.
The memory 140 may also include a data store 143, the data store 143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by the electronic device. The driver storage portion 144 of the memory 140 may include various drivers of the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging application, address book application, etc.).
The communication module 110 is a transmitter/receiver 110 that transmits and receives signals via an antenna 111. The communication module (transmitter/receiver) 110 is coupled to the central processor 100 to provide an input signal and receive an output signal, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 110 is also coupled to a speaker 131 and a microphone 132 via an audio processor 130 to provide audio output via the speaker 131 and receive audio input from the microphone 132 to implement general telecommunications functions. Audio processor 130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, an audio processor 130 is also coupled to the central processor 100, so that recording on the local can be enabled through a microphone 132, and so that sound stored on the local can be played through a speaker 131.
Embodiments of the present invention also provide a computer-readable program, where when the program is executed in an electronic device, the program causes a computer to execute the financial data query method in the electronic device according to the above embodiments.
Embodiments of the present invention also provide a storage medium storing a computer-readable program, where the computer-readable program enables a computer to execute the financial data query described in the above embodiments in an electronic device.
The preferred embodiments of the present invention have been described above with reference to the accompanying drawings. The many features and advantages of the embodiments are apparent from the detailed specification, and thus, it is intended by the appended claims to cover all such features and advantages of the embodiments that fall within the true spirit and scope thereof. Further, since numerous modifications and changes will readily occur to those skilled in the art, it is not desired to limit the embodiments of the invention to the exact construction and operation illustrated and described, and accordingly, all suitable modifications and equivalents may be resorted to, falling within the scope thereof.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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, embedded processor, 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, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (12)
1. A financial data query method is characterized by comprising the following steps:
receiving a query request including a time condition;
determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the record table is a corresponding relation between a pre-established time period for storing data and the partition table;
and performing data query on the financial database according to the partition table where the determined target data is located.
2. The method of claim 1, wherein the determining the partition table where the target data is located according to the time condition in the query request and a pre-established record table comprises:
determining the time period of the target data according to the time condition;
and determining a partition table where the target data is located according to the determined time period and the record table.
3. The method of querying financial data as claimed in claim 1, wherein said method further comprises:
judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and inquiring the financial data in the temporary table;
and determining the target data is not in the temporary table, and determining the partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
4. The method of querying financial data as claimed in claim 1, wherein said method further comprises:
generating a data source loading file according to the time sequence and the preset loading file configuration condition;
and establishing a financial database according to the data source loading file.
5. The financial data inquiry method of claim 4 wherein said preset loading file configuration conditions include: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
6. A financial data inquiry device, said data inquiry device comprising:
a request receiving module, configured to receive a query request including a time condition;
the partition table determining module is used for determining a partition table where the target data are located according to the time condition in the query request and a pre-established record table; the record table is pre-established as the corresponding relation between the time period for storing data and the partition table;
and the query module is used for performing data query in the financial database according to the partition table where the determined target data is located.
7. The financial data querying device according to claim 6, wherein the partition table determining module comprises:
a time period determining unit for determining a time period of the target data according to the time condition;
and the partition table determining unit is used for determining the partition table where the target data is located according to the determined time period and the recording table.
8. The financial data inquiry apparatus of claim 6 wherein said apparatus further comprises:
the judging module is used for judging whether the target data is in the temporary table or not according to the time condition and the time period of the temporary table cache data;
determining that the target data is in the temporary table, and performing financial data query in the temporary table by the query module;
and determining that the target data is not in the temporary table, wherein the query module determines a partition table in which the target data is located according to the time condition in the query request and a pre-established record table.
9. The financial data inquiry apparatus of claim 6 wherein said apparatus further comprises:
the loading module is used for generating a data source loading file according to the time sequence and the preset loading file configuration condition;
and the database establishing module is used for establishing a financial database according to the data source loading file.
10. The financial data inquiry apparatus as claimed in claim 9, wherein said preset loading file configuration condition comprises: the number of pieces of data for which the loading file supports recording or the period of time for which the loading file supports recording.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 5 when executing the computer program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010259988.9A CN111460037A (en) | 2020-04-03 | 2020-04-03 | Financial data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010259988.9A CN111460037A (en) | 2020-04-03 | 2020-04-03 | Financial data query method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111460037A true CN111460037A (en) | 2020-07-28 |
Family
ID=71685908
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010259988.9A Pending CN111460037A (en) | 2020-04-03 | 2020-04-03 | Financial data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111460037A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113326285A (en) * | 2021-08-03 | 2021-08-31 | 北京轻松筹信息技术有限公司 | Database table query method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101251861A (en) * | 2008-03-18 | 2008-08-27 | 北京锐安科技有限公司 | Method for loading and inquiring magnanimity data |
| CN106874498A (en) * | 2017-02-24 | 2017-06-20 | 深圳国泰安教育技术股份有限公司 | The access method and access device of a kind of finance data |
| CN108427684A (en) * | 2017-02-14 | 2018-08-21 | 华为技术有限公司 | Data query method, apparatus and computing device |
| CN109710614A (en) * | 2018-12-28 | 2019-05-03 | 深圳市同行者科技有限公司 | A kind of method and device of real-time data memory and inquiry |
| CN109829015A (en) * | 2019-01-16 | 2019-05-31 | 成都有据量化科技有限公司 | Finance data storage method, device and storage medium based on HBase |
| CN110019277A (en) * | 2019-01-17 | 2019-07-16 | 阿里巴巴集团控股有限公司 | A kind of method, the method, device and equipment of data query of data accumulation |
| CN110413631A (en) * | 2018-04-25 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of data query method and device |
-
2020
- 2020-04-03 CN CN202010259988.9A patent/CN111460037A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101251861A (en) * | 2008-03-18 | 2008-08-27 | 北京锐安科技有限公司 | Method for loading and inquiring magnanimity data |
| CN108427684A (en) * | 2017-02-14 | 2018-08-21 | 华为技术有限公司 | Data query method, apparatus and computing device |
| CN106874498A (en) * | 2017-02-24 | 2017-06-20 | 深圳国泰安教育技术股份有限公司 | The access method and access device of a kind of finance data |
| CN110413631A (en) * | 2018-04-25 | 2019-11-05 | 中移(苏州)软件技术有限公司 | A kind of data query method and device |
| CN109710614A (en) * | 2018-12-28 | 2019-05-03 | 深圳市同行者科技有限公司 | A kind of method and device of real-time data memory and inquiry |
| CN109829015A (en) * | 2019-01-16 | 2019-05-31 | 成都有据量化科技有限公司 | Finance data storage method, device and storage medium based on HBase |
| CN110019277A (en) * | 2019-01-17 | 2019-07-16 | 阿里巴巴集团控股有限公司 | A kind of method, the method, device and equipment of data query of data accumulation |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113326285A (en) * | 2021-08-03 | 2021-08-31 | 北京轻松筹信息技术有限公司 | Database table query method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109947668B (en) | Method and device for storing data | |
| CN107197359B (en) | Video file caching method and device | |
| TW202042100A (en) | Method and device for cooperatively editting document, computer device and storage media | |
| CN109359118B (en) | Data writing method and device | |
| CN111949614B (en) | Bank system file conversion method and device | |
| CN112328413B (en) | Application service calling method, device and system | |
| CN102722405A (en) | Counting method in high concurrent and multithreaded application and system | |
| CN104657435A (en) | Storage management method for application data and network management system | |
| JP2015514274A (en) | Cache management | |
| CN109947718A (en) | A kind of date storage method, storage platform and storage device | |
| CN115080515A (en) | Block chain based system file sharing method and system | |
| CN115114232A (en) | Method, device and medium for enumerating historical version objects | |
| CN111460037A (en) | Financial data query method and device | |
| CN116701413A (en) | Main data processing method and device | |
| EP2657894A1 (en) | Social connections migration | |
| CN114942908B (en) | Index system, data processing method, electronic device, and medium | |
| CN116233254A (en) | Business cut-off method, device, computer equipment and storage medium | |
| CN111161047A (en) | Bank business data processing and inquiring method and device | |
| CN114416212A (en) | Mobile terminal application program data resource processing method and device | |
| CN111291017A (en) | Mirror image storage and extraction method and device of mirror image warehouse | |
| CN113158259A (en) | Block chain integrity verification method and device | |
| CN113176854A (en) | Service management data processing method, device and system | |
| CN111901403A (en) | Session management method and apparatus, electronic device, and medium | |
| CN111737297A (en) | Method and device for processing link aggregation call information | |
| CN113342501B (en) | System fault processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220927 Address after: 12 / F, 15 / F, 99 Yincheng Road, Pudong New Area pilot Free Trade Zone, Shanghai, 200120 Applicant after: Jianxin Financial Science and Technology Co.,Ltd. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200728 |