学习可配置连接.ppsx

1、Leaning into Configurable JoinsAdam GrossWashington and Lee UniversityAlisa LoughlinWashington and Lee UniversityElodie HardtUniversity of RichmondTom NicholasUniversity of RichmondLeaning into Configurable JoinsAdam Gross,director of admissions operationsAlisa Loughlin,assistant director of admissi

2、ons information systemsWashington and Lee UniversityFounded 1749Rural,Highly Selective Liberal ArtsCommon App,QuestBridge,Coalition for College member1,857 Undergraduate Enrollment49 States,41 CountriesTop producer of Fulbright students in the U.S.W&L prepares students to meet the worlds challenges

3、as ethical leaders,visionary thinkers and compassionate citizens.Washington and Lee UniversityLive in Slate in 2012Rural,Highly Selective Liberal ArtsCommon App,QuestBridge,Coalition for College member1,857 Undergraduate Enrollment49 States,41 CountriesTop producer of Fulbright students in the U.S.W

4、&L prepares students to meet the worlds challenges as ethical leaders,visionary thinkers and compassionate citizens.What is a join and why is it configurable now?Slate is a relational database,information is stored in many different tablesLocal bases did the work for us previouslyIsnt it all just Sl

5、ate?Imagine a Food Court,all the restaurants(Slate tables)are in the same place in the Food Court(Slate),but they are separate entities.You can get a Big Mac and a Whopper bring them back to your seat(your new CJ query),but it is going to take a couple of steps.In other words,you can get your Whoppe

6、r and your Big Mac at the Food Court,but it is going to take a couple of steps by going to both McDonalds and Burger King.Food CourtMcDonaldsBurger KingMcDonalds Big MacBurger King WhopperWhat do you mean different tables?Choosing your baseCategoryRecordsRelatedSystemMost common choiceAssociated thi