WO2001095154A3 - Object-relational mapping for tables without primary keys - Google Patents
Object-relational mapping for tables without primary keys Download PDFInfo
- Publication number
- WO2001095154A3 WO2001095154A3 PCT/US2001/017498 US0117498W WO0195154A3 WO 2001095154 A3 WO2001095154 A3 WO 2001095154A3 US 0117498 W US0117498 W US 0117498W WO 0195154 A3 WO0195154 A3 WO 0195154A3
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- primary keys
- tables
- relational
- relational mapping
- relational database
- Prior art date
Links
Classifications
-
- 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/284—Relational 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/953—Organization of data
- Y10S707/96—Object-relational
-
- 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)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Methods and systems consistent with the present invention provide an improved object-relational mapping tool used to maintain information in relational database tables that do not utilize primary keys. The improved object-relational mapping tool uses a cursor update operation associated with relational database tables to maintain information contained in a relational database table without primary keys, including performing operations such as, delete or update on the table.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/585,602 | 2000-06-02 | ||
US09/585,602 US6591275B1 (en) | 2000-06-02 | 2000-06-02 | Object-relational mapping for tables without primary keys |
Publications (3)
Publication Number | Publication Date |
---|---|
WO2001095154A2 WO2001095154A2 (en) | 2001-12-13 |
WO2001095154A3 true WO2001095154A3 (en) | 2003-05-30 |
WO2001095154A8 WO2001095154A8 (en) | 2004-04-08 |
Family
ID=24342150
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2001/017498 WO2001095154A2 (en) | 2000-06-02 | 2001-05-31 | Object-relational mapping for tables without primary keys |
Country Status (2)
Country | Link |
---|---|
US (1) | US6591275B1 (en) |
WO (1) | WO2001095154A2 (en) |
Families Citing this family (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6694490B2 (en) * | 2002-07-10 | 2004-02-17 | Hewlett-Packard Development Company, L.P. | DIMM and method for producing a DIMM |
US20030233632A1 (en) * | 2002-06-12 | 2003-12-18 | Lockheed Martin Corporation | Automatically generated client application source code using database table definitions |
US20060195460A1 (en) * | 2005-02-28 | 2006-08-31 | Microsoft Corporation | Data model for object-relational data |
US7685561B2 (en) * | 2005-02-28 | 2010-03-23 | Microsoft Corporation | Storage API for a common data platform |
US7853961B2 (en) * | 2005-02-28 | 2010-12-14 | Microsoft Corporation | Platform for data services across disparate application frameworks |
US7676493B2 (en) * | 2005-09-07 | 2010-03-09 | Microsoft Corporation | Incremental approach to an object-relational solution |
US7526501B2 (en) * | 2006-05-09 | 2009-04-28 | Microsoft Corporation | State transition logic for a persistent object graph |
US20070266041A1 (en) * | 2006-05-11 | 2007-11-15 | Microsoft Corporation | Concept of relationshipsets in entity data model (edm) |
US8214797B2 (en) * | 2007-02-01 | 2012-07-03 | Microsoft Corporation | Visual association creation for object relational class development |
US20080189311A1 (en) * | 2007-02-01 | 2008-08-07 | Microsoft Corporation | Visual controls for stored procedure and object relational class development |
US8024701B2 (en) * | 2007-03-27 | 2011-09-20 | Microsoft Corporation | Visual creation of object/relational constructs |
US7788275B2 (en) * | 2007-09-18 | 2010-08-31 | Microsoft Corporation | Customization of relationship traversal |
CN101546259B (en) * | 2008-03-28 | 2012-10-03 | 国际商业机器公司 | Object-relation mapping system supporting model extension in runtime, and method thereof |
US9223814B2 (en) * | 2008-11-20 | 2015-12-29 | Microsoft Technology Licensing, Llc | Scalable selection management |
US9367582B2 (en) * | 2009-08-07 | 2016-06-14 | International Business Machines Corporation | Systems and methods involving information objects |
US9146969B2 (en) | 2012-11-26 | 2015-09-29 | The Boeing Company | System and method of reduction of irrelevant information during search |
KR101720602B1 (en) * | 2013-08-29 | 2017-03-29 | 후아웨이 테크놀러지 컴퍼니 리미티드 | Data storage method and apparatus |
US10592492B2 (en) | 2016-06-24 | 2020-03-17 | International Business Machines Corporation | Automatic updating of operational tables |
US10970316B1 (en) * | 2018-10-10 | 2021-04-06 | Bentley Systems, Incorporated | Maintaining a class hierarchy of an object-oriented data model using shared columns and/or overflow tables |
DE202022000476U1 (en) | 2022-02-22 | 2022-09-21 | Andreas Enrico Bansemer | Tools to explore the structure, composition and properties of objects in a database |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5596746A (en) * | 1991-10-21 | 1997-01-21 | General Electric Company | Method for transforming relational data base schemas into object models using ideal table meta models |
US5627979A (en) * | 1994-07-18 | 1997-05-06 | International Business Machines Corporation | System and method for providing a graphical user interface for mapping and accessing objects in data stores |
US5640555A (en) * | 1994-09-29 | 1997-06-17 | International Business Machines Corporation | Performance optimization in a heterogeneous, distributed database environment |
US5832498A (en) * | 1994-09-13 | 1998-11-03 | Bull, S.A. | Device for generating object-oriented interfaces for relational data bases and a process implemented by this device |
WO1999032997A1 (en) * | 1997-12-22 | 1999-07-01 | Tony Chun Tung Ng | Rule-based approach to object-relational mapping strategies |
Family Cites Families (46)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4589092A (en) | 1983-12-12 | 1986-05-13 | International Business Machines Corporation | Data buffer having separate lock bit storage array |
US4930071A (en) * | 1987-06-19 | 1990-05-29 | Intellicorp, Inc. | Method for integrating a knowledge-based system with an arbitrary database system |
US5043876A (en) | 1988-05-27 | 1991-08-27 | International Business Machines Corporation | N-level file shadowing and recovery in a shared file system |
US5261069A (en) | 1990-08-13 | 1993-11-09 | Hewlett-Packard Company | Method of maintaining consistency of cached data in a database system |
EP0472812B1 (en) | 1990-08-28 | 1998-05-06 | Landis & Gyr Technology Innovation AG | Method to change an object code version of a first program stored in the computer of an appliance into an object code version of a second program which was derived by at least one change to the first program |
US5291583A (en) | 1990-12-14 | 1994-03-01 | Racal-Datacom, Inc. | Automatic storage of persistent ASN.1 objects in a relational schema |
US5263155A (en) | 1991-02-21 | 1993-11-16 | Texas Instruments Incorporated | System for selectively registering and blocking requests initiated by optimistic and pessimistic transactions respectively for shared objects based upon associated locks |
US5301297A (en) | 1991-07-03 | 1994-04-05 | Ibm Corp. (International Business Machines Corp.) | Method and means for managing RAID 5 DASD arrays having RAID DASD arrays as logical devices thereof |
US5280612A (en) | 1991-11-26 | 1994-01-18 | International Business Machines Corporation | Multiple version database concurrency control system |
CA2080797C (en) | 1992-10-16 | 1999-02-02 | Kim D. Letkeman | Method of operating a computer program using data base schema and related language dictionaries |
US5504885A (en) * | 1993-06-29 | 1996-04-02 | Texas Instruments Incorporated | O-R gateway: a system for connecting object-oriented application programs and relational databases |
US5701453A (en) | 1993-07-01 | 1997-12-23 | Informix Software, Inc. | Logical schema to allow access to a relational database without using knowledge of the database structure |
WO1995003586A1 (en) | 1993-07-21 | 1995-02-02 | Persistence Software, Inc. | Method and apparatus for generation of code for mapping relational data to objects |
WO1995004960A2 (en) | 1993-08-02 | 1995-02-16 | Persistence Software, Inc. | Method and apparatus for managing relational data in an object cache |
US5548749A (en) | 1993-10-29 | 1996-08-20 | Wall Data Incorporated | Semantic orbject modeling system for creating relational database schemas |
US5774731A (en) | 1995-03-22 | 1998-06-30 | Hitachi, Ltd. | Exclusive control method with each node controlling issue of an exclusive use request to a shared resource, a computer system therefor and a computer system with a circuit for detecting writing of an event flag into a shared main storage |
US5542078A (en) | 1994-09-29 | 1996-07-30 | Ontos, Inc. | Object oriented data store integration environment for integration of object oriented databases and non-object oriented data facilities |
US5742813A (en) | 1994-11-10 | 1998-04-21 | Cadis, Inc. | Method and apparatus for concurrency in an object oriented database using lock inheritance based on class objects |
US5835910A (en) | 1994-11-10 | 1998-11-10 | Cadis, Inc. | Method and system for comparing attributes in an object-oriented management system |
US5583983A (en) | 1994-11-17 | 1996-12-10 | Objectware, Inc. | Multi-platform object-oriented software development and deployment system |
US5873093A (en) | 1994-12-07 | 1999-02-16 | Next Software, Inc. | Method and apparatus for mapping objects to a data source |
US5893108A (en) * | 1994-12-29 | 1999-04-06 | International Business Machines Corporation | System, method, and computer program product for efficiently translating relational tuples to object-oriented objects |
US5799309A (en) * | 1994-12-29 | 1998-08-25 | International Business Machines Corporation | Generating an optimized set of relational queries fetching data in an object-relational database |
US5574882A (en) | 1995-03-03 | 1996-11-12 | International Business Machines Corporation | System and method for identifying inconsistent parity in an array of storage |
US5829006A (en) | 1995-06-06 | 1998-10-27 | International Business Machines Corporation | System and method for efficient relational query generation and tuple-to-object translation in an object-relational gateway supporting class inheritance |
US5717924A (en) | 1995-07-07 | 1998-02-10 | Wall Data Incorporated | Method and apparatus for modifying existing relational database schemas to reflect changes made in a corresponding object model |
US5732257A (en) * | 1995-09-13 | 1998-03-24 | Hewlett-Packard Co. | Object conversion method from a flat object space to a class structured space |
US5878419A (en) * | 1996-01-19 | 1999-03-02 | Novell, Inc. | Method for creating a relational description of a formatted transaction |
US6049673A (en) | 1996-03-08 | 2000-04-11 | Organicnet, Inc. | Organicware applications for computer systems |
US5860070A (en) | 1996-05-31 | 1999-01-12 | Oracle Corporation | Method and apparatus of enforcing uniqueness of a key value for a row in a data table |
US5907846A (en) * | 1996-06-07 | 1999-05-25 | Electronic Data Systems Corporation | Method and system for accessing relational databases using objects |
US5835906A (en) | 1996-07-01 | 1998-11-10 | Sun Microsystems, Inc. | Methods and apparatus for sharing stored data objects in a computer system |
US5832484A (en) | 1996-07-02 | 1998-11-03 | Sybase, Inc. | Database system with methods for parallel lock management |
US5933824A (en) | 1996-12-23 | 1999-08-03 | Lsi Logic Corporation | Methods and apparatus for locking files within a clustered storage environment |
US5857197A (en) | 1997-03-20 | 1999-01-05 | Thought Inc. | System and method for accessing data stores as objects |
US6182274B1 (en) | 1997-05-01 | 2001-01-30 | International Business Machines Corporation | Reusing code in object-oriented program development |
US5937402A (en) | 1997-06-19 | 1999-08-10 | Ontos, Inc. | System for enabling access to a relational database from an object oriented program |
US5878411A (en) | 1997-06-27 | 1999-03-02 | International Business Machines Corporation | Dependent object class and subclass mapping to relational data store |
US5920725A (en) | 1997-07-02 | 1999-07-06 | Adaptivity Inc. | Run-time object-synthesis and transparent client/server updating of distributed objects using a meta server of all object descriptors |
US5937409A (en) * | 1997-07-25 | 1999-08-10 | Oracle Corporation | Integrating relational databases in an object oriented environment |
US6009428A (en) | 1997-09-15 | 1999-12-28 | International Business Machines Corporation | System and method for providing a single application program interface for heterogeneous databases |
US6175837B1 (en) | 1998-06-29 | 2001-01-16 | Sun Microsystems, Inc. | Object-relational mapping toll that processes views |
US6385618B1 (en) | 1997-12-22 | 2002-05-07 | Sun Microsystems, Inc. | Integrating both modifications to an object model and modifications to a database into source code by an object-relational mapping tool |
US6038565A (en) | 1998-01-16 | 2000-03-14 | International Business Machines Corporation | Object oriented data format mapping mechanism |
US6003040A (en) | 1998-01-23 | 1999-12-14 | Mital; Vijay | Apparatus and method for storing, navigating among and adding links between data items in computer databases |
US6163776A (en) * | 1998-03-23 | 2000-12-19 | Software Tree, Inc. | System and method for exchanging data and commands between an object oriented system and relational system |
-
2000
- 2000-06-02 US US09/585,602 patent/US6591275B1/en not_active Expired - Lifetime
-
2001
- 2001-05-31 WO PCT/US2001/017498 patent/WO2001095154A2/en active Application Filing
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5596746A (en) * | 1991-10-21 | 1997-01-21 | General Electric Company | Method for transforming relational data base schemas into object models using ideal table meta models |
US5627979A (en) * | 1994-07-18 | 1997-05-06 | International Business Machines Corporation | System and method for providing a graphical user interface for mapping and accessing objects in data stores |
US5832498A (en) * | 1994-09-13 | 1998-11-03 | Bull, S.A. | Device for generating object-oriented interfaces for relational data bases and a process implemented by this device |
US5640555A (en) * | 1994-09-29 | 1997-06-17 | International Business Machines Corporation | Performance optimization in a heterogeneous, distributed database environment |
WO1999032997A1 (en) * | 1997-12-22 | 1999-07-01 | Tony Chun Tung Ng | Rule-based approach to object-relational mapping strategies |
Non-Patent Citations (1)
Title |
---|
INFOTECHUNIV, MAPPING/DECODING RELATIONSHIPS, 1 January 2001 (2001-01-01), pages 1 - 4, XP002224626, Retrieved from the Internet <URL:www.itdart.com/tuorial1> [retrieved on 20030109] * |
Also Published As
Publication number | Publication date |
---|---|
US6591275B1 (en) | 2003-07-08 |
WO2001095154A8 (en) | 2004-04-08 |
WO2001095154A2 (en) | 2001-12-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2001095154A8 (en) | Object-relational mapping for tables without primary keys | |
EP1164510A3 (en) | Virtual join index for relational databases | |
WO2003081476A3 (en) | Method and data structure for a low memory overhead database | |
EP1164509A3 (en) | Aggregate join index for relational databases | |
WO2006009822A3 (en) | Integrated database indexing system | |
WO2002097676A3 (en) | Integrating tablespaces with different block sizes | |
WO2002061622A3 (en) | Technique for encapsulating a query definition | |
CA2329558A1 (en) | Methods and apparatus for similarity text search based on conceptual indexing | |
WO2003100666A3 (en) | High-performance change capture for data warehousing | |
SG142158A1 (en) | Index structure of metadata, method for providing indices of metadata, and metadata searching method and apparatus using the indices of metadata | |
EA200500009A1 (en) | METHOD FOR CODING KEYS IN THE DATABASE AND DATABASE | |
WO2003009178A3 (en) | Database systems, methods and computer program products including primary key and super key indexes for use with partitioned tables | |
CA2326135A1 (en) | System and method for rewriting relational database queries | |
AU2001257232A1 (en) | Generic attribute database system | |
TW200639674A (en) | Modified keyboard and systems containing the keyboard | |
EP1553511A4 (en) | Network service system and point commuting system | |
WO2004044708A3 (en) | Enhanced client relationship management systems and methods | |
ZA200003317B (en) | Method and apparatus for optimizing query generation by selectively utilising attributes or key values. | |
WO2005121944A3 (en) | Internet based resource retrieval system | |
CA2324741A1 (en) | Method for providing a system maintained materialized functionally dependent column for a database management system | |
WO2000043916A3 (en) | Database item versioning | |
WO2004061718A8 (en) | Systems and methods for associating system entities with descriptions | |
AU3028801A (en) | Data recovery in a distributed system | |
WO2005059674A3 (en) | System and method for functional elements | |
WO2002033587A3 (en) | Database linking method and apparatus |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): CN JP KR SG |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
122 | Ep: pct application non-entry in european phase | ||
WR | Later publication of a revised version of an international search report | ||
NENP | Non-entry into the national phase |
Ref country code: JP |