Upgrade to Pro — share decks privately, control downloads, hide ads and more …

67-311 Data import presentation

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Adam Weis Adam Weis
November 28, 2012
Education
63
1

67-311 Data import presentation

How to import data after a database transition. Case Study: Schedule+

Avatar for Adam Weis

Adam Weis

November 28, 2012

More Decks by Adam Weis

See All by Adam Weis
dbImportPresentation.pdf
Avatar for Adam Weis aweis
1
34

Other Decks in Education

See All in Education
!コスパよくインターンに受かる方法！
Avatar for ruribou ruribou
1
350
[2026前期火５] 論理学（京都大学文学部 前期 第12回）「証明を走らせる：カリー・ハワード対応」
Avatar for Shunsuke Yatabe yatabe
0
300
[2026前期火５] 論理学（京都大学文学部 前期 第13回）「走って、止まって、積み上がる」
Avatar for Shunsuke Yatabe yatabe
0
210
Portable & Reproducible Research Environments in the Age of AI Agents
Avatar for Mai Nishimura denkiwakame
0
710
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
300
Modulo : abc
Avatar for Abraham Zamudio robintux
0
120
AIでアウトプットできる時代だからこそ、自分の言葉で考えることの大切さ / What's Left to Think, When AI Can Write?
Avatar for モブエンジニア（Masaki Okuda） masakiokuda
1
170
Center for Entrepreneurship Education | Science Tokyo (Institute of Science Tokyo)
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
350
良書紹介08_ 頭のいい子がやっているすごいグラフの読み方
Avatar for ぶんちん bunnchinn3
0
150
The Strengthening Institutions Program
Avatar for Territorium territorium
PRO
0
160
Visionary Initiative: Future Intelligence — Laying the foundations for the future of science, intelligence, and society | Science Tokyo
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
280
Throw Yourself In! - How I've learned English and What I'm Facing
Avatar for Takeshi "George" Matsuda georgeorge
1
250

Featured

See All Featured
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
1
34k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.6k
The Director’s Chair: Orchestrating AI for Truly Effective Learning
Avatar for Mike Taylor tmiket
1
290
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
Imperfection Machines: The Place of Print at Facebook
Avatar for Scott Boms scottboms
270
14k
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
Avatar for UX Y'all uxyall
1
2.7k
Claude Code どこまでも/ Claude Code Everywhere
Avatar for nwiizo nwiizo
67
58k
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
7.4k
The Language of Interfaces
Avatar for Des Traynor destraynor
162
27k
HDC tutorial
Avatar for Michiel Stock michielstock
2
840
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.6k
AI: The stuff that nobody shows you
Avatar for John Nunemaker jnunemaker
PRO
9
970

Transcript

  1. 67-311 Database Design and Implementation Adam Weis 11/11/12 Wednesday, November

    28, 12

  2. Database Redesign Case study: Wednesday, November 28, 12

  3. Database Redesign Case study: Wednesday, November 28, 12

  4. Fall 2011 Wednesday, November 28, 12

  5. Fall 2011 Wednesday, November 28, 12

  6. Wednesday, November 28, 12

  7. Spring 2013 Wednesday, November 28, 12

  8. Spring 2013 Wednesday, November 28, 12

  9. Wednesday, November 28, 12

  10. Wednesday, November 28, 12

  11. Wednesday, November 28, 12

  12. Wednesday, November 28, 12

  13. ERD - Fall 2011 Wednesday, November 28, 12

  14. ERD - Spring 2013 Wednesday, November 28, 12

  15. Overview Wednesday, November 28, 12

  16. Overview How to upgrade database design? Wednesday, November 28, 12

  17. Overview How to upgrade database design? How to import old

    data? Wednesday, November 28, 12

  18. What changed? Wednesday, November 28, 12

  19. What changed? A lot. Wednesday, November 28, 12

  20. What changed? A lot. Instructors are now a table, not

    a row in Courses Wednesday, November 28, 12

  21. What changed? A lot. Instructors are now a table, not

    a row in Courses Completely new relationships with “Group” join table Wednesday, November 28, 12

  22. What changed? A lot. Instructors are now a table, not

    a row in Courses Completely new relationships with “Group” join table etc. Wednesday, November 28, 12

  23. Migrations Wednesday, November 28, 12

  24. Migrations Awesome for database manipulation Wednesday, November 28, 12

  25. Migrations Awesome for database manipulation Bad with legacy data Wednesday,

    November 28, 12

  26. Solution Wednesday, November 28, 12

  27. Solution Write a database importer script! Wednesday, November 28, 12

  28. Solution Write a database importer script! Query both databases simultaneously

    to import legacy data into new schema! Wednesday, November 28, 12

  29. Database importer Wednesday, November 28, 12

  30. Database importer ingredients Wednesday, November 28, 12

  31. Database importer ingredients Establish a new ActiveRecord connection with old

    database Wednesday, November 28, 12

  32. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Wednesday, November 28, 12

  33. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Create the to_model methods Wednesday, November 28, 12

  34. Database importer ingredients Establish a new ActiveRecord connection with old

    database Recreate all legacy model relationships Create the to_model methods Write the driver Wednesday, November 28, 12

  35. Example Wednesday, November 28, 12

  36. Citations Wednesday, November 28, 12

  37. Citations Vincent Siao (SCS & HCI 2014) Wednesday, November 28,

    12

  38. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Wednesday, November 28, 12

  39. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Wednesday, November 28, 12

  40. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Tim Riley: http://openmonkey.com/blog/2009/05/02/ importing-legacy-data-in-rails/ Wednesday, November 28, 12

  41. Citations Vincent Siao (SCS & HCI 2014) Jason MacDonald (SCS

    2013) Steven Fackler (SCS 2013) Tim Riley: http://openmonkey.com/blog/2009/05/02/ importing-legacy-data-in-rails/ https://github.com/aweis/rails_importer/blob/master/ S13importer.rb Wednesday, November 28, 12