摘要
与常规数据库相比,大数据库不仅仅是数据存储量巨大,每一个表结构记录的条数也更大,其对于系统管理、系统性能等提出了许多新的要求。为了对大数据表在查询过程中农工存在的延迟问题以及管理问题进行解决,可以将表分区方法引入其中。该文从表分区的原理出发,以SQL Server 2012为例,对大数据库优化中表分区的实现方法进行了研究和讨论,希望能够借此提升大数据库数据管理与查询的效率。
Compared with the conventional database, the large database is not only a huge amount of data storage, but also a larger number of records per table structure. It puts forward many new requirements for system management and system performance. In order to solve the delay problem and management problem of the agricultural workers in the query process of the big data table, the table partitioning method can be introduced. Based on the principle of table partitioning, this paper takes SQL Server 2012 as an example to study and discuss the implementation method of table partitioning in large database optimization,hoping to improve the efficiency of large database data management and query.
出处
《电脑知识与技术》
2018年第9Z期18-19,共2页
Computer Knowledge and Technology
关键词
表分区
大数据库
优化
table partitioning
large database
optimization
