TinyOlap: A multi-dimensional in-memory OLAP database in plain Python 3.
Project description
TinyOlap is a minimal in-process in-memory multi-dimensional database with numerical aggregations and calculations in mind. First a multi-dimensional data model needs to be defined, consisting of cubes, dimensions, members, hierarchies etc. Afterwards additional calculation logic can be added through arbitrary Python code. Data access is cell-based or range-based. A minimal support for SQL in also provided. All calculations will be executed on the fly. Optionally, persistence is provided through SQLite. TinyOlap is a byproduct of a research project, intended to mimic the behavior and capabilities of real-world MOLAP databases (e.g. IBM TM/1, SAP HANA or Jedox PALO) but with a super minimal footprint. TinyOlap is best suited for interactive planning, forecasting, simulation and general multidimensional numerical problems.
TinyOlap is also quite handy as a more comfortable alternative to Pandas DataFrames when your data is multidimensional, requires hierarchical aggregations or complex calculations.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for tinyolap-0.8.12-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e0489cf3d92efddde9eb0cae676a7df67fabc344acfd9322e8f5bca435b82428 |
|
MD5 | 38f8a3eba133f981b5bbe7c7181d79d5 |
|
BLAKE2b-256 | 4adb969fe259a17bcc71d80dcb6d12f471033babb22d5c10d32cf5ee7f3a86d6 |