Oracle数据库分区技术研究与应用

Research and application of Oracle database partitioning technology

利用Oracle数据平台分区技术管理用户数据,依据主键确定用户数据物理存储空间,在目标数据表中使用主键值创建存储索引,定义不同分区数据的存储结构和空间。基于某网站“客户基本信息主文件”数据表CUSTOMER_TABLE为演示数据,分析数据库分区技术的应用过程,提高用户建立、检索和更新目标数据表的技术能力。

In order to manage user data using Oracle data platform partitioning technology,determining the physical storage space of user data based on the primary key,creating a storage index using the primary key value for the target data table,to define the storage structure and space of different partitioned data.The data table CUSTOMER_TABLE,which is based on the"customer basic information master file"of a website,is the demonstration data,to analyze the application process of database partitioning technology for improve users technical ability to create,retrieve and update target data tables.