CHAPTER
Data and Knowledge
Management
3
1. Managing Data
2. The Database Approach
3. Big Data
4. Data Warehouses and Data Marts
5. Knowledge Management
1. Discuss ways that common challenges in managing
data can be addressed using data governance.
2. Discuss the advantages and disadvantages of
relational databases.
3. Define Big Data, and discuss its basic characteristics.
4. Explain the elements necessary to successfully
implement and maintain data warehouses.
5. Describe the benefits and challenges of implementing
knowledge management systems in organizations.
3.1 Managing Data
• Difficulties of Managing Data
• Data Governance
The Difficulties of Managing
Data
•The amount of data increases
exponentially over time
•Data are scattered throughout
organizations
•Data are generated from multiple
sources (internal, personal, external)
–Clickstream Data
•New sources of data
The Difficulties of Managing
Data (continued)
•Data Degradation
•Data Rot
•Data security, quality, and integrity
are critical
•Legal requirements change
frequently and differ among
countries & industries
Data Governance
• Master Data Management
• Master Data
3.2 The Database
Approach
• Data File
• Database Systems Minimize &
Maximize Three Things
• The Data Hierarchy
• The Relational Database Model
Figure 3.1: Database
Management System
Database Management
Systems (DBMS) Minimize:
• Data Redundancy
• Data Isolation
• Data Inconsistency
Database Management
Systems (DBMS) Maximize:
• Data Security
• Data Integrity
• Data Independence
Data Hierarchy
• Bit
• Byte
• Field
• Record
• Data File (Table)
• Database
Figure 3.2: Hierarchy of Data
for a Computer-based File
The Relational Database
Model
• Database Management System
(DBMS)
• Relational Database Model
• Data Model
• Entity
• Instance
• Attribute
The Relational Database
Model (continued)
• Primary Key
• Secondary Key
• Foreign Key
• Unstructured Data
Figure 3.3: Student
Database Example
3.3 Big Data
• Defining Big Data
• Characteristics of Big Data
• Issues with Big Data
• Managing Big Data
• Putting Big Data to Use
• Big Data Used in the Functional
Areas of the Organization
Defining Big Data
• Gartner (www.gartner.com)
• Big Data Institute
Defining Big Data: Gartner
• Diverse, high volume, high-velocity
information assets that require new
forms of processing to enable
enhanced decision making, insight
discovery, and process optimization.
Defining Big Data: The Big
Data Institute (TBDI)
• Vast Datasets that:
– Exhibit variety
– Include structured, unstructured, and semistructured data
– Generated at high velocity with an uncertain
pattern
– Do not fit neatly into traditional, structured,
relational databases
– Can be captured, processed, transformed,
and analyzed in a reasonable amount of time
only by sophisticated information systems.
Big Data Generally Consist
of the Following:
• Traditional Enterprise Data
• Machine-Generated/Sensor Data
• Social Data
• Images Captured by Billions of
Devices Located Throughout the
World
Characteristics of Big Data
• Volume
• Velocity
• Variety
Issues with Big Data
• Untrusted data sources
• Big Data is dirty
• Big Data changes, especially in data
streams
Managing Big Data
• Big Data makes it possible to do
many things that were previously
impossible:
– Spot business trends more rapidly and
accurately
– tracking the spread of disease
– tracking crime
– detecting fraud
Managing Big Data
(continued)
• First Step:
– Integrate information silos into a
database environment and develop
data warehouses for decision making.
• Second Step:
– making sense of their proliferating
data.
Managing Big Data
(continued)
• Many organizations are turning to
NoSQL databases to process Big
Data
Putting Big Data to Use
• Making Big Data Available
• Enabling Organizations to Conduct
Experiments
• Micro-Segmentation of Customers
• Creating New Business Models
• Organizations Can Analyze Far More
Data
Big Data Used in the
Functional Areas of the
Organization
• Human Resources
• Product Development
• Operations
• Marketing
• Government Operations
3.4 Data Warehouses and
Data Marts
• Describing Data Warehouses and
Data Marts
• A Generic Data Warehouse
Environment
Describing Data
Warehouses and Data Marts
• Organized by business dimension or
Use online analytical processing
(OLAP)
• Integrated
• Time variant
• Nonvolatile
• Multidimensional
A Generic Data Warehouse
Environment
• Source Systems
• Data Integration
• Storing the Data
• Metadata
• Data Quality
• Governance
• Users
Figure 3.4: Data Warehouse
Framework
Figure 3.5: Relational
Databases
Figure 3.6: Data Cube
Figure 3.7: Equivalence Between
Relational and Multidimensional
Databases
3.5 Knowledge
Management
• Concepts and Definitions
• Knowledge Management Systems
• The KMS Cycle
Concepts and Definitions
• Knowledge Management
• Knowledge
• Explicit and Tacit Knowledge
• Knowledge Management Systems
• The KMS Cycle
Figure 3.8: The Knowledge
Management System Cycle
Saudi Electronic University
College of Administrative and Financial Sciences
E-commerce Department
Student Name:
Student ID:
Course Title: Management Information Course Code: MIS201
System
Academic Year/ Semester:
CRN:
Instructor Name:
Student Grade:
Grade Level:
Low/ Middle / High
Saudi Electronic University
College of Administrative and Financial Sciences
Assignment of MIS201- Management Information System
MIS201 – Project
First Semester 2021-2022
Submission
Part 1
Part 2
Part 3
Submission: End of week 5 Saturday 01/10/2022
Submission: End of week 11 Saturday 12/11/2022
Instructors will manage the date and time for presentation during week 12
40 Marks
Assignment Details
The project involves studying the IT infrastructure of a relevant information system (IS)/
information technology (IT) used by selecting any organization of your choice locally or
internationally
The idea is to investigate the selected organization using the main components of IT
(Hardware, software, services, data management and networking). Infrastructure
Investigation, which is in a selected industry, should be carried out by using articles,
websites, books and journal papers and /or interviews. In the report, you are expected to
discuss:
Project Report Structure: Part 1
Submission: End of week 5 Saturday 01/10/2022
Marks: 17 Marks
1. Cover Page (1 Mark).
This must contain topic title (0.25), student names and Students ID (0.5), section number and course
name (0.25).
(You can find the cover page in the blackboard)
2. Table of Contents (0.5 Mark).
Make sure the table of contents contains and corresponds to the headings in the text, figures, and
tables.
3. Executive Summary (2.5 Marks).
What does the assignment about (1), The name and field of the chosen company (0.5), and briefly
explain the distinct features (1).
4. Organizational Profile (3 Marks).
Brief background of the business including organization details (1), purpose (1), and organizational
structure (1).
5. Strategies (4 Marks).
Discuss different types of strategies for competitive advantages (2), and then select and discuss the
most appropriate strategies to improve the performance of the organization (2).
(You can discuss any points that you learned in this course and its related to your selected organization)
6. Technology Involved (3 Marks).
How is the organization set up in terms of its IT infrastructure? Discuss the hardware (0.5), software
(0.5), telecommunication (0.5), information security (0.5), networks (0.5), and other elements (0,5).
(You can discuss any points that you learned in this course, and it’s related to your selected
organization)
7. Data Management (2 Marks).
Discuss the methods the organization uses to manage and process data (1), and then give one
advantage and one disadvantage of these methods (1).
(You can discuss any points that you learned in this course (chapter 3) and link it to your selected
organization)
8. Identify the Stakeholders (1 Mark)
Who are the main individuals, groups, or departments affected by the information system?
(You can choose any stakeholder who has a major influence on the IS or vice versa. You can choose 1
stakeholder to discuss)
Project Report Structure: Part 2
Submission: End of week 11 Saturday 12/11/2022
Marks: 13 Marks
9. Analysis of Existing System (5 Marks).
Analyze the key problems of the existing system used by the company (2). Also, discuss the
Information Systems used within the company (3) for example:
•
•
•
•
•
Transaction processing systems (TPS)
Enterprise Resource Planning (ERP) Systems
Functional Area Information Systems
Business intelligence
DSS
(You can discuss any points that you learned in this course and it’s related to your selected organization)
10. System Evaluation (2 Marks).
Evaluate the current system that the company use (your chosen company) with one of the following
options (1):
•
•
•
Success
Partial failure/partial success
Total failure
Then, State the reasons for your choice (1)
11. Suggestions for the company (3 Marks)
Design or choose a system to help the company solve its main problems. State the following:
•
•
•
The new system name (1)
Its features (1)
Problems that will be solved (1)
(If the system that the company uses is successful and does not need to be changed, you can
mention that (1), mention its features (1), and mention the problems that it solved or prevented
from happening (1).)
(You can discuss any points that you learned in this course and it’s related to your selected organization)
12. Conclusion (2 Marks).
Summarize your report (including part 1)
13. References (1 Mark).
Use APA referencing style format
Project Presentation: Part 3
Submission: Instructors will manage the date and time for presentation during week 12
Marks: 10 Marks
Make a power-point presentation of your Project work mentioning all the above contents and
present in a group (All team members must participate( (1). There must be minimum 10 slides
in the presentation with a good background design (0.5), readable font size and style with an
appropriate color (0.5).
Presentation must have the following format:
•
First slide: Group members name and Student id & Title of the Project (1)
•
Company Profile (1)
•
Strategies (1)
•
Technology Involved and Data Management (1)
•
Analysis of Existing System (1)
•
Evaluation and suggestions (1)
•
Conclusion (1)
•
References (1)
Guidelines for the assignment:
✓ Make sure to include the cover page with all information required. One mark will be deducted if
there is no cover page
✓ This is a group project (2-3 students), which is part of your course score. It requires effort, research,
and critical thinking.
✓ Use font Times New Roman, 12 font sizes
✓ Use 1.5 line spacing with adjust to all paragraphs (alignment).
✓ Use the footer function to insert page number.
✓ Ensure that you follow the APA style in your project and references.
✓ The minimum number of required references is 3 for each part (1 and 2).
✓ Your project report length Part 1 should be between 1500 to 2200 words & Part 2 should be
between 1000 to 2000 words.
✓ You must check the spelling and grammar mistakes before submitting the assignment.
✓ Up to 20% of the total grade will be deducted for providing a poor structure of assignment
(Structure includes these elements paper style, free of spelling and grammar mistakes, referencing
and word count).
✓ Assignment must be in Word format only NO PDF
✓ Your file should be saved as Word doc [Example]: [Your Name] [CRN] MIS201 – Project Assignment
Part 1.doc
Useful links:
✓ http://www.nottingham.ac.uk/studentservices/documents/planning-and-preparing-to-writeassignments.pdf
✓ APA reference system https://student.unsw.edu.au/apa
✓ About plagiarism http://wts.indiana.edu/pamphlets/plagiarism.shtml
✓ About plagiarism https://en.wikipedia.org/wiki/Plagiarism
Purchase answer to see full
attachment
Data and Knowledge
Management
3
1. Managing Data
2. The Database Approach
3. Big Data
4. Data Warehouses and Data Marts
5. Knowledge Management
1. Discuss ways that common challenges in managing
data can be addressed using data governance.
2. Discuss the advantages and disadvantages of
relational databases.
3. Define Big Data, and discuss its basic characteristics.
4. Explain the elements necessary to successfully
implement and maintain data warehouses.
5. Describe the benefits and challenges of implementing
knowledge management systems in organizations.
3.1 Managing Data
• Difficulties of Managing Data
• Data Governance
The Difficulties of Managing
Data
•The amount of data increases
exponentially over time
•Data are scattered throughout
organizations
•Data are generated from multiple
sources (internal, personal, external)
–Clickstream Data
•New sources of data
The Difficulties of Managing
Data (continued)
•Data Degradation
•Data Rot
•Data security, quality, and integrity
are critical
•Legal requirements change
frequently and differ among
countries & industries
Data Governance
• Master Data Management
• Master Data
3.2 The Database
Approach
• Data File
• Database Systems Minimize &
Maximize Three Things
• The Data Hierarchy
• The Relational Database Model
Figure 3.1: Database
Management System
Database Management
Systems (DBMS) Minimize:
• Data Redundancy
• Data Isolation
• Data Inconsistency
Database Management
Systems (DBMS) Maximize:
• Data Security
• Data Integrity
• Data Independence
Data Hierarchy
• Bit
• Byte
• Field
• Record
• Data File (Table)
• Database
Figure 3.2: Hierarchy of Data
for a Computer-based File
The Relational Database
Model
• Database Management System
(DBMS)
• Relational Database Model
• Data Model
• Entity
• Instance
• Attribute
The Relational Database
Model (continued)
• Primary Key
• Secondary Key
• Foreign Key
• Unstructured Data
Figure 3.3: Student
Database Example
3.3 Big Data
• Defining Big Data
• Characteristics of Big Data
• Issues with Big Data
• Managing Big Data
• Putting Big Data to Use
• Big Data Used in the Functional
Areas of the Organization
Defining Big Data
• Gartner (www.gartner.com)
• Big Data Institute
Defining Big Data: Gartner
• Diverse, high volume, high-velocity
information assets that require new
forms of processing to enable
enhanced decision making, insight
discovery, and process optimization.
Defining Big Data: The Big
Data Institute (TBDI)
• Vast Datasets that:
– Exhibit variety
– Include structured, unstructured, and semistructured data
– Generated at high velocity with an uncertain
pattern
– Do not fit neatly into traditional, structured,
relational databases
– Can be captured, processed, transformed,
and analyzed in a reasonable amount of time
only by sophisticated information systems.
Big Data Generally Consist
of the Following:
• Traditional Enterprise Data
• Machine-Generated/Sensor Data
• Social Data
• Images Captured by Billions of
Devices Located Throughout the
World
Characteristics of Big Data
• Volume
• Velocity
• Variety
Issues with Big Data
• Untrusted data sources
• Big Data is dirty
• Big Data changes, especially in data
streams
Managing Big Data
• Big Data makes it possible to do
many things that were previously
impossible:
– Spot business trends more rapidly and
accurately
– tracking the spread of disease
– tracking crime
– detecting fraud
Managing Big Data
(continued)
• First Step:
– Integrate information silos into a
database environment and develop
data warehouses for decision making.
• Second Step:
– making sense of their proliferating
data.
Managing Big Data
(continued)
• Many organizations are turning to
NoSQL databases to process Big
Data
Putting Big Data to Use
• Making Big Data Available
• Enabling Organizations to Conduct
Experiments
• Micro-Segmentation of Customers
• Creating New Business Models
• Organizations Can Analyze Far More
Data
Big Data Used in the
Functional Areas of the
Organization
• Human Resources
• Product Development
• Operations
• Marketing
• Government Operations
3.4 Data Warehouses and
Data Marts
• Describing Data Warehouses and
Data Marts
• A Generic Data Warehouse
Environment
Describing Data
Warehouses and Data Marts
• Organized by business dimension or
Use online analytical processing
(OLAP)
• Integrated
• Time variant
• Nonvolatile
• Multidimensional
A Generic Data Warehouse
Environment
• Source Systems
• Data Integration
• Storing the Data
• Metadata
• Data Quality
• Governance
• Users
Figure 3.4: Data Warehouse
Framework
Figure 3.5: Relational
Databases
Figure 3.6: Data Cube
Figure 3.7: Equivalence Between
Relational and Multidimensional
Databases
3.5 Knowledge
Management
• Concepts and Definitions
• Knowledge Management Systems
• The KMS Cycle
Concepts and Definitions
• Knowledge Management
• Knowledge
• Explicit and Tacit Knowledge
• Knowledge Management Systems
• The KMS Cycle
Figure 3.8: The Knowledge
Management System Cycle
Saudi Electronic University
College of Administrative and Financial Sciences
E-commerce Department
Student Name:
Student ID:
Course Title: Management Information Course Code: MIS201
System
Academic Year/ Semester:
CRN:
Instructor Name:
Student Grade:
Grade Level:
Low/ Middle / High
Saudi Electronic University
College of Administrative and Financial Sciences
Assignment of MIS201- Management Information System
MIS201 – Project
First Semester 2021-2022
Submission
Part 1
Part 2
Part 3
Submission: End of week 5 Saturday 01/10/2022
Submission: End of week 11 Saturday 12/11/2022
Instructors will manage the date and time for presentation during week 12
40 Marks
Assignment Details
The project involves studying the IT infrastructure of a relevant information system (IS)/
information technology (IT) used by selecting any organization of your choice locally or
internationally
The idea is to investigate the selected organization using the main components of IT
(Hardware, software, services, data management and networking). Infrastructure
Investigation, which is in a selected industry, should be carried out by using articles,
websites, books and journal papers and /or interviews. In the report, you are expected to
discuss:
Project Report Structure: Part 1
Submission: End of week 5 Saturday 01/10/2022
Marks: 17 Marks
1. Cover Page (1 Mark).
This must contain topic title (0.25), student names and Students ID (0.5), section number and course
name (0.25).
(You can find the cover page in the blackboard)
2. Table of Contents (0.5 Mark).
Make sure the table of contents contains and corresponds to the headings in the text, figures, and
tables.
3. Executive Summary (2.5 Marks).
What does the assignment about (1), The name and field of the chosen company (0.5), and briefly
explain the distinct features (1).
4. Organizational Profile (3 Marks).
Brief background of the business including organization details (1), purpose (1), and organizational
structure (1).
5. Strategies (4 Marks).
Discuss different types of strategies for competitive advantages (2), and then select and discuss the
most appropriate strategies to improve the performance of the organization (2).
(You can discuss any points that you learned in this course and its related to your selected organization)
6. Technology Involved (3 Marks).
How is the organization set up in terms of its IT infrastructure? Discuss the hardware (0.5), software
(0.5), telecommunication (0.5), information security (0.5), networks (0.5), and other elements (0,5).
(You can discuss any points that you learned in this course, and it’s related to your selected
organization)
7. Data Management (2 Marks).
Discuss the methods the organization uses to manage and process data (1), and then give one
advantage and one disadvantage of these methods (1).
(You can discuss any points that you learned in this course (chapter 3) and link it to your selected
organization)
8. Identify the Stakeholders (1 Mark)
Who are the main individuals, groups, or departments affected by the information system?
(You can choose any stakeholder who has a major influence on the IS or vice versa. You can choose 1
stakeholder to discuss)
Project Report Structure: Part 2
Submission: End of week 11 Saturday 12/11/2022
Marks: 13 Marks
9. Analysis of Existing System (5 Marks).
Analyze the key problems of the existing system used by the company (2). Also, discuss the
Information Systems used within the company (3) for example:
•
•
•
•
•
Transaction processing systems (TPS)
Enterprise Resource Planning (ERP) Systems
Functional Area Information Systems
Business intelligence
DSS
(You can discuss any points that you learned in this course and it’s related to your selected organization)
10. System Evaluation (2 Marks).
Evaluate the current system that the company use (your chosen company) with one of the following
options (1):
•
•
•
Success
Partial failure/partial success
Total failure
Then, State the reasons for your choice (1)
11. Suggestions for the company (3 Marks)
Design or choose a system to help the company solve its main problems. State the following:
•
•
•
The new system name (1)
Its features (1)
Problems that will be solved (1)
(If the system that the company uses is successful and does not need to be changed, you can
mention that (1), mention its features (1), and mention the problems that it solved or prevented
from happening (1).)
(You can discuss any points that you learned in this course and it’s related to your selected organization)
12. Conclusion (2 Marks).
Summarize your report (including part 1)
13. References (1 Mark).
Use APA referencing style format
Project Presentation: Part 3
Submission: Instructors will manage the date and time for presentation during week 12
Marks: 10 Marks
Make a power-point presentation of your Project work mentioning all the above contents and
present in a group (All team members must participate( (1). There must be minimum 10 slides
in the presentation with a good background design (0.5), readable font size and style with an
appropriate color (0.5).
Presentation must have the following format:
•
First slide: Group members name and Student id & Title of the Project (1)
•
Company Profile (1)
•
Strategies (1)
•
Technology Involved and Data Management (1)
•
Analysis of Existing System (1)
•
Evaluation and suggestions (1)
•
Conclusion (1)
•
References (1)
Guidelines for the assignment:
✓ Make sure to include the cover page with all information required. One mark will be deducted if
there is no cover page
✓ This is a group project (2-3 students), which is part of your course score. It requires effort, research,
and critical thinking.
✓ Use font Times New Roman, 12 font sizes
✓ Use 1.5 line spacing with adjust to all paragraphs (alignment).
✓ Use the footer function to insert page number.
✓ Ensure that you follow the APA style in your project and references.
✓ The minimum number of required references is 3 for each part (1 and 2).
✓ Your project report length Part 1 should be between 1500 to 2200 words & Part 2 should be
between 1000 to 2000 words.
✓ You must check the spelling and grammar mistakes before submitting the assignment.
✓ Up to 20% of the total grade will be deducted for providing a poor structure of assignment
(Structure includes these elements paper style, free of spelling and grammar mistakes, referencing
and word count).
✓ Assignment must be in Word format only NO PDF
✓ Your file should be saved as Word doc [Example]: [Your Name] [CRN] MIS201 – Project Assignment
Part 1.doc
Useful links:
✓ http://www.nottingham.ac.uk/studentservices/documents/planning-and-preparing-to-writeassignments.pdf
✓ APA reference system https://student.unsw.edu.au/apa
✓ About plagiarism http://wts.indiana.edu/pamphlets/plagiarism.shtml
✓ About plagiarism https://en.wikipedia.org/wiki/Plagiarism
Purchase answer to see full
attachment
