Hybrid online analytical processing (OLAP) and relational query processing
In some embodiments, a method receives a connection to a data source. The method analyzes metadata of the data source to determine a first type of metadata for a first type of database access and a second type of metadata for a second type of database access. The first type of metadata and the second type of metadata are combined into a data structure. Then, the method stores the data structure where the data structure is used to analyze a query to determine which of the first type of database access and the second type of database access to use for the query.
1. A method comprising:
receiving, by a computing device, a connection to a data source;
analyzing, by the computing device, metadata of the data source to determine a first type of metadata for a first type of database access and a second type of metadata for a second type of database access, wherein the first type of metadata relates to hierarchies in online analytical processing (OLAP) data of the data source and the second type of metadata relates to table schemas of a relational database of the data source;
combining, by the computing device, the first type of metadata and the second type of metadata into a data structure; and
storing, by the computing device, the data structure, wherein the data structure is used to analyze a query to determine which of the first type of database access and the second type of database access to use for the query.
2. The method of claim 1 , wherein the first type of access comprises an online analytical processing (OLAP) type of access.
3. The method of claim 2 , wherein the second type of access comprises a relational type of access.
4. The method of claim 1 , wherein the connection to the data source does not specify which of the first type of database access and the second type of database access to use to process queries.
5. The method of claim 1 , wherein which of the first type of database access and the second type of database access to use for the query is determined after the query is received.
6. The method of claim 1 , further comprising:
analyzing one or more portions in the query to determine which of the first type of database access and the second type of database access to use to access the one or more portions.
7. The method of claim 1 , further comprising:
analyzing one or more portions in the query to determine if the one or more portions includes a hierarchical object.
8. The method of claim 7 , further comprising:
using the first type of access when the one or more portions includes the hierarchical object.
9. The method of claim 1 , further comprising:
analyzing one or more portions in the query to determine if the one or more portions includes a hierarchical attribute.
10. The method of claim 9 , further comprising:
using the first type of access when the one or more portions includes the hierarchical attribute.
11. The method of claim 1 , further comprising:
analyzing one or more portions in the query to determine if the one or more portions includes at least one of a hierarchical object and a hierarchical attribute.
12. The method of claim 11 , further comprising:
using the second type of access when the one or more portions does not include at least one of the hierarchical object and the hierarchical attribute.
13. The method of claim 11 , further comprising:
using the first type of access when the one or more portions does include at least one of the hierarchical object and the hierarchical attribute.
14. The method of claim 1 , further comprising:
using the first type of access to retrieve a first portion of data from the data source; and
using the second type of access to retrieve a first portion of data from the data source.
15. A non-transitory computer-readable storage medium containing instructions, that when executed, control a computer system to be operable for:
receiving a connection to a data source;
analyzing metadata of the data source to determine a first type of metadata for a first type of database access and a second type of metadata for a second type of database access, wherein the first type of metadata relates to hierarchies in online analytical processing (OLAP) data of the data source and the second type of metadata relates to table schemas of a relational database of the data source;
combining the first type of metadata and the second type of metadata into a data structure; and
storing the data structure, wherein the data structure is used to analyze a query to determine which of the first type of database access and the second type of database access to use for the query.
16. A method comprising:
receiving, by a computing device, a query for a data source, wherein the query for the data source does not specify which of a first type of database access and a second type of database access to use to process the query;
analyzing, by the computing device, one or more portions in the query to determine which of the first type of database access and the second type of database access to use to access the one or more portions, wherein the first type of metadata relates to hierarchies in online analytical processing (OLAP) data of the data source and the second type of metadata relates to table schemas of a relational database of the data source;
selecting, by the computing device, one of the first type of database access and the second type of database access;
retrieving, by the computing device, one of a first type of metadata and a second type of metadata from a data structure based on which of the one of the first type of database access and the second type of database access is selected; and
accessing, by the computing device, the data source using the one of the first type of metadata and the second type of metadata to determine a result for the query.
17. The method of claim 16 , further comprising:
analyzing one or more portions in the query to determine if the one or more portions includes at least one of a hierarchical object and a hierarchical attribute.
18. The method of claim 17 , further comprising:
using the second type of access when the one or more portions does not include at least one of the hierarchical object and the hierarchical attribute.
19. The method of claim 17 , further comprising:
using the first type of access when the one or more portions does include at least one of the hierarchical object and the hierarchical attribute.
20. The method of claim 16 , further comprising:
using the first type of access to retrieve a first portion of data from the data source; and
using the second type of access to retrieve a first portion of data from the data source.