CN105339941B - 针对etl映射设计使用投影器和选择器组件类型 - Google Patents

针对etl映射设计使用投影器和选择器组件类型 Download PDF

Info

Publication number
CN105339941B
CN105339941B CN201480036876.XA CN201480036876A CN105339941B CN 105339941 B CN105339941 B CN 105339941B CN 201480036876 A CN201480036876 A CN 201480036876A CN 105339941 B CN105339941 B CN 105339941B
Authority
CN
China
Prior art keywords
component
data
logical design
components
information
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
CN201480036876.XA
Other languages
English (en)
Chinese (zh)
Other versions
CN105339941A (zh
Inventor
J·莱格
D·阿兰
刘国洪（托马斯）
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.)
Oracle International Corp
Original Assignee
Oracle International Corp
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 Oracle International Corp filed Critical Oracle International Corp
Publication of CN105339941A publication Critical patent/CN105339941A/zh
Application granted granted Critical
Publication of CN105339941B publication Critical patent/CN105339941B/zh
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)
CN201480036876.XA 2013-05-17 2014-03-26 针对etl映射设计使用投影器和选择器组件类型 Active CN105339941B (zh)

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 (2)

Publication Number Publication Date
CN105339941A CN105339941A (zh) 2016-02-17
CN105339941B true CN105339941B (zh) 2019-03-05

Family

ID=51896600

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201480036876.XA Active CN105339941B (zh) 2013-05-17 2014-03-26 针对etl映射设计使用投影器和选择器组件类型

Country Status (5)

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

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 (https=) * 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
JP6985279B2 (ja) 2016-08-22 2021-12-22 オラクル・インターナショナル・コーポレイション パターン分解を通してデータ変換を推論するためのシステムおよび方法
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

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1763696A (zh) * 2005-05-23 2006-04-26 威盛电子股份有限公司 数据传输系统及其链接电源状态改变方法
US20100005366A1 (en) * 2008-07-01 2010-01-07 International Business Machines Corporation Cascade interconnect memory system with enhanced reliability

Family Cites Families (24)

* 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
US7581189B2 (en) * 2005-09-09 2009-08-25 Microsoft Corporation Dynamically generating a database report during a report building process
JPWO2007083371A1 (ja) 2006-01-18 2009-06-11 富士通株式会社 データ統合装置、データ統合方法およびデータ統合プログラムを記録したコンピュータ読み取り可能な記録媒体
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
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1763696A (zh) * 2005-05-23 2006-04-26 威盛电子股份有限公司 数据传输系统及其链接电源状态改变方法
CN100373297C (zh) * 2005-05-23 2008-03-05 威盛电子股份有限公司 数据传输系统及其链接电源状态改变方法
US20100005366A1 (en) * 2008-07-01 2010-01-07 International Business Machines Corporation Cascade interconnect memory system with enhanced reliability

Also Published As

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

Similar Documents

Publication Publication Date Title
CN105339941B (zh) 针对etl映射设计使用投影器和选择器组件类型
CN105359141B (zh) 支持基于流的etl和基于实体关系的etl的组合
US10073867B2 (en) System and method for code generation from a directed acyclic graph using knowledge modules
CN112685385A (zh) 一种用于智慧城市建设的大数据平台
US12348527B2 (en) Tenant-specific solution subscriptions for an extensibility platform
US12511199B2 (en) Disaster recovery in a cell model for an extensibility platform
CN107103064A (zh) 数据统计方法及装置
US20140229223A1 (en) Integrated erp based planning
US12547390B2 (en) Flexible meta model (FMM) for an extensibility platform
CN117289916B (zh) 数智化PaaS平台系统
US20230315428A1 (en) Extensibility platform
Park et al. Towards reliable business process simulation: a framework to integrate ERP systems
Ivanov et al. A hot decomposition procedure: Operational monolith system to microservices
CN118626496B (zh) 数据集成方法、装置、服务器、介质及程序
CN112988695B (zh) 一种超融合混合架构计算材料平台
CN119718413A (zh) 一种基于配置化的政企客户业务自服务的系统
US20230315514A1 (en) Configuration-driven data processing pipeline for an extensibility platform
CN117493542A (zh) 一种多维技术融合的可视化大屏平台
US9754228B2 (en) Integrating software solutions to execute business applications
Nikkanen Design and assessment of a generic architecture for industrial process quality classification
US20260120020A1 (en) Systems and methods for multi-level process orchestration and status management
Kadadi Challenges of data integration in big data
Sharma et al. Three Layered Crud API Architecture
CN121659503A (zh) 海上石油平台数字孪生平台构建方法
Correia Entrega Contínua de Aplicações em Ambientes Híbridos

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant