Weeks 8 and 9 - Design
Overview
Learn
- Differentiate database design philosophies and practices
- Evaluate Extract/Transform/Load designs and products
- Contrast metadata repository designs
Read
- Read Chapters 8, 9, and 10 in your textbook.
- Read about database design, ETL, and metadata design in the smaller textbook
Gartner Field Trip
If you are logged into the library you have access to Gartner. If you are not logged in the library will prompt you to do so.
- "How Metadata Improves Business Opportunities and Threats" http://www.gartner.com/document/1949417
- "Gartner Clarifies the Definition of Metadata" http://www.gartner.com/document/1424022
- "Exploit Metadata to Maximize Information Value" http://www.gartner.com/document/3250517
- "Five Reasons Why Big Data Needs Metadata Management and How to Leverage It" http://www.gartner.com/document/3075917
- "Metadata Is the Fish Finder in Data Lakes" http://www.gartner.com/document/3142417
- "Securing the Internet of Things" http://www.gartner.com/document/3316617
You are, of course, free to look for more Gartner articles that support your Weighty Posts - these are merely a starting point.
If you are asked to pay money you probably didn't start off from the library. It's very important that you are logged into the library and only access Gartner from the library.
Internet Field Trips
- "The Internet of Things is being used to launch massive cyberattacks" http://www.businessinsider.com/internet-of-things-cyberattacks-2016-10
- "Database Design - Better Business Intelligence = Don't Lose a Keystroke" http://it.toolbox.com/blogs/tricks-of-the-trade/database-design-better-business-intelligence-dont-lose-a-keystroke-20636
- "Blueprint for Do-it-Yourself Metadata" http://www.information-management.com/newsletters/metadata_ETL_integration-10018603-1.html | pdf
- "Shedding Light on Building and Implementing Successful Taxonomies" http://content.arma.org/IMM/May-June2011/IMM0511businessmatterssheddinglightonbuilding.aspx
- "Structured Data Elements: Are They Records?" http://content.arma.org/IMM/marchapril2011/IMM0311structureddataelements.aspx
- "Getting Started: Metadata, Tagging and Twitter Hashtags" https://web.archive.org/web/20140301061636/http://socialmediatoday.com/farshidketabchi/102624/getting-started-metadata-tagging-and-twitter-hashtags
- "#InPraiseOfTheHashtag" by Julia Turner for The New York Times, November 2012, http://www.nytimes.com/2012/11/04/magazine/in-praise-of-the-hashtag.html?_r=0&pagewanted=all
Watch
- "What is Metadata?" http://youtu.be/HXAstVP3-y0
- "What is Metadata?" (different presenter with a charming Scots accent) http://youtu.be/96ncNPpohjo
