BU415 Chapter Notes - Chapter 11: Database Administrator, Data Modeling, Customer Retention
Document Summary
Business intelligence (bi) a term combining aspects of reporting, data exploration and ad hoc queries, and sophisticated data modeling and analysis. Analytics a term describing the extensive use of data, statistical and quantitative analysis, explanatory and predictive models, and fact-based management to drive decisions and actions. Information data presented in a context so that it can answer a question or support decision making. Knowledge insight derived from experience and expertise. Database a single table or a collection of related tables. Database management systems (dbms) software for creating, maintaining and manipulating data. Structured query language (sql) a language used to create and manipulate databases. Database administrator (dba) job title focuses on directing, performing, or overseeing activities associated with a database or set of databases. Table or file a list of data, arranged in columns (fields) and rows (records) Relational database the most common standard for expressing databases, whereby tables (files) are related based on common keys.