1/253
Looks like no tags are added yet.
What makes organizational data difficult to manage?
Rapid growth, scattered locations, multiple sources, data degradation, security, quality, and regulations.
What is data rot (data degradation)?
The deterioration of data quality or usefulness over time.
What are the three broad sources of organizational data?
Internal, personal, and external sources.
What is an example of an internal data source?
A company database or internal document.
What is an example of an external data source?
A commercial database, government report, or corporate website.
What is clickstream data?
Records of a user's clicks and navigation through websites.
What is data governance?
An organization-wide approach to managing data and ensuring its quality, security, and proper use.
What is master data management (MDM)?
A process for maintaining consistent, accurate core business data across an organization.
What is master data?
Core information about key business entities, such as customers, products, and employees.
What is transaction data?
Data generated by day-to-day business activities, such as purchases and payments.
What is data redundancy?
Unnecessary duplication of the same data.
What is data isolation?
Data stored in separate systems or files that are difficult to access together.
What is data inconsistency?
Different versions of the same data contain conflicting values.
What is data security?
Protecting data against unauthorized access, misuse, loss, or damage.
What is data integrity?
The accuracy, completeness, and reliability of data.
What is data independence?
The ability to change data storage structures without changing applications that use the data.
What three problems do database management systems minimize?
Data redundancy, data isolation, and data inconsistency.
What three things do database management systems maximize?
Data security, data integrity, and data independence.
What is a bit?
The smallest unit of data; a 0 or 1.
What is a byte?
A group of 8 bits, often representing a character.
What is a field?
A group of characters representing an attribute, such as a person's last name.
What is a record?
A group of related fields describing one entity or occurrence.
What is a data file or database table?
A collection of related records; in a relational table, records are rows.
What is a database?
An organized collection of related data.
What is the data hierarchy from smallest to largest?
Bit ā byte ā field ā record ā file/table ā database.
What is a database management system (DBMS)?
Software used to create, store, retrieve, secure, and manage databases.
What is the most common traditional database model?
The relational database model.
How is data organized in a relational database?
In related tables made of rows (records) and columns (fields).
What is an entity in a database?
A person, place, thing, or event about which data is stored.
What is an instance of an entity?
One specific occurrence of an entity, such as one student.
What is an attribute?
A characteristic of an entity, such as student ID or name.
What is a primary key?
A field or combination of fields that uniquely identifies a record.
What is a foreign key?
A field that refers to the primary key in another table to link records.
What is a NoSQL database?
A nonrelational database designed to handle flexible or large-scale data structures.
What is a multidimensional database?
A database that organizes data by multiple dimensions for analysis.
What is Big Data?
High-volume, high-velocity, diverse data requiring advanced processing and analysis.
What are the three V's of Big Data?
Volume, velocity, and variety.
What does volume mean in Big Data?
The enormous amount of data generated and stored.
What does velocity mean in Big Data?
The speed at which data is generated, collected, and processed.
What does variety mean in Big Data?
The many data formats, including structured, semi-structured, and unstructured.
What is structured data?
Data organized in a predefined format such as rows and columns.
What is unstructured data?
Data without a fixed tabular format, such as video, images, and social media posts.
What are four major sources of Big Data described in the slides?
Enterprise data, machine/sensor data, social data, and images.
What are common problems with Big Data?
Untrusted sources, inaccurate or dirty data, and rapidly changing data streams.
What is Hadoop used for?
Storing and processing very large datasets across multiple computers.
What is MapReduce?
A method for processing large datasets by splitting and combining computing tasks.
What is hot data?
Data that must be accessed quickly and frequently.
What is cold data?
Relatively inactive data stored for infrequent access.
How can organizations use Big Data?
Find patterns, run experiments, segment customers, improve decisions, and build new business models.
What is customer microsegmentation?
Dividing customers into small, specific groups for targeted offerings.
Which functional areas can benefit from Big Data?
Human resources, product development, operations, marketing, and government operations.
Why do federal data regulations exist?
To protect privacy, improve accountability, and require responsible handling of information.
What is the Sarbanes-Oxley Act of 2002 (SOX)?
A U.S. law strengthening corporate financial reporting, internal controls, and accountability.
What is the Gramm-Leach-Bliley Act (GLBA)?
A U.S. law requiring covered financial institutions to explain information sharing and safeguard customer data.
What is a data warehouse?
A subject-organized repository of historical data used to support decisions.
What is a data mart?
A smaller, lower-cost data warehouse for a department or business unit.
What are key features of a data warehouse?
Integrated, subject-oriented, time-variant, nonvolatile, and multidimensional.
What does nonvolatile mean in a data warehouse?
Stored historical data is generally retained rather than frequently overwritten.
What is online analytical processing (OLAP)?
Technology used to analyze data from multiple perspectives for decision-making.
How does a data lake differ from a data warehouse?
A lake stores raw data in many formats; a warehouse stores organized, processed data for analysis.
What is knowledge management (KM)?
Creating, capturing, organizing, storing, and sharing an organization's knowledge.
What is intellectual capital?
The collective knowledge, expertise, skills, and ideas that create value for an organization.
What is explicit knowledge?
Knowledge that can be documented and easily shared, like manuals and procedures.
What is tacit knowledge?
Personal experience and know-how that is difficult to document or transfer.
What is a knowledge management system (KMS)?
Technology used to organize and share knowledge within and between organizations.
What are the six stages of the KMS cycle?
Create, capture, refine, store, manage, and disseminate knowledge.
What is SQL?
Structured Query Language; used to query and manage relational databases.
What is Query By Example (QBE)?
A visual method for constructing database queries without writing full SQL statements.
What is an entity-relationship (ER) diagram?
A diagram showing database entities and relationships among them.
What is a data dictionary?
A reference describing data fields, definitions, types, and rules.
What is cardinality in a database relationship?
The number of entity instances that can participate in a relationship.
What are the three common relationship types by connectivity?
One-to-one, one-to-many, and many-to-many.
What is a unary relationship?
A relationship involving one entity type.
What is a binary relationship?
A relationship between two entity types.
What is a ternary relationship?
A relationship among three entity types.
What is normalization?
Organizing database tables to reduce redundancy and improve data integrity.
What is first normal form (1NF)?
Each column contains atomic values and rows do not contain repeating groups.
What is second normal form (2NF)?
1NF plus every nonkey field depends on the entire primary key.
What is third normal form (3NF)?
2NF plus nonkey fields do not depend on other nonkey fields.
What is a database join?
Combining related records from multiple tables through matching fields.What is a computer network?
What is bandwidth?
The amount of data a communication channel can transmit in a given time.
What is broadband?
High-speed network access that supports substantial data transmission.
What is a personal area network (PAN)?
A short-range network connecting one person's nearby devices.
What is a local area network (LAN)?
A network serving a limited area, such as an office, building, or campus.
What is a wide area network (WAN)?
A network spanning large geographic areas and connecting multiple LANs.
What is the network-size order from smallest to largest?
PAN ā LAN ā MAN ā WAN.
What is a router?
A device that directs data packets between networks.
What is a corporate backbone network?
A high-capacity central network linking smaller networks within an organization.
What is a software-defined network (SDN)?
A network where software centrally controls traffic and network behavior.
What does a modem do?
Modulates and demodulates signals so data can travel over a communication medium.
What is a digital signal?
Information represented using discrete values, typically 0s and 1s.
What is twisted-pair wire?
Pairs of insulated copper wires twisted together to transmit signals.
What are twisted-pair wire's main pros and cons?
Cheap and widely available, but lower bandwidth and more susceptible to interference.
What is coaxial cable?
A copper cable with insulation and shielding that carries electronic signals.
How does coaxial compare with twisted-pair?
Higher bandwidth and less interference, but more expensive and less flexible.
What is fiber-optic cable?
Glass or plastic fibers that transmit data using pulses of light.
What is fiber-optic cable's key advantage?
Very high bandwidth and harder to tap; splicing can be difficult.
What is a network protocol?
A set of rules governing how devices exchange data.
What are examples of network protocols?
Ethernet, TCP, IP, and HTTP.
What is Ethernet?
A widely used protocol for wired LAN communication.