Unlock instant, AI-driven research and patent intelligence for your innovation.

Mass data processing method and device based on Oracle

A mass data processing and database technology, applied in the field of data processing, can solve problems such as slow response and timeout of query operations, and achieve the effects of slow response speed, improved retrieval speed, and reduced data volume

Active Publication Date: 2019-03-19
BANK OF CHINA
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the present invention provides an Oracle-based massive data processing method and device, which are used to solve the problems of slow response and timeout in query operations based on massive data in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Mass data processing method and device based on Oracle
  • Mass data processing method and device based on Oracle
  • Mass data processing method and device based on Oracle

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0053] First, the applicant explains the relevant technical terms involved in the present invention.

[0054] Oracle: It is a relational database developed by Oracle in the United States.

[0055] Oracle awr: The full name is Automatic Workload Repository, which is interpreted as automatic load information library in Chinese. It is an analysis tool for oracle database, and its function is to collect, process and maintain performance system i...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a mass data processing method and device based on Oracle. The method comprises the steps that SQL-like statements are generated according to a received operation request initiated by a client, and each SQL-like statement comprises an SQL statement structure part, a database sub-table prefix name, a key element item and the maximum number of sub-tables related to a table nameprefix; wherein one key element item corresponds to one database table, one database table is divided into a plurality of database sub-tables, and prefix names of the plurality of database sub-tablescorresponding to the same database table are the same; analyzing the SQL-like statement; calculating the serial number of each database sub-table; for each database sub-table, obtaining a name of thedatabase sub-table according to a database sub-table prefix name and a serial number of the database sub-table; generating SQL scripts used for oracle execution based on the obtained names of the database sub-tables; and submitting the SQL script to an oracle for execution. According to the invention, the retrieval speed is improved.

Description

Technical field [0001] The invention relates to the technical field of data processing, in particular to an Oracle-based mass data processing method and device. Background technique [0002] In the existing centralized mode, the oracle partition technology is generally used to store massive data in partitions. However, although the data is stored in different storage areas, each time a query operation is performed, the amount of data recorded in the database table is large. Responses to query operations are often slow or even timeout. [0003] Taking the database table as the historical account transaction flow table of the bank as an example, it is assumed that the historical account transaction flow table stores the change account data of each account within 2 years, which generally contains tens of billions of data. So in the actual application process, if you query data according to the query condition "account number + query start date + query end date", hundreds of query tra...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/28
Inventor 肖飞军赵斯兵陆雯怡金晓磊王华阳董洁
Owner BANK OF CHINA