You are here

Databases

Databases

Relational Database Management Systems (RDBMS)

Codra uses the main databases available on the market: SQL Server, Oracle, MySql, Sybase, PostgresSQL, etc. We have implemented these databases in demanding environments (over 50,000 insertions per second, over 150 million records per table, etc.)

Object-Relational Mapping (ORM)

Codra no longer uses object-oriented databases for projects. They have been replaced by Object-Relational Mapping components. These components allow developers to configure objects so as to link them with their representation in a relational database. The components we use depend on the programming language:

  • Java:
    • Apache ObJectRelationalBridge
    • Hibernate
  • .NET :
  • ADO.NET Entity Framework (Linq)

Real-time databases

Traditional DBMSs cannot meet real-time requirements as they do not include mechanisms for handling time constraints; their performance objectives are to minimize transaction response times. In contrast to traditional database management, the data in a real-time database must be managed so as to both retain logical consistency (i.e. they must meet integrity requirements) and meet time constraints. In this case, we use a real-time UML. In order to meet time constraints concerning transactions, real-time tasks can run in parallel with real-time transactions. This mainly involves specifying the various types of time constraints in sequence diagrams.