Unlock instant, AI-driven research and patent intelligence for your innovation.

Systems and methods for the implementation of unordered and ordered collections in a data store

A data storage and collection technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to process relational queryable objects

Active Publication Date: 2010-03-24
MICROSOFT TECH LICENSING LLC
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0032] Although collections are implemented in existing database products, these products typically model collections using value-based relationships such as the primary key-foreign key concept, and thus cannot be handled as relational queryable objects

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
  • Systems and methods for the implementation of unordered and ordered collections in a data store
  • Systems and methods for the implementation of unordered and ordered collections in a data store
  • Systems and methods for the implementation of unordered and ordered collections in a data store

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044]Details have been used to describe the inventive subject matter in order to meet the stated requirements. However, the description itself is not intended to limit the scope of the invention. Rather, the inventors contemplate that the claimed subject matter may also be implemented in other ways, to include different steps or elements similar to those disclosed in this document, in conjunction with other present or future technologies. Furthermore, although the term "step" is used herein to imply various aspects of the method employed, the term should not be construed to imply any particular order among or between the various steps disclosed herein unless explicitly described the order of the steps.

[0045] In the embodiments described below, the above features of the present invention are described as being implemented in the MICROSOFT SQLSERVER database system. as above. SQL SERVER combines the MICROSOFT.NET common language runtime (CLR) to enable writing and executi...

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

Several embodiments of the present invention are directed to systems and methods for extending the UDT framework of an extended relational data store (ERDS) to include support for unordered collections (multisets) and ordered collection (lists). More specifically, several embodiments of the present invention use an UDT infrastructure, CLR generics, and a new UNNEST operator to create and utilize aspecial type abstraction for collections that is simultaneously a scalar and a relation. As a scalar, this collection type can be processed by all parts of the data store engine that understand scalars (including but not limited to the client stack) and, as a relation, this collection type is queriable like any other type of relation.

Description

[0001] References to related applications [0002] This application claims U.S. Provisional Application No. 60 / 566,740, entitled "SYSTEMS AND METHODS FOR THE IMPLEMENTATION OF MULTISETS IN A DATABASE SYSTEM," filed April 30, 2004 (Designed Abstract MSFT-3940 / 307228.01), the contents of which are hereby incorporated by reference. Additionally, this application is also part of U.S. Patent Application Serial No. 10 / 837,929, entitled "SYSTEMS AND METHODS FOR SUPPORTING INHERITANCE FORUSER-DEFINED TYPES," filed May 3, 2004 (Designed Abstract No. MSFT-3843 / 307227.01), which is an application filed on February 10, 2004, entitled "SYSTEM AND METHOD FOR PROVIDING USER DEFINED TYPES IN A DATABASE SYSTEM" Continuation-in-part of U.S. Patent Application No. 10 / 775,282 (Delegated Abstract No. MSFT-3029 / 307007.01), the contents of which are hereby incorporated by reference. [0003] This application is related in subject matter to the invention disclosed in the following commonly-assigned a...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor B·拉塔克瑞施纳B·塞兹金D·Y·艾尔图多夫J·A·布莱克雷O·N·泽利格R·凡卡特实俞玮B·H·M·德内特C·J·库宁汉姆D·V·楚林S·斯特凡尼D·托米克
Owner MICROSOFT TECH LICENSING LLC