cubesviewer第一篇

最新推荐文章于 2024-09-14 19:55:29 发布

weixin_34401479

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量534

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/3179991/blog/1612079

版权

2019独角兽企业重金招聘Python工程师标准>>>

1. It is powered by the SQLAlchemy which supports multiple databases including PostgreSQL, MySQL, Oracle, simple sqlite and many others.

2. Cubes install:

url: http://cubes.readthedocs.io/en/v1.0.1/install.html

3. Cubes purpose:

Purpose is to provide a framework for giving analyst or any application end-user understandable and natural way of reporting using concept of data Cubes – multidimensional data objects.

Analytical Workspace:

The analyital workspace manages cubes, shared (public) dimensions, data stores, model providers and model metadata. Provides aggregation browsers and maintains database connections

Stores:

Cube data are stored somewhere or might be provided by a service. We call this data source a data store. A workspace might use multiple stores to get content of the cubes.

Supported SQL dialects (by SQLAlchemy) are: Drizzle, Firebird, Informix, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, Sybase

Model Providers:

Model provider creates models of cubes, dimensions and other analytical objects. The models can be created from a metadata, database or an external source, such as API.

转载于:https://my.oschina.net/u/3179991/blog/1612079