Scribe logoScribeNotes & practice
Sign inStart free
  1. Notes
  2. ›IB Computer Science
  3. ›A3 Databases
  4. ›A3.4 Alternative databases and warehouses

IB Computer Science · A3 · Databases

A3.4 Alternative databases and warehouses

Describe NoSQL databases, compare them with relational databases for different scenarios, and explain the purpose, advantages and disadvantages of data warehouses.

  • 4 min read
  • 5 parts
  • 10 questions
  • Draft
  • HL only
Start a Quick 5 on this topic→Jump to the 10 questions
1/5NoSQL databases store data in non-relational forms
  1. 1NoSQL databases store data in non-relational forms
  2. 2Flexible schemas and horizontal scaling define NoSQL
  3. 3The best choice depends on the scenario
  4. 4A data warehouse gathers data from many sources for analysis
  5. 5Warehouses support decisions but bring cost and complexity
  6. Check your recall
  7. Practice: 10 questions
1

Part 1 of 5: NoSQL databases store data in non-relational forms

Linked tables suit neat, regular data. Some data fits them poorly, such as social media posts, sensor readings or product details that vary widely. A NoSQL database stores data in a model other than related tables.

NoSQL covers several designs, which are compared below. Many of them were built to spread data across many servers. This helps them cope with very large amounts of data.

Common NoSQL database types

TypeStores data asTypical use
DocumentSelf-contained documentsProduct catalogues
Key–valueA unique key paired with a valueSession data
GraphNodes joined by linksSocial networks
Wide-columnRows whose columns can varyVery large datasets
Type
Document
Stores data as
Self-contained documents
Typical use
Product catalogues
Type
Key–value
Stores data as
A unique key paired with a value
Typical use
Session data
Type
Graph
Stores data as
Nodes joined by links
Typical use
Social networks
Type
Wide-column
Stores data as
Rows whose columns can vary
Typical use
Very large datasets

A document database, for example, may store a customer and their orders together in one document. No join is then needed to read them.

Key term

NoSQL database

A NoSQL database is a database that stores data using a model other than related tables, often with a flexible schema and a distributed design.

Part 1 done

2

Part 2 of 5: Flexible schemas and horizontal scaling define NoSQL

Two features explain why organisations choose NoSQL. The first concerns structure. A relational database has a fixed schema, so tables and data types are defined before any data is stored.

Many NoSQL databases use a flexible schema instead. Two records in the same collection can hold different fields. A new field can appear without redesigning the database.

The second feature is scale. Many NoSQL systems support horizontal scaling, which means adding more servers to share the load. Relational systems more often scale by upgrading one server.

Common mistake

NoSQL does not mean the data has no structure. The structure is simply less rigid.

Key terms · tap one for its definition

schema

A schema is the definition of a database’s structure, including its tables, fields, data types and relationships.

horizontal scaling

Horizontal scaling is increasing a system’s capacity by adding more servers, rather than upgrading a single server.

Part 2 done

Quick check

One question on the part you just read

Easy

Identify what the term NoSQL database describes.
Show answer and explanation

Answer: A · Worked explanation

A NoSQL database uses a model other than related tables, such as documents or key–value pairs. It can still be queried, so it is not an unqueryable relational database. NoSQL databases can store several kinds of data and are not limited to text. Historical data describes the purpose of a data warehouse.
3

Part 3 of 5: The best choice depends on the scenario

Choosing a database means matching its strengths to the task. The table compares the two approaches.

Relational compared with NoSQL

FeatureRelationalNoSQL
SchemaFixed in advanceOften flexible
RelationshipsJoined using keysOften stored inside documents or links
ConsistencyStrong, using transactionsVaries, sometimes relaxed
ScalingUsually verticalOften horizontal
Suited toAccurate, structured recordsVaried, fast-growing data
Feature
Schema
Relational
Fixed in advance
NoSQL
Often flexible
Feature
Relationships
Relational
Joined using keys
NoSQL
Often stored inside documents or links
Feature
Consistency
Relational
Strong, using transactions
NoSQL
Varies, sometimes relaxed
Feature
Scaling
Relational
Usually vertical
NoSQL
Often horizontal
Feature
Suited to
Relational
Accurate, structured records
NoSQL
Varied, fast-growing data

A bank needs every transfer to be accurate, so a relational database fits. A social app storing varied posts for millions of users may prefer NoSQL. Many organisations use both.

Match each feature to a need in the scenario. Ask whether accuracy, flexibility or growth matters most.

Exam tip

Justify your choice by linking a feature to the need in the scenario, such as accuracy or growth.

Go deeperConsistency trade-offs

Some distributed NoSQL systems accept that copies of data may briefly differ. This model is called eventual consistency. It favours speed and availability over instant agreement between copies.

A relational DBMS usually guarantees that each committed transaction leaves the data consistent. That makes it the safer choice when a mistake would be costly, as with payments.

Part 3 done

4

Part 4 of 5: A data warehouse gathers data from many sources for analysis

So far we have looked at databases that run daily tasks. An operational database supports an organisation’s day-to-day transactions, such as taking orders or updating stock. Organisations also need to study what happened over years.

