Daily+Information

=Daily Information for=

=**Principles of Management**=
 * Monday, November 25, 2013**


 * Leadership mini-module**
 * In class today we will explore two aspects of leadership, leadership styles and vision**
 * 1) ****PP slides available here:**** []
 * 2) Steve Jobs interview on managing people []
 * 3) Transformational Leadership []
 * 4) What's next

Thursday May 16, 2013 **Final Exam 4:30 PM**
> @http://www.registrar.ku.edu/sites/registrar.ku.edu/files/servicedocs/spring_2013_final_exam_schedule.pdf

Wednesday May 8, **2013 Projects** Monday May 6, **2013 Projects**
 * **Clarification on Project due date.**
 * The project is due on Monday. Every team should be prepared to present in class which means you need to give me access to your electronic project by 4:00 on Monday. Hard copy of the project can be turned in on Monday or on Wednesday.

Chapter 12, Quiz Chapter 12
 * Wednesday May 1, 2013**
 * 1) Distributed Databases []
 * 2) Distributed databases for fish industry []
 * 3) IBM on security of distributed databases []
 * 4) Distributed databases (mechanical voice) []


 * Monday, April 29, 2013**
 * 1) Chapter 11 quiz, Guest DBA Mark Filipi
 * 2) Concurrency controls []

> [] DBA Superman! > [] The job of the DBA > [] How to get your first job as a Database Administrator > [] Data warehouse administration the IBM way > [] Database Security >
 * Wednesday April 24, 2013**
 * 1) Chapter 11 homework Ch 11 p.506 review q 2, 8, 11, 12, 26
 * 2) Just-in-time Career Fair details on Recruiting page
 * 3) Data and Database Administration
 * 1) [] Mind altering!


 * Monday April 22, 2013**
 * 1) Chapter 10 Quiz
 * 2) SAS []
 * 3) Skip to the 4 minute mark.. MDM http://www.youtube.com/watch?v=M0QZrZgKDyk&feature=related
 * 4) Gartner [] central core function
 * 5) Complete data integration system []
 * 6) IBM loading data warehouse http://www.youtube.com/watch?v=_BIO3U10OeA
 * 7) More http://www.youtube.com/watch?v=36cffgFULpE

>
 * Wednesday, April 17, 2013**
 * 1) Chapter 10 Data Quality
 * 2) http://en.wikipedia.org/wiki/Data_quality
 * 3) Dirty data song http://www.youtube.com/watch?v=XBv95uMFudE
 * 4) Bad Quality http://www.youtube.com/watch?v=E0dIu4dCnJE
 * 5) Data Debris http://www.information-management.com/news/what-to-do-about-data-debris-10024289-1.html?zkPrintable=1&nopagination=1
 * 6) Dirty Data.. http://www.youtube.com/watch?v=yVXYfXyIFKg
 * 7) Cleaning data using Excel http://www.youtube.com/watch?v=pIyMc-oqbv4
 * 8) Data deduplication http://www.youtube.com/watch?v=6HNX_tk2VxU
 * 9) Planning for missing data http://www.youtube.com/watch?NR=1&v=XlUdRVdT7iU&feature=endscreen (long)
 * 10) Master Data management http://www.information-management.com/conferences/mdm/?utm_source=mdm-email&utm_medium=email&utm_campaign=imchat-summary
 * 1) Skip to the 4 minute mark.. MDM http://www.youtube.com/watch?v=M0QZrZgKDyk&feature=related


 * Monday, April 15, 2013**
 * 1) Exam policy clarification posted to dropbox. The 20 points on the syllabus for wiki contribution will be changed to a single white paper review due on Wednesday, April 17. Choose from white papers not already reviewed by you in the dropbox.com folder.
 * 2) If you have made contributions to the wiki, please foot note this fact on your white paper submission so I can consider what you have done for additional credit
 * 3) Vitalization PP presentations with video embedded
 * 4) A layer on the hardware creating an instance...http://www.youtube.com/watch?v=zLJbP6vBk2M
 * 5) Near term changes for big data http://www.information-management.com/gallery/how-will-business-analytics-change-in-the-near-future-10024267-1.html?ET=informationmgmt:e9124:2260350a:&st=email&utm_source=editorial&utm_medium=email&utm_campaign=IM_Daily_041013 slide show


 * Wednesday, April 10, 2013**
 * 1) Schedule and projects update
 * 2) Quiz on chapter 9
 * 3) Chapter 9 wrap up
 * 4) Star Schema by Oracle http://www.youtube.com/watch?v=LfehTEyglrQ
 * 5) AWS data Warehouse - Amazon Redshift http://www.youtube.com/watch?v=AUvn49gey8Y
 * 6) Amazon explains the economics of the cloud http://www.youtube.com/watch?v=yMJ75k9X5_8&NR=1&feature=endscreen
 * 7) We won't get to this today, but its a great basic intro to everything cloud and virtualization http://www.youtube.com/watch?v=QYzJl0Zrc4M


 * Monday, April 8, 2013**
 * 1) **Note the addition of a link for EZVID, a free video making program on the Project II page**
 * 2) Data Warehousing.. Chapter 9 Quiz on Wednesday
 * 3) Benefits of Data Warehousing https://www.youtube.com/watch?v=mgEugd5kZgk&list=PL6CDB8E02AEC6DF2B
 * 4) Data Warehousing Basics https://www.youtube.com/watch?v=EtaUzQrAPKE&list=PL6CDB8E02AEC6DF2B
 * 5) Star Schema design https://www.youtube.com/watch?v=KtfPAeu1OMM
 * 6) Dimensions Measures Hierarchy Grain https://www.youtube.com/watch?v=qkJOace9FZg


 * Wednesday, April 3, 2013**
 * 1) **Exam on Chapters 5-8**
 * 2) Link to XBRL article @http://bit.ly/10yJMLf
 * 3) Frequently missed questions on chapter 8 quiz:
 * 4) Fat client
 * 5) Advantages of Stored procedures
 * 6) Open database connectivity standard
 * 7) XML derived from SGML and allows customized tags - True
 * 8) XQuery not associated with HTML.


 * Monday, April 1, 2013**
 * 1) Check out the new page When Pigs Fly
 * 2) Spring Project II now has its own page! Project II Spring 2013
 * 3) See the Recruiting page for a special summer internship opportunity in India.
 * 4) Quiz on Chapter 8
 * 5) Review of 5-8
 * 6) SWOT wikipedia page http://en.wikipedia.org/wiki/SWOT_analysis for reference on project II
 * 7) Big Data Fighting Cancer http://online.wsj.com/article/SB10001424127887323466204578384732911187000.html?mod=e2tw#articleTabs%3Dvideo


 * Wednesday, March 27 2013**
 * 1) Chapter 8 continued and Chapter 8 quiz on Monday; chapter 8 homework due
 * 2) Recruiting page
 * 3) W3Schools Certificates http://ww1.w3schools.com/cert/default.asp
 * 4) XML video https://www.dropbox.com/lightbox/home/IST%20326%20Students
 * 5) Three tier and the cloud http://channel9.msdn.com/Blogs/DevRadio/Microsoft-DevRadio-Part-9-Practical-Azure-with-Jim-ONeil--Windows-Azure-Web-Sites
 * 6) Gartner video on virtualization http://www.itbriefingcenter.com/programs/gartner_1422_HP.html


 * Monday, March 25, 2013**
 * Rock Chalk Jay Hawks! Group Presentations continued.
 * Note slight changes to schedule in dropbox (final exam on Wednesday of exam week)
 * Intro to chapter 8; note second exam covers chapters 4-8 on April 3.
 * http://www.youtube.com/watch?v=LwggpLngGM4


 * Spring Break: Stay Safe**


 * Wednesday March 13, 2013**
 * Group Presentations, Project 1

