qookie:database
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
qookie:database [2008/11/09 08:54] – created deva | qookie:database [2009/01/04 17:21] – deva | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | =====Qookie Database Design===== | + | ======Qookie Database Design====== |
- | ====Design goals==== | + | =====Design goals===== |
- | the following is a prioritized list of design goals for the Qookie database. | + | The following is a prioritized list of design goals for the Qookie database. |
- | - **Simplicity**, | + | - **Simplicity**, |
- | - **Speed**, the database should respond quickly to searches. | + | - **Speed**, the database should respond quickly to search queries. |
+ | - **Ease of backup**, the database should be easy to backup. | ||
- **Portability**, | - **Portability**, | ||
+ | The following is a list of things that are **not** required by the Qookie database. | ||
+ | * **Size**, the database size will not be an issue, since it will probably never contain more than a couple of thousands entries. | ||
+ | |||
+ | =====Database middleware===== | ||
+ | The database is implemented through a middleware layer, in order to abstract the physical database access away from the data itself.\\ | ||
+ | This is also done in order to make porting the data storing to other databases an easy task. | ||
+ | |||
+ | =====Data definitions===== | ||
+ | ====Component==== | ||
+ | A component is the super class of all data components in Qookie. It contain all common attributes: | ||
+ | ^ Attribute | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | |||
+ | ===Preparation sequence=== | ||
+ | A named sequence of text blobs or images with a text blob, containing the atomic steps in a preparation procedure. | ||
+ | |||
+ | |||
+ | |||
+ | ====Ingredient==== | ||
+ | A basic ingredient, such as flour, an egg or a tomato.\\ | ||
+ | An ingredient is made out of the following attributes: | ||
+ | ^ Attribute | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | |||
+ | ====Dish==== | ||
+ | A single dish is an atomic component of a dish, i.e. cheese sauce, fried potatoes, meat balls. | ||
+ | ^ Attribute | ||
+ | | '' | ||
+ | |||
+ | ====Course==== | ||
+ | A course is a combination of several dishes all served together at the same time, i.e. fried potatoes with meat balls and cheese sauce. | ||
+ | ^ Attribute | ||
+ | | '' | ||
+ | |||
+ | ====Menu==== | ||
+ | A menu is a combination of dishes to be served together or after each other. A standard menu is aperitif, starter, main course and desert. | ||
+ | ^ Attribute | ||
+ | | '' |
qookie/database.txt · Last modified: 2009/01/04 19:09 by deva