System of seamless integrated pure XML query engine in relational database
A seamless integration, query engine technology, applied in electrical digital data processing, special data processing applications, instruments, etc.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0127] Example 1: Create a user table with XML type fields
[0128] Create the user table BookStore, the BooksSold field in this table is of XML type, used to store the XML document for saving book information. The SQL statement for creating a table is as follows:
[0129] create table BookStore
[0130] {
[0131] BookStoreID int,
[0132] BookStoreName nvarchar(50),
[0133] BooksSold xml
[0134]}
[0135] When creating the BookStore table, create a relational table that stores the BooksSold field, assuming that the relationID of the relational table is 17003. The user table after extending the XML data type is attached to the manual figure 2 shown.
[0136] Insert a record into this table:
[0137] insert into BookStore value(210310001, 'XinHuaBookStore',
[0138] '
[0139]
[0140] Everyday Italian
[0141] Giada De Laurentiis
[0142] 2005
[0143] 30.00
[0144]
[0145]
[0146] Harry Potter
[0...
Embodiment 2
[0163] Example 2: Index Usage Method
[0164] For the manual attached image 3 For the XML document shown in , three indexes are applied respectively:
[0165] (1) Element index:
[0166] Input: name='book', type=1
[0167] Output: {1.1, 1.2, 1.3}
[0168] (2) Value index:
[0169] Input: name='en'
[0170] Output: {1.1.2.1, 1.2.2.1, 1.3.2.1}
[0171] (3) Path index:
[0172]Input: bib->book->author
[0173] Output: {1.1.3, 1.2.3, 1.3.3, 1.3.4, 1.3.5, 1.3.6, 1.3.7}
Embodiment 3
[0174] Embodiment 3: XQuery expression syntax tree form and structure conversion
[0175] We give an XQuery expression of the form:
[0176] for $book in / / book
[0177] let $title:=$book / title
[0178] where position()=2
[0179] return $title
[0180] After the user inputs the above-mentioned XQuery expression, the parser will call the lex&&yacc tool interface, and analyze the user input sentence according to the XQuery grammar production formula formulated in the present invention to form a query syntax tree. The form of query syntax tree is as attached to the manual Figure 5 shown. The syntax tree formed at this time is as follows: Figure 6 The parallel structure shown, such a structure is not conducive to the further processing of the actuator. The present invention adjusts the above-mentioned parallel structure represented by a linked list, recursively hooks the inner loop to the outer Return clause, and finally obtains the Figure 7 The structure shown is...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com