Chapter 6

8 Pages
89 Views

Department
Information Technology Management
Course Code
ITM 102
Professor
Ross Mc Naughton

This preview shows pages 1-3. Sign up to view the full 8 pages of the document.
CHAPTER 6: DATABASE MANAGEMENT AND BUSINESS INTELLIGENCE
-Organizational Plumbing: the IT systems designed to support different kinds of
knowledge work- gathering and storing data, processing information, and making
decisions
-The Data-Information-Knowledge Continuum:
Data: raw unorganized facts, numbers, pictures, and so on
Information: data that have been organized and are useful to a person
Knowledge: a person combines experience and judgement with information
(create value to organizations)
Wisdom: adds insights and ethics to the experience and professional judgement
inherent in knowledge (enables leaders to perceive the underlying meaning and
nuances of a business situation and ensures that knowledge from relevant
perspectives, disciplines, and sources is considered in the final decision)
-Lifelong Knowledge Creation
Explicit knowledge: knowledge that is readily codified, such as the knowledge in
this textbook
Tacit Knowledge: knowledge gain through experience, insight, and discovery
-Knowledge Work Activities
Knowledge Work: involves the discovery, analysis, transformation, synthesis,
and communication of data, information, and knowledge
Work Flows: the steps you went through
Work Product: the outcome
-Discovery: Finding Data, Information, or Knowledge (page 208)
Discovery: Finding of data, information, and knowledge relevant to a task,
problem, issue, or opportunity (the context)
Managers Request: find our companys and our competitors weekly sales data
www.notesolution.com
Helpful IT tools ad Activities: use data from check-out/ point-of-sale (POS)
terminals, search tools (ex: Google) and web searching
-Analysis: Investigating and examining the available data, information and knowledge
Breaking down the whole into its more discrete pats to better understand how
it works
Process napping: if you are analyzing a business process
Quality assurance: if you are analyzing product quality
Performance Testing: if you are assessing fitness or standards
Data warehouses and data mining are two information technologies that can
help answer questions about underlying patterns and correlations across large
amounts of data
Managers Request: Compare the sales data for the first week of May to similar
data from our company for the previous two months
Helpful IT Tools and Activities: Import the data into a database or spreadsheet
application, and use its features and tools to organize the data
-Transformation: Organizing Discovery Results
Transformations: knowledge work that requires you to use the results of your
analysis to deepen your understanding of the data and information
Managers Request: Identify any trends in the data by week, month, and day of
the week. Indicate how our companys results compare with our competition
and with the industry as a whole
Help IT Tools and Activities: Use the data analysis tools in the spreadsheet
application to examine the data from different aspects
-Synthesis: The Sum of the Parts
Allows you to interpret trends or patterns that seem to explain the past and the
present, and may suggest courses of action likely to favourably influence the
future
www.notesolution.com
Managers Request: Given your analysis of our companys relative success or
failure, suggest ways to capitalize on our strengths an overcome our
weaknesses
Helpful IT tools and activities: with analysis in mind, obtain feedback about
specific company products and services
-Communications: Sharing Analysis with Others
The ability to hare your analyses, ideas, and solutions with others (email,
PowerPoint, or instant messaging)
Managers Request: Present your findings and suggestions to management
Helpful IT Tools and Activities: import your spreadsheet data into presentation
software
-Databases: The Primary Data Storage for Organizations (page 214)
Database: the primary technology used to store, manage and allow efficient
access to data
Consist of interrelated data that are stored in files and organized so that
computer programs can quickly and easily access specific pieces of data
Database Management System (DBMS): a collection of software that allows
users to create and work with a database (used to obtain and print a customers’
monthly bank statement)
Database System: a data and a DBMS
Database Administrators (DBA): people who create and manage the database
use the tools in the DBMS to do their work
-The Data Hierarchy (pate 215)
To organize data in a database
Organizes stored data in increasing levels of complexity
www.notesolution.com

Loved by over 2.2 million students

Over 90% improved by at least one letter grade.

Leah — University of Toronto

OneClass has been such a huge help in my studies at UofT especially since I am a transfer student. OneClass is the study buddy I never had before and definitely gives me the extra push to get from a B to an A!

Leah — University of Toronto
Saarim — University of Michigan

Balancing social life With academics can be difficult, that is why I'm so glad that OneClass is out there where I can find the top notes for all of my classes. Now I can be the all-star student I want to be.

Saarim — University of Michigan
Jenna — University of Wisconsin

As a college student living on a college budget, I love how easy it is to earn gift cards just by submitting my notes.

Jenna — University of Wisconsin
Anne — University of California

OneClass has allowed me to catch up with my most difficult course! #lifesaver

