Abstract: Computer systems, devices, and associated methods of optimizing the execution of instructions of a database statement by a database server are disclosed herein. In one embodiment, a method includes identifying a potential execution plan for executing instructions of the database statement and estimating a cost for executing the execution plan. The cost can comprise an encrypted data processing cost associated with a operation in the execution plan of executing an operation on encrypted data in a protected computing environment. The method can include estimating the encrypted data processing cost in the protected computing environment based on statistics generated in the protected computing environment about a database table. In response to estimating the cost for executing the execution plan, comparing the cost to estimated costs of alternative execution plans, selecting the lowest-cost plan for execution, and executing the lowest-cost execution plan.

Abstract: A method and device for labeling packages and containers. The abstract of the disclosure is submitted herewith as required by 37 C.F.R. § 1.72(b). As stated in 37 C.F.R. § 1.72(b): A brief abstract of the technical disclosure in the specification must commence on a separate sheet, preferably following the claims, under the heading “Abstract of the Disclosure.” The purpose of the abstract is to enable the Patent and Trademark Office and the public generally to determine quickly from a cursory inspection the nature and gist of the technical disclosure. The abstract shall not be used for interpreting the scope of the claims. Therefore, any statements made relating to the abstract are not intended to limit the claims in any manner and should not be interpreted as limiting the claims in any manner.

Abstract: Computer systems, devices, and associated methods of optimizing the execution of instructions of a database statement by a database server are disclosed herein. In one embodiment, a method includes identifying a potential execution plan for executing instructions of the database statement and estimating a cost for executing the execution plan. The cost can comprise an encrypted data processing cost associated with a operation in the execution plan of executing an operation on encrypted data in a protected computing environment. The method can include estimating the encrypted data processing cost in the protected computing environment based on statistics generated in the protected computing environment about a database table. In response to estimating the cost for executing the execution plan, comparing the cost to estimated costs of alternative execution plans, selecting the lowest-cost plan for execution, and executing the lowest-cost execution plan.

Abstract: A labeling device includes a container transporter that conveys the containers along a conveyor path and a first conveyor that runs between the return-stations. The labeling stations are arranged along the conveyor path between the return-stations. The frame's frame ends lie at opposite ends of a longitudinal axis. Attachment-sections associated with the frame ends attach to respective return stations, with at least one of them permitting attachment of a return-station at multiple positions along the axis. These attach to the mounts, which have continuous mounting-elements extending between the return-stations along the longitudinal axis. The mounts enable mounting a labeling station in any position between the return-stations using an attachment element that is complementary to the mounts and with which the labeling stations are equipped.

Abstract: A labeling device includes a container transporter that conveys the containers along a conveyor path and a first conveyor that runs between the return-stations. The labeling stations are arranged along the conveyor path between the return-stations. The frame's frame ends lie at opposite ends of a longitudinal axis. Attachment-sections associated with the frame ends attach to respective return stations, with at least one of them permitting attachment of a return-station at multiple positions along the axis. These attach to the mounts, which have continuous mounting-elements extending between the return-stations along the longitudinal axis. The mounts enable mounting a labeling station in any position between the return-stations using an attachment element that is complementary to the mounts and with which the labeling stations are equipped.

Abstract: A method for equipping bottles with equipment elements using a group of at least three similar container-equipping subassemblies designed to apply equipment elements to a container region of containers moving, on a transporting system, past the container-equipping subassemblies includes, during disruption-free operation, activating at least two container-equipping subassemblies of the group to equip in each case one container that has not yet been labeled by another container-equipping subassembly of the group, and during disruption-free operation, placing at least one container-equipping subassembly assigned to the group in standby mode, and in the event of disruption to a first activated container-equipping subassembly in the group, activating the container-equipping subassembly that is in standby mode to take over the function of the first container-equipping subassembly.

Abstract: A system and method for accelerating searches of B-trees. An auxiliary index that is optimized for use with a cache is used in conjunction with a B-tree. A hash type of auxiliary index maintains pointers to key entries in the B-tree leaf nodes. The hash type of index may be searched, and a resulting pointer is used to locate records of the B-tree, bypassing a search of the B-tree. A top level type of auxiliary index maintains pointers to leaf nodes or internal nodes of the B-tree. A top level index may be searched, and a search of the B-tree is performed beginning with the node found by using the top level index. A monitoring mechanism may automatically start, change, or discard the auxiliary index based on an amount of cache memory, types of searches, or other factors. The auxiliary index may be optimized for high performance in read only searches, while the B-tree provides transaction durability.

Abstract: A system and method for accelerating searches of B-trees. An auxiliary index that is optimized for use with a cache is used in conjunction with a B-tree. A hash type of auxiliary index maintains pointers to key entries in the B-tree leaf nodes. The hash type of index may be searched, and a resulting pointer is used to locate records of the B-tree, bypassing a search of the B-tree. A top level type of auxiliary index maintains pointers to leaf nodes or internal nodes of the B-tree. A top level index may be searched, and a search of the B-tree is performed beginning with the node found by using the top level index. A monitoring mechanism may automatically start, change, or discard the auxiliary index based on an amount of cache memory, types of searches, or other factors. The auxiliary index may be optimized for high performance in read only searches, while the B-tree provides transaction durability.

Abstract: A beverage bottling plant for filling bottles with a liquid beverage filling material, a container filling plant container information adding station, such as, a labeling station, configured to add information to containers, such as, bottles and cans, and modules for labeling stations proposed a labeling machine. Each module comprises a first coupling structure to permit interchangeable position of a module at one of a plurality of second coupling structures. The abstract of the disclosure is submitted herewith as required by 37 C.F.R. §1.72(b). As stated in 37 C.F.R. §1.72(b): A brief abstract of the technical disclosure in the specification must commence on a separate sheet, preferably following the claims, under the heading “Abstract of the Disclosure.” The purpose of the abstract is to enable the Patent and Trademark Office and the public generally to determine quickly from a cursory inspection the nature and gist of the technical disclosure.

Abstract: A beverage bottling plant for filling bottles with a liquid beverage filling material, a container filling plant container information adding station, such as, a labeling station, configured to add information to containers, such as, bottles and cans, and modules for labeling stations proposed a labeling machine. Each module comprises a first coupling structure to permit interchangeable position of a module at one of a plurality of second coupling structures.

Abstract: A system and/or methodology to track and organize database application data in response to a delete, insert or update procedure. More specifically, a system and/or methodology that employs a version-based retention and linkage approach with respect to triggering implementations is provided.

Abstract: In order to provide recovery for a database stored on storage not meeting the WAL protocol requirements, for example, storage including a temporary cache and a second storage (e.g. an IDE disk with a temporary cache and a hard disk), a log is created including, for each changed page, a pre-image of the page before changes were effected. The log also includes one or more change log records logging changes made to the page. Periodic checkpoints occur in which the cached pages are flushed to the disk. Recovery proceeds with a redo pass through the active log and then with an undo pass, undoing any transactions that have not been committed.

Abstract: Systems and methods are disclosed that facilitate providing page-level database restore functionality upon detection of a corruption event. Updates to a data page in a database can trigger generation of a snapshot of the data page, and an update log can be maintained that stores information related to page updates. Subsequent snapshots can be generated at predetermined intervals and can trigger truncation of a log segment and initiation of a new log segment. Upon detection of page corruption, a most-recent uncorrupt snapshot of the corrupt page can be identified, copied to the location of the corrupt page in the database, and modified according to the log segment associated with the uncorrupt snapshot to make the page current as of the corrupting event, all of which can be performed to restore the database without having to take the database offline.

Abstract: A beverage bottling plant for filling bottles with a liquid beverage filling material, a container filling plant container information adding station, such as, a labeling station, configured to add information to containers, such as, bottles and cans, and modules for labeling stations proposed a labeling machine. Each module comprises a first coupling structure to permit interchangeable position of a module at one of a plurality of second coupling structures. The abstract of the disclosure is submitted herewith as required by 37 C.F.R. §1.72(b). As stated in 37 C.F.R. §1.72(b): A brief abstract of the technical disclosure in the specification must commence on a separate sheet, preferably following the claims, under the heading “Abstract of the Disclosure.” The purpose of the abstract is to enable the Patent and Trademark Office and the public generally to determine quickly from a cursory inspection the nature and gist of the technical disclosure.

Abstract: A beverage bottling plant for filling bottles with a liquid beverage filling material, a container filling plant container information adding station, such as, a labeling station, configured to add information to containers, such as, bottles and cans, and modules for labeling stations proposed a labeling machine. Each module comprises a first coupling structure to permit interchangeable position of a module at one of a plurality of second coupling structures. The abstract of the disclosure is submitted herewith as required by 37 C.F.R. §1.72(b). As stated in 37 C.F.R. §1.72(b): A brief abstract of the technical disclosure in the specification must commence on a separate sheet, preferably following the claims, under the heading “Abstract of the Disclosure.” The purpose of the abstract is to enable the Patent and Trademark Office and the public generally to determine quickly from a cursory inspection the nature and gist of the technical disclosure.

Abstract: A beverage bottling plant for filling bottles with a liquid beverage comprising of a filling machine, a bottle closing station and a labeling station configured and disposed to label filled bottles. The labeling station comprises a label storage magazine configured to hold a plurality of single-sheet labels in a stacked condition, pie-shaped grippers, that extract labels from the storage magazine and directly apply them on the bottles. The grippers are heated prior to applying the labels to the bottles to assist in securing the labels and then the grippers are cooled.

Abstract: In order to provide a more efficient persistent storage device, one or more long-term storage media are included along with a non-volatile memory. In one embodiment, one portion of the non-volatile memory is used as a write buffer and a read cache for writes and reads to the long-term storage media. Interfaces are provided for controlling the use of the non-volatile memory as a write buffer and a read cache. Additionally, a portion of the non-volatile memory is used to provide a direct mapping for specified sectors of the long-term storage media. Descriptive data regarding the persistent storage device is stored in another portion of the non-volatile memory.

Abstract: A method and system for fragment-based serialization places one or more object members in fragments. Fragments may comprise a header and a payload. A header can provide useful information about the fragment, such as an indication of fragment type and an indication of fragment length. A payload may comprise one or more members of an object. Primitive members may be stored in a Binary Fragment with a record format payload. LOB and FS members may be stored in fragments that have a Value Type field for setting forth additional properties of the fragment. Collections may be stored in a series of fragments, a first fragment to indicate a start of a collection, one or more second fragments to serialize collection elements, and a Terminator Fragment to indicate the end of a collection. Fragment-serialized objects minimize storage overhead while providing fast instantiation and low-cost location and updating.

Abstract: A method and system for fragment-based serialization places one or more object members in fragments. Fragments may comprise a header and a payload. A header can provide useful information about the fragment, such as an indication of fragment type and an indication of fragment length. A payload may comprise one or more members of an object. Primitive members may be stored in a Binary Fragment with a record format payload. LOB and FS members may be stored in fragments that have a Value Type field for setting forth additional properties of the fragment. Collections may be stored in a series of fragments, a first fragment to indicate a start of a collection, one or more second fragments to serialize collection elements, and a Terminator Fragment to indicate the end of a collection. Fragment-serialized objects minimize storage overhead while providing fast instantiation and low-cost location and updating.

Abstract: A method for performing a consistency check on a database backup of a database is performed without requiring a full recovery of the original database from the database backup. Instead, a database view may be used as a smaller storage requirement tool for providing a transaction-consistent view of portions of an existing full database backup. The database view, in combination with the database backup and transaction log, contains all the information necessary to perform a consistency check on the database backup without a full reconstitution of the original database from the database backup. The consistency check may be run on the database view along with the database backup to verify the integrity of the full database backup to add improved reliability to a database recovery scheme.