WO2011130706A3 - Methods and systems for performing cross store joins in a multi-tenant store - Google Patents

Methods and systems for performing cross store joins in a multi-tenant store Download PDF

Info

Publication number
WO2011130706A3
WO2011130706A3 PCT/US2011/032781 US2011032781W WO2011130706A3 WO 2011130706 A3 WO2011130706 A3 WO 2011130706A3 US 2011032781 W US2011032781 W US 2011032781W WO 2011130706 A3 WO2011130706 A3 WO 2011130706A3
Authority
WO
WIPO (PCT)
Prior art keywords
store
data
tenant
database query
systems
Prior art date
Application number
PCT/US2011/032781
Other languages
French (fr)
Other versions
WO2011130706A2 (en
Inventor
Craig Weissman
James Taylor
Original Assignee
Salesforce.Com, Inc.
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
Priority claimed from US12/973,676 external-priority patent/US8447754B2/en
Priority claimed from US12/973,668 external-priority patent/US10162851B2/en
Priority claimed from US13/087,210 external-priority patent/US8666974B2/en
Application filed by Salesforce.Com, Inc. filed Critical Salesforce.Com, Inc.
Publication of WO2011130706A2 publication Critical patent/WO2011130706A2/en
Publication of WO2011130706A3 publication Critical patent/WO2011130706A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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
    • G06F16/24534—Query rewriting; Transformation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Methods, systems, and computer implemented operations for optimizing queries and for performing high volume searches in a multi- tenant store are described. In one embodiment, operations includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.
PCT/US2011/032781 2010-04-16 2011-04-15 Methods and systems for performing cross store joins in a multi-tenant store WO2011130706A2 (en)

Applications Claiming Priority (12)

Application Number Priority Date Filing Date Title
US32494610P 2010-04-16 2010-04-16
US61/324,946 2010-04-16
US32570910P 2010-04-19 2010-04-19
US61/325,709 2010-04-19
US32595110P 2010-04-20 2010-04-20
US61/325,951 2010-04-20
US12/973,668 2010-12-20
US12/973,676 2010-12-20
US12/973,676 US8447754B2 (en) 2010-04-19 2010-12-20 Methods and systems for optimizing queries in a multi-tenant store
US12/973,668 US10162851B2 (en) 2010-04-19 2010-12-20 Methods and systems for performing cross store joins in a multi-tenant store
US13/087,210 2011-04-14
US13/087,210 US8666974B2 (en) 2010-04-16 2011-04-14 Methods and systems for performing high volume searches in a multi-tenant store

Publications (2)

Publication Number Publication Date
WO2011130706A2 WO2011130706A2 (en) 2011-10-20
WO2011130706A3 true WO2011130706A3 (en) 2012-01-19

Family

ID=44799370

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2011/032781 WO2011130706A2 (en) 2010-04-16 2011-04-15 Methods and systems for performing cross store joins in a multi-tenant store

Country Status (1)

Country Link
WO (1) WO2011130706A2 (en)

Families Citing this family (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8898113B2 (en) 2012-11-21 2014-11-25 International Business Machines Corporation Managing replicated data
US10019471B2 (en) 2013-01-31 2018-07-10 Hewlett Packard Enterprise Development Lp Event log system
US9454767B2 (en) * 2013-03-13 2016-09-27 Salesforce.Com, Inc. Systems, methods, and apparatuses for implementing a related command with a predictive query interface
US9208200B1 (en) * 2014-11-01 2015-12-08 Veeva Systems Inc. System and method for reporting multiple objects in enterprise content management
US11030177B1 (en) * 2017-05-04 2021-06-08 Amazon Technologies, Inc. Selectively scanning portions of a multidimensional index for processing queries
CN110888870A (en) * 2018-09-11 2020-03-17 北京奇虎科技有限公司 Data storage table query method, partition server and electronic equipment
CN110196871B (en) * 2019-03-07 2024-05-17 腾讯科技（深圳）有限公司 Data warehousing method and system
CN111783109B (en) * 2019-04-04 2023-08-01 华控清交信息科技(北京)有限公司 Data query method, system and storage medium
US11347736B2 (en) 2019-10-30 2022-05-31 Boray Data Technology Co. Ltd. Dynamic query optimization
WO2021087153A1 (en) * 2019-10-30 2021-05-06 Boray Data Technology Co. Ltd. Dynamic query optimization
CN111104408A (en) * 2019-12-17 2020-05-05 腾讯云计算（北京）有限责任公司 Data exchange method and device based on map data and storage medium
CN111159192B (en) * 2019-12-30 2023-09-05 北京因特睿软件有限公司 Big data based data warehousing method and device, storage medium and processor
CN112148731B (en) * 2020-08-13 2022-05-27 新华三大数据技术有限公司 Data paging query method, device and storage medium
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
CN114328466A (en) * 2022-01-06 2022-04-12 北京微吼时代科技有限公司 Data cold and hot storage method and device and electronic equipment
CN117407445B (en) * 2023-10-27 2024-06-04 上海势航网络科技有限公司 Data storage method, system and storage medium for Internet of vehicles data platform

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6411951B1 (en) * 1998-12-16 2002-06-25 Microsoft Corporation Evaluating SQL subqueries
US20020107840A1 (en) * 2000-09-12 2002-08-08 Rishe Naphtali David Database querying system and method
US20070214104A1 (en) * 2006-03-07 2007-09-13 Bingjie Miao Method and system for locking execution plan during database migration
US20090164447A1 (en) * 2007-12-20 2009-06-25 International Business Machines Corporation Content searching for portals having secure content
US20090276395A1 (en) * 2003-09-23 2009-11-05 Salesforce.Com, Inc. Query optimization in a multi-tenant database system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6411951B1 (en) * 1998-12-16 2002-06-25 Microsoft Corporation Evaluating SQL subqueries
US20020107840A1 (en) * 2000-09-12 2002-08-08 Rishe Naphtali David Database querying system and method
US20090276395A1 (en) * 2003-09-23 2009-11-05 Salesforce.Com, Inc. Query optimization in a multi-tenant database system
US20070214104A1 (en) * 2006-03-07 2007-09-13 Bingjie Miao Method and system for locking execution plan during database migration
US20090164447A1 (en) * 2007-12-20 2009-06-25 International Business Machines Corporation Content searching for portals having secure content

Also Published As

Publication number Publication date
WO2011130706A2 (en) 2011-10-20

Similar Documents

Publication Publication Date Title
WO2011130706A3 (en) Methods and systems for performing cross store joins in a multi-tenant store
AU2011345318A8 (en) Methods and systems for performing cross store joins in a multi-tenant store
CA2834864C (en) Database system and method
WO2014035879A3 (en) Operating a distributed database with foreign tables
WO2014113772A3 (en) Methods and systems for mapping repair orders within a database
GB2559909A (en) A system and method for processing big data using electronic document and electronic file-based system that operates on RDBMS
JP2015508529A5 (en)
WO2014099234A3 (en) Method for storage, querying, and analysis of time series data
IN2013CH04496A (en)
WO2013009925A3 (en) Optimizing data processing using dynamic schemas
WO2012059816A3 (en) Method and apparatus for handling digital objects in a communication network
WO2006060773A3 (en) Computer systems and methods for visualizing data with generation of marks
WO2013173826A3 (en) Populating and searching a drug informatics database
GB2542279A (en) Improved method, system and software for searching, identifying, retrieving and presenting electronic documents
WO2013163644A3 (en) Updating a search index used to facilitate application searches
WO2012097009A3 (en) Systems and methods for high-speed searching and filtering of large datasets
WO2014008281A3 (en) Query-based software system design representation
WO2013041852A3 (en) Scalable distributed transaction processing system
WO2011127158A8 (en) Data storage and/or retrieval based on a database model-agnostic, schema-agnostic and workload-agnostic data storage and access models
WO2014036282A3 (en) System and process of associating import and/or export data with a corporate identifier
GB2542304A (en) Methods, systems, and media for searching for video content
WO2006107772A3 (en) System and methods for facilitating a linear grid database with data organization by dimension
WO2008088721A3 (en) Querying data and an associated ontology in a database management system
WO2015090244A3 (en) Method, server, and system for accessing metadata
WO2011115839A3 (en) Computer relational database method and system having role based access control

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 11769725

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 11769725

Country of ref document: EP

Kind code of ref document: A2