JP6329552B2 - 単一テーブルから複数テーブルへの参照データセグメント化 - Google Patents

単一テーブルから複数テーブルへの参照データセグメント化 Download PDF

Info

Publication number
JP6329552B2
JP6329552B2 JP2015534803A JP2015534803A JP6329552B2 JP 6329552 B2 JP6329552 B2 JP 6329552B2 JP 2015534803 A JP2015534803 A JP 2015534803A JP 2015534803 A JP2015534803 A JP 2015534803A JP 6329552 B2 JP6329552 B2 JP 6329552B2
Authority
JP
Japan
Prior art keywords
data
tables
definition
computer
database
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.)
Active
Application number
JP2015534803A
Other languages
English (en)
Japanese (ja)
Other versions
JP2015530677A (ja
JP2015530677A5 (enExample
Inventor
ファン，アイリーン
ン，アーノルド
モディ，ラジャン
ガウ，ジョニー
Original Assignee
オラクル・インターナショナル・コーポレイション
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 オラクル・インターナショナル・コーポレイション filed Critical オラクル・インターナショナル・コーポレイション
Publication of JP2015530677A publication Critical patent/JP2015530677A/ja
Publication of JP2015530677A5 publication Critical patent/JP2015530677A5/ja
Application granted granted Critical
Publication of JP6329552B2 publication Critical patent/JP6329552B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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

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)
JP2015534803A 2012-10-01 2013-09-30 単一テーブルから複数テーブルへの参照データセグメント化 Active JP6329552B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/633,064 US9507837B2 (en) 2012-10-01 2012-10-01 Reference data segmentation from single to multiple tables
US13/633,064 2012-10-01
PCT/US2013/062698 WO2014055438A1 (en) 2012-10-01 2013-09-30 Reference data segmentation from single to multiple tables

Related Child Applications (1)

Application Number Title Priority Date Filing Date
JP2017229138A Division JP6549681B2 (ja) 2012-10-01 2017-11-29 単一テーブルから複数テーブルへの参照データセグメント化

Publications (3)

Publication Number Publication Date
JP2015530677A JP2015530677A (ja) 2015-10-15
JP2015530677A5 JP2015530677A5 (enExample) 2016-11-17
JP6329552B2 true JP6329552B2 (ja) 2018-05-23

Family

ID=49382602

Family Applications (2)

Application Number Title Priority Date Filing Date
JP2015534803A Active JP6329552B2 (ja) 2012-10-01 2013-09-30 単一テーブルから複数テーブルへの参照データセグメント化
JP2017229138A Active JP6549681B2 (ja) 2012-10-01 2017-11-29 単一テーブルから複数テーブルへの参照データセグメント化

Family Applications After (1)

Application Number Title Priority Date Filing Date
JP2017229138A Active JP6549681B2 (ja) 2012-10-01 2017-11-29 単一テーブルから複数テーブルへの参照データセグメント化

Country Status (5)

Country Link
US (1) US9507837B2 (enExample)
EP (1) EP2904520B1 (enExample)
JP (2) JP6329552B2 (enExample)
CN (1) CN104781814B (enExample)
WO (1) WO2014055438A1 (enExample)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11030063B1 (en) * 2015-03-30 2021-06-08 Amazon Technologies, Inc. Ensuring data integrity during large-scale data migration
US10540366B2 (en) 2017-03-09 2020-01-21 Bank Of America Corporation Transforming data structures and data objects for migrating data between databases having different schemas
WO2018176356A1 (en) * 2017-03-31 2018-10-04 Oracle International Corporation System and method for determining the success of a cross-platform application migration
CN107704568B (zh) * 2017-09-29 2019-03-26 马上消费金融股份有限公司 一种测试数据添加的方法及装置
CN110209652B (zh) * 2019-05-20 2024-02-02 平安科技（深圳）有限公司 数据表迁移方法、装置、计算机设备和存储介质
CN116932513A (zh) * 2023-07-31 2023-10-24 金篆信科有限责任公司 一种数据迁移方法、装置、系统及介质

Family Cites Families (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11110262A (ja) * 1997-10-01 1999-04-23 Toshiba Corp 情報管理システム
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
JPH11312150A (ja) * 1998-04-30 1999-11-09 Nippon Telegr & Teleph Corp <Ntt> 並列処理方法および並列処理システム、ならびに並列処理プログラムを記録した記録媒体
WO2001025962A1 (en) * 1999-10-05 2001-04-12 S.C. Medicarom Group S.R.L. Database organization for increasing performance by splitting tables
US6910115B2 (en) * 2001-10-31 2005-06-21 Hewlett-Packard Development Company, L.P. System and method for configuring a removable storage medium
EP1321865A3 (en) 2001-12-19 2006-03-15 Alcatel Canada Inc. System and method for multiple-threaded access to a database
US7739223B2 (en) * 2003-08-29 2010-06-15 Microsoft Corporation Mapping architecture for arbitrary data models
US7389314B2 (en) * 2004-08-30 2008-06-17 Corio, Inc. Database backup, refresh and cloning system and method
US7849106B1 (en) * 2004-12-03 2010-12-07 Oracle International Corporation Efficient mechanism to support user defined resource metadata in a database repository
JP2006293981A (ja) * 2005-03-18 2006-10-26 Hitachi Ltd データベース格納方法、および、データベース格納システム
US8458201B2 (en) * 2005-04-08 2013-06-04 International Business Machines Corporation Method and apparatus for mapping structured query language schema to application specific business objects in an integrated application environment
JP2008171225A (ja) * 2007-01-12 2008-07-24 Hitachi Information Systems Ltd データベース自動移行システム
CN101034349A (zh) * 2007-04-06 2007-09-12 西安万年科技实业有限公司 基于功能设计的数据库应用系统开发平台
US7720873B2 (en) * 2007-06-21 2010-05-18 International Business Machines Corporation Dynamic data discovery of a source data schema and mapping to a target data schema
US7702694B1 (en) * 2007-09-07 2010-04-20 Southern Company Services, Inc. System and method for organizing managing and accessing large quantities of data from non-homogenous data sources
US8515903B2 (en) * 2007-10-03 2013-08-20 Database Logic Inc. Collaboration of plural databases by interaction through universal index
CN101566986A (zh) * 2008-04-21 2009-10-28 阿里巴巴集团控股有限公司 联机事务处理中的数据处理方法和装置
US9996572B2 (en) * 2008-10-24 2018-06-12 Microsoft Technology Licensing, Llc Partition management in a partitioned, scalable, and available structured storage

Also Published As

Publication number Publication date
JP2018060570A (ja) 2018-04-12
WO2014055438A1 (en) 2014-04-10
US20140095522A1 (en) 2014-04-03
CN104781814B (zh) 2019-07-05
EP2904520A1 (en) 2015-08-12
JP2015530677A (ja) 2015-10-15
JP6549681B2 (ja) 2019-07-24
CN104781814A (zh) 2015-07-15
US9507837B2 (en) 2016-11-29
EP2904520B1 (en) 2019-10-23

Similar Documents

Publication Publication Date Title
JP6549681B2 (ja) 単一テーブルから複数テーブルへの参照データセグメント化
CN109997126B (zh) 事件驱动提取、变换、加载（etl）处理
CN110222036B (zh) 用于自动数据库迁移的方法和系统
JP6113693B2 (ja) Ｈａｄｏｏｐにおける強化されたＳＱＬライクなクエリのためのバックグラウンドフォーマット最適化
US11893041B2 (en) Data synchronization between a source database system and target database system
US9529846B2 (en) Data grid advisor
CN111026568B (zh) 数据和任务关系构建方法、装置、计算机设备及存储介质
CN111324610A (zh) 一种数据同步的方法及装置
US8645502B2 (en) Dynamic interface to read database through remote procedure call
US20150095283A1 (en) Master schema shared across multiple tenants with dynamic update
JP2010524060A (ja) 分散コンピューティングにおけるデータマージング
CN105205154B (zh) 数据迁移方法以及装置
US20150293948A1 (en) Converting Data Objects from Single- to Multi-Source Database Environment
US9971794B2 (en) Converting data objects from multi- to single-source database environment
WO2024060677A1 (zh) 数据校验方法及电子设备
CN112905676A (zh) 一种数据文件的导入方法及装置
JP2018109898A (ja) データマイグレーションシステム
CN114168566A (zh) 应用于事项数据同步的数据处理方法、装置、设备、介质和程序产品
US8108349B1 (en) Directory services integration and replication system
US12405941B2 (en) Multi-region workflow management
CN109587224B (zh) 数据处理方法、装置、电子设备及计算机可读介质
CN111159585B (zh) 自动提交数据的方法、装置、设备及介质
CN112486460A (zh) 自动导入接口文档的方法、系统、设备和介质
CN117390040B (zh) 基于实时宽表的业务请求处理方法、设备及存储介质
JP5673246B2 (ja) データストア制御装置、データストア制御プログラムおよびデータストア制御方法

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20160926

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20160926

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20170809

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20170829

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20171129

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20180403

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20180420

R150 Certificate of patent or registration of utility model

Ref document number: 6329552

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250