SQL Server is a relational database management system (RDBMS) by Microsoft. The product's main purposes are to store data and retrieve it as requested by other software applications - on the same computer or on another computer across a shared network. The solution is built on top of Structured Query Language (SQL), which is a standardized programming language used for relational database management.
It has the easiest licensing.
This is a downside of enterprise Microsoft products.
It has the easiest licensing.
This is a downside of enterprise Microsoft products.
Snowflake is a cloud-based data warehousing solution for storing and processing data, generating reports and dashboards, and as a BI reporting source. It is used for optimizing costs and using financial data, as well as for migrating data from on-premises to the cloud. The solution is often used as a centralized data warehouse, combining data from multiple sources.
Pricing can be confusing for customers.
You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.
Pricing can be confusing for customers.
You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.
Oracle Database is a top-ranking multi-model database management system by Oracle Corporation. Through Oracle database services and products, clients receive cost-optimized and high-performing versions of Oracle Database, as well as in-memory, NoSQL, and MySQL databases. The solution is available by several service providers on premises, in the cloud, or as a hybrid installation. It can be run on vendor servers as well as on Oracle hardware, including Exadata on-premise, Oracle Cloud, or Cloud at Customer.
Be prepared to pay for consulting services, and do not underestimate the time required to find and hire good quality database administrators.
The license cost need to be optimized. The licensing cost is very high compared to other RDBMS.
Be prepared to pay for consulting services, and do not underestimate the time required to find and hire good quality database administrators.
The license cost need to be optimized. The licensing cost is very high compared to other RDBMS.
MySQL is an open-source relational database management system (RDBMS) owned by Oracle. Before Oracle acquired the product, it was completely free for users. After the merge, the solution started offering paid services with more features, alongside a free version. MySQL can easily integrate with a wide variety of programming languages, which makes it one of the most flexible and reliable products among its competitors. This cost-effective solution helps users deliver high-performance and scalable database applications through several products. They include:
When you know the setup will continue to grow, make sure you have the paid support.
Enterprise editions and support are definitely needed for the heavy users who need direct support.
When you know the setup will continue to grow, make sure you have the paid support.
Enterprise editions and support are definitely needed for the heavy users who need direct support.
MariaDB is an open source relational database created by the original founders of MySQL. It is considered one of the most popular and trusted database servers throughout the world. MariaDB is a valued component found in most cloud offerings and is the default in many Linux tools. It is also widely used by Wikipedia, WordPress, and Google, among other well-known sites. Maria DB easily melds data into concise information from a vast array of applications, such as banking, online shopping, websites, and more.
The price of this solution represents a very good compromise between the cost and what it offers.
It's an open-source solution.
The price of this solution represents a very good compromise between the cost and what it offers.
It's an open-source solution.
Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.
The price of this solution could be improved.
The pricing is okay. You can pay as you go.
The price of this solution could be improved.
The pricing is okay. You can pay as you go.
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
It is expensive, which isn't a problem for us because SAP HANA is processing the data so fast.
SAP HANA is an expensive product.
It is expensive, which isn't a problem for us because SAP HANA is processing the data so fast.
SAP HANA is an expensive product.
Teradata is a multi-cloud data platform company that provides data warehouse and relational database tools. The brand has an extensive portfolio of big data analytic solutions, integrated marketing applications, and services. The products that Teradata offers can be categorized in the following ways:
Teradata is not cheap, but you get what you pay for.
The initial cost may seem high, but the TCO is low.
Teradata is not cheap, but you get what you pay for.
The initial cost may seem high, but the TCO is low.
Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).
The Initial investment price could use improvement
I think it's free.
The Initial investment price could use improvement
I think it's free.
What is Amazon Redshift?
If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift.
BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge.
If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift.
BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge.
They are competitive and honest (compared to how peer firms approach licensing conversations).
Compared to Oracle, it is so much cheaper.
They are competitive and honest (compared to how peer firms approach licensing conversations).
Compared to Oracle, it is so much cheaper.
Vertica is a deploy-anywhere SQL database created for elasticity, speed, and advanced analytics. Vertica enables today’s busy teams to modernize their data warehouses, democratize data and analytics to enable increased access, and deploy analytics in a hybrid cloud environment. Additionally, Vertica merges how companies power their analytics by providing a scalable, open, and elastic database with numerous intuitive features.
Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).
Read the fine print carefully.
Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).
Read the fine print carefully.
Headquartered in New York, MongoDB's mission is to empower innovators to create, transform, and disrupt industries by unleashing the power of software and data. Built by developers, for developers, our developer data platform is a database with an integrated set of related services that allow development teams to address the growing requirements for today's wide variety of modern applications, all in a unified and consistent user experience. MongoDB has tens of thousands of customers in over 100 countries. The MongoDB database platform has been downloaded hundreds of millions of times since 2007, and there have been millions of builders trained through MongoDB University courses. To learn more, visit www.mongodb.com.
We are using the Community Edition of MongoDB.
It is rather expensive.
We are using the Community Edition of MongoDB.
It is rather expensive.
BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. ... You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.
BigQuery is inexpensive.
The price is a bit high but the technology is worth it.
BigQuery is inexpensive.
The price is a bit high but the technology is worth it.
There are no licensing costs involved, hence money is saved on the software infrastructure.
This is a low cost and powerful solution.
There are no licensing costs involved, hence money is saved on the software infrastructure.
This is a low cost and powerful solution.
InfluxDB is open-source software that helps developers and enterprises alike to collect, store, process, and visualize time series data and to build next-generation applications. InfluxDB provides monitoring and insight on IoT, application, system, container, and infrastructure quickly and easily without complexities or compromises in scale, speed, or productivity.
We are using the open-source version of InfluxDB.
InfluxDB is open-source, but there are additional costs for scaling.
We are using the open-source version of InfluxDB.
InfluxDB is open-source, but there are additional costs for scaling.
Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.
The cost is perfect with Oracle Universal credit.
ROI is high.
The cost is perfect with Oracle Universal credit.
ROI is high.
When comparing with Oracle Sybase and SQL, it's cheaper. It's not expensive.
The price could be better for the product.
When comparing with Oracle Sybase and SQL, it's cheaper. It's not expensive.
The price could be better for the product.
Cassandra setups can vary in difficulty, with some users finding it straightforward and others needing assistance. The installation process can take anywhere from a minute to several months, depending on the complexity and the availability of proper guides.
Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise.
There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly.
Cassandra is a free open source solution, but there is a commercial version available called DataStax Enterprise.
There are licensing fees that must be paid, but I'm not sure if they are paid monthly or yearly.
SingleStore is a powerful data management and analytics platform that excels in efficiently handling and analyzing large volumes of data in real-time. It is particularly effective in managing complex queries and providing fast query responses.
With its scalability and ability to handle high data loads, SingleStore is suitable for various industries such as e-commerce, finance, and telecommunications.
Users have praised its high performance, scalability, and real-time analytics capabilities as its most valuable features. It can handle large amounts of data efficiently and seamlessly integrate with existing systems.
The platform's ease of use and intuitive interface are also highly praised.
I would advise users to try the free 128GB version.
SingleStore is a bit expensive.
I would advise users to try the free 128GB version.
SingleStore is a bit expensive.
Oracle Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.
Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE.
Get benefit from the capacity-on-demand features. License your cores according to your licenses.
Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE.
Get benefit from the capacity-on-demand features. License your cores according to your licenses.
VMware Tanzu Greenplum is a massively parallel processing (MPP) data platform that enables organizations to store, manage, and analyze large volumes of data. It provides a unified analytics platform that supports various data types and sources, including structured, semi-structured, and unstructured data.
It is the best product with best fit for price/performance customer objectives.
Pricing is good compared to other products. It's fine.
It is the best product with best fit for price/performance customer objectives.
Pricing is good compared to other products. It's fine.
In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side.
In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side.
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
I think the program is well-priced compared to the other offerings that are out in the market.
All the features that we use do not require any additional subscription or yearly fees.
I think the program is well-priced compared to the other offerings that are out in the market.
All the features that we use do not require any additional subscription or yearly fees.
The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership.
Users have to pay extra for premium-level technical support.
The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership.
Users have to pay extra for premium-level technical support.
Exasol is a high-performance data warehouse solution that accelerates BI and reporting features. Its speed, stability, and self-tuning queries make it valuable, and it doesn't require a database administrator. It's a backend database for Tableau dashboards, resulting in faster report loading times and increased efficiency in querying data.
The solution's cost is mid-ranged.
The solution's cost is mid-ranged.
Yellowbrick’s mission is to make analytics and data warehousing simple. Replace racks of hardware with an easy to manage turn-key solution. Yellowbrick delivers an optimized analytic database and advanced software that eliminates tasks that consume hours of IT and DBA staff time, all while improving service and insight quality.
IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.
If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version.
If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version.