Anne — University of California
Description
CHAPTER 6: DATABASE MANAGEMENT AND BUSINESS INTELLIGENCE - Organizational Plumbing: the IT systems designed to support different kinds of knowledge work- gathering and storing data, processing information, and making decisions - The Data-Information-Knowledge Continuum: • Data: raw unorganized facts, numbers, pictures, and so on • Information: data that have been organized and are useful to a person • Knowledge: a person combines experience and judgement with information (create value to organizations) • Wisdom: adds insights and ethics to the experience and professional judgement inherent in knowledge (enables leaders to perceive the underlying meaning and nuances of a business situation and ensures that knowledge from relevant perspectives, disciplines, and sources is considered in the final decision) - Lifelong Knowledge Creation • Explicit knowledge: knowledge that is readily codified, such as the knowledge in this textbook • Tacit Knowledge: knowledge gain through experience, insight, and discovery - Knowledge Work Activities • Knowledge Work: involves the discovery, analysis, transformation, synthesis, and communication of data, information, and knowledge • Work Flows: the steps you went through • Work Product: the outcome - Discovery: Finding Data, Information, or Knowledge (page 208) • Discovery: Finding of data, information, and knowledge relevant to a task, problem, issue, or opportunity (the context) • Managers’ Request: find our company’s and our competitors’ weekly sales data www.notesolution.com • Helpful IT tools ad Activities: use data from check-out/ point-of-sale (POS) terminals, search tools (ex: Google) and web searching - Analysis: Investigating and examining the available data, information and knowledge • Breaking down the whole into its more discrete pats to better understand how it works • Processnapping: if you are analyzing a business process • Quality assurance: if you are analyzing product quality • Performance Testing: if you are assessing fitness or standards • Data warehouses and data mining are two information technologies that can help answer questions about underlying patterns and correlations across large amounts of data • Manager’s Request: Compare the sales data for the first week of May to similar data from our company for the previous two months • Helpful IT Tools and Activities: Import the data into a database or spreadsheet application, and use its features and tools to organize the data - Transformation: Organizing Discovery Results • Transformations: knowledge work that requires you to use the results of your analysis to deepen your understanding of the data and information • Manager’s Request: Identify any trends in the data by week, month, and day of the week. Indicate how our company’s results compare with our competition and with the industry as a whole • Help IT Tools and Activities: Use the data analysis tools in the spreadsheet application to examine the data from different aspects - Synthesis: The Sum of the Parts • Allows you to interpret trends or patterns that seem to explain the past and the present, and may suggest courses of action likely to favourably influence the future www.notesolution.com • Manager’s Request: Given your analysis of our company’s relative successor failure, suggest ways to capitalize on our strengths an overcome our weaknesses • Helpful IT tools and activities: with analysis in mind, obtain feedback about specific company products and services - Communications: Sharing Analysis with Others • The ability to hare your analyses, ideas, and solutions with others (email, PowerPoint, or instant messaging) • Manager’s Request: Present your findings and suggestions to management • Helpful IT Tools and Activities: import your spreadsheet data into presentation software - Databases: The Primary Data Storage for Organizations (page 214) • Database: the primary technology used to store, manage and allow efficient accessto data • Consist of interrelated data that are stored in files and organized so that computer programs can quickly and easily accessspecific pieces of data • Database Management System (DBMS): a collection of software that allows users to create and work with a database (used to obtain and print a customers’ monthly bank statement) • Database System: a data and a DBMS • Database Administrators (DBA): people who create and manage the database use the tools in the DBMS to do their work - The Data Hierarchy (pate 215) • To organize data in a database • Organizes stored data in increasing levels of complexity www.notesolution.com • Lowest level: the data hierarchy stores all data using electronic bits that an be 1 (on) or 0 (off) • Data Character: a specific combination of bits • Ex: ASCII encoding scheme: use 8 bits (one byte) to store a letter of the alphabet • Unicode: store the same letter using 16 bits (two bytes) • Field: combination of characters representing a data item, such as a name or a price • Records: the next higher level of the data hierarchy stores collections of fields (First name, Last Name, Gender, Age) • Table or File: next level up, the data hierarchy assembles records into collection • Top Level: compiles the organized collection of files into a database • Advantages of using the a Database System to organize Data which improves the accuracy of the data stored (data integrity) as well as increase its use: Independent of any one software app which allows all apps to accessthe data in a standard manner Reduces data redundancy Include features for maintaining the quality of the data, handing security, and synchronizing accessby simultaneous users Allows for capabilities such as improved data access, allowing different views of the data for diff users, and repo
More Less
Unlock Document


Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit