-
公开(公告)号：US09183272B1
公开(公告)日：2015-11-10
申请号：US14073822
申请日：2013-11-06
申请人： Dell Software Inc.
CPC分类号： G06F17/30592 , G06F17/30292 , G06F17/30389 , G06F17/30418 , G06F17/30424 , G06F17/30477 , G06F17/30563 , G06F17/30864 , G06F17/30982
摘要： In one embodiment, a method includes defining a slice of a dimensional database. The slice includes at least one dimension and at least one measurement and is expressable as a table. The method further includes building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases. The SQL dialect represents the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases. In addition, the method includes parsing the single query. The parsing includes generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases. Furthermore, the method includes executing the dimensional query on the dimensional database. Moreover, the method includes, for each non-dimensional database of the one or more non-dimensional databases, executing the non-dimensional query on the non-dimensional database.
摘要翻译： 在一个实施例中，一种方法包括定义维数据库的切片。 切片包括至少一个维度和至少一个测量值，并且可表示为表格。 该方法还包括以结构化查询语言（SQL）方言构建查询片和一个或多个非维数据库的单个查询。 SQL方言表示一个或多个非维数据库的至少一个维度，至少一个测量值和数据属性。 此外，该方法包括解析单个查询。 解析包括为维度数据库生成维度查询和为一个或多个非维数据库中的每一个生成非维度查询。 此外，该方法包括在维数据库上执行维度查询。 此外，对于一个或多个非维数据库的每个非维数据库，该方法包括在非维数据库上执行无量纲查询。
-
公开(公告)号：US09495437B1
公开(公告)日：2016-11-15
申请号：US14869072
申请日：2015-09-29
申请人： Dell Software Inc.
CPC分类号： G06F17/30592 , G06F17/30292 , G06F17/30389 , G06F17/30418 , G06F17/30424 , G06F17/30477 , G06F17/30563 , G06F17/30864 , G06F17/30982
摘要： In one embodiment, a method includes defining a slice of a dimensional database. The slice includes at least one dimension and at least one measurement and is expressable as a table. The method further includes building, in a structured query language (SQL) dialect, a single query that queries the slice and one or more non-dimensional databases. The SQL dialect represents the at least one dimension, the at least one measurement, and data attributes of the one or more non-dimensional databases. In addition, the method includes parsing the single query. The parsing includes generating a dimensional query for the dimensional database and a non-dimensional query for each of the one or more non-dimensional databases. Furthermore, the method includes executing the dimensional query on the dimensional database. Moreover, the method includes, for each non-dimensional database of the one or more non-dimensional databases, executing the non-dimensional query on the non-dimensional database.
-
搜索结果
2 条记录 (耗时 0.011 秒)
