SQL • BITS | Business IT Solutions

Relational databases | Oracle | SQL Server | Postgres | MySQL
SQL (Structured Query Language) is a database language used to structure, store and query data in relational databases. It is mainly used to query and manipulate data from relational database management systems (RDBMS).

SQL is often used in combination with other technologies such as PHP, Java or C# to create dynamic websites and applications based on databases. Some examples of applications that use SQL include customer management systems, e-commerce platforms, and financial management tools.

There are many different RDBMSs that support SQL, including MySQL, Oracle, Microsoft SQL Server, and PostgreSQL. There are also many tools and applications that support SQL, including database development platforms such as MySQL Workbench and SQL Server Management Studio.

BITS experts have used SQL in a wide range of projects. A selection of case studies and references can be found below.

Migration of a Java business application to Docker as well as startup within a Kubernetes cluster
Migration of a Java business application to Docker as well as startup within a Kubernetes cluster
Custom Software, Homepage, References, Web development

Migration of a Java business application to Docker as well as startup within a Kubernetes cluster

In this project, the task was to migrate a hotel management software consisting of Java backend, relational database and Angular frontend from a native server environment to a Kubernetes cluster. At the same time, the Kubernetes cluster was designed, rebuilt and commissioned.

Cost savings by reducing the amount of memory consumed by SAP systems, establishing monitoring and increasing performance
Cost savings by reducing the amount of memory consumed by SAP systems, establishing monitoring and increasing performance
Homepage, IT Consulting, IT Project Management

Cost savings by reducing the amount of memory consumed by SAP systems, establishing monitoring and increasing performance

The goal of the SAP project was to reduce existing storage consumption and thereby save costs in the seven-digit range per year, both in the short term and in the long term.

Development of a web application and a mobile app to improve breast cancer patient follow-up.
Development of a web application and a mobile app to improve breast cancer patient follow-up.
App development, Homepage, Web development

Development of a web application and a mobile app to improve breast cancer patient follow-up.

Together with AIM-Apps in Medicine GmbH, AOK Bayern, DAK Gesundheit and Siemens Betriebskrankenkasse (SBK), under the direction of the Klinikum rechts der Isar of the Technical University of Munich (MRI), BITS GmbH participated in the PRISMA study as a consortium partner for the technical infrastructure.

Supporting an automotive manufacturer with end-of-support migration
Supporting an automotive manufacturer with end-of-support migration
IT Consulting, IT Project Management, MAN, References, Transition Management

Supporting an automotive manufacturer with end-of-support migration

On-time service migration with support from BITS in the areas of IT project management and IT consulting

Connection of production machines of a medium-sized manufacturer to the Industry 4.0 OEE solution of BITS for monitoring and optimization of production
Connection of production machines of a medium-sized manufacturer to the Industry 4.0 OEE solution of BITS for monitoring and optimization of production
easy2cool, Homepage, MVP, References

Connection of production machines of a medium-sized manufacturer to the Industry 4.0 OEE solution of BITS for monitoring and optimization of production

The task of BITS was to monitor and control production machines with the help of an OEE solution in order to optimize quality, utilization and costs.

Development and operation of the DACH wide Internet e-commerce platform www.getraenkedienst.com
Development and operation of the DACH wide Internet e-commerce platform www.getraenkedienst.com
App development, carrying service, Homepage, IT Quality Assurance, References, Web development

Development and operation of the DACH wide Internet e-commerce platform www.getraenkedienst.com

Together with drink now GmbH as a specialist in the field of beverage distribution, BITS GmbH as a strategic IT partner has built up the Internet e-commerce platform www.getraenkedienst.com and successfully operates it to this day.

Realization of MVPs
Realization of MVPs
IT Project Management, MVP, References

Realization of MVPs

BITS has realized a large number of MVPs, prototypes or proof of conctepts. The central goal here is to test a new idea, an alternative orientation or an improvement with the least possible effort and, if successful, to expand it further.