IS E2

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/253

encourage image

There's no tags or description

Looks like no tags are added yet.

254 Terms

1
New cards

What makes organizational data difficult to manage?

Rapid growth, scattered locations, multiple sources, data degradation, security, quality, and regulations.

2
New cards

What is data rot (data degradation)?

The deterioration of data quality or usefulness over time.

3
New cards

What are the three broad sources of organizational data?

Internal, personal, and external sources.

4
New cards

What is an example of an internal data source?

A company database or internal document.

5
New cards

What is an example of an external data source?

A commercial database, government report, or corporate website.

6
New cards

What is clickstream data?

Records of a user's clicks and navigation through websites.

7
New cards

What is data governance?

An organization-wide approach to managing data and ensuring its quality, security, and proper use.

8
New cards

What is master data management (MDM)?

A process for maintaining consistent, accurate core business data across an organization.

9
New cards

What is master data?

Core information about key business entities, such as customers, products, and employees.

10
New cards

What is transaction data?

Data generated by day-to-day business activities, such as purchases and payments.

11
New cards

What is data redundancy?

Unnecessary duplication of the same data.

12
New cards

What is data isolation?

Data stored in separate systems or files that are difficult to access together.

13
New cards

What is data inconsistency?

Different versions of the same data contain conflicting values.

14
New cards

What is data security?

Protecting data against unauthorized access, misuse, loss, or damage.

15
New cards

What is data integrity?

The accuracy, completeness, and reliability of data.

16
New cards

What is data independence?

The ability to change data storage structures without changing applications that use the data.

17
New cards

What three problems do database management systems minimize?

Data redundancy, data isolation, and data inconsistency.

18
New cards

What three things do database management systems maximize?

Data security, data integrity, and data independence.

19
New cards

What is a bit?

The smallest unit of data; a 0 or 1.

20
New cards

What is a byte?

A group of 8 bits, often representing a character.

21
New cards

What is a field?

A group of characters representing an attribute, such as a person's last name.

22
New cards

What is a record?

A group of related fields describing one entity or occurrence.

23
New cards

What is a data file or database table?

A collection of related records; in a relational table, records are rows.

24
New cards

What is a database?

An organized collection of related data.

25
New cards

What is the data hierarchy from smallest to largest?

Bit → byte → field → record → file/table → database.

26
New cards

What is a database management system (DBMS)?

Software used to create, store, retrieve, secure, and manage databases.

27
New cards

What is the most common traditional database model?

The relational database model.

28
New cards

How is data organized in a relational database?

In related tables made of rows (records) and columns (fields).

29
New cards

What is an entity in a database?

A person, place, thing, or event about which data is stored.

30
New cards

What is an instance of an entity?

One specific occurrence of an entity, such as one student.

31
New cards

What is an attribute?

A characteristic of an entity, such as student ID or name.

32
New cards

What is a primary key?

A field or combination of fields that uniquely identifies a record.

33
New cards

What is a foreign key?

A field that refers to the primary key in another table to link records.

34
New cards

What is a NoSQL database?

A nonrelational database designed to handle flexible or large-scale data structures.

35
New cards

What is a multidimensional database?

A database that organizes data by multiple dimensions for analysis.

36
New cards

What is Big Data?

High-volume, high-velocity, diverse data requiring advanced processing and analysis.

37
New cards

What are the three V's of Big Data?

Volume, velocity, and variety.

38
New cards

What does volume mean in Big Data?

The enormous amount of data generated and stored.

39
New cards

What does velocity mean in Big Data?

The speed at which data is generated, collected, and processed.

40
New cards

What does variety mean in Big Data?

The many data formats, including structured, semi-structured, and unstructured.

41
New cards

What is structured data?

Data organized in a predefined format such as rows and columns.

42
New cards

What is unstructured data?

Data without a fixed tabular format, such as video, images, and social media posts.

43
New cards

What are four major sources of Big Data described in the slides?

Enterprise data, machine/sensor data, social data, and images.

44
New cards

What are common problems with Big Data?

Untrusted sources, inaccurate or dirty data, and rapidly changing data streams.

45
New cards

What is Hadoop used for?

Storing and processing very large datasets across multiple computers.

46
New cards

What is MapReduce?

A method for processing large datasets by splitting and combining computing tasks.

47
New cards

What is hot data?

Data that must be accessed quickly and frequently.

48
New cards

What is cold data?

Relatively inactive data stored for infrequent access.

49
New cards

How can organizations use Big Data?

Find patterns, run experiments, segment customers, improve decisions, and build new business models.

50
New cards

What is customer microsegmentation?

Dividing customers into small, specific groups for targeted offerings.

51
New cards

Which functional areas can benefit from Big Data?

Human resources, product development, operations, marketing, and government operations.

52
New cards

Why do federal data regulations exist?

To protect privacy, improve accountability, and require responsible handling of information.

53
New cards

What is the Sarbanes-Oxley Act of 2002 (SOX)?

A U.S. law strengthening corporate financial reporting, internal controls, and accountability.

54
New cards

What is the Gramm-Leach-Bliley Act (GLBA)?

A U.S. law requiring covered financial institutions to explain information sharing and safeguard customer data.

55
New cards

What is a data warehouse?

A subject-organized repository of historical data used to support decisions.

56
New cards

What is a data mart?

A smaller, lower-cost data warehouse for a department or business unit.

57
New cards

What are key features of a data warehouse?

Integrated, subject-oriented, time-variant, nonvolatile, and multidimensional.

58
New cards

What does nonvolatile mean in a data warehouse?

Stored historical data is generally retained rather than frequently overwritten.

59
New cards

What is online analytical processing (OLAP)?

Technology used to analyze data from multiple perspectives for decision-making.

60
New cards

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.

61
New cards

What is knowledge management (KM)?

Creating, capturing, organizing, storing, and sharing an organization's knowledge.

62
New cards

What is intellectual capital?

The collective knowledge, expertise, skills, and ideas that create value for an organization.

63
New cards

What is explicit knowledge?

Knowledge that can be documented and easily shared, like manuals and procedures.

64
New cards

What is tacit knowledge?

Personal experience and know-how that is difficult to document or transfer.

65
New cards

What is a knowledge management system (KMS)?

Technology used to organize and share knowledge within and between organizations.

66
New cards

What are the six stages of the KMS cycle?

Create, capture, refine, store, manage, and disseminate knowledge.

67
New cards

What is SQL?

Structured Query Language; used to query and manage relational databases.

68
New cards

What is Query By Example (QBE)?

A visual method for constructing database queries without writing full SQL statements.

69
New cards

What is an entity-relationship (ER) diagram?

A diagram showing database entities and relationships among them.

70
New cards

What is a data dictionary?

A reference describing data fields, definitions, types, and rules.

71
New cards

What is cardinality in a database relationship?

The number of entity instances that can participate in a relationship.

72
New cards

What are the three common relationship types by connectivity?

One-to-one, one-to-many, and many-to-many.

73
New cards

What is a unary relationship?

A relationship involving one entity type.

74
New cards

What is a binary relationship?

A relationship between two entity types.

75
New cards

What is a ternary relationship?

A relationship among three entity types.

76
New cards

What is normalization?

Organizing database tables to reduce redundancy and improve data integrity.

77
New cards

What is first normal form (1NF)?

Each column contains atomic values and rows do not contain repeating groups.

78
New cards

What is second normal form (2NF)?

1NF plus every nonkey field depends on the entire primary key.

79
New cards

What is third normal form (3NF)?

2NF plus nonkey fields do not depend on other nonkey fields.

80
New cards

What is a database join?

Combining related records from multiple tables through matching fields.What is a computer network?

81
New cards

What is bandwidth?

The amount of data a communication channel can transmit in a given time.

82
New cards

What is broadband?

High-speed network access that supports substantial data transmission.

83
New cards

What is a personal area network (PAN)?

A short-range network connecting one person's nearby devices.

84
New cards

What is a local area network (LAN)?

A network serving a limited area, such as an office, building, or campus.

85
New cards

What is a wide area network (WAN)?

A network spanning large geographic areas and connecting multiple LANs.

86
New cards

What is the network-size order from smallest to largest?

PAN → LAN → MAN → WAN.

87
New cards

What is a router?

A device that directs data packets between networks.

88
New cards

What is a corporate backbone network?

A high-capacity central network linking smaller networks within an organization.

89
New cards

What is a software-defined network (SDN)?

A network where software centrally controls traffic and network behavior.

90
New cards

What does a modem do?

Modulates and demodulates signals so data can travel over a communication medium.

91
New cards

What is a digital signal?

Information represented using discrete values, typically 0s and 1s.

92
New cards

What is twisted-pair wire?

Pairs of insulated copper wires twisted together to transmit signals.

93
New cards

What are twisted-pair wire's main pros and cons?

Cheap and widely available, but lower bandwidth and more susceptible to interference.

94
New cards

What is coaxial cable?

A copper cable with insulation and shielding that carries electronic signals.

95
New cards

How does coaxial compare with twisted-pair?

Higher bandwidth and less interference, but more expensive and less flexible.

96
New cards

What is fiber-optic cable?

Glass or plastic fibers that transmit data using pulses of light.

97
New cards

What is fiber-optic cable's key advantage?

Very high bandwidth and harder to tap; splicing can be difficult.

98
New cards

What is a network protocol?

A set of rules governing how devices exchange data.

99
New cards

What are examples of network protocols?

Ethernet, TCP, IP, and HTTP.

100
New cards

What is Ethernet?

A widely used protocol for wired LAN communication.