qookie:database
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
qookie:database [2008/11/09 09:01] – deva | qookie:database [2009/01/04 19:09] (current) – 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**, | ||
Line 10: | Line 10: | ||
* **Size**, the database size will not be an issue, since it will probably never contain more than a couple of thousands entries. | * **Size**, the database size will not be an issue, since it will probably never contain more than a couple of thousands entries. | ||
- | ====Database middleware==== | + | =====Database middleware===== |
The database is implemented through a middleware layer, in order to abstract the physical database access away from the data itself.\\ | 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. | 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 | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | | '' | ||
+ | |||
+ | |||
+ | ====Recipe==== | ||
+ | A recipe 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.1226217661.txt.gz · Last modified: 2008/11/09 09:01 by deva