Monday March 11, 2013

 * Quiz on Chapter 7 rescheduled
 * Project reminders.. Presentation, hard copy and electronic copy required!
 * White paper reviews due. See http://ist326.wikispaces.com/White+Paper+Review+Assignment for details
 * http://www.trinity.edu/rjensen/Bookbob3.htm#Dictionaries Writing help web links
 * 1) Infomatica [] Play first
 * 2) Hadoop page http://service-demand-forecasting.wikispaces.com/Hadoop-OpenSource
 * 3) [] 18 minutes on basics of Hadoop
 * 4) [] Application of Hadoop
 * Hadoop and big data changes to database management
 * http://service-demand-forecasting.wikispaces.com/Hadoop-OpenSource

**Wednesday March 6, 2013**

 * Check out the LinkedIn assignment on the recruitment page. You may use this assignment in lieu of the attend a public speech requirement.
 * Quiz chapter 7 re-scheduled for Monday, March 11
 * White paper reviews. Choose **2 for 30 points each**. Each review should be a one page review. Three strong paragraphs that answer the Why What and and How questions. Any white paper in the IST 326 dropbox is OK. You might want to chose one that will help you in your group project if possible. Due Monday.
 * Chapter 7 Advance SQL Topics
 * Sub Queries in WHERE
 * Aggregation (from dropbox.com)
 * Null (from dropbox.com)
 * https://www.youtube.com/watch?v=P_6vDLq64gE

**Monday March 4, 2013**

 * http://www.ted.com/talks/simon_sinek_how_great_leaders_inspire_action.html
 * SQL Chapter 6 homework, SQL queries; Chapter 6 quiz; Schedule review
 * Distinct Clause http://www.youtube.com/watch?v=Ub_PtqVUZok
 * Advanced Query(left join, http://www.youtube.com/watch?v=YLwZwheyeEc
 * SQL Basic slides
 * http://service-demand-forecasting.wikispaces.com/Hadoop-OpenSource

**Wednesday February 27, 2013**
>
 * Schedule Adjustment
 * Recruiting additions
 * http://www.youtube.com/watch?v=8oBKA4hU4xM Understanding Indexes 5:38
 * Quiz chapter 5
 * Turn in SQL quiz results. The quiz counts as a normal quiz.
 * SQL exercises http://www.youtube.com/watch?v=FCRY-MZNsjA Queries with a wild card
 * SQL videos from Stanford located in dropbox.com
 * http://en.wikibooks.org/wiki/Structured_Query_Language SQL online book
 * http://northwinddatabase.codeplex.com/

**Monday February 25, 2013**

 * =====**Class today is cancelled.** Watch for schedule adjustments coming soon.=====
 * From the recruiting page: 4) Ask yourself the "so what" question. Although keywords and skills are critical in getting through the initial screening process, you'll need to sell the reviewer on your abilities by stressing your accomplishments. Asking yourself "so what" after each bulleted statement on your resume will help you focus on the positive results you've achieved. See the recruiting page for more!

**Wednesday February 20, 2013**
>> [] Database Normalization >> [] First, Second and Third Normal Form examples >> [] Walking through 1st 2nd and third normal forms > > http://ww1.w3schools.com/sql/default.asp All students need to show proof that they have completed the quiz with a score of 100%. > > === ===
 * 1) Project update and reminders
 * See updated Automotive Project page Automotive Project
 * preliminary documentation and team member assignments
 * Due March 13; first round of presentations on March 13th
 * 1) Complete third normal form
 * 2) Normalization:
 * [] Normailzation "rule of one"
 * [] Another look at key characteristics of 1st, 2nd and 3rd NF
 * 1) http://www.youtube.com/watch?v=JzlW4dAeQ_Q Denormalization
 * 1) Introduce chapter 5
 * 2) http://www.youtube.com/watch?v=ihdHvGo4x5M Horizontal Partitioning in Oracle
 * 3) http://www.youtube.com/watch?v=rRQHoCB7LTk Logical and Physical design for autobody shop
 * 4) Chapter 5 homework
 * review questions 1,2,4,5,6,17,19 ||
 * ===**Note: Homework for the 27th includes an SQL quiz located at w3schools.org**===

