JP5744187B2 - データ統合のためのスキーマコントラクト - Google Patents

データ統合のためのスキーマコントラクト Download PDF

Info

Publication number
JP5744187B2
JP5744187B2 JP2013512257A JP2013512257A JP5744187B2 JP 5744187 B2 JP5744187 B2 JP 5744187B2 JP 2013512257 A JP2013512257 A JP 2013512257A JP 2013512257 A JP2013512257 A JP 2013512257A JP 5744187 B2 JP5744187 B2 JP 5744187B2
Authority
JP
Japan
Prior art keywords
data
input
column
columns
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.)
Expired - Fee Related
Application number
JP2013512257A
Other languages
English (en)
Japanese (ja)
Other versions
JP2013533995A (ja
JP2013533995A5 (enExample
Inventor
キャロル マシュー
キャロル マシュー
ノア デービッド
ノア デービッド
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.)
Microsoft Corp
Original Assignee
Microsoft 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 Microsoft Corp filed Critical Microsoft Corp
Publication of JP2013533995A publication Critical patent/JP2013533995A/ja
Publication of JP2013533995A5 publication Critical patent/JP2013533995A5/ja
Application granted granted Critical
Publication of JP5744187B2 publication Critical patent/JP5744187B2/ja
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/84—Mapping; Conversion
    • G06F16/86—Mapping to a database
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
    • G06F16/83—Querying
    • G06F16/835—Query processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (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)
  • Stored Programmes (AREA)
JP2013512257A 2010-05-27 2011-05-26 データ統合のためのスキーマコントラクト Expired - Fee Related JP5744187B2 (ja)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US12/788,310 US8799299B2 (en) 2010-05-27 2010-05-27 Schema contracts for data integration
US12/788,310 2010-05-27
PCT/US2011/038227 WO2011150271A2 (en) 2010-05-27 2011-05-26 Schema contracts for data integration

Publications (3)

Publication Number Publication Date
JP2013533995A JP2013533995A (ja) 2013-08-29
JP2013533995A5 JP2013533995A5 (enExample) 2014-07-03
JP5744187B2 true JP5744187B2 (ja) 2015-07-01

Family

ID=45004839

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2013512257A Expired - Fee Related JP5744187B2 (ja) 2010-05-27 2011-05-26 データ統合のためのスキーマコントラクト

Country Status (6)

Country Link
US (1) US8799299B2 (enExample)
EP (1) EP2577519A4 (enExample)
JP (1) JP5744187B2 (enExample)
CN (1) CN102298607B (enExample)
AU (1) AU2011258098B2 (enExample)
WO (1) WO2011150271A2 (enExample)

Families Citing this family (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP5601066B2 (ja) * 2010-07-23 2014-10-08 富士通株式会社 情報統合プログラム、装置及び方法
US8484255B2 (en) * 2010-12-03 2013-07-09 Sap Ag Automatic conversion of multidimentional schema entities
US9053576B2 (en) * 2010-12-21 2015-06-09 International Business Machines Corporation Identifying reroutable data columns in an ETL process
US8930330B1 (en) * 2011-06-27 2015-01-06 Amazon Technologies, Inc. Validation of log formats
US8572122B2 (en) * 2011-12-29 2013-10-29 Sap Ag Data schema and language
US8583631B1 (en) * 2013-01-31 2013-11-12 Splunk Inc. Metadata tracking for a pipelined search language (data modeling for fields)
US9323793B2 (en) 2013-03-13 2016-04-26 International Business Machines Corporation Control data driven modifications and generation of new schema during runtime operations
US9892134B2 (en) 2013-03-13 2018-02-13 International Business Machines Corporation Output driven generation of a combined schema from a plurality of input data schemas
US9104707B1 (en) * 2013-03-14 2015-08-11 Amazon Technologies, Inc. Iterative generation of partial column schema
US9613124B2 (en) 2013-05-30 2017-04-04 ClearStory Data Inc. Apparatus and method for state management across visual transitions
CN103336843B (zh) * 2013-07-18 2017-02-15 山东中创软件工程股份有限公司 一种数据集成方法及装置
CN104601358B (zh) * 2013-11-01 2019-01-04 中兴通讯股份有限公司 一种实现采集系统与分析系统间的匹配方法及装置
US9881032B2 (en) 2014-06-13 2018-01-30 Business Objects Software Limited Personal objects using data specification language
CN104361086A (zh) * 2014-11-14 2015-02-18 国电南瑞科技股份有限公司 一种计量资产全寿命周期管理系统数据集成方法
US9916140B2 (en) 2015-03-23 2018-03-13 International Business Machines Corporation Method of generating end-to-end web application from tooling
CN105354616A (zh) * 2015-12-18 2016-02-24 国电南瑞科技股份有限公司 一种电力计量资产数据处理装置及其在线处理方法
WO2018039251A1 (en) 2016-08-22 2018-03-01 Oracle International Corporation System and method for inferencing of data transformations through pattern decomposition
US10650048B2 (en) * 2016-09-09 2020-05-12 Baidu Usa Llc Managing complex service dependencies in a data integration system
US10459774B2 (en) * 2016-10-31 2019-10-29 General Electric Company Self-aware and self-registering software and analytics platform components
US10481874B2 (en) * 2016-10-31 2019-11-19 General Electric Company System architecture for secure and rapid development, deployment and management of analytics and software systems
US10545984B2 (en) * 2017-05-23 2020-01-28 Sap Se Abstract default column type in tables
CN107451175B (zh) * 2017-05-23 2020-01-31 创新先进技术有限公司 一种基于区块链的数据处理方法及设备
US20190332697A1 (en) * 2018-04-26 2019-10-31 Hewlett-Packard Development Company, L.P. Database schema validations
US11232139B2 (en) 2018-06-29 2022-01-25 Lucid Software, Inc. Custom interactions with visualizations
US11870847B2 (en) * 2019-01-21 2024-01-09 EMC IP Holding Company LLC Decentralized data flow valuation and deployment
EP3915024A4 (en) 2019-02-22 2022-10-26 Lucid Software, Inc. REVERSIBLE DATA TRANSFORMATIONS
US11100173B2 (en) * 2019-06-18 2021-08-24 Lucid Software, Inc. Autolayout of visualizations based on graph data
US11263105B2 (en) 2019-11-26 2022-03-01 Lucid Software, Inc. Visualization tool for components within a cloud infrastructure
US11169671B2 (en) 2019-11-26 2021-11-09 Lucid Software, Inc. Alteration of a source data visualization based on user input
US12169486B2 (en) * 2022-10-19 2024-12-17 Snowflake Inc. File-based error handling during ingestion with transformation

Family Cites Families (35)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6263492B1 (en) 1997-06-06 2001-07-17 Microsoft Corporation Run time object layout model with object type that differs from the derived object type in the class structure at design time and the ability to store the optimized run time object layout model
US7885981B2 (en) * 2000-10-31 2011-02-08 Michael Philip Kaufman System and method for generating automatic user interface for arbitrarily complex or large databases
US20030105732A1 (en) 2000-11-17 2003-06-05 Kagalwala Raxit A. Database schema for structure query language (SQL) server
JP2003099298A (ja) * 2001-09-21 2003-04-04 Nippon Telegr & Teleph Corp <Ntt> データ変換方法およびデータ変換装置
US7000238B2 (en) 2001-10-10 2006-02-14 Borland Software Corporation Development system providing extensible remoting architecture
JP2003177948A (ja) * 2001-12-07 2003-06-27 Fujitsu Ltd データの変換・流通を行うデータ管理機構
US20040003341A1 (en) * 2002-06-20 2004-01-01 Koninklijke Philips Electronics N.V. Method and apparatus for processing electronic forms for use with resource constrained devices
JP2004030221A (ja) * 2002-06-26 2004-01-29 Hitachi Ltd 変更対象テーブル自動検出方法
US20040083199A1 (en) * 2002-08-07 2004-04-29 Govindugari Diwakar R. Method and architecture for data transformation, normalization, profiling, cleansing and validation
US20040158567A1 (en) * 2003-02-12 2004-08-12 International Business Machines Corporation Constraint driven schema association
US7546226B1 (en) 2003-03-12 2009-06-09 Microsoft Corporation Architecture for automating analytical view of business applications
US20050102303A1 (en) * 2003-11-12 2005-05-12 International Business Machines Corporation Computer-implemented method, system and program product for mapping a user data schema to a mining model schema
US6976029B2 (en) * 2004-02-10 2005-12-13 Microsoft Corporation System and method for providing user defined types in a database system
JP4473026B2 (ja) * 2004-03-31 2010-06-02 三菱電機株式会社 データ交換計算機
US7805341B2 (en) * 2004-04-13 2010-09-28 Microsoft Corporation Extraction, transformation and loading designer module of a computerized financial system
US7581204B2 (en) 2004-06-01 2009-08-25 Sap Ag Dynamic contexts
US20050278653A1 (en) 2004-06-10 2005-12-15 Martin Scholz Automatic selection of user interface controls
US20060259456A1 (en) * 2005-05-10 2006-11-16 Alexander Falk System for describing text file formats in a flexible, reusable way to facilitate text file transformations
US7634515B2 (en) * 2005-05-13 2009-12-15 Microsoft Corporation Data model and schema evolution
US7849049B2 (en) * 2005-07-05 2010-12-07 Clarabridge, Inc. Schema and ETL tools for structured and unstructured data
US8275810B2 (en) * 2005-07-05 2012-09-25 Oracle International Corporation Making and using abstract XML representations of data dictionary metadata
US20070074155A1 (en) * 2005-09-23 2007-03-29 Business Objects, S.A. Apparatus and method for data profile based construction of an extraction, transform, load (etl) task
US7571175B2 (en) 2005-09-23 2009-08-04 Sap Ag Transformation directives in datatype definitions
US7509655B2 (en) 2006-08-30 2009-03-24 Microsoft Corporation Integration of workflow and rules
JP2008108144A (ja) * 2006-10-26 2008-05-08 Hitachi Ltd 情報処理方法、情報処理装置、およびプログラム
US7774301B2 (en) * 2006-12-21 2010-08-10 International Business Machines Corporation Use of federation services and transformation services to perform extract, transform, and load (ETL) of unstructured information and associated metadata
US8768978B2 (en) * 2007-07-30 2014-07-01 Hewlett-Packard Development Company, L.P. Single-operation on-line schema evolution
US8103704B2 (en) * 2007-07-31 2012-01-24 ePrentise, LLC Method for database consolidation and database separation
US20090043778A1 (en) 2007-08-08 2009-02-12 Microsoft Corporation Generating etl packages from template
US20090055439A1 (en) * 2007-08-24 2009-02-26 Ketera Technologies, Inc. Flexible Dimension Approach In A Data Warehouse
US20100017395A1 (en) * 2008-07-16 2010-01-21 Sapphire Information Systems Ltd. Apparatus and methods for transforming relational queries into multi-dimensional queries
US8180810B2 (en) * 2008-08-21 2012-05-15 International Business Machines Corporation Interactive generation of integrated schemas
US8209341B2 (en) * 2008-09-30 2012-06-26 International Business Machines Corporation Configurable transformation macro
US8700560B2 (en) * 2008-10-17 2014-04-15 Business Objects S.A. Populating a multi-relational enterprise social network with disparate source data
CN101477547B (zh) * 2009-01-20 2011-05-11 中国测绘科学研究院 一种基于规则的空间数据整合方法

Also Published As

Publication number Publication date
AU2011258098A1 (en) 2012-12-13
CN102298607B (zh) 2016-08-17
WO2011150271A3 (en) 2012-03-15
WO2011150271A2 (en) 2011-12-01
EP2577519A2 (en) 2013-04-10
EP2577519A4 (en) 2016-06-15
AU2011258098B2 (en) 2014-06-26
US20110295865A1 (en) 2011-12-01
JP2013533995A (ja) 2013-08-29
US8799299B2 (en) 2014-08-05
CN102298607A (zh) 2011-12-28

Similar Documents

Publication Publication Date Title
JP5744187B2 (ja) データ統合のためのスキーマコントラクト
JP5197688B2 (ja) 統合環境生成器
US10521427B2 (en) Managing data queries
US9552335B2 (en) Expedited techniques for generating string manipulation programs
CN103180826B (zh) 在代表计算机程序的数据流图中管理数据集对象
CN103164249B (zh) 用于脚本语言编译器的扩展机制
US9665620B2 (en) Managing data queries
US9424003B1 (en) Schema-less system output object parser and code generator
CN104020994B (zh) 基于流系统的流过程定义装置和流过程定义方法
US8140596B2 (en) System and method for the derivation and application of sub-iteration contexts in a transformation operation in a data integration system
US7941460B2 (en) Compilation model for processing hierarchical data in stream systems
CN106104468B (zh) 动态地确定数据处理应用程序的模式
CN105354036A (zh) 数据库操作代码生成方法及装置
US20200265028A1 (en) Method and systems for mapping object oriented/functional languages to database languages
WO2015019504A1 (ja) 検証方法、検証装置および検証プログラム
US8413109B2 (en) Systems and methods for metamodel transformation
US9244706B2 (en) Command line shell command generation based on schema
CN114879978B (zh) 软件包依赖关系的处理方法、计算设备及可读存储介质
CN117992337A (zh) 一种高性能规则验证方法、系统、存储介质及电子设备
WO2005073867A1 (en) Converting a heterogeneous document
US8775873B2 (en) Data processing apparatus that performs test validation and computer-readable storage medium
JP7591649B2 (ja) データベースで実行するためのコンピュータプログラムの動作の変換
JPWO2011090032A1 (ja) 並列処理プログラム生成方法、並列処理プログラム生成プログラム、及び並列処理プログラム生成装置
Wei et al. Efficient service variant analysis with Markov updates in Monte Carlo tree search (Short Paper)
JP2012221166A (ja) 計算機、分散並列処理プログラム生成方法、及び、プログラム

Legal Events

Date Code Title Description
RD03 Notification of appointment of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7423

Effective date: 20130703

RD04 Notification of resignation of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7424

Effective date: 20130717

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20140514

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20140514

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20150216

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20150220

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20150310

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

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20150428

R150 Certificate of patent or registration of utility model

Ref document number: 5744187

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

S111 Request for change of ownership or part of ownership

Free format text: JAPANESE INTERMEDIATE CODE: R313113

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

LAPS Cancellation because of no payment of annual fees