A data warehouse is a large central store of data from many sources. It is built for analysis and reporting, not for daily transactions. It holds historical data that is mostly read and rarely changed.

Data enters the warehouse through ETL, which has three stages.

  • Extract: copy the data from each source system.
  • Transform: clean it and convert it to one consistent format.
  • Load: store the result in the warehouse.

Key terms · tap one for its definition

operational database

An operational database is a database that supports an organisation’s day-to-day transactions, such as taking orders or updating stock.

data warehouse

A data warehouse is a large central database that stores integrated, historical data from many sources to support analysis and reporting.

ETL

ETL is the process of extracting data from sources, transforming it into a consistent format and loading it into a data warehouse.

Part 4 done

Quick check

One question on the part you just read

Easy

Identify what happens in the transform stage of ETL.
Show answer and explanation

Answer: B · Worked explanation

Transform cleans the data and puts it into one consistent format so that data from different sources can be combined. Copying from the sources is the extract stage. Storing the result in the warehouse is the load stage. ETL does not require the source data to be deleted.
5

Part 5 of 5: Warehouses support decisions but bring cost and complexity

Once data is in a warehouse, analysts can search it for patterns. Data mining is the analysis of large datasets to find trends and relationships. A retailer might find which products sell best in each season.

Running this analysis on the warehouse keeps the operational systems fast. Staff and customers are not slowed down.

Advantages and disadvantages of data warehouses

AdvantagesDisadvantages
One consistent view of data from many sourcesCostly to build and maintain
Historical data supports trend analysisETL is complex and can introduce errors
Analysis does not slow operational systemsData may be out of date between loads
Supports better-informed decisionsConcentrated sensitive data is a security risk
Advantages
One consistent view of data from many sources
Disadvantages
Costly to build and maintain
Advantages
Historical data supports trend analysis
Disadvantages
ETL is complex and can introduce errors
Advantages
Analysis does not slow operational systems
Disadvantages
Data may be out of date between loads
Advantages
Supports better-informed decisions
Disadvantages
Concentrated sensitive data is a security risk

A warehouse is a tool, not a guarantee. Poor quality data loaded into it leads to poor decisions. Organisations therefore weigh the benefits of analysis against the cost of building and running the system.

Key term

data mining

Data mining is the analysis of large datasets to discover patterns, trends and relationships that are not obvious.

Note read

Check your recall[15 marks]

6 written questions. Answer each one in your head or on paper, then open the mark scheme.

  1. 1.Describe[2 marks]

    Describe two features of NoSQL databases.

    Show mark schemeHide mark scheme

    Model answer

    Many NoSQL databases have a flexible schema, so records can hold different fields without redesigning the database. Many also support horizontal scaling, which adds servers to share the load.

    • 1 mark for describing a flexible schema
    • 1 mark for describing horizontal scaling or another feature such as a non-relational data model
  2. 2.Distinguish[2 marks]

    Distinguish between the schema of a relational database and that of many NoSQL databases.

    Show mark schemeHide mark scheme

    Model answer

    A relational database has a fixed schema that defines tables and data types before data is stored. Many NoSQL databases have a flexible schema, so records can hold different fields.

    • 1 mark for stating that a relational schema is fixed in advance
    • 1 mark for stating that many NoSQL schemas are flexible
  3. 3.Discuss[3 marks]

    Discuss whether a relational or a NoSQL database is more suitable for the account records of a bank.

    Show mark schemeHide mark scheme

    Model answer

    A relational database suits a bank because the data is structured and every transfer must be accurate, which transactions and strong consistency support. A NoSQL database offers flexibility and scale, but its consistency may be weaker. The relational database is therefore the more suitable choice.

    • 1 mark for identifying that bank records are structured and must be accurate
    • 1 mark for stating that a relational database supports transactions and strong consistency
    • 1 mark for considering NoSQL strengths or weaknesses and reaching a conclusion
  4. 4.Explain[3 marks]

    Explain the purpose of a data warehouse in a large retail organisation.

    Show mark schemeHide mark scheme

    Model answer

    It collects data from many sources, such as tills and websites, in one consistent store. Analysts can use the historical data to find trends and support decisions. The analysis runs on the warehouse, so daily operational systems are not slowed.

    • 1 mark for stating that it combines data from many sources
    • 1 mark for explaining that historical data supports analysis and decisions
    • 1 mark for stating that it keeps operational systems from being slowed
  5. 5.Outline[3 marks]

    Outline the ETL process.

    Show mark schemeHide mark scheme

    Model answer

    Extract copies the data from the source systems. Transform cleans the data and converts it to one consistent format. Load stores the result in the data warehouse.

    • 1 mark for outlining extract as copying data from sources
    • 1 mark for outlining transform as cleaning and converting the data
    • 1 mark for outlining load as storing it in the warehouse
  6. 6.State[2 marks]

    State two disadvantages of data warehouses.

    Show mark schemeHide mark scheme

    Model answer

    They are costly to build and maintain. ETL is complex and can introduce errors, and the data may be out of date between loads.

    • 1 mark for stating one disadvantage
    • 1 mark for stating a second disadvantage

