database management systems
The tools for creating, updating and managing databases, such as Oracle, MySQL and Microsoft SQL Server.
digital
Database integrators perform integration among different databases. They maintain integration and ensure interoperability.
Competences and skills
67 ESCO relationsEssential knowledge 7 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
6 competencesdomain name service
Naming database which maps internet domain names to Internet Protocol (IP) addresses. The Domain Name System allows internet users to utilise names such as website titles instead of remembering numeric IP addresses used by computers to locate a concrete website
digital
ICT debugging tools
The ICT tools used to test and debug programs and software code, such as GNU Debugger (GDB), Intel Debugger (IDB), Microsoft Visual Studio Debugger, Valgrind and WinDbg.
digital
information structure
The type of infrastructure which defines the format of data: semi-structured, unstructured and structured.
digital
query languages
The field of standardised computer languages for retrieval of information from a database and of documents containing the needed information.
digital
resource description framework query language
The query languages such as SPARQL which are used to retrieve and manipulate data stored in Resource Description Framework format (RDF).
digital
Cross-sector
1 competencedata extraction, transformation and loading tools
The tools for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure.
digital
Essential skills and competences 10 competences
Occupation specific
1 competenceuse interface description language
Utilise specification language for describing interface connection among software components or programs in a programming-language-independent way. The languages which support this method are among others CORBA and WSDL.
digital
Sector-specific
8 competencesbalance database resources
Stabilise the workload and resources of a database, by controlling the demand of transactions, allocating disk spaces and ensuring reliability of the servers in order to optimise cost and risk ratio.
digital
create database diagrams
Develop the database design models and diagrams which establish the structure of a database by using modelling software tools to be implemented in further processes.
digital
execute integration testing
Perform testing of system or software components grouped in multiple ways to evaluate their ability to interconnect, their interface and their ability to provide global functionality.
digital
implement data warehousing techniques
Apply models and tools such as online analytical processing (OLAP) and Online transaction processing (OLTP), to integrate structured or unstructured data from sources, in order to create a central depository of historical and current data.
digital
integrate ICT data
Combine data from sources to provide unified view of the set of these data.
digital
manage data
Administer all types of data resources through their lifecycle by performing data profiling, parsing, standardisation, identity resolution, cleansing, enhancement and auditing. Ensure the data is fit for purpose, using specialised ICT tools to fulfil the data quality criteria.
digital
manage ICT legacy implication
Oversee the transfer process from a legacy (an outdated system) to a current system by mapping, interfacing, migrating, documenting and transforming data.
digital
verify formal ICT specifications
Check capabilities, correctness and efficiency of intended algorithm or system to match certain formal specifications.
digital
Cross-sector
1 competenceperform data cleansing
Detect and correct corrupt records from data sets, ensure that the data become and remain structured according to guidelines.
digital
Optional knowledge 38 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
33 competencesCA Datacom/DB
The computer program CA Datacom/DB is a tool for creating, updating and managing databases, currently developed by the software company CA Technologies.
digital
DB2
The computer program IBM DB2 is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
Filemaker (database management systems)
The computer program FileMaker is a tool for creating, updating and managing databases, developed by the software company FileMaker Inc.
digital
IBM Informix
The computer program IBM Informix is a tool for creating, updating and managing databases, developed by the software company IBM.
digital
IBM InfoSphere DataStage
The computer program IBM InfoSphere DataStage is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company IBM.
digital
IBM InfoSphere Information Server
The software program IBM InfoSphere Information Server is a platform for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company IBM.
digital
Informatica PowerCenter
The computer program Informatica PowerCenter is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Informatica.
digital
inter-organisational middleware system
A software infrastructure that acts as an intermediary layer between applications to enable data exchange, interoperability and communication. It aims to provide standardised protocols and services between organisations to promote their interaction.
digital
LDAP
The computer language LDAP is a query language for retrieval of information from a database and of documents containing the needed information.
digital
LINQ
The computer language LINQ is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
digital
MarkLogic
The NoSQL enterprise non-relational database used for creating, updating and managing large amounts of unstructured data stored in the cloud and which provides features such as semantics, flexible data models and Hadoop integration.
digital
MDX
The computer language MDX is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Microsoft.
digital
Microsoft Access
The computer program Access is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
MySQL
The computer program MySQL is a tool for creating, updating and managing databases, currently developed by the software company Oracle.
digital
N1QL
The computer language N1QL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the software company Couchbase.
digital
ObjectStore
The computer program ObjectStore is a tool for creating, updating and managing databases, developed by the software company Object Design, Incorporated.
digital
OpenEdge Database
The computer program OpenEdge Database is a tool for creating, updating and managing databases, developed by the software company Progress Software Corporation.
digital
Oracle Data Integrator
The computer program Oracle Data Integrator is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Oracle.
digital
Oracle Relational Database
The computer program Oracle Rdb is a tool for creating, updating and managing databases, developed by the software company Oracle.
digital
Oracle Warehouse Builder
The computer program Oracle Warehouse Builder is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Oracle.
digital
Pentaho Data Integration
The computer program Pentaho Data Integration is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Pentaho.
digital
PostgreSQL
The computer program PostgreSQL is a free and open-source software tool for creating, updating and managing databases, developed by the PostgreSQL Global Development Group.
digital
QlikView Expressor
The computer program QlikView Expressor is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Qlik.
digital
SAP Data Services
The computer program SAP Data Services is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company SAP.
digital
SAS Data Management
The computer program SAS Data Management is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company SAS.
digital
SPARQL
The computer language SPARQL is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation World Wide Web Consortium.
digital
SQL Server
The computer program SQL Server is a tool for creating, updating and managing databases, developed by the software company Microsoft.
digital
SQL Server Integration Services
The computer program SQL Server Integration Services is a tool for integration of information from multiple applications, created and maintained by organisations, into one consistent and transparent data structure, developed by the software company Microsoft.
digital
system design
The process of defining the architecture for different components and modules of a system, as well as the relevant data, for satisfying specific requirements.
digital
systems theory
The principles that can be applied to all types of systems at all hierarchical levels, which describe the system's internal organisation, its mechanisms of maintaining identity and stability and achieving adaptation and self-regulation and its dependencies and interaction with the environment.
digital
Teradata Database
The computer program Teradata Database is a tool for creating, updating and managing databases, developed by the software company Teradata Corporation.
digital
TripleStore
The RDF store or TripleStore is a database used for storage and retrieval of Resource Description Framework triples (subject-predicate-object data entities) which can be accessed by semantic queries.
digital
XQuery
The computer language XQuery is a query language for retrieval of information from a database and of documents containing the needed information. It is developed by the international standards organisation World Wide Web Consortium.
digital
Cross-sector
5 competencesbusiness intelligence
The tools used to transform large amounts of raw data into relevant and helpful business information.
digital
data engineering
The process of developing and constructing systems for implementing data collection and analysis at large scale.
digital
database
The classification of databases, that includes their purpose, characteristics, terminology, models and use such as XML databases, document-oriented databases and full text databases.
digital
digital systems
Systems to store, process and spread information in digital form. They are hardware, software and networks, as well as the ways in which these can be employed.
digital
systems development life-cycle
The sequence of steps, such as planning, creating, testing and deploying and the models for the development and life-cycle management of a system.
digital
Optional skills and competences 12 competences
Occupation specific
0 competencesNo competences in this bucket.
Sector-specific
10 competencesapply ICT systems theory
Implement principles of ICT systems theory in order to explain and document system characteristics that can be applied universally to other systems
digital
define data quality criteria
Specify the criteria by which data quality is measured for business purposes, such as inconsistencies, incompleteness, usability for purpose and accuracy.
define integration strategy
Specify strategies for system integration, incorporating the time schedule, the processes required to combine components into subsystems and systems, the means on how components will interface as well as the risks associated with the integration.
digital
design application interfaces
Create and program application interfaces, their operations, inputs and outputs and underlying types.
digital
- Scope note
- Application interfaces include Application Programming Interfaces (API).
execute ICT audits
Organise and execute audits in order to evaluate ICT systems, compliance of components of systems, information processing systems and information security. Identify and collect potential critical issues and recommend solutions based on required standards and solutions.
digital
manage cloud data and storage
Create and manage cloud data retention. Identify and implement data protection, encryption, and capacity planning needs.
digital
manage ICT semantic integration
Oversee integration of public or internal databases and other data, by using semantic technologies to produce structured semantic output.
digital
perform data mining
Explore large datasets to reveal patterns using statistics, database systems or artificial intelligence and present the information in a comprehensible way.
digital
- Scope note
- Includes activities on big data.
use scripting programming
Utilise specialised ICT tools to create computer code that is interpreted by the corresponding run-time environments in order to extend applications and automate common computer operations. Use programming languages which support this method such as Unix Shell scripts, JavaScript, Python and Ruby.
digital
write database documentation
Develop documentation containing information about the database that is relevant to end users.
Cross-sector
2 competencescreate solutions to problems
Solve problems which arise in planning, prioritising, organising, directing/facilitating action and evaluating performance. Use systematic processes of collecting, analysing, and synthesising information to evaluate current practice and generate new understandings about practice.
perform project management
Manage and plan various resources, such as human resources, budget, deadline, results, and quality necessary for a specific project, and monitor the project's progress in order to achieve a specific goal within a set time and budget.
research