**Monday February 18, 2013**
>> On Sun, Feb 17, 2013 at 5:46 PM, xxxxxxx wrote: >> > Professor Hannon, >> > >> > I have a question regarding the Quiz 3 Version B #4. It is the question that >> > asks which is true about the figure shown, and involves a rental unit, a >> > house, and an apartment. I was just wondering how the answer is B if there >> > is a "d" in the middle indicating a disjoint rule. Wouldn't that mean that >> > it cannot overlap? Thanks for your response. >> > >> > xxxxx >> Hi xxxx, >> >> Thanks for the question. The answer key is not consistent with the drawing. I think the problem stems from the real life problem of a house being capable of having an apartment inside of it. However, the way the drawing on the quiz question is displayed that situation according to the disjoint rule, cannot exist as depicted in the drawing. >> The answer is clearly either apartment or house according to the disjoint rule. We will cover this question before the exam and adjustments will be made to the quiz. >> >> Neal >> >> >> >
 * 1) Review chapter 4
 * 2) Exam 1-4
 * 3) Exam consists of multiple choice and one tor two problems similar to the diagrams in prior quizzes.

**Wednesday February 13, 2013**
> || **Bonus:** Ch 4 Exercises 15, 16 (optional) || > > Hi xxxxxxxx, > I do understand the importance of the career fair. I intend to cover the material for chapter 4 in class tomorrow and give a quiz at the end of the period. However, I will not object to anyone either leaving early or coming late **if they are attending the career fair**. Next Monday we have our first exam. I will time the exam also provide a chapter 4 review prior to handing out the tests and will make sure you still have ample time to complete the exam. > Those who miss the chapter 4 quiz while attending the career fair can make it up on Monday prior to the exam. I will be in my office by 11:15. (I also have a 1:00-2:15 class). > Neal Normalization: > http://www.youtube.com/watch?v=FZs-Qdf-Sxg&list=PL2976ACE87E7EC6DD Database Normalization > http://www.youtube.com/watch?v=ygfikznRjpw&list=PL2976ACE87E7EC6DD First, Second and Third Normal Form examples > http://www.youtube.com/watch?v=cEeXy88Zrak Walking through 1st 2nd and third normal forms > >
 * 1) Welcome to Career Day. If you are attending, good luck and happy hunting!
 * 2) Chapter 4; chapter 4 quiz
 * 3) Homework due:
 * Ch 4 Review Ques. 1,2,4,6,7,9,10,11 ||
 * http://www.youtube.com/watch?v=4T15hOhE5N4&list=PL2976ACE87E7EC6DD&index=3 Normailzation "rule of one"
 * http://www.youtube.com/watch?feature=endscreen&NR=1&v=y_MDbbqQIUU Another look at key characteristics of 1st, 2nd and 3rd NF

**Monday February 11, 2013**
>
 * 1) Example of completed prior project (see dropbox.com)
 * 2) Chapter 3 Quiz, Chapter 3 homework Enhanced ER diagram
 * 3) Turn in review questions 1, 2, 4-8; P 20 (p.146)
 * 4) Chapter 3 review
 * 5) http://www.youtube.com/watch?v=mQ4D0drMrYI watch from 6;00 mark
 * 6) http://www.youtube.com/watch?feature=trueview-instream&v=D4ZQxBPtyHg Big Data Primer

**Wednesday February 6, 2013**
> > You are welcome to attend and hear any of our class speakers this semester. Class meets from 4 to 7:30 on Wednesday evening in 424 Summerfield. Speakers come in either at 4 pm or 6 pm. An updated schedule is available on our website. > > 30-Jan Michael Hagedorn, CFO UMB Bank > 6-Feb John Dicus, CEO. Kent Townsend, CFO. Capitol Federal > 13-Feb Presentations & Steve Koenig > 20-Feb Steve Kovzan, CFO NIC, Inc. > 6-Mar Scott Jones/ Todd Preheim > 27-Mar Kevin Wilmot - Jayhawkers > 3-Apr Kevin Rauckman, CFO Garmin > 10-Apr Terry Matlack, Managing Director, Tortoise Capital > 17-Apr Greg Martinez, Morgan Stanley > 1-May John R. Elmore, US Bank, Vice-Chairman > > We have some empty seats in class on the top and third row on the side. Please let me know if you’d like to attend. > > Best regards, > > Catherine Shenoy, PhD s  Director, MBA Program s  Senior Lecturer > University of Kansas School of Business s  1300 Sunnyside Ave, 124C Summerfield Hall > Lawrence, KS 66045-7585 s  785-864-7519  begin_of_the_skype_highlighting 785-864-7519 end_of_the_skype_highlighting  begin_of_the_skype_highlighting 785-864-7519  begin_of_the_skype_highlighting 785-864-7519 end_of_the_skype_highlighting  end_of_the_skype_highlighting   begin_of_the_skype_highlighting 785-864-7519  begin_of_the_skype_highlighting 785-864-7519 end_of_the_skype_highlighting  <span class="skype_pnh_container"> begin_of_the_skype_highlighting <span class="skype_pnh_print_container_1360705086">785-864-7519 <span class="skype_pnh_container"> begin_of_the_skype_highlighting 785-864-7519 end_of_the_skype_highlighting  end_of_the_skype_highlighting  end_of_the_skype_highlighting  s MBA.ku.edu > > As I mentioned in last week’s assembly meeting, we are honored to bring **Nobel laureate and financial economist Robert C. Merton** to campus next week as a distinguished guest. (Read the full release.) > > ** He will present a public lecture, "A Next-Generation Solution for Funding Retirement: A Case Study in Design and Implementation of Financial Innovation," 1 p.m. Friday, Feb. 15, at the Dole Institute of Politics. ** > > Merton received the Nobel Prize in Economics in 1997 for his work on the Black-Scholes-Merton model for pricing options. This model remains one of the best ways to determine the value of derivative securities, and it is considered one of the most important concepts in modern financial theory. > > Merton’s lecture is part of the Bold Aspirations Visitor and Lecture Series, which highlights eminent visitors and KU scholars related to the four strategic initiative themes in KU’s strategic plan, Bold Aspirations. Merton’s lecture is most closely related to the strategic theme, “Harnessing information, multiplying knowledge.” > > You are all invited to attend his talk. Please share the event with your students and peers on campus. > > Rock Chalk, > Neeli > > Neeli Bendapudi > Dean, KU School of Business
 * 1) Quiz on chapter 2; Read Chapter 3 plus homework
 * 2) See updated schedule in dropbox
 * 3) http://video.cnbc.com/gallery/?video=3000097583 CNBC appearance June 13th
 * 4) http://www.youtube.com/watch?v=_02wy7U7pDE Cardinality Constraints
 * 5) Creating ERD's in Microsoft Visio http://www.youtube.com/watch?v=1BYt3wmkgXE&list=PL9D42FC153A024DAB part !
 * 6) Creating ERD's in Microsoft Visio http://www.youtube.com/watch?v=ow8AB0uKf3c&list=PL9D42FC153A024DAB part 2
 * 7) ERD activity #1 http://www.youtube.com/watch?v=v4mbqTsCEQc
 * 8) ERD #2 http://www.youtube.com/watch?v=GGZUNtKeGWs
 * 9) ERD #3 http://www.youtube.com/watch?v=TkZgrNtSN34
 * 1) Dear Colleagues,
 * 1) Dear faculty and staff,

