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.13-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 195c399c3808c5ef294dbde67eabe68bc1f3add69c3349720cfac13f38da387e |
|
MD5 | b72836d2e895297b775f057da37a4140 |
|
BLAKE2b-256 | 2b30b3464743ffad99d4ec6e95b64ed704d110d964300560b468465d1c2d27db |