International Business Machines Corporation

Kwai Hing Man

Li Fu Chen

Yu Cheng Chen

Mengchu Cai

Yonghua Ding

Eric N Katayama

Rong-Hoang Chang

Wai Kei So

Shuo Li

Xin Peng Liu

Xiaobo Wang

ShengYan Sun

Gerald Edward Kozina

Shirley S Wang

Embodiments of the disclosure provide methods, systems, computer program products for manipulating a table with an XML column in database. According to the method, a SQL statement for a table is received first, wherein the table comprises an XML column which is a representation of a plurality of logical columns of the table, there is at least one XML element in at least one row and in the XML column of the table, and each of the at least one XML element corresponds to a non-null value in a specific row and in a logical column of the plurality of logical columns of the table. Then the SQL statement is parsed. And then the SQL statement is transformed into a hybrid statement being able to process the XML column in response to the parsing result indicating that the SQL statement relates to at least one logical column of the plurality of logical columns. At last the hybrid statement is executed.

Manipulating a table with an XML column in a database

A method is provided to generate a correct XML (eXtensible Markup Language) representation of source data from a relational database without knowing the format of source data. A XML parsing function is used to create the final XML data if the source data contains entity references. Where the source data does not contain entity reference, a XML publishing function is called to generate the final correct XML data.

Creating XML data from a database

Optimizing update instructions in hierarchically structured documents is provided. A pending update list including a first plurality of items is received. Each item of the first plurality of items describes an update to a hierarchically structured document. Each of one or more items of the first plurality of items is added to a subsumed update list having a second plurality of items. The subsumed update list is ordered based, at least in part, on a document order and on a target node of each of the second plurality of items. Subsume logic is applied to each of the one or more items based, at least in part, on the second plurality of items. Responsive to determining that subsume logic has been applied to each item of the first plurality of items, each of the second plurality of items of the subsumed update list is executed.

Optimizing update operations in hierarchically structured documents

A method and system for granular access control. An access control system allows a user or administrator to restrict access to electronic documents on a granular basis. Access may be restricted for individual data objects, types of objects, or even on a byte-by-byte basis. When a user attempts to access the electronic document, the access control system determines what parts, if any, of the document the user is permitted to access, and retrieves only those parts for access by the user. Data objects may include, for example, audio, video, graphics, or text.

System and methods for granular access control

An item migration system generates a workflow process comprising logical nodes and physical nodes. Candidate physical nodes are associated with the logical nodes. An item generated at an initial logical node within the workflow process is inserted into the workflow and logically migrated to a subsequent logical node. The system determines whether the item requires physical migration based on properties of the item, characteristics of the subsequent logical node, characteristics of candidate physical nodes, and weighting factors applied to the properties and characteristics. If the item requires physical migration, the system selects an optimum target physical node from the candidate physical nodes. The present system migrates the item to the physical location corresponding to the selected physical node. Otherwise, the present system performs logical migration to the logical node without physical migration.

System, method, and service for migrating an item within a workflow process

A migration object selection method selects data objects for migration from a source storage device to a target storage device. At a scheduled migration date, the method computes a benefit of migration for a selected data object based on adjustable weighted migration properties. If the benefit exceeds a predetermined threshold, the selected data object is migrated. Otherwise, the selected data object is not migrated. The weighted migration properties comprise last reference date, data object size, version, format, access speed of the source storage device, access speed of the target storage device, speed of a network, and location of the source storage device. The weighted migration properties are weighted with an adjustable weighting factor that indicates a relative importance of each of the weighted migration properties.

Method for migrating objects in content management systems through exploitation of file properties, temporal locality, and spatial locality

A resource manager () of a content management system () is configured to receive a client request () pertaining to information and to access at least one of a plurality of data servers () to execute the client request (). An encryption engine () encrypts passwords associated with the plurality of data servers () using a key-based encryption algorithm and stores a ciphertext corresponding to each password in a passwords storage (). A server identifier module () identifies a ciphertext in the passwords storage () that is associated with the at least one of a plurality of data servers (). A decryption engine () decrypts the ciphertext using a key-based decryption algorithm corresponding to the key-based encryption algorithm.

Growing community of inventors

Fremont, CA, United States of America

Kwai Hing Man