International Business Machines Corporation

Joshua Wai-Ho Hui

Hui-I Hsiao

Ning Li

Kevin Scott Beyer

Inderpal Singh Narang

Peter Martin Schwarz

Lin Xu

Robert D Goldring

San-Ju Lin Shi

Parag V Tijare

Madhumati Krishnan

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.

System and method for updating external file referenced by database with transactional consistency using SQL

Described herein are methods, systems, apparatuses and products for transforming hierarchical language data into relational form. An aspect provides for assembling at least one statistical summary of at least one hierarchical language data source responsive to execution of program instructions accessible to at least one processor operatively connected to a memory device; accessing at least one entity of interest selected from the at least one statistical summary; generating at least one target hierarchical language model based on the at least one entity of interest; and transforming data from the at least one hierarchical language data source into at least one relational form by executing transformation artifacts generated based on a type of the relational form. Other aspects are disclosed herein.

Transforming hierarchical language data into relational form

A dynamic foldering system automatically manages the creation and deletion of run-time dynamic folders and selection of documents, items, or object graphs found in the run-time dynamic folders. The system comprises a query/predicate for a design-time folder group based on which dynamic folders are automatically managed, a variable binding mechanism, automatic identifications of dynamic folders containing a particular object, parallel navigation, and customized combination of foldering results. The dynamic folder hierarchy is defined by a hierarchy of design-time folder groups defined by a query/predicate on a document comprising structured or semi-structured data. Modifiable criteria for creating the dynamic folder hierarchy are provided by the user. Variable binding provides powerful query/predicate definitions on hierarchical data or graph-structured data. Given a document, the system automatically identifies which dynamic folders contain the document.

System and method for creating dynamic folder hierarchies

A system and method for data model and content migration in content management applications is disclosed that facilitates data migration by utilizing a markup-language format to preserve dependency and enable compatibility among various platforms, applications, devices, etc. The method generally includes retrieving a plurality of objects, determining a dependency of the plurality of objects, extracting object definitions from the objects, forming a markup-language user document with the extracted object definitions utilizing the determined object dependency, and exporting the markup-language user document.

System and method for data model and content migration in content management applications

A system and method are provided for XML query cursor implementation through the steps of query translation and processing, query result navigation, and positioned update. An XML query cursor implemented in Interface Definition Language (IDL) as well as an extension to XQuery, an XML query language, is described. These steps are addressed by one of three approaches: multi-cursor, outer union, or hybrid. In each approach, XML data is assumed to be stored in a relational database with a mapping that maps each element to a row in a relational database table. In each approach, a system and method provide for cursor movements and positioned updates in increments of a node, sub-tree, or entire document. Given a user's navigation patterns, a system and method is provided to select either a multi-cursor, outer union, or hybrid approach as an optimal implementation for an XML query cursor.

Providing XML cursor support on an XML repository built on top of a relational database system

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.

Growing community of inventors

San Jose, CA, United States of America

Joshua Wai-Ho Hui