Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for providing a dynamic access control list for an object in a computer- implemented content management system. A list of one or more subjects is received. Each of the subjects is associated with a set of operations that the subject has permission to perform on the object in accordance with a first rule-set. A set of dynamic evolution conditions is defined. The dynamic evolution conditions specify under what circumstances to evolve the access control list to a new state in which a second rule-set describes a different set of operations to be associated with one or more of the subjects. The dynamic evolution conditions, the subjects, and the operations are stored in a dynamic access control list on a server in the content management system. A content management system is also described.

Abstract: 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.

Abstract: 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.

Abstract: Methods and apparatus, including computer program products, implementing and using techniques for providing an access control list for an object in a computer system. A list of one or more subjects is defined. Each of the subjects is associated with a set of operations that the subject can perform on the object. A set of rules is defined that specify conditions at which a different set of operations is to be associated with one or more of the subjects in the list of subjects. An access control list is also described.

Abstract: 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.

Abstract: A method and program product for storing large objects (LOBs) in a database is disclosed in one embodiment of the invention as including creating a column in a database. The column is created by assigning a data type to the column suitable for storing LOBs, assigning a maximum length for each LOB in the column, and assigning a length of an initial portion of each LOB. Once the column is created, one or more LOBs may be stored in the column. These LOBs are stored by storing the initial portions of each LOB substantially contiguously on certain pages of the database, while storing the remaining portions of each LOB on separate pages of the database. A pointer is provided with each initial portion. The pointer stores the location of the remaining portion of each LOB.

Abstract: A resource manager (14, 16) of a content management system (10) is configured to receive a client request (34, 36) pertaining to information and to access at least one of a plurality of data servers (20, 22, 24, 26) to execute the client request (34, 36). An encryption engine (80) encrypts passwords associated with the plurality of data servers (20, 22, 24, 26) using a key-based encryption algorithm and stores a ciphertext corresponding to each password in a passwords storage (40). A server identifier module (70, 72) identifies a ciphertext in the passwords storage (40) that is associated with the at least one of a plurality of data servers (20, 22, 24, 26). A decryption engine (100) decrypts the ciphertext using a key-based decryption algorithm corresponding to the key-based encryption algorithm.