Build and manage a star schema.
Project description
Introduction
This is a set of Python libraries that allow you to build and manage a star schema.
The star schema is a simple approach to data warehousing. In contrast to big data tools, the star schema is suited to mid-size data problems.
Its biggest benefit is the strict generation and management of facts.
facts and dimensions
The pylitics project creates a set of facts based on dimensions.
Dimensions are the finite data sets you wish to measure your facts against. Common dimensions include dates, lists of customers and sizes/colours.
Facts are the measurements you take. They are most often calculations or summations. Example facts include gross sales by colour per day, total clicks per customer and customers added per week.
Documentation
The full documentation is available at readthedocs.org
Version 1
Version 1 of pylytics is a considerable departure from the previous stable version (v.0.7.0).
Projects created using pylytics versions < 1.0 are not compatible with pylytics >= 1.0.
We recommend you version pin your old pylytics projects to v.0.7.0.
Installing the MySQL connector
Pylytics v1 uses Oracle’s Python MySQL adapter. It can be installed using pip, but isn’t hosted on PyPi.
Depending on your version of pip, you may need to install the requirements as follows:
pip install -r requirements.txt --allow-external mysql-connector-python
Supported MySQL version
Pylytics has been tested with MySQL versions 5.5.37 and 5.6.5.
The recommended version is 5.6.5.
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
File details
Details for the file pylytics-1.0.9.tar.gz.
File metadata
- Download URL: pylytics-1.0.9.tar.gz
- Upload date:
- Size: 30.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 7fc57547a75d34450e545f58409bd9ed9579d40e95b2fc79b12900d7872ae508 |
|
| MD5 | 2a151b1010583dd03e922bed788ec65e |
|
| BLAKE2b-256 | 8f31fe4ccc0e9758f93f72a2c4fcd2d64ec0c2187bec8675e7008b8ce13451e6 |
