Database+Management+Home

=‍Welcome to IST 326 Course Wiki! ‍=
 * || **Teaching Philosophy:**
 * 1) Data is key; Organizing, designing, collecting, processing and querying data give the management team key decision direction.
 * 2) We will learn database management by reading, viewing and getting our hands on company information, software company training material, and white papers.
 * 3) Knowledge learned is expected to be applied to individual and group projects
 * 4) Professional writing, oral communications, and group interactions will all enhance your experience in this course. ||

http://en.wikibooks.org/wiki/Structured_Query_Language

http://searchstorage.bitpipe.com/data/demandEngage.action?resId=1357234634_203 =Choosing Blindness with Business Data= http://www.information-management.com/blogs/choosing-blindness-with-business-data-10023770-1.html?ET=informationmgmt:e5850:2260350a:&st=email&utm_source=editorial&utm_medium=email&utm_campaign=IM_Blogs_010913

= The Rise of Analytic Platforms  =

 || || ||=

|| Unity: Because the Sum is Greater than All the Parts Dec. 4 @ 4 ET **Live Webcast** REGISTER NOW!
 * ||  ||   || ** DECEMBER 3, 2012 ** ||
 * ||  ||   || ** DECEMBER 3, 2012 ** ||

The current Holy Grail of analytical systems is the Unified Data Architecture: a management layer that connects people and systems to all the appropriate information sources, both structured and unstructured, across the entire enterprise. The idea is to provide a strategic view of information assets, ideally with an intelligent metadata layer that helps users align salient data sets, thus enabling a big-picture perspective that fosters insight, collaboration and improvement. Register for this episode of The Briefing Room to hear veteran Analyst Krish Krishnan explain why we're closer than ever to achieving this holistic perspective for data assets. ||