**Monday February 4, 2013**
Team Rosters due; first come first served on assignments Agenda > http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model >>>
 * 1) Intern opportunity in Denver. See recruiting page for details.
 * 2) ER "cliff notes version" from Wikipedia The three schema approach (conceptual, logical, physical models)
 * review of business rules; entities, attributes
 * 1) http://www.youtube.com/watch?v=YL5h276A3-s 14 minutes ER modeling (tie into UML at the 12:40 minute mark)
 * 2) http://www.vtc.com/modules/products/moviePlay.php?sku=33607&foldername=datamodeling&id=45119&movieCode=0301&movieName=Entity+Relationship+Diagrams ER Diagrams (good intro)
 * 3) [] Entity Relationship Modeling
 * 4) Forxia Academy 5 videos on ER modeling http://www.youtube.com/user/ForxiaAcademy?feature=watch
 * 1) http://www.youtube.com/watch?v=_02wy7U7pDE Cardinality Constraints
 * 2) http://www.vtc.com/products/Data-Modeling-tutorials.htm
 * 3) http://www.databaseanswers.org/modelling_tools.htm
 * 4) http://www.excelsoftware.com/uml_topic.html UML Modeling
 * 5) http://www.youtube.com/watch?v=SrkqF9AnxaQ IBM Operational analytics

**Wednesday January 30, 2013**
Logistics review > > https://www.youtube.com/watch?v=Zfmk0GtANNs Client-Server Architecture > http://www.youtube.com/watch?v=HDssi0eZceM NetSuite hairball institute for business > > > >
 * Dropbox.com; ist326.wikispaces.com; Project work; 4 resume reviews complete; http://calvertsexpress.com/
 * 1) ​**Quiz on chapter one**; **chapter one homework due**
 * 2) http://www.youtube.com/watch?v=FNpGUrlN8Is NetSuite ERP
 * 1) [] s Epicore ERP automotive video
 * 1) systems development life cycle https://www.youtube.com/watch?v=1wD-Z62MxVg
 * 1) [] Entity Relationship Modeling

**Monday January 28, 2013**
>> >> Thanks for the question. The homework assignments are located at https://www.dropbox.com/home/IST%20326%20Students. >> >> Once there, look for the file IST 326 Schedule Homework_Exams_2013-2. That file contains all homework assignments and due dates. Keep in mind its now revision 2 and may change again so check the file often to be sure you have the latest version. >> >> >>
 * Dropbox logistics- re-organization of files
 * 1) Where are the homework assignments?
 * 1) http://paper.li/BigDataExpo/1329400391?utm_source=subscription&utm_medium=email&utm_campaign=paper_sub# another source for articles each day on the topic of Big Data
 * 1) Project #1 Companies
 * 2) Midas
 * 3) Autozone
 * 4) PepBoys
 * 5) Walmart Auto
 * 6) Sears Auto
 * 7) O'Reilly's
 * 8) Xexpress
 * 9) GM dealership
 * 10) Aamco
 * 11) Jiffy Lube
 * 12) Meineke
 * 13) Toyoda Car Dealership
 * 14) Stanford database course nealhannon ist326 http://www.db-class.org/db/Winter2013/videos/01-01-introduction

Foundational videos/papers on databases > http://www.youtube.com/watch?v=WCIMgoNGaqQ 51 minute video about creating a database in automotive market > [] (51 minutes)
 * http://www.youtube.com/watch?v=xNJZYX6tpWU Entities, Attributes, Relationships
 * http://www.youtube.com/watch?v=Y-bvjtYgRVU What is a Database?
 * Ten things to avoid in database design White paper (Dropbox account)
 * Background on Relational databases

