Skip to content

OmniSciDB Overview

snowcrash007 edited this page Aug 1, 2019 · 2 revisions

OmniSciDB is maintained by OmniSci

The OmniSci platform combines an open-source SQL engine (OmniSciDB), server-side rendering (OmniSci Render), and web-based data visualization (OmniSci Immerse) to provide a comprehensive platform for data analysis.

You can learn more about the technical architecture by visiting the Architecture page.

What is OmniSciDB?

OmniSciDB is an open-source, GPU-accelerated database that is the foundation of the OmniSci platform. OmniSciDB harnesses GPU processing power and returns SQL query results in milliseconds, even on tables with billions of rows.

OmniSciDB is designed to deliver:

  • high performance,
  • rapid query compilation,
  • query vectorization, and
  • advanced memory management

Native SQL

With native SQL support, OmniSciDB returns query results hundreds of times faster than CPU-only analytical database platforms. Use existing SQL knowledge to query data. Developers can use the standalone SQL engine with the command line, or the SQL editor that is part of the OmniSci Immerse visual analytics interface. SQL query results can output to OmniSci Immerse or to third-party software such as Birst, Power BI (Microsoft), Qlik, or Tableau.

Geospatial Data

OmniSciDB can store and query data using native Open Geospatial Consortium (OGC) types, including POINT, LINESTRING, POLYGON, and MULTIPOLYGON. With geo type support, you can query geo data at scale using special geospatial functions. Using the power of GPU processing, you can quickly and interactively calculate distances between two points and intersections between objects.

Contributing

OmniSciDB is open source and developers are encouraged to contribute to this open source project. Check out the Contributing page to learn more.

Need Help?

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.

Copyright & License

This project is licensed under the Apache License, Version 2.0.