CN100474286C - 用于在单个语句中更改集值和标量值列的sql语言扩展 - Google Patents
用于在单个语句中更改集值和标量值列的sql语言扩展 Download PDFInfo
- Publication number
- CN100474286C CN100474286C CNB2004800032581A CN200480003258A CN100474286C CN 100474286 C CN100474286 C CN 100474286C CN B2004800032581 A CNB2004800032581 A CN B2004800032581A CN 200480003258 A CN200480003258 A CN 200480003258A CN 100474286 C CN100474286 C CN 100474286C
- Authority
- CN
- China
- Prior art keywords
- value
- statement
- update
- change
- labyrinth type
- 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.)
- Expired - Fee Related
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Computer Hardware Design (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (22)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/693,302 | 2003-10-24 | ||
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 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1875358A CN1875358A (zh) | 2006-12-06 |
CN100474286C true 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) |
Families Citing this family (40)
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 |
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 |
US9697174B2 (en) | 2011-12-08 | 2017-07-04 | Oracle International Corporation | Efficient hardware instructions for processing bit vectors for single instruction multiple data processors |
US10534606B2 (en) | 2011-12-08 | 2020-01-14 | Oracle International Corporation | Run-length encoding decompression |
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 |
US9600522B2 (en) * | 2012-08-20 | 2017-03-21 | Oracle International Corporation | Hardware implementation of the aggregation/group by operation: filter method |
US9514187B2 (en) | 2012-09-28 | 2016-12-06 | Oracle International Corporation | Techniques for using zone map information for post index access pruning |
US9430550B2 (en) | 2012-09-28 | 2016-08-30 | Oracle International Corporation | Clustering a table in a relational database management system |
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 |
CN103177123B (zh) * | 2013-04-15 | 2016-05-11 | 昆明理工大学 | 一种提高数据库检索信息相关度的方法 |
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 |
US10402425B2 (en) | 2016-03-18 | 2019-09-03 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multi-core processors |
US10061714B2 (en) | 2016-03-18 | 2018-08-28 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multicore 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 |
US10459859B2 (en) | 2016-11-28 | 2019-10-29 | Oracle International Corporation | Multicast copy ring for database direct memory access filtering engine |
US10176114B2 (en) | 2016-11-28 | 2019-01-08 | Oracle International Corporation | Row identification number generation in database direct memory access 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 |
CN109725898B (zh) * | 2018-11-30 | 2024-05-28 | 平安科技(深圳)有限公司 | 凭证规则的配置方法、装置、计算机设备及存储介质 |
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 |
WO2002059793A2 (en) * | 2000-10-31 | 2002-08-01 | Michael Philip Kaufman | System and method for generating automatic user interface 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 EP EP04779537A patent/EP1597655A4/en not_active Withdrawn
- 2004-07-29 KR KR1020057012345A patent/KR101085686B1/ko active IP Right Grant
- 2004-07-29 JP JP2006536590A patent/JP4604041B2/ja not_active Expired - Fee Related
Also Published As
Publication number | Publication date |
---|---|
JP2007509422A (ja) | 2007-04-12 |
WO2005045582A3 (en) | 2005-12-29 |
KR20060112191A (ko) | 2006-10-31 |
US7433886B2 (en) | 2008-10-07 |
EP1597655A2 (en) | 2005-11-23 |
JP4604041B2 (ja) | 2010-12-22 |
CN1875358A (zh) | 2006-12-06 |
KR101085686B1 (ko) | 2011-11-22 |
WO2005045582A2 (en) | 2005-05-19 |
US20050091256A1 (en) | 2005-04-28 |
EP1597655A4 (en) | 2008-12-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN100474286C (zh) | 用于在单个语句中更改集值和标量值列的sql语言扩展 | |
US7139774B2 (en) | Singleton abstract model correspondence to multiple physical models | |
US6611843B1 (en) | Specification of sub-elements and attributes in an XML sub-tree and method for extracting data values therefrom | |
CN100481076C (zh) | 关系型数据库与全文检索相结合的检索方法 | |
US20030195889A1 (en) | Unified relational database model for data mining | |
CN101427249B (zh) | 具有对丰富数据类型的支持的可扩展查询语言 | |
CN100458793C (zh) | 数据访问层Xml格式数据与关系数据间的映射转换方法 | |
US7512633B2 (en) | Conversion of hierarchically-structured HL7 specifications to relational databases | |
CN1749999B (zh) | .net数据类型和实例的持久存储 | |
CN100545837C (zh) | 用于数据库结构比较的方法和装置 | |
EP1918827A1 (en) | Data processing | |
US9218409B2 (en) | Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers | |
US20010018690A1 (en) | Integrating both modifications to an object model and modifications to a databse into source code by an object-relational mapping tool | |
CN101673287A (zh) | 一种sql语句生成方法及系统 | |
US6915303B2 (en) | Code generator system for digital libraries | |
US20100131570A1 (en) | Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an exisitng taxonomy | |
Marcos et al. | Extending UML for object-relational database design | |
US20040044989A1 (en) | Apparatus and method using pre-described patterns and reflection to generate source code | |
CN102819585A (zh) | 一种xml数据库文档控制方法 | |
CN100517229C (zh) | 数据版本升级方法 | |
Čerāns et al. | Rdb2owl: A RDB-to-RDF/OWL mapping specification language | |
US7509332B1 (en) | Customized indexes for user defined data types | |
US7761461B2 (en) | Method and system for relationship building from XML | |
Chen et al. | Constructing and maintaining scientific database views in the framework of the object-protocol model | |
US20030191727A1 (en) | Managing multiple data mining scoring results |
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 |