An easy-to-use guide for developers and data architects
building databases with SQL & Data Model patterns.
To find out about our easy ordering and pricing click here.
Or, continue reading and see how data patterns benefit your work.
If your goal is to create better databases with proven data model patterns and more effective SQL, then this unique package is for you. There is nothing like it!
The SQL Pattern Framework contains design patterns for SQL, data models, and data architectures which simplify your work when it comes to creating databases. Don't waste time reinventing the wheel, use the SQL Framework to get started.
It covers multiple pattern categories including: SQL and Data Access Patterns, Data Model Patterns, Data Persistence Patterns, Auditing & Archiving Patterns, Data Experience Patterns, and Meta Model Patterns.
And we go beyond theory: all patterns are available in real-world reference applications.
SQL is the query language of relational databases. SQL is unique in that it is a set-oriented language as opposed to record-oriented programming languages. In SQL you only specify what is needed and not how the data is retrieved.
A wide variety of SQL Patterns is covered including CRUD patterns (with hard, soft, undo deletes), JOIN patterns, Subqueries, SQL Batching, NULL value Patterns, Table aliases, SQL Namespace patterns, SQL Injection, and more.
This package emphasizes simple, fast SQL with ultra-short transactions and how to accomplish this through effective patterns and practices.
Experienced data architects know that a solid data model is key to building successful databases.
A suboptimal data model will make it difficult for developers to get data in and out of the database. Applications suffer because they need to perform SQL gymnastics to retrieve and store data. This package will show you how to design simple, effective data models using patterns.
Introductory data patterns include: ER diagrams, Primary key, Foreign keys, Data types, Referential integrity, and Indexing patterns.
Advanced data patterns include: Record name, Rollup column, Sort column, Snapshot, Journaling, Enumeration, Name-Value, Missing marker, External ID, and more. Just this set of patterns is worth the price of the entire package!
A section on anti-patterns discusses database smells including value smells, column smells, table smells, database smells, and transaction smells. Applying patterns to eliminate these will help you build better databases.
What do I get with this package? Here is a complete table of contents.
The SQL Pattern Framework comes with 2 comprehensive reference applications which allow you
to experience and explore the data patterns first hand in a real-world environment.
These are screenshots of the 'Training' application which represents a fictitious software training company.
Many of the data patterns have a visual manifestation in the UI. Those that do are marked with a pattern icon in the application.
Hovering over these icons will show which pattern is at work. As you can see below, many of these patterns have an impact on the user experience.
Below are screenshots of the 'MetaPlus' reference application.
This application will knock your socks off. The meta models in this application allow users to create their own entities and attributes. Essentially the user starts with a blank slate and then builds their own solution (referred to as citizen development).
This is made possible by using meta model patterns and doesn't require any database or code changes! Very powerful.
(note: full documentation on meta models is only available in the PRO edition)
Of course, data models and ER diagrams are available throughout the package.
The SQL + Database Design Pattern Framework is a unique package that will show you how to build effective databases through patterns. You will learn to design, build, and access modern databases like a pro and gain a competitive edge, which you can build upon every day. But it takes action.
Ordering is easy. Select the license you need and click 'Order Now'. Following payment you will receive a confirmation email with download instructions. Download, install, and you're ready to go.
Your purchase includes a 1-year subscription which gives you FREE access to any new or updated releases during that period.
|There is no risk. Your purchase is 100% backed with a full 60-day money back guarantee! You will have plenty of time to explore and apply these patterns in your own work.|