CA2838500A1 - Enriching database query responses using data from external data sources - Google Patents

Enriching database query responses using data from external data sources Download PDF

Info

Publication number
CA2838500A1
CA2838500A1 CA 2838500 CA2838500A CA2838500A1 CA 2838500 A1 CA2838500 A1 CA 2838500A1 CA 2838500 CA2838500 CA 2838500 CA 2838500 A CA2838500 A CA 2838500A CA 2838500 A1 CA2838500 A1 CA 2838500A1
Authority
CA
Canada
Prior art keywords
data
external data
database query
data source
external
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.)
Abandoned
Application number
CA 2838500
Other languages
English (en)
French (fr)
Inventor
Anthony Nino BICE
David Robinson
Hariharan Sivaramakrishnan
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 Technology Licensing LLC
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 CA2838500A1 publication Critical patent/CA2838500A1/en
Abandoned 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/245—Query processing
    • G06F16/2453—Query optimisation
    • 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/245—Query processing
    • G06F16/2457—Query processing with adaptation to user needs
    • G06F16/24575—Query processing with adaptation to user needs using context
    • 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/23—Updating
    • 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/2425—Iterative querying; Query formulation based on the results of a preceding query
    • 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/2445—Data retrieval commands; View definitions
    • 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/245—Query processing
    • G06F16/2452—Query translation
    • G06F16/24522—Translation of natural language queries to structured queries
    • 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/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471—Distributed queries
    • 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/953—Querying, e.g. by the use of web search engines
    • G06F16/9535—Search customisation based on user profiles and personalisation
    • 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/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • 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/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33—Querying
    • G06F16/335—Filtering based on additional data, e.g. user or group profiles

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Artificial Intelligence (AREA)
  • Fuzzy Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Software Systems (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)
CA 2838500 2011-06-14 2012-06-05 Enriching database query responses using data from external data sources Abandoned CA2838500A1 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US13/159,666 US9122720B2 (en) 2011-06-14 2011-06-14 Enriching database query responses using data from external data sources
US13/159,666 2011-06-14
PCT/US2012/040947 WO2012173823A2 (en) 2011-06-14 2012-06-05 Enriching database query responses using data from external data sources

Publications (1)

Publication Number Publication Date
CA2838500A1 true CA2838500A1 (en) 2012-12-20

Family

ID=47354574

Family Applications (1)

Application Number Title Priority Date Filing Date
CA 2838500 Abandoned CA2838500A1 (en) 2011-06-14 2012-06-05 Enriching database query responses using data from external data sources

Country Status (11)

Country Link
US (4) US9122720B2 (enExample)
EP (1) EP2721533A4 (enExample)
JP (1) JP5940149B2 (enExample)
KR (2) KR102048653B1 (enExample)
CN (1) CN103608810B (enExample)
AU (2) AU2012271083B2 (enExample)
BR (1) BR112013031948A2 (enExample)
CA (1) CA2838500A1 (enExample)
MX (1) MX2013014791A (enExample)
RU (1) RU2611967C2 (enExample)
WO (1) WO2012173823A2 (enExample)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111506644A (zh) * 2019-01-31 2020-08-07 北京神州泰岳软件股份有限公司 一种应用数据处理方法、装置和电子设备

