CN116547659A - 用于在分析应用环境中使用分段查询模型的系统和方法 - Google Patents

用于在分析应用环境中使用分段查询模型的系统和方法 Download PDF

Info

Publication number
CN116547659A
CN116547659A CN202180073687.XA CN202180073687A CN116547659A CN 116547659 A CN116547659 A CN 116547659A CN 202180073687 A CN202180073687 A CN 202180073687A CN 116547659 A CN116547659 A CN 116547659A
Authority
CN
China
Prior art keywords
data
semantic
semantic model
changes
model
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.)
Pending
Application number
CN202180073687.XA
Other languages
English (en)
Chinese (zh)
Inventor
J·库提卡特
A·文卡塔
P·安南塔莫西
B·克里斯南
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 CN116547659A publication Critical patent/CN116547659A/zh
Pending legal-status Critical Current

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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
    • 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
    • G06F16/213—Schema design and management with details for schema evolution support
    • 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
    • G06F16/258—Data format conversion from or 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Stored Programmes (AREA)
CN202180073687.XA 2020-09-25 2021-09-22 用于在分析应用环境中使用分段查询模型的系统和方法 Pending CN116547659A (zh)

Applications Claiming Priority (7)

Application Number Priority Date Filing Date Title
US202063083319P 2020-09-25 2020-09-25
US63/083,319 2020-09-25
US17/376,903 US12216651B2 (en) 2020-09-25 2021-07-15 System and method for semantic model action sets and replay in an analytic applications environment
US17/376,890 2021-07-15
US17/376,895 2021-07-15
US17/376,903 2021-07-15
PCT/US2021/051588 WO2022066795A1 (en) 2020-09-25 2021-09-22 System and method for use of a fragmented query model in an analytic applications environment

Publications (1)

Publication Number Publication Date
CN116547659A true CN116547659A (zh) 2023-08-04

Family

ID=80821253

Family Applications (2)

Application Number Title Priority Date Filing Date
CN202180073687.XA Pending CN116547659A (zh) 2020-09-25 2021-09-22 用于在分析应用环境中使用分段查询模型的系统和方法
CN202180073726.6A Pending CN116438528A (zh) 2020-09-25 2021-09-22 用于在分析应用环境中的语义模型动作集和重放的系统和方法

Family Applications After (1)

Application Number Title Priority Date Filing Date
CN202180073726.6A Pending CN116438528A (zh) 2020-09-25 2021-09-22 用于在分析应用环境中的语义模型动作集和重放的系统和方法

Country Status (5)

Country Link
US (4) US12216650B2 (enExample)
EP (2) EP4217882A1 (enExample)
JP (3) JP7772782B2 (enExample)
CN (2) CN116547659A (enExample)
WO (2) WO2022066795A1 (enExample)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113039527B (zh) 2019-05-06 2025-03-18 甲骨文国际公司 用于在分析应用环境中进行定制的系统和方法
US12216650B2 (en) 2020-09-25 2025-02-04 Oracle International Corporation System and method for use of a fragmented query model in an analytic applications environment
US12549630B2 (en) 2022-07-29 2026-02-10 The Toronto-Dominion Bank System and method for managing data stored in a remote computing environment
US12032568B2 (en) * 2022-09-19 2024-07-09 Sap Se Multi-layer extensibility for enterprise portal
US20240231960A9 (en) * 2022-10-25 2024-07-11 Sap Se Software extension via semantic model
US12405875B2 (en) * 2023-06-29 2025-09-02 Dell Products L.P. Managing integration of new data for data pipelines
US12461898B2 (en) 2023-06-29 2025-11-04 Dell Products L.P. Remediating a change in a system of representation of information in data used by a data pipeline
US12561143B2 (en) 2023-06-29 2026-02-24 Dell Products L.P. System and method for remediating misalignment of a data pipeline
US12468541B2 (en) 2023-06-29 2025-11-11 Dell Products L.P. Curating anomalous data for use in a data pipeline through interaction with a data source
US12430008B2 (en) 2023-06-29 2025-09-30 Dell Products L.P. Managing data pipelines using graphical user interfaces
US12464000B2 (en) 2023-06-29 2025-11-04 Dell Products L.P. Identifying poisoned data during data curation using false positive detection
CN121563982A (zh) * 2026-01-22 2026-02-24 山东鑫海矿业技术装备股份有限公司 一种用于检测磷矿浮选泡沫层品位的视觉分析系统

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1592291A (zh) * 2003-08-28 2005-03-09 国际商业机器公司 管理服务状态数据的方法和系统
US20100161648A1 (en) * 2008-12-19 2010-06-24 Peter Eberlein Flexible multi-tenant support of metadata extension
US20110295793A1 (en) * 2010-05-28 2011-12-01 Oracle International Corporation System and method for providing data flexibility in a business intelligence server using an administration tool
CN102576363A (zh) * 2009-09-29 2012-07-11 渣普控股有限公司 扩展商业智能系统的形式和功能的基于内容的方法
US20140156643A1 (en) * 2012-12-04 2014-06-05 International Business Machines Corporation Enabling business intelligence applications to query semantic models
US20140229511A1 (en) * 2013-02-11 2014-08-14 David Tung Metadata manager for analytics system
US20160179877A1 (en) * 2014-12-23 2016-06-23 Dennis Koerner Analytic solution with a self-learning and context-sensitive semantic layer

