ISYS111 Lecture Notes - Lecture 9: Data Governance, Core Data, Data Model
17 Jun 2018
School
Department
Course
Professor
Managing data:
• Difficulties involved in managing data:
o Data needs to be accurate, complete, timely, consistent, accessible,
relevant and concise
o Data must be consolidated in a common and accessible location to
everyone as the storage media on which data are kept may deteriorate
over time, causing the data to be lost
• Data governance, master data and transactional data
o Data governance: formal set of business processes and policies that
ensure that data are handled in a certain, well-defined manner
o Master data: set of core data (customer, product, employee, vendor, etc.)
that are common across the entire organisation
o Transactional data: captured by individual transaction of the information
systems that actually operate the business. Transactions define the
activities of the business
Database approach:
• Databases:
o Used to store data
o Eliminate many problems that arose from previous methods of storing
and accessing data such as file management systems
o Arranged so that one set of software programs provides all users with
access to all the data
• Database management systems (DBMS):
o
o Data model: diagram that represents the entities (person, place, thing,
event) in a database and how they relate to one another (relationships)
o Primary key: field in the database that is used to uniquely identify a
record so that it can be retrieved, updated and sorted
o Secondary key: field in the database that has additional identifying
information but cannot identify an individual record uniquely
find more resources at oneclass.com
find more resources at oneclass.com