Families Citing this family (50)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9244956B2 (en) 2011-06-14 2016-01-26 Microsoft Technology Licensing, Llc Recommending data enrichments
US9147195B2 (en) 2011-06-14 2015-09-29 Microsoft Technology Licensing, Llc Data custodian and curation system
GB2500567A (en) * 2012-02-01 2013-10-02 Stetfast Ltd Operating software and associated policy rules to carry out data search in order to identify missing or incomplete data
US9613104B2 (en) * 2012-02-17 2017-04-04 Netflix, Inc. System and method for building a point-in-time snapshot of an eventually-consistent data store
US10135677B1 (en) 2012-07-06 2018-11-20 Cradlepoint, Inc. Deployment of network-related features over cloud network
US10560343B1 (en) 2012-07-06 2020-02-11 Cradlepoint, Inc. People centric management of cloud networks via GUI
US10601653B2 (en) * 2012-07-06 2020-03-24 Cradlepoint, Inc. Implicit traffic engineering
US10177957B1 (en) 2012-07-06 2019-01-08 Cradlepoint, Inc. Connecting a cloud network to the internet
US10110417B1 (en) 2012-07-06 2018-10-23 Cradlepoint, Inc. Private networks overlaid on cloud infrastructure
US12450653B2 (en) * 2012-07-31 2025-10-21 The Clearing Corporation Firm trade processing system and method
US9275121B2 (en) * 2013-01-03 2016-03-01 Sap Se Interoperable shared query based on heterogeneous data sources
US9336067B2 (en) * 2013-03-14 2016-05-10 Bmc Software, Inc. Method and system to release IMS resources used by IMS batch application programs
CN111177125B (zh) 2013-03-15 2023-10-31 美国结构数据有限公司 用于分析关注实体特性的设备、系统以及方法
US9251210B2 (en) 2013-04-19 2016-02-02 Oracle International Corporation Caching external data sources for SQL processing
EP2843879A1 (fr) * 2013-09-03 2015-03-04 HAGER CONTROLS (Société par Actions Simplifiée) Configuration d'un réseau domotique
US20150317572A1 (en) * 2014-05-05 2015-11-05 Sap Ag On-Demand Enrichment of Business Data
US10936616B2 (en) * 2014-06-09 2021-03-02 Oracle International Corporation Storage-side scanning on non-natively formatted data
US10019473B2 (en) 2014-06-09 2018-07-10 Oracle International Corporation Accessing an external table in parallel to execute a query
US10120951B2 (en) * 2015-08-12 2018-11-06 Samsung Electronics Co., Ltd. Bifurcated search
WO2017220505A1 (en) 2016-06-24 2017-12-28 Telefonica Digital España, S.L.U A method, system and computer programs for enriching application program interface (api) input information in a telecommunication system
US20180121025A1 (en) * 2016-10-27 2018-05-03 Microsoft Technology Licensing, Llc. Dynamic enrichment of communication items
US10747736B2 (en) * 2016-11-09 2020-08-18 Sap Se Aggregation database for external dataset
US20180293234A1 (en) * 2017-04-10 2018-10-11 Bdna Corporation Curating objects
US12261809B2 (en) * 2017-04-28 2025-03-25 Hrb Innovations, Inc. Context-aware conversational assistant
US11399851B2 (en) 2017-07-11 2022-08-02 Howmedica Osteonics Corp. Guides and instruments for improving accuracy of glenoid implant placement
US10885586B2 (en) * 2017-07-24 2021-01-05 Jpmorgan Chase Bank, N.A. Methods for automatically generating structured pricing models from unstructured multi-channel communications and devices thereof
US10728622B2 (en) 2017-08-25 2020-07-28 Sony Interactive Entertainment LLC Management of non-linear content presentation and experience
CN109947764B (zh) * 2017-09-18 2020-12-22 中国科学院声学研究所 一种基于时延构建弹性现场的查询增强系统及方法
WO2019084213A1 (en) * 2017-10-24 2019-05-02 Baker Hughes, A Ge Company, Llc FEDERATED INTERROGATION
CN110309174A (zh) * 2018-03-02 2019-10-08 阿里巴巴集团控股有限公司 一种数据查询方法、装置和服务器
US10890461B2 (en) 2018-04-30 2021-01-12 International Business Machines Corporation Map enriched by data other than metadata
KR102797073B1 (ko) * 2018-10-18 2025-04-18 삼성전자주식회사 전자 장치 및 이의 제어 방법
US11170002B2 (en) 2018-10-19 2021-11-09 Oracle International Corporation Integrating Kafka data-in-motion with data-at-rest tables
US11048675B2 (en) 2019-01-31 2021-06-29 EMC IP Holding Company LLC Structured data enrichment
US10970272B2 (en) 2019-01-31 2021-04-06 Sap Se Data cloud—platform for data enrichment
US11200234B2 (en) 2019-06-14 2021-12-14 Oracle International Corporation Non-disruptive dynamic ad-hoc database catalog services
US20210034628A1 (en) * 2019-07-29 2021-02-04 Jpmorgan Chase Bank, N.A. Method and system for determining information relevance
AU2020104100A4 (en) * 2020-10-30 2021-02-25 Grafa Pty Ltd An Electronic Data Analysis System and Method
CN112581293A (zh) * 2021-01-30 2021-03-30 陈军 一种金融主体市值计算的方法及系统
CN113190760B (zh) * 2021-05-24 2024-05-17 北京天健智慧科技有限公司 区域健康信息平台的数据处理方法
CN115510082A (zh) * 2021-06-07 2022-12-23 中国移动通信集团重庆有限公司 数据查询方法、装置、系统、电子设备和存储介质
CN113806430A (zh) * 2021-06-07 2021-12-17 广发银行股份有限公司 一种多功能数据管理平台
US11900176B2 (en) * 2021-06-08 2024-02-13 Microsoft Technology Licensing, Llc Interoperability bridge for application hosts
US11741093B1 (en) 2021-07-21 2023-08-29 T-Mobile Usa, Inc. Intermediate communication layer to translate a request between a user of a database and the database
CN113704120A (zh) * 2021-08-31 2021-11-26 平安普惠企业管理有限公司 数据传输方法、装置、设备及存储介质
US12242458B2 (en) 2022-01-31 2025-03-04 Oracle International Corporation Transactional query processing in external tables
US12229130B2 (en) * 2022-03-16 2025-02-18 Business Objects Software Ltd Managing queries for blended data from data models
CN114840547B (zh) * 2022-03-18 2025-03-07 阿里云计算有限公司 一种基于分布式系统的数据查询方法和装置
CN115794922A (zh) * 2022-11-29 2023-03-14 广发银行股份有限公司 一种外部数据查询方法、装置、设备及存储介质
CN117171195A (zh) * 2023-09-06 2023-12-05 中国银行股份有限公司 银行数据副本管理方法、装置、电子设备及存储介质

