Abstract:
The atomicity of a transaction is extended to a filesystem as well as a database, meaning that, when the transaction is complete, all changes within the transaction to both the database and the filesystem will be either committed or not committed. Interactions may be coordinated among a client, a database resource manager, a filesystem resource manager, and a transaction manager.
Abstract:
A type of an object that can be persisted in a database store is defined by a user. The type definition comprises fields and behaviors, each field having a respective data type. One or more fields of the type definition may be designated as containing data of a type that is to be stored as a file outside of the database store and separately from the other fields of the type definition. When a request is received to store an object that is an instance of the user defined type, the data in any so designated field of the object is stored in a file outside of the database store, preferably within a file system of the computer on which the database store is implemented. The data in each of the other fields of the object is stored within the database store in the usual manner. The database store maintains a link, or reference, between the persisted object and the data of the field that is stored as a file outside of the database store. Applications are provided “out of band” access, via the file system of the computer, to the file in which the data of given field is stored outside the database store.
Abstract:
Providing for network-based management of dynamic mobile coupons (DMCs) employed in mobile device-related commerce is described herein. Management can include mitigating processing load involved in processing dynamic characteristics of a set of DMCs, facilitating post-transaction evaluation of DMCs, or facilitating a virtual shopping experience in conjunction with redeeming DMCs in a mobile-commerce environment. Communicative association between a mobile device and network components can be implemented to leverage data collected by the mobile device with communication and processing capabilities of the network. Dynamic DMC states are determined from the collected data, which are implemented to facilitate the mobile-commerce. The disclosure provides an integrated mechanism for efficient utilization of DMCs to enhance user experience and satisfaction with mobile commerce.
Abstract:
A set of servers takes advantage of the existing data redundancy of a mirrored database to restore page corruptions. The page restore may occur with none of the time and/or administration costs of a restore from backup media and without the data loss associated with repair. Online page restore from a database mirror can be initiated and performed by the computer system automatically upon corruption detection. An entire file or database instead of an individual page or set(s) of pages can be restored. The mechanism can be used both to restore corrupt pages on the principal server from a mirror, or corrupt pages on a mirror from the principal server. Online page restore from a database mirror enables page data recovery without the need to find/load/scan through and apply data and log backups, allowing efficient and potentially automatic data recovery.
Abstract:
Providing for network-based management of dynamic mobile coupons (DMCs) employed in mobile device-related commerce is described herein. Management can include mitigating processing load involved in processing dynamic characteristics of a set of DMCs, facilitating post-transaction evaluation of DMCs, or facilitating a virtual shopping experience in conjunction with redeeming DMCs in a mobile-commerce environment. Communicative association between a mobile device and network components can be implemented to leverage data collected by the mobile device with communication and processing capabilities of the network. Dynamic DMC states are determined from the collected data, which are implemented to facilitate the mobile-commerce. The disclosure provides an integrated mechanism for efficient utilization of DMCs to enhance user experience and satisfaction with mobile commerce.
Abstract:
Methods and computer-readable media for maintaining transactional link-level consistency between a database and a file system. A file system change is logged in a record of a database log and a file corresponding to the file system change is created in a file system folder. During a restart recovery process, an analysis operation and a conditional redo operation are performed based on the database log, and a conditional redo operation and an undo operation are performed based on the files in the file system folder. An undo operation is then performed based on the database log.
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:
An automatic database backup and restoration system comprises an interface component that receives statements relating to backing up at least a portion of a first database, the original database resident upon a consumer computing device. A backup component associated with the interface component automatically copies at least the portion of the first database and writes the copied portion to a backup database, the backup database is a full backup of the first database. The consumer computing device can be, for example, one of a laptop computer, a desktop computer, a personal digital assistant, and a cellular phone.
Abstract:
A type of an object that can be persisted in a database store is defined by a user. The type definition comprises fields and behaviors, each field having a respective data type. One or more fields of the type definition may be designated as containing data of a type that is to be stored as a file outside of the database store and separately from the other fields of the type definition. When a request is received to store an object that is an instance of the user defined type, the data in any so designated field of the object is stored in a file outside of the database store, preferably within a file system of the computer on which the database store is implemented. The data in each of the other fields of the object is stored within the database store in the usual manner. The database store maintains a link, or reference, between the persisted object and the data of the field that is stored as a file outside of the database store. Applications are provided “out of band” access, via the file system of the computer, to the file in which the data of given field is stored outside the database store.
Abstract:
In a database system that supports user-defined types, one or more fields of a user-defined type may be designated as containing data that is to be stored as a file outside of a database store, separate from the other fields of the type which are stored within the database. Instead of being stored within the database, the data in such a designated field of an instance of the user-defined type is stored as a file within the file system of a computer. Applications are provided “out of band” access, via the file system of the computer, to the file in which the data of such a field is stored outside the database store. A component of the system intercepts file system open requests and checks security against the database store before allowing the open request to proceed. The component also notifies the database when file system close requests are received.