WO2000023917A9 - Accessing a hierarchical data store through an sql input - Google Patents
Accessing a hierarchical data store through an sql inputInfo
- Publication number
- WO2000023917A9 WO2000023917A9 PCT/US1999/023876 US9923876W WO0023917A9 WO 2000023917 A9 WO2000023917 A9 WO 2000023917A9 US 9923876 W US9923876 W US 9923876W WO 0023917 A9 WO0023917 A9 WO 0023917A9
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data store
- hierarchical data
- sql
- tables
- order
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/466—Transaction processing
-
- 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/99936—Pattern matching access
-
- 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/99943—Generating database or data structure, e.g. via user interface
-
- 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
-
- 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
- Y10S707/99945—Object-oriented database structure processing
Definitions
- the present invention relates to a database management system, and in particular to an Application Programming Interface (API) that allows application programs access to various database management systems.
- API Application Programming Interface
- Open DataBase Connectivity is an Application Programming Interface (API) that provides a common interface for accessing various structure query language (SQL) based database management systems.
- SQL structure query language
- Most vendors have added an ODBC interface to their relational databases.
- One major disadvantage of the conventional ODBC is that it was designed to access relational database management systems that use standard SQL language in their queries and its use outside the relational databases has met with significant problems because SQL assumes the relational nature of the database. Therefore it is desirable to provide a system and method for providing an ODBC interface or driver that allow access to non-relational data store such as a hierarchical object/property model.
- the present invention provides a driver that allows access of data stored in a hierarchical data store through an SQL input query. Based on the SQL input, the driver transforms a hierarchical data store into relational database tables. Preferably, the tables hold pointers that point to the actual data stored in the hierarchical data store. Then the SQL input is executed using the transformed tables.
- Figure 1 is a block diagram showing an ODBC driver interfaced between an ODBC driver and an ODBC driver.
- Figure 2 is a flow chart of the ODBC driver according to the present invention.
- Figure 3 illustrates a representation of a hierarchical data store and that of an equivalent relational database.
- An hierarchical data store is represented as a graph of objects and properties. Objects may be owned by and conceptually aggregated into other objects. Objects may hold references to other objects via reference properties. Properties are owned by and aggregated into objects.
- FIG. 3 includes a representation of such an hierarchical data store and that of an equivalent relational database.
- the hierarchical data store in FIG. 3 is a model of customers and their order information.
- the data store includes an object or a group of objects called "Customer” each having a unique internal identification number, "int id".
- the "Customer” object has three properties: one scalar property and two vector properties.
- the one scalar property is of type "Name” which can hold only one value by definition.
- the first vector property is of type "Phone_number” which may hold many values by definition.
- the second vector property is of type "Order ref ' which may also hold many values.
- Each value of "Order_ref ' is a pointer which references another object called "Order”.
- the "Order” object has a property of type "DateOrdered” which stores the date of a particular order that has been placed.
- the equivalent data store in a relational database can be represented as three separate tables as shown on the right side of FIG. 3.
- a "Customer” table has two columns named “Id” and "Name”
- an "Order” table has three columns named “Order_id”, “DateOrdered” and “Cust”
- a "Phone” table has three columns named “Cust”, "Seq” and "Phone number”.
- the three tables are linked to each other through "Id” of Customer, "Cust” of Phone and "Cust” of Order which have identical values.
- FIG. 1 is a block diagram showing an ODBC driver 6 interfaced between an ODBC driver 6 interfaced between an ODBC driver 6 interfaced between an ODBC driver 6 interfaced between an ODBC driver 6 interfaced between an ODBC driver 6 interfaced between an ODBC driver 6
- a conventional ODBC is designed to access relational databases using standard SQL language queries.
- the ODBC driver 6 of the present invention allows standard SQL language queries from an SQL report generator 2 to be used against a standard object/property model of information such as a hierarchical data store 4 according to the steps of FIG. 2.
- the driver 6 receives the SQL input from the generator 2.
- the driver 6 identifies object classes and their properties to be processed based on the received SQL input.
- the hierarchical data store 4 is transformed into relational database tables with various columns such that the hierarchical data store 4 appears to be a relational database to the SQL report generator 2.
- step 14 involves the following manipulations such that the hierarchically stored database is transformed into relational database tables:
- each class of object is transformed into a table.
- Each table of this type has two pseudocolumns: an "Id” that contains the unique identifier of the instance and is the primary key, and an "Owner” that contains a foreign key reference back to the owning object;
- each non-reference scalar property of an object becomes a column in the object's class table
- each non-reference vector property is transformed into a table.
- Each table of this type has two pseudocolumns: a "Sequence” column that contains a sequence value for each element of the vector and is part of the primary key for the table, and an "Owner” column that contains a foreign key back to the owning object and is part of the primary key; and
- each reference property both scalar and vector, may be used to calculate a foreign key relationship from the referenced object to the object owning the reference property.
- the necessary tables and columns are created/transformed, they preferably have pointers that point to the actual data residing in the hierarchical data store, and do not store the data themselves.
- the query contained in the SQL input is then executed in step 16 on the transformed tables.
- the result of the execution is then passed to the report generator 2 that transmitted the SQL input.
- FIG. 2 A more detailed explanation of the steps in FIG. 2 will be provided below with reference to a couple of example SQL inputs.
- the above SQL input means that the generator would like to receive DateOrdered for all orders that "Doe” has placed.
- the way the Customer and the Order tables are connected or joined is that the value in the "Cust" column of the Order table should match the value in the Id column of the Customer table.
- the "Id” is the primary key for the Customer table and "Cust” is a foreign key of the Order table.
- the hierarchical data store in FIG. 3 is not set up in a form that is readily usable by a conventional ODBC interface. This is one of the problems that is solved by the ODBC driver 6 according to the present invention.
- the ODBC driver 6 analyzes the received SQL input and identifies the object classes that need to be processed.
- the ODBC driver 6 then transforms each object class into a table.
- a database table is created for each identified object class because object classes map to tables.
- the columns for the tables are created partly by analyzing what columns are being referenced in the received SQL language and by analyzing the properties of the object classes since columns map to the properties.
- the internal identification number "int id" is mapped to a column of the corresponding table.
- the ODBC driver creates a "Customer” table with “Id” and “Name” columns, and an "Order” table with "Order d", “DateOrdered” and “Cust” columns as shown in FIG. 3.
- the "int_ id” and “Name” of the Customer object map to "Id” and “Name” columns of the "Customer” table, and the “int_ id” and “DateOrdered” of the Order object map to "Order_id", "DateOrdered” columns of the "Order” table.
- the only column that we need to synthesize is the "Cust" column of the Order table.
- the customer property in the hierarchical data store does not exist in the "Order" object.
- there's no property in the Order object pointing back to the "Cust" ("int id") of the Customer object.
- it's the inverse of the relational database because it's the Customer object that points to the Order object.
- the foreign key concept is similar to a reference property in the hierarchical data store such as the "Order ref ' property of the "Customer” object. Recognizing that the query requires a foreign key backwards, the "Order ref ' property of the "Customer” object is read, the inverse relationship is synthesized, and the "Cust” column is then synthesized or created using the "int_id" of the Customer object.
- the tables preferably store pointers that point to the actual data residing in the hierarchical data store, and do not store the data themselves.
- actual data may be stored in the tables.
- a different transform occurs because it references a vector property "phone number".
- each non-reference vector property is transformed into a table.
- the property itself maps to one column named "phone number”. Two more columns are synthesized.
- One column named "Cust” is the id ("int id") of the object ("Customer") that owned the "phone number” and a second column named “seq” is an arbitrary increasing number so that different phone numbers for the same object can be differentiated.
- the tables preferably store pointers that point to the actual data residing in the hierarchical data store.
- the SQL input is then executed using the transformed tables.
- the data matching the selection criteria of the SQL input are selected from the hierarchical data store pointed to by the pointers stored in the transformed tables and passed to the report generator 2. Again, actual data may be stored in the tables.
Abstract
Description
Claims
Priority Applications (10)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2000577590A JP2002528793A (en) | 1998-10-16 | 1999-10-15 | Access to hierarchical data store through SQL input |
KR1020017004595A KR20010093777A (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an sql input |
AU14452/00A AU775431B2 (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an SQL input |
EP99970761A EP1121655B1 (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an sql input |
DE69932344T DE69932344T2 (en) | 1998-10-16 | 1999-10-15 | ACCESS TO HIERARCHICAL DATA STORAGE VIA SQL ENTRY |
IL14248299A IL142482A0 (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an sql input |
CA002346928A CA2346928A1 (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an sql input |
BR9914427-1A BR9914427A (en) | 1998-10-16 | 1999-10-15 | Access to a hierarchical data store through an sql entry |
IL142482A IL142482A (en) | 1998-10-16 | 2001-04-05 | Accessing a hierarchical data store through an sql input |
HK02100660.7A HK1040440A1 (en) | 1998-10-16 | 2002-01-28 | Accessing a hierarchical data store through an sql input |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10468298P | 1998-10-16 | 1998-10-16 | |
US60/104,682 | 1998-10-16 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2000023917A1 WO2000023917A1 (en) | 2000-04-27 |
WO2000023917A9 true WO2000023917A9 (en) | 2000-11-02 |
Family
ID=22301805
Family Applications (5)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US1999/023876 WO2000023917A1 (en) | 1998-10-16 | 1999-10-15 | Accessing a hierarchical data store through an sql input |
PCT/US1999/024120 WO2000023863A2 (en) | 1998-10-16 | 1999-10-15 | Determining differences between two or more metadata models |
PCT/US1999/024117 WO2000023882A1 (en) | 1998-10-16 | 1999-10-15 | Impact analysis of a model |
PCT/US1999/024115 WO2000023919A1 (en) | 1998-10-16 | 1999-10-15 | Method and system for an extensible macro language |
PCT/US1999/024118 WO2000023883A1 (en) | 1998-10-16 | 1999-10-15 | Apparatus and method for building modeling tools |
Family Applications After (4)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US1999/024120 WO2000023863A2 (en) | 1998-10-16 | 1999-10-15 | Determining differences between two or more metadata models |
PCT/US1999/024117 WO2000023882A1 (en) | 1998-10-16 | 1999-10-15 | Impact analysis of a model |
PCT/US1999/024115 WO2000023919A1 (en) | 1998-10-16 | 1999-10-15 | Method and system for an extensible macro language |
PCT/US1999/024118 WO2000023883A1 (en) | 1998-10-16 | 1999-10-15 | Apparatus and method for building modeling tools |
Country Status (13)
Country | Link |
---|---|
US (3) | US7711685B1 (en) |
EP (5) | EP1121655B1 (en) |
JP (6) | JP2002528789A (en) |
KR (5) | KR20010103603A (en) |
CN (5) | CN1129859C (en) |
AT (1) | ATE333125T1 (en) |
AU (5) | AU775431B2 (en) |
BR (5) | BR9914553A (en) |
CA (5) | CA2346924A1 (en) |
DE (1) | DE69932344T2 (en) |
HK (4) | HK1040441A1 (en) |
IL (10) | IL142484A0 (en) |
WO (5) | WO2000023917A1 (en) |
Families Citing this family (53)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1121655B1 (en) * | 1998-10-16 | 2006-07-12 | Computer Associates Think, Inc. | Accessing a hierarchical data store through an sql input |
US7734457B2 (en) * | 1999-10-16 | 2010-06-08 | Computer Associates Think, Inc. | Method and system for generating dynamic comparison models |
US20050160401A1 (en) * | 1999-10-16 | 2005-07-21 | Computer Associates Think, Inc. | System and method for adding user-defined objects to a modeling tool |
US7194405B2 (en) * | 2000-04-12 | 2007-03-20 | Activepoint Ltd. | Method for presenting a natural language comparison of items |
US6480970B1 (en) * | 2000-05-17 | 2002-11-12 | Lsi Logic Corporation | Method of verifying data consistency between local and remote mirrored data storage systems |
US6853997B2 (en) * | 2000-06-29 | 2005-02-08 | Infoglide Corporation | System and method for sharing, mapping, transforming data between relational and hierarchical databases |
US7089256B2 (en) * | 2000-07-11 | 2006-08-08 | Knowledge Dynamics, Inc. | Universal data editor |
US7421587B2 (en) * | 2001-07-26 | 2008-09-02 | Mcafee, Inc. | Detecting computer programs within packed computer files |
US7069547B2 (en) | 2001-10-30 | 2006-06-27 | International Business Machines Corporation | Method, system, and program for utilizing impact analysis metadata of program statements in a development environment |
US7194475B2 (en) | 2001-10-30 | 2007-03-20 | International Business Machines Corporation | Method, system, and program for performing an impact analysis of program statements in at least one source code file |
US7069263B1 (en) * | 2002-02-19 | 2006-06-27 | Oracle International Corporation | Automatic trend analysis data capture |
CH703081B1 (en) * | 2003-03-19 | 2011-11-15 | Roland Pulfer | Analysis of a model of a complex system. |
CH698890B1 (en) * | 2003-03-19 | 2009-11-30 | Roland Pulfer | Modeling a complex system. |
CH703073B1 (en) * | 2003-03-19 | 2011-11-15 | Roland Pulfer | Comparing models a complex system. |
CA2429335A1 (en) * | 2003-05-22 | 2004-11-22 | Cognos Incorporated | System and method of determining impact of reports based on metadata model changes |
CN101416182B (en) * | 2003-10-22 | 2010-12-08 | 英特尔公司 | Expression grouping and evaluation |
KR100611098B1 (en) * | 2003-12-12 | 2006-08-09 | 한국전자통신연구원 | Satellite simulation modeling system using Interface Model |
US8793602B2 (en) | 2004-01-15 | 2014-07-29 | The Mathworks, Inc. | System and method for scheduling the execution of model components using model events |
US7484212B2 (en) * | 2004-02-27 | 2009-01-27 | International Business Machines Corporation | Methods and arrangements for automated change plan construction and impact analysis |
US7555531B2 (en) * | 2004-04-15 | 2009-06-30 | Microsoft Corporation | Efficient algorithm and protocol for remote differential compression |
US20060074980A1 (en) * | 2004-09-29 | 2006-04-06 | Sarkar Pte. Ltd. | System for semantically disambiguating text information |
GB2419700B (en) * | 2004-10-29 | 2010-03-31 | Hewlett Packard Development Co | Methods for indexing data, systems, software and apparatus relng thereto |
US20060168555A1 (en) * | 2005-01-21 | 2006-07-27 | Represas Ferrao Lucio E | Software development system and method |
EP1684170A3 (en) * | 2005-01-21 | 2007-01-24 | Outsystems, software em redes, S. A. | Software development system and method |
US7735062B2 (en) | 2005-01-21 | 2010-06-08 | Outsystems—Software Em Rede, S.A. | Software development system and method |
US20060168577A1 (en) * | 2005-01-21 | 2006-07-27 | Melo Antonio A V | Software development system and method |
JP4755427B2 (en) | 2005-02-23 | 2011-08-24 | インターナショナル・ビジネス・マシーンズ・コーポレーション | Database access system and database access method |
US20060259781A1 (en) * | 2005-04-29 | 2006-11-16 | Sony Corporation/Sony Electronics Inc. | Method and apparatus for detecting the falsification of metadata |
US20070006130A1 (en) * | 2005-06-02 | 2007-01-04 | Arnold Stamler | Model oriented method of automatically detecting alterations in the design of a software system |
CN100432999C (en) * | 2005-06-06 | 2008-11-12 | 上海宝信软件股份有限公司 | Method for data access for complete record by using list architecture under ORACLE |
US20070250927A1 (en) * | 2006-04-21 | 2007-10-25 | Wintutis, Inc. | Application protection |
US9626161B2 (en) * | 2006-12-12 | 2017-04-18 | Ca, Inc. | Computer readable medium and methods for filtering a dynamic comparison model |
US8156147B1 (en) | 2007-02-06 | 2012-04-10 | The Mathworks, Inc. | Sharing of instructions across model boundaries |
US8334995B2 (en) * | 2007-09-19 | 2012-12-18 | Sharp Laboratories Of America, Inc. | Method and system for adaptive control of imaging node |
US20090094616A1 (en) * | 2007-10-04 | 2009-04-09 | Delima Roberto | Comparing Middleware Configurations |
US20090138846A1 (en) * | 2007-11-23 | 2009-05-28 | Microsoft Corporation | Extended macro recording |
US7962457B2 (en) * | 2008-02-12 | 2011-06-14 | Computer Associates Think, Inc. | System and method for conflict resolution |
US8321407B2 (en) * | 2008-02-24 | 2012-11-27 | Panaya Ltd. | Methods for calculating a combined impact analysis repository |
US8170988B2 (en) * | 2008-04-17 | 2012-05-01 | The Boeing Company | System and method for synchronizing databases |
KR100956921B1 (en) * | 2008-04-28 | 2010-05-11 | 권순용 | database access method |
US20100088686A1 (en) * | 2008-10-06 | 2010-04-08 | Microsoft Corporation | Programming language with extensible syntax |
CN101587492B (en) * | 2009-05-11 | 2011-05-11 | 金蝶软件(中国)有限公司 | Method and system for positioning processed object |
KR100921255B1 (en) * | 2009-05-14 | 2009-10-13 | 주식회사 신시웨이 | Sql masking apparatus and method thereof |
US20110313736A1 (en) * | 2010-06-18 | 2011-12-22 | Bioproduction Group, a California Corporation | Method and Algorithm for Modeling and Simulating A Discrete-Event Dynamic System |
US8316314B2 (en) * | 2010-06-30 | 2012-11-20 | Thermo Electron Scientific Instruments Llc | Intelligent multi-functional macros language for analytical measurements |
US8706744B2 (en) | 2011-05-31 | 2014-04-22 | Ca, Inc. | Determining dependencies during macro expansion |
US20130139113A1 (en) * | 2011-11-30 | 2013-05-30 | Microsoft Corporation | Quick action for performing frequent tasks on a mobile device |
US8990187B2 (en) | 2012-05-21 | 2015-03-24 | Google Inc. | Efficient top-down hierarchical join on a hierarchically clustered data stream |
KR102270791B1 (en) | 2014-12-10 | 2021-06-29 | 삼성전자주식회사 | Method and apparatus for processing macro instruction |
CN107408113B (en) * | 2015-03-31 | 2020-03-31 | 华为技术有限公司 | Analysis engine and method for analyzing pre-generated data reports |
US10585648B2 (en) | 2016-06-01 | 2020-03-10 | The Mathworks, Inc. | Systems and methods for aggregating implicit and explicit event code of executable models |
KR102195838B1 (en) * | 2019-04-10 | 2020-12-28 | 주식회사 티맥스 소프트 | Method for managing database |
US11769489B2 (en) | 2021-01-28 | 2023-09-26 | Samsung Electronics Co., Ltd. | Electronic device and method for performing shortcut command in electronic device |
Family Cites Families (95)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US3656178A (en) * | 1969-09-15 | 1972-04-11 | Research Corp | Data compression and decompression system |
US4667290A (en) * | 1984-09-10 | 1987-05-19 | 501 Philon, Inc. | Compilers using a universal intermediate language |
US4787035A (en) * | 1985-10-17 | 1988-11-22 | Westinghouse Electric Corp. | Meta-interpreter |
JPS63181033A (en) * | 1987-01-23 | 1988-07-26 | Hitachi Ltd | Automatic program generating system |
US5070534A (en) * | 1988-10-17 | 1991-12-03 | International Business Machines Corporation | Simplified cad parametric macroinstruction capability including variational geometrics feature |
US4931928A (en) * | 1988-11-09 | 1990-06-05 | Greenfeld Norton R | Apparatus for analyzing source code |
GB2227339A (en) * | 1989-01-21 | 1990-07-25 | Kashinath Narayan Dandeker | Complex expression generator |
JPH0363581A (en) | 1989-04-28 | 1991-03-19 | Internatl Business Mach Corp <Ibm> | Method of testing electronic circuit |
US5276880A (en) * | 1989-12-15 | 1994-01-04 | Siemens Corporate Research, Inc. | Method for parsing and representing multi-versioned computer programs, for simultaneous and synchronous processing of the plural parses |
US5257363A (en) * | 1990-04-09 | 1993-10-26 | Meta Software Corporation | Computer-aided generation of programs modelling complex systems using colored petri nets |
US5699310A (en) * | 1990-06-29 | 1997-12-16 | Dynasty Technologies, Inc. | Method and apparatus for a fully inherited object-oriented computer system for generating source code from user-entered specifications |
FR2667711B1 (en) * | 1990-10-09 | 1992-11-27 | Thomson Csf | METHOD FOR RECOGNIZING OBJECTS IN IMAGES AND ITS APPLICATION TO TRACKING OBJECTS IN IMAGE SEQUENCES. |
US5295256A (en) * | 1990-12-14 | 1994-03-15 | Racal-Datacom, Inc. | Automatic storage of persistent objects in a relational schema |
US5507030A (en) * | 1991-03-07 | 1996-04-09 | Digitial Equipment Corporation | Successive translation, execution and interpretation of computer program having code at unknown locations due to execution transfer instructions having computed destination addresses |
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 |
US5421016A (en) | 1991-12-12 | 1995-05-30 | International Business Machines Corporation | System and method for dynamically invoking object methods from an application designed for static method invocation |
FR2688611A1 (en) * | 1992-03-12 | 1993-09-17 | Bull Sa | USE OF A LANGUAGE WHICH TYPES RELATES TO THE CONTENT OF THE VARIABLES AND ALLOWS TO HANDLE COMPLEX CONSTRUCTIONS. |
US5721895A (en) * | 1992-03-17 | 1998-02-24 | International Business Machines Corporation | Computer program product and program storage device for a data transmission dictionary for encoding, storing, and retrieving hierarchical data processing information for a computer system |
US5517641A (en) | 1992-05-27 | 1996-05-14 | Cdb Software, Inc. | Restartable method to reorganize DB2 tablespace records by determining new physical positions for the records prior to moving using a non sorting technic |
FR2694105B1 (en) | 1992-07-22 | 1994-11-25 | Bull Sa | Use of an on-board interpreter language for the creation of an interactive user interface definition tool. |
US5295059A (en) * | 1992-09-09 | 1994-03-15 | Allen-Bradley Company, Inc. | Programmable controller with ladder diagram macro instructions |
US5794229A (en) * | 1993-04-16 | 1998-08-11 | Sybase, Inc. | Database system with methodology for storing a database table by vertically partitioning all columns of the table |
JPH06332710A (en) * | 1993-05-21 | 1994-12-02 | Fujitsu Ltd | Object directional data processing system |
US5550971A (en) | 1993-06-30 | 1996-08-27 | U S West Technologies, Inc. | Method and system for generating a user interface adaptable to various database management systems |
JPH07244605A (en) * | 1994-03-03 | 1995-09-19 | Fujitsu Ltd | Data base system and its update method |
US5724425A (en) * | 1994-06-10 | 1998-03-03 | Sun Microsystems, Inc. | Method and apparatus for enhancing software security and distributing software |
US5742828A (en) * | 1994-08-03 | 1998-04-21 | Microsoft Corporation | Compiler and method for evaluation of foreign syntax expressions in source code |
US5694539A (en) * | 1994-08-10 | 1997-12-02 | Intrinsa Corporation | Computer process resource modelling method and apparatus |
US5495613A (en) * | 1994-08-18 | 1996-02-27 | Unisys Corporation | Method and apparatus for extending the capability of a system editor using high-level language transforms |
US5692195A (en) | 1994-08-31 | 1997-11-25 | International Business Machines Corporation | Parent class shadowing |
US5768564A (en) * | 1994-10-07 | 1998-06-16 | Tandem Computers Incorporated | Method and apparatus for translating source code from one high-level computer language to another |
US5732192A (en) | 1994-11-30 | 1998-03-24 | The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration | Global qualitative flow-path modeling for local state determination in simulation and analysis |
US5721915A (en) | 1994-12-30 | 1998-02-24 | International Business Machines Corporation | Interaction between application of a log and maintenance of a table that maps record identifiers during online reorganization of a database |
US5768586A (en) * | 1995-01-10 | 1998-06-16 | Peoplesoft, Inc. | Net change management for object-oriented modeling |
US5513314A (en) | 1995-01-27 | 1996-04-30 | Auspex Systems, Inc. | Fault tolerant NFS server system and mirroring protocol |
US5644764A (en) * | 1995-01-31 | 1997-07-01 | Unisys Corporation | Method for supporting object modeling in a repository |
US5548754A (en) | 1995-02-07 | 1996-08-20 | International Business Machines Corporation | Optimization of SQL queries using early-out join transformations |
US5701487A (en) * | 1995-03-27 | 1997-12-23 | Sun Microsystems, Inc. | Method and apparatus for displaying locations of errors detected inside software macro calls |
JPH11504451A (en) | 1995-04-24 | 1999-04-20 | アスペクト・ディベロップメント・インコーポレイテッド | Modeling objects suitable for database structures, translating into relational database structures, and performing fluid searches on them |
US5737592A (en) * | 1995-06-19 | 1998-04-07 | International Business Machines Corporation | Accessing a relational database over the Internet using macro language files |
US5790861A (en) * | 1995-07-07 | 1998-08-04 | Sun Microsystems, Inc. | Method and apparatus for generating executable code from object-oriented C++ source code |
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 |
US5638381A (en) * | 1995-07-21 | 1997-06-10 | Motorola, Inc. | Apparatus and method for deriving correspondence between storage elements of a first circuit model and storage elements of a second circuit model |
US6011917A (en) | 1995-08-23 | 2000-01-04 | International Business Machines Corporation | Method and computer system for generating process management computer programs from process models |
US5721929A (en) * | 1995-10-06 | 1998-02-24 | Electronic Data Systems Corporation | Method for extending a fourth generation programming language |
US5855014A (en) * | 1995-11-03 | 1998-12-29 | Application Partners, Inc. | Getfield function for a relational workgroup platform using keyword and workflow databases |
US6003037A (en) | 1995-11-14 | 1999-12-14 | Progress Software Corporation | Smart objects for development of object oriented software |
US5721925A (en) * | 1995-12-01 | 1998-02-24 | Unisys Corporation | Method for generically invoking operation in an object oriented repository |
US5802511A (en) * | 1996-01-02 | 1998-09-01 | Timeline, Inc. | Data retrieval method and apparatus with multiple source capability |
US5815415A (en) * | 1996-01-19 | 1998-09-29 | Bentley Systems, Incorporated | Computer system for portable persistent modeling |
US6091895A (en) | 1996-03-27 | 2000-07-18 | International Business Machines Corporation | Object oriented central maintenance for programs and scripts |
US5715453A (en) * | 1996-05-31 | 1998-02-03 | International Business Machines Corporation | Web server mechanism for processing function calls for dynamic data queries in a web page |
US5987123A (en) | 1996-07-03 | 1999-11-16 | Sun Microsystems, Incorporated | Secure file system |
US5819305A (en) * | 1996-08-23 | 1998-10-06 | Motorola, Inc. | Method and apparatus for configuring operating modes in a memory |
US5974201A (en) * | 1996-10-01 | 1999-10-26 | Siemens Corporate Research, Inc. | Smart image system |
US6112024A (en) | 1996-10-02 | 2000-08-29 | Sybase, Inc. | Development system providing methods for managing different versions of objects with a meta model |
US5761494A (en) | 1996-10-11 | 1998-06-02 | The Sabre Group, Inc. | Structured query language to IMS transaction mapper |
US6065002A (en) | 1996-10-31 | 2000-05-16 | Systems And Computer Technology Corporation | Simplified interface for relational database access using open database connectivity |
US5983016A (en) | 1996-11-12 | 1999-11-09 | International Business Machines Corporation | Execution engine in an object modeling tool |
US5857197A (en) | 1997-03-20 | 1999-01-05 | Thought Inc. | System and method for accessing data stores as objects |
US5905982A (en) | 1997-04-04 | 1999-05-18 | International Business Machines Corporation | Handling null values in SQL queries over object-oriented data |
US6182274B1 (en) * | 1997-05-01 | 2001-01-30 | International Business Machines Corporation | Reusing code in object-oriented program development |
US5978789A (en) | 1997-05-07 | 1999-11-02 | Lucent Technologies Inc. | Efficient hypothetical query evaluation in a database system |
US5878411A (en) | 1997-06-27 | 1999-03-02 | International Business Machines Corporation | Dependent object class and subclass mapping to relational data store |
US5822750A (en) * | 1997-06-30 | 1998-10-13 | International Business Machines Corporation | Optimization of correlated SQL queries in a relational database management system |
US6513152B1 (en) | 1997-07-23 | 2003-01-28 | International Business Machines Corporation | Object oriented framework mechanism for customization of object oriented frameworks |
US6081774A (en) * | 1997-08-22 | 2000-06-27 | Novell, Inc. | Natural language information retrieval system and method |
US6112304A (en) * | 1997-08-27 | 2000-08-29 | Zipsoft, Inc. | Distributed computing architecture |
US6292811B1 (en) * | 1997-09-19 | 2001-09-18 | Modernsoft, Inc. | Populating cells of an electronic financial statement |
US5974407A (en) | 1997-09-29 | 1999-10-26 | Sacks; Jerome E. | Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus |
US6085120A (en) * | 1997-11-17 | 2000-07-04 | International Business Machines Corporation | Data system processing and method for creating application extension |
US6105043A (en) * | 1997-12-16 | 2000-08-15 | International Business Machines Corporation | Creating macro language files for executing structured query language (SQL) queries in a relational database via a network |
US6247020B1 (en) | 1997-12-17 | 2001-06-12 | Borland Software Corporation | Development system with application browser user interface |
US6243709B1 (en) | 1998-06-29 | 2001-06-05 | Sun Microsystems, Inc. | Method and apparatus for loading stored procedures in a database corresponding to object-oriented data dependencies |
US6374256B1 (en) | 1997-12-22 | 2002-04-16 | Sun Microsystems, Inc. | Method and apparatus for creating indexes in a relational database corresponding to classes in an object-oriented application |
US6114978A (en) | 1998-01-14 | 2000-09-05 | Lucent Technologies Inc. | Method and apparatus for assignment of shortcut key combinations in a computer software application |
US6453356B1 (en) | 1998-04-15 | 2002-09-17 | Adc Telecommunications, Inc. | Data exchange system and method |
US6052720A (en) | 1998-05-14 | 2000-04-18 | Sun Microsystems, Inc. | Generic schema for storing configuration information on a server computer |
US6446109B2 (en) | 1998-06-29 | 2002-09-03 | Sun Microsystems, Inc. | Application computing environment |
US6226792B1 (en) | 1998-10-14 | 2001-05-01 | Unisys Corporation | Object management system supporting the use of application domain knowledge mapped to technology domain knowledge |
US6859919B1 (en) | 1998-10-16 | 2005-02-22 | Computer Associates Think, Inc. | Object modeling tool with meta model semantic registry (rules) a meta data manager for object(s) properties an object/property interface for instance(s) of objects/properties received via object/property interface of the object factory registry |
EP1121655B1 (en) | 1998-10-16 | 2006-07-12 | Computer Associates Think, Inc. | Accessing a hierarchical data store through an sql input |
US6502234B1 (en) | 1999-01-15 | 2002-12-31 | International Business Machines Corporation | Component based wizard for creating wizards |
US6678882B1 (en) | 1999-06-30 | 2004-01-13 | Qwest Communications International Inc. | Collaborative model for software systems with synchronization submodel with merge feature, automatic conflict resolution and isolation of potential changes for reuse |
KR200258626Y1 (en) | 1999-06-30 | 2001-12-28 | 윤청목 | Mixer combined with Juice Extractor |
US6385767B1 (en) | 1999-09-30 | 2002-05-07 | Unisys Corporation | Method and system for creating and manipulating extensions to version control systems |
EP1247165B1 (en) | 1999-10-01 | 2006-05-03 | Infoglide Corporation | System and method for transforming a relational database to a hierarchical database |
US20050160401A1 (en) | 1999-10-16 | 2005-07-21 | Computer Associates Think, Inc. | System and method for adding user-defined objects to a modeling tool |
US7734457B2 (en) | 1999-10-16 | 2010-06-08 | Computer Associates Think, Inc. | Method and system for generating dynamic comparison models |
JP2001265361A (en) | 2000-03-14 | 2001-09-28 | Sony Corp | Device and method for providing information, device and method for providing information, and program storage medium |
US7353289B2 (en) | 2000-11-06 | 2008-04-01 | Telecommunication Systems, Inc. | System for an open architecture development platform with centralized synchronization |
US6754671B2 (en) | 2001-05-02 | 2004-06-22 | Sun Microsystems, Inc. | Apparatus for Meta Object Facility repository bootstrap |
US20030014439A1 (en) | 2001-06-20 | 2003-01-16 | International Business Machines Corporation | Defining a markup language representation for state chart data |
US7322025B2 (en) | 2001-07-17 | 2008-01-22 | Tata Consultancy Services Limited | Method and apparatus for versioning and configuration management of object models |
US6904588B2 (en) | 2001-07-26 | 2005-06-07 | Tat Consultancy Services Limited | Pattern-based comparison and merging of model versions |
-
1999
- 1999-10-15 EP EP99970761A patent/EP1121655B1/en not_active Expired - Lifetime
- 1999-10-15 CA CA002346924A patent/CA2346924A1/en not_active Abandoned
- 1999-10-15 IL IL14248499A patent/IL142484A0/en active IP Right Grant
- 1999-10-15 JP JP2000577559A patent/JP2002528789A/en active Pending
- 1999-10-15 JP JP2000577592A patent/JP2002528794A/en active Pending
- 1999-10-15 KR KR1020017004770A patent/KR20010103603A/en not_active Application Discontinuation
- 1999-10-15 JP JP2000577590A patent/JP2002528793A/en not_active Withdrawn
- 1999-10-15 CN CN99812190A patent/CN1129859C/en not_active Expired - Fee Related
- 1999-10-15 AU AU14452/00A patent/AU775431B2/en not_active Ceased
- 1999-10-15 KR KR1020017004595A patent/KR20010093777A/en not_active Application Discontinuation
- 1999-10-15 WO PCT/US1999/023876 patent/WO2000023917A1/en active IP Right Grant
- 1999-10-15 BR BR9914553-7A patent/BR9914553A/en not_active IP Right Cessation
- 1999-10-15 IL IL14248299A patent/IL142482A0/en active IP Right Grant
- 1999-10-15 WO PCT/US1999/024120 patent/WO2000023863A2/en not_active Application Discontinuation
- 1999-10-15 KR KR1020017004801A patent/KR20010089309A/en not_active Application Discontinuation
- 1999-10-15 WO PCT/US1999/024117 patent/WO2000023882A1/en not_active Application Discontinuation
- 1999-10-15 CN CN99812038A patent/CN1361891A/en active Pending
- 1999-10-15 CA CA002346925A patent/CA2346925A1/en not_active Abandoned
- 1999-10-15 AU AU13152/00A patent/AU772191B2/en not_active Ceased
- 1999-10-15 CN CN99812224A patent/CN1359489A/en active Pending
- 1999-10-15 EP EP99953188A patent/EP1129391A4/en not_active Withdrawn
- 1999-10-15 CN CN99812225A patent/CN1129068C/en not_active Expired - Fee Related
- 1999-10-15 AT AT99970761T patent/ATE333125T1/en not_active IP Right Cessation
- 1999-10-15 EP EP99956567A patent/EP1121654A4/en not_active Ceased
- 1999-10-15 WO PCT/US1999/024115 patent/WO2000023919A1/en not_active Application Discontinuation
- 1999-10-15 WO PCT/US1999/024118 patent/WO2000023883A1/en not_active Application Discontinuation
- 1999-10-15 CA CA002346928A patent/CA2346928A1/en not_active Abandoned
- 1999-10-15 IL IL14256499A patent/IL142564A0/en active IP Right Grant
- 1999-10-15 BR BR9914549-9A patent/BR9914549A/en not_active IP Right Cessation
- 1999-10-15 CN CNB998121916A patent/CN1192321C/en not_active Expired - Fee Related
- 1999-10-15 EP EP99956569.0A patent/EP1121639B1/en not_active Expired - Lifetime
- 1999-10-15 JP JP2000577558A patent/JP2002528788A/en active Pending
- 1999-10-15 IL IL14257299A patent/IL142572A0/en active IP Right Grant
- 1999-10-15 AU AU13154/00A patent/AU761228B2/en not_active Ceased
- 1999-10-15 KR KR1020017004671A patent/KR20010106514A/en not_active Application Discontinuation
- 1999-10-15 JP JP2000577541A patent/JP2002528783A/en active Pending
- 1999-10-15 AU AU65180/99A patent/AU6518099A/en not_active Abandoned
- 1999-10-15 BR BR9914427-1A patent/BR9914427A/en not_active IP Right Cessation
- 1999-10-15 AU AU12071/00A patent/AU1207100A/en not_active Abandoned
- 1999-10-15 IL IL14257199A patent/IL142571A0/en active IP Right Grant
- 1999-10-15 BR BR9914552-9A patent/BR9914552A/en not_active IP Right Cessation
- 1999-10-15 DE DE69932344T patent/DE69932344T2/en not_active Expired - Lifetime
- 1999-10-15 EP EP99970749.0A patent/EP1121640B1/en not_active Expired - Lifetime
- 1999-10-15 CA CA002347467A patent/CA2347467A1/en not_active Abandoned
- 1999-10-15 BR BR9914551-0A patent/BR9914551A/en not_active IP Right Cessation
- 1999-10-15 KR KR1020017004771A patent/KR20010103604A/en not_active Application Discontinuation
- 1999-10-15 CA CA002347495A patent/CA2347495A1/en not_active Abandoned
- 1999-10-16 US US09/419,749 patent/US7711685B1/en not_active Expired - Fee Related
- 1999-10-16 US US09/419,731 patent/US6601023B1/en not_active Expired - Lifetime
- 1999-10-16 US US09/419,736 patent/US6385610B1/en not_active Expired - Lifetime
-
2001
- 2001-04-05 IL IL142482A patent/IL142482A/en not_active IP Right Cessation
- 2001-04-05 IL IL142484A patent/IL142484A/en not_active IP Right Cessation
- 2001-04-12 IL IL142564A patent/IL142564A/en not_active IP Right Cessation
- 2001-04-12 IL IL142572A patent/IL142572A/en not_active IP Right Cessation
- 2001-04-12 IL IL142571A patent/IL142571A/en not_active IP Right Cessation
-
2002
- 2002-01-28 HK HK02100664.3A patent/HK1040441A1/en unknown
- 2002-01-28 HK HK02100665.2A patent/HK1040552A1/en unknown
- 2002-01-28 HK HK02100660.7A patent/HK1040440A1/en unknown
- 2002-03-04 HK HK02101645.5A patent/HK1042140A1/en unknown
-
2005
- 2005-05-11 JP JP2005138696A patent/JP2005285141A/en active Pending
Also Published As
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2000023917A9 (en) | Accessing a hierarchical data store through an sql input | |
US6665677B1 (en) | System and method for transforming a relational database to a hierarchical database | |
US7149752B2 (en) | Method for simplifying databinding in application programs | |
US7152074B2 (en) | Extensible framework supporting deposit of heterogenous data sources into a target data repository | |
US6366922B1 (en) | Multi-dimensional data management system | |
US5388259A (en) | System for accessing a database with an iterated fuzzy query notified by retrieval response | |
CN1705945B (en) | Method and system for providing query attributes | |
US7844623B2 (en) | Method to provide management of query output | |
US7949652B2 (en) | Filtering query results using model entity limitations | |
JP2002538546A (en) | ABAP Code Converter Specifications | |
US7461085B2 (en) | Apparatus and method for parametric group processing | |
US20180067987A1 (en) | Database capable of integrated query processing and data processing method thereof | |
US20040054683A1 (en) | System and method for join operations of a star schema database | |
US5819277A (en) | Method for generating SQL commands to create an integrated global schema | |
Boulanger et al. | An approach to analyzing the information content of existing databases | |
Karadimce et al. | A framework for declarative updates and constraint maintenance in Object-Oriented databases | |
Halpin et al. | Modeling Collections in UML and ORM | |
Cavallaro | HIFI—Hypertext interface to external databases | |
Halustchak | Proposed spatial data handling extensions to SQL | |
Jett et al. | ESTEVAL: a decision support tool for hardware/software system design | |
JPH06119150A (en) | Automatic data storing method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WWE | Wipo information: entry into national phase |
Ref document number: 99812191.6 Country of ref document: CN |
|
ENP | Entry into the national phase |
Ref document number: 2000 14452 Country of ref document: AU Kind code of ref document: A |
|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HU ID IL IS JP KE KG KP KR KZ LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
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) | ||
AK | Designated states |
Kind code of ref document: C2 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HU ID IL IS JP KE KG KP KR KZ LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: C2 Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
COP | Corrected version of pamphlet |
Free format text: PAGES 1/3-3/3, DRAWINGS, REPLACED BY NEW PAGES 1/2-2/2; DUE TO LATE TRANSMITTAL BY THE RECEIVING OFFICE |
|
WWE | Wipo information: entry into national phase |
Ref document number: 1999970761 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 142482 Country of ref document: IL |
|
ENP | Entry into the national phase |
Ref document number: 2346928 Country of ref document: CA Ref document number: 2346928 Country of ref document: CA Kind code of ref document: A |
|
WWE | Wipo information: entry into national phase |
Ref document number: 14452/00 Country of ref document: AU Ref document number: 1020017004595 Country of ref document: KR |
|
ENP | Entry into the national phase |
Ref document number: 2000 577590 Country of ref document: JP Kind code of ref document: A |
|
WWP | Wipo information: published in national office |
Ref document number: 1999970761 Country of ref document: EP |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
WWG | Wipo information: grant in national office |
Ref document number: 14452/00 Country of ref document: AU |
|
WWG | Wipo information: grant in national office |
Ref document number: 1999970761 Country of ref document: EP |