JP2009544064A5 - - Google Patents

Download PDF

Info

Publication number
JP2009544064A5
JP2009544064A5 JP2009502890A JP2009502890A JP2009544064A5 JP 2009544064 A5 JP2009544064 A5 JP 2009544064A5 JP 2009502890 A JP2009502890 A JP 2009502890A JP 2009502890 A JP2009502890 A JP 2009502890A JP 2009544064 A5 JP2009544064 A5 JP 2009544064A5
Authority
JP
Japan
Prior art keywords
application
database
view
data
update
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
JP2009502890A
Other languages
English (en)
Japanese (ja)
Other versions
JP2009544064A (ja
JP5064483B2 (ja
Filing date
Publication date
Priority claimed from US11/725,206 external-priority patent/US7680767B2/en
Application filed filed Critical
Publication of JP2009544064A publication Critical patent/JP2009544064A/ja
Publication of JP2009544064A5 publication Critical patent/JP2009544064A5/ja
Application granted granted Critical
Publication of JP5064483B2 publication Critical patent/JP5064483B2/ja
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

JP2009502890A 2006-03-23 2007-03-22 増分ビューの保守を用いたマッピングアーキテクチャ Active JP5064483B2 (ja)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US78567206P 2006-03-23 2006-03-23
US60/785,672 2006-03-23
US11/725,206 2007-03-16
US11/725,206 US7680767B2 (en) 2006-03-23 2007-03-16 Mapping architecture with incremental view maintenance
PCT/US2007/007261 WO2007112009A1 (en) 2006-03-23 2007-03-22 Mapping architecture with incremental view maintenance

Publications (3)

Publication Number Publication Date
JP2009544064A JP2009544064A (ja) 2009-12-10
JP2009544064A5 true JP2009544064A5 (enExample) 2010-05-13
JP5064483B2 JP5064483B2 (ja) 2012-10-31

Family

ID=38534796

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2009502890A Active JP5064483B2 (ja) 2006-03-23 2007-03-22 増分ビューの保守を用いたマッピングアーキテクチャ

Country Status (12)

Country Link
US (1) US7680767B2 (enExample)
EP (1) EP2008206B1 (enExample)
JP (1) JP5064483B2 (enExample)
KR (1) KR101411083B1 (enExample)
CN (1) CN101405729B (enExample)
AT (1) ATE528720T1 (enExample)
AU (1) AU2007231006B2 (enExample)
BR (1) BRPI0709108A2 (enExample)
CA (1) CA2643699C (enExample)
MX (1) MX2008011651A (enExample)
RU (1) RU2441273C2 (enExample)
WO (1) WO2007112009A1 (enExample)

Families Citing this family (121)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093495B (zh) * 2006-06-22 2011-08-17 国际商业机器公司 基于网状关系维的数据处理方法和系统
US8156149B2 (en) * 2007-07-24 2012-04-10 Microsoft Corporation Composite nested streams
US7996416B2 (en) * 2007-08-31 2011-08-09 Red Hat, Inc. Parameter type prediction in object relational mapping
US8423955B2 (en) * 2007-08-31 2013-04-16 Red Hat, Inc. Method and apparatus for supporting multiple business process languages in BPM
US9058571B2 (en) * 2007-08-31 2015-06-16 Red Hat, Inc. Tool for automated transformation of a business process definition into a web application package
US8825713B2 (en) * 2007-09-12 2014-09-02 Red Hat, Inc. BPM system portable across databases
US8914804B2 (en) 2007-09-12 2014-12-16 Red Hat, Inc. Handling queues associated with web services of business processes
US7941398B2 (en) * 2007-09-26 2011-05-10 Pentaho Corporation Autopropagation of business intelligence metadata
US20090138500A1 (en) * 2007-10-12 2009-05-28 Yuan Zhiqiang Method of compact display combined with property-table-view for a complex relational data structure
US8429601B2 (en) * 2007-11-29 2013-04-23 Red Hat, Inc. Code completion for object relational mapping query language (OQL) queries
US9336327B2 (en) * 2007-11-30 2016-05-10 Microsoft Technology Licensing, Llc Mapping and query translation between XML, objects, and relations
US8954952B2 (en) * 2007-11-30 2015-02-10 Red Hat, Inc. Portable business process deployment model across different application servers
US8161000B2 (en) * 2008-01-04 2012-04-17 International Business Machines Corporation Generic bijection with graphs
US8166449B2 (en) * 2008-01-17 2012-04-24 Microsoft Corporation Live bidirectional synchronizing of a visual and a textual representation
US20090193004A1 (en) * 2008-01-30 2009-07-30 Business Objects, S.A. Apparatus and method for forming database tables from queries
US8209340B2 (en) * 2008-03-31 2012-06-26 Microsoft Corporation Efficient functional representation of result shaping
US8375014B1 (en) * 2008-06-19 2013-02-12 BioFortis, Inc. Database query builder
US8364750B2 (en) 2008-06-24 2013-01-29 Microsoft Corporation Automated translation of service invocations for batch processing
US8713048B2 (en) * 2008-06-24 2014-04-29 Microsoft Corporation Query processing with specialized query operators
US8375044B2 (en) * 2008-06-24 2013-02-12 Microsoft Corporation Query processing pipelines with single-item and multiple-item query operators
US8819046B2 (en) * 2008-06-24 2014-08-26 Microsoft Corporation Data query translating into mixed language data queries
US8364751B2 (en) * 2008-06-25 2013-01-29 Microsoft Corporation Automated client/server operation partitioning
US8676749B2 (en) * 2008-07-31 2014-03-18 Sybase, Inc. Statement logging in databases
US8176272B2 (en) * 2008-09-04 2012-05-08 International Business Machines Corporation Incremental backup using snapshot delta views
US8285708B2 (en) * 2008-10-21 2012-10-09 Microsoft Corporation Query submission pipeline using LINQ
CN101419616A (zh) * 2008-12-10 2009-04-29 阿里巴巴集团控股有限公司 一种数据同步方法及装置
US9047338B2 (en) 2008-12-17 2015-06-02 International Business Machines Corporation Managing drill-through targets
US8738584B2 (en) * 2009-02-17 2014-05-27 Microsoft Corporation Context-aware management of shared composite data
US8463743B2 (en) * 2009-02-17 2013-06-11 Microsoft Corporation Shared composite data representations and interfaces
US8065323B2 (en) * 2009-02-23 2011-11-22 Oracle International Corporation Offline validation of data in a database system for foreign key constraints
US8150882B2 (en) * 2009-03-03 2012-04-03 Microsoft Corporation Mapping from objects to data model
US8280924B2 (en) * 2009-03-26 2012-10-02 Microsoft Corporation Object-relational mapping with dynamic relational schemas
US9864796B2 (en) * 2009-06-24 2018-01-09 Microsoft Technology Licensing, Llc Databases from models
US8688752B2 (en) * 2009-08-28 2014-04-01 Adobe Sytems Incorporated Method and system for deploying a model-based application to an application server
CA2679786A1 (en) * 2009-09-16 2009-12-16 Ibm Canada Limited - Ibm Canada Limitee Conceptual representation of business processes for cross-domain mapping
US8667028B2 (en) * 2009-09-28 2014-03-04 At&T Global Network Services Deutschland Gmbh System and method to determine database schema impact
US8768947B2 (en) * 2009-12-22 2014-07-01 At&T Global Network Services Deutschland Gmbh System and method for implementing unique primary keys across enterprise databases
JP5090481B2 (ja) * 2010-01-28 2012-12-05 日本電信電話株式会社 データモデリング方法及び装置及びプログラム
US8739118B2 (en) 2010-04-08 2014-05-27 Microsoft Corporation Pragmatic mapping specification, compilation and validation
US8433673B2 (en) * 2010-05-28 2013-04-30 Oracle International Corporation System and method for supporting data warehouse metadata extension using an extender
CN101840230B (zh) * 2010-06-04 2012-02-01 浙江中控技术股份有限公司 一种监控和管理数据的方法及系统
US8843843B2 (en) * 2010-06-25 2014-09-23 International Business Machines Corporation Method and system using heuristics in performing batch updates of records
CA2706741C (en) 2010-06-29 2011-12-13 Ibm Canada Limited - Ibm Canada Limitee Managing parameters in filter expressions
US8566318B1 (en) * 2010-09-10 2013-10-22 Giovanni Sacco Process for physical database design based on transaction workload
US9460189B2 (en) 2010-09-23 2016-10-04 Microsoft Technology Licensing, Llc Data model dualization
US20120094600A1 (en) 2010-10-19 2012-04-19 Welch Allyn, Inc. Platform for patient monitoring
US9477730B2 (en) * 2010-10-28 2016-10-25 Microsoft Technology Licensing, Llc Web services runtime for dataset transformation
US8538963B2 (en) 2010-11-16 2013-09-17 International Business Machines Corporation Optimal persistence of a business process
US20120158763A1 (en) * 2010-12-17 2012-06-21 Microsoft Corporation Bulk operations
US8874601B2 (en) * 2010-12-17 2014-10-28 Sap Ag SADL query view—a model-driven approach to speed-up read-only use cases
US8650151B2 (en) * 2011-01-24 2014-02-11 International Business Machines Corporation Transactional service pipeline
US9141403B2 (en) * 2011-02-15 2015-09-22 Microsoft Technology Licensing, Llc Data-driven schema for describing and executing management tasks in a graphical user interface
CN102104510B (zh) * 2011-03-01 2014-01-29 北京中创信测科技股份有限公司 一种数据视图处理方法和系统
JP5673246B2 (ja) * 2011-03-14 2015-02-18 富士通株式会社 データストア制御装置、データストア制御プログラムおよびデータストア制御方法
US8601007B2 (en) * 2011-05-17 2013-12-03 Microsoft Corporation Net change notification based cached views with linked attributes
US9396284B2 (en) * 2011-05-18 2016-07-19 Oracle International Corporation Method and system for implementing efficient updatable relational views over XML data
US9195769B2 (en) * 2011-07-20 2015-11-24 Opentable, Inc. Method and apparatus for quickly evaluating entities
US8601016B2 (en) 2011-08-30 2013-12-03 International Business Machines Corporation Pre-generation of structured query language (SQL) from application programming interface (API) defined query systems
US9201558B1 (en) 2011-11-03 2015-12-01 Pervasive Software Inc. Data transformation system, graphical mapping tool, and method for creating a schema map
US9430114B1 (en) 2011-11-03 2016-08-30 Pervasive Software Data transformation system, graphical mapping tool, and method for creating a schema map
CN102521401B (zh) * 2011-12-24 2014-10-15 北京数码大方科技股份有限公司 数据视图的处理方法及装置
US8990187B2 (en) 2012-05-21 2015-03-24 Google Inc. Efficient top-down hierarchical join on a hierarchically clustered data stream
US9953353B2 (en) 2012-08-30 2018-04-24 Oracle International Corporation Method and system for implementing an architecture for a sales catalog
US9922303B2 (en) 2012-08-30 2018-03-20 Oracle International Corporation Method and system for implementing product group mappings
US10223697B2 (en) 2012-08-30 2019-03-05 Oracle International Corporation Method and system for implementing a CRM quote and order capture context service
RU2515565C1 (ru) * 2012-10-22 2014-05-10 Закрытое акционерное общество Научно-производственное предприятие "Реляционные экспертные системы" Способ обновления структурированных данных в системе управления реляционными базами данных
US9098546B2 (en) * 2012-12-12 2015-08-04 Sap Se Advanced business query language
US9424304B2 (en) * 2012-12-20 2016-08-23 LogicBlox, Inc. Maintenance of active database queries
CN103092998B (zh) * 2013-02-21 2017-02-08 用友网络科技股份有限公司 数据查询系统和数据查询方法
AU2014233499A1 (en) * 2013-03-15 2015-11-05 Neura Labs Corp. Intelligent internet system with adaptive user interface providing one-step access to knowledge
US10705802B2 (en) 2013-03-20 2020-07-07 Microsoft Technology Licensing, Llc Extensible and queryable strong types
US9734183B2 (en) * 2013-08-08 2017-08-15 Hong Kong Baptist University System and method for performing view updates in database systems
US9342555B2 (en) 2013-08-30 2016-05-17 International Business Machines Corporation Reporting tools for object-relational databases
WO2015035289A1 (en) * 2013-09-06 2015-03-12 Unisys Corporation Business suite framework for developing software applications
CN104519103B (zh) * 2013-09-30 2018-10-26 腾讯科技(北京)有限公司 网络数据的同步处理方法、服务器及相关系统
CN104598374B (zh) 2013-10-30 2017-12-01 国际商业机器公司 校正失效脚本的方法和设备
US20150193852A1 (en) * 2014-01-09 2015-07-09 Cgi Federal, Inc. System and method for multi-user evaluation of healthplan benefit based on prescription coverage annual cost
US9961011B2 (en) 2014-01-21 2018-05-01 Oracle International Corporation System and method for supporting multi-tenancy in an application server, cloud, or other environment
CN105138526B (zh) * 2014-05-30 2019-02-22 国际商业机器公司 用于为关系型数据库自动生成语义映射的方法和系统
CN106462833B (zh) * 2014-06-23 2020-01-14 甲骨文国际公司 用于在多租户应用服务器环境中支持多个分区编辑会话的系统和方法
US10594619B2 (en) 2014-06-23 2020-03-17 Oracle International Corporation System and method for supporting configuration of dynamic clusters in a multitenant application server environment
WO2016011677A1 (en) * 2014-07-25 2016-01-28 Hewlett-Packard Development Company, L.P. Local database cache
US20160070541A1 (en) * 2014-09-08 2016-03-10 Unisys Corporation Conversion of business suite solutions
US10372697B2 (en) 2014-12-19 2019-08-06 International Business Machines Corporation Responding to data requests related to constrained natural language vocabulary terms
CN104731911A (zh) * 2015-03-24 2015-06-24 浪潮集团有限公司 一种数据表与实体类的动态映射及转换方法
US10078676B2 (en) * 2015-04-06 2018-09-18 Sap Se Schema evolution in multi-tenant environment
EP3079065B1 (en) * 2015-04-08 2019-06-12 Huawei Technologies Co., Ltd. Redo-logging for partitioned in-memory datasets
US10872065B1 (en) * 2015-08-03 2020-12-22 Intelligence Designs, LLC System for managing relational databases using XML objects
US11138223B2 (en) * 2015-09-09 2021-10-05 LiveData, Inc. Techniques for uniting multiple databases and related systems and methods
US10970311B2 (en) * 2015-12-07 2021-04-06 International Business Machines Corporation Scalable snapshot isolation on non-transactional NoSQL
US10394775B2 (en) 2015-12-28 2019-08-27 International Business Machines Corporation Order constraint for transaction processing with snapshot isolation on non-transactional NoSQL servers
US10838940B1 (en) * 2016-08-11 2020-11-17 MuleSoft, Inc. Balanced key range based retrieval of key-value database
US10437564B1 (en) 2016-09-16 2019-10-08 Software Tree, LLC Object mapping and conversion system
US11086895B2 (en) 2017-05-09 2021-08-10 Oracle International Corporation System and method for providing a hybrid set-based extract, load, and transformation of data
US10558658B2 (en) * 2017-05-16 2020-02-11 Sap Se Propagation of structured query language associations
US10521223B1 (en) 2017-08-22 2019-12-31 Wells Fargo Bank, N.A. Systems and methods of a metadata orchestrator augmenting application development
US11138157B2 (en) 2017-08-30 2021-10-05 Jpmorgan Chase Bank, N.A. System and method for identifying business logic and data lineage with machine learning
US10698884B2 (en) * 2017-11-06 2020-06-30 Bank Of America Corporation Dynamic lineage validation system
CN108038665B (zh) * 2017-12-08 2020-01-24 平安科技(深圳)有限公司 业务规则管理方法、装置、设备及计算机可读存储介质
US11106820B2 (en) * 2018-03-19 2021-08-31 International Business Machines Corporation Data anonymization
US11226854B2 (en) * 2018-06-28 2022-01-18 Atlassian Pty Ltd. Automatic integration of multiple graph data structures
US11036497B1 (en) 2018-10-24 2021-06-15 Cerner Innovation, Inc. Code assessment for quality control of an object relational mapper and correction of problematic cast functions
US11086868B2 (en) * 2019-10-29 2021-08-10 Oracle International Corporation Materialized view rewrite technique for one-sided outer-join queries
US11210285B2 (en) 2020-03-06 2021-12-28 Ab Initio Technology Llc Generation of optimized logic from a schema
CN111798311A (zh) * 2020-07-22 2020-10-20 睿智合创(北京)科技有限公司 基于大数据的银行风险分析库平台、搭建方法及可读介质
CN111984977B (zh) * 2020-08-06 2022-07-19 成都安恒信息技术有限公司 一种基于运维审计系统的多租户权限鉴权方法
CN112416704A (zh) * 2020-11-10 2021-02-26 北京三快在线科技有限公司 一种检测系统故障的方法及装置
US12174887B2 (en) * 2020-11-10 2024-12-24 Sap Se Mapping expression generator
EP4030313B1 (en) * 2021-01-13 2025-10-01 Sage Global Services Limited Sql statement generator
IL289482B2 (en) * 2021-01-15 2025-02-01 Drivenets Ltd A Distributed Database System
US12001416B1 (en) * 2021-04-20 2024-06-04 The Travelers Indemnity Company Systems and methods for generic data parsing applications
US12153560B1 (en) * 2021-07-07 2024-11-26 Tableau Software, LLC Database normalization using statistical analysis
US11829735B2 (en) 2021-07-14 2023-11-28 Bank Of America Corporation Artificial intelligence (AI) framework to identify object-relational mapping issues in real-time
US12327092B2 (en) 2021-07-14 2025-06-10 Bank Of America Corporation Artificial intelligence (AI) framework to identify object-relational mapping issues in real-time
US12411853B2 (en) * 2021-09-22 2025-09-09 Sap Se Centralized metadata repository with relevancy identifiers
US11797552B2 (en) 2021-10-01 2023-10-24 Sap Se System and method for selective retrieval of metadata artefact versions
US12141161B1 (en) * 2022-06-22 2024-11-12 Amazon Technologies, Inc. Automated non-relational to relational database streaming
US12423299B2 (en) * 2023-05-05 2025-09-23 Jpmorgan Chase Bank, N.A. Method and system for imitation conversion fixes between Structured Query Language (SQL) dialects
US12386850B1 (en) 2023-08-08 2025-08-12 Eygs Llp Systems and methods to convert data according to a schema
US12099883B1 (en) 2023-10-27 2024-09-24 Eygs Llp Systems and methods to generate machine-executable programs configured to present data in cloud environments
EP4589396A1 (en) * 2024-01-22 2025-07-23 Abb Schweiz Ag A computer-implemented method for configuring a component with an opc ua server in an industrial plant

Family Cites Families (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5504885A (en) * 1993-06-29 1996-04-02 Texas Instruments Incorporated O-R gateway: a system for connecting object-oriented application programs and relational databases
US5907846A (en) * 1996-06-07 1999-05-25 Electronic Data Systems Corporation Method and system for accessing relational databases using objects
US6058391A (en) * 1997-12-17 2000-05-02 Mci Communications Corporation Enhanced user view/update capability for managing data from relational tables
US6175837B1 (en) * 1998-06-29 2001-01-16 Sun Microsystems, Inc. Object-relational mapping toll that processes views
US6718320B1 (en) * 1998-11-02 2004-04-06 International Business Machines Corporation Schema mapping system and method
US6421658B1 (en) * 1999-07-30 2002-07-16 International Business Machines Corporation Efficient implementation of typed view hierarchies for ORDBMS
US6618733B1 (en) * 2000-04-11 2003-09-09 Revelink Inc. View navigation for creation, update and querying of data objects and textual annotations of relations between data objects
US6795825B2 (en) * 2000-09-12 2004-09-21 Naphtali David Rishe Database querying system and method
US6915305B2 (en) * 2001-08-15 2005-07-05 International Business Machines Corporation Restructuring view maintenance system and method
US6865569B1 (en) * 2001-08-22 2005-03-08 Ncr Corporation Determining materialized view coverage
EP1349081A1 (en) * 2002-03-28 2003-10-01 LION Bioscience AG Method and apparatus for querying relational databases
US7263512B2 (en) * 2002-04-02 2007-08-28 Mcgoveran David O Accessing and updating views and relations in a relational database
US6954748B2 (en) * 2002-04-25 2005-10-11 International Business Machines Corporation Remote data access and integration of distributed data sources through data schema and query abstraction
AU2002953555A0 (en) * 2002-12-23 2003-01-16 Canon Kabushiki Kaisha Method for presenting hierarchical data
CA2438997A1 (en) * 2003-08-28 2005-02-28 Ibm Canada Limited - Ibm Canada Limitee System and method for carrying out legacy application transitions
US7739223B2 (en) * 2003-08-29 2010-06-15 Microsoft Corporation Mapping architecture for arbitrary data models
CN100498766C (zh) * 2003-12-02 2009-06-10 天津曙光计算机产业有限公司 基于数据库的海量文件管理系统与方法
US8150893B2 (en) * 2004-12-29 2012-04-03 Alcatel Lucent Method and apparatus for incremental evaluation of schema-directed XML publishing
US20060195460A1 (en) * 2005-02-28 2006-08-31 Microsoft Corporation Data model for object-relational data
US7685561B2 (en) * 2005-02-28 2010-03-23 Microsoft Corporation Storage API for a common data platform
US7853961B2 (en) * 2005-02-28 2010-12-14 Microsoft Corporation Platform for data services across disparate application frameworks
US7676493B2 (en) * 2005-09-07 2010-03-09 Microsoft Corporation Incremental approach to an object-relational solution
US7440957B1 (en) * 2005-11-30 2008-10-21 At&T Intellectual Property Ii, L.P. Updates through views
US7467128B2 (en) * 2006-02-15 2008-12-16 Microsoft Corporation Maintenance of materialized outer-join views

Similar Documents

Publication Publication Date Title
JP2009544064A5 (enExample)
US11360976B2 (en) Deployment of javascript and typescript stored procedures and user-defined functions into database management systems
RU2008137769A (ru) Архитектура отображения с поддержанием инкрементного представления
US9646041B2 (en) Testing of inactive design-time artifacts
CN101930469B (zh) 调度数据服务平台中跨平台多异构数据库的通用数据访问方法
JP2018514012A5 (enExample)
JP2013522769A5 (enExample)
CN105956087A (zh) 数据及代码版本管理系统及方法
JP2008544400A5 (enExample)
US10769139B2 (en) System and method for implementing query tagging
CN101223505A (zh) 数据中心工作流
WO2018035799A1 (zh) 数据查询方法、应用和数据库服务器、中间件及系统
WO2019041441A1 (zh) 列表视图的更新装置、方法及计算机可读存储介质
CN104537129A (zh) 一种基于Web的数据库虚拟存储处理方法
JP2015180991A (ja) 画像形成装置、画像形成装置の制御方法およびプログラム
WO2019034066A1 (zh) 一种页面更新方法和装置
EP3462341B1 (en) Local identifiers for database objects
US9513879B2 (en) Model augmentation in a model-driven application development environment
Asaad et al. NoSQL databases–seek for a design methodology
US7860894B2 (en) Template driven type and mode conversion
CN104239412A (zh) 数据存储库中应用至存储库的数据映射及相关方法、系统和计算机可读介质
US9864796B2 (en) Databases from models
US20200174804A1 (en) Graphical User Interface Command Pattern
CN104765800A (zh) 一种基于大数据的高效搜索方法
US20210405982A1 (en) Bytecode transformations using virtual artifacts