Silicon Valley Code Camp : October 1 & 2, 2016session
Demystifying Databases with Platform-Independent Schema
Starting from a conceptual perspective, explore the patterns of platform-independent database design. This session will show you how thinking about records as physical objects illuminates the meaning of complicated queries.
About This Session
Starting from a conceptual perspective, join with me to explore the patterns of platform-independent database design and how 1schema.com uses these patterns to automate complex database implementation tasks.
We will look at the database holistically; capturing both stored and computed values in our schema diagrams. This will yield a view of the database as a series of tubes that transports information through multiple transformations to produce useful results (think like the board game "Snakes and Ladders").
We will use the analogy of data as “water” to show how the same physical principles that apply to the pipes in your house can greatly inform your conceptual understanding of database design.
By specifying schema in a way that clearly indicates the paths through which data can “flow”, you will develop an intuitive understanding of which tables allow data to flow automatically, and which tables require “work” (i.e. aggregation) to move data against the natural “gravity” of your schema.
While simple at heart, this presentation will leverage Domain-Driven Design and the Enterprise Integration Patterns (aka Enterprise Messaging Patterns) to show how spreadsheet-style Formulas can be used to efficiently encode SQL and MapReduce logic in your schema.
Finally, we will show how 1schema.com can be used as a powerful tool to automate complex tasks based on this shared conceptual understanding.
Also, we will provide a "Snakes and Ladders" board game for kids to play.