摘要:
To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.
摘要:
Optimization is provided for database statements involving XML data, e.g., XPath and XQuery, which operate over views that use aggregate set operators, e.g., UNION ALL. As part of a “view merge” stage of query transformation, the query that operates over the view is merged with a query that defines the view. One or more expressions (e.g., operators, predicates, virtual table constructs) from the query that operates over the view are then “pushed down” to operate on the individual underlying XML data constructs. “Branch elimination” is performed based on the structure of the view and the query acting over the view, based on which it is possible to determine whether any of the sub-queries, if executed, would result in the return of zero rows. If so, then such branches are eliminated from the transformed query, leaving a reduced set of data containers on which to execute the query.
摘要:
To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.
摘要:
Optimization is provided for database statements involving XML data, e.g., XPath and XQuery, which operate over views that use aggregate set operators, e.g., UNION ALL. As part of a “view merge” stage of query transformation, the query that operates over the view is merged with a query that defines the view. One or more expressions (e.g., operators, predicates, virtual table constructs) from the query that operates over the view are then “pushed down” to operate on the individual underlying XML data constructs. “Branch elimination” is performed based on the structure of the view and the query acting over the view, based on which it is possible to determine whether any of the sub-queries, if executed, would result in the return of zero rows. If so, then such branches are eliminated from the transformed query, leaving a reduced set of data containers on which to execute the query.
摘要:
Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.
摘要:
Techniques are provided for processing a query including receiving the query, where the query specifies certain operations; determining that the query includes a first portion in a first query language and a second portion in a second query language; generating a first in-memory representation for the first portion; generating a second in-memory representation for the second portion; generating a third in-memory representation of the query based on the first in-memory representation and the second in-memory representation; and performing the certain operations based on the third in-memory representation.
摘要:
A methodology is provided for making UV-curable, wear resistant and antistatic coating filled with carbon nanotubes (CNTs). The composition consists of a mixture of CNTs, an acrylate-based monomer, a urethane-acrylate oligomer and a photoinitiator. The present invention provides a coating of which the wear resistance and antistatic properties are dramatically improved in comparison with the polymer substrate. This coating is suitable for protecting a variety of polymer substrates from scratch and electrostatic accumulation.
摘要:
FIG. 1 is a front perspective view of a shower valve set showing my new design; FIG. 2 is a front view thereof; FIG. 3 is a rear view thereof; FIG. 4 is a left view thereof; FIG. 5 is a right view thereof; FIG. 6 is a top view thereof; FIG. 7 is a bottom view thereof; FIG. 8 is an enlarged view of the detail in FIG. 1; and, FIG. 9 is another enlarged view of the detail in FIG. 1. The broken lines shown in the figures are for the purpose of illustrating portions of the shower valve set that forms no part of the claimed design. The broken lines showing the enlargements in FIGS. 1,8 and 9 form no part of the claimed design.
摘要:
The invention relates to a method for determining the amount of oat flour addition in compound flours and noodles, and it belongs to the field of food detection technology. Based on the similarity of the fatty acid composition between oat and wheat, the quantitative analysis index used for measuring the oat flour addition was determined. Based on the differences of fatty acid contents in oat and wheat, the relationship between the changing trend of fatty acid composition and oat flour content in compound powders or noodles is employed to quantitatively determine the amount of oat added to these compound flours or noodles. The invention provides a highly sensitive and feasible method for safety monitoring and quality control of oat flours and oat noodles.
摘要:
A method of making diamond including mixing graphene with diamond seed to form a powder mixture, and then sintering the powder mixture, in the absence of a transition metal catalyst, at high pressure and high temperature; and a method of making a polycrystalline diamond compact including mixing graphene in diamond powder to form a powder mixture with less than about 50% graphene by weight, and then sintering the powder mixture, in the absence of a transition metal catalyst, at high pressure and high temperature.