1 / 47

CST 221: Database Systems

CST 221: Database Systems. Dr. Zhen Jiang Computer Science Department West Chester University. Class information . Website www.cs.wcupa.edu/~zjiang/cst221index.htm. Motivation. Why computer minor/certificate?

yamal
Download Presentation

CST 221: Database Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CST 221: Database Systems Dr. Zhen Jiang Computer Science Department West Chester University

  2. Class information • Website www.cs.wcupa.edu/~zjiang/cst221index.htm

  3. Motivation • Why computer minor/certificate? • 6 among top 10 are computer related! (http://www.washingtonpost.com/business/economy/the-10-best-and-worst-jobs-of-2013/2013/05/03/fccd6a8e-b1ab-11e2-bbf2-a6f9e9d79e19_gallery.html#photo=1)

  4. Why this section? • Job hunting • WCU graduated vs. • UPenn, Temple, Drexel, … • Something help you to stand out! • How can I introduce you?

  5. Tell you what I see at Temple • Knowledge? • Communication? • Abstraction & critical thinking • Passion and motivation • I just need 3 credits • How much I need to do for getting an ‘A’ • I need to care my GPA • http://www.youtube.com/watch?v=lYtxA_IfQMk

  6. Critical thinking, abstraction, motivation • How can I obtain all these • How can I prepare myself • How can I prove myself

  7. Research project • Critical thinking, communication, etc. • Real competition, deadline, pressure • More realistic system, complex programming, for instance, http://www.cis.temple.edu/~jiang/RSU_van.pptx. • Student opportunities: http://www.cs.wcupa.edu/~zjiang/student_info.htm • Sponsorship • http://www.cs.wcupa.edu/~zjiang/ISC2013.pptx. • NSF, NSA, etc • Industry interns

  8. No pain, no gain • Happy ending • Need to handle those things coming from pressure: frustration, upset, madness, etc. • Looking for solution, not excuse. • Deadline!

  9. Deadline of assignment • Class website (including ppt)+ google search • Hands-on experience • Group discussion

  10. Topics and schedule • See syllabus Database data Query request DBMS

  11. Integration • Administration • Security & encryption • Privacy & inference • Transaction & injection • Sketching & hashing

  12. Know how simply the system works, rather than memorizing all those in the manual. • Use those generally supported phases, statements, or rules, rather than focusing on trick plays (For instance, no join operator!) • Use class design to better organize the data relationship, reducing the data vulnerability while fully maintaining all the query requirements.

  13. ACCESS -> SQL • How this GUI interface works? • Advanced SQL (nested SQL) • Who can have the control of table? • Normalization • Easy to do • Ambiguous in use for real application • Class design (UML) – alternative design • Use case • Class diagram • Multiple layer • Indirect Database • Server – MySQL • Client – JDBC

  14. API integration

  15. Databases • Relational DB • The dependency relation among data • Non-relational DB • Without such a relation • NonSQL DB • More complicate relation structure • e.g., Kobo, Playtika (mobile service) • Fast third-party data aggregation • Globally distributed data repository • E-commerce and internet burstness • Game (data intensive applications) • Ad targeting (social networks)

  16. Data information • Share the experience of data processing: Word, Power point, Excel, IE, and etc.

  17. Word • <Insert> • <Symbol> • ≥ •  • <Copy> & <Paste> • <Ctrl> <c>  <Ctrl> <v> • <PrtSc> & <Alt> <PrtSc>  <Ctrl> <v> • <Ctrl><p> Summer Training on Computer Science, WCU

  18. Power Point • <Insert> • <Date and Time> ! Summer Training on Computer Science, WCU

  19. <Slide Show> • <Custom Animation>, <Add Effect>, <Motion Path> ! Summer Training on Computer Science, WCU

  20. Excel Document resource: www.cs.wcupa.edu/~zjiang/summer07_student_grade_sample.xls. =average(c6:c28) Another well used function: SUM ! Summer Training on Computer Science, WCU

  21. <Insert> • <Chart> ! Summer Training on Computer Science, WCU

  22. <view> <freeze panes> • B2, $b$2

  23. Data input

  24. Advanced techniques (resorting to other tools, not discussed here) • Conditional formatting table, for single table data query • Templates, for multiple tables • SmartArt and Images • Macros and Visual Basic

  25. IE Summer Training on Computer Science, WCU

  26. Summer Training on Computer Science, WCU

  27. Summer Training on Computer Science, WCU

  28. Information stored in word, Excel, Powerpoint, PDF, txt (plain text), etc • Share/exchange information • PrimoPDFhttp://www.primopdf.com/index.aspx

  29. Problem • How to manage and locate the wanted information?

  30. Directory & files • Multiple descriptors/requirements  single name, single index, single data entity

  31. Database Systems & Access • Shelly, Cashman, Pratt, “Microsoft Office Access 2007 Comprehensive Concepts and Techniques”, Course Technology • Page: AC14 • Page: AC44 • Exercise 1: http://www.cs.wcupa.edu/~zjiang/cst221_lab1.doc

  32. Access • <Start>  <All program>  … <Microsoft Office Access 2007>

  33. √

  34. Creating a report • Report wizard, page AC50-AC56 • Split form, page AC57-AC59

  35. Input & Output • Page AC211

  36. Assignment 1 (see at class website)

More Related