Practice this topic

10 quick-fire multiple-choice questions, easy to hard. Tap an answer to see if you're right and the worked explanation. (The written questions with mark schemes are under “Check your recall” above.)

0 right0 of 10 answered

Includes the 2 quick checks in the note above.

3.

Easy·State[1 mark]

State the main purpose of a data warehouse.
Show answer and explanation

Answer: C · Worked explanation

A data warehouse holds integrated, historical data so that analysts can study trends and report on them. Processing each order as it is placed is the job of an operational database. Spreading data across servers relates to horizontal scaling. A warehouse sits alongside operational databases and does not replace them.
4.

Medium·Identify[1 mark]

A social app stores posts whose fields differ from post to post, and the data grows quickly across many servers. Identify the most suitable type of database.
Show answer and explanation

Answer: D · Worked explanation

Posts with differing fields suit a flexible schema, and growth across many servers suits horizontal scaling, both features of NoSQL. A fixed schema would need redesign whenever the post fields changed. A data warehouse is for analysing historical data. A flat file cannot be spread across many servers.
5.

Medium·Identify[1 mark]

A company processes stock orders where every change must be recorded accurately by transactions. Identify the most suitable type of database.
Show answer and explanation

Answer: B · Worked explanation

Accurate, structured records changed by transactions are a strength of relational databases, which offer strong consistency. A graph database is chosen for linked data, not for strict transactions. A data warehouse is for analysis and is not used to process orders. Relaxed consistency would risk inaccurate stock records.
6.

Medium·Compare[1 mark]

Which statement correctly compares an operational database with a data warehouse?
Show answer and explanation

Answer: C · Worked explanation

An operational database handles day-to-day transactions, while a warehouse combines historical data from many sources for analysis. Saying the operational database gathers many sources and the warehouse only one reverses the roles, because the warehouse is the one that integrates sources. The warehouse is mostly read and rarely changed, so it is not changed constantly. Orders are processed by the operational database, and analysis is done on the warehouse, not the other way round.
7.

Medium·Identify[1 mark]

Identify a disadvantage of a data warehouse.
Show answer and explanation

Answer: A · Worked explanation

Because data enters the warehouse through ETL at intervals, it can lag behind the operational systems. The other statements describe benefits or abilities the warehouse does have: running analysis on the warehouse keeps operational systems fast, it exists to combine sources, and it exists to hold historical data.
8.

Hard·Determine[2 marks]

A retail chain has three shops whose tills record sales in different formats. Managers want reports on five years of sales trends. Determine the best approach.
Show answer and explanation

Answer: B · Worked explanation

ETL into a warehouse gives one consistent store of historical data and keeps analysis off the tills. Running reports on each operational database would slow trading and leave formats inconsistent. Flat files repeat data and are hard to combine. Separate document databases would keep the three formats apart, so trends could not be compared easily.
9.

Hard·Explain[2 marks]

A student says that NoSQL databases have no structure and cannot store related data. Which response is correct?
Show answer and explanation

Answer: A · Worked explanation

Many NoSQL databases hold structured documents or key–value pairs, so the data has structure that is simply less rigid. Related data can be stored together in one document or as links in a graph. The claim that relationships need a fixed schema is false, and so is the claim that NoSQL always has a fixed schema.
10.

Hard·Deduce[2 marks]

A hospital must record admissions accurately as they happen and also analyse ten years of patient outcomes. Deduce the best combination of systems.
Show answer and explanation

Answer: D · Worked explanation

Accurate, transaction-based admissions suit a relational operational database. Ten years of outcomes suit a warehouse, which is built for historical analysis. A warehouse alone is not meant for daily transactions. A key–value store with relaxed consistency is a poor fit for accuracy. A second warehouse still does not process transactions.

Keep going

Next topicA4.1 Machine learning fundamentalsPrevious topicA3.3 Database programming

More in A3 · Databases

  1. A3.1Database fundamentalsNotes · 10 questions
  2. A3.2Database designNotes · 10 questions
  3. A3.3Database programmingNotes · 10 questions
  4. A3.4Alternative databases and warehousesNotes · 10 questions· HL only

All IB Computer Science topics →

Draft: written by Scribe and checked automatically, not yet by a subject reviewer.

Practice questions are original, written by Scribe and checked automatically for correctness.

Topic codes follow the official numbering. Not endorsed by IB Diploma Programme or any exam board.

On this page

0/5 read

  1. 1NoSQL databases store data in non-relational forms
  2. 2Flexible schemas and horizontal scaling define NoSQL
  3. 3The best choice depends on the scenario
  4. 4A data warehouse gathers data from many sources for analysis
  5. 5Warehouses support decisions but bring cost and complexity
  6. Check your recall
  7. Practice: 10 questions
All coursesScribeHow it worksPricingPrivacyTerms

Notes and questions are written by Scribe in our own words. Topic codes follow the official course numbering so you can find your place. Not produced or endorsed by the IB, College Board, AQA, OCR, Pearson Edexcel or any exam board.

© 2026 Scribe