CA2283050A1 - Exporting and importing of data in object-relational databases - Google Patents

Exporting and importing of data in object-relational databases Download PDF

Info

Publication number
CA2283050A1
CA2283050A1 CA002283050A CA2283050A CA2283050A1 CA 2283050 A1 CA2283050 A1 CA 2283050A1 CA 002283050 A CA002283050 A CA 002283050A CA 2283050 A CA2283050 A CA 2283050A CA 2283050 A1 CA2283050 A1 CA 2283050A1
Authority
CA
Canada
Prior art keywords
data
database
data transfer
type hierarchy
transfer file
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
Application number
CA002283050A
Other languages
French (fr)
Other versions
CA2283050C (en
Inventor
Leo Tat Man Lau
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IBM Canada Ltd
Original Assignee
IBM Canada Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by IBM Canada Ltd filed Critical IBM Canada Ltd
Priority to CA002283050A priority Critical patent/CA2283050C/en
Publication of CA2283050A1 publication Critical patent/CA2283050A1/en
Application granted granted Critical
Publication of CA2283050C publication Critical patent/CA2283050C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

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/21—Design, administration or maintenance of databases
    • G06F16/214—Database migration support
    • 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/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

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

A computer system for transferring data from an object relational database to another such database. The data in the source database having a table type hierarchy of data tables. The system transforming data from the source database to a flat file format data transfer file using a defined tree traversal order. The columns and subcolumns of the data transfer file corresponding to types and attributes from the source database type hierarchy; The data transfer file having a type identifier column corresponding to a type in the table type hierarchy. The system permitting the inputting of the data from the data transfer file to a target database having a table type hierarchy corresponding to the table type hierarchy of the source database.
CA002283050A 1999-09-23 1999-09-23 Exporting and importing of data in object-relational databases Expired - Fee Related CA2283050C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002283050A CA2283050C (en) 1999-09-23 1999-09-23 Exporting and importing of data in object-relational databases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CA002283050A CA2283050C (en) 1999-09-23 1999-09-23 Exporting and importing of data in object-relational databases

Publications (2)

Publication Number Publication Date
CA2283050A1 true CA2283050A1 (en) 2001-03-23
CA2283050C CA2283050C (en) 2003-03-18

Family

ID=4164191

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002283050A Expired - Fee Related CA2283050C (en) 1999-09-23 1999-09-23 Exporting and importing of data in object-relational databases

Country Status (1)

Country Link
CA (1) CA2283050C (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20190311041A1 (en) * 2018-04-05 2019-10-10 Accenture Global Solutions Limited Database migration sequencing using dynamic object-relationship diagram
CN112069129A (en) * 2020-09-18 2020-12-11 浪潮云信息技术股份公司 Configuration file format conversion method, device and medium based on domestic CPU

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20190311041A1 (en) * 2018-04-05 2019-10-10 Accenture Global Solutions Limited Database migration sequencing using dynamic object-relationship diagram
US10838930B2 (en) * 2018-04-05 2020-11-17 Accenture Global Solutions Limited Database migration sequencing using dynamic object-relationship diagram
CN112069129A (en) * 2020-09-18 2020-12-11 浪潮云信息技术股份公司 Configuration file format conversion method, device and medium based on domestic CPU
CN112069129B (en) * 2020-09-18 2024-01-19 浪潮云信息技术股份公司 Configuration file format conversion method, device and medium based on domestic CPU

Also Published As

Publication number Publication date
CA2283050C (en) 2003-03-18

Similar Documents

Publication Publication Date Title
EP1313038A3 (en) X.500 System and methods using metadata
CA2027779A1 (en) Data retrieval system for relational database
WO2004012057A3 (en) Method and system of unifying data
AU6034696A (en) Computer system for creating semantic object models from existing relational database schemas
WO1997038388A3 (en) Method of integrating schemas of distributed heterogeneous databases
EP1385100A3 (en) Mapping a class hierarchy to a relational database system
EP1482430A3 (en) System and method of transforming queries based upon e/r schema into multi-dimensional expression queries
ES2136253T3 (en) INTELLIGENT DATA STORE.
CA2210097A1 (en) Query translation system
CA2143652A1 (en) Information model based on a physical system
EP0309374A3 (en) Automated bill of material
EP0320266A3 (en) View composition in a data base management system
DE60130475D1 (en) IMPLEMENTATION OF CALCULATIONS OF THE TABLE CALCULATION TYPE IN A DATABASE SYSTEM
AU4613199A (en) Method and system for fast memory-resident processing of transaction data
WO2002005116A3 (en) Automatic database replication server and methods
EP1298543A3 (en) Providing a join plan using group-by operator
WO2001095154A8 (en) Object-relational mapping for tables without primary keys
WO2000043916A3 (en) Database item versioning
US7308455B2 (en) System and method for decomposition of multiple items into the same table-column pair without dedicated mapping constructs
EP1492030A3 (en) System and method for online analytical processing using dimension attributes and multiple hierarchies per dimension
CA2283050A1 (en) Exporting and importing of data in object-relational databases
WO2002075597A3 (en) A method and system for providing a virtual unified product content repository
WO2000055767A3 (en) System and method for real-time interoperation between a database management system and multiple data sources
CA2130065A1 (en) Utilizing Pseudotables as a Method and Mechanism for Providing Database Monitor Information
WO2001046866A3 (en) Data restructurer for flattening hierarchies

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed