Information Systems - Databases

Information Systems - Databases database ️ An organized collection of data, including schemas, tables, queries, reports, views, and other objects. database management system (DBMS) ️ A computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. general-purpose DBMS ️ Designed to allow the definition, creation, querying, update, and administration of databases. data warehouse ️ A central repository of integrated data from one or more disparate sources used for reporting and data analysis. data mining ️ The computational process of discovering patterns in large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics, and database systems. relational database management system ️ A database management system that is based on representing data in terms of ordered sets of elements (tuples), grouped into relations (tables). hierarchical database model ️ A data model in which the data is organized into a tree-like structure. network model ️ A database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice. management strategies ️ Include registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information that has been corrupted by some event such as an unexpected system failure. centralized database ️ A database that is located, stored, and maintained in a single location. client/server ️ A distributed application structure that partitions tasks or workloads between the providers of a resource or service and service requesters. data cleansing ️ The process of detecting and correcting or removing corrupt or inaccurate records from a record set, table, or database. database administrator (DBA) ️ The role responsible for installation, configuration, design, migration, capacity planning, performance monitoring, security, troubleshooting, as well as backup and recovery of a database or databases. database model ️ Determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized, and manipulated. database schema ️ The structure of a database described in a formal language supported by the database management system. dirty data ️ Inaccurate, incomplete, or erroneous data, especially in a computer system or database. distributed database ️ A database in which portions of the database are stored on multiple computers within a network. export ️ The act or process of retrieving data out of data sources for further data processing or data storage (data migration). field ️ A column or attribute of a record in a relational database. geographical information system (GIS) ️ A system designed to capture, store, manipulate, analyze, manage, and present all types of spatial or geographical data.