Rollins is a small automotive dealership. Rather than employ his own people to manage a website, he is able to use Dealercarsearch.com, which manages his database
High quality data are
The Difficulties of Managing Data
*Amount of data is increasing exponentially
*scattered throughout organizations
and collected by many individuals using
various methods and devices
*Data come from many sources
*Data degrade over time (outdated data)
*Data are subject to data rot (outdated,
destroyed storage media)
*Data security, quality, and integrity are critical, yet easily jeopardized
*Inconsistent, conflicting data due to
nonintegrated information systems
*Federal regulations (Sarbanes-Oxley)
*Companies are drowning in unstructured data
An approach to managing information across an entire organization.
“A plan for dealing with database”
Master data management (MDM)
*A strategy for data governance
*A process that spans all of an organization’s business processes and applications
*Allows companies to store, maintain,
exchange, and synchronize a consistent, accurate, and timely “single version of the truth” for the company’s core master data
A set of core data that covers a complete enterprise information system
Databases minimize the following problems:
Data redundancy, Data isolation, Data inconsistency, Data security, Data integrity, and Data independence.
The same data are stored in many places.
“Can be good or Bad”
Various copies of the data do not agree.
Keeping the organization’s data safe from theft, modification, and/or destruction.
Data must meet constraints and be reliable
Applications and data are independent of one another.
Database management system (DBMS)
: Specific type of software for creating, storing, organizing, and accessing data from a database
A diagram that represents the entities in the database and their relationships.
Entity-relationship (ER) modeling
A person, place, thing, or event about which information is maintained
Entity classes: Groups of entities of a certain type (group of records)
Entity instance: The representation of a particular entity (a record)
A particular characteristic or quality of a particular entity
Primary key (or identifier): A field that uniquely identifies a record
Secondary keys: Other fields that have some identifying information (e.g., major, state)
Types: One-to-one, One-to-many, Many-to-many
Minimum and maximum cardinality
The most popular database architecture
Widely used by organizational employees
Examples: Microsoft Access and Oracle
Used to request information from a database.
Structured query language (SQL)
The most popular query language
Allows users to perform complicated searches using relatively simple statements or key words
Query by example (QBE)
Allows users to fill out a grid or template to construct a sample or description of the needed data
*Defines the format necessary to enter the data into the database
*Creates standard definitions for all attributes
*Provides organizational data resource inventory for effective data management.
Data about Data.
Stored in Data Dictionary
*A process of improving the database
design structure by putting it into
its most streamlined form
*When data are normalized, attributes in the table depend only on the primary key
*Streamlines complex groupings of data
*Minimizes redundant data
*Maximizes data integrity
Provides best processing performance
A large repository of historical data organized by subject to support decision makers in the organization
A low-cost, scaled-down version of a data warehouse designed for the end-user needs in a strategic business unit (SBU) or a department
Provide data to the warehouse or mart
Utilize IT to Extract data from source systems, Transform it, and Load it into a warehouse or mart
Storing the data
Different architectures are available
The quality of the data in the warehouse must meet users’ needs
Ensures that the systems meet organizational needs
Include information producers (create information for others) and information consumers.
*Objective, rational, technical knowledge that has been documented and can be distributed or transformed into a process or a strategy
*Examples: Policies, procedural guides, reports, products, strategies, goals, core competencies
Cumulative store of subjective or experiential learning
Highly personal, imprecise, and costly to transfer
Examples: Experiences, insights, expertise, know-how, trade secrets, understanding, skill sets, learning, and organizational culture
Knowledge management (KM)
A process that helps organizations manipulate important knowledge that is part of the organization’s memory, usually in an unstructured format
Knowledge management systems
Use information technologies to systematize, enhance, and expedite intrafirm and interfirm knowledge management
Utilize best practices as the most effective and efficient ways of doing things
What’s in IT for ME?
Use databases to keep track of the transactions and internal controls of an organization
Use external databases to obtain financial data
Access marketing data and transactions
Contribute to an organization’s knowledge base
Use databases to perform optimization analysis
Human Resources Management
Utilize databases to keep track of employee records
Compensate employees who contribute to knowledge base
Manage databases, maintain data dictionary, and help users access needed data and generate reports with query tools