**Wednesday January 23, 2013**
Welcome to class! Agenda: > >
 * 1) Foundational Material for Database Management
 * 2) http://www.coursesmart.com/IR/4184174/9780132662260?__hdv=6.8
 * 3) Syllabus discussion
 * 4) Wikispaces (daily agenda, syllabus, recruiting)
 * 5) Dropbox.com (homework scoring, white papers, project information, detailed schedule)
 * 6) Blackboard
 * 7) Daily assignments and quiz for every chapter
 * 8) Updated chart showing progress will be located on dropbox.com
 * 9) Introduction to Group Projects
 * 10) Recruiting Page
 * 11) http://digital.info-mgmt.com/info-mgmt/2012datamodeling#pg1
 * 1) http://bigdatauniversity.com/ IBM Academic Initiative
 * 2) Stanford Database Management course http://openclassroom.stanford.edu/MainFolder/CoursePage.php?course=IntroToDatabases
 * 1) http://www.information-management.com/channels/data-modeling.html


 * Financial Literacy Tools 2013 **

The AICPA's financial literacy campaign has reached many individuals in creative ways, writes Melora C. Heavey, senior manager of communications at AICPA. A community college teacher uses the interactive Me Save feature on the Feed the Pig website to help her students identify what type of spenders they are. A friend uses the 360 Retirement Planner to make sure he is on track with his savings. Other popular tools include the Weekly Savings Tip and  Tweens Curriculum. AICPA Insights

Spreading Financial Well Being ---

http://blog.aicpa.org/2013/01/spreading-financial-well-being.html#sthash.cJDIaL8x.azMXjhsc.dpbs

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ =End of Fall 2012 Course Material=

Final exam @ 4:30 Coverage 9, 10, 11, 12 52 questions worth 2 points each.
 * Wednesday December 12**

Project Two presentations
 * Wednesday December 5**

Project Two Presentations
 * Monday December 3**


 * Wednesday November 28**
 * Order of presentations for Mon-Wed will be based upon the time you add your electronic portion of the presentation to the appropriate dropbox account. All projects are due on Monday.**

http://www.youtube.com/watch?v=ZuHuZ5cwxQM Data Replication Solution http://www.youtube.com/watch?v=lr0IRdz38EA EMC Replication in Microsoft environment http://www.youtube.com/watch?v=G3xH2SoMOF0 <span style="background-color: #ebebeb; color: #333333; font-family: arial,sans-serif;">Concurrency Control basics set to Gnarls Barkley's "Crazy". http://www.youtube.com/watch?v=96sEBjdQ-vg IBM distributed databases and security http://www.youtube.com/watch?v=XksQYBNz2Kw Data Deduplication EMC http://www.youtube.com/watch?v=K2G-9w2aofY&feature=BFa&list=PL31AE4045B9B8B478 IBM Server Virtualization http://www.youtube.com/watch?v=cJcWViY_ZC4&feature=context-chf&playnext=1&list=PLB63318E77185F485 Content Management in the Cloud by IBM

http://www.youtube.com/watch?v=Kf9KjCKmDcU Cryptography http://www.khanacademy.org/math/applied-math/crypt/v/the-fundamental-theorem-of-arithmetic-1 http://www.youtube.com/watch?v=4w58M0MVwNo&feature=autoplay&list=PLC7EDCF897784CAAC&playnext=2 Why Smart Businesses are Turning to Cloud Storage

Chapter 12 quiz

http://www.youtube.com/watch?v=9_h5P-C5VEA Save the database! http://www.youtube.com/watch?v=HbXZzKesM8k Save the database II! http://www.youtube.com/watch?v=yZBgiMSDNyM&feature=related Intro to database security http://www.youtube.com/watch?v=DTtfksf7nQY&feature=related Database security demo http://www.youtube.com/watch?v=RM4sdWs2rmo&feature=related Managing database security http://www.youtube.com/watch?v=G3xH2SoMOF0 Concurrency Control... warning.. geeky lyrics! Chapter 11 quiz
 * Monday November 26**

Data and Database Administration http://www.youtube.com/watch?v=BDFEgXsv3zE&feature=related DBA Superman! http://www.youtube.com/watch?v=Jos6dRLzi80 The job of the DBA http://www.youtube.com/watch?v=U52GFwh0EvY&feature=related How to get your first job as a Database Administrator http://www.youtube.com/watch?v=sW0mckeBpYk Data warehouse administration the IBM way http://www.youtube.com/watch?v=XWidOqq71tk Database Security <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Exams: Final exam is mandatory unless I have given you an exemption. If you miss the final, I will take 10 points off you exam score for exam II. I will take the best two of three exam grades to apply to the 360 points. <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Quizzes: One quiz can be dropped. The remaining quizzes will be averaged and applied against the 140 points. <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Assignments: Homework counts for 100 points. One assignment can be dropped. A X+ average will equal 100 points. Any additional X++ points will count toward bonus points up to 5 points. White papers count 30 points each. <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Projects: Points will be prorated based on 170. For example, a 94 on project one will earn 160 of the 170 points available. <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Attendance: Perfect attendance will earn an additional 10 point bonus that can be counted against the assignment category. Perfect is defined as two or fewer absences.
 * Monday November 19**
 * Ch 11 p.506 review q 2, 8, 11, 12, 26 ||
 * <span style="background-color: white; font-family: Arial,sans-serif; font-size: 10pt;">Important Syllabus Clarifications: **

Quiz chapter 10 http://www.information-management.com/dmradio/-10022787-1.html Big Data and Data Analytics as disruptive technologies http://www.insideanalysis.com/wp-content/uploads/2012/11/BR12-11-13-Morphlabs1.pdf slides that go with the radio broadcast above. Data Quality Management white paper loaded Project II rosters final input http://www.youtube.com/watch?v=nJmGrNdJ5Gw Mapping Networks RSA Animate 7:00 mark for interconnections Centerprise Data Integration Demo http://www.youtube.com/user/AsteraSoftware?v=Z8E-g5-fKq8
 * Wednesday November 14**

White paper reviews due; Rosters due Project 2. Read chapter 10; homework due on Wednesday: http://www.youtube.com/watch?v=XqrRN-AbB1Y cleaning dirty data http://www.youtube.com/watch?v=3r-uf976GS8&feature=related http://www.youtube.com/watch?v=yVXYfXyIFKg&feature=related Intricity on dirty data http://www.youtube.com/watch?v=M0QZrZgKDyk&feature=related Master Data Management 4:24 mark for definitions Last day for candy count contest.. See "tune up your PC page" for details
 * Monday November 12**
 * p. 456 review questions 1, 2, 8, 9, 10 ||

No assigned homework. White paper review due on Monday, November 12. We will discuss the team assignments for project two. []
 * Wednesday November 7**
 * Cloud computing presentation (with emphasis on database applications)**

IT Trends Impacting the Network Cloud Primer YouTube Channel on Cloud Computing http://streaming.oracle.com/ebn/podcasts/media/9968978a_SOA_Cloud_050911.mp3 **PodCast on SOA to Cloud evolution** []

Monday November 5
Chapter 9 quiz http://www.youtube.com/watch?v=KtfPAeu1OMM Star Schema in Data Warehousing http://www.youtube.com/watch?v=R-sGvh6tI04&feature=related **Data mining video** http://www.youtube.com/watch?v=LFnewuBsYiY&feature=related BI and Business Analytics http://www.youtube.com/watch?NR=1&feature=endscreen&v=k7xvIrsJhDg Using Data Mining for purchasing insights http://www.youtube.com/watch?v=QYDtrFdwbC0&feature=channel&list=UL http://www.youtube.com/watch?v=UYkf3i6LT3Q&feature=autoplay&list=ULQYDtrFdwbC0&playnext=1
 * What is Business Intelligence**

[] Big Data and the Data Warehouse

Wednesday October 31
> ===http://www.information-management.com/resource-center/?id=10023052 Agile Data Warehousing=== > ===Data Warehousing Best Practices Star Schemas=== > http://www.youtube.com/watch?v=uG2J4XWTtts > http://www.youtube.com/watch?v=K_FCHYWGGug&feature=fvwrel
 * ===http://www.youtube.com/watch?v=0O5QGq4j81Q&feature=related 50,000 foot intro===
 * http://www.youtube.com/watch?v=LfehTEyglrQ&list=PL6CDB8E02AEC6DF2B&index=11&feature=plpp_video
 * ===Data Warehousing Basics===
 * http://www.youtube.com/watch?v=KGHbY_Sales&list=PL6CDB8E02AEC6DF2B&index=2&feature=plpp_video
 * ===Demystifying the Data Warehouse===
 * http://www.youtube.com/watch?v=mgEugd5kZgk&list=PL6CDB8E02AEC6DF2B&index=3&feature=plpp_video
 * ===ETL Process===
 * ===What is an ETL Tool?===


 * ====http://xkcd.com/1127/large/ Historical right lean vs. left lean in Washington, DC====

Monday October 29
Exam II Chapters 5-8 Most frequent misses:
 * Chapter 8 quiz updates:**


 * When XML documents are shredded, the elements are stored in a **relational database.**
 * A PC configured to handle user interfaces with little or no local storage is called a **Thin Client**
 * Web services are a set of emerging standards for protocols for automatic communication between software over the Web.
 * An advantage of stored procedures is that performance improves for complied SQL statements

Good luck on the exam.

Here's the link to my CNBC appearance from last June: http://video.cnbc.com/gallery/?video=3000097065&play=1#eyJ2aWQiOiIzMDAwMDk3NTgzIiwiZW5jVmlkIjoiTVdReU1PTXNaZDdTZWtVMUR6NUFyUT09IiwidlRhYiI6InRyYW5zY3JpcHQiLCJ2UGFnZSI6IiIsImdOYXYiOlsiwqBMYXRlc3QgVmlkZW8iXSwiZ1NlY3QiOiJBTEwiLCJnUGFnZSI6IjEiLCJzeW0iOiIiLCJzZWFyY2giOiIifQ==

Wednesday October 17
Chapter 8 Quiz http://www.information-management.com/ebooks/?ET=informationmgmt:e5636:2261558a:&st=email&utm_source=editorial&utm_medium=email&utm_campaign=IM_Daily_102212 https://cloud.google.com/products/big-query http://www.youtube.com/watch?v=T_upX2Js72g Google Apps for Business http://www.youtube.com/watch?feature=endscreen&v=pv5VQM8WtEk&NR=1

How XBRL works: http://www.youtube.com/watch?v=nATJBPOiTxM&feature=related Building a Drupal e-commerce site in 25 minutes: http://www.youtube.com/watch?feature=endscreen&v=ViS2xFvnZwc&NR=1

Monday October 22
Chapter 8; Quiz on Wednesday. Big Data http://www.youtube.com/watch?feature=fvwp&NR=1&v=nJmGrNdJ5Gw The Power of Networks http://www.youtube.com/watch?v=Zfmk0GtANNs client-server architecture http://www.youtube.com/watch?v=tcZXSfd_k0Q HP Thin Client http://www.youtube.com/watch?v=rF1X12PE6PY What is Drupal? http://www.youtube.com/watch?feature=endscreen&v=-Ifdijd6KEc&NR=1 Intro to Drupal XML

Wednesday October 17
Presentations and http://www.youtube.com/watch?v=QYzJl0Zrc4M&feature=fvsr **Basics of Cloud Computing 1:10 long** http://www.youtube.com/user/IBMITServices?v=BSDzi2hQ4so **IBM Virtualization** http://www.youtube.com/watch?v=lTLrKXzyUIw&list=PL31AE4045B9B8B478&index=29&feature=plpp_video **Storage Optimization from IBM**