Family Cites Families (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7698348B2 (en) * 2003-12-19 2010-04-13 Kinaxis Holdings Inc. Extended database engine providing versioning and embedded analytics
US7739292B2 (en) * 2005-09-28 2010-06-15 Altova Gmbh System and method for modeling and managing enterprise architecture data and content models and their relationships
US7996855B2 (en) 2006-09-15 2011-08-09 Oracle International Corporation Personal messaging application programming interface for integrating an application with groupware systems
CN101546259B (zh) 2008-03-28 2012-10-03 国际商业机器公司 支持运行时模型扩展的对象关系映射系统和方法
US20090281865A1 (en) 2008-05-08 2009-11-12 Todor Stoitsev Method and system to manage a business process
US8341099B2 (en) 2010-03-12 2012-12-25 Microsoft Corporation Semantics update and adaptive interfaces in connection with information as a service
US8863075B2 (en) * 2011-08-10 2014-10-14 Sap Ag Automated support for distributed platform development
US9529576B2 (en) 2011-09-30 2016-12-27 Oracle International Corporation Systems and methods for object to XML mappings
US8805971B1 (en) 2012-06-15 2014-08-12 Amazon Technologies, Inc. Client-specified schema extensions in cloud computing environments
US9509571B1 (en) 2012-07-25 2016-11-29 NetSuite Inc. First-class component extensions for multi-tenant environments
US9621435B2 (en) 2012-09-07 2017-04-11 Oracle International Corporation Declarative and extensible model for provisioning of cloud based services
JP5656946B2 (ja) * 2012-09-27 2015-01-21 株式会社東芝 データ分析装置及びプログラム
US9294482B2 (en) 2013-07-25 2016-03-22 Oracle International Corporation External platform extensions in a multi-tenant environment
US20150088807A1 (en) 2013-09-25 2015-03-26 Infobright Inc. System and method for granular scalability in analytical data processing
US9922104B1 (en) * 2014-08-13 2018-03-20 Numerify, Inc. Metadata driven code-generated external data feeds
US10891272B2 (en) 2014-09-26 2021-01-12 Oracle International Corporation Declarative language and visualization system for recommended data transformations and repairs
US10078676B2 (en) 2015-04-06 2018-09-18 Sap Se Schema evolution in multi-tenant environment
US9990383B2 (en) 2015-05-01 2018-06-05 Ebay Inc. Constructing a data adaptor in an enterprise server data ingestion environment
US10019497B2 (en) * 2015-08-13 2018-07-10 International Business Machines Corporation Data model augmentation
US10635686B2 (en) 2015-10-21 2020-04-28 Oracle International Corporation Extensible attributes for data warehouses
CN107533570B (zh) 2015-10-23 2020-11-03 甲骨文国际公司 用于从表格数据自动推断立方体模式的系统和方法
US11244090B2 (en) 2016-06-01 2022-02-08 The Mathworks, Inc. Systems and methods for extracting adjustable attributes of model components
US10346401B2 (en) * 2016-07-07 2019-07-09 Accenture Global Solutions Limited Query rewriting in a relational data harmonization framework
US10866938B2 (en) 2016-07-29 2020-12-15 Sap Se Automated reshaping and restructuring of storage structures
CN108701257B (zh) 2016-08-22 2023-01-06 甲骨文国际公司 用于实时可视模拟内的动态、增量推荐的系统和方法
US10614091B1 (en) 2016-09-29 2020-04-07 Numerify, Inc. Warehouse based reporting and operational reporting integration
US10628594B2 (en) 2017-01-26 2020-04-21 Sap Se Managing multi-tenant systems using object-oriented models
US20200007556A1 (en) 2017-06-05 2020-01-02 Umajin Inc. Server kit configured to marshal resource calls and methods therefor
US10685034B2 (en) 2017-10-17 2020-06-16 Salesforce.Com, Inc. Systems, methods, and apparatuses for implementing concurrent dataflow execution with write conflict protection within a cloud based computing environment
US11036735B2 (en) 2018-01-16 2021-06-15 Oracle International Corporation Dimension context propagation techniques for optimizing SQL query plans
KR101951719B1 (ko) 2018-07-26 2019-02-25 (주)비아이매트릭스 그래픽 인터페이스 기반으로 이벤트 동작을 프로그래밍 하는 웹 레포팅 디자인 시스템
US11068448B2 (en) * 2019-01-07 2021-07-20 Salesforce.Com, Inc. Archiving objects in a database environment
CN113039527B (zh) 2019-05-06 2025-03-18 甲骨文国际公司 用于在分析应用环境中进行定制的系统和方法
US12309078B2 (en) 2019-08-09 2025-05-20 Oracle International Corporation System and method for supporting a quota policy language in a cloud infrastructure environment
US11138164B1 (en) 2019-11-27 2021-10-05 Amazon Technologies, Inc. Alter table implementation details with schema versioning
US11349917B2 (en) 2020-07-23 2022-05-31 Pure Storage, Inc. Replication handling among distinct networks
US11934957B2 (en) 2020-08-27 2024-03-19 GM Global Technology Operations LLC Methods, systems, and apparatuses for user-understandable explainable learning models
US12216650B2 (en) 2020-09-25 2025-02-04 Oracle International Corporation System and method for use of a fragmented query model in an analytic applications environment

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1592291A (zh) * 2003-08-28 2005-03-09 国际商业机器公司 管理服务状态数据的方法和系统
US20100161648A1 (en) * 2008-12-19 2010-06-24 Peter Eberlein Flexible multi-tenant support of metadata extension
CN102576363A (zh) * 2009-09-29 2012-07-11 渣普控股有限公司 扩展商业智能系统的形式和功能的基于内容的方法
US20120185425A1 (en) * 2009-09-29 2012-07-19 Zap Holdings Limited Content based approach to extending the form and function of a business intelligence system
US20110295793A1 (en) * 2010-05-28 2011-12-01 Oracle International Corporation System and method for providing data flexibility in a business intelligence server using an administration tool
US20140156643A1 (en) * 2012-12-04 2014-06-05 International Business Machines Corporation Enabling business intelligence applications to query semantic models
US20140229511A1 (en) * 2013-02-11 2014-08-14 David Tung Metadata manager for analytics system
US20160179877A1 (en) * 2014-12-23 2016-06-23 Dennis Koerner Analytic solution with a self-learning and context-sensitive semantic layer

Also Published As

Publication number Publication date
US20220100748A1 (en) 2022-03-31
JP2023543996A (ja) 2023-10-19
JP7772782B2 (ja) 2025-11-18
US20220100778A1 (en) 2022-03-31
US20220100749A1 (en) 2022-03-31
JP2026035614A (ja) 2026-03-04
EP4217881A1 (en) 2023-08-02
JP2023543995A (ja) 2023-10-19
US20250124025A1 (en) 2025-04-17
US12216650B2 (en) 2025-02-04
EP4217882A1 (en) 2023-08-02
US11609904B2 (en) 2023-03-21
US12216651B2 (en) 2025-02-04
WO2022066796A1 (en) 2022-03-31
WO2022066795A1 (en) 2022-03-31
CN116438528A (zh) 2023-07-14

Similar Documents

Publication Publication Date Title
US12216650B2 (en) System and method for use of a fragmented query model in an analytic applications environment
JP7611843B2 (ja) 分析アプリケーション環境を用いたデータアナリティクスのためのシステムおよび方法
CN113039527B (zh) 用于在分析应用环境中进行定制的系统和方法
US11615108B2 (en) System and method for running warehouse loads for multiple tenants of a data warehouse
US12265546B2 (en) System and method for automatic generation of BI models using data introspection and curation
EP3107050A1 (en) System for data aggregation and report generation
JP2026027305A (ja) データイントロスペクションおよびキュレーションを使用したｂｉモデルの自動生成のためのシステムおよび方法
US12405967B2 (en) System and method for generating a network graph from analytic artifacts in an analytics environment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination