Skip to content

Databases

Emakin supports various database types—relational, XML, file, and document—allowing flexible data storage based on specific needs. A single process can utilize multiple database types concurrently (e.g., customer data in a relational database, documents in a file database, and order details in a document database).

Relational Database

Suitable for storing a large number of small, structured entities. Operations typically affect a small subset of data without impacting others.

Advantages:

  • High performance for large datasets.
  • Efficient handling of small data changes with logging and rollback capabilities.

Disadvantages:

  • Requires a predefined schema.
  • Schema must be consistent across all entities.
  • Requires database administration expertise.

See the relational database section for details.

XML Database

Stores a smaller to medium number of large, hierarchical entities. Operations usually involve entire entity trees.

Advantages:

  • Handles highly variable and unstructured data effectively.
  • Optimized for rapid retrieval of complete documents or objects.

Disadvantages:

  • Performance degrades when joining data outside the entity tree is required.

See the XML database section for details.

File Database

Stores binary files of varying sizes. See the file database section for details.

Advantages:

  • Efficient binary file storage.

Disadvantages:

  • Access is limited to file IDs.