The heart of modern information systems
Database systems are the mainstay of modern information systems. Whether SAP, Mainframe or Web systems - there’s a database behind them all. The majority of modern information systems have relational databases. Hierarchical database systems are still to be found in host environments. In recent years, NoSQL(Not Only SQL) databases have grown in importance, which are based on Store/Load and Search optimisation. In-memory technology current presents the most promising development, now integrated in renowned manufacturers’ products and which achieves previously unattainable processing speeds.
Adequate modelling of a database is one of the key factors for the success of an information system. The modelling of a relational database demands a lot of experience. It is essential in this respect to weigh up compliance of normalisation against specific denormalisation for performance reasons. A clear index structure and a profound knowledge of the optimiser are basic prerequisites for high-performance yet secure query design.
Maximising performance has also been the driving force behind the current trend for integrating in-memory concepts into traditional database systems. So now, for example since Oracle 12c, tables can be loaded into the main memory, with subsequent access no longer requiring time-wasting reading from the hard drive. Performance gain can be achieved by the simultaneous transfer to a column-based memory structure, particularly with OLAP applications – and that without the need to adapt the application.
One of the main aims of NoSQL databases is extremely short response times with thousands of user queries. However, it is tried here by means of horizontal scaling. NoSQL databases reveal their strengths when the highly available, high-performance processing of rather unstructured content is called for and, at the same time, the requirements governing transaction security are of lesser importance. Together with their flexibility when it comes to data modelling, NoSQL databases are often the first choice for Web 2.0 applications.
- Database design
- Relational modelling
- Targeted normalisation/denormalisation
- Optimisation to performance and/or size, including use of the in-memory option
- Host server coupling using gateway technologies (e.g. DB2-Oracle)
- Database migrations
- Upscaling from MySQL to PostgreSQL or Oracle
- License savings through the use of PostgreSQL, MySQL or Firebird
- Design and development of distributed replicated database systems
- Database programming
- Database security
- Roles and rights concept
- Data encryption
We are familiar with database systems of all sizes and use scenarios. Our experience ranges from company-wide large DB2 computer databases and their use on distributed, heterogeneous synchronised Oracle structures on Unix systems to large business-critical databases based on Linux and PostgreSQL.
Our experience is based on many years of working for large corporations, including BMW and Audi, and on the daily use of large databases in our in-house systems.
- Relational database systems
- MS SQL Servers
- In-memory databases
- Oracle 12c (In-Memory-Option)
- MS SQL-Server 2014 (Hekaton)
- NoSQL database systems
- Hierarchical database systems