Path expression in structured query language

A technology of query language and grammar, applied in the field of formulas, can solve problems such as waste of system resources, difficulties for application developers to deal with interfaces, and multiple definitions of lengthy formulas

Inactive Publication Date: 2008-04-16
MICROSOFT CORP
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, multiple definitions need to be specified which can further lead to lengthy formulations, which can lead to awkward interfaces for application developers and waste of system resources

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Path expression in structured query language
  • Path expression in structured query language
  • Path expression in structured query language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] The invention is now described with reference to the drawings, wherein like reference numerals are used to refer to like elements throughout. In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It is, however, evident that the invention may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to facilitate describing the present invention.

[0027] As used in this application, the terms "component," "process," "model," "system," and the like refer to a computer-related entity that is either hardware, a combination of hardware and software, software, or an executing software. For example, a component may be, but is not limited to being limited to, a process running on a processor, a processor, an object, an executable, a thread of execution, a program, and / or a comput...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Systems and methods for extension of a query language for defining a simple formulation of joins by capturing the semantics of an existing linkage between a plurality of tables, via employing a reference join. Such reference join enables a compiler to exploit existing relationships in a data base, and employ existing knowledge about referential constraints for an unambiguous transformation of the reference join expression into the equivalent INNER JOIN on the columns involved. Accordingly, a simpler query syntax and semantics can be provided to express multi-table join navigation over primary key / foreign key relations, for example.

Description

technical field [0001] The present invention relates generally to query languages, and more particularly to the formulation of joins utilizing existing relationships in databases. Background of the invention [0002] Increasing advances in computer technology (eg, microprocessor speed, memory capacity, data transmission bandwidth, software functionality, etc.) have generally contributed to the adoption of computers in a variety of industries. More powerful server systems, often configured as server arrays, are typically provided to serve requests originating from external sources such as the World Wide Web. [0003] As the amount of electronic data available grows, it becomes increasingly important to store this data in a manageable manner that facilitates user-friendly and fast data search and retrieval. A database management system (DBMS) typically manages data in any form, including text, images, sound, and video. A common approach today is to store electronic data in o...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/30466G06F16/24544
Inventor B·拉塔克瑞施纳C·坎宁安E·扎伯克利特斯基J·A·布莱克利
Owner MICROSOFT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap