Snowflake Assigned Four Patents
Storing multi-level metadata in database, database metadata in immutable storage, adaptive distribution for hash operation
By Francis Pelletier | January 18, 2021 at 2:18 pmStoring multi-level metadata in database
Snowflake Inc., San Mateo, CA, has been assigned a patent (10,866,955) developed by Dageville, Benoit, San Mateo, CA, Fang, Yi, Kirkland, WA, Hentschel, Martin, Berlin, Germany, Motivala, Ashish, Foster City, CA, Triantafyllis, Spyridon, San Mateo, CA, and Zhu, Yizhi, Bellevue, WA, for “storing multi-level metadata in database systems.“
The abstract of the patent published by the U.S. Patent and Trademark Office states: ”The subject technology receives first metadata corresponding to a set of micro-partitions. The subject technology generates second metadata for a grouping of the first metadata. The subject technology generates a first data structure including the first metadata and a second data structure including the second metadata, the second data structure including information associating the second metadata to the first metadata. Further, the subject technology stores the first data structure and the second data structure in persistent storage as a first file and a second file.”
The patent application was filed on April 30, 2020 (16/863,627).
Database metadata in immutable storage
Snowflake Inc., San Mateo, CA, has been assigned a patent (10,860,573) developed by Dageville, Benoit, San Mateo, CA, Hentschel, Martin, Berlin, Germany, and Waddington, William, San Mateo, CA, for a “database metadata in immutable storage.“
The abstract of the patent published by the U.S. Patent and Trademark Office states: ”A method for a database system includes storing table data for a database, the table data including information in rows and columns of one or more database tables. The method includes storing metadata on immutable storage, the metadata including information about the table data for the database. In one embodiment, mutable metadata may be periodically consolidated in the background to create new versions of metadata files and which allows for deletions of old metadata files and old data files.”
The patent application was filed on April 2, 2020 (16/838,301).
Adaptive distribution for hash operation
Snowflake Inc., San Mateo, CA, has been assigned a patent (10,838,979) developed by Dageville, Benoit, Seattle, WA, Cruanes, Thierry, Zukowski, Marcin, San Mateo, CA, Lee, Allison Waingold, San Carlos, CA, and Unterbrunner, Philipp Thomas, Belmont, CA, for an “adaptive distribution method for hash operation.“
The abstract of the patent published by the U.S. Patent and Trademark Office states: ”A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.”
The patent application was filed on April 24, 2020 (16/858,518).
Adaptive distribution for hash operation
Snowflake Inc., San Mateo, CA, has been assigned a patent (10,838,978) developed by Dageville, Benoit, Seattle, WA, Cruanes, Thierry, Zukowski, Marcin, San Mateo, CA, Lee, Allison Waingold, San Carlos, CA, and Unterbrunner, Philipp Thomas, Belmont, CA for an “adaptive distribution method for hash operation.“
The abstract of the patent published by the U.S. Patent and Trademark Office states: ”A method, apparatus, and system for join operations of a plurality of relations that are distributed over a plurality of storage locations over a network of computing components.”
The patent application was filed on April 24, 2020 (16/858,510).