"To segment a single table into multiple tables based on selected columns. Each of the multiple tables has the same number of rows but fewer columns. See also horizontal filtering; vertical filtering." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)
"Vertical partitioning segments a single table into multiple tables based on selected columns. Each of the multiple tables has the same number of rows but fewer columns." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)
"The process of splitting a single table into multiple tables based on selected columns. Each of the multiple tables has the same number of rows but fewer columns." (SQL Server 2012 Glossary, "Microsoft", 2012)
"Vertical partitioning is a technique for improving database performance by storing columns of a relational table in separate, multiple partitions. This is especially helpful when only a subset of columns is read from a row of data and the columns are read from many rows." (Dan Sullivan, "NoSQL for Mere Mortals®", 2015)
"Storing a relation as two or more tables that are projections of the original relation to improve database performance." (Jan L Harrington, "Relational Database Design and Implementation" 3rd Ed., 2009)
No comments:
Post a Comment