Abstract: A system and method for updating files in a file system that is linked to a database system which stores metadata pertaining to the files. Changes intended to be made to an original file are written to a replacement file, and when the user is ready to move the changes onto the original file, a database transaction is commenced. If the transaction commits, the replacement file is renamed to the original file and the file security attributes of the original file are applied. Otherwise, the rename operation does not take place, thereby ensuring consistency between the metadata in the dbms system and the file system data that is represented by the metadata.

Abstract: A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers (“RIDs”) associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.

Abstract: A Resource Management and Reservation System (RMRS) for managing and reserving storage bandwidth, is a platform independent middleware layer that provides an interface to applications, their database management systems, or some other higher level data management systems like ADRS which does data management on behalf of the applications. RMRS is highly relevant in hosted environments where one or more applications may be run on behalf of multiple customers each with a unique service level agreement with the Service Provider. Through its interface to the aforementioned applications, RMRS allows each application or an application side management system to communicate expected future storage access requirements (e.g., periodic access for backups). The interface also allows applications to request urgent storage access (e.g., recovery actions may be requested without being planned ahead of time).

Abstract: A method, storage server, and computer readable medium for off-loading star-join operations from a host information processing system to a storage server. At least a first and second set of keys from a first and second dimension table, respectively are received from a host system. Each of the first and second set of keys is associated with at least one fact table. A set of locations associated with a set of foreign key indexes are received from the host system. A set of fact table indexes are traversed. At least a first set of Row Identifiers (“RIDs”) associated with the first set of keys and at least a second set of RIDs associated with the second set of keys are identified. An operation is performed on the first and second sets of RIDs to identify an intersecting set of RIDs. The intersecting set of RIDs are then stored.

Abstract: A method is provided for query processing in a grid computing infrastructure. The method entails storing data in a data storage system accessible to a plurality of computing nodes. Computationally-expensive query operations are identified and query fragments are allocated to individual nodes according to computing capability. The query fragments are independently executed on individual nodes. The query fragment results are combined into a final query result.

Abstract: According to the present invention a method and a system is provided for establishing synchronized recovery log points in an infrastructure comprising at least a first database management system and a second database management system, whereby recovery log files are written and log points are created separately for each database management system. Firstly, log write of all database management systems is suspended, then, the corresponding log points for each database management system forming a global log point are recorded and log writes of all database management systems are resumed.

Abstract: A system and method to automatically and dynamically optimize available resources to meet application data availability and business objectives. In one embodiment, a backup and data recovery system continually and dynamically adjust to the backup and recovery or restore process depending on the customer's environment, workload, and business objectives. Acceptable tolerance of downtime due to recovery and backup impacts the customer's business or system operation. From this high-level business requirement, the present system determines the backup and recovery plan details. The present system accepts application data availability policies based on business objectives, and devises, executes and refines a resource optimal backup and recovery strategy required to deliver the desired quality of service in the environments that have dynamically changing application workloads, business objectives, and hardware/software infrastructure technologies.

Abstract: A method, an apparatus, a system, a computer program product, and a computer program are disclosed for maintaining consistency of object content (252) and metadata (204) related to the object (252) in a loose transaction model, preferably using SQL Mediated Object Manipulation (SMOM), for object and meta-data updates. The related meta-data (204) and a reference to the object (252) are stored in a table of a database. The object is stored externally to the database in an object store. The reference is used to obtain a handle for directly accessing or manipulating the external object. A version number embedded in the handle is then obtained. The embedded version number is then compared with a version number of a latest committed version of the externally stored object to determine if the handle refers to a current version of the externally stored object.

Abstract: A method, apparatus, article of manufacture, and data structure for use in providing transaction control for a computer-implemented database management system. The database management system manages one or more databases. A transaction processing system provides transaction control for one or more of the databases managed by the database management system, wherein the transaction processing system assigns a recoverable, unique sequence number whenever a request is made by an application.

Abstract: According to the present invention a method and an system is provided for establishing synchronized recovery log points in an infrastructure comprising at least a first database management system and a second database management system, whereby recovery log files are written and log points are created separately for each database management system. Firstly, log write of all database management systems is suspended, then, the corresponding log points for each database management system forming a global log point are recorded and log writes of all database management systems are resumed.

