CN108959545A - A kind of Oracle data processing method - Google Patents
A kind of Oracle data processing method Download PDFInfo
- Publication number
- CN108959545A CN108959545A CN201810706948.7A CN201810706948A CN108959545A CN 108959545 A CN108959545 A CN 108959545A CN 201810706948 A CN201810706948 A CN 201810706948A CN 108959545 A CN108959545 A CN 108959545A
- Authority
- CN
- China
- Prior art keywords
- data processing
- middle table
- storing process
- data
- oracle
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of Oracle data processing method, belong to technical field of data processing, Oracle data handling procedure is divided into three Oracle storing process by the present invention, i.e., acquired original data processing is inserted into the storing process of middle table, middle table data are inserted into the storing process of result table and deletes the storing process of middle table.And data processing is completed by three storing process of routine call.Database preparation is carried out using program, instead of uninteresting and time-consuming mechanization data processing work, promotes working efficiency.
Description
Technical field
The present invention relates to internet data processing technique more particularly to a kind of Oracle data processing methods.
Background technique
In internet data collection process, a large amount of data are generated.Such as house type, price and the reservation status in acquisition hotel
Etc. information, data moment changing, it usually needs acquire these information daily, therefore a large amount of initial data can be accumulated.Usually
Collected data are more original, can not directly use, therefore usually require to process the data that acquisition comes, classify, clearly
Equal standardizations are washed, subsequent use is facilitated.
Under normal conditions, the internet data acquired daily is handled, needs to modify daily, execute corresponding processing script.
It is not only time-consuming and laborious, it is also possible to since the maloperation of people causes unnecessary loss.
Summary of the invention
In order to solve the above technical problems, the invention proposes a kind of Oracle data processing methods.It is carried out using program
Data automatically process, and to replace the data processing work of daily repetition and time-consuming, can be obviously improved working efficiency.
The technical scheme is that
A kind of Oracle data processing method,
Oracle data handling procedure is divided into three Oracle storing process, i.e.,
Acquired original data processing is inserted into the storing process of middle table；
Middle table data are inserted into the storing process of result table and delete the storing process of middle table, and pass through routine call three
Storing process completes data processing.
Specifically include following three step:
Step 1: acquired original data processing is inserted into middle table.
Oracle storing process is write, acquired original data are inserted into middle table.
In order to complete daily data processing needs, and can need to create in corresponding daily with more days data of parallel processing
Between table.
After the completion of middle table creation, according to data processing and demand is extracted, by information useful in initial data by taking out
It takes and is inserted into middle table after handling.
Step 2: middle table data are inserted into result table
Oracle storing process is write, middle table data are inserted into object table, daily data processing is completed and updates.
Step 3: deleting middle table
Oracle storing process is write, the middle table of first step creation is deleted, discharges storage space of database.
The beneficial effects of the invention are as follows
Database preparation is carried out using program, instead of uninteresting and time-consuming mechanization data processing work, reduces repeatability
Work promotes working efficiency.
Specific embodiment
More detailed elaboration is carried out to the contents of the present invention below:
A kind of Oracle data processing method of the invention is that Oracle data handling procedure is divided into three Oracle to store
Journey, i.e.,
Acquired original data processing is inserted into the storing process of middle table；
Middle table data are inserted into the storing process of result table and delete the storing process of middle table, and pass through routine call three
Storing process completes data processing.
Specifically:
Step 1: acquired original data processing is inserted into middle table.
Oracle storing process is write, acquired original data are inserted into middle table.
In order to complete daily data processing needs, and can need to create in corresponding daily with more days data of parallel processing
Between table.
After the completion of middle table creation, according to data processing and demand is extracted, by information useful in initial data by taking out
It takes and is inserted into middle table after handling.
Step 2: middle table data are inserted into result table
Oracle storing process is write, middle table data are inserted into object table, daily data processing is completed and updates.
Step 3: deleting middle table
Oracle storing process is write, the middle table of first step creation is deleted, discharges storage space of database.
Claims (3)
1. a kind of Oracle data processing method, which is characterized in that
Oracle data handling procedure is divided into three Oracle storing process, i.e.,
Acquired original data processing is inserted into the storing process of middle table；
Middle table data are inserted into the storing process of result table and delete the storing process of middle table, and pass through routine call three
Storing process completes data processing.
2. the method according to claim 1, wherein
Specifically include following three step:
Step 1: acquired original data processing is inserted into middle table
Oracle storing process is write, acquired original data are inserted into middle table；
Step 2: middle table data are inserted into result table
Oracle storing process is write, middle table data are inserted into object table, daily data processing is completed and updates；
Step 3: deleting middle table
Oracle storing process is write, the middle table of first step creation is deleted, discharges storage space of database.
3. the method according to claim 1, wherein
In the first step, in order to complete daily data processing needs, and creation pair daily can be needed with more days data of parallel processing
The middle table answered；After the completion of middle table creation, according to data processing and demand is extracted, information useful in initial data is passed through
It extracts and is inserted into middle table after handling.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810706948.7A CN108959545A (en) | 2018-07-02 | 2018-07-02 | A kind of Oracle data processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810706948.7A CN108959545A (en) | 2018-07-02 | 2018-07-02 | A kind of Oracle data processing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108959545A true CN108959545A (en) | 2018-12-07 |
Family
ID=64484872
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810706948.7A Pending CN108959545A (en) | 2018-07-02 | 2018-07-02 | A kind of Oracle data processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959545A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101923566A (en) * | 2010-06-24 | 2010-12-22 | 浙江协同数据系统有限公司 | Data increment extraction method based on trigger |
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN102820982A (en) * | 2011-09-21 | 2012-12-12 | 金蝶软件（中国）有限公司 | Data transmission method and device |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN104933042A (en) * | 2013-09-29 | 2015-09-23 | 国家电网公司 | Large-data-volume based database table acquisition optimizing technique |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
| CN105786912A (en) * | 2014-12-25 | 2016-07-20 | 远光软件股份有限公司 | Data acquisition and transformation method and device |
| CN106570086A (en) * | 2016-10-19 | 2017-04-19 | 上海携程商务有限公司 | Data migration system and method |
| WO2017076321A1 (en) * | 2015-11-05 | 2017-05-11 | 中兴通讯股份有限公司 | Database synchronization method and system, source data and target data synchronization device |
-
2018
- 2018-07-02 CN CN201810706948.7A patent/CN108959545A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101923566A (en) * | 2010-06-24 | 2010-12-22 | 浙江协同数据系统有限公司 | Data increment extraction method based on trigger |
| CN102820982A (en) * | 2011-09-21 | 2012-12-12 | 金蝶软件（中国）有限公司 | Data transmission method and device |
| CN102495910A (en) * | 2011-12-28 | 2012-06-13 | 畅捷通信息技术股份有限公司 | Device and method for data timing synchronization of heterogeneous system |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN104933042A (en) * | 2013-09-29 | 2015-09-23 | 国家电网公司 | Large-data-volume based database table acquisition optimizing technique |
| CN105786912A (en) * | 2014-12-25 | 2016-07-20 | 远光软件股份有限公司 | Data acquisition and transformation method and device |
| WO2017076321A1 (en) * | 2015-11-05 | 2017-05-11 | 中兴通讯股份有限公司 | Database synchronization method and system, source data and target data synchronization device |
| CN105589968A (en) * | 2015-12-25 | 2016-05-18 | 中国银联股份有限公司 | Data summarization system and method |
| CN106570086A (en) * | 2016-10-19 | 2017-04-19 | 上海携程商务有限公司 | Data migration system and method |
Non-Patent Citations (1)
| Title |
|---|
| 齐少蕾 等: "一种适应SaaS多租户模式的数据迁移方法", 《计算机工程与应用》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9256665B2 (en) | Creation of inverted index system, and data processing method and apparatus | |
| CN106126543B (en) | The model conversion and data migration method of a kind of relevant database to MongoDB | |
| CN105677728A (en) | Object image recognition and classification managing method | |
| CN109376196B (en) | Method and device for batch synchronization of redo logs | |
| CN110362632A (en) | A kind of method of data synchronization, device, equipment and computer readable storage medium | |
| CN107301214A (en) | Data migration method, device and terminal device in HIVE | |
| CN105975502A (en) | Method for realizing incremental data extract based on CDC (Change Data Capture) mode | |
| CN104199892B (en) | A kind of index reading/writing method for merging asynchronous refresh based on compression | |
| CN103186541A (en) | Generation method and device for mapping relationship | |
| CN105205105A (en) | Data ETL (Extract Transform Load) system based on storm and treatment method based on storm | |
| CN106126522A (en) | A kind of processing system of accounting statement | |
| CN103226610B (en) | Database table querying method and device | |
| CN107944866B (en) | Transaction record duplication elimination method and computer-readable storage medium | |
| CN106155838A (en) | A kind of database back-up data restoration methods and device | |
| CN104408128B (en) | A kind of reading optimization method indexed based on B+ trees asynchronous refresh | |
| CN106033438A (en) | Public sentiment data storage method and server | |
| CN108287889A (en) | A kind of multi-source heterogeneous date storage method and system based on elastic table model | |
| CN110633301A (en) | Method and system for extracting data based on engine setting | |
| CN104298570B (en) | Data processing method and device | |
| CN108959545A (en) | A kind of Oracle data processing method | |
| CN113723501A (en) | Maximum diversity clustering construction method of pathogenic microorganism reference knowledge base | |
| CN104376055B (en) | A kind of large-sized model data comparing method based on allocation methods | |
| CN112052248A (en) | Audit big data processing method and system | |
| CN107784588A (en) | Insurance user information merging method and device | |
| CN112288675A (en) | Vehicle-mounted contact net component imaging processing method |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20190306 Address after: Room 411, 238, Jiangchang Third Road, Zhabei District, Shanghai, 200436 Applicant after: Shanghai wave Cloud Computing Service Co., Ltd. Address before: 250100 S06 Floor, No. 1036 Tidal Road, Jinan High-tech Zone, Shandong Province Applicant before: Shandong Hui Trade Electronic Port Co., Ltd. |
|
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200828 Address after: 214029 No. 999 Gaolang East Road, Binhu District, Wuxi City, Jiangsu Province (Software Development Building) 707 Applicant after: Chaozhou Zhuoshu Big Data Industry Development Co.,Ltd. Address before: 200436, room 238, No. three, 411 Shanghai Road, Zhabei District, China Applicant before: SHANGHAI INSPUR CLOUD CALCULATING SERVICE Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181207 |