US 11,734,229 B2
Reducing database fragmentation
Thomas Manville, Mountain View, CA (US); and Julio Lopez, Mountain View, CA (US)
Assigned to EMC IP Holding Company LLC, Hopkinton, MA (US)
Filed by EMC IP Holding Company LLC, Mountain View, CA (US)
Filed on Aug. 21, 2019, as Appl. No. 16/546,863.
Application 16/546,863 is a continuation of application No. 15/844,203, filed on Dec. 15, 2017, granted, now 10,572,450.
Application 15/844,203 is a continuation of application No. 14/675,454, filed on Mar. 31, 2015, granted, now 9,875,249, issued on Jan. 23, 2018.
Prior Publication US 2019/0377711 A1, Dec. 12, 2019
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/17 (2019.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01)
CPC G06F 16/1724 (2019.01) [G06F 16/2282 (2019.01); G06F 16/2365 (2019.01)] 21 Claims
OG exemplary drawing
 
1. A method, comprising:
storing, by one or more processors, first information associated with a chunk in a first database table, wherein the chunk is associated with a file and the first information associated with the chunk comprises data associated with a first attribute, and the storing the first information comprises storing a null value in the first database table in place of a first attribute value, wherein the first attribute value is a non-null value;
mapping the first attribute to the null value in connection with storing the first attribute value in the first database table;
reducing fragmentation for storing the null value in place of the first attribute value in the first table, wherein reducing fragmentation includes transforming the first database table by removing affected portions of the first database table; and
storing, by one or more processors, the affected portions' non-null values and one or more values for the first attribute in one or more other database tables.