NewSQL databases overview in DBMS Theory - Mini Project: Build & Apply

NewSQL Databases Overview

📖 Scenario: You are learning about modern database technologies used in businesses to handle large amounts of data quickly and reliably.NewSQL databases combine the best features of traditional SQL databases and newer NoSQL systems.

🎯 Goal: Build a simple structured overview of NewSQL databases, including their key features, examples, and benefits.

📋 What You'll Learn

Create a dictionary named newsql_overview with key features and examples

Add a variable named main_benefit describing the primary advantage of NewSQL

Use a loop to create a list of feature descriptions from the dictionary

Add a final summary string combining key points about NewSQL

💡 Why This Matters

🌍 Real World

NewSQL databases are used in companies that need fast, reliable, and scalable data storage with strong consistency, such as financial services and cloud providers.

💼 Career

Understanding NewSQL helps in roles like database administration, backend development, and data engineering where choosing the right database technology is crucial.

1

Create the NewSQL features dictionary

Create a dictionary called newsql_overview with these exact entries: 'Scalability': 'Supports horizontal scaling like NoSQL', 'Consistency': 'Maintains ACID transactions', 'SQL Support': 'Uses standard SQL queries', 'Examples': ['Google Spanner', 'CockroachDB', 'VoltDB'].

DBMS Theory

# Create the newsql_overview dictionary with the specified keys and values
# Your code here

Need a hint?

Use curly braces to create a dictionary and colons to assign values to keys.

2

Add the main benefit variable

Create a variable called main_benefit and set it to the string 'Combines scalability of NoSQL with the reliability of SQL'.

DBMS Theory

newsql_overview = {
    'Scalability': 'Supports horizontal scaling like NoSQL',
    'Consistency': 'Maintains ACID transactions',
    'SQL Support': 'Uses standard SQL queries',
    'Examples': ['Google Spanner', 'CockroachDB', 'VoltDB']
}
# Create the main_benefit variable with the specified string
# Your code here

Need a hint?

Assign the exact string to the variable main_benefit.

3

Create a list of feature descriptions

Use a for loop with the variable feature to iterate over the keys of newsql_overview except the key 'Examples'. Inside the loop, append the string combining the feature and its description separated by a colon and space to a list called feature_list. Initialize feature_list as an empty list before the loop.

DBMS Theory

newsql_overview = {
    'Scalability': 'Supports horizontal scaling like NoSQL',
    'Consistency': 'Maintains ACID transactions',
    'SQL Support': 'Uses standard SQL queries',
    'Examples': ['Google Spanner', 'CockroachDB', 'VoltDB']
}

main_benefit = 'Combines scalability of NoSQL with the reliability of SQL'

feature_list = []
# Use a for loop to add feature descriptions to feature_list
# Your code here

Need a hint?

Use a for loop to check each key and skip 'Examples'. Use f-strings to format the string.

4

Add the final summary string

Create a variable called summary and set it to a string that says: 'NewSQL databases like Google Spanner and CockroachDB offer scalability and strong consistency by combining SQL support with NoSQL features.'

DBMS Theory

newsql_overview = {
    'Scalability': 'Supports horizontal scaling like NoSQL',
    'Consistency': 'Maintains ACID transactions',
    'SQL Support': 'Uses standard SQL queries',
    'Examples': ['Google Spanner', 'CockroachDB', 'VoltDB']
}

main_benefit = 'Combines scalability of NoSQL with the reliability of SQL'

feature_list = []
for feature in newsql_overview:
    if feature != 'Examples':
        feature_list.append(f"{feature}: {newsql_overview[feature]}")

# Add the summary string below
# Your code here

Need a hint?

Assign the exact summary string to the variable summary.