Skip to main content

Data Access Workflow

1. Use Cases​

  • What are the use cases?
  • Information about the use cases from the 6U request.
  • What screens are involved? and what are the data requirements for each screen?

2. API Access patterns​

  • What are the API access patterns by screen and action type?
  • What are the methods for Queries and Writes?
  • Are there realtime subscriptions?

3. API Design​

  • What are the API endpoints?
  • What are the API request and response methods and formats?
  • What are the API request and response validations?

4. Data Model​

  • What are the data models?
  • SQL:
    • What are the tables and columns?
    • What are the columns data types?
    • What are the indexes?
    • What are the foreign keys?
    • What are the relationships? (1-n, n-n, etc.)
  • NoSQL:
    • What are the collections and documents?
    • What are the document fields?
    • What are the indexes?
    • What are the relationships? (1-n, n-n, etc.)
    • What are the data types?
    • What are the key constraints? Primary, sort key, etc.

5. Database Access patterns​

  • How do we access the database?
  • How are the queries and writes mapped to the API endpoints and methods?
  • Are there advanced queries such as joins or specialized geohash?