CN1875358A - 用于在单个语句中更改集值和标量值列的sql语言扩展 - Google Patents
用于在单个语句中更改集值和标量值列的sql语言扩展 Download PDFInfo
- Publication number
- CN1875358A CN1875358A CNA2004800032581A CN200480003258A CN1875358A CN 1875358 A CN1875358 A CN 1875358A CN A2004800032581 A CNA2004800032581 A CN A2004800032581A CN 200480003258 A CN200480003258 A CN 200480003258A CN 1875358 A CN1875358 A CN 1875358A
- Authority
- CN
- China
- Prior art keywords
- value
- statement
- update
- change
- collection
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/235—Update request formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/289—Object oriented databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99934—Query formulation, input preparation, or translation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
Abstract
Description
Claims (22)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/693,302 US7433886B2 (en) | 2003-10-24 | 2003-10-24 | SQL language extensions for modifying collection-valued and scalar valued columns in a single statement |
US10/693,302 | 2003-10-24 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1875358A true CN1875358A (zh) | 2006-12-06 |
CN100474286C CN100474286C (zh) | 2009-04-01 |
Family
ID=34522359
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2004800032581A Expired - Fee Related CN100474286C (zh) | 2003-10-24 | 2004-07-29 | 用于在单个语句中更改集值和标量值列的sql语言扩展 |
Country Status (6)
Country | Link |
---|---|
US (1) | US7433886B2 (zh) |
EP (1) | EP1597655A4 (zh) |
JP (1) | JP4604041B2 (zh) |
KR (1) | KR101085686B1 (zh) |
CN (1) | CN100474286C (zh) |
WO (1) | WO2005045582A2 (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103177123A (zh) * | 2013-04-15 | 2013-06-26 | 昆明理工大学 | 一种提高数据库检索信息相关度的方法 |
Families Citing this family (38)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7890532B2 (en) * | 2004-12-15 | 2011-02-15 | Microsoft Corporation | Complex data access |
US7624374B2 (en) * | 2005-08-30 | 2009-11-24 | Microsoft Corporation | Readers and scanner design pattern |
US20070174305A1 (en) * | 2006-01-06 | 2007-07-26 | International Business Machines Corporation | Method to reduce the number of copies of values in procedural language |
US8656272B2 (en) * | 2006-04-28 | 2014-02-18 | Microsoft Corporation | Persisting instance-level report customizations |
US20080071730A1 (en) * | 2006-09-14 | 2008-03-20 | Roland Barcia | Method and Apparatus to Calculate Relational Database Derived Fields During Data Modification |
US8387004B2 (en) * | 2007-02-09 | 2013-02-26 | Microsoft Corporation | Compositional application programming interface and literal syntax |
US8595231B2 (en) * | 2007-04-26 | 2013-11-26 | International Business Machines Corporation | Ruleset generation for multiple entities with multiple data values per attribute |
US7676525B2 (en) * | 2007-07-02 | 2010-03-09 | Microsoft Corporation | Efficient query processing of merge statement |
US7974981B2 (en) | 2007-07-19 | 2011-07-05 | Microsoft Corporation | Multi-value property storage and query support |
US8200668B2 (en) * | 2008-06-24 | 2012-06-12 | Microsoft Corporation | Scalar representation for a logical group of columns in relational databases |
US10534606B2 (en) | 2011-12-08 | 2020-01-14 | Oracle International Corporation | Run-length encoding decompression |
US9697174B2 (en) | 2011-12-08 | 2017-07-04 | Oracle International Corporation | Efficient hardware instructions for processing bit vectors for single instruction multiple data processors |
US9792117B2 (en) | 2011-12-08 | 2017-10-17 | Oracle International Corporation | Loading values from a value vector into subregisters of a single instruction multiple data register |
US9600522B2 (en) * | 2012-08-20 | 2017-03-21 | Oracle International Corporation | Hardware implementation of the aggregation/group by operation: filter method |
US9563658B2 (en) | 2012-08-20 | 2017-02-07 | Oracle International Corporation | Hardware implementation of the aggregation/group by operation: hash-table method |
US9727606B2 (en) | 2012-08-20 | 2017-08-08 | Oracle International Corporation | Hardware implementation of the filter/project operations |
US9430550B2 (en) | 2012-09-28 | 2016-08-30 | Oracle International Corporation | Clustering a table in a relational database management system |
US9507825B2 (en) | 2012-09-28 | 2016-11-29 | Oracle International Corporation | Techniques for partition pruning based on aggregated zone map information |
US8996544B2 (en) | 2012-09-28 | 2015-03-31 | Oracle International Corporation | Pruning disk blocks of a clustered table in a relational database management system |
US10642837B2 (en) | 2013-03-15 | 2020-05-05 | Oracle International Corporation | Relocating derived cache during data rebalance to maintain application performance |
US11113054B2 (en) | 2013-09-10 | 2021-09-07 | Oracle International Corporation | Efficient hardware instructions for single instruction multiple data processors: fast fixed-length value compression |
US9378232B2 (en) | 2013-09-21 | 2016-06-28 | Oracle International Corporation | Framework for numa affinitized parallel query on in-memory objects within the RDBMS |
US10025823B2 (en) | 2015-05-29 | 2018-07-17 | Oracle International Corporation | Techniques for evaluating query predicates during in-memory table scans |
US10067954B2 (en) | 2015-07-22 | 2018-09-04 | Oracle International Corporation | Use of dynamic dictionary encoding with an associated hash table to support many-to-many joins and aggregations |
US10061714B2 (en) | 2016-03-18 | 2018-08-28 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multicore processors |
US10402425B2 (en) | 2016-03-18 | 2019-09-03 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multi-core processors |
US10055358B2 (en) | 2016-03-18 | 2018-08-21 | Oracle International Corporation | Run length encoding aware direct memory access filtering engine for scratchpad enabled multicore processors |
US10061832B2 (en) | 2016-11-28 | 2018-08-28 | Oracle International Corporation | Database tuple-encoding-aware data partitioning in a direct memory access engine |
US10599488B2 (en) | 2016-06-29 | 2020-03-24 | Oracle International Corporation | Multi-purpose events for notification and sequence control in multi-core processor systems |
US10380058B2 (en) | 2016-09-06 | 2019-08-13 | Oracle International Corporation | Processor core to coprocessor interface with FIFO semantics |
US10783102B2 (en) | 2016-10-11 | 2020-09-22 | Oracle International Corporation | Dynamically configurable high performance database-aware hash engine |
US10176114B2 (en) | 2016-11-28 | 2019-01-08 | Oracle International Corporation | Row identification number generation in database direct memory access engine |
US10459859B2 (en) | 2016-11-28 | 2019-10-29 | Oracle International Corporation | Multicast copy ring for database direct memory access filtering engine |
US10725947B2 (en) | 2016-11-29 | 2020-07-28 | Oracle International Corporation | Bit vector gather row count calculation and handling in direct memory access engine |
US10656964B2 (en) | 2017-05-16 | 2020-05-19 | Oracle International Corporation | Dynamic parallelization of a calculation process |
US10719372B2 (en) | 2017-05-22 | 2020-07-21 | Oracle International Corporation | Dynamic parallelization of data loading |
US11086876B2 (en) | 2017-09-29 | 2021-08-10 | Oracle International Corporation | Storing derived summaries on persistent memory of a storage device |
US11748352B2 (en) * | 2021-08-26 | 2023-09-05 | International Business Machines Corporation | Dynamical database system resource balance |
Family Cites Families (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5412804A (en) * | 1992-04-30 | 1995-05-02 | Oracle Corporation | Extending the semantics of the outer join operator for un-nesting queries to a data base |
US6016497A (en) * | 1997-12-24 | 2000-01-18 | Microsoft Corporation | Methods and system for storing and accessing embedded information in object-relational databases |
US6460043B1 (en) * | 1998-02-04 | 2002-10-01 | Microsoft Corporation | Method and apparatus for operating on data with a conceptual data manipulation language |
US6122644A (en) * | 1998-07-01 | 2000-09-19 | Microsoft Corporation | System for halloween protection in a database system |
JP4346158B2 (ja) * | 1999-06-28 | 2009-10-21 | 株式会社東芝 | データ生成装置及びプログラムを記憶したコンピュータ読み取り可能な記憶媒体 |
US6484179B1 (en) * | 1999-10-25 | 2002-11-19 | Oracle Corporation | Storing multidimensional data in a relational database management system |
US6564203B1 (en) * | 2000-02-24 | 2003-05-13 | Oracle Corporation | Defining instead-of triggers over nested collection columns of views |
US6493708B1 (en) * | 2000-03-02 | 2002-12-10 | Oracle Corporation | Techniques for handling function-defined hierarchical dimensions |
EP1364313A2 (en) * | 2000-10-31 | 2003-11-26 | Michael Philip Kaufman | System and method for automatically generating user interfaces for arbitrarily complex or large databases |
US6892204B2 (en) * | 2001-04-16 | 2005-05-10 | Science Applications International Corporation | Spatially integrated relational database model with dynamic segmentation (SIR-DBMS) |
-
2003
- 2003-10-24 US US10/693,302 patent/US7433886B2/en not_active Expired - Fee Related
-
2004
- 2004-07-29 WO PCT/US2004/024522 patent/WO2005045582A2/en active Application Filing
- 2004-07-29 CN CNB2004800032581A patent/CN100474286C/zh not_active Expired - Fee Related
- 2004-07-29 JP JP2006536590A patent/JP4604041B2/ja not_active Expired - Fee Related
- 2004-07-29 EP EP04779537A patent/EP1597655A4/en not_active Withdrawn
- 2004-07-29 KR KR1020057012345A patent/KR101085686B1/ko active IP Right Grant
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103177123A (zh) * | 2013-04-15 | 2013-06-26 | 昆明理工大学 | 一种提高数据库检索信息相关度的方法 |
CN103177123B (zh) * | 2013-04-15 | 2016-05-11 | 昆明理工大学 | 一种提高数据库检索信息相关度的方法 |
Also Published As
Publication number | Publication date |
---|---|
KR20060112191A (ko) | 2006-10-31 |
JP4604041B2 (ja) | 2010-12-22 |
JP2007509422A (ja) | 2007-04-12 |
CN100474286C (zh) | 2009-04-01 |
WO2005045582A2 (en) | 2005-05-19 |
EP1597655A4 (en) | 2008-12-10 |
KR101085686B1 (ko) | 2011-11-22 |
US20050091256A1 (en) | 2005-04-28 |
WO2005045582A3 (en) | 2005-12-29 |
EP1597655A2 (en) | 2005-11-23 |
US7433886B2 (en) | 2008-10-07 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN1875358A (zh) | 用于在单个语句中更改集值和标量值列的sql语言扩展 | |
CN1299223C (zh) | 提供关系数据的一致性层次抽象化 | |
CN1199104C (zh) | 往返式软件设计的方法与装置 | |
CN1277231C (zh) | 从远程数据源加载数据 | |
US7139750B2 (en) | System and method for where-used searches for data stored in a multi-level hierarchical structure | |
CN1864159A (zh) | 通过查询结果扩充和结果数据反馈的迭代数据分析过程 | |
CN1653448A (zh) | 搜索数据源的系统和方法 | |
CN1705945A (zh) | 全局查询相关属性 | |
CN1361890A (zh) | 观察改变索引对查询优化方案的影响的数据库系统 | |
CN1877523A (zh) | 一种支持异构构件的构件库统一管理方法 | |
CN1684069A (zh) | 计算机化财务系统的提取、变换和加载设计器模块 | |
CN1761962A (zh) | 将非结构化数据实时聚集为结构化数据以便关系数据库引擎进行sql处理 | |
CN1967560A (zh) | 业务操作权限控制方法、关系数据库的生成方法 | |
WO1999014651B1 (en) | Method and system for database application software creation requiring minimal programming | |
CN1768325A (zh) | 公开内容的抽象数据库抽象中的规则应用管理 | |
CN1509433A (zh) | 把传统软件应用程序转换为现代面向对象系统的方法和系统 | |
CN100342377C (zh) | 一种提高数据处理效率的方法 | |
CN1271441A (zh) | 一种关于数据库的方法 | |
CN1661593A (zh) | 一种计算机语言翻译方法及其翻译系统 | |
CN1251088C (zh) | 目标集成管理系统 | |
CN102819585A (zh) | 一种xml数据库文档控制方法 | |
US7509332B1 (en) | Customized indexes for user defined data types | |
CN1766876A (zh) | 用于管理结构化文件的系统和方法 | |
CN1592908A (zh) | 具有异种对象类型的数据库系统 | |
CN1825306A (zh) | 基于关系数据库的xml数据存储与访问方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150424 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20150424 Address after: Washington State Patentee after: Micro soft technique license Co., Ltd Address before: Washington State Patentee before: Microsoft Corp. |
|
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090401 Termination date: 20200729 |
|
CF01 | Termination of patent right due to non-payment of annual fee |