For several years now, researchers have expressed the desire to set up a database for their research data in consultations. But we have noticed that people’s definitions and ideas of what a database really is differ starkly.

What is a database and what is a database system?   

A database is an organized collection of structured information or data that is typically stored electronically in a computer system. A database management system (DBMS) does exactly what it says in the name – it manages the database. When combined, the data, the DBMS and the associated applications make up the database system. 

In an SQL database, the data is typically arranged in tables with rows and columns, enabling them to be efficiently accessed, managed and modified via Structured Query Language (SQL). More and more frequently, NoSQL databases (Not only SQL) are used in addition to SQL databases. These enable optimized solutions for other use cases.

How can I get my own database at TUD?  

If you require a central database that is accessible to many employees from anywhere, you can apply at the ZIH for a virtual machine within Enterprise Cloud, where you can have a DBMS of your choosing set up and operated, including a web server. 

If your group of employees is on the small side and they don’t frequently need to access the virtual machine, Microsoft Access is a good alternative. This software can be installed and used easily via the free Microsoft package. Your database is then saved as a local file rather than in a centrally located server. This file can be shared with colleagues for everyone to edit, for instance via a shared drive. 

If you only need to manage simple data models and small amounts of data, you can also turn to Microsoft SharePoint. This system allows you to provide employees with centralized access to the data.  

Do you need a database for your work but you aren’t sure about the associated setup and operation requirements? The Service Center Research Data is happy to help you find a suitable system and can even help you get it up and running. Please contact us at Service Center Research Data by email or book an appointment.