Data Management - Foundations - D426 WGU

Data Management - Foundations - gi gi gi gi


D426 WGU gi gi


1.Data: numeric , textual , visual or audio information that describes
gi gi gi gi gi gi gi gi gi gi gi

real-world systems. gi

varies in ways such as scope, format, access.
gi gi gi gi gi gi gi

2.analog data: Historically most common before computers, encoded as
gi gi gi gi gi gi gi gi

continu- ous variations on various physical media.
gi gi gi gi gi gi gi


3.digital data: most common today, recorded as 0's and 1's on electr
gi gi gi gi gi gi gi gi gi gi gi

onic and magnetic media.
gi gi gi


4.database designer: determines the format of each data element and th
gi gi gi gi gi gi gi gi gi gi

e overall database structure
gi gi gi


5.database user: a consumer of data in a database. can either use an ap
gi gi gi gi gi gi gi gi gi gi gi gi gi

plication or submit queries directly to the database. they use, request a
gi gi gi gi gi gi gi gi gi gi gi

nd update data. to generate reports
gi gi gi gi gi


6.transaction: a group of queries that must be completed or rejected as gi gi gi gi gi gi gi gi gi gi gi gi

whole. will result in incomplete or incorrect data if not terminated as a
gi gi gi gi gi gi gi gi gi gi gi gi gi

whole.
7.Query processor: interprets queries, creates a plan to modify the dat
gi gi gi gi gi gi gi gi gi gi

abase or retrieve data, and returns query results to the application.
gi gi gi gi gi gi gi gi gi gi


8.Query optimization: to ensure the most efficient instructions are execut
gi gi gi gi gi gi gi gi gi

ed on the data from the processor.
gi gi gi gi gi gi


9.Storage Manager: translates the query processor instructions into l
gi gi gi gi gi gi gi gi

ow-level file-system commands that modify or retrieve data.
gi gi gi gi gi gi gi

10.indexes: used by the storage manager to quickly locate data gi gi gi gi gi gi gi gi gi

11. catalog: also called a data dictionary , a directory of tables, colum gi gi gi gi gi gi gi gi gi gi gi

ns and indexes as well as other database objects.
gi gi gi gi gi gi gi gi


12.relational database: a database that stores data in tables that consist
gi gi gi gi gi gi gi gi gi gi

of rows and columns, similar to a spreadsheet
gi gi gi gi gi gi gi gi

13.SQL: Structured Query Language gi gi gi

14.NoSQL: A new generation of database management systems that is
gi gi gi gi gi gi gi gi gi gi

not based on the traditional relational database model.
gi gi gi gi gi gi gi


15.query: command for a database that typically inserts, retrieves, up
gi gi gi gi gi gi gi gi gi

dates and deletes data from the database.
gi gi gi gi gi gi

16.crud: Create, Read, Update, Delete gi gi gi gi

17.statement: a database command such as a query that inserts , selects gi gi gi gi gi gi gi gi gi gi gi

updates and deletes data
gi gi gi gi

18.SELECT: Retrieves data from a table gi gi gi gi gi

19.UPDATE: modifies data in a table gi gi gi gi gi

20.data type: indicates the type of data that can be stored in a field of a
gi gi gi gi gi gi gi gi gi gi gi gi gi gi gi

olumn
21.data independence: A condition in which data access is unaffected by
gi gi gi gi gi gi gi gi gi gi gi


1gi/
gi14

, Data Management - Foundations -
gi gi gi gi


D426 WGU
gi gi

changes in the physical data storage characteristics.
gi gi gi gi gi gi




2gi/
gi14