Monday October 15
Presentations today. See new information posted in the recruiting section.

**Wednesday October 10**
<span style="background-color: #ffffff; color: #222222; font-family: arial,sans-serif; font-size: 14px;">Don’t forget to join the School of Business at Arthur Laffer’s lecture tomorrow at 5 p.m. in Woodruff Auditorium, including a reception following his presentation in the Malott room on level six. We look forward to seeing you there!

Special topics relating to white paper assignment http://kvsync.com/services/playlist/?p=idg.Dell_Networking_KV&email=hannon%40ku.edu

**Wednesday October 3**
Chapter 7 plus Chapter 7 quiz http://www.headfirstlabs.com/books/hfsql/ SQL Book for Download http://www.headfirstlabs.com/sql_hands_on/hf01.htm O'Reilly Head First SQL Hands On http://www.headfirstlabs.com/sql_hands_on/hf32.htm Joins http://ww1.w3schools.com/sql/sql_join_inner.asp Inner Joins http://ww1.w3schools.com/sql/sql_join_left.asp Left Join


 * Instructions for White Paper Review Due October 10th:**
 * Select your topic he following list:
 * 1) Virtualization
 * 2) Data De-duplication
 * 3) Analytics (either operational or predictive)
 * 4) Cloud Computing
 * 5) HaDoop (open source big data tool) (**<span style="font-family: 'Calibri','sans-serif';">hadoop **<span style="font-family: 'Calibri','sans-serif';">.apache.org/)
 * 6) SaaS (Software as a Service)
 * 7) Big Data
 * 8) Storage in the Cloud
 * Review the titles of the approximately 80 white papers loaded to Dropbox.com. Additional resources can be found at [|www.information-management.com]
 * Select (min) of two white papers focused on the topic you selected. Additional resources are encouraged but must be referenced.
 * Write an executive summary of what you have learned in **500 words** or less. Be sure to provide references to the papers you have selected so the executive can read them later.
 * 1) The summaries should be written focusing on how this technology or methodology will impact a real business. Direct the executive memo to a Chief Executive Officer and assume that you work for the I.S. department in the company.
 * Your typed hard copy reports are due on October 10th.

Feel free to use the articles posted to the wiki discussion pages as long as you add the article in your references.

Monday October 1
SQL continued; Quiz Chapter 6 Please join the School of Business at Arthur Laffer’s lecture on Thursday, Oct. 11, at 5 p.m. in Woodruff Auditorium, including a reception following his presentation in the Centennial room on level six.

Standard bonus points available for three paragraph summary of talk. Due Monday, October 15.

Wednesday September 26
SQL exercise in class plus chapter 6 SQL Basics http://www.w3schools.com/sql/sql_quiz.asp for homework due today. Must show results at 100% to qualify for X+ http://www.w3schools.com/sql/sql_quickref.asp

1. find all customers based in Spain 2. Display the complete records for customer contact Phillip Cramer and Francisco Chang 3. Add record for Jayhawk natural foods
 * Example questions:**
 * review questions 1,2,5; problem 6,7,8 Ch 6 due Monday October 1 ||

Monday September 24
How did the Career Fair go? Results from Exam One posted on Blackboard http://www.youtube.com/watch?v=O_adEBQQtoA Oracle partitioning http://www.youtube.com/watch?v=K_FCHYWGGug&feature=fvwrel ETL Tools Chapter 5 Quiz today http://www.w3schools.com/sql/sql_quiz.asp for homework

Wednesday September 19
<span style="background-color: #ffffff; color: #222222; font-family: 'Times New Roman',serif; font-size: 12pt;">**Career Fair this Thursday, September 20** <span style="background-color: #ffffff; color: #222222; font-family: arial,sans-serif;"><span style="font-family: 'Times New Roman',serif; font-size: 12pt;">Noon <span style="font-family: Tahoma,sans-serif; font-size: 12pt;">– <span style="font-family: 'Times New Roman',serif; font-size: 12pt;"> 4:00 p.m. <span style="background-color: #ffffff; color: #222222; font-family: 'Times New Roman',serif; font-size: 12pt;">5th and 6th floors, Kansas Union <span style="background-color: #ffffff; color: #222222; font-family: 'Times New Roman',serif; font-size: 12pt;">Participating Companies: @https://ku-csm.symplicity.com/events/students.php?cf=2012busfair See Recruiting page for more details.

<span style="background-color: #ffffff; color: #222222; font-family: 'Times New Roman',serif; font-size: 12pt;">We will begin chapter 5, Physical Database Design in class today. Homework due
 * review questions 1,2,4,5,6,17,19 ||

Monday September 17
From the University of Chicago Writing in College: A Short Guide to College Writing --- http://writing-program.uchicago.edu/resources/collegewriting/ Bob Jensen's helpers for writers are at http://www.trinity.edu/rjensen/Bookbob3.htm#Dictionaries


 * Exam on chapters 1,2,3,4.**

** Case Interviewing Workshop & Career Opportunities w/ Deloitte Consulting :** Please see the our ist326 Recruiting page for details.

 * Quiz** on chapter 4; **one page summary** of project and one pager on the **Gov Brownback lecture** for extra credit due today

**Project Alert:**
One suggestion. Add a statement of business intent for the use of data coming from your efforts. Here is an example:

The purpose of this Woman's clothing database is is to support the turnover of merchandise in the department. This will be accomplished by.

You can add to this as you see fit. The intent is to get you to link a business strategy to your database design.


 * Exam One** on chapters 1-4 will be held **Monday.**

**Monday September 10**
Quiz on Chapter 3. Chapter 4 homework due. We will introduce chapter 4 concepts in class today.including logical database design and data normalization. Key videos explaining the topics will be posted here shortly.