|| Hot Technologies of 2012:  Analytic Platforms Dec. 5 @ 3 ET **Live Webcast** REGISTER NOW! There's a good reason why so many people are talking about analytic platforms these days. The surge in popularity of Big Data, coupled with the need to reconcile this new source of insights with Business Intelligence and Data Warehousing, has fueled a wave of innovation for synthesizing analytical capabilities. What are the latest innovations in analytic platforms? Register for this episode of Hot Technologies to find out! Veteran Analysts Mark Madsen of Third Nature and John O'Brien of Radiant Advisors will offer their insights on what to look for in a robust analytic platform. || Enabling Self-Service Access and Exploration of Big Data Dec. 11 @ 4 ET <span style="font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">**Live Webcast** <span style="color: #0a74db; display: block; font-family: Arial,Helvetica,sans-serif; font-size: 12pt;">REGISTER NOW!

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 10pt; text-align: center;">As the information landscape expands with all kinds of Big Data, businesses are searching for ways to unite their traditional analytics with this new source of insight. One ambitious approach involves federating access to multiple data sources, even across various operating systems. The idea is to take analytic processing to the data, then intelligently assemble the results for a business user. <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 10pt; text-align: center;">Could this be the long-awaited alternative to data virtualization? Register for this episode of The Briefing Room to hear veteran Analyst Robin Bloor explain how federated access to data sources can pave the way for a truly integrated data fabric. <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| Time to Face the Music: <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;"> TARP Update and the Fiscal Cliff <span style="color: #000000; display: block; font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">Dec. 12 @ Noon ET <span style="font-family: Arial,Helvetica,sans-serif; font-size: 10pt;">**Live Webcast** <span style="color: #0a74db; display: block; font-family: Arial,Helvetica,sans-serif; font-size: 12pt;">REGISTER NOW! The implementation of the Troubled Asset Relief Program (TARP) turned a lot of heads, not so much because the government was offering financial assistance, but because it did so at such an enormous scale. Now in its third year, many are left wondering: how successful has the program been and what unforeseen consequences emerged because of it? Register for this episode of Federal Spending to hear former TARP regulator Amy Poster review the program's successes and shortcomings. <span style="color: #bf3f3f; display: block; font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 17pt;">Managing Diverse Workloads in the Data Warehouse ** by Krish Krishnan **
 * || [[image:http://ih.constantcontact.com/fs095/1104983460042/img/53.png width="75" height="88" align="left" link="@http://r20.rs6.net/tn.jsp?e=001ySE4F8mySsnNBeM8PXC7ZRnWQOD0ZJ1hcN3qnmxKm0SYQvQHrYnpdVqsoZZiEZPUCgSjWmHrYnq-uzF58xB2R7uRd835O5-oQKggpCoYj2WeUWoKaJZ2SOS1xQEC9qu7p-pwCOaj4rPRTAohVrAymPpQ9Ony27yH"]]
 * || [[image:http://ih.constantcontact.com/fs095/1104983460042/img/53.png width="75" height="88" align="left" link="@http://r20.rs6.net/tn.jsp?e=001ySE4F8mySsnNBeM8PXC7ZRnWQOD0ZJ1hcN3qnmxKm0SYQvQHrYnpdVqsoZZiEZPUCgSjWmHrYnq-uzF58xB2R7uRd835O5-oQKggpCoYj2WeUWoKaJZ2SOS1xQEC9qu7p-pwCOaj4rPRTAohVrAymPpQ9Ony27yH"]]

The modern data warehouse is not a single system-based architecture that serves all the enterprise users; it has grown into an ecosystem of diverse systems that is geographically distributed on different technology platforms with data shared across the platforms. Along with the growth of the platforms comes the challenge of managing workloads across the platforms.

READ MORE... ||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= <span style="background-color: transparent; color: #0a74db; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">UP 2012 Cloud Computing Conference
 * ||  ||  ||= <span style="font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 16pt;">**EVENTS** ||
 * ||  ||  ||= <span style="font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 16pt;">**EVENTS** ||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">San Francisco, CA <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Dec. 12 -13

<span style="background-color: transparent; color: #0a74db; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">TDWI World Conference Series

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Las Vegas, NV <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Feb. 17 - 23

<span style="background-color: transparent; color: #0a74db; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Strata Conference

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Santa Clara, CA <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Feb. 26 - 28 <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= <span style="font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 16pt;">**RECENT WEBCASTS** <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= ||


 * || Three Keys for Making Big Data User-Friendly ||  ||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= ||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= <span style="font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 16pt;">**Book Nook** <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= || by David Loshin || <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= <span style="font-family: "Arial Narrow","Arial MT Condensed Light",sans-serif; font-size: 16pt;">**Newsletter Archives** <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">|| <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||= <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">** Access and Explore: Big Data and Beyond **
 * || Time to Fly -- Why Predictive Analytics Is Going Mainstream ||  ||
 * || "Business Intelligence - The Savvy Manager's Guide, 2nd Edition"

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">** Ten Laws of Information Technology **

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">** Three Keys for Making Big Data User-Friendly **

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;"><span style="color: #4c4c4c; display: block; font-family: Arial,Helvetica,sans-serif; font-size: 8pt;">More... ||

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">||=






 * ||= Send an email to Inside Analysis! ||  ||   ||   ||

= Ten Laws of Information Technology = <span style="background-color: transparent; color: #888888; display: block; font-family: arial,sans-serif; font-size: 1em; text-align: center;">by [|ROBIN BLOOR]  on NOVEMBER 15, 2012

<span style="background-color: #ffffff; color: #111111; display: block; font-family: Georgia,"Times New Roman",Times,serif; font-size: 1.4em; text-align: center;">The following are observations about IT, which seem almost – if the field of IT can be classified as natural – to be natural laws. > Join Robin Bloor in [|The Briefing Room] on Tuesday, Nov. 20 as he discusses the maturation of Cloud Computing.
 * 1) **Digital information is alive; it reproduces and replicates.** Data is often regarded with such reverence that when it dies it is frozen cryogenically by a process called //archive//rather than being cremated and destroyed by a process called//deletion//.
 * 2) **Office software is the heart of bureaucracy. Email is its soul. IT made it immortal.** Information technology loves bureaucracy. Bureaucracy loves information technology. They embrace each other, even shamelessly in public, in a pretense to efficiency.
 * 3) **Big databases outlive little databases – the survival of the fattest.** This is why all new database products target “big data.”
 * 4) **Big data is not new. There always was big data, there is big data, there always will be big data.** Next year’s big data will be bigger than this year’s big data. Big data is not yet really big, but it cannot be prevented from growing.
 * 5) **Good marketing trumps good technology every time. It’s not a fair fight.** Alternatively it is a fair fight, because good technology with good marketing usually beats bad technology with good marketing. VCs know this. IT start-ups that rely on quality of technology are carrying a knife to a gun fight.
 * 6) **Any sufficiently advanced information technology is indistinguishable from entertainment.** If a new information technology can be used for entertainment it will succeed. Even better if it can be used pornographically – but, in that case, the vendor will strenuously deny that it targets the “smut” market. To be successful software products should provide the user with an opportunity to play.
 * 7) **Consumer IT is a fashion industry that naturally invades corporate IT.** Fashion is a very powerful IT force. IT vendors have convinced IT consumers that they are buying fashion. This, happily for them, creates a renewable market for their products. And it also establishes corporate relevancy in corporate IT (corporations are people, my friend). Apple penetrated the corporation via the consumer IT market, with no marketing (cost = zero) whatsoever to the corporation.
 * 8) **Corporate IT is depicted as an arms race, but it is not.** Weapons command high prices, so there are big advantages to the “arms race” paradigm for the IT vendor, which are usually supported by heroic “war stories.” This is marketing genius.
 * 9) **The user interface is the most important component of any software.** The UI is all that the user ever sees. The user is thus inclined to believe that the UI is the software. Gaming programs are almost all UI – odd when you think about it, that they have no practical function. Other programs would do well to adopt gaming interfaces.
 * 10) **Man created information technology in his own image.**But information technology is an atheist. It does not believe in or pay any homage to its creator. That’s why it abuses us so frequently.

