Data Management Foundations - WGU C175
analytical database - answer-A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability - answer-In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database - answer-A database located at a single site cloud database - answer-A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS data - answer-Raw facts, or facts that have not yet been processed to reveal their meaning to the end user data anomaly - answer-An abnormality of the data in which inconsistent changes have been made to a database (For example, an employee moves, but the address changes is not corrected in all files in the database) data dependence - answer-A data condition in which data representation and manipulation are dependent on the physical data storage characteristics data dictionary - answer-A DBMS component that stores metadata. Contains the data definition, as well as their characteristics and relationships data inconsistency - answer-A condition in which different versions of the same data yield different results data independence - answer-A condition in which data access is unaffected by changes in the physical data storage characteristics data integrity - answer-In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints data management - answer-A process that focuses on data collection, storage, and retrieval. data processing (DP) specialist - answer-The person responsible for developing and managing a computerized file processing system data redundancy - answer-Exists when the same data is stored unnecessarily at different places database - answer-A shared, integrated computer structure that houses a collection of related data including end-user data (raw facts) and metadata (data about the data) database design - answer-The process that yields the description of the database structure and determines the database components. The second phase of the database life cycle database management system (DBMS) - answer-The collection of programs that manages the database structure and controls access to the data stored in the database database system - answer-An organization of components that defines and regulates the collection, storage, management, and use of data in a database environment desktop database - answer-A single-user database that runs on a personal computer discipline-specific database - answer-A database that contains data focused on specific subject areas enterprise database - answer-The overall company data representation, which provides support for present and expected future needs field - answer-An alphabetic or numeric character or group of characters that defines a characteristic of a person, place, or thing. (for example, a person's SSN, address, phone number, and bank balance all constitute fields) file - answer-A named collection of related records general-purpose database - answer-A database that contains a wide variety of data used in multiple disciplines hub - answer-A warehouse of data packets housed in a central location on a local area network. It contains multiple ports that copy the data in the data packets to make it accessible to selected or all segments of the network information - answer-The result of processing raw data to reveal its meaning. It consists of transformed data and facilitates decision making islands of information - answer-In the old file system environment, pools of independent, often duplicated, and inconsistent data created and managed by different departments knowledge - answer-The body of information and facts about a specific subject. It implies familiarity, awareness, and understanding of information as it applies to an environment logical data format - answer-The way a person views data within the context of a problem domain metadata - answer-Data about data multiuser database - answer-A database that supports multiple concurrent users NoSQL - answer-A new generation of database management systems that is not based on the traditional relational database model. It stores structured and unstructured data in efficient ways. online analytical processing (OLAP) - answer-Decision support system (DSS) tools that use multidimensional data analysis techniques. It creates an advanced data analysis environment that supports decision making, business modeling, and operations research operational database - answer-A database designed primarily to support a company's day-to-day operations. (Also known as a transactional database, OLTP database, or production database) performance tuning - answer-Activities that make a database perform more efficiently in terms of storage and access speed physical data format - answer-The way a computer "sees" (stores) data query - answer-A question or task asked by an end user of a database in the form of SQL code. A specific request for data manipulation issued by the end user or the application to the DBMS query language - answer-A nonprocedural language that is used by a DBMS to manipulate its data (such as SQL) query result set - answer-The collection of data rows returned by a query record - answer-A collection of related (logically connected) fields role - answer-In Oracle, a named collection of database access privileges that authorize a user to connect to a database and use its system resources router - answer-1) An intelligent devise used to connect dissimilar networks 2) Hardware/software equipment that connects multiple and diverse networks semistructured data - answer-Data that has already been processed to some extent
Información del documento
- Subido en
- 4 de mayo de 2024
- Número de páginas
- 19
- Escrito en
- 2023/2024
- Tipo
- Otro
- Personaje
- Desconocido