Family Cites Families (38)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5623652A (en) * 1994-07-25 1997-04-22 Apple Computer, Inc. Method and apparatus for searching for information in a network and for controlling the display of searchable information on display devices in the network
US5608904A (en) * 1995-02-13 1997-03-04 Hewlett-Packard Company Method and apparatus for processing and optimizing queries having joins between structured data and text data
US5913214A (en) * 1996-05-30 1999-06-15 Massachusetts Inst Technology Data extraction from world wide web pages
JP3648051B2 (ja) * 1998-02-02 2005-05-18 富士通株式会社 関連情報検索装置及びプログラム記録媒体
US6763496B1 (en) 1999-03-31 2004-07-13 Microsoft Corporation Method for promoting contextual information to display pages containing hyperlinks
US6343287B1 (en) * 1999-05-19 2002-01-29 Sun Microsystems, Inc. External data store link for a profile service
US7472349B1 (en) * 1999-06-01 2008-12-30 Oracle International Corporation Dynamic services infrastructure for allowing programmatic access to internet and other resources
US7007275B1 (en) * 1999-10-21 2006-02-28 Unisys Corporation Method and apparatus for automatic execution of concatenated methods across multiple heterogeneous data sources
US6618822B1 (en) 2000-01-03 2003-09-09 Oracle International Corporation Method and mechanism for relational access of recovery logs in a database system
US6957214B2 (en) * 2000-06-23 2005-10-18 The Johns Hopkins University Architecture for distributed database information access
JP2002149459A (ja) 2000-11-10 2002-05-24 Mitsubishi Electric Corp 冗長化データベース管理・検索システム
JP4543563B2 (ja) 2001-02-28 2010-09-15 株式会社日立製作所 統合データベースシステムにおける問合せ最適化方法
US6928425B2 (en) * 2001-08-13 2005-08-09 Xerox Corporation System for propagating enrichment between documents
US7133862B2 (en) 2001-08-13 2006-11-07 Xerox Corporation System with user directed enrichment and import/export control
AU2002360793A1 (en) 2001-12-28 2003-07-24 Chijoke Mgbokwee Method and system for adaptive software system interface and external database synchronization
US6993534B2 (en) * 2002-05-08 2006-01-31 International Business Machines Corporation Data store for knowledge-based data mining system
AU2003243635A1 (en) 2002-06-17 2003-12-31 Beingmeta, Inc. Systems and methods for processing queries
US7177874B2 (en) * 2003-01-16 2007-02-13 Jardin Cary A System and method for generating and processing results data in a distributed system
US7146356B2 (en) * 2003-03-21 2006-12-05 International Business Machines Corporation Real-time aggregation of unstructured data into structured data for SQL processing by a relational database engine
EP1482418A1 (en) * 2003-05-28 2004-12-01 Sap Ag A data processing method and system
US7739223B2 (en) * 2003-08-29 2010-06-15 Microsoft Corporation Mapping architecture for arbitrary data models
US20130104251A1 (en) 2005-02-01 2013-04-25 Newsilike Media Group, Inc. Security systems and methods for use with structured and unstructured data
US7882122B2 (en) * 2005-03-18 2011-02-01 Capital Source Far East Limited Remote access of heterogeneous data
WO2006128062A2 (en) * 2005-05-25 2006-11-30 Terracotta, Inc. Database caching of queries and stored procedures using database provided facilities for dependency analysis and detected database updates for invalidation
US7716240B2 (en) * 2005-12-29 2010-05-11 Nextlabs, Inc. Techniques and system to deploy policies intelligently
US8005832B2 (en) 2006-08-29 2011-08-23 Switchbook, Inc. Search document generation and use to provide recommendations
US7571069B1 (en) 2006-12-22 2009-08-04 Hewlett-Packard Development Company, L.P. Data assurance workflow derivation and execution
US20080228716A1 (en) * 2007-03-13 2008-09-18 Dettinger Richard D System and method for accessing unstructured data using a structured database query environment
US8219523B2 (en) 2007-03-23 2012-07-10 Sap Ag Data quality enrichment integration and evaluation system
US7970943B2 (en) * 2007-08-14 2011-06-28 Oracle International Corporation Providing interoperability in software identifier standards
US8972518B2 (en) * 2007-09-20 2015-03-03 Flash Networks Ltd. Integrated data-model and flow based policy system
GB2456184A (en) * 2008-01-07 2009-07-08 Cvon Innovations Ltd System for selecting an information provider or service provider
ITTO20080434A1 (it) * 2008-06-05 2009-12-06 Accenture Global Services Gmbh Sistema di raccolta e di analisi di dati relativi agli acquisti di consumatori e acquirenti
NO330101B1 (no) * 2008-12-23 2011-02-21 Microsoft Int Holdings B V Fremgangsmåte for human-sentrisk informasjonsaksess og presentasjon
US8452794B2 (en) * 2009-02-11 2013-05-28 Microsoft Corporation Visual and textual query suggestion
US8103681B2 (en) * 2009-05-29 2012-01-24 Clear Channel Management Services, Inc. Associating works with unique identifiers
US20110010379A1 (en) * 2009-07-09 2011-01-13 Xeround Systems Ltd. Database system with query interception and redirection
KR101672454B1 (ko) * 2009-10-30 2016-11-04 삼성전자 주식회사 컨텐트 이용 이력에 기반한 네트워크 컨텐트 서비스 관리 방법 및 장치

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111506644A (zh) * 2019-01-31 2020-08-07 北京神州泰岳软件股份有限公司 一种应用数据处理方法、装置和电子设备
CN111506644B (zh) * 2019-01-31 2024-01-23 北京神州泰岳软件股份有限公司 一种应用数据处理方法、装置和电子设备

