Supplemental Websites for this Chapter
Information to Supplement this Chapter from the Authors
Other Websites Pertinent to this Chapter
Websites from this Chapter in the Text
Websites Referred to in the Text of this Chapter
Chapter References for this Chapter that Are Online
Onsite Information to Supplement the Text
Database or Spreadsheet (Chapter 9)
Importing an Excel file into Access
Data is... (An animated show - must have Power Point installed to view)
Offsite Websites That Are Pertinent to This Chapter
- Data Flow Diagraming
- Data Mining & Warehouses
- Data Modeling
- Database Dictionary
- Database Introduction
- Database Models
- Databases to Download and Query
- Normalizing Data
- Secondary Data Use (For Deidentified Data see Chapter 21)
- Tutorials
Data Flow Diagraming
Kozar, K. (1997). The Technique of Data Flow Diagramming. A detailed guide. of data flow diagramming techniques. This site may be over a decade old, but the information is still current.
http://spot.colorado.edu/~kozar/DFDtechnique.htm
Data Mining &Warehouses
Data Mining: What is Data Mining? A description rooted in the data, information, knowledge model. Applies to industry, but still some good basic information.
http://www.anderson.ucla.edu/faculty/jason.frand/teacher/technologies/palace/datamining.htm
Silver,Michael; Sakata, Taikil; Su, Hua-Ching; Herman, Charles; Dolins,Steven B.; & O’Shea Michael J. (2001). Case Study: How to Apply Data Mining Techniques in a Healthcare Data Warehouse. Journal of Healthcare Information Management, 15(2), 155-164. Technical at first, but read on to see the interesting discovery.
http://www.himss.org/content/files/jhim/15-2/him15208.pdf
Reed, M. (2002)A Definition of Data Warehousing. An easily read and understood definition.
http://www.intranetjournal.com/features/datawarehousing.html
Thearling, K. (1998). Data Mining and Privacy: A conflict in the making? A white paper discussing the issue.
http://www.thearling.com/text/dsstar/privacy.htm
Data Modeling
Data Modeling Overview. Continue through all these sections for a good explanation. Use the links in the text itself, the ones in the right hand column go through a screen telling you that these are in the archives.
http://www.utexas.edu/its/archive/windows/database/datamodeling/dm/overview.html
Database Models.
Database Models. Good description with diagrams of the various models, e.g flat, hierarchical etc.
http://www.databasejournal.com/sqletc/article.php/26861_1428721_3/Introduction-to-Databases-for-the-Web-Pt-1.htm
Database Dictionary
A database dictionary. In the definition for each term, links to the definition for other terms is provided. A valuable asset
http://www.geekgirls.com/database_dictionary.htm
Database Introduction
A very easily read piece with two sections, database basics and database design. Great information, applicable to any database. If you're looking for a nice, slow approach to learning databases, choose Databasics. If, on the other hand, you want to dive right into the nitty gritty of database design, try the companion series of articles, Databases from Scratch.
http://www.geekgirls.com/menu_databases.htm
Overview of the Relational Model. Use the links in the text itself, the ones in the right hand column are outdated.
http://www.utexas.edu/its/archive/windows/database/datamodeling/rm/overview.html
Databases to Download
Countries database in Access 97 or 2000. Has information such as population, area, and if a member of the UN. Will open in later versions of Access including 2007.
UN.http://www.geekgirls.com/databasics_06.htm#sampledata
US Census Bureau. Quick, easy access to facts about people, business, and geography. Select a state, or a county within that state, then data in which you are interested. When the table is in view, scroll to the bottom to download the file as an Excel spreadsheet. It can also be downloaded in a delimited format, by selecting the data, copying it (Ctrl+C) and pasting (Ctrl+V) it into Notepad. (Open Notepad from the Start Button>All Programs>Accessories>Notepad. They are tab delimited. Links above will help you to import to Access)
http://quickfacts.census.gov/qfd/index.html
Vital Statistics Tables from California. These Excel tables can be imported into Access if desired for querying.
http://www.dhs.ca.gov/hisp/chs/OHIR/tables/
Normalizing Data
Bostrup, T. (n.d.) Introduction to Relational Databases - Part 1: Theoretical Foundation. This article provides Codd's 12 rules of database design which you may want to skip. Don't, however, skip the sections about purpose and selecting key fields and normalization. Unless designing a complex database stop reading after the 3rd normal form .There are excellent descriptions of each of the seven forms with examples for the first three (the common ones). Excellent article and very easily understood.
http://www.15seconds.com/issue/020522.htm
Secondary Data Use (For Deidentified Data see Chapter 21)
AMIA report. Toward a National Framework for the Secondary Use of Health Data.
http://www2.amia.org/inside/initiatives/healthdata/2006/
finalpapertowardanationalframeworkforthesecondaryuseofhealthdata_09_08_06_.pdf
AMIA Secondary Uses and Re-uses of Healthcare Data: Taxonomy for Policy Formulation and Planning
http://www.amia.org/files/amiataxonomyncvhs.pdf
Enhanced Protections for Uses of Health Data: A Stewardship Framework for “Secondary Uses” of Electronically Collected and Transmitted Health Data (2007, Dec 19). Report to the Secretary
of the U.S. Department of Health and Human Services from the National Committee on Vital and Health Statistics. http://www.ncvhs.hhs.gov/071221lt.pdf
Manion, Frank J.Robbins; Robert J. Weems, William A.; Crowley, Rebecca S. (2009). Security and privacy requirements for a multi-institutional cancer research data grid: an interview-based study. (Abstract. On 6/22/09 the full pdf version was still in progress.)
http://www.biomedcentral.com/1472-6947/9/31/abstract
Transforming healthcare through secondary use of health data. A 40 page 2009 report by Price-Waterhouse Coopers. You may need to register name etc., but the report is free. Presents an excellent case for secondary data use, includes guidelines. (Added Dec 10, 2009)
http://www.medtechpublishing.com/pwc/Transforming-healthcare-through-secondary-use-of-health-data.pdf
Secondary use of data—striking a balance.
http://www.dataprotection.ie/documents/conferences/SecondaryUseDataHarryComber.doc
Joelving, F. (2010, February 10). Who owns your cells? New book tackles thorny issue [Book Review]. Presents some interesting information, see what you thin about this issues.
http://www.reuters.com/article/idUSTRE61B42N20100212?feedType=RSS&feedName=healthNews&utm_source=feedburner&utm_medium=feed&utm_campaign
=Feed%3Areuters%2FhealthNews%28News%2FUS%2FHealthNews%29
Tutorials
Access
None of these tutorials teaches how to name objects, i.e. precede every object with a code name indicating the type of object, e.g. "tbl" for table, "qry" for query etc. But still helpful.
Access 2000. Lots of illustrations to make understanding easy.
http://www.fgcu.edu/support/office2000/access/
MS Office Access 2003. A lengthy and thorough tutorial with many different sections.
http://www.brainbell.com/tutorials/ms-office/Access_2003/
Access 2007. Lots of illustrations to make understanding easy.
http://www.fgcu.edu/support/office2007/access/index.asp
Boolean Searching
Boolean Seaching. A well explained site, even includes advance Boolean Searching.
http://www.patentlens.net/daisy/patentlens/1107.html
Websites Referred to in Text of Chapter
There are none in this chapter.
References in this Chapter that are Online
Lashenko, A. (n.d.). Database Models. Retrieved November 21, 2008, from http://www.unixspace.com/context/databases.html
Lundberg, C., & Konicek, D. (2007, March). Overview: SNOMED Clinical Terms® Nursing Working Group & Collaboration. Retrieved November 22, 2008, from http://www.dsr.dk/dsr/upload/3/0/997/SNOMED_CAP_6.pdf
StarSoft Inc. (2006). Data Mining Techniques. Retrieved November 21, 2008, from http://www.statsoft.com/textbook/stdatmin.html
Two Crows Corporation. (1999). Introduction to data mining and knowledge discovery. Retrieved November 21, 2008, from http://www.twocrows.com/booklet.htm
W3 Schools. (2008). Introduction to SQL. Retrieved November 21, 2088, from http://www.w3schools.com/sql/sql_intro.asp
What is OLAP? (2008, March 3). Retrieved November 21, 2008, from http://www.olapreport.com/fasmi.htmCreated June 1, 2009