Study Guides (238,085)
Canada (114,909)
Administration (1,171)
ADM2372 (42)
All (20)

MIS Final Notes.doc

20 Pages
Unlock Document

University of Ottawa

MISFINALNOTESCHAPTER 7DATABASES AND DATA WAREHOUSESDATABASE FUNDAMENTALSInformation QualityBusiness decisions only as good as information used to make themWhat are the characteristics of high quality informationoAccuracyoCompletenessoConsistencyoUniquenessoTimelinesCharacteristics of low quality informationoMissing infooIncomplete infooInaccurate infooDuplicate infooWrong infoCosts of poor informationoInability to accurately track customersoDifficulty identifying valuable customersoInability to identify selling opportunitiesoMarketing to nonexistent customersoInability to build strong customer relationsDatabase FundamentalsDatabase collection of data organized to serve several applications efficientlyMaintains info about various types of objects inventory transactions events people employees and places warehousesDatabase AdvantagesIncreased flexibilityIncreased scalability and performanceReduced redundancyIncreased qualityIncreased securityRelationship DatabaseMost popularRepresented by twodimensional tables called relations or filesRelate data across tables based on commondata element ex AccessEntity rowsa person place object or event about which data is stored Entity Class tablea collection of similar entriesAttributes fields or columnscharacteristics of an entity classPrimary Keya field that uniquely identifies a given entity in a tableMISFINALNOTESForeign Keya primary key of one table that appears as an attribute on another table that provides a logical relationship between the twoHierarchal DatabaseMostly in old systemsOrganizes data in treelike structureparentchild relationships one to manyReliable but not very specified in advanceNot very flexibleDatabase Management SystemDBMSsoftware through which users and application programs interact with databasesFour components of DBMS1Data definition2Data manipulation3Application generation4Data administrationData Definition Component data dictionary essentially defines the logical properties of the info that the database containsData Manipulation Component query in accessDATA WAREHOUSE FUNDAMENTALSData Warehouse a logical collection of informationgathered from many different operational databasesthat supports business analysis activities and decision making tasks to aggregate info into a single depositoryExtraction Transformation and Loading ETLa process that extracts info from the external and internal databases transforms the info using a common set of enterprise definitions and loads information into data warehousesData Mart contains a subset of data warehouse informationInformation Scrubbing or CleansingTaking outMissing recordsRedundant recordsMissing keysErroneous relationshipsInaccurate dataMultidimensional AnalysisDatabase contain info in a series of twodimensional tablesIn a data warehouse and data mart info is multidimensional it contains layers in columns and roles dimensionsparticular attribute of infoCubecommon term for the representation of multidimensional informationData Mining
More Less

Related notes for ADM2372

Log In


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


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.