可配置连接：回到未来 - 从基础到构建用户门户.ppsx

1、Configurable Joins:Back to the Future From the Basics to Building User PortalsVinnie RodriguezDynamic Campus IncCory TardieClarkson UniversityGetting Started with Configurable Joins Building Bridges to Easy WinsVinnie RodriguezSlate AnalystDynamic CampusWho Am I?-Worked in Slate for 5 years-Graduate

2、 Online at Jacksonville University-Undergrad at JU-Consulting with Dynamic CampusA Walk Down Memory LaneA quick look at local query basesA Quick Look at Local Query BasesA Quick Look at Local Query BasesProspectsProspects(Include opt-outs)ApplicationsProspects and ApplicantsPersons(remove opt-out ta

3、gged)PersonsApplicationsPersons(Joined to Rank 1 App)But First.Some requisite knowledge for Configurable Joins to make sense.One-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-OneOne-to-Many vs One-to-One

4、Bridging IslandsWhat even is a join anyway?But How?Application AtollBridging IslandsApplication Atoll-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging IslandsYou Are HerePerson IslandApplication Atoll-Major-Start Term-Disciplinary History-Campus-Submission

5、 Status-Fails-Checklist ItemsBridging IslandsYou Are HerePerson IslandApplication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging I

6、slandsYou Are HerePerson IslandApplication Atoll-Name-Email-Birthdate-Sex at Birth-Citizenship-Visa Status-Religion-SSN-Anticipated Major-Coffee Preference-Shirt Size-Major-Start Term-Disciplinary History-Campus-Submission Status-Fails-Checklist ItemsBridging IslandsJoin!You Are HerePerson IslandApp