Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Sample data models in NoSQL Workbench

Focus mode
Sample data models in NoSQL Workbench - Amazon Keyspaces (for Apache Cassandra)

The home page for the modeler and visualizer displays a number of sample models that ship with NoSQL Workbench. This section describes these models and their potential uses.

Employee data model

This data model represents an Amazon Keyspaces schema for an employee database application.

Applications that access employee information for a given company can use this data model.

The access patterns supported by this data model are:

  • Retrieval of an employee record with a given ID.

  • Retrieval of an employee record with a given ID and division.

  • Retrieval of an employee record with a given ID and name.

Credit card transactions data model

This data model represents an Amazon Keyspaces schema for credit card transactions at retail stores.

The storage of credit card transactions not only helps stores with bookkeeping, but also helps store managers analyze purchase trends, which can help them with forecasting and planning.

The access patterns supported by this data model are:

  • Retrieval of transactions by credit card number, month and year, and date.

  • Retrieval of transactions by credit card number, category, and date.

  • Retrieval of transactions by category, location, and credit card number.

  • Retrieval of transactions by credit card number and dispute status.

Airline operations data model

This data model shows data about plane flights, including airports, airlines, and flight routes.

Key components of Amazon Keyspaces modeling that are demonstrated are key-value pairs, wide-column data stores, composite keys, and complex data types such as maps to demonstrate common NoSQL data-access patterns.

The access patterns supported by this data model are:

  • Retrieval of routes originating from a given airline at a given airport.

  • Retrieval of routes with a given destination airport.

  • Retrieval of airports with direct flights.

  • Retrieval of airport details and airline details.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.