Database management systems

Description

The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.

Alternative labels

DBMS
DB engines
SQL
database systems

Oracle Lite
IMS DB
Quadbase SQL Server
Model 204
YARD-SQL
Jasmine ii
Pervasive.SQL Workgroup
R:Base
POET Object Server Suite
SUPRA
Informix Extended Parallel Server
Advantage Database Server
Ingres ii
IDMS
Informix Dynamic Server 2000
Datacom
PointBase Mobile
PointBase Network Server
Rdb
UniData
Db.linux
Interbase
PointBase Embedded
Cloudscape
Db.star
Versant
Oracle 8I
TimesTen
DB2 Everyplace
NonStop SQL
Adabas
SQLBase
UniSQL
Adabas D
Objectivity DB
Adaptive Server Anywhere
Adaptive Server Enterprise
Raima Database Manager
Velocis
Pervasive.SQL 2000

Skill type

knowledge

Skill reusability level

sector-specific

Relationships with occupations

Essential knowledge

Database management systems is an essential knowledge of the following occupations:

Data warehouse designer: Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
Database integrator: Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Big data archive librarian: Big data archive librarians classify, catalogue and maintain libraries of digital media. They also evaluate and comply with metadata standards for digital content and update obsolete data and legacy systems.
Bioinformatics scientist: Bioinformatics scientists analyse biological processes using computer programmes. They maintain or construct databases containing biological information. Bioinformatics scientists gather and analyse biological data and may also assist scientists in various fields, including in biotechnology and pharmaceutics. They perform scientific research and statistical analyses, and report on their findings. Bioinformatics scientists may also collect DNA samples, discover data patterns and conduct genetic research.
Database administrator: Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users’ needs.
Database designer: Database designers specify the database’s logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
Data centre operator: Data centre operators maintain computer operations within the data centre. They manage daily activities within the centre to solve problems, maintain the system availability, and evaluate the system’s performance.
Database developer: Database developers program, implement and coordinate changes to computer databases based on their expertise of database management systems.
Editorial assistant: Editorial assistants support the editorial staff at all stages of the publication process of newspapers, websites, online newsletters, books and journals. They collect, verify and process information, acquire permits and deal with rights. Editorial assistants act as point of contact for the editorial staff, schedule appointments and interviews. They proofread and give recommendations on the content.

Optional knowledge

Database management systems is optional for these occupations. This means knowing this knowledge may be an asset for career advancement if you are in one of these occupations.

System configurator: System configurators tailor a computer system to the organisation’s and users’ needs. They adjust the base system and software to the needs of the customer. They perform configuration activities and scripting and ensure communication with users.
Chief data officer: Chief data officers manage companies’ enterprise-wide data administration and data mining functions. They ensure data are used as a strategic business asset at the executive level and implement and support a more collaborative and aligned information management infrastructure for the benefit of the organisation at large.

 


 

References

  1. Database management systems – ESCO

 

Last updated on September 20, 2022