[]Big Data Becomes Operational!
<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[] What is a Data Model?

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">**SAP announces additional support for Hadoop**

<span style="background-color: transparent; color: #666666; display: block; font-family: arial,trebuchet,verdana; font-size: 13px; text-align: center;">Todd Morrison, News and Features Editor <span style="background-color: transparent; color: #222222; display: block; font-family: arial,trebuchet,verdana; font-size: 10px; text-align: center;">SAP announced last week that it is offering new packages that integrate Hadoop software with its analytics and database technologies, including its much-touted HANA in-memory platform and Sybase IQ server, a columnar database and enterprise data warehouse.

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,trebuchet,verdana; font-size: 10px; text-align: center;">SAP also announced packages integrating Hadoop and SAP Data Integrator and across the SAP BusinessObjects business intelligence (BI) suite.

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,trebuchet,verdana; font-size: 10px; text-align: center;">The new packages, being offered through partners including Cloudera, Hitachi Data Systems, Hortonworks, HP and IBM, give customers a comprehensive data warehousing solution for real-time analysis on large data sets coming from various sources, according to SAP.

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,trebuchet,verdana; font-size: 10px; text-align: center;">Hadoop is a free, Java-based programming framework used to process large data sets over a distributed computing environment, using multiple machines, according to SAP. It is part of the Apache project sponsored by the Apache Software Foundation. <span style="background-color: transparent; color: #222222; display: block; font-family: verdana; font-size: 13px; text-align: center;">Read about the new SAP Hadoop support

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">http://www.youtube.com/watch?v=xNJZYX6tpWU Review basics here <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Data Modeling video: <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">List of videos from Data Modeling Class <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[|WWW.VTC.COM]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">In the find a tutorial enter Data Modeling

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">What is Data Model? <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Types of Data Models <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">The Evolution of Data Model <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Hierarchical Databases <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Network Databases <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Relational Databases <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Entity Relationship Databases

<span style="background-color: transparent; color: #222222; display: block; font-family: Arial; font-size: 18px; text-align: center;">**InfoWorld** Virtualization Alert <span style="background-color: transparent; color: #222222; display: block; font-family: Arial; font-size: 13px; text-align: center;">** IT Influencers: Building the next generation data center: a detailed guide **

<span style="background-color: transparent; color: #222222; display: block; font-family: Arial; font-size: 12px; text-align: center;">Moving tier 1 applications to virtualization and maximizing capacity utilization on virtual hosts are critical in realizing a fully optimized virtual infrastructure. This paper offers strategies to overcome virtualization obstacles and explains how automation and orchestration can control VM sprawl, reduce provisioning errors, and improve audit capabilities. <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">** Learn More **

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">**W3Schools lesson on SQL:** <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">1. read SQL tutorial <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">2. Take Quiz until you get 100% <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">3. Turn in proof of the 100%

<span style="background-color: #ffffff; color: #222222; font-family: arial,sans-serif; font-size: 10.5pt;">The 2012 Anderson Chandler Lecture is approaching.
<span style="background-color: #ffffff; color: #222222; display: block; font-family: arial,sans-serif; font-size: 10.5pt; text-align: center;">Gov. Sam Brownback will present "Economic Growth and Kansas Tax Policy" at **7 p.m. Monday, Sept. 10, at the Lied Center.**

<span style="background-color: #ffffff; color: #222222; display: block; font-family: arial,sans-serif; font-size: 10.5pt; text-align: center;">Please add this lecture to your calendar, and encourage your students to attend. You are also invited to attend a dessert reception immediately following the presentation in the Lied Center pavilion. <span style="background-color: rgba(255,255,255,0.917969); color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">This will count as one makeup homework assignment or 5 bonus quiz points. Requirement: Write an three paragraph original review of the session.

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Data normalization example as shown in class: <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">http://www.youtube.com/watch?v=fg7r3DgS3rA

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Links to great instructional videos on data modeling: <span style="background-color: #ffffff; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: left;">[]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Link to Information Management homepage: http://www.information-management.com/

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Article sources: <span style="background-color: transparent; color: #222222; display: block; font-family: Arial,Helvetica,sans-serif; font-size: 16px; text-align: center;">SearchBusinessAnalytics.com <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">[]

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Google Docs tutorial: http://www.youtube.com/watch?v=6_hJ3R8jEZM&feature=related

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Lucidchart videos: <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">http://www.youtube.com/watch?v=G7iyOm0mbBY <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">http://www.youtube.com/watch?v=hly1tqs7ZfI&feature=player_embedded#!

<span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">Office Max case study <span style="background-color: transparent; color: #222222; display: block; font-family: arial,sans-serif; font-size: 13px; text-align: center;">http://www.paraccel.com/resources/Case-Studies/ParAccel-Case-Study-OfficeMax.pdf?mkt_tok=3RkMMJWWfF9wsRonuajLZKXonjHpfsX86%2BUoW6Kg38431UFwdcjKPmjr1YIASMV0dvycMRAVFZl5nRxZCOGWf4VM