JP6412924B2 - Ｅｔｌマップ設計のためのプロジェクタおよびセレクタコンポーネントタイプの使用 - Google Patents

Ｅｔｌマップ設計のためのプロジェクタおよびセレクタコンポーネントタイプの使用 Download PDF

Info

Publication number
JP6412924B2
JP6412924B2 JP2016513953A JP2016513953A JP6412924B2 JP 6412924 B2 JP6412924 B2 JP 6412924B2 JP 2016513953 A JP2016513953 A JP 2016513953A JP 2016513953 A JP2016513953 A JP 2016513953A JP 6412924 B2 JP6412924 B2 JP 6412924B2
Authority
JP
Japan
Prior art keywords
data
components
logical design
attributes
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.)
Active
Application number
JP2016513953A
Other languages
English (en)
Japanese (ja)
Other versions
JP2016525734A (ja
JP2016525734A5 (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 JP2016525734A publication Critical patent/JP2016525734A/ja
Publication of JP2016525734A5 publication Critical patent/JP2016525734A5/ja
Application granted granted Critical
Publication of JP6412924B2 publication Critical patent/JP6412924B2/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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • 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)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Stored Programmes (AREA)
JP2016513953A 2013-05-17 2014-03-26 Ｅｔｌマップ設計のためのプロジェクタおよびセレクタコンポーネントタイプの使用 Active JP6412924B2 (ja)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US201361824544P 2013-05-17 2013-05-17
US61/824,544 2013-05-17
US14/044,417 2013-10-02
US14/044,417 US9507838B2 (en) 2013-05-17 2013-10-02 Use of projector and selector component types for ETL map design
PCT/US2014/031921 WO2014186058A1 (en) 2013-05-17 2014-03-26 Use of projector and selector component types for etl map design

Publications (3)

Publication Number Publication Date
JP2016525734A JP2016525734A (ja) 2016-08-25
JP2016525734A5 JP2016525734A5 (enExample) 2017-04-13
JP6412924B2 true JP6412924B2 (ja) 2018-10-24

Family

ID=51896600

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2016513953A Active JP6412924B2 (ja) 2013-05-17 2014-03-26 Ｅｔｌマップ設計のためのプロジェクタおよびセレクタコンポーネントタイプの使用

Country Status (5)

Country Link
US (1) US9507838B2 (enExample)
EP (1) EP2997512A4 (enExample)
JP (1) JP6412924B2 (enExample)
CN (1) CN105339941B (enExample)
WO (1) WO2014186058A1 (enExample)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10216814B2 (en) 2013-05-17 2019-02-26 Oracle International Corporation Supporting combination of flow based ETL and entity relationship based ETL
US9922104B1 (en) * 2014-08-13 2018-03-20 Numerify, Inc. Metadata driven code-generated external data feeds
IN2015CH02357A (enExample) * 2015-05-08 2015-05-22 Wipro Ltd
WO2017143405A1 (en) * 2016-02-26 2017-08-31 Cryspintel Pty Ltd A data source system agnostic fact category partitioned information repository and methods for the insertion and retrieval of data using the information repository
WO2018039266A1 (en) * 2016-08-22 2018-03-01 Oracle International Corporation System and method for dynamic lineage tracking, reconstruction, and lifecycle management
US11055310B2 (en) * 2017-12-04 2021-07-06 Bank Of America Corporation SQL server integration services (SSIS) package analyzer
AU2020100309B4 (en) * 2019-03-20 2020-09-24 Parametric Systems Pty Ltd Techniques for Controlling Interaction with an Application Database
CN110780946B (zh) * 2019-10-30 2021-05-25 京东数字科技控股有限公司 用于处理信息的方法和装置
US11824837B2 (en) * 2020-07-15 2023-11-21 Sap Se End user creation of trusted integration pathways between different enterprise systems
CN112035468B (zh) * 2020-08-24 2024-06-14 杭州览众数据科技有限公司 基于内存计算、web可视化配置的多数据源ETL工具
US11561803B1 (en) * 2021-07-08 2023-01-24 SambaNova Systems, Inc. Systems and methods for editing topology of a reconfigurable data processor
US11750488B1 (en) * 2022-04-12 2023-09-05 International Business Machines Corporation Minimizing latency of round trip network communication in a computing infrastructure

Family Cites Families (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5659723A (en) 1991-12-20 1997-08-19 International Business Machines Corporation Entity/relationship to object oriented logical model conversion method
US7185016B1 (en) 2000-09-01 2007-02-27 Cognos Incorporated Methods and transformations for transforming metadata model
US7343585B1 (en) * 2002-01-30 2008-03-11 Oracle International Corporation Operator approach for generic dataflow designs
US7350191B1 (en) * 2003-04-22 2008-03-25 Noetix, Inc. Computer implemented system and method for the generation of data access applications
US7739223B2 (en) 2003-08-29 2010-06-15 Microsoft Corporation Mapping architecture for arbitrary data models
US7849438B1 (en) * 2004-05-27 2010-12-07 Sprint Communications Company L.P. Enterprise software development process for outsourced developers
US7430498B2 (en) * 2004-09-07 2008-09-30 The Boeing Company System, method and computer program product for developing a system-of-systems architecture model
TWI311705B (en) * 2005-05-23 2009-07-01 Via Tech Inc Peripheral component interconnect express and changing method of link power states thereof
US7581189B2 (en) * 2005-09-09 2009-08-25 Microsoft Corporation Dynamically generating a database report during a report building process
WO2007083371A1 (ja) * 2006-01-18 2007-07-26 Fujitsu Limited データ統合装置、方法、プログラムを記録した記録媒体
US8307012B2 (en) 2006-02-28 2012-11-06 Sap Ag Schema mapping and data transformation on the basis of a conceptual model
US7610299B2 (en) * 2006-11-30 2009-10-27 International Business Machines Corporation Method of processing data
US7860905B2 (en) 2007-04-24 2010-12-28 Microsoft Corporation Systems and methods for modularizing data flows
US8245105B2 (en) * 2008-07-01 2012-08-14 International Business Machines Corporation Cascade interconnect memory system with enhanced reliability
US9557889B2 (en) * 2009-01-28 2017-01-31 Headwater Partners I Llc Service plan design, user interfaces, application programming interfaces, and device management
JP5375413B2 (ja) * 2009-07-30 2013-12-25 富士通株式会社 データ変換装置、データ変換方法、およびデータ変換プログラム
US8719769B2 (en) 2009-08-18 2014-05-06 Hewlett-Packard Development Company, L.P. Quality-driven ETL design optimization
US9218408B2 (en) 2010-05-27 2015-12-22 Oracle International Corporation Method for automatically creating a data mart by aggregated data extracted from a business intelligence server
JP5601066B2 (ja) * 2010-07-23 2014-10-08 富士通株式会社 情報統合プログラム、装置及び方法
US20120054147A1 (en) 2010-08-25 2012-03-01 Christophe Goetz System and method for extract, transform, and load workflow generation
WO2012050579A1 (en) 2010-10-14 2012-04-19 Hewlett-Packard Development Company, L.P. Providing operational business intelligence
US8762934B2 (en) 2010-10-15 2014-06-24 Serghei Sarafudinov Method of extensible business object modeling and generation of system artifacts from the models
US8887076B2 (en) * 2011-11-01 2014-11-11 Aver Informatics Inc. Software user interface allowing logical expression to be expressed as a flowchart
US8676772B2 (en) * 2011-12-09 2014-03-18 Telduráðgevin Sp/f Systems and methods for improving database performance
US9396037B2 (en) 2012-02-27 2016-07-19 Microsoft Technology Licensing, Llc Model-based data pipeline system optimization
US9020945B1 (en) * 2013-01-25 2015-04-28 Humana Inc. User categorization system and method

Also Published As

Publication number Publication date
US9507838B2 (en) 2016-11-29
US20140344210A1 (en) 2014-11-20
EP2997512A1 (en) 2016-03-23
CN105339941B (zh) 2019-03-05
WO2014186058A1 (en) 2014-11-20
EP2997512A4 (en) 2017-01-18
JP2016525734A (ja) 2016-08-25
CN105339941A (zh) 2016-02-17

Similar Documents

Publication Publication Date Title
JP6434960B2 (ja) フローベースのｅｔｌおよびエンティティリレーションシップベースのｅｔｌの組合せのサポート
US11847131B2 (en) Optimizing incremental loading of warehouse data
US11789964B2 (en) Load plan generation
JP6412924B2 (ja) Ｅｔｌマップ設計のためのプロジェクタおよびセレクタコンポーネントタイプの使用
US10073867B2 (en) System and method for code generation from a directed acyclic graph using knowledge modules
US9659012B2 (en) Debugging framework for distributed ETL process with multi-language support
US10678632B2 (en) Extract-transform-load diagnostics
CN110023923B (zh) 生成数据变换工作流
US8954375B2 (en) Method and system for developing data integration applications with reusable semantic types to represent and process application data
CN115774730A (zh) 具有公共数据结构的阶段式查询编译
US12405967B2 (en) System and method for generating a network graph from analytic artifacts in an analytics environment
Demchenko et al. Big Data Algorithms, MapReduce and Hadoop ecosystem
CN114637767A (zh) 使用通用数据库搜索模型的系统和方法
Prakash et al. A Comprehensive Study on Structural and Non-Structural Databases and Its Impact on Hybrid Databases
US12169501B2 (en) Optimizing incremental loading of warehouse data
CN116457771A (zh) 用于提供与数据分析环境一起使用的查询执行调试器的系统和方法
Aytas Designing Big Data Platforms: How to Use, Deploy, and Maintain Big Data Systems
Eisa Parallel Processing for Data Retrieval in Odoo Enterprise Resource Planning Reporting System
Garcia Curating and Standardizing Data: The Case Study of Pharmaceutical Company Using a Common Data Layer
Virolainen Migrating Microservices to Graph Database

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20170310

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20170310

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20180222

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20180313

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20180612

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20180619

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: 20180905

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20181001

R150 Certificate of patent or registration of utility model

Ref document number: 6412924

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