G11 IT Database and Info

• DBMS: software that facilitates the creation, maintenance, and querying of databases, providing an interface between users and the data.
• Desktop Databases: Databases designed to be used on individual computers, often for personal or small-scale purposes.
• Server Database: A database hosted on a server, accessible by multiple users or applications over a network.
• Distributed Database: A database spread across multiple locations or servers, allowing data to be stored and managed in different physical locations.
• Data Synchronisation: The process of ensuring that data across different databases or replicas remains consistent and up-to-date.
• Duplication: The replication of data across multiple locations or databases, often for redundancy or performance improvement.
• 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.
• Database administrator: a person responsible for the design, implementation, maintenance, and security of databases.
• UNIX Administrator: A professional responsible for managing and maintaining UNIX or UNIX-like operating systems, often including database servers.
• 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.
• DB Programmers: Programmers who develop custom made software applications that interact with databases, creating, retrieving, and manipulating data as needed.
• Project Managers: Professionals who oversee the planning, execution, and completion of database projects, ensuring they meet objectives and deadlines.
• Data Warehouse: A centralized repository that stores data from various sources, optimized for analysis and reporting.
• Data Mining: The process of discovering patterns, trends, or insights from large datasets stored in databases or data warehouses.