Multidimensional Database Server SQL Gateway
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current techniques lack efficiency in accessing multidimensional data stored in relational database management systems using SQL, as they require excessive data transfer and computation, and do not allow direct manipulation of multidimensional data without converting it into relational tables.
Innovation Solution
Implementing a multidimensional database server that extracts and processes only a subset of multidimensional data, filters cells based on criteria, and presents it in a virtual return table format to the relational database server, enabling efficient data access and manipulation through SQL commands.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If multidimensional data is stored in a specialized multidimensional database system, then data access efficiency is improved, but application compatibility deteriorates because only specially built applications can access the data
Solution Approach 1:
The patent introduces a gateway component that acts as an intermediary between SQL-based applications and the multidimensional database system. This gateway translates SQL queries into multidimensional data queries, enabling standard applications to access multidimensional data without direct integration, thus maintaining both efficiency and compatibility
Solution Approach 2:
The system enables the multidimensional database to serve multiple functions: it maintains optimized multidimensional storage for efficient data access while simultaneously providing SQL interface compatibility for broad application support. The gateway provides universal access methods that work with both specialized and general-purpose applications
2Adaptability or versatility
If multidimensional data is stored in a relational database system, then application compatibility is improved, but data access efficiency deteriorates due to excessive data transfer and computation
Solution Approach 1:
The gateway serves as a mediator that receives SQL queries from relational database systems and translates them into optimized multidimensional queries. This allows relational databases to maintain their compatibility advantages while the gateway handles the complex multidimensional data access efficiently
Solution Approach 2:
The system segments the data access function into two parts: the relational database handles storage and basic compatibility, while the gateway handles the complex multidimensional query translation and optimization. This segmentation allows each component to excel at its specific function
3Reliability
If all multidimensional data is extracted and presented to the relational database server, then complete data access is achieved, but data transfer and computation requirements increase significantly
Solution Approach 1:
The gateway extracts only the specific subset of multidimensional data that is relevant to the SQL query being executed. Instead of transferring all data, it selectively retrieves and translates only the necessary portions, reducing data transfer and computation while maintaining access completeness for the requested information
Solution Approach 2:
The system performs partial action by translating and transferring only the specific data subset needed to answer the query rather than all multidimensional data. This partial extraction maintains reliability for the requested information while significantly reducing energy consumption
Data Source
AI summary
In processing a query on multidimensional data in a multidimensional schema, a multidimensional database server performs various processes to limit the amount of data that is extracted from the database and presented to a relational database server in response to the request. A subset of data is identified to extract from the multidimensional data, based on the query. In various embodiments, cell-filtering, measure-filtering, and column-filtering criteria identified from the query are used to filter the subset of data, in order to return a minimized set of multidimensional data values from the subset of data. Therefore, computational resources are conserved with respect to further processing by the relational database server in response to the query.