OLAP and multidimensional database technology have contributed significantly to speed up and build confidence in the effectiveness of methodologies based on the use of management indicators in decision-making, industry, production, and services. Although there are a wide variety of tools related to the OLAP approach, many implementations are performed in relational database systems (R-OLAP). So, all interrogation actions are performed through queries that must be reinterpreted in the SQL language. This translation has several consequences because SQL language is based on a mixture of relational algebra and tuple relational calculus, which conceptually responds to the logic of the relational data model, very different from the needs of the multidimensional databases. This paper presents a multidimensional query language that allows expressing multidimensional queries directly over ROLAP databases. The implementation of the multidimensional query language will be done through a middleware that is responsible for mapping the queries, hiding the translation to a layer of software not noticeable to the end-user. Currently, progress has been made in the definition of a language where through a key statement, called aggregate, it is possible to execute the typical multidimensional operators which represent an important part of the most frequent operations in this type of database.

中文翻译：

---

一种简化的语义多维数据库查询语言，可促进决策中的信息访问

OLAP和多维数据库技术在决策，行业，生产和服务中使用管理指标的基础上，极大地加快了方法的有效性，并建立了人们对方法有效性的信心。尽管有许多与OLAP方法有关的工具，但是许多实现是在关系数据库系统（R-OLAP）中执行的。因此，所有查询操作都是通过必须以SQL语言重新解释的查询执行的。由于SQL语言基于关系代数和元组关系演算的混合体，因此这种翻译具有多种后果，它在概念上响应关系数据模型的逻辑，与多维数据库的需求大不相同。本文提出了一种多维查询语言，该语言允许直接在ROLAP数据库上表达多维查询。多维查询语言的实现将通过负责映射查询的中间件完成，将转换隐藏到最终用户不易察觉的软件层。当前，语言的定义已经取得了进展，其中通过称为聚合的关键语句，可以执行典型的多维运算符，这些运算符表示此类数据库中最常见的运算的重要部分。将翻译隐藏到最终用户看不到的软件层中。当前，语言的定义已经取得了进展，其中通过称为聚合的关键语句，可以执行典型的多维运算符，这些运算符表示此类数据库中最常见的运算的重要部分。将翻译隐藏到最终用户看不到的软件层中。当前，语言的定义已经取得了进展，其中通过称为聚合的关键语句，可以执行典型的多维运算符，这些运算符表示此类数据库中最常见的运算的重要部分。