OUSHU DATABASE

The fastest data warehouse in the world

Welcome to

Oushu Database

Oushu database, a New Data Warehouse powered by Apache HAWQ, is blazing fast and adopts an innovative architecture that combines the merits of MPP performance and the scalability of Hadoop. And it can scale to thousands of nodes.

Oushu database follows ANSI-SQL standards and it is compatible with Oracle, Greenplum database and PostgreSQL. HAWQ provides the users and tools to confidently and successfully interact with petabyte data sets. HAWQ has been used extensively by hundreds of enterprise users, including GE, NYSE, Jindong, Chine Mobile et al.

Oushu Database Release Notes
Image description

Features

  • Brand new executor, 5-10 times faster, key feature of Oushu database 3.0
  • On-premise or cloud deployment
  • Robust ANSI SQL compliance: SQL-92, SQL-99, SQL-2003, OLAP extension
  • Many times faster than traditional MPP database and the Hadoop SQL engines
  • World-class parallel optimizer
  • Full transaction capability and consistency guarantee: ACID
  • Dynamic data flow engine through high speed UDP based interconnect
  • Support PostGIS, the capability of store and querying spatial objects
  • Multiple compression method support: snappy, gzip, lz4, RLE
  • Multi-language user defined function support: python, perl, java, c/c++ and R
  • Dynamic node expansion: in seconds
  • Advanced machine learning and data mining functionalities through MADLib
  • New pluggable external framework, easy to add new data sources, for example, HBase et al.
  • Support popular third party tools: Tableau, SAS et al.
  • Seamless integration with the Hadoop ecosystem
  • Support ORC format. combined with new executor, 10-50 faster than old external storage

Oushu Database Enhancements to Apache HAWQ

  • Brand new executor, 5-10 times faster, key feature of Oushu database 3.0
  • Support PostGIS, the capability of store and querying spatial objects
  • Support Kubenetes deployment
  • Documentation
  • Support ORC format. combined with new executor, 10-50 faster than old external storage
  • New pluggable external framework, easy to add new data sources
  • Multi-bytes delimiter for TXT/CSV format
  • Release Notes