Type Design
easyAsPieDB allows you to design Record Types representing information you need to keep track of. A Record Type assigns a name and layout to a complex piece of information made up from multiple simpler pieces. For example, instead of saying: "a first name, a last name and a phone number", you can simply say: a Contact.
- When you want to create a list of "first names, last names and phone numbers", you instruct easyAsPieDB to create a Table of the Contact Record Type.
- If you need to change the layout of a Contact Table you already have, for example by adding a Date for a Birthday, all you need to do is change the Contact Record Type. All your Tables of the Contact Record Type will be updated automatically.
Object-Orientation
easyAsPieDB replaces traditional, structural information design concepts such as "related tables" and "foreign keys" with object-oriented, intuitive concepts such as Composition and References.
- In Composition, one Record is an integral part of another Record, for example an Address inside a Contact.
- A Reference is an association of one Record with another Record, for example an Order referencing the purchased Product.
You can not only design a custom Product (e.g., with Text and an Image), not only design a specialized Order (e.g., with a Date and a Signature), but also have each new Order specify a known Product, effortlessly.
Hierarchical Organization
easyAsPieDB allows you to group information that is related in a way that's meaningful to you into Collections.
- A Collection can include any number of Tables to be grouped together.
- A Collection can include other Collections, thus organizing information hierarchically into a tree-like structure of containers of unlimited depth, analogous to traditional files and folders.