This is a reminder that the School’s **2012 Anderson Chandler Lecture** will be at the Lied Center at __7:00 on Monday, September 10.__ We hope that you will encourage your students to attend this lecture. We’d like to see a great turnout. The speaker is Governor Brownback. His topic: “**Economic Growth and Kansas Tax Policy**.”

For all those who have wrestled with creating charts and diagrams in word processors, the Google Chrome application Lucidchart may be a long-awaited answer. Users can start using the intuitive drag-and-drop interface right away, although a free signup is required to save diagrams. By sharing a link with coworkers, project collaborators can work on the same diagram at the same time. This application is compatible with all computers running Google Chrome.
 * Lucidchart: Diagramming ** --- https://chrome.google.com/webstore/detail/apboafhkiegglekeafbckfjldecefkhn

** Very Cool Mars landing video: **
http://www.youtube.com/embed/XRCIzZHpFtY?rel=0

Data normalization Videos from Youtube http://www.youtube.com/watch?v=FZs-Qdf-Sxg&feature=related http://www.youtube.com/watch?v=ygfikznRjpw&feature=related nealhannon's Youtube channel http://www.youtube.com/user/nealhannon

**Wednesday September 5**
Read Chapter 3, Quiz on chapter 3 is Monday September 10th. Review team setup and due dates. Offer to review preliminary plan. Due on Sep 12th. Team roster with commitments and planning scope for project 1.

**Labor Day Weekend**
http://www.webproxbrl.com/blog/?p=83 Enjoy!
 * Here's my blog "Tune up your PC for free"**

**Wednesday August 29**
Here's an example of the email I get daily: Hi Neal,

Thank you for registering for the DMRadio broadcast titled “**Do You Really Need an Enterprise Data Warehouse**?” sponsored by Denodo Technologies. As expected, everybody on the show agreed that the data warehouse will not become irrelevant anytime soon, but they also agreed that the idea of an enterprise data warehouse’ is ceasing to point just towards a collection of relational databases and is evolving to point towards a dynamic information system, which is a system of reference for any kind of data, much like the world wide web.


 * Data Virtualization** is playing a key role in developing this dynamic information system. While it is not intended to replace a data warehouse, it is becoming important to increase value, time to market and agility of existing information delivery systems. Companies are using this technology to boost their existing data infrastructure in use cases like data warehouse extension, prototyping, virtual data marts and to integrate big data sources with the existing data warehouse.

We have many resources available on www.denodo.com, here are a couple of recommended resources:


 * Webinar by Cisco titled, **‘Value-Added Customer Technical Services - Practical Challenges Overcome with Data Virtualization**’ which talks about how Data Virtualization is being used to increase agility of their existing information delivery systems. @http://www.denodo.com/en/resources/webcasts/dv_world_series_2011/index.php


 * **Whitepaper titled, "Data Virtualization Goes Mainstream"** which describes the capabilities of a Data Virtualization platform and provides case studies.

We hope this provides ideas for potential uses of Data Virtualization at your company.

I will be reaching out to you to discuss these ideas and determine if a very targeted teleconference session covering your specific interests and/or needs with a Data Virtualization expert would be of value to you.

Thank you.

Best Regards,

Kimberly J. Lukens Sales Development Manager Denodo Technologies

Monday August 27th
Today in class we will do some work on the data model, talk about the first group project and explore what is a white paper. Quizzes from chapter one will be returned,

http://www.imarketingmag.com/tutorial/White-Paper-marketing-tutorial-title-slide.html

Where will the jobs be in 2020? []

Desk top virtualization []

Abbreviations []

August 22, 2012 =Why Woz is unhappy with the cloud=

Although the Apple co-founder says the idea of the cloud is great, people should prepare for lots of disappointment, he warns
By [|Paul Krill] | InfoWorld [|Follow @pjkrill] [|Print] | [|4 Comments]<span class="tb_btn_text">[| .] Continuing his recent mantra, Apple co-founder [|Steve Wozniak (popularly known as "Woz") has more words of caution about cloud applications], warning that users lack control over these systems. But Wozniak is no anti-cloud zealot. In fact, he supports it, but anticipates a rough road ahead for cloud users. Wozniak says the basic issue is that users don't own anything in the cloud. People can get used to a feature in the cloud and then suddenly it is gone or changes. "Anything can change instantly. The way things work, a feature can disappear, a product can disappear on the cloud," Wozniak said at a meeting of the Churchill Club business group. When signing up for cloud applications and services, users agree to all sorts of things when quickly checking off boxes in user agreements. "I'm sure I've signed away [recourse to] anything on the cloud that goes wrong. I have no recourse," Wozniak said. And that will cause users to go through waves of problems and disappointments. "We're going to have quite a few years of people not being satisfied ... [because] "it doesn't work beautifully like a trusted friend does." Despite his reservations about how the cloud is managed by providers, Wozniak endorses cloud applications. "We can't turn back the cloud. There's no way to stop it. It's so important, it has such huge advantages, it's a good thing." //This story, "[|Why Woz is unhappy with the cloud]," was originally published at [|InfoWorld.com]. Get the first word on what the important tech news really means with the [|InfoWorld Tech Watch blog]. For the latest developments in business technology news, follow InfoWorld.com on Twitter.//

Wednesday August 22nd
[] What is a Data Model?

[] Data modeling class report

List of videos from Data Modeling Class [|WWW.VTC.COM]In the find a tutorial enter Data Modeling What is Data Model?Types of Data ModelsThe Evolution of Data ModelHierarchical DatabasesNetwork DatabasesRelational DatabasesEntity Relationship Databases Table relationships: []

[]Big Data Becomes Operational!
[] Review basics here

<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; font-family: arial,sans-serif; font-size: 10.5pt;">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; font-family: arial,sans-serif; font-size: 10.5pt;">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; font-family: arial,sans-serif;">This will count as one makeup homework assignment or 5 bonus quiz points. Requirement: Write an three paragraph original review of the session.