Oracle Bulk Binds技术分析

通过对Oracle批量绑定功能原理的分析,提出利用批量绑定技术来提高海量数据操作性能的观点;运用SQL脚本实例对比分析,验证批量绑定的强大优势,并从中研究出一种通过提高数据库缓冲区,利用分组的批量绑定方式来大幅度提高TB级数据DML性能的方法. According to the functional analysis of Oracle bulk binds,a theory which makes use of the technology of bulk binds to enhance the manipulation performance of millions of data is...

Full description

Bibliographic Details
Main Authors: 周晓丹, 冯少荣, 薛永生
Format: Article in Journal/Newspaper
Language:Chinese
Published: 2007
Subjects:
Oracle
数据库
批量绑定
database
bulk binds
DML
Online Access:http://dspace.xmu.edu.cn/handle/2288/156785
Description
Summary:通过对Oracle批量绑定功能原理的分析,提出利用批量绑定技术来提高海量数据操作性能的观点;运用SQL脚本实例对比分析,验证批量绑定的强大优势,并从中研究出一种通过提高数据库缓冲区,利用分组的批量绑定方式来大幅度提高TB级数据DML性能的方法. According to the functional analysis of Oracle bulk binds,a theory which makes use of the technology of bulk binds to enhance the manipulation performance of millions of data is proposed.SQL scripts are executed to compare and establish the soundness of bulk binds,and a methodology that divides one hundred million rows' data into parts to enhance bulk binds function's performance is developed.

Similar Items