Abstract: The subject technology determines whether a table is sufficiently clustered. The subject technology in response to determining the table is not sufficiently clustered, selects one or more micro-partitions of the table to be reclustered. The subject technology constructs a data structure for the table. The subject technology extracts minimum and maximum endpoints for each micro-partition in the data structure. The subject technology sorts each of one or more peaks in the data structure based on height. The subject technology sorts overlapping micro-partitions based on width. The subject technology selects based on which micro-partitions are within the tallest peaks of the one or more peaks and further based on which of the overlapping micro-partitions have the widest widths.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: The subject technology determines whether a table is sufficiently clustered. The subject technology in response to determining the table is not sufficiently clustered, selects one or more micro-partitions of the table to be reclustered. The subject technology constructs a data structure for the table. The subject technology extracts minimum and maximum endpoints for each micro-partition in the data structure. The subject technology sorts each of one or more peaks in the data structure based on height. The subject technology sorts overlapping micro-partitions based on width. The subject technology selects based on which micro-partitions are within the tallest peaks of the one or more peaks and further based on which of the overlapping micro-partitions have the widest widths.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: The subject technology determines whether a table is sufficiently clustered. The subject technology in response to determining the table is not sufficiently clustered, selects one or more micro-partitions of the table to be reclustered. The subject technology constructs a data structure for the table. The subject technology extracts minimum and maximum endpoints for each micro-partition in the data structure. The subject technology sorts each of one or more peaks in the data structure based on height. The subject technology sorts overlapping micro-partitions based on width. The subject technology selects based on which micro-partitions are within the tallest peaks of the one or more peaks and further based on which of the overlapping micro-partitions have the widest widths.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: Resource provisioning systems and methods are described. In an embodiment, a system includes a plurality of shared storage devices collectively storing database data, an execution platform, and a compute service manager. The compute service manager is configured to determine a task to be executed in response to a trigger event and determine a query plan for executing the task, wherein the query plan comprises a plurality of discrete subtasks. The compute service manager is further configured to assign the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform, determine whether execution of the task is complete, and in response to determining the execution of the task is complete, store a record in the plurality of shared storage devices indicating the task was completed.

Abstract: Resource provisioning systems and methods are described. In an embodiment, a system includes a plurality of shared storage devices collectively storing database data, an execution platform, and a compute service manager. The compute service manager is configured to determine a task to be executed in response to a trigger event and determine a query plan for executing the task, wherein the query plan comprises a plurality of discrete subtasks. The compute service manager is further configured to assign the plurality of discrete subtasks to one or more nodes of a plurality of nodes of the execution platform, determine whether execution of the task is complete, and in response to determining the execution of the task is complete, store a record in the plurality of shared storage devices indicating the task was completed.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: Automatic clustering of a database table is disclosed. A method for automatic clustering of a database table includes receiving an indication that a data modification task has been executed on a table and determining whether the table is sufficiently clustered. The method includes, in response to determining the table is not sufficiently clustered, selecting one or more micro-partitions of the table to be reclustered. The method includes assigning each of the one or more micro-partitions to an execution node to be reclustered.

Abstract: The invention, Real Estate Floor Plan System, is a series of pre-cut shapes printed on flexible vinyl, which can be rolled, placed and carried in a lightweight, tubular shoulder bag. This new product will be marketed towards realtors, interior designers, DIYers, moving companies, or anyone who deals with vacant rooms or properties. Real Estate Floor Plan System is designed to a help clients visualize and plan how their furniture will best fit in specific spaces inside a home, office, or business.

Abstract: Magnetic structural components utilized to permit construction of a wide variety of structural profiles and to thereby increase design and/or construction flexibility and choice. The structural components each include a number of magnets operatively associated with a periphery thereof to provide a number of points of magnetic connection. In addition, each structural component has at least one mechanical connector operatively associated therewith to provide at least one point of mechanical connection. The structural components can be magnetically and/or mechanically interconnected to form a variety of different two or three-dimensional structural profiles of varying complexities.

Abstract: A movable magnetic construction kit that is suitable for creating a variety of different construction profiles and including at least one primary connecting element that can be operatively associated with one or more secondary connecting elements via magnetic and/or mechanical connections. The primary connecting element has at least one aperture therein and a plurality of magnets operatively associated with an edge thereof. The primary connecting element in combination with the secondary connecting elements provides for a movable construction kit for enhanced construction and design capabilities.

Abstract: A magnetic construction module that is suitable for creating a variety of different construction profiles and lengths and that permits the construction of modules where at least some of the members are adapted to be flexible. A rod is attachable to a holder adapted for retaining a magnet. The magnet is retained in a pocket of the holder. The holder can be attached in rods of various lengths, curves, rigidities to conform to the shape desired by the user. An outer surface of the magnet is adapted to provide a magnetic connection to a magnetizeable element such as a metal sphere with which the rod and holder can be operatively associated for a particular construction profile. Moreover, the holder may also be securely, selectively connected to the rod via a male-female connection in order to provide greater construction flexibility.

Abstract: A combination pen and walkie-talkie device includes a walkie-talkie incorporated within the housing of a writing pen such that the walkie-talkie function of the device is well concealed. The antenna of the walkie-talkie is concealed by being entirely enclosed within the pen housing. Examples include a combination pen and walkie-talkie device in which the walkie-talkie circuitry operates at a transmit/receive frequency within a range of from about 462 MHz to about 467 MHz, and/or in which the transmit/receive antenna is a half-wavelength antenna having a free length greater than one foot.

Abstract: What is new in this invention pertains to the use of only citric acid, with or without water, in treating tobacco, to reduce and/or eliminate nicotine and nitrosaminies in the tobacco.