Database For Grade 11 IT

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/13

encourage image

There's no tags or description

Looks like no tags are added yet.

14 Terms

1
New cards

DBMS

software that facilitates the creation, maintenance, and querying of databases, providing an interface between users and the data.

2
New cards

Desktop Databases

Databases designed to be used on individual computers, often for personal or small-scale purposes.

3
New cards

Server Database

A database hosted on a server, accessible by multiple users or applications over a network.

4
New cards

Distributed Database

A database spread across multiple locations or servers, allowing data to be stored and managed in different physical locations.

5
New cards

Data Synchronisation

The process of ensuring that data across different databases or replicas remains consistent and up-to-date.

6
New cards

Duplication

The replication of data across multiple locations or databases, often for redundancy or performance improvement.

7
New cards

Partitioning

The practice of dividing a large database into smaller, more manageable segments for easier maintenance and improved performance. Each site manages its own data and uploads the data to the central database.

8
New cards

Database administrator

a person responsible for the design, implementation, maintenance, and security of databases.

9
New cards

UNIX Administrator

A professional responsible for managing and maintaining UNIX or UNIX-like operating systems, often including database servers.

10
New cards

Database Analysts

Individuals who analyze an organization's data requirements, design database systems, analyse efficiency and maintenance of database and ensure they meet business needs.

11
New cards

DB Programmers

Programmers who develop custom made software applications that interact with databases, creating, retrieving, and manipulating data as needed.

12
New cards

Project Managers

Professionals who oversee the planning, execution, and completion of database projects, ensuring they meet objectives and deadlines.

13
New cards

Data Warehouse

A centralized repository that stores data from various sources, optimized for analysis and reporting.

14
New cards

Data Mining

The process of discovering patterns, trends, or insights from large datasets stored in databases or data warehouses.