All new methodology

Agile Query-Driven Data Modeling
for NoSQL

At the request of many of our enterprise customers, we have a developed a comprehensive course on data modeling for NoSQL database. The course is mostly vendor-neutral, with only the last 20% focused on advanced features of Hackolade.

Data modeling has been under pressure in the context of Agile development and NoSQL, with modelers sometimes feeling left out of the process. It is necessary to re-invent data modeling to make it relevant again!

Hackolade data modeling for NoSQL methodology

Course description

The JSON-based dynamic-schema nature (aka schema-less nature) of document NoSQL databases is a fantastic opportunity for application developers: ability to start storing and accessing data with minimal effort and setup, flexibility, fast and easy evolution. But moving to NoSQL requires a mind-shift, a new methodology, and new tools to leverage new capabilities such as: polymorphism, embedding, denormalization, and sharding. This data modeling course highlights the differences in the lifecycle, purpose, roles, and approach for data modeling for NoSQL in an Agile development environment. It covers in depth the design patterns and modeling techniques for various representative use cases and illustrates the patterns and best practices, including specific aspects of different NoSQL database vendors.

Learning objectives

• This class is a complete data modeling course for NoSQL, containing practical techniques for producing NoSQL physical data models.
• Participants will learn NoSQL schema design patterns applied to different illustrative use cases, including the migration from relational SQL schemas to denormalized schemas optimized to leverage the capabilities of NoSQL technology.
• Participants will learn not only how to build a NoSQL physical data model, but how to build it well, taking into account the differences with traditional SQL data modeling, as well as taking into account NoSQL vendor-specific aspects.
• The course also includes hands-on training for the Hackolade application, including exercises with general as well as advanced features.

Length

2-day course

Target audience

Anyone with one or more of these terms in their job title: "data", "analyst", "architect", "developer", "database", and "modeler"

Course outline

The course assumes some prior experience in data modeling for relational databases, but assumes no prior in-depth knowledge of NoSQL databases.
Most topics are illustrated by hands-on exercises and quizzes. The course is not a programming course!
• Introduction
• NoSQL overview
  o Why NoSQL?
  o JSON: embracing the document model
• NoSQL Data Modeling
  o Why re-invent Data Modeling?
  o The Hackolade methodology
  o Step-by-Step process
    • Domain-Driven Design
    • Workflow design
    • UX/UI design
    • Patterns & constraints
    • Physical modeling and style guide
      - Guiding principles & key levers
      - Denormalization patterns
      - Relationship patterns
      - Document design
      - Document keys
      - Sub-objects or arrays
      - Attribute values: empty, NULL, or missing
      - Naming conventions
    • Vendor-specific aspects
    • Optimization
      - Indexing
      - Partitioning and clustering
      - Data integrity
      - Joins
      - Transactions
• References
• NoSQL Data Modeling with Hackolade
  o Application overview
  o Modeling philosophy
  o UI fundamentals
  o Advanced features

Contact us at info@hackolade.com for more information