OmniSciDB is an open source SQL-based, relational, columnar database engine that leverages the full performance and parallelism of modern hardware (both CPUs and GPUs) to enable querying of multi-billion row datasets in milliseconds, without the need for indexing, pre-aggregation, or downsampling. OmniSciDB can be run on hybrid CPU/GPU systems (Nvidia GPUs are currently supported), as well as on CPU-only systems featuring X86, Power, and ARM (experimental support) architectures. To achieve maximum performance, OmniSciDB features multi-tiered caching of data between storage, CPU memory, and GPU memory, and an innovative Just-In-Time (JIT) query compilation framework.
To find out more, please check out the OmniSci Website and the OmniSciDB wiki.
- Install the dependencies mentioned in the Dependencies page.
- Read up about building, running tests, and basic usage and configuration.
- Download and install the package.
- Initialize servers using a wrapper or manually
- Load sample data. Sample sets can be found in the Data Set Library.
- Perform a sample query
For complete download and installation instructions, please visit the Documentation page.
- How-tos, code snippets and more on the OmniSci Blog
- Tutorials & Demos
- Need a data set to practice with? Search the Data Set Library
- Video overview of the Architecture
| OmniSciDB | Documentation | Setup | Community & Resources |
|---|---|---|---|
| Overview of OmniSciDB | Developer Friendly Technical Documentation | Step-by-step getting started documentation | Important links, community resources and updates |
| Distro | Package type | CPU/GPU | Download Link | Installation Guide |
|---|---|---|---|---|
| CentOS | RPM | CPU | https://releases.omnisci.com/os/yum/stable/cpu | https://www.omnisci.com/docs/latest/4_centos7-yum-cpu-os-recipe.html |
| CentOS | RPM | GPU | https://releases.omnisci.com/os/yum/stable/cuda | https://www.omnisci.com/docs/latest/4_centos7-yum-gpu-os-recipe.html |
| Ubuntu | DEB | CPU | deb https://releases.omnisci.com/os/apt/ stable cpu | https://www.omnisci.com/docs/latest/4_ubuntu-apt-cpu-os-recipe.html |
| Ubuntu | DEB | GPU | deb https://releases.omnisci.com/os/apt/ stable cuda | https://www.omnisci.com/docs/latest/4_ubuntu-apt-gpu-os-recipe.html |
| * | tarball | CPU | https://releases.omnisci.com/os/tar/omnisci-os-latest-Linux-x86_64-cpu.tar.gz | |
| * | tarball | GPU | https://releases.omnisci.com/os/tar/omnisci-os-latest-Linux-x86_64-cuda.tar.gz |
Developers can also access OmniSciDB through the partner marketplaces. Easily find installation guides, videos, quickstarts and more important resources on how to set up OmniSciDB on public cloud providers such as AWS, Google Cloud Platform, Azure, Docker and more on the Partner page.
Get more detailed download instructions, videos, resources and tutorials by visiting our Downloads page and Documentation.
Developers are encouraged to contribute to this Open Source project to expand and enhance OmniSciDB capabilities. Check out our Contributing page on the wiki! If you have questions and would like to connect with the maintainers of this open source project, please visit the official online forum and community.
Check out contribution wishlist with highlighted issues that would make great first contributions to this project. We also recommend visiting the Roadmap to learn more about upcoming features or checking out the Issues to see the latest updates or proposed content.
In order to clarify the intellectual property license granted with Contributions from any person or entity, OmniSci must have a Contributor License Agreement ("CLA") on file that has been signed by each Contributor, indicating agreement to the Contributor License Agreement. After making a pull request, a bot will notify you if a signed CLA is required and provide instructions for how to sign it. Please read the agreement carefully before signing and retain a copy for your records.
Have questions? Post questions and get answers on the official online forum and community or create an issue in the repo.
This project is licensed under the Apache License, Version 2.0.
The repository includes a number of third party packages provided under separate licenses. Details about these packages and their respective licenses is at ThirdParty/licenses/index.md.