Databases

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 in a relational database, store all quote documents in a file database, and store order information 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.

Advantages

• Stores large number of entities without losing any performance.
• 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 the relational database section for more information.

XML Database

Provides storage for a small or medium number of large size entities in a hierarchy. Database operations are generally performed by reading or writing 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 the other data, out of the entity tree needs to be joined.

Please refer to the XML database section for more information.

File Database

Provides storage for binary files with small or large sizes. Please refer to the file database section for more information.

Advantages

• Efficient for binary files.
• Full-text indexing

Disadvantages

• Only accessible from the file id