Abstract: A choose tree is generated at compile time to facilitate a determination if any partition of a range partitioned database table includes a particular key at runtime. To generate the choose tree at compile time, a query compiler receives a source code indicative of each partition of the range partitioned database table, and generates the choose tree from the source code at compile time where the choose tree is representative of a pre-computed binary search of the range partitioned database table. Thereafter, the choose tree can be interpreted/executed at runtime to facilitate a traversal of the choose tree for determining if any partition of the range partitioned database table includes the particular key.

Abstract: A system and a method for the deferral and incremental performance of integrity processing for data rolled into a table of a data warehouse and for the deferral and incremental performance of maintenance on data rolled out of a table of the data warehouse while permitting general users online access to other data contained in the table. The rolled in and rolled out data are contained within specific data partitions of the table. Each data partition in the table has an associated distinguishable partition ID. Each data partition can also have associated attributes corresponding to containing rolled-in and rolled-out data respectively. Table operation mechanisms are arranged such that general users of the table do not access rolled in data in a partition for which integrity processing has not yet been performed and do not access rolled out data.

Abstract: Disclosed is an electrical box extension that includes an extending member for switch and/or plug mounting having one or more fastening brackets, one or more base fastening brackets and one or more fasteners that together with optional contact points provide for mechanical and electrical connectivity between the extending member and its associated electrical box and provide sufficient mechanical resistance to support the adjustable elevation of the elevating member thereby supporting a flush surface for surface mounted sockets, switches and their associated plates.

Abstract: Disclosed is an electrical box extension that includes an extending member for switch and/or plug mounting having one or more fastening brackets, one or more base fastening brackets and one or more fasteners that together with optional contact points provide for mechanical and electrical connectivity between the extending member and its associated electrical box and provide sufficient mechanical resistance to support the adjustable elevation of the elevating member thereby supporting a flush surface for surface mounted sockets, switches and their associated plates.

Abstract: Disclosed is an electrical box extension that is a combination of a tubular sleeve with one or more fastening brackets, an electrical box adaptor plate with one or more fastening brackets and one or more double reverse screws as the preferred fasteners for mechanically and electrically connecting the tubular sleeve and the adaptor plate via the brackets providing sufficient mechanical resistance to support the adjustable elevation of the tubular sleeve thereby providing a flush surface for surface mounted sockets, switches and their associated plates.