Dynamic data processing method applied to Oracle database

A technology of dynamic data and processing methods, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as DAO re-ordering, achieve high flexibility, reduce transformation and upgrade costs, and reduce module coupling. Effect

Inactive Publication Date: 2012-12-12
WHALE CLOUD TECH CO LTD
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage is that once the application changes, DAO needs to be re-ordered

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
  • Dynamic data processing method applied to Oracle database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0027] Such as figure 1 Shown, a kind of dynamic data processing method applied to Oracle database, it comprises the following steps:

[0028] (a) Create a data access object, that is, a DAO object, including data insertion, update, and deletion;

[0029] (b), set the connection database Oracle;

[0030] (c) Set the structured query statement corresponding to the DAO object, that is, the SQL statement;

[0031] (d) Set corresponding binding parameters of each SQL statement; including: parameter name, ie SQL variable name, parameter type, parameter length, target value of parameter and parameter position.

[0032] (e) Perform dynamic data processing, receive data operation instructions, and save the data operation instructions to the cache of the corresponding DAO object;

[0033] (f) Determine whether the DAO object to be processed needs to continue...

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 relates to a dynamic data processing method applied to an Oracle database, which comprises the following steps of: creating data access objects, i.e. DAO (Data Access Object) objects, which comprise data insertion, updating and deletion; setting the connected database Oracle; setting structured query languages, i.e. SQL languages, corresponding to the DAO objects; setting corresponding bound parameters corresponding to each SQL languages; executing the dynamic data processing, receiving data operation commands and storing the data operation commands into caches of the corresponding DAO objects; judging whether the DAO objects to be processed need to be subjected to data insertion and if yes, continuously inserting data into the caches distributed for the data by the DAO objects; or, executing the data processing and finishing. According to the invention, by a dynamic DAO technology, the reconstruction upgrading cost is greatly reduced, the investment of manpower resources is reduced and the stability of a system is improved.

Description

Technical field [0001] The invention involves data access objects, that is, dynamic DAO technology, especially Oracle batch data processing. Specifically, it is a dynamic data processing method applied to the Oracle database. [0002] Background technique [0003] QuickMDB is a memory database that stored in shared memory, and can also be synchronized to file databases such as Oracle. [0004] Due to the efficiency required by QuickMDB itself, the speed of data synchronization must be very high.For access to Oracle data, single processing is simple and convenient, but the speed is only a few hundred pieces per second, which obviously cannot meet the performance requirements.Oracle provides a set of batch processing data interfaces that can increase the synchronization speed to thousands of pieces per second. [0005] This method of processing data is arraybound technology, which can achieve DAO, data access object. [0006] In the DAO scheme, how to apply DAO to synchronous logic...

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): G06F17/30
Inventor 刘启铨董春
Owner WHALE CLOUD TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap