WGU C175: data management
foundations
data - ANSWER-numeric, textual, visual or audio information that describes real-world systems scope of data -
... [Show More] ANSWER-the amount of data produced and collected format of data - ANSWER-data may be produced as numbers, text, image, audio, or video access of data - ANSWER-some data sources are private while others are made publicly available database - ANSWER-a collection of data in a structured format database system aka DBMS - ANSWER-is software that reads and writes data in a database. ensures data is secure, internally consistent, and available at all times query language - ANSWER-a specialized programming language designed specifically for database systems. reads and writes data efficiently, and differs significantly from general purpose languages such as python or java database application - ANSWER-software that helps business users interact with database systems database administrator - ANSWER-the person responsible for securing the database system against unauthorized users. enforces procedures for user and database system availability database designer - ANSWER-the person that determines the format of each data element and the overall database structure. must balance several priorities including storage, response time, and support for rules that govern the data. database programmer - ANSWER-the person that develops computer programs that utilize a database. they write applications that combine database query languages and general purpose programming languages. database user - ANSWER-a consumer of data in a database. request, update, or use stored data to generate reports or information. transaction - ANSWER-a group of queries that must be either completed or rejected as a whole. ensure transactions are processed completely or not at all prevent conflicts between concurrent transactions ensure transaction results are never lost - ANSWER-when processing transactions, database systems must: architecture of a database system (5) - ANSWER-describes the internal components and the relationships between components: query processor storage manager transaction manager log catalog query processor - ANSWER-interprets queries, creates a plan to modify the database or retrieve data, and returns query results to the application. storage manager - ANSWER-translates the query processor instructions into low-level file-system commands that modify or retrieve [Show Less]