In emakin you can store all kinds of relational or document based data, including files. Depending on your needs you are free to choose which database to use. For example, a process may store all customer information on in a relational database, store all quote documents in a file database, and store order information on in a document database for further analysis.
Each database type has its own advantages or disadvantages depending on upon your needs.
Relational Database
Provides storage for large number of small entities. Database operations are generally performed on a small number of entities without affecting other entities.
...
- Stores large number of entities without losing any performance lost.
- Efficient at processing small changes to data that can be logged and rolled-back (undone) if required.
Disadvantages
- You have to specify a database schema.
- Database schema must be identical for all of the entities.
- Technical and engineering knowledge is required to manage it.
Please refer to to the relational database section for more information.
...
Provides storage for small or large number of large size entities in a hierarchy. Database operations are generally performed with reading or writing full on tree of entities.
...
- Ideal for highly variable data structures, and even unstructured data.
- Optimized for extremely fast storage and retrieval of the whole documents or objects.
Disadvantages
- Slow performance when need to join the other data, out of the entity tree needs to be joined.
Please refer to the xml database section for more information.
...
Provides storage for binary files with small or large size. Please refer to to the file database section for more information.
...
Disadvantages
- Only accessible from the file id