Abstract: A Resource Management and Reservation System (RMRS) for managing and reserving storage bandwidth, is a platform independent middleware layer that provides an interface to applications, their database management systems, or some other higher level data management systems like ADRS which does data management on behalf of the applications. RMRS is highly relevant in hosted environments where one or more applications may be run on behalf of multiple customers each with a unique service level agreement with the Service Provider. Through its interface to the aforementioned applications, RMRS allows each application or an application side management system to communicate expected future storage access requirements (e.g., periodic access for backups). The interface also allows applications to request urgent storage access (e.g., recovery actions may be requested without being planned ahead of time).

Abstract: A client-server computing system is disclosed for supporting relational database records and linked external files. The system comprises one or more servers for storing external files, and a plurality of clients interlinked by a network. Each of the servers and certain of the clients have respective filter layers for controlling servicing of application requests relating to external files, for any application command of a protected class relating to an external file made to a client having a filter layer, the respective client filter layer determines the presence of a valid user token associated with the command, then passes the command to a server across the network. The server filter layer, if it recognizes the command, causes the command to be serviced by the server.

Abstract: A computer system updates a data object that is maintained in data storage external to a database management system (DBMS), after receiving an update request from a DBMS client for the data object, by first scheduling the update request with the DBMS to provide access to the external data object, then initiating a subtransaction in the DBMS for the update request, updating the data object with an in-place update action at the external data storage to thereby produce an updated data object and also updating the DBMS metadata of the data object, next appending information relating to type and time of the update action in an object version table, and then executing a backup operation of the updated data object. This permits update-in-place operations on the external data object, under supervision of the DBMS.

Abstract: A system and method for replicating files in a source file system that is linked to a source DBMS which stores metadata pertaining to files in the source file system. The files and metadata are replicated to a target system having a target file system linked to a target DBMS. File references are also mapped from the source to the target. Also, only the most recent consistent version of files that have changed at the source and that have had insert or update references in the source DBMS are copied over to the target file system, thereby minimizing unnecessary replications.

Abstract: A method, an apparatus, a system, a computer program product, and a computer program are disclosed for maintaining consistency of object content (252) and metadata (204) related to the object (252) in a loose transaction model, preferably using SQL Mediated Object Manipulation (SMOM), for object and meta-data updates. The related meta-data (204) and a reference to the object (252) are stored in a table of a database. The object is stored externally to the database in an object store. The reference is used to obtain a handle for directly accessing or manipulating the external object. A version number embedded in the handle is then obtained. The embedded version number is then compared with a version number of a latest committed version of the externally stored object to determine if the handle refers to a current version of the externally stored object.

Abstract: Coupling facility store-in cache structures are duplexed in order to improve data availability. That is, once duplexing is established, selective data is written to both a primary structure instance and a secondary structure instance. Thus, if one of the structure instances fails, then the other structure instance is used in order to prevent data from being lost. Duplexing can be started manually and/or automatically by the operating system. Further, a structure may be removed from duplex mode and enter simplex mode, if duplexing is not desired.

Abstract: Recovery of a filesystem directory structure is performed to restore it to any point in time and also to synchronize a database restore and a filesystem restore to bring the two restores to a database consistent state. A database management system (DBMS) manages external files and hierarchical directory structures to enable recovery and reconciliation of the files and filesystems, under DBMS control, after filesystem crashes. First, a database table, which recorded previous directory creations and deletions, is used to rebuild a filesystem's directory structure to any previous database state and then external file link information is used to restore files to that same state.

Abstract: A system and method for updating files in a file system that is linked to a database system which stores metadata pertaining to the files. Changes intended to be made to an original file are written to a replacement file, and when the user is ready to move the changes onto the original file, a database transaction is commenced. If the transaction commits, the replacement file is renamed to the original file and the file security attributes of the original file are applied. Otherwise, the rename operation does not take place, thereby ensuring consistency between the metadata in the dbms system and the file system data that is represented by the metadata.

Abstract: In a database system with linkage between data in the database system and files in a system for filing data which is external to the database system (“the filing system”), backup and restoration of the database are coordinated with the filing system. Backup of a referenced file is initiated when the file is linked to the database system. The file backup is asynchronous to the linking process. When database backup occurs, all unfinished file backups are accelerated and completed before the database backup is declared successful. When a database is restored to a state with reference to files in a file manager, the database system causes the file manager to ensure that referenced files are linked to the database system.

Abstract: Castout processing for duplexed data structures. A selective data item is written from a primary instance of a data structure to at least one storage medium. A determination is made as to whether the selective data item can be deleted from a secondary instance of the data structure. If the selective data item can be deleted, it is deleted from the secondary instance.