Evaluate your need for SQL/NoSQL/NewSQL database

Which SQL/NoSQL/NewSQL architecture fits my needs

An assessment tool to determine which SQL / NoSQL / NewSQL database architecture you need.

This simple online powerful tool helps you evaluate which database architecture will perform better for your information system.

The tool walks you through questions, which you need to rate some critical parameters. Each parameter is explained.

At the end of the process, you will get our assessment for the best database alternative for your organization.

A relational, consistent, centralized, small-medium based on tables SQL database

A distributed, vast, flexible, based on documents NoSQL database

The SQL vs NoSQL Evaluator helps you in choosing the best alternative for your database needs. It allows you to select the desired database according to your requirements.

Please read the short instructions and rate each topic according to the listed ranking scale. At the end of the process (no more than half a minute), you will receive an initial answer regarding your best database system alternative.

Note that you need to complete the questionnaire for each class in your data system. A deeper evaluation and understanding of your alternatives is possible using our pro evaluator for overall cost-benefit based on each specific class usage.

At the end of these three questionnaires (recommended), you will be able to understand your best choice for your database much better.

Fill in each question according to following scale:

Not Relevant	Low need	Your scale for this function	Critical requirement
0	1	2 - 9	10

Consistency: the need for all users to see the same data when/where he uses a specific information. Read more

The consistency property of a database means that once data is written to a database successfully, queries from all over the world, that follow are able to access the data and get a consistent view of the data. In practice, this means that if you write a record to a database and then immediately request that record, you are guaranteed to see it. It is particularly useful for things like health care orders and bank transfers. Close

Availability: the need that every request receives a (non-error) response, without the guarantee that it contains the most recent information. Read more

High-availability NoSQL databases are systems designed to run without interruption of service. Many web-based businesses require data services that are available without interruption. For example, databases that support online purchasing need to be available 24 hours a day, 7 days a week, 365 days a year. Close

Partition tolerance: The system continues to operate despite part of messages being dropped (or delayed) by the network between nodes. Read more

Partitioning is the database process where very large tables are divided into multiple smaller parts. By splitting a large table into smaller, individual tables, queries that access only a fraction of the data can run faster because there is less data to scan. The main of goal of partitioning is to aid in maintenance of large tables and to reduce the overall response time to read and load data for particular SQL operations.

Partition tolerance means that the entire global network of my servers can still work even if a network separation causes communication interruption between nodes. Close

Vertical extension: The need to expand the amount of information beyond hundreds of thousands of records in a relatively short period of time. Read more

This approach involves adding more physical or virtual resources to the underlying server hosting the database – more CPU, more memory or more storage. Basically, you need a bigger boat server. This is the traditional approach. Close

Horizontal expansion: The need to expand the type of variable and information frequently in the system. Read more

Horizontal Scaling is adding more machines. It divides the data set and distributes the data over multiple servers. Each server is an independent database. Instead of buying a single 2 TB server, you are buying two hundred 10 GB servers. Close

Flexible data: The need to change the database structure in the system according to users' needs. Read more

What if you want to store user profiles in a single row? Yes, a user has user_id, name and country (and more). However, users may have personal and work email addresses as well as mobile and office phone numbers. While some users have Twitter and LinkedIn accounts, others may have Facebook and Instagram accounts. What about interests? Close

Quick access: The need to present the information very quickly to any surfer anywhere in the world. Read more

The speed of information appearing on the Internet is the key to the frequent and effective use that surfers are regular to get. The use of servers spread around the world allows fast browsing (a short distance between the server and the surfer causes the page to appear faster). A rapid view of your website information presents the surfer with a clear understanding that the organization is serious. To achieve great access performance, you need to set up servers that are close to your target audience. This is achieved using NoSQL document-based systems. Close

Multilingual: the need to view the site depending on the country in which it is viewed. Read more

Clever brand building, and great relationships with customers, businesses can improve their online presence and increase the number of loyal customers. Each hosting should handle and contain data for one language so that the surfer can do everything using his mother language. Close

System conversion: the need to convert a SQL relational database to a new NoSQL-based database. Read more

Database migration means moving your data from one platform to another. There are many reasons you might want to move to a different platform. For example, a company might decide to save money by moving to a NoSQL database. Or, a company might find that some particular database software has features that are critical for their business needs. Or, the SQL database can not hold what the company needs. Close

Processing capabilities: The need for real-time analytics process on your servers for cyber big data analytics. Read more

A single server can serve a limited number of clients. Both a complex search as well as a challenging meta-calculation can consume CPU time and computing power. To enable many users to get the required processing results from the server, we need to split the servers into a large number of hosting computers that can serve a large number of requests simultaneously. Close