.png){kind=logo}
Data Management - Foundations - D426 WGU Leave the first rating Students also studied Terms in this set (156) Western Governors UniversityD 426 Save D426 Study Guide (Red Text ONLY) 225 terms brattynnPreview
WGU - D426: Objective Assessment...
151 terms natesoundslike Preview
WGU D426 V2
160 terms MoDhochesPreview
D426 -
139 term Sam Practice questions for this set Learn1 / 7Study using Learn Grant all permissions to user 'tester'.Datanumeric , textual , visual or audio information that describes real-world systems.varies in ways such as scope, format, access.analog dataHistorically most common before computers, encoded as continuous variations on various physical media.digital datamost common today, recorded as 0's and 1's on electronic and magnetic media.Choose an answer
1TCL2DQL
3DDL4DCL
Don't know?
database designerdetermines the format of each data element and the overall database structure database usera consumer of data in a database. can either use an application or submit queries directly to the database. they use, request and update data. to generate reports transactiona group of queries that must be completed or rejected as whole. will result in incomplete or incorrect data if not terminated as a whole.Query processorinterprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application.Query optimizationto ensure the most efficient instructions are executed on the data from the processor.Storage Managertranslates the query processor instructions into low-level file-system commands that modify or retrieve data.indexesused by the storage manager to quickly locate data catalogalso called a data dictionary , a directory of tables, columns and indexes as well as other database objects.relational databasea database that stores data in tables that consist of rows and columns, similar to a spreadsheet SQLStructured Query Language NoSQLA new generation of database management systems that is not based on the traditional relational database model.querycommand for a database that typically inserts, retrieves, updates and deletes data from the database.crudCreate, Read, Update, Delete statementa database command such as a query that inserts , selects updates and deletes data SELECTRetrieves data from a table UPDATEmodifies data in a table data typeindicates the type of data that can be stored in a field of a column data independenceA condition in which data access is unaffected by changes in the physical data storage characteristics.
database modelDescribes the relationship between the data elements and provides a framework for organizing the data. contains 3 parts data structures operations rules relational modelA database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files.rowan unnamed tuple of values , each value corresponds to a column and belongs to the columns data type.relational rulespart of the relational model and govern data in every relational database data lakeAn analytic database of raw, unprocessed data copied from multiple data sources.in-memory databaseA database management system that stores the entire database in random access memory (RAM).replicaa cop of an entire database data warehousea separate database optimized for analytics instead of operations analytic dataHistorical data used to make decisions in the present operational datadata used for managing business processes, such as for processing transactions or for data analysis distributed transactionA database transaction that accesses data in several remote data processors in a distributed database.Local Transactionsupdates data on a single node of a distributed database CREATE TABLEA SQL command that creates a table's structures using the characteristics and attributes given.CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); Data Transaction Language (DTL)manages database transactions Data Control Language (DCL)Commands that control a database, including administering privileges and committing data
Data Manipulation Language (DML)A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports.data query language (DQL)Enables users to retrieve, sort, and display specific data from the database Data Definition Language (DDL)The language that allows a database administrator to define the database structure, schema, and subschema.entityAn object or event that we want to keep track of attributeA property or characteristic of an entity or relationship type that is of interest to the organization.binary relationshipA relationship between the instances of two entity types.primary keya column or group of columns that identifies a unique row in a table Simple Primary Keyconsists of a single column composite primary keyconsists of multiple columns PRIMARY KEY (example_table_1,example_table_2)); Metadatais data about the database, such as column names and the number of rows in each table. Database systems store metadata in the catalog and use metadata to process queries.
.png)