Architectural Design and Best Practices Project Final ...

1 Architectural Design and Best Practices Project Final Report and Design Recommendations ( ) Prepared for the Virginia Department of Education February 28, 2011 Technical Point of Contact: Louis McDonald | CIO/CTO | Administrative Point of Contact: Pat Inman | Contract Manager | Delivverable Final RReport and Desiggn Recommendaations Conteents Executivve Summary .. 4 1 Intrroduction .. 6 Study Goal .. 6 Project Deliiverables .. 6 2 Research Processs .. 6 3 Keyy Messages .. 8 Stakeholderr Managemeent .. 8 Federated SSystems Perfform Poorly.

2 9 Data Governnance .. 9 Leveraging Existing Sysstems .. 10 Use of Commmercial Systtems .. 10 Multiple Haash Keys .. 11 Requiremennts and System Architeccture .. 11 Clearly Defiined Securitty Policies .. 12 4 Archhitecture Beest Practice CCase 13 Indiana Deppartment of Education .. 13 Iowa Deparrtment of Edducation .. 18 Army Suicidde Mitigatioon 20 Texas Educcation Agenccy .. 23 DLA Data CConvergencee and Qualityy Project .. 26 NORC at thhe Universitty of Chicagoo Data Enclaave .. 29 5 Subjbject Matter Expert Interrviews .. 34 Dr. Bhavanii Thuraisinghham.

3 35 Paul 36 James Camppbell .. 37 Susan Carteer .. 38 Raj Rameshh .. 40 Ron Kleinmman .. 41 Peter Dobleer .. 42 Dr. Laura HHaas .. 43 Dr. Thilini AAriyachandrra .. 44 Dr. Cynthiaa Dwork .. 45 6 SLDDS Architecture 47 Archhitectural Designn and Best Practiices Project | P age | 2 SLDS Sevenn Functionall Componentts .. 47 Portal .. 47 Securitty .. 49 Workflflow .. 50 Reportting .. 53 Lexiconn .. 56 Shakerr .. 57 Data .. 58 7 Phyysical Infrastructure .. 60 Developmennt Environmment .. 60 Test 61 Production Environmennt.

4 62 Appendixx A: Secondary Architeccture Best Prractice Case Studies .. 63 Illiinois State Board of Educcation .. 63 Noorth Dakota Departmentt of Public 65 WWashington EEducation Reesearch and Data 68 Appendixx B: Best Praactice Case SStudies Interrviewee Listt .. 70 Inddiana Departtment of Eduucation .. 70 Iowwa Departmment of Educaation .. 70 Daata Strategiess Army Suiicide Mitigaation Projectt .. 70 Teexas Education Agency .. 71 Daata Strategiess DLA Datta Convergennce and Quaality Project .. 71 NOORC Data Ennclave .. 71 Illiinois State Board of Educcation.

5 72 Noorth Dakota Departmentt of Public Innstruction .. 72 Staate of Washiington Educcation Reseaarch & Data Center .. 73 Appendixx C: Materiaals Sent to Best Practicess Intervieweees .. 74 Besst Practices interview Template .. 74 Arrchitectural Best Practice, Design & Planning Suupport Projeect Overvieww .. 76 Appendixx D: Materiaals Sent to Su ubject Matter Experts .. 77 Subbject Matterr Expert Innterview Temmplate .. 77 Virginia Statewwide Longittudinal Data System - Exxecutive Summmary .. 79 Virrginia Statewwide Longituudinal Data System - Ussage .. 82 Delivverable Final RReport and Desiggn Recommendaations Archhitectural Designn and Best Practiices Project | P age | 3 Delivverable Final RReport and Desiggn Recommenda ationsExecuutive Summary The educcational landdscape has chhanged drammatically sinnce the establishment of Statewide Longituddinal Data Syystems (SLDDS) throughoout the Unitted States.

6 AA grant progrram1 funded by the DDepartmentt of Educatioon, as authorrized by the Educationall Technical AAssistance AAct of 2002, hass helped to cchange manyy states K-122 data systemms significanntly and mayy, in fact, revolutioonize the fut ure managemment and ut implemennted these ddata systemss now have m ability too access, anallyze and utillize the data These successes, howwever, have bbeen achieve and assidduous implemmentations. In 2010, tthe Virginia Departmentt of Educatio enhance its statewidde data systemm, and launc Project . TThe Project team was chharged with stakeholdders; additioonally, the teeam faced ch ility of educational dataa.

7 States thatt have more accuratte and robus t data and ann enhanced a in a mannerr previously unavailablee in the past. ed only throuugh rigorouss planning, mmeticulous ddesign, on (VDOE) wwas awardedd a federal mmulti-year grrant to ched the Virrginia Longittudinal Dataa System (VLLDS) creating a syystem that wwill address the needs off all hallenging Feederal and VVirginia secu rity and privvacy requiremments. To meeet these chaallenges, VDOOE commisssioned the CCenter for Innnovative Technoloogy (CIT) too identify keyy success fac of a fully secure and pprivate, as wwell as more In order tto achieve thhis complex objective, th integration projects iin state educcation agenc industriees.

8 The team examined ppublished infanalysis wwas performmed on these reports and areas whhere further rresearch musst be conduc leaders and a numberr of industryy leaders wh interviewws provided the foundatiion for the c were esseential to thee success of eeach of these Informattion collectedd during thee research an themes aand these theemes were orrganized int report. TThis process rrevealed sevveral key elem implemenntations. Thhe primary thhemes that e detailed pproject plannning and maanagement ( managemment) as welll as the needd to conduct implemennting the tecchnology and creating th solutionss and leveragging existingg systems).

9 Ctors that coould provide guidance inn the developpment efficient, SLLDS in Virginnia. he CIT projeect team inveestigated othher large datta cies, other goovernmentall agencies annd in other formation from a varietyy of sources, and a gap d articles to iidentify misssing informaation and criitical cted. In addiition, the teaam interviewwed nine SLDDS ho managed llarge integraation projectts. These compilation oof best practtices and keyy takeawayss that e projects. nd analysis pphase was annalyzed to iddentify commmon to a set of beest Practices that were inncluded in a Final ments2 that wwere cruciall to ensuringg successful emerged inclluded, amonng others, thee necessity foor (the importaance of data ggovernance aand stakehoolder t comprehennsive researchh and planniing before he system arrchitecture ((the use of coommercial 1 The Stateewide Longituddinal Data Systtems (SLDS) Grrant Program 2 The Final report includeed challenges aand obstacles tto be avoided and provided rrecommendatiions for a nummber of preliminary action itemms.)))

10 In addition,, the report coontained a suppplement that inncluded the coomplete reportts with detailed findings for eaach interview aand data proje ct Archhitectural Designn and Best Practiices Project | P aag e | 4 Delivverable Final RReport and Desiggn Recommendaations The CIT Project teamm, along withh VLDS subjject matter eexperts, tookk the originaal conceptuaal SLDS arcchitecture annd incorporaated results f expert innterviews to develop an iimplementat 6) expannded the detaails for functtional compo would bee managed ggiven knownn constraints information, and the necessary wworkflows to deployment.