Also Published As

Publication number Publication date
EP2721533A4 (en) 2015-04-22
AU2017200613A1 (en) 2017-02-23
KR20180131634A (ko) 2018-12-10
EP2721533A2 (en) 2014-04-23
AU2012271083B2 (en) 2016-11-03
US20140143267A1 (en) 2014-05-22
US20140143266A1 (en) 2014-05-22
JP2014518415A (ja) 2014-07-28
AU2017200613B2 (en) 2017-12-14
US9122721B2 (en) 2015-09-01
KR101925165B1 (ko) 2018-12-04
US9122720B2 (en) 2015-09-01
US20150339352A1 (en) 2015-11-26
US9128979B2 (en) 2015-09-08
KR20140041544A (ko) 2014-04-04
CN103608810B (zh) 2017-06-13
RU2013155624A (ru) 2015-06-20
WO2012173823A2 (en) 2012-12-20
MX2013014791A (es) 2014-01-24
CN103608810A (zh) 2014-02-26
US20120323947A1 (en) 2012-12-20
BR112013031948A2 (pt) 2016-12-20
KR102048653B1 (ko) 2019-11-25
WO2012173823A3 (en) 2013-05-10
RU2611967C2 (ru) 2017-03-01
JP5940149B2 (ja) 2016-06-29

Similar Documents

Publication Publication Date Title
AU2017200613B2 (en) Enriching database query responses using data from external data sources
AU2012271083A1 (en) Enriching database query responses using data from external data sources
EP2924588B1 (en) Report creation method, device and system
US10019524B2 (en) Query model over information as a networked service
US11055352B1 (en) Engine independent query plan optimization
US20130132372A1 (en) Systems and methods for dynamic service integration
US8745088B2 (en) System and method of performing risk analysis using a portal
CN109241384B (zh) 一种科研信息的可视化方法及装置
CN111625510A (zh) 一种基于云映射的多源数据共享系统及方法
US20200320045A1 (en) Sytems and methods for context-independent database search paths
CN114328492B (zh) 用于企业应用集成的数据处理方法以及相关装置
CN115017185A (zh) 一种数据处理方法、装置及存储介质
CN112527856B (zh) 用于电网数据的统一数据源管理系统及方法
US10176269B1 (en) Cross-references in service schema
CN119537378A (zh) 数据调取方法、装置、计算机设备和计算机可读存储介质
CN115705435A (zh) 云服务的数据处理的方法、装置、设备及介质

Legal Events

Date Code Title Description
FZDE Discontinued

Effective date: 20190605