Abstract: A data-warehousing system allows various areas of an enterprise to view data at varying levels of data freshness. The system acquires data that represents an event in the life of a business enterprise, such as a transaction between the enterprise and one of its customers, and loads this data into a database table. The system then makes the data available for retrieval from the table and stores information indicating when the data was made available for retrieval. In some embodiments, the system also acquires data that is related to and more current than the data representing the event and stores the more current data in the database. The system then stores information indicating when the more current data was stored in the database. Such a data warehouse allows decision-makers in the business to see some information (e.g., customer transaction or account data) up-to-the-moment and other information as it stood at some specific point-in-time, such as at the end of the previous month.

Abstract: A SQL query that includes an IN-List is optimized by (1) performing an evaluation to determine whether access to a table can be performed as a join operation, (2) converting the IN-List to an IN-LIST relation, and (3) joining the IN-List relation with the table to access the data in the table.

Abstract: A computer network is used to improve the profitability of one or more business entities. The network receives business-related data from at least two business entities and stores at least some of the data from each of the business entities in a common database. Then, in accordance with the terms of an agreement among the business entities, the network allows at least one of the business entities to receive information gathered from the common database.

Abstract: A database management system receives a request to perform an operation on a set of target data and, at some point after it begins executing that operation, places a lock on the target data to prevent concurrent execution of other operations on the target data. In some embodiments, the system receives an instruction from a user to perform a data-definition operation on a set of target data; places an initial lock on the target data at a level that allows at least one concurrent operation on the target data; begins executing the operation; and then places a final lock on the target data at a level that excludes all other concurrent operations on the target data.

Abstract: A service establishment, such as a fast-food restaurant or a bank, improves customer satisfaction by monitoring the quality of service received by the customer and compensating the customer with a personalized offer of compensation when service is inadequate. When the customer visits the service establishment, the service establishment detects the customer's presence by acquiring a signal from a device, such as an RF transponder, carried by the customer. The establishment uses information contained in this signal to identify the customer and to retrieve archived information about previous interactions with the customer. The establishment then analyzes the archived information to identify a product or service of interest to the customer and, before the customer leaves the service establishment, to offer the product or service to the customer.

Abstract: A hardware cabinet includes a chassis that is designed for mounting multiple heat-generating electronic systems and a door that allows access into the cabinet. The door has a solid face that extends from the top portion of the door along the majority of the door's length. An opening formed in a lower portion of the door allows chilled air to enter the cabinet. The chassis is structured so that, when electronic systems are mounted in the cabinet, a plenum is formed between the door and the electronic systems. The plenum allows air entering the cabinet to rise between the door and the electronic systems.