MIS 301 Final Flashcards
raw facts and figures
data
data presented in a context so that it can answer a question or support decision making
information
insight derived from experience and expertise
knowledge
a single table or collection of related tables
database
sometimes referred to as database software; software for creating maintaining and manipulating data
database management systems (DBMS)
language used to create and manipulate databases
structured query language (SQL)
job title focused on directing, performing or overseeing activities associated with a database or a set of databases. these may include (but not necessarily be limited to ) data base design , creation, implementation, maintenance, backup, and recovery, policy setting and enforcement and security
database administrator (DBA)
a list of data arranged in columns (fields) and rows (records)
table or file
represent each category of data contained in a record, first name, last name
column or field
row or record
row or record
most common standard for expressing databases, whereby tables (files) are related based on common keys
relational databases
a type of cloud computing where a third party vendor manages servers, replications, fault tolerance, computing scalability, and certain aspects of security, freeing software developers to focus on building “business solutions” and eliminating the need to spend time and resources managing the technology complexity of much of the underlying “IT solution”
serverless computing
query tools
query tool
a general purpose programming language that is also popular for data analytics
python
allow a user to create a query through a point-and-click or drag-and-drop interface, rather than requiring programming knowledge
graphical query tools
reports that provide regular summaries of information in predetermined format
canned reports
tools that put users in control so that they can create custom reports on an as-needed basis by selecting fields, ranges, summary conditions and other parameters
ad hoc reporting tools
a heads up display of critical indicators that allow managers to get a graphical glance at key performance metrics
dashboards
graphical representation of data and information
data visualization
process of using computers to identify hidden patterns in and to build models from, large datasets
tasks:
association rules
classifications
regressions
cluster analysis
data mining
build model with so many variables that the solutions arrived at might only on the subset of data you’ve used to create it
over-engineer
the global mapping of users and organizations and how they are connected
social graph
also know as Metcalfe’s Law or network externalities. When value of a product or service increases as its numbers of users expands
network effects
the cost a consumer incurs when moving from one product to another. It can involve actual money spent as well as investments in time, any data loss and so forth
switching costs