In emakin 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 your needs.
Relational Database
Provides storage for a 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.
...
XML Database
Provides storage for a small or large medium number of large size entities in a hierarchy. Database operations are generally performed with by reading or writing full fully on a tree of entities.
Advantages
- Ideal for highly variable data structures , and even unstructured data.
- Optimized for extremely fast storage and retrieval of 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 document the XML database section for more information.
...
Provides storage for binary files with small or large sizesizes. Please refer to to the file database section for more information.
...
- Efficient for binary files.
- Full-text indexing
Disadvantages
- Only stores accessible from the file content.id