Amazon-AWS

Amazon AWS For many use cases, it has several solutions that you can choose which is the best solution for your use case and not be limited to one solution. Amazon AWS is used by the biggest companies in the world, banking insurance companies including the US army.  Amazon’s popular services are : Amazon Elastic […]

Redshift

  Amazon Redshift is a fully managed, cloud-based big data warehouse service offered by Amazon. The platform provides a storage system that stores petabytes of data in easy-to-access clusters that can be queried in parallel. Each of these nodes can be accessed independently by users and applications. Companies can choose to create a single node […]

Vertica

  Vertica is an elastically scalable, advanced SQL analytics database purpose built to manage rapidly growing volumes of data, maximising cloud economics for mission-critical big data analytics initiatives. It is designed for use in data warehouses and other big data workloads where: speed, scalability, simplicity, and openness are crucial to the success of analytics as […]

Exasol

Exasol is a high performance parallelized relational database management system (RDBMS) which runs on a cluster of standard computer hardware servers. This database is designed to run in memory, although data is persistently stored on disk following the ACID rules. Exasol supports the SQL Standard 2003 and can be integrated via standard interfaces like ODBC, […]

Presto

Presto is an open-source, distributed SQL query engine that runs on Hadoop. It uses an architecture similar to a classic massively parallel processing (MPP) database management system and was designed for fast analytic queries against data of any size. The system was initially designed at Facebook as they needed to run interactive queries against large […]

Amazon

Amazon Athena   Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 (Simple Storage Service), using standard SQL. Since Athena is serverless, there is no infrastructure to manage, and you pay only for the queries that you run. Athena relies on the open source Presto distributed SQL […]

Google

Google Big Query   Google BigQuery is a fast, powerful, flexible, and cost-effective serverless data warehouse that’s tightly integrated with the other services on a Google Cloud Platform. Designed to help you make informed decisions quickly, the cloud-based data warehouse and analytics platform uses a built-in query engine and a highly scalable serverless computing model […]

Cassandra

What is Cassandra databse? Apache Cassandra is a free, open-source, NoSQL distributed database which was initially developed to be used by Facebook. It belongs to the NoSQL Column Oriented  Database , which has a RDBMS-like schema (keyspace), with tables and tables with columns . Cassandra Cluster is masterless; the data is distributed evenly between its […]

Elasticsearch – The best open source search engine

Elasticsearch Elasticsearch is a free open source search engine based on Apache Lucene with many goodies such as aggregation, analytics, ETL using Logstash and Kibana dashboard which make it today the best search engine in the world with many capabilities to become a centralized database for many products and companies. Elasticsearch can store Petabytes of […]

Analytical database

An analytical database (also known as an analytic database), is a read-only system that stores historical data on business metrics such as sales performance and inventory levels. Who uses it? It would be better to ask who doesn’t. Business analysts, corporate executives and essentially any worker in an enterprise can run enterprise data analytics on […]