Search.setIndex({"docnames": ["01ModelingIntro/ModelingIntro", "01ModelingIntro/toctree", "02OneEntityShapes/OneEntityShapes", "02OneEntityShapes/toctree", "03TwoEntityShapes/AllInOne", "03TwoEntityShapes/TwoEntityShapes", "03TwoEntityShapes/be-be_Shapes", "03TwoEntityShapes/toctree", "04ThreeEntityShapes/IntersectionArbitraryId", "04ThreeEntityShapes/IntersectionShape", "04ThreeEntityShapes/toctree", "05IntroQuerying/00MasteringIntro", "05IntroQuerying/01Queying_Analysis", "05IntroQuerying/temp", "05IntroQuerying/toctree", "06Relations/00Definitions", "06Relations/01Connections", "06Relations/toctree", "07OperatorFramework/00Relations", "07OperatorFramework/01Operators_Charts", "07OperatorFramework/toctree", "08TinyDB/00creatureDBOverview", "08TinyDB/toctree", "09UnaryOps/00UnaryIntro", "09UnaryOps/01Filter", "09UnaryOps/02Project", "09UnaryOps/03Reduce", "09UnaryOps/04Group", "09UnaryOps/05UnaryFramework", "09UnaryOps/06UnaryExercises", "09UnaryOps/toctree", "10QueriesAfterUnary/00UnaryCombos", "10QueriesAfterUnary/toctree", "11SetOps/00SetIntro", "11SetOps/01UnionIntersectMinusSimple", "11SetOps/02UnionIntersectMinusAdvanced", "11SetOps/03Times", "11SetOps/04SetOpsFramework", "11SetOps/toctree", "12QueryAfterSet/00TimesFilterReduceEx", "12QueryAfterSet/toctree", "13MatchJoin/00MJIntro", "13MatchJoin/01Circumstances", "13MatchJoin/02TableOfCircumstances", "13MatchJoin/03DifferentBase_M_1_1", "13MatchJoin/04DifferentBase_M_1_2", "13MatchJoin/05DifferentBase_M_1_3", "13MatchJoin/06DifferentBase_M_M", "13MatchJoin/07SameBase_1_1_M_M", "13MatchJoin/08SameBase_1_1_E_E", "13MatchJoin/09SameBase_1_1", "13MatchJoin/10SameRelation_M_1", "13MatchJoin/11SameRelation_M_M", "13MatchJoin/12MatchJoinFramework", "13MatchJoin/toctree", "14OuterJoin/01OuterJoin", "14OuterJoin/02OJGeneric", "14OuterJoin/NotUsedOJTesting", "14OuterJoin/toctree", "15Divide/01Divide", "15Divide/NotUsedDivide_testing", "15Divide/toctree", "16CompareJoin/01CompareJoin", "16CompareJoin/toctree", "17CategoryRelations/01CategoryRelations", "17CategoryRelations/toctree", "WaysOfWork_under_construction/00WW_Intro", "WaysOfWork_under_construction/01Narratives", "index"], "filenames": ["01ModelingIntro/ModelingIntro.rst", "01ModelingIntro/toctree.rst", "02OneEntityShapes/OneEntityShapes.rst", "02OneEntityShapes/toctree.rst", "03TwoEntityShapes/AllInOne.rst", "03TwoEntityShapes/TwoEntityShapes.rst", "03TwoEntityShapes/be-be_Shapes.rst", "03TwoEntityShapes/toctree.rst", "04ThreeEntityShapes/IntersectionArbitraryId.rst", "04ThreeEntityShapes/IntersectionShape.rst", "04ThreeEntityShapes/toctree.rst", "05IntroQuerying/00MasteringIntro.rst", "05IntroQuerying/01Queying_Analysis.rst", "05IntroQuerying/temp.rst", "05IntroQuerying/toctree.rst", "06Relations/00Definitions.rst", "06Relations/01Connections.rst", "06Relations/toctree.rst", "07OperatorFramework/00Relations.rst", "07OperatorFramework/01Operators_Charts.rst", "07OperatorFramework/toctree.rst", "08TinyDB/00creatureDBOverview.rst", "08TinyDB/toctree.rst", "09UnaryOps/00UnaryIntro.rst", "09UnaryOps/01Filter.rst", "09UnaryOps/02Project.rst", "09UnaryOps/03Reduce.rst", "09UnaryOps/04Group.rst", "09UnaryOps/05UnaryFramework.rst", "09UnaryOps/06UnaryExercises.rst", "09UnaryOps/toctree.rst", "10QueriesAfterUnary/00UnaryCombos.rst", "10QueriesAfterUnary/toctree.rst", "11SetOps/00SetIntro.rst", "11SetOps/01UnionIntersectMinusSimple.rst", "11SetOps/02UnionIntersectMinusAdvanced.rst", "11SetOps/03Times.rst", "11SetOps/04SetOpsFramework.rst", "11SetOps/toctree.rst", "12QueryAfterSet/00TimesFilterReduceEx.rst", "12QueryAfterSet/toctree.rst", "13MatchJoin/00MJIntro.rst", "13MatchJoin/01Circumstances.rst", "13MatchJoin/02TableOfCircumstances.rst", "13MatchJoin/03DifferentBase_M_1_1.rst", "13MatchJoin/04DifferentBase_M_1_2.rst", "13MatchJoin/05DifferentBase_M_1_3.rst", "13MatchJoin/06DifferentBase_M_M.rst", "13MatchJoin/07SameBase_1_1_M_M.rst", "13MatchJoin/08SameBase_1_1_E_E.rst", "13MatchJoin/09SameBase_1_1.rst", "13MatchJoin/10SameRelation_M_1.rst", "13MatchJoin/11SameRelation_M_M.rst", "13MatchJoin/12MatchJoinFramework.rst", "13MatchJoin/toctree.rst", "14OuterJoin/01OuterJoin.rst", "14OuterJoin/02OJGeneric.rst", "14OuterJoin/NotUsedOJTesting.rst", "14OuterJoin/toctree.rst", "15Divide/01Divide.rst", "15Divide/NotUsedDivide_testing.rst", "15Divide/toctree.rst", "16CompareJoin/01CompareJoin.rst", "16CompareJoin/toctree.rst", "17CategoryRelations/01CategoryRelations.rst", "17CategoryRelations/toctree.rst", "WaysOfWork_under_construction/00WW_Intro.rst", "WaysOfWork_under_construction/01Narratives.rst", "index.rst"], "titles": ["<span class=\"section-number\">1.1. </span>Brief Background of Conceptual Data Modeling", "<span class=\"section-number\">1. </span>Beyond Conceptual Data Modeling", "<span class=\"section-number\">2.1. </span>One-entity shapes: begin to consider \u2018how\u2019", "<span class=\"section-number\">2. </span>From model to instances: One-entity shapes", "<span class=\"section-number\">3.7. </span>What we have seen so far", "<span class=\"section-number\">3.1. </span>Implementing Two-entity Shapes in relational databases", "<span class=\"section-number\">3.8. </span>One-One to-be relationship Shape", "<span class=\"section-number\">3. </span>Implementing relationships: Two-entity shapes", "<span class=\"section-number\">4.2. </span>The Chicken-feet-in Shape: an intersection with arbitrary identifier", "<span class=\"section-number\">4.1. </span>The Chicken-feet-in Shape: implementing an intersection", "<span class=\"section-number\">4. </span>Implementing relationships: Three-entity shapes", "<span class=\"section-number\">5.1. </span>Mastering relational data analysis", "<span class=\"section-number\">5.4. </span>What We Mean by Querying and Analysis", "&lt;no title&gt;", "<span class=\"section-number\">5. </span>Relational Databases, Querying, and Analysis", "<span class=\"section-number\">6.1. </span>The Essence of Relational Databases", "<span class=\"section-number\">6.2. </span>Connections between Relations", "<span class=\"section-number\">6. </span>Relational Data", "<span class=\"section-number\">7.1. </span>Relations as input and output", "<span class=\"section-number\">7.2. </span>Precedence Charts", "<span class=\"section-number\">7. </span>Relational Operations and Precedence Charts", "<span class=\"section-number\">8.1. </span>A small example database", "<span class=\"section-number\">8. </span>A Small Example Database", "<span class=\"section-number\">9.1. </span>Unary Operator Introduction", "<span class=\"section-number\">9.2. </span>Filter", "<span class=\"section-number\">9.3. </span>Project", "<span class=\"section-number\">9.4. </span>Reduce", "<span class=\"section-number\">9.5. </span>Group", "<span class=\"section-number\">9.6. </span>Summary of Unary Operators", "<span class=\"section-number\">9.7. </span>Exercises for Unary Operators", "<span class=\"section-number\">9. </span>The Unary Operators", "<span class=\"section-number\">10.1. </span>Combination Queries to Consider After Unary Operators", "<span class=\"section-number\">10. </span>Combining the Unary Operators", "<span class=\"section-number\">11.1. </span>Introduction to the Binary Set Operations", "<span class=\"section-number\">11.2. </span>Simplest Examples of Union, Intersect, and Minus", "<span class=\"section-number\">11.3. </span>Complex Examples of Union, Intersect, and Minus", "<span class=\"section-number\">11.4. </span>Times", "<span class=\"section-number\">11.5. </span>Summary of Binary Set Operators", "<span class=\"section-number\">11. </span>The Binary Set Operators", "<span class=\"section-number\">12.1. </span>An often-used Combination", "<span class=\"section-number\">12. </span>Putting pieces together", "<span class=\"section-number\">13.1. </span>Introduction to Match Join", "<span class=\"section-number\">13.2. </span>Circumstances For Match Joins", "<span class=\"section-number\">13.3. </span>The Common Circumstances", "<span class=\"section-number\">13.4. </span>Different Base A and B, M - 1 match over cols Aid(D), Bid(E)", "<span class=\"section-number\">13.5. </span>Different Base A and B, M - 1 match over cols Aid(D),Bid(M)", "<span class=\"section-number\">13.6. </span>Different Base A and B, M - 1 match over cols Aid(S),Bid(E)", "<span class=\"section-number\">13.7. </span>Different Base A and B, M - M match over cols Aid(D),Bid(D)", "<span class=\"section-number\">13.8. </span>Same Base A and B, 1 - 1 match over cols Aid(M),Bid(M)", "<span class=\"section-number\">13.9. </span>Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)", "<span class=\"section-number\">13.10. </span>Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)", "<span class=\"section-number\">13.11. </span>Same Relation A and B, M - 1 match over cols Aid(D),Bid(E)", "<span class=\"section-number\">13.12. </span>Same Relation A and B, M - M match over cols Aid(D),Bid(D)", "<span class=\"section-number\">13.13. </span>Match Join Framework", "<span class=\"section-number\">13. </span>The Match Join Operator", "<span class=\"section-number\">14.1. </span>Outer Join by Examples", "<span class=\"section-number\">14.2. </span>A Generic Version of OuterJoin", "Test of Outer Join", "<span class=\"section-number\">14. </span>The Outer Join Operator", "<span class=\"section-number\">15.1. </span>Divide Operator: two types", "Joe Celko\u2019s page examples", "<span class=\"section-number\">15. </span>The Divide Operator", "<span class=\"section-number\">16.1. </span>A Variation: Compare Join", "<span class=\"section-number\">16. </span>Compare Join", "<span class=\"section-number\">17.1. </span>Category Relations", "<span class=\"section-number\">17. </span>Category Relations", "Ways of Work", "Ways of Forming Query Narratives", "Mastering Relational Databases: from Models to Querying"], "terms": {"modelingintro": 0, "what": [0, 2, 5, 7, 8, 9, 11, 14, 15, 16, 19, 20, 21, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 50, 51, 53, 55, 59, 64, 66, 67], "Not": [0, 34], "how": [0, 3, 5, 6, 8, 9, 11, 12, 16, 18, 19, 21, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 39, 41, 43, 46, 48, 49, 51, 52, 54, 55, 59, 62, 64, 66, 67, 68], "The": [0, 2, 10, 11, 14, 16, 18, 19, 21, 23, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 39, 42, 44, 45, 46, 47, 48, 49, 50, 53, 55, 56, 59, 62, 64, 66, 68], "most": [0, 5, 12, 15, 26, 31, 33, 35, 39, 41, 42, 45, 55, 59, 64, 68], "import": [0, 8, 9, 11, 15, 21, 24, 26, 27, 31, 34, 36, 38, 41, 42, 45, 49, 50, 55, 59, 64, 67], "aspect": [0, 2, 12, 33, 36, 41, 53, 54, 62, 67], "rememb": [0, 5, 6, 8, 9, 12, 15, 23, 25, 27, 29, 31, 42, 44], "about": [0, 2, 5, 7, 9, 11, 12, 15, 18, 21, 27, 29, 30, 31, 34, 35, 38, 41, 42, 43, 46, 48, 49, 59, 62, 64, 66, 68], "i": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 19, 20, 21, 23, 24, 25, 28, 29, 30, 31, 33, 34, 35, 37, 38, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 59, 62, 64, 66, 67], "thei": [0, 9, 11, 12, 15, 16, 23, 24, 26, 29, 33, 35, 37, 39, 41, 42, 45, 46, 48, 49, 50, 55, 59, 62, 64, 66, 67], "ar": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 27, 29, 30, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 53, 55, 56, 59, 62, 64, 66, 67, 68], "graphic": [0, 12, 68], "diagram": [0, 2, 14, 15, 21, 23, 24, 26, 31, 44, 56, 68], "depict": [0, 8, 9, 15, 19, 62], "someon": [0, 24], "want": [0, 2, 5, 6, 9, 12, 15, 24, 25, 26, 27, 31, 33, 41, 42, 48, 50, 55, 59, 62, 64, 66, 68], "store": [0, 8, 11, 12, 55, 68], "databas": [0, 2, 7, 8, 9, 11, 12, 16, 17, 18, 24, 25, 26, 31, 33, 35, 36, 41, 42, 43, 44, 45, 46, 48, 49, 50, 55, 64, 66, 67], "later": [0, 2, 5, 6, 11, 12, 15, 16, 18, 19, 23, 24, 27, 36, 39, 41, 55, 59, 66, 68], "analysi": [0, 15, 21, 59, 64, 66, 68], "do": [0, 2, 5, 6, 11, 12, 15, 18, 19, 21, 23, 24, 25, 26, 29, 31, 33, 35, 37, 39, 42, 43, 44, 48, 49, 50, 51, 55, 59, 66, 68], "indic": [0, 5, 6, 9, 15, 18, 24, 29, 33, 34, 35, 37, 41, 42, 46], "therefor": [0, 18, 19, 31, 41, 44, 48, 50, 51, 68], "abstract": [0, 2, 54], "level": [0, 12, 16, 35, 64, 66, 67], "detail": [0, 2, 5, 11, 12, 15, 24, 39, 41, 43, 44, 53, 59, 68], "underli": [0, 36, 62, 64], "thi": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 27, 28, 29, 30, 31, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 55, 56, 59, 62, 64, 66, 67], "book": [0, 11, 12, 15, 18, 19, 21, 24, 31, 36, 49, 55, 59, 62], "fragment": [0, 8, 9, 19, 21, 44, 45, 46, 47, 49, 51, 53, 55], "veri": [0, 19, 24, 33, 34, 36, 39, 41, 55, 59, 64, 66], "simpl": [0, 11, 12, 15, 19, 25, 26, 27, 31, 33, 34, 35, 36, 59, 68], "us": [0, 2, 5, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 28, 29, 32, 33, 34, 36, 37, 38, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 52, 53, 55, 56, 59, 62, 64, 66, 67, 68], "logic": [0, 24, 36, 44, 45, 46, 68], "structur": [0, 11, 12, 15, 18, 24, 25, 26, 27, 33, 36, 68], "ld": [0, 5, 46, 47, 49, 55, 68], "notat": [0, 2, 12, 68], "present": [0, 2, 12, 24, 31, 33, 36, 43, 44, 53, 59, 66, 68], "master": [0, 2, 12, 14, 15, 21, 25, 27, 29, 44, 59, 62, 66], "A": [0, 9, 11, 12, 15, 16, 18, 19, 25, 26, 27, 29, 30, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 54, 58, 59, 63, 64, 68], "user": [0, 2, 8, 11, 12, 15, 16, 25, 66, 67, 68], "driven": [0, 68], "approach": [0, 68], "john": [0, 68], "carli": [0, 2, 12, 21, 24, 25, 26, 27, 31, 42, 55, 68], "joseph": [0, 68], "maguir": [0, 2, 68], "addison": [0, 68], "weslei": [0, 68], "profession": [0, 2, 11, 68], "2000": [0, 68], "isbn": [0, 68], "9780134176536": [0, 68], "an": [0, 2, 5, 6, 10, 11, 12, 15, 16, 18, 19, 24, 26, 27, 29, 31, 33, 35, 36, 37, 38, 40, 42, 44, 45, 48, 49, 50, 52, 54, 55, 56, 59, 62, 64, 66, 67, 68], "excel": [0, 64], "tool": [0, 14, 23, 24, 34, 35, 36, 62], "end": [0, 5, 6, 14, 19, 24, 31, 36, 42, 44, 45, 46, 55, 56, 59], "so": [0, 2, 5, 7, 8, 9, 11, 12, 15, 18, 19, 23, 24, 25, 26, 27, 29, 31, 33, 36, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 55, 59, 62, 64, 66], "you": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 53, 55, 59, 62, 64, 66, 67, 68], "get": [0, 2, 5, 12, 16, 18, 24, 25, 26, 27, 31, 34, 35, 39, 42, 50, 52, 55, 59, 62, 64, 66, 68], "essenc": [0, 17, 62], "have": [0, 2, 5, 6, 7, 8, 9, 11, 12, 15, 16, 18, 19, 21, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 53, 55, 56, 59, 62, 64, 66, 68], "without": [0, 31, 62], "worri": [0, 24], "when": [0, 2, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 44, 45, 49, 50, 51, 53, 55, 56, 59, 62, 66, 67, 68], "we": [0, 2, 5, 6, 7, 8, 9, 11, 14, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 59, 64, 66, 67, 68], "avoid": [0, 12, 26, 27, 32], "think": [0, 12, 15, 18, 19, 21, 25, 27, 30, 35, 37, 42, 43, 46, 48, 62, 64, 66, 68], "much": [0, 2, 11, 12, 15, 18, 24, 27, 31, 39, 41, 59, 62, 64], "possibl": [0, 2, 8, 25, 29, 31, 36, 39, 46, 56, 62, 64, 68], "howev": [0, 2, 6, 11, 12, 16, 27, 31, 33, 36, 44, 49, 50, 55, 59, 64, 66], "know": [0, 2, 5, 6, 12, 18, 25, 26, 29, 31, 39, 42, 44, 46, 48, 51, 59, 67], "bit": [0, 8, 29, 35, 44, 48, 62], "relat": [0, 2, 7, 19, 21, 23, 24, 25, 27, 29, 31, 33, 34, 35, 37, 38, 39, 42, 43, 44, 45, 46, 47, 48, 49, 50, 54, 55, 56, 59, 62, 66], "help": [0, 2, 11, 12, 18, 23, 24, 26, 31, 33, 34, 35, 39, 42, 44, 46, 48, 64, 68], "see": [0, 2, 6, 11, 12, 15, 16, 18, 19, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 42, 44, 47, 48, 51, 55, 59, 62, 64, 66, 67, 68], "why": [0, 11, 15, 18, 25, 26, 27, 29, 31, 33, 36, 37, 41, 44, 46, 48, 51, 59], "mani": [0, 6, 8, 9, 11, 12, 16, 26, 27, 29, 31, 36, 39, 41, 42, 44, 46, 50, 51, 55, 56, 59, 62, 64, 66, 68], "guidelin": [0, 18], "suggest": [0, 19, 23, 25, 29, 31, 41, 47, 68], "abov": [0, 2, 5, 6, 8, 9, 12, 15, 18, 19, 21, 23, 24, 25, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 44, 45, 46, 47, 50, 51, 55, 59, 62, 64], "becom": [0, 12, 15, 18, 26, 27, 36, 41, 42, 44, 46, 50, 55], "good": [0, 12, 18, 24, 29, 31, 42, 44, 59, 64, 68], "practic": [0, 2, 11, 14, 18, 21, 24, 25, 26, 27, 28, 29, 32, 33, 34, 35, 37, 39, 41, 44, 46, 59, 62, 68], "creat": [0, 2, 6, 7, 8, 9, 11, 12, 16, 18, 21, 24, 31, 33, 34, 35, 36, 39, 41, 43, 44, 45, 47, 48, 49, 50, 52, 55, 59, 62, 64, 68], "make": [0, 2, 5, 9, 11, 12, 19, 21, 23, 24, 25, 26, 29, 31, 34, 35, 39, 42, 44, 45, 46, 47, 48, 50, 51, 55, 59, 66, 68], "easi": [0, 15, 19, 24, 27, 33, 55], "directli": [0, 15], "its": [0, 5, 9, 11, 12, 15, 18, 24, 25, 26, 27, 29, 36, 41, 42, 43, 44, 45, 46, 49, 50, 51, 52, 53, 55, 59, 62, 64, 66, 68], "associ": [0, 8, 59], "sampl": [0, 5, 21], "instanc": [0, 6, 7, 8, 9, 11, 12, 15, 16, 18, 21, 24, 33, 35, 50, 55, 68], "obtain": [0, 11, 33, 39, 41, 46, 47, 55], "work": [0, 2, 8, 11, 12, 15, 18, 19, 21, 23, 24, 26, 27, 28, 32, 33, 34, 36, 37, 43, 44, 45, 46, 47, 48, 49, 50, 55, 59, 64, 67, 68], "In": [0, 5, 6, 8, 9, 11, 15, 16, 21, 23, 24, 25, 26, 27, 29, 31, 34, 35, 36, 39, 41, 44, 45, 48, 49, 50, 51, 52, 55, 59, 62, 64, 66, 67, 68], "first": [0, 2, 9, 11, 15, 18, 19, 24, 25, 26, 27, 29, 32, 33, 34, 35, 36, 39, 41, 42, 43, 44, 45, 46, 50, 51, 52, 53, 56, 58, 59, 62, 64, 66, 67, 68], "part": [0, 8, 11, 12, 15, 18, 42, 45, 59], "start": [0, 2, 8, 18, 19, 21, 23, 24, 25, 31, 33, 34, 36, 41, 46, 48, 59, 62, 64, 66, 68], "practition": [0, 36], "learn": [0, 11, 12, 15, 18, 19, 21, 27, 36, 44, 59, 68], "task": [0, 12, 67, 68], "next": [0, 2, 6, 8, 9, 11, 15, 18, 19, 21, 24, 25, 29, 31, 33, 34, 36, 41, 42, 44, 46, 51, 55, 59, 67], "few": [0, 9, 11, 15, 27, 29, 31, 42, 46, 55, 59], "chapter": [0, 2, 4, 15, 16, 21, 23, 24, 28, 31, 33, 34, 35, 36, 37, 41, 48, 51, 52, 55, 62, 64, 66, 68], "intend": [0, 68], "companion": 0, "one": [0, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 29, 30, 31, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 55, 56, 59, 64], "like": [0, 2, 4, 5, 9, 12, 15, 18, 19, 23, 24, 25, 26, 29, 30, 31, 33, 34, 35, 36, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 55, 56, 59, 64, 67], "which": [0, 5, 6, 8, 11, 12, 15, 18, 21, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 43, 44, 46, 47, 49, 50, 51, 53, 55, 56, 59, 62, 64, 66, 68], "likewis": [0, 15], "step": [0, 2, 25, 31, 36, 42, 46, 48, 50, 56, 59, 64], "stone": 0, "2": [0, 2, 6, 11, 15, 18, 21, 24, 25, 26, 29, 30, 31, 35, 37, 38, 39, 41, 42, 44, 45, 46, 55, 59, 62, 64, 67], "where": [0, 8, 11, 12, 19, 24, 26, 27, 31, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 52, 55, 56, 59, 62, 64, 66], "examin": [0, 2, 5, 9, 12, 21, 31, 34, 35, 41, 42, 47, 59, 64, 66, 67], "extract": [0, 11, 66], "inform": [0, 33, 42, 52, 55, 65], "been": [0, 5, 11, 12, 26, 31, 34, 41, 50, 55, 59, 62, 68], "abl": [0, 12, 31, 44, 45, 48, 53, 64, 66, 68], "toctre": [1, 3, 7, 10, 14, 17, 20, 22, 30, 32, 38, 40, 54, 58, 61, 63, 65], "brief": [1, 39, 41, 64], "background": [1, 11], "transit": 1, "from": [1, 2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 44, 46, 47, 48, 49, 51, 52, 53, 55, 56, 59, 62, 64, 66, 67], "implement": [1, 2, 6, 18, 24, 47, 48, 49, 59, 66, 68], "oneentityshap": 2, "conceptu": [2, 5, 8, 9, 16, 18, 21, 41, 42, 43, 44, 45, 47, 49, 51, 53, 55], "model": [2, 5, 8, 9, 16, 18, 41, 47, 59], "design": [2, 11, 68], "can": [2, 4, 5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 55, 56, 59, 64, 66, 67, 68], "awai": [2, 25, 41], "concentr": [2, 41, 51, 68], "need": [2, 6, 8, 11, 12, 15, 18, 19, 23, 24, 26, 31, 33, 34, 35, 39, 41, 42, 44, 47, 51, 59, 62, 66, 67], "repres": [2, 6, 8, 9, 15, 21, 25, 26, 35, 36, 42, 45, 46, 48, 55, 59, 67], "As": [2, 6, 11, 12, 18, 21, 23, 24, 25, 27, 31, 36, 41, 42, 47, 55, 56, 59, 66, 68], "after": [2, 4, 8, 9, 11, 12, 24, 25, 26, 27, 29, 32, 39, 42, 45, 50, 55, 59, 67, 68], "your": [2, 11, 12, 15, 18, 19, 21, 23, 24, 25, 26, 28, 29, 31, 33, 35, 36, 37, 39, 41, 42, 46, 48, 59, 62, 66, 67, 68], "studi": [2, 12, 21, 25, 27, 34, 36, 39, 42, 46, 55, 59], "some": [2, 5, 7, 8, 9, 11, 12, 15, 16, 18, 21, 23, 24, 26, 27, 29, 30, 31, 33, 34, 36, 38, 39, 41, 42, 43, 44, 46, 48, 49, 53, 56, 59, 62, 64, 66, 68], "reason": [2, 12, 26, 29, 31, 33, 48, 55, 62, 66], "record": [2, 12, 15, 67], "match": [2, 18, 21, 24, 29, 33, 35, 36, 39, 55, 56, 62, 64, 68], "sql": [2, 4, 6, 9, 11, 14, 16, 21, 24, 25, 26, 27, 29, 32, 33, 34, 35, 36, 39, 42, 44, 45, 46, 47, 48, 49, 50, 51, 55, 59, 62, 64], "here": [2, 4, 5, 8, 9, 11, 12, 13, 15, 16, 18, 21, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 39, 41, 42, 44, 47, 48, 49, 52, 55, 56, 59, 62, 64, 68], "normal": [2, 55, 56, 64], "share": [2, 11, 44, 59], "more": [2, 4, 5, 8, 11, 12, 13, 15, 16, 18, 19, 21, 23, 24, 25, 26, 29, 31, 33, 34, 35, 36, 41, 42, 44, 45, 46, 47, 48, 50, 53, 55, 61, 62, 64, 66, 68], "them": [2, 8, 9, 11, 12, 21, 23, 24, 26, 27, 29, 31, 33, 35, 37, 39, 41, 43, 44, 46, 48, 53, 62, 64, 66, 68], "becaus": [2, 6, 8, 11, 12, 18, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 55, 56, 59, 62, 64, 68], "hide": [2, 29], "reveal": [2, 29], "anoth": [2, 6, 8, 12, 16, 23, 26, 31, 34, 38, 39, 45, 46, 50, 55, 59, 62, 64, 68], "least": [2, 11, 15, 29, 31, 42, 56, 61], "both": [2, 9, 11, 12, 15, 16, 21, 24, 31, 33, 35, 41, 42, 49, 58, 59, 62, 66], "underneath": 2, "separ": [2, 6, 9, 16, 25, 26, 39, 55], "client": [2, 29, 31, 64, 67], "let": [2, 5, 6, 8, 9, 15, 18, 21, 23, 24, 25, 27, 29, 30, 31, 34, 35, 36, 41, 42, 45, 46, 48, 50, 51, 52, 55, 59, 62, 64], "": [2, 5, 6, 8, 9, 11, 12, 15, 18, 19, 21, 23, 24, 25, 27, 29, 30, 31, 34, 35, 36, 37, 39, 41, 42, 43, 44, 45, 47, 48, 50, 51, 52, 53, 54, 55, 59, 62, 64, 66], "singl": [2, 5, 11, 12, 16, 27, 31, 34, 35, 39, 41, 50, 51, 59], "If": [2, 12, 18, 21, 24, 26, 27, 29, 31, 34, 37, 41, 42, 44, 50, 55, 59, 62, 68], "read": [2, 9, 12, 15, 19, 21, 25, 27, 29, 33, 39, 42, 68], "should": [2, 5, 6, 9, 12, 15, 18, 21, 24, 25, 26, 27, 28, 29, 31, 34, 37, 42, 44, 46, 49, 55, 59, 66, 67, 68], "familiar": [2, 21, 31, 33, 46, 67], "yet": [2, 5, 11, 24, 26, 31, 35, 36, 37, 44, 47, 55, 59], "slightli": [2, 31, 36, 45, 46, 59, 62], "differ": [2, 6, 8, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 29, 31, 33, 35, 37, 39, 41, 42, 43, 48, 54, 55, 59, 62, 64, 67, 68], "now": [2, 5, 9, 12, 18, 21, 23, 24, 26, 27, 29, 34, 35, 36, 37, 42, 44, 45, 46, 47, 48, 50, 52, 55, 56, 59, 62, 64], "spot": [2, 31, 44], "doe": [2, 5, 8, 14, 15, 16, 18, 23, 24, 29, 33, 35, 36, 37, 39, 55, 59, 62, 66], "tell": [2, 47], "u": [2, 5, 6, 9, 18, 23, 25, 26, 27, 29, 31, 34, 36, 39, 41, 42, 44, 45, 46, 47, 55, 64], "type": [2, 8, 9, 11, 12, 15, 16, 18, 21, 24, 27, 33, 34, 35, 36, 41, 44, 48, 49, 55, 61, 64, 67], "each": [2, 5, 8, 9, 12, 15, 16, 18, 19, 21, 23, 24, 25, 26, 27, 28, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 46, 47, 48, 49, 51, 52, 55, 59, 62, 64, 67], "attribut": [2, 5, 6, 8, 9, 15, 27, 29], "would": [2, 4, 5, 6, 9, 15, 19, 24, 26, 27, 29, 31, 41, 44, 45, 50, 55, 59, 62, 64, 67, 68], "look": [2, 5, 6, 8, 9, 12, 19, 23, 24, 25, 26, 27, 31, 35, 36, 41, 42, 44, 45, 46, 48, 49, 50, 51, 52, 53, 55, 59, 62, 67, 68], "explor": [2, 21, 41], "creatureid": [2, 9, 11, 12, 16, 18, 21, 24, 25, 26, 27, 29, 31, 34, 35, 39, 42, 44, 45, 46, 47, 48, 50, 51, 55, 59, 62, 64], "creaturenam": [2, 16, 21, 24, 25, 26, 27, 42], "creaturetyp": [2, 16, 21, 24, 25, 26, 27, 42], "creatureresidetown": 2, "1": [2, 9, 11, 12, 15, 18, 21, 24, 25, 26, 29, 30, 31, 34, 35, 38, 39, 42, 43, 54, 56, 59, 62, 64], "bannon": [2, 5, 18, 21, 24, 25, 26, 27, 42], "person": [2, 6, 21, 24, 25, 26, 27, 29, 31, 42, 44, 45, 55, 59, 62, 64], "philli": [2, 26], "myer": [2, 21, 24, 25, 26, 27, 42], "anoka": [2, 26], "3": [2, 9, 11, 16, 18, 21, 24, 25, 26, 29, 30, 31, 35, 39, 42, 44, 45, 46, 49, 53, 59, 64], "neff": [2, 21, 24, 25, 26, 27, 42], "blue": [2, 26], "earth": [2, 26], "4": [2, 6, 11, 15, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 50, 51, 59, 62, 64], "bemidji": [2, 5, 26, 48], "5": [2, 9, 15, 21, 24, 25, 26, 27, 29, 31, 34, 35, 39, 42, 44, 45, 46, 50, 59, 62, 64, 68], "mieska": [2, 21, 24, 25, 26, 27, 42], "duluth": [2, 26, 59], "6": [2, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 50, 53, 55, 59, 62, 64], "edina": 2, "7": [2, 15, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "kermit": [2, 21, 24, 25, 26, 27, 42, 59], "frog": [2, 21, 24, 25, 26, 27, 35, 42], "greenvil": [2, 26], "8": [2, 15, 16, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 49, 59, 62, 64], "godzilla": [2, 21, 24, 25, 26, 27, 42], "monster": [2, 21, 24, 25, 26, 27, 42], "tokyo": [2, 26], "9": [2, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "thor": [2, 21, 24, 25, 26, 27, 42, 59], "superhero": [2, 21, 24, 25, 26, 27, 42], "asgard": [2, 26], "whose": [2, 6, 9, 24, 25, 29, 31, 34, 35, 41, 42, 44, 45, 47, 50, 51, 55, 59, 64, 68], "text": [2, 8, 15, 25, 39, 41], "string": [2, 8], "shown": [2, 5, 6, 8, 15, 18, 19, 25, 26, 27, 31, 34, 41, 42, 44, 45, 46, 47, 50, 53, 55, 56, 59, 62], "quot": [2, 24, 33], "number": [2, 15, 18, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 45, 46, 55, 59], "hold": [2, 15, 34], "code": [2, 11, 21, 24, 26, 27, 31, 35, 39, 42, 49, 55, 59, 62], "carefulli": [2, 18, 21, 26, 34, 39, 44, 55, 59], "note": [2, 5, 7, 8, 9, 11, 12, 18, 19, 21, 24, 26, 27, 29, 30, 31, 35, 36, 39, 41, 44, 45, 46, 47, 48, 49, 51, 52, 55, 56, 59, 62, 64, 68], "run": [2, 5, 25, 27, 31, 35, 36, 55, 59, 62, 68], "noth": [2, 5, 26, 27, 29], "appear": [2, 5, 13, 15, 19, 24, 31, 34, 36, 44, 45, 55, 62], "happen": [2, 5, 26, 27, 29, 42, 64], "sinc": [2, 5, 11, 12, 16, 18, 24, 25, 26, 27, 29, 36, 41, 45, 46, 48, 55, 64], "all": [2, 4, 5, 6, 8, 11, 12, 15, 19, 23, 24, 25, 26, 27, 28, 31, 36, 37, 38, 39, 41, 42, 44, 45, 46, 51, 53, 55, 56, 59, 62, 64, 66, 68], "place": [2, 4, 12, 18, 25, 27, 31, 55, 62, 67], "row": [2, 11, 12, 15, 16, 18, 21, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 41, 42, 45, 46, 48, 55, 59], "insert": [2, 5, 8, 9, 21, 25, 43, 55], "particular": [2, 6, 8, 9, 15, 16, 24, 25, 26, 27, 35, 41, 42, 48, 59, 62, 64], "map": [2, 5, 16, 21, 35, 49, 68], "final": [2, 12], "someth": [2, 6, 15, 29, 55, 64, 66], "back": [2, 5, 25, 27, 31, 33, 46, 49, 50], "includ": [2, 6, 8, 11, 25, 27, 31, 35, 36, 39, 41, 44, 53, 55, 56, 62, 68], "everi": [2, 8, 12, 15, 18, 24, 25, 27, 34, 50, 55], "valu": [2, 5, 8, 9, 11, 12, 15, 16, 18, 24, 25, 26, 27, 29, 31, 35, 39, 42, 46, 50, 54, 55, 56, 59, 62, 64, 67], "often": [2, 8, 12, 15, 24, 25, 27, 33, 36, 40, 41, 42, 43, 44, 46, 55, 66], "refer": [2, 5, 8, 16, 18, 21, 26, 28, 33, 37, 44, 48, 59, 62, 68], "column": [2, 5, 6, 8, 9, 11, 15, 16, 18, 19, 23, 24, 29, 30, 31, 33, 34, 36, 37, 38, 39, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 54, 56, 58, 59, 62, 64], "correspond": [2, 16, 24, 25, 26, 27, 31, 33, 35, 36, 41, 42, 43, 48, 49, 50, 53, 59], "wai": [2, 6, 8, 9, 11, 12, 15, 16, 21, 24, 25, 27, 29, 31, 33, 34, 35, 39, 44, 45, 50, 55, 59, 62, 64], "With": [2, 24, 26, 29, 35, 37, 46, 48, 67, 68], "follow": [2, 5, 6, 8, 9, 12, 15, 19, 21, 23, 24, 25, 26, 27, 28, 29, 32, 33, 34, 35, 36, 39, 41, 42, 43, 44, 46, 49, 51, 53, 55, 59, 62, 64, 66, 67, 68], "choos": [2, 6, 11, 12, 15, 25, 26, 29, 31, 42, 44, 49, 64], "subset": 2, "pitfal": 2, "syntax": [2, 8, 11, 12, 34, 44, 45, 46, 51, 52, 55, 59, 68], "For": [2, 5, 9, 12, 15, 16, 18, 21, 23, 24, 25, 26, 27, 29, 31, 35, 44, 46, 48, 50, 51, 54, 59, 66, 67], "best": [2, 26, 31, 39, 59], "stick": [2, 11], "asterisk": [2, 24, 27], "show": [2, 8, 16, 24, 26, 28, 29, 31, 33, 36, 37, 39, 41, 42, 44, 47, 49, 55, 59, 62, 64, 67], "displai": [2, 11, 12, 26, 29, 36, 46, 55], "result": [2, 11, 12, 15, 19, 20, 23, 24, 25, 27, 29, 30, 31, 33, 34, 35, 36, 37, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 55, 59, 62, 64, 68], "go": [2, 15, 24, 34, 35, 36, 39, 41, 42, 44, 59, 64, 68], "previou": [2, 8, 24, 25, 27, 28, 29, 31, 33, 34, 37, 41, 42, 43, 45, 46, 47, 48, 49, 56, 59], "ad": [2, 5, 8, 11, 19, 27, 35, 45, 56], "command": [2, 5, 8, 11, 12, 21, 24], "begin": [3, 14, 18, 21, 24, 31, 34, 35, 37, 41, 42, 68], "consid": [3, 8, 9, 11, 15, 24, 25, 26, 27, 29, 32, 36, 37, 50, 54, 55, 67], "creatur": [3, 6, 7, 8, 9, 12, 16, 29, 31, 33, 34, 35, 36, 39, 41, 43, 44, 45, 46, 47, 48, 50, 51, 52, 53, 55, 59, 62, 64, 67], "data": [3, 4, 7, 8, 9, 12, 14, 16, 18, 21, 24, 25, 26, 27, 28, 29, 31, 34, 35, 37, 41, 42, 43, 44, 45, 46, 49, 50, 51, 53, 55, 56, 59, 62, 67], "tabl": [3, 6, 7, 8, 9, 12, 14, 15, 16, 18, 21, 26, 27, 28, 29, 35, 36, 37, 41, 42, 43, 44, 49, 53, 55, 64], "creation": [3, 4, 5, 6, 15, 16, 21, 39], "popul": [3, 7, 15, 21], "try": [3, 4, 6, 15, 21, 23, 24, 25, 26, 27, 29, 31, 34, 35, 36, 39, 42, 45, 48, 50, 54, 61, 63, 65, 68], "yourself": [3, 12, 21, 26, 31, 36, 61], "allinon": 4, "complet": [4, 19, 21, 27, 31, 36, 39, 42, 44, 59, 62, 64, 67, 68], "version": [4, 24, 29, 36, 55, 58, 59], "statement": [4, 6, 9, 16, 21, 31, 62, 66], "download": [4, 21, 26, 28, 37, 39], "file": [4, 15, 21, 23, 24, 26, 39], "thing": [4, 12, 15, 24, 25, 31, 41, 42, 44, 55, 59, 66, 67], "And": [4, 18, 24, 31, 55, 59], "retriev": [4, 24], "experi": [4, 11, 12, 25, 31, 35], "twoentityshap": 5, "relationship": [5, 8, 9, 19, 21, 31, 41, 42, 44, 45, 46, 47, 49, 51, 55, 56, 68], "actual": [5, 43, 64, 66], "suppos": [5, 35, 42, 55, 59], "wa": [5, 6, 8, 9, 23, 24, 27, 33, 39, 41, 42, 43, 45, 46, 48, 55, 59, 62, 64, 68], "besid": [5, 56], "name": [5, 8, 11, 12, 15, 16, 18, 19, 21, 23, 24, 25, 27, 29, 30, 31, 33, 35, 36, 39, 41, 42, 44, 45, 46, 47, 53, 55, 56, 59, 66], "exampl": [5, 6, 8, 9, 11, 12, 15, 16, 18, 19, 28, 29, 30, 31, 33, 37, 38, 41, 42, 43, 44, 45, 47, 48, 49, 50, 51, 52, 53, 56, 58, 59, 62, 64, 66, 67, 68], "mn": [5, 26, 68], "usa": [5, 68], "ha": [5, 9, 11, 12, 15, 16, 18, 19, 23, 24, 25, 26, 27, 31, 33, 34, 35, 36, 37, 41, 44, 46, 49, 51, 55, 59, 64, 67, 68], "nicknam": 5, "motto": 5, "seen": [5, 7, 19, 24, 27, 31, 36, 44, 48, 55], "wikipedia": [5, 59], "page": [5, 25, 42, 43, 44, 48, 68], "caus": [5, 12, 15], "evolut": [5, 8, 9], "our": [5, 12, 15, 18, 21, 26, 29, 31, 34, 36, 39, 41, 42, 44, 46, 48, 58, 59, 64], "extra": [5, 34, 41, 44, 58, 62], "also": [5, 9, 11, 12, 18, 21, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 37, 42, 44, 45, 46, 47, 48, 55, 59, 63, 67, 68], "chang": [5, 8, 9, 11, 12, 18, 23, 24, 25, 26, 29, 35, 39, 42, 45, 59, 62, 64, 68], "onc": [5, 8, 12, 25, 27, 31, 34, 35, 39, 44, 50, 51, 59, 64], "had": [5, 8, 11, 43, 49, 62, 68], "replac": [5, 33, 42, 59], "townid": [5, 16, 24, 26, 29, 35, 42, 47, 59], "call": [5, 8, 9, 12, 15, 16, 19, 23, 24, 26, 29, 31, 34, 36, 37, 41, 42, 44, 46, 55, 56, 59, 64], "said": [5, 15, 59], "below": [5, 8, 16, 21, 27, 29, 31, 34, 35, 36, 37, 39, 42, 44, 45, 46, 51, 52, 53, 55, 59, 62, 64, 68], "notic": [5, 8, 12, 16, 19, 24, 27, 29, 31, 34, 36, 39, 41, 45, 55, 62, 64], "declar": [5, 8, 9, 11, 12, 15, 16, 19, 29], "p": [5, 21, 24, 25, 26, 27, 42], "philadelphia": [5, 26], "term": [5, 11, 15, 18, 27, 53, 66], "foreign": [5, 6, 9, 16, 21, 24, 31, 41, 44, 46, 47, 49, 55, 56], "kei": [5, 6, 8, 9, 11, 12, 15, 16, 18, 21, 24, 27, 29, 31, 41, 44, 46, 47, 48, 49, 55, 56, 59], "made": [5, 24, 29, 31, 39, 48, 59], "opposit": [5, 6, 31], "origin": [5, 12, 18, 24, 25, 26, 29, 31, 33, 34, 35, 42, 43, 45, 46, 47, 48, 52, 61, 62, 68], "did": [5, 26, 29, 36, 41, 56, 62], "add": [5, 9, 11, 15, 25, 39, 42, 45, 52, 55, 59, 62, 64], "exist": [5, 11, 16, 49, 59, 68], "z": [5, 9, 11, 24, 25, 27, 29, 31, 34, 35, 39, 42, 44, 45, 46, 56, 59, 64], "enter": [5, 8, 9], "explain": [5, 23, 25, 64], "queri": [5, 11, 15, 18, 19, 24, 25, 26, 27, 29, 32, 34, 36, 38, 39, 41, 42, 45, 48, 49, 50, 51, 54, 55, 59, 63, 65, 66], "simpli": [5, 25, 26, 27, 31, 33, 42, 50, 55, 59, 62, 64], "togeth": [5, 24, 26, 29, 31, 55, 66, 68], "again": [5, 8, 18, 25, 27, 29, 31, 33, 34, 36, 42, 45, 52, 62, 64], "whole": [5, 11], "purpos": [5, 12, 15, 24, 55, 68], "never": [5, 9, 15, 18, 19, 26, 27, 31, 44, 45, 55], "afraid": 5, "point": [5, 12, 18, 31, 34, 35, 38, 39, 41, 44, 46, 48, 49, 59, 66], "dure": 5, "process": [5, 12, 33, 44, 45, 46, 59, 66, 67, 68], "be_shap": 6, "take": [6, 11, 15, 18, 19, 23, 25, 31, 42, 45, 48, 50, 62, 64, 66], "two": [6, 8, 9, 12, 15, 16, 18, 19, 23, 25, 26, 27, 31, 33, 34, 35, 36, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 53, 55, 61, 62, 64, 68], "entiti": [6, 8, 9, 16, 21, 31, 35, 39, 41, 43, 47, 49, 50, 55, 59, 68], "describ": [6, 29, 31, 44, 46, 59, 64], "set": [6, 11, 12, 15, 16, 18, 24, 25, 27, 34, 35, 36, 41, 42, 49, 50, 51, 52, 55, 59, 62, 66, 68], "form": [6, 11, 12, 16, 23, 24, 25, 26, 27, 33, 34, 41, 50, 53, 59, 66, 68], "categor": 6, "subgroup": 6, "sometim": [6, 8, 15, 19, 25, 39, 59, 67], "those": [6, 11, 12, 15, 18, 23, 24, 25, 29, 31, 33, 34, 36, 41, 42, 43, 44, 45, 50, 59, 66], "meant": [6, 64], "contain": [6, 8, 9, 15, 18, 24, 25, 26, 27, 29, 31, 43, 44, 45, 46, 49, 50, 51, 59, 62, 64], "skill": [6, 8, 9, 11, 15, 18, 21, 24, 26, 29, 34, 35, 36, 39, 41, 43, 46, 47, 48, 49, 50, 52, 53, 55, 59, 62, 67], "might": [6, 9, 12, 15, 24, 25, 26, 27, 29, 31, 33, 42, 45, 46, 50, 55, 59, 62, 64, 66, 67], "achiev": [6, 8, 9, 12, 18, 21, 25, 26, 33, 34, 35, 36, 41, 42, 43, 46, 47, 48, 50, 52, 53, 55, 62, 67], "perform": [6, 11, 12, 24, 25, 33, 34, 35, 44, 50, 55, 56, 59, 62, 64], "individu": [6, 24], "team": [6, 21, 26, 49, 62, 67, 68], "case": [6, 8, 18, 24, 25, 29, 30, 31, 33, 34, 36, 39, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 53, 55, 56, 59, 62, 64], "decid": [6, 18, 24, 25, 26, 42, 44, 46, 50, 64], "teamskil": [6, 25, 29, 42, 43, 49, 53], "teamsiz": [6, 29], "bobsled": [6, 25, 27, 31, 42, 44, 45, 64], "cours": [6, 12, 15, 31, 68], "requir": [6, 11, 15, 16, 25, 31, 39, 66], "peopl": [6, 11, 12, 36, 66, 68], "done": [6, 11, 24, 31, 34, 39, 42, 59, 64], "link": [6, 68], "incorpor": [6, 11], "bar": 6, "must": [6, 9, 11, 12, 15, 16, 18, 24, 25, 26, 29, 31, 33, 35, 36, 41, 42, 44, 50, 52, 55, 64, 66], "identifi": [6, 9, 10, 11, 12, 15, 16, 18, 19, 24, 25, 26, 27, 29, 31, 35, 36, 41, 42, 44, 45, 46, 47, 48, 49, 50, 52, 53, 55, 56, 59, 64, 67], "skillcod": [6, 9, 11, 18, 24, 25, 26, 27, 29, 31, 34, 35, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 55, 59, 62, 64], "primari": [6, 8, 9, 11, 15, 16, 18, 31, 53, 68], "ve": [6, 31, 42, 55, 68], "time": [6, 8, 12, 15, 18, 19, 21, 24, 25, 26, 27, 29, 38, 39, 42, 44, 48, 51, 52, 54, 55, 59], "individualskil": 6, "could": [6, 9, 12, 15, 16, 19, 25, 26, 27, 29, 31, 35, 39, 42, 45, 46, 55, 59, 62, 64, 66], "exercis": [6, 23, 30, 32, 38, 54, 55, 61, 68], "onli": [6, 8, 9, 11, 12, 15, 16, 19, 24, 25, 26, 27, 31, 34, 41, 42, 44, 46, 55, 59, 62, 64], "sub": 6, "group": [6, 23, 30, 32, 39, 55, 59, 62], "wish": [6, 8, 21, 25, 26, 29, 35, 59, 68], "anyth": [6, 15, 31, 45, 46], "els": [6, 15, 44], "mai": [6, 8, 11, 12, 15, 16, 18, 19, 21, 24, 25, 26, 29, 33, 35, 36, 48, 62, 66, 68], "delai": 6, "overlap": [6, 41, 42, 53], "either": [6, 16, 31, 42, 43, 45, 48, 49, 50, 53, 64], "determin": [6, 11, 25, 29, 31, 36, 42, 44, 45, 47, 59, 64], "other": [6, 8, 9, 11, 12, 15, 18, 24, 25, 26, 29, 31, 33, 34, 35, 36, 39, 43, 45, 48, 49, 53, 54, 55, 59, 63, 65, 66, 67, 68], "e": [6, 9, 11, 15, 18, 24, 25, 27, 29, 31, 33, 35, 39, 41, 42, 43, 45, 53, 54, 55, 59, 64], "interest": [6, 8, 29, 35, 36, 39, 55, 59], "come": [6, 11, 12, 15, 16, 24, 27, 31, 36, 48, 55, 59], "choic": [6, 23, 47], "new": [7, 8, 11, 12, 25, 26, 27, 29, 31, 34, 36, 37, 41, 44, 45, 47, 59, 65, 67], "town": [7, 16, 24, 27, 29, 31, 34, 35, 36, 42, 44, 45, 46, 47, 48, 50, 52, 55, 59, 62], "re": [7, 24, 25, 34, 35, 48], "through": [7, 11, 12, 15, 31, 42, 43, 46, 48, 50, 53, 59, 66, 68], "peek": 7, "ahead": 7, "natur": [7, 9, 15, 26, 27, 30, 41, 42, 44, 45, 46, 47, 49, 55, 56, 62, 66], "join": [7, 24, 36, 44, 45, 46, 47, 48, 49, 50, 51, 56, 59, 64, 68], "far": [7, 29, 31, 36, 39, 41, 55, 59, 64], "One": [7, 25, 33, 35, 42, 44, 50, 59, 62, 68], "intersectionarbitraryid": 8, "occur": [8, 39, 42, 44], "care": [8, 11, 15, 19, 29, 50], "consider": [8, 37], "being": [8, 9, 29, 36, 42, 43, 51, 53, 54, 55, 59, 66, 67, 68], "automat": [8, 9, 26, 34, 44], "intermedi": [8, 9, 11, 12, 31, 34, 36, 39, 43, 48, 55, 56, 59], "still": [8, 9, 12, 15, 24, 26, 44, 45, 48, 55, 59], "pair": [8, 9, 16, 27, 35, 36, 42, 43, 45, 47, 48, 50, 52, 53, 62], "than": [8, 11, 12, 15, 18, 19, 23, 24, 26, 27, 29, 31, 33, 34, 35, 36, 41, 42, 44, 45, 47, 50, 53, 55, 59, 62, 64], "occurr": [8, 9, 64], "date": [8, 25, 27, 30, 59, 64], "achdat": [8, 24, 27, 29, 31, 39, 44, 45, 59, 64], "same": [8, 15, 16, 18, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 37, 38, 41, 42, 43, 44, 45, 46, 47, 54, 55, 56, 59, 62, 64], "cannot": [8, 15, 16, 25, 26, 27, 29, 31, 45], "tiebreak": 8, "instead": [8, 14, 15, 16, 18, 36, 55, 59, 62, 66], "line": [8, 9, 15, 25, 41, 42], "20": [8, 16, 24, 26, 27, 29, 31, 35, 39, 44, 45, 46, 59, 62, 64], "keyword": [8, 9, 24, 25, 26, 27, 31, 34, 35, 36, 44, 47, 55], "autoincr": 8, "integ": [8, 15, 16, 25, 27, 64], "system": [8, 11, 15, 21, 24, 27, 44, 55, 68], "increment": 8, "vari": [8, 15, 34], "sqlite": [8, 21, 24, 25, 27, 34, 36, 44, 55, 68], "similarli": [8, 41], "almost": [8, 12, 15, 62, 67], "encount": [8, 16], "defin": [8, 11, 12, 17, 59], "datatyp": [8, 30], "function": [8, 12, 18, 25, 27, 31, 36], "convert": [8, 11, 12, 39, 55], "datetim": 8, "treat": [8, 15, 27, 33, 35], "11": [8, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 64], "taken": 8, "short": [8, 12, 15, 25, 29, 41, 42, 53, 67], "cut": 8, "were": [8, 21, 24, 26, 29, 33, 39, 41, 45, 47, 52, 53, 55, 62], "order": [8, 11, 15, 19, 33, 36, 37, 41, 46, 49, 52, 55, 62], "achid": [8, 24, 25, 26, 27, 29, 31, 39, 42, 44, 45, 59, 62, 64], "featur": [8, 12, 15, 68], "found": [8, 12, 24, 41, 42, 55], "gener": [8, 12, 15, 26, 27, 33, 34, 35, 53, 58, 59, 64, 67, 68], "timestamp": 8, "special": [8, 11, 15, 44, 55, 62, 68], "illustr": [8, 9, 12, 16, 18, 21, 28, 33, 34, 37, 42, 44, 59, 68], "up": [8, 12, 24, 27, 29, 31, 34, 42, 48, 55, 59, 64, 67, 68], "intersectionshap": 9, "To": [9, 11, 18, 23, 24, 26, 31, 35, 36, 41, 50, 55, 59, 62, 68], "realiz": [9, 23, 27, 31, 35, 36, 48, 50, 55, 62], "skilldescript": [9, 25, 27, 31, 42, 44, 45, 55, 64], "float": [9, 25, 27, 31, 35, 42, 44, 45, 59, 64, 67], "swim": [9, 25, 27, 31, 33, 42, 44, 45, 59, 64], "o": [9, 25, 27, 31, 35, 41, 42, 44, 45, 46, 53, 64], "sink": [9, 25, 27, 31, 42, 44, 45, 64], "walk": [9, 25, 27, 31, 42, 44, 45, 64], "water": [9, 25, 27, 31, 42, 44, 45, 48, 64], "gargl": [9, 18, 25, 27, 31, 33, 34, 35, 42, 44, 45, 59, 64], "wight": 9, "profici": [9, 11, 24, 25, 26, 27, 29, 31, 35, 39, 44, 45, 55, 59, 64, 67], "combin": [9, 35, 36, 40, 47, 54, 55, 64, 68], "stop": [9, 33], "sure": [9, 24, 26, 29, 31, 55], "understand": [9, 11, 12, 18, 21, 24, 31, 33, 34, 36, 39, 41, 42, 45, 46, 48, 59, 64, 66], "last": [9, 12, 15, 18, 25, 35, 46, 59, 62, 64], "sentenc": [9, 12, 19, 29, 31], "answer": [9, 11, 15, 16, 29, 31, 50, 62], "question": [9, 15, 16, 25, 29, 50, 62], "q": [9, 12, 25, 29, 31, 50, 51, 59], "given": [9, 11, 12, 25, 26, 29, 31, 36, 41, 42, 52, 53, 59, 64, 66, 67, 68], "contribut": [9, 21, 29, 31, 44, 46, 47, 59, 67], "situat": [9, 26, 41, 42, 44, 45, 46, 47, 48, 50, 51, 53], "repeat": [9, 12, 16, 18, 29, 59], "earlier": [9, 12, 16, 18, 24, 31, 41, 44, 49], "23": [9, 24, 27, 29, 31, 39, 44, 45, 59, 64], "further": [9, 12, 25, 42, 48, 55, 64, 68], "uniqu": [9, 11, 15, 18], "default": 9, "null": [9, 13, 15, 16, 21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 46, 54, 55, 56, 59, 64], "remov": [9, 25, 26, 27, 34, 41, 42, 62], "NOT": [9, 16, 31, 34, 35, 59], "non": [9, 12, 15, 16, 19, 24, 25, 26, 27, 32, 34, 36, 37, 38, 41, 42, 43, 44, 45, 46, 53, 62], "perhap": [9, 11, 15, 25, 26, 29, 59, 66], "alwai": [9, 11, 12, 15, 18, 19, 25, 26, 29, 37, 41, 42, 44, 47, 48, 59, 66, 68], "altern": [9, 19, 26, 31, 36, 44, 45], "respect": [9, 19, 36, 50, 62], "24": [9, 15, 24, 27, 29, 31, 39, 44, 45, 59, 64], "25": [9, 25, 27, 29, 31, 42, 44, 45, 64], "just": [9, 11, 12, 15, 16, 18, 21, 25, 26, 27, 29, 33, 34, 35, 39, 41, 42, 43, 44, 55, 59, 62, 64, 66, 68], "befor": [9, 19, 24, 25, 27, 32, 34, 36, 39, 41, 42, 47, 59, 68], "section": [9, 11, 15, 23, 25, 31, 34, 35, 36, 41, 42, 43, 44, 46, 47, 48, 49, 56, 67], "chicken": [10, 31, 42, 47, 48, 50, 54, 55], "feet": [10, 42, 47, 48, 50, 54, 55], "intersect": [10, 38, 42, 49, 50, 55, 59], "arbitrari": [10, 42], "summari": [10, 14, 17, 30, 33, 34, 35, 38], "concept": [10, 15, 18, 29, 48, 59, 64, 68], "introduc": [10, 12, 18, 24, 35, 37, 64], "00masteringintro": 11, "aim": 11, "rel": [11, 50], "newcom": 11, "intent": [11, 18, 66], "enabl": [11, 15, 25, 31, 46, 59, 68], "develop": [11, 12, 46, 48, 64, 68], "masteri": [11, 12, 15, 18, 26, 29, 31, 35, 36, 41, 46, 48], "correct": [11, 18, 24, 26, 29, 31, 39, 49, 68], "desir": [11, 25, 35, 41, 46, 47], "seek": [11, 12], "save": [11, 12, 15, 31, 36], "cost": [11, 12], "analyz": [11, 12, 15], "improv": [11, 12, 18, 67], "decis": [11, 12, 42, 44, 45, 46, 47], "advanc": [11, 24, 68], "claim": 11, "flaw": [11, 12, 36], "better": [11, 25], "oper": [11, 12, 15, 16, 18, 19, 21, 24, 27, 34, 35, 36, 39, 42, 44, 46, 47, 49, 51, 52, 55, 62, 64, 66, 68], "produc": [11, 12, 18, 19, 25, 26, 29, 33, 35, 36, 39, 49], "importantli": 11, "languag": [11, 12, 19, 26, 44, 66], "precis": [11, 12, 24, 26, 29, 55, 62, 66, 67], "disciplin": [11, 14, 18], "formul": [11, 12, 44, 45, 46, 66], "narr": [11, 12, 25, 31, 59, 66], "technic": 11, "happili": 11, "none": [11, 24, 25, 42], "focu": [11, 12, 24, 25, 44, 50, 51, 66, 68], "technologi": [11, 68], "commun": [11, 44, 59, 66, 67], "among": [11, 25, 37, 59], "problem": [11, 31], "solv": 11, "Be": [11, 31, 55], "alreadi": [11, 12, 19, 34, 43, 44, 59], "experienc": [11, 68], "slower": 11, "starter": [11, 21], "novic": [11, 16, 26, 27, 31], "unlearn": 11, "manag": [11, 12, 15, 41, 68], "dbm": [11, 12, 15, 16, 25, 29, 30, 34, 66], "human": [11, 15, 66], "role": [11, 14, 15, 31, 44], "analyst": [11, 12, 44, 66, 67], "analys": [11, 12, 36, 41, 44, 59, 64], "devis": [11, 24, 41, 46, 48, 59, 62], "plan": [11, 14, 15, 18, 19, 24], "accomplish": [11, 55, 59], "execut": [11, 12, 15, 25, 68], "rest": [11, 21, 23, 36, 41, 43], "comfort": [11, 46, 59, 62], "certain": [11, 12, 18, 26, 39, 46, 50, 55], "involv": [11, 12, 50, 55, 59], "administr": 11, "dba": 11, "who": [11, 12, 24, 26, 31, 34, 35, 39, 48, 55, 59, 62, 64, 67, 68], "respons": 11, "larg": [11, 12, 16, 25, 59, 64], "purview": 11, "give": [11, 29, 42, 45, 55, 59, 66], "privileg": 11, "g": [11, 15, 18, 21, 24, 25, 26, 27, 29, 31, 33, 35, 42, 44, 45, 46, 64, 68], "index": [11, 68], "build": 11, "backup": 11, "recoveri": 11, "etc": [11, 15, 64], "applic": [11, 12, 15], "programm": 11, "write": [11, 12, 18, 24, 26, 29, 31, 41, 42, 44, 66], "app": 11, "limit": [11, 15], "view": [11, 15, 39], "insul": [11, 12], "messi": 11, "access": [11, 12, 15, 23, 24, 26, 44], "comput": [11, 15, 27, 30, 39, 59, 67, 68], "via": 11, "unfortun": 11, "realm": [11, 12, 15], "overload": 11, "paragraph": 11, "briefli": [11, 12, 15], "sever": [11, 12, 19, 27, 29, 41, 48, 50, 59, 66, 67], "despit": 11, "usag": 11, "input": [11, 12, 19, 20, 23, 24, 25, 26, 27, 29, 31, 33, 34, 35, 37, 38, 39, 42, 43, 44, 45, 46, 47, 48, 50, 51, 53, 54, 55, 59, 62], "output": [11, 12, 19, 20, 23, 27], "simplest": [11, 12, 25, 38], "within": [11, 12, 15, 18, 27], "truli": [11, 12, 62], "consist": [11, 12, 15, 25, 27, 36], "cell": [11, 15, 16, 18, 27], "singleton": [11, 15, 26], "organ": [11, 48], "rectangl": [11, 15, 26], "It": [11, 12, 15, 18, 21, 24, 25, 26, 27, 28, 31, 36, 37, 39, 42, 44, 45, 48, 50, 55, 64], "serv": [11, 15, 18, 24, 26, 34, 64], "distinguish": [11, 12, 15, 26], "duplic": [11, 12, 15, 26, 27, 34, 42, 55, 62], "burden": 11, "enforc": [11, 15, 16], "restrict": [11, 12, 15, 33, 35, 42], "shift": 11, "onto": 11, "By": [11, 15, 47, 66], "contrast": 11, "ii": 11, "consequ": [11, 12, 15, 16, 18, 24, 25, 55], "allow": [11, 12, 15, 27], "mathemat": [11, 15, 36], "while": [11, 12, 15, 16, 18, 19, 21, 26, 27, 31, 33, 36, 66], "bag": 11, "multi": 11, "miss": [11, 51, 55, 65, 67], "bewar": [11, 15, 26], "mistakenli": 11, "synonym": 11, "foster": 11, "sai": [11, 12, 16, 24, 25, 36, 59, 66], "sadli": [11, 18], "effect": [11, 29, 35], "materi": [11, 12, 15, 68], "distinct": [11, 15, 18, 26, 27, 31, 55, 59, 66, 67], "between": [11, 15, 17, 19, 23, 25, 26, 27, 39, 42, 44, 46, 47, 48, 49, 50, 54, 55, 64, 67], "prime": 11, "misus": [11, 31], "express": [11, 12, 19, 25, 67], "written": [11, 24, 25, 26, 44, 68], "comprehens": 11, "eventu": [11, 12, 15], "transform": [11, 12], "variant": 11, "preced": [11, 12, 18, 21, 23, 24, 26, 27, 29, 31, 34, 35, 36, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 59, 62, 64, 68], "chart": [11, 12, 18, 21, 24, 25, 26, 27, 29, 30, 31, 33, 34, 35, 36, 39, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 59, 62, 64, 68], "These": [11, 12, 15, 33, 34, 42, 44, 46], "proper": 11, "itself": [11, 12, 36, 54, 62], "error": [11, 26, 27, 33, 39], "prone": 11, "mechan": [11, 68], "sens": [11, 12, 15, 24, 59], "leav": [11, 24, 42, 66], "unchang": 11, "broader": 11, "expect": [11, 12, 25, 45, 66, 68], "softwar": [11, 12, 15, 44, 68], "permiss": [11, 68], "dynam": 11, "element": [11, 15, 19, 33, 34, 56], "schema": [11, 21, 26, 31, 35, 41, 42, 43, 44, 45, 46, 48, 49, 50, 51, 53, 55], "reli": 11, "assum": [11, 64, 67, 68], "There": [11, 15, 21, 27, 31, 33, 41, 42, 45, 46, 48, 49, 53, 55, 62, 66, 67], "01queying_analysi": 12, "complex": [12, 31, 33, 38, 39, 43, 59, 68], "focus": [12, 24], "anchor": [12, 26, 62], "german": 12, "bring": [12, 18, 68], "light": 12, "fuzzi": 12, "effici": 12, "cycl": 12, "until": [12, 15, 24, 41, 64], "satisfi": [12, 24, 59, 62], "evolv": 12, "along": [12, 25, 26, 33, 44, 45, 59, 64], "richer": 12, "Such": [12, 16, 19, 26], "notion": [12, 15, 16, 19, 25, 26, 27, 37, 41, 42, 48], "definit": [12, 15, 59], "fortun": [12, 66], "respond": 12, "extern": 12, "trigger": 12, "surpris": [12, 66, 67], "shortfal": 12, "avail": [12, 25, 55], "raw": [12, 15, 19, 26], "period": 12, "quarterli": 12, "report": [12, 64], "thought": [12, 31, 36, 41, 59], "endeavor": 12, "proactiv": 12, "inventori": 12, "prelud": 12, "revis": 12, "purchas": 12, "polici": 12, "anomali": 12, "trend": 12, "lead": [12, 25, 36, 48], "delv": [12, 15, 21], "increas": [12, 68], "knowledg": [12, 64, 67], "valuabl": 12, "acquir": 12, "depth": 12, "nuanc": 12, "organiz": 12, "context": [12, 67], "ask": [12, 16, 26, 27, 35, 44, 45, 50, 55, 59, 64], "kind": [12, 15, 19, 27, 67], "thin": 12, "connot": 12, "littl": [12, 18, 44], "ow": 12, "small": [12, 25, 26, 36, 41, 43, 46, 48, 59, 68], "No": [12, 29, 36], "loan": 12, "monei": 12, "fat": 12, "extens": 12, "compar": [12, 24, 29, 30, 33, 35, 36, 39, 59, 64, 68], "debt": 12, "load": [12, 25], "custom": 12, "employ": 12, "statu": 12, "credit": 12, "histori": 12, "support": [12, 55], "larger": [12, 19, 50, 68], "schedul": 12, "incom": 12, "threshold": 12, "pronounc": [12, 25], "l": 12, "quell": 12, "standard": [12, 27, 68], "interfac": 12, "r": 12, "vendor": 12, "compli": 12, "specifi": [12, 15, 25, 26, 27], "accept": [12, 15, 19, 36], "textbook": [12, 59], "unnam": [12, 66], "object": 12, "four": [12, 27, 33, 35, 62, 68], "italic": [12, 15, 24], "word": [12, 15, 18, 25, 26, 30, 34, 35, 39, 45, 48, 55, 59, 67], "oppos": [12, 55], "outcom": 12, "amort": 12, "reus": [12, 64], "multipl": [12, 29, 30, 41, 64], "gotten": [12, 43], "remain": [12, 23, 27, 48], "blissfulli": 12, "ignor": [12, 27], "sad": 12, "fact": [12, 15, 18, 24, 25, 46], "complain": 12, "got": 12, "b": [12, 21, 24, 25, 26, 27, 29, 31, 33, 34, 35, 36, 37, 39, 41, 42, 43, 54, 56, 59, 64], "c": [12, 29, 55, 59], "therebi": 12, "gain": 12, "benefit": 12, "harder": [12, 48], "aid": [12, 41, 42, 43, 53, 54, 55, 56], "reflect": [12, 27], "terribli": 12, "difficult": [12, 36, 42], "even": [12, 15, 25, 27, 29, 31, 33, 46, 55, 59, 62], "expert": 12, "find": [12, 18, 21, 24, 25, 26, 27, 31, 34, 35, 36, 42, 44, 45, 46, 47, 48, 49, 51, 52, 55, 59, 62, 64, 66, 67], "hard": [12, 29, 39, 59], "struggl": [12, 66], "own": [12, 15, 18, 21, 23, 24, 26, 28, 29, 31, 37, 41, 46, 59, 64, 68], "imposs": [12, 55], "ani": [12, 15, 19, 26, 27, 31, 33, 34, 35, 36, 39, 41, 45, 47, 48, 55, 59, 62], "mention": [12, 25, 34, 36, 46], "although": [12, 15, 26, 67], "sound": [12, 25], "english": [12, 24, 25, 26, 27, 31, 34, 35, 36, 39, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 55, 59, 62, 66], "Of": [12, 31], "state": [12, 16, 19, 26, 29, 44, 45, 46, 50, 66, 67], "too": [12, 15, 19, 26], "wors": 12, "tend": 12, "convolut": 12, "forc": [12, 66], "That": [12, 15, 25, 31], "mental": 12, "juggl": 12, "inde": [12, 16, 27, 36, 45, 55], "furthermor": 12, "script": 12, "off": [12, 19], "fail": [12, 15, 26, 67], "reap": 12, "less": [12, 24, 61, 64], "expens": [12, 36], "overcom": 12, "my": [12, 18, 31, 68], "advic": [12, 15], "bare": 12, "collect": [12, 15], "minim": 12, "yield": [12, 24, 26, 27, 31], "composit": [12, 15], "succeed": 12, "compil": 12, "reread": 12, "mutual": 12, "exclus": 12, "program": [12, 15, 27], "higher": [12, 39, 44], "lower": [12, 33, 42, 44, 45, 46, 55, 62], "machin": [12, 68], "worth": [12, 15, 59], "competitor": 12, "filter": [12, 18, 23, 30, 32, 34, 36, 42, 44, 45, 52, 54, 59, 62, 64], "appli": [12, 21, 23, 24, 25, 36, 46, 47, 53, 63], "usual": [12, 18, 23, 34, 44, 55, 59], "compris": [12, 15, 45], "well": [12, 31, 36, 48, 59, 66], "fix": [12, 67], "establish": 12, "authorit": 12, "bodi": 12, "open": [12, 36, 64], "mind": [12, 24, 42, 48, 55], "author": 12, "select": [12, 24, 25, 26, 31, 34, 44, 55, 59, 62], "somewhat": [12, 21, 27, 29, 43, 59, 68], "mostli": [12, 66], "greek": 12, "symbol": [12, 16, 24, 26, 27, 41, 42, 43, 44, 45, 46, 53, 55, 59, 62], "shortcut": [12, 24, 41, 42, 44], "detract": 12, "anonym": [12, 15], "moreov": 12, "content": [12, 13, 37, 66], "major": 12, "readi": 12, "remaind": 12, "lot": [12, 18, 25], "temp": 13, "stai": 13, "tune": 13, "recipe_id": [13, 15], "rank": [13, 15], "recipe_categori": [13, 15], "recipe_nam": [13, 15], "9257643": [13, 15], "8772": [13, 15], "cooki": [13, 15], "oatmeal": [13, 15], "crispi": [13, 15], "60029738": [13, 15], "bread": [13, 15, 19], "banana": [13, 15], "v": [14, 68], "algebra": [14, 15, 18, 19, 21, 34, 39, 59], "mean": [14, 15, 18, 19, 26, 31, 33, 34, 39, 42, 44, 47, 51, 53, 55, 59, 64, 66, 67], "product": [14, 33, 36], "initi": [14, 66], "big": 14, "pictur": [14, 34], "00definit": 15, "broad": [15, 66], "deem": 15, "resist": 15, "urg": 15, "quickli": [15, 27, 31], "crucial": [15, 18, 24, 25, 26], "second": [15, 24, 26, 31, 34, 35, 36, 39, 41, 42, 44, 45, 47, 51, 58, 59, 62, 66, 67, 68], "implicit": 15, "empti": 15, "rdmb": 15, "won": 15, "t": [15, 21, 23, 24, 25, 26, 27, 29, 31, 35, 36, 39, 42, 44, 45, 46, 59, 64], "hing": 15, "dozen": [15, 26], "common": [15, 31, 35, 41, 42, 50, 53, 55], "decept": 15, "unord": [15, 62], "dimens": 15, "enclos": 15, "venn": 15, "curli": 15, "brace": 15, "heterogen": 15, "remot": 15, "control": 15, "appl": 15, "jackhamm": 15, "pi": 15, "commonli": 15, "homogen": 15, "34": 15, "letter": [15, 41, 42, 44, 46, 47, 53, 55], "signific": [15, 24], "themselv": [15, 62], "complac": 15, "pai": [15, 47], "attent": [15, 47], "plai": 15, "critic": 15, "tini": 15, "size": 15, "denot": 15, "ital": 15, "underlin": [15, 18, 19], "4x2": 15, "recal": [15, 18, 25, 31, 33, 34, 35, 41, 42, 59, 62], "incorrect": [15, 29, 31], "singular": [15, 19, 21, 24, 67], "encod": 15, "domain": [15, 16, 64, 67], "dictat": 15, "left": [15, 16, 18, 26, 39, 42, 55, 56, 59, 62, 66, 67], "right": [15, 18, 25, 26, 31, 33, 36, 39, 42, 51, 58, 62, 66, 68], "meaning": 15, "charact": [15, 21], "smaller": [15, 62], "ph": 15, "0": [15, 24, 25, 27, 31, 42, 44, 45, 56, 64], "14": [15, 24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64, 68], "grade": 15, "constrain": 15, "f": [15, 29, 59], "explicitli": [15, 42, 44], "constraint": 15, "foolishli": 15, "trust": 15, "behav": [15, 35], "confus": 15, "especi": [15, 29, 55], "scale": 15, "nomin": 15, "ordin": 15, "numer": 15, "field": 15, "variabl": [15, 27], "tupl": 15, "atom": 15, "sensibl": 15, "assert": [15, 16], "current": [15, 25, 26, 62], "futur": 15, "exactli": [15, 18, 24, 25, 31, 36, 41, 42, 44, 46, 53, 61, 62, 64], "intern": [15, 18, 26], "temporari": 15, "alias": 15, "keystrok": 15, "noun": [15, 18, 19, 26, 29, 36, 67], "phrase": [15, 18, 26, 30, 31, 33, 34, 35, 44, 45, 46, 59, 66], "topic": [15, 68], "pervad": 15, "tax": 15, "student": [15, 26, 68], "appreci": 15, "namer": 15, "thu": [15, 16, 26, 27, 29, 31, 46, 48, 62, 64], "progress": [15, 26, 31, 68], "deriv": [15, 19, 33, 35, 68], "three": [15, 25, 27, 31, 33, 34, 41, 42, 43, 44, 45, 46, 47, 53, 59, 62, 64, 68], "video": 15, "summar": [15, 27], "playback": 15, "faster": 15, "feel": [15, 18, 59], "m": [15, 26, 41, 42, 43, 49, 50, 54, 56], "slow": 15, "speed": 15, "fine": [15, 29, 66], "01connect": 16, "variou": [16, 18, 21, 24, 28, 37, 59, 64], "pointer": 16, "address": [16, 18], "direct": [16, 19, 42, 49, 59], "zero": [16, 18, 24, 26, 27, 31, 39, 42, 55, 56], "updat": 16, "pairwis": 16, "home": [16, 26, 48], "guarante": [16, 55], "reside_townid": [16, 21, 24, 25, 26, 27, 31, 42, 45, 46, 48, 52, 55, 62], "At": [16, 21], "referenti": 16, "integr": 16, "mouth": 16, "plain": 16, "shape": [16, 19, 23, 29, 31, 33, 41, 42, 44, 45, 47, 48, 49, 50, 51, 55, 59, 68], "varchar": 16, "townnam": [16, 26, 29], "countri": [16, 26, 29], "townnicknam": [16, 26, 29], "80": 16, "townmotto": [16, 26], "conflat": 16, "impli": [16, 19, 26, 39, 45, 66], "appropri": [16, 18], "belong": 16, "connect": [17, 19, 42], "00relat": 18, "chose": [18, 39, 51], "paramet": 18, "clearli": [18, 44, 62, 66, 68], "box": [18, 19, 29, 39, 62], "round": [18, 26], "edg": 18, "condit": [18, 19, 23, 31, 42], "insid": [18, 19, 27, 39, 42, 44, 68], "alongsid": 18, "soon": [18, 19, 31], "out": [18, 19, 25, 29, 31, 35, 36, 39, 42, 44, 46, 47, 48, 50, 55, 59, 62, 64, 67, 68], "fulli": [18, 56], "recogn": [18, 27], "except": [18, 34, 35, 44, 62, 66], "aris": [18, 27, 36], "properli": [18, 33, 55], "preach": 18, "gentli": 18, "pick": 18, "effort": 18, "worthwhil": 18, "rare": [18, 33], "congruent": 18, "ensur": [18, 24, 29, 31, 33, 34], "base": [18, 19, 23, 24, 25, 26, 27, 29, 31, 35, 37, 38, 41, 42, 43, 54, 62, 68], "shorten": [18, 24, 25, 33, 39, 51], "maintain": [18, 50], "signifi": 18, "down": [18, 29, 41, 44, 59, 67], "confid": [18, 41], "forgo": 18, "encourag": [18, 23], "throughout": [18, 21], "rather": [18, 29, 33, 34, 35, 62, 68], "shorter": [18, 23, 26], "lengthen": 18, "unlik": [18, 26], "old": [18, 26], "british": 18, "lawyer": 18, "am": [18, 48, 55, 68], "paid": 18, "subsect": 18, "constant": [18, 25, 27], "score": [18, 25, 35, 39, 64], "list": [18, 25, 26, 27, 31, 41, 42, 44], "locat": 18, "memori": 18, "third": [18, 26, 33, 34, 41, 42, 44, 46, 62, 66], "ninth": 18, "01operators_chart": 19, "partial": [19, 36], "former": [19, 26, 27], "latter": [19, 26, 27], "wast": 19, "convent": [19, 21, 44], "rectangular": 19, "arrow": [19, 33, 36, 42, 49], "bottom": [19, 67], "top": [19, 31, 39, 42, 44, 46], "label": [19, 29, 36], "alia": [19, 42], "peak": [19, 42, 44, 45, 46, 48, 49], "binari": [19, 34, 36, 42, 46, 59, 62, 68], "hous": [19, 33, 42, 44, 45, 46, 47, 48, 49], "triangl": [19, 59], "semant": 19, "corner": [19, 33, 42, 55], "pattern": [19, 24, 29, 33, 36, 39, 45, 54, 64], "discern": [19, 42, 66], "notabl": [19, 24, 25, 26, 27], "characterist": [19, 24, 25, 26, 30, 36], "unari": [19, 21, 24, 26, 27, 34, 39, 68], "sandwich": 19, "metaphor": 19, "meat": 19, "verb": [19, 25, 67], "outsid": [19, 62], "acycl": 19, "graph": 19, "procedur": 19, "exclud": 19, "loop": 19, "turn": [19, 36, 55, 64], "portion": [19, 21, 24, 39, 42, 44, 45, 50], "incomplet": 19, "00creaturedboverview": 21, "expand": 21, "simpler": 21, "heed": 21, "keep": [21, 24, 25, 26, 28, 31, 35, 36, 37, 41, 42, 55, 56, 62, 64], "copi": [21, 23, 24, 26, 28, 37, 44, 46, 48, 68], "long": [21, 23, 24, 25, 27, 35, 39, 59, 62], "provid": [21, 25, 33, 36, 42, 44, 55, 59], "insight": 21, "creaturedb": 21, "central": 21, "fiction": 21, "scenario": 21, "aspir": [21, 25, 29, 31, 34, 36, 43, 44, 47, 48, 50, 53, 59, 62], "main": [21, 24], "cast": 21, "idol_creatureid": [21, 24, 25, 26, 27, 31, 42, 51], "10": [21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "d": [21, 24, 25, 26, 27, 29, 31, 35, 39, 41, 42, 43, 46, 53, 54, 55, 59, 64], "elastigirl": [21, 24, 25, 26, 27, 42], "mv": [21, 24, 25, 26, 27, 29, 31, 39, 42, 44, 45, 59, 64], "13": [21, 24, 25, 26, 27, 29, 31, 35, 36, 39, 42, 44, 45, 46, 59, 62, 64], "david": [21, 24, 25, 26, 27, 42], "beckham": [21, 24, 25, 26, 27, 42], "le": [21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 64], "12": [21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "harri": [21, 24, 25, 26, 27, 42], "kane": [21, 24, 25, 26, 27, 42], "megan": [21, 24, 25, 26, 27, 42], "rapino": [21, 24, 25, 26, 27, 42], "sw": [21, 24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 64], "believ": [21, 68], "easier": [21, 29, 31, 35, 39, 42], "00unaryintro": 23, "whether": [23, 27, 29, 33, 37, 42, 53, 59, 64, 67], "suppli": 23, "project": [23, 27, 30, 32, 35, 36, 42, 52, 54, 59, 62], "fewer": [23, 24, 29, 39, 41, 42, 45], "reduc": [23, 30, 32, 34, 35, 39, 42, 44, 45, 50, 54, 59, 62, 64], "doesn": [23, 31], "probabl": [23, 51], "wrong": 23, "drawio": [23, 24, 26, 31, 34, 44], "templat": [23, 24, 26, 31, 34, 44, 59], "browser": [23, 24, 25, 26, 68], "googl": [23, 24, 26], "drive": [23, 24, 26], "space": [23, 24, 26, 64], "free": [23, 24], "web": [23, 24, 36], "net": [23, 24, 26, 31, 34, 36, 44], "dive": 23, "01filter": 24, "put": [24, 26, 31, 39, 44, 46, 55, 68], "pass": 24, "modifi": [24, 25, 26, 27, 36], "wide": [24, 25, 26, 27, 68], "Its": [24, 25, 26, 27, 36, 68], "height": [24, 26], "depend": [24, 25, 27, 31, 42], "relev": [24, 44], "translat": [24, 59, 66, 68], "saw": [24, 56], "renam": [24, 25, 26, 36, 41], "pose": [24, 50], "accur": [24, 27, 29, 31, 44, 66], "tab": [24, 25, 26, 29, 34, 35, 36, 39, 42, 44, 45, 46, 47, 51, 52, 59], "don": [24, 29, 31, 36, 42, 59], "explan": [24, 25, 26, 59], "fairli": [24, 25, 31, 39, 42, 43], "return": [24, 27, 59, 62], "claus": [24, 31, 36, 42, 44, 45, 52, 55, 62], "semi": [24, 42], "colon": [24, 42], "beyond": [24, 26, 68], "equal": [24, 29, 31, 41, 42, 44, 45, 46, 49, 62, 64], "inequ": 24, "greater": [24, 31, 35, 64], "resid": [24, 31, 42, 46, 47, 48, 52, 55, 62], "london": [24, 26, 48], "speech": 24, "descript": [24, 35, 59], "test_townid": [24, 27, 29, 31, 34, 35, 39, 44, 45, 55, 59, 62, 64], "2020": [24, 27, 29, 31, 39, 44, 45, 59, 64, 68], "07": [24, 27, 29, 31, 39, 44, 45, 59, 64], "21": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64], "37": [24, 27, 29, 31, 39, 44, 45, 59, 64], "53": [24, 27, 29, 31, 39, 44, 45, 59, 64], "2017": [24, 27, 29, 31, 39, 44, 45, 59, 64], "09": [24, 27, 29, 31, 39, 44, 45, 59, 64], "15": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64], "35": [24, 27, 29, 31, 39, 44, 45, 59, 64], "00": [24, 27, 29, 31, 39, 44, 45, 59, 64], "2018": [24, 27, 29, 31, 39, 44, 45, 59, 64], "2016": [24, 27, 29, 31, 39, 44, 45, 59, 64], "04": [24, 27, 29, 31, 39, 44, 45, 59, 64], "42": [24, 27, 29, 31, 39, 44, 45, 59, 64], "30": [24, 27, 29, 31, 39, 44, 45, 59, 64], "06": [24, 27, 29, 31, 39, 44, 45, 59, 64], "pk": [24, 25, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 64], "1998": [24, 27, 29, 31, 39, 44, 45, 59, 64], "08": [24, 27, 29, 31, 39, 44, 45, 59, 64], "05": [24, 27, 29, 31, 39, 44, 45, 59, 64], "2012": [24, 27, 29, 31, 39, 44, 45, 59, 64], "thr": [24, 25, 26, 27, 29, 31, 39, 42, 44, 45, 59, 62, 64], "16": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64], "b2": [24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "19": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64], "01": [24, 27, 29, 31, 39, 44, 45, 59, 64], "17": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64, 68], "18": [24, 26, 27, 29, 31, 39, 44, 45, 59, 62, 64], "tr4": [24, 25, 26, 27, 29, 31, 34, 35, 39, 42, 44, 45, 46, 59, 62, 64], "85": [24, 27, 29, 31, 35, 39, 44, 45, 46, 59, 64], "22": [24, 26, 27, 29, 31, 35, 39, 44, 45, 59, 62, 64], "d3": [24, 25, 26, 27, 29, 31, 35, 39, 42, 44, 45, 46, 59, 62, 64], "prior": 24, "august": 24, "qualifi": [24, 55, 67], "kept": [24, 41, 55], "boolean": 24, "connector": 24, "AND": [24, 35, 59], "idea": [24, 29, 59, 64], "sophist": [24, 50, 59, 68], "primit": [24, 33, 36, 37], "comparison": 24, "ones": [24, 25, 26, 27, 31, 47, 64], "exact": [24, 41, 45, 59, 60, 62], "manipul": [24, 25], "awar": [24, 41, 42], "month": [24, 66], "dai": [24, 25], "sing": 24, "overal": [24, 53], "format": [24, 68], "yyyi": 24, "mm": 24, "dd": 24, "hh": 24, "ss": 24, "great": [24, 66, 68], "advantag": 24, "regardless": [24, 27, 35], "whatev": 24, "suit": 24, "oval": 24, "style": [24, 25, 66], "clear": [24, 26, 44], "meet": 24, "per": [24, 27, 31, 39, 55, 59, 64], "draw": [24, 26, 30, 31, 33, 34, 35, 36, 44, 55, 62], "haven": [24, 26, 31, 35, 44], "hint": [24, 25], "origin_townid": [24, 25, 27, 31, 34, 42, 44, 45, 48, 62, 64], "02project": 25, "pr\u0259\u02c8jekt": 25, "stem": [25, 47, 67], "tall": [25, 26, 27], "addit": [25, 26, 34, 38, 42, 48, 55, 56, 64, 68], "carri": [25, 26, 27, 29, 64], "shortli": [25, 42, 59], "comma": [25, 26], "total": [25, 36, 43, 53, 59], "elaps": 25, "juliandai": 25, "minu": [25, 37, 38, 41, 59], "AS": [25, 36, 55, 59], "id": [25, 26, 41, 42, 53], "61": 25, "63": 25, "appeal": 25, "hopefulli": [25, 35, 55, 62], "handl": 25, "tricki": [25, 26, 29], "scope": [25, 30, 31], "averag": [25, 27, 35], "year": [25, 68], "arithmet": [25, 27], "built": 25, "manual": 25, "spend": 25, "awkward": 25, "talk": 25, "inconveni": 25, "complementari": 25, "prefer": [25, 29, 51], "specif": [25, 64], "easili": [25, 31, 42, 44, 46, 55, 64], "extrem": [25, 36, 41], "minimum": [25, 27, 31, 35, 59], "maximum": [25, 27, 31, 39], "aspiredprofici": [25, 29, 35, 46, 64], "maxprofici": [25, 27, 31, 42, 44, 45, 46, 64], "minprofici": [25, 27, 31, 42, 44, 45, 64], "crew": [25, 27, 31, 42, 44, 45, 64], "c2": [25, 27, 31, 35, 36, 42, 44, 45, 46, 52, 62, 64], "cano": [25, 27, 31, 42, 44, 45, 59, 64], "australasia": [25, 27, 31, 42, 44, 45, 59, 64], "debat": [25, 27, 31, 42, 44, 45, 59, 64], "soccer": [25, 27, 31, 42, 44, 45, 48, 59, 64], "penalti": [25, 27, 31, 42, 44, 45, 48, 59, 64], "kick": [25, 27, 31, 42, 44, 45, 48, 59, 64], "leg": [25, 26, 27, 31, 42, 44, 45, 59, 62, 64], "race": [25, 27, 31, 42, 44, 45, 59, 64], "4x100": [25, 27, 31, 34, 42, 44, 45, 59, 64], "meter": [25, 27, 31, 34, 42, 44, 45, 59, 64], "track": [25, 27, 31, 34, 36, 42, 44, 45, 59, 64], "relai": [25, 27, 31, 34, 42, 44, 45, 59, 64], "100": [25, 27, 31, 36, 42, 44, 45, 64], "03reduc": 26, "orient": [26, 53], "unless": [26, 27], "bullet": 26, "toward": [26, 31, 35, 48], "continu": [26, 36], "friend": 26, "came": 26, "seem": [26, 27, 36, 44, 48, 59], "overkil": 26, "invalu": 26, "real": 26, "hundr": 26, "longer": [26, 34, 36, 39, 42, 59], "explicit": 26, "violat": 26, "rule": [26, 66], "imagin": [26, 27, 34], "sort": 26, "bunch": 26, "absolut": 26, "necessari": [26, 31], "rolenam": [26, 29, 31, 62], "pilot": [26, 62], "speaker": [26, 62], "brakeman": [26, 62], "captain": [26, 62], "solidifi": 26, "readili": 26, "But": [26, 31, 59], "tempt": [26, 27, 31, 64], "skim": 26, "snazzier": 26, "grasp": 26, "fundament": 26, "sensit": [26, 66, 67], "unit": 26, "halloween": 26, "capit": 26, "world": [26, 67], "odin": 26, "vault": 26, "magic": 26, "scienc": [26, 59], "citi": 26, "mississippi": 26, "vallei": 26, "jolli": 26, "green": [26, 41, 59, 62], "giant": 26, "rich": 26, "grow": 26, "zenith": 26, "heart": 26, "soul": 26, "delta": 26, "food": 26, "shop": 26, "entertain": 26, "south": 26, "england": [26, 48], "kingdom": 26, "smoke": 26, "domin": 26, "dirig": 26, "nos": 26, "metrovil": [26, 59], "incred": 26, "stand": 26, "pa": 26, "brotherli": 26, "love": 26, "endur": 26, "seattl": 26, "washington": 26, "emerald": 26, "goodwil": 26, "kanto": 26, "japan": 26, "drawn": [26, 34, 42], "conveni": [26, 33, 34, 55, 59], "necess": 26, "neither": [26, 29, 35], "somewher": 26, "elimin": [26, 42, 44, 45, 52, 55, 62], "render": 26, "though": [26, 27, 31, 46, 50], "restraint": 26, "04group": 27, "fourth": [27, 33], "calcul": 27, "aggreg": [27, 31, 67], "statist": 27, "review": [27, 31, 42], "circumst": [27, 28, 37, 44, 45, 47, 48, 54, 63], "partit": 27, "count": [27, 29, 31, 36, 42, 55, 59], "achievementcount": 27, "sum": 27, "varianc": 27, "deviat": 27, "horizont": 27, "numproficiencyvalu": 27, "scalar": 27, "vertic": 27, "arrai": 27, "vector": 27, "failur": 27, "emerg": 27, "cover": [27, 55, 68], "visibl": 27, "lurk": 27, "twice": [27, 39, 62], "parenthes": [27, 34, 39, 41], "contempl": 27, "scroll": [27, 31, 51], "max": 27, "min": 27, "highli": 27, "quit": [27, 31, 36, 49, 55, 59, 66], "entir": 27, "mislead": 27, "realli": [27, 31, 55], "potenti": [27, 47, 62], "test": [27, 47, 52, 55, 59, 62], "origintownid": 27, "residetownid": 27, "highest": 27, "maximumprofici": 27, "lowest": 27, "Then": [27, 29, 33, 39, 55, 56, 66], "05unaryframework": 28, "framework": [28, 37, 54], "document": [28, 37], "06unaryexercis": 29, "button": 29, "click": 29, "imag": [29, 41], "check": [29, 31, 39, 45, 64], "haw": 29, "versu": 29, "collaps": 29, "pleas": [29, 31], "fill": [29, 31, 46, 59], "blank": [29, 31, 59], "straightforward": [29, 36, 43, 49, 62], "bad": [29, 30, 31], "possibli": [29, 55, 59], "squar": 29, "creaturecount": 29, "achievementprofici": 29, "rolecount": 29, "contributionrolenam": 29, "averageteams": 29, "towncountri": 29, "he": [29, 31, 55, 59, 64, 68], "26": 29, "h": 29, "27": 29, "28": 29, "sensic": 29, "countofachievedskil": 29, "townoffirstachievedskil": 29, "achievingcreatur": 29, "middl": [29, 55], "remind": [29, 33], "j": 29, "test_town": 29, "31": 29, "basic": [29, 59, 68], "introduct": [30, 38, 54], "danger": 30, "over": [30, 31, 41, 42, 54, 56, 58, 66], "00unarycombo": 31, "categori": [31, 42, 68], "head": 31, "guid": [31, 34, 35, 44, 59, 66, 68], "BY": [31, 55, 59], "un": 31, "skillcodecount": 31, "poor": [31, 64, 67], "mistak": 31, "plural": [31, 67], "lost": 31, "similar": [31, 34, 35, 51, 52, 55, 62, 64], "envis": 31, "interpret": [31, 39, 54, 64], "achievementd": 31, "nearbi": [31, 35], "comment": 31, "method": [31, 59], "around": 31, "uncom": 31, "jump": 31, "straight": 31, "skip": 31, "enough": [31, 42, 66], "temptat": 31, "argu": 31, "scratch": 31, "paper": 31, "electron": [31, 41], "pad": 31, "observ": [31, 42], "figur": 31, "spin": 31, "wheel": 31, "senseless": 31, "reaction": 31, "move": [31, 36], "00setintro": 33, "speak": [33, 66], "theori": [33, 55, 68], "overlook": 33, "soak": 33, "ever": 33, "matter": [33, 37], "upper": [33, 55], "half": [33, 42, 44, 45, 46, 48, 49, 62], "symmetri": [33, 37, 41, 43, 44, 47, 50, 53, 54], "cartesian": [33, 36], "plu": [33, 36], "full": [33, 41, 42, 44, 47, 55, 59, 64, 68], "wider": 33, "basi": [33, 36, 42, 62], "subsequ": [33, 55], "action": [33, 55], "visual": [33, 35, 38, 39, 62, 68], "decidedli": 33, "01unionintersectminussimpl": 34, "symmetr": [34, 37, 38, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 53], "oracl": [34, 68], "mysql": [34, 68], "job": [34, 39], "IN": 34, "known": [34, 48], "inner": [34, 44, 45, 47, 55], "relay4x100creatur": 34, "garglingcreatur": 34, "send": 34, "op": [34, 37], "dowload": [34, 44], "unachiev": [34, 35], "02unionintersectminusadvanc": 35, "relation": 35, "desired_townid": [35, 46, 64], "nearli": 35, "ident": 35, "compat": 35, "achievedskillintownwithprofici": 35, "highlight": [35, 41, 47], "sketch": 35, "OR": 35, "BUT": 35, "nor": 35, "area": 35, "03time": 36, "power": [36, 39, 59, 62, 64], "mere": 36, "juxtapos": [36, 41], "against": [36, 59], "cross": 36, "theorist": 36, "underpin": 36, "hear": 36, "wow": 36, "door": 36, "amazingli": 36, "univers": [36, 59], "embed": 36, "preval": [36, 41, 47], "odd": 36, "challeng": 36, "tag": [36, 41, 42], "essenti": [36, 55], "c1": [36, 62], "169": 36, "truncat": 36, "convinc": 36, "rephras": [36, 45], "creature1": 36, "creature2": 36, "catch": 36, "appar": [36, 44, 46], "04setopsframework": 37, "union": [38, 42, 49, 55], "00timesfilterreduceex": 39, "interlud": 39, "farther": 39, "longest": 39, "demonstr": 39, "wouldn": 39, "forward": 39, "bigger": 39, "favorit": 39, "editor": 39, "attain": 39, "debug": 39, "00mjintro": 41, "emphas": [41, 59], "simplifi": 41, "character": 41, "scheme": 41, "disjoint": [41, 42, 44, 53], "bid": [41, 42, 43, 53, 54, 55, 56], "front": 41, "five": 41, "card": 41, "notebook": 41, "handi": [41, 44], "memor": 41, "01circumst": 42, "fall": [42, 62, 64], "attempt": [42, 68], "goe": [42, 55], "side": [42, 44, 46, 55], "roof": [42, 55], "discuss": [42, 49, 66], "x": 42, "y": 42, "goal": [42, 62], "true": 42, "forget": 42, "verifi": [42, 55, 68], "ll": 42, "luckili": 42, "outlin": 42, "02tableofcircumst": 43, "seven": 43, "nine": [43, 53], "col": [43, 54], "proce": 43, "tast": 43, "motiv": [43, 47], "03differentbase_m_1_1": 44, "frequent": 44, "symmtric": 44, "db": [44, 46], "succinct": 44, "tradit": [44, 45], "ON": [44, 59], "dbmss": 44, "infer": 44, "omit": 44, "useabl": 44, "nice": 44, "aspiredcontribut": [44, 46, 47], "04differentbase_m_1_2": 45, "Or": [45, 67], "close": [45, 59], "peski": 45, "05differentbase_m_1_3": 46, "pertain": [46, 47], "color": 46, "origin_towndid": 46, "obvious": 46, "led": [46, 47], "backward": 46, "branch": 46, "pull": [46, 48], "emsod": [46, 47], "06differentbase_m_m": 47, "previous": 47, "center": 47, "yellow": [47, 62], "becam": 47, "07samebase_1_1_m_m": 48, "live": [48, 62], "ski": 48, "minnesota": 48, "perfect": 48, "footbal": 48, "Being": 48, "star": 48, "contriv": 48, "recommend": 48, "trickier": 48, "inspir": 48, "08samebase_1_1_e_": 49, "referenc": 49, "09samebase_1_1": 50, "parallel": 50, "propos": [50, 60], "10samerelation_m_1": 51, "idol": 51, "reflex": 51, "pare": 51, "11samerelation_m_m": 52, "12matchjoinframework": 53, "recap": 54, "01outerjoin": 55, "creaturenjachiev": 55, "nomenclatur": 55, "unabl": 55, "him": 55, "hi": [55, 59, 68], "flip": [55, 56], "swap": [55, 56], "counterpart": 55, "indictor": 55, "creaureid": 55, "tri": 55, "creaturelojachievement_w": 55, "unusu": 55, "util": 55, "happenst": 55, "vision": 55, "literatur": 55, "curiou": 55, "02ojgener": 56, "outer": [56, 59, 68], "finish": 56, "w": 56, "notusedojtest": 57, "rescu": 58, "outerjoin": 58, "01divid": 59, "edgar": 59, "ted": 59, "codd": 59, "inventor": 59, "adventur": 59, "fit": 59, "defer": 59, "creator": 59, "outstand": 59, "stood": 59, "http": 59, "en": 59, "org": 59, "wiki": 59, "relational_algebra": 59, "1970": 59, "bank": 59, "acm": 59, "377": 59, "387": 59, "doi": 59, "1145": 59, "362384": 59, "362685": 59, "www": 59, "sea": 59, "upenn": 59, "edu": 59, "zive": 59, "03f": 59, "cis550": 59, "pdf": 59, "edgar_f": 59, "_codd": 59, "complic": 59, "nonetheless": 59, "seri": 59, "principl": 59, "ultim": 59, "brand": 59, "typic": [59, 62, 68], "survivor": 59, "obtus": 59, "constitut": [59, 64, 67], "met": 59, "criteria": 59, "ye": 59, "chosen": 59, "bold": 59, "compact": [59, 62], "break": 59, "nest": 59, "popular": 59, "col1_of_input": 59, "fulfil": 59, "col_of_pattern": 59, "in1": 59, "in2": 59, "col_of_input": 59, "unpack": 59, "minor": 59, "accordingli": 59, "hardest": 59, "p1": 59, "player": 59, "spokesperson": 59, "club": 59, "encumb": 59, "block": 59, "enjoi": 59, "articl": 59, "joe": 59, "celko": 59, "superman": 59, "notuseddivide_test": 60, "divis": 60, "01comparejoin": 62, "largest": 62, "rdbm": 62, "unsettl": 62, "particularli": 62, "unsatisfactori": 62, "entri": 62, "matrix": 62, "stuck": 62, "valid": 62, "train": 62, "partner": 62, "mentor": 62, "mente": 62, "coupl": [62, 67], "bow": 62, "paddler": 62, "stern": 62, "io": 62, "variat": 63, "01categoryrel": 64, "divid": [64, 68], "assist": 64, "ourselv": 64, "fair": 64, "swimmer": 64, "man": 64, "rang": [64, 68], "codifi": 64, "consult": [64, 68], "low": 64, "high": [64, 66], "glimps": 64, "distribut": 64, "suffici": 64, "gargling_categori": 64, "late": 64, "00ww_intro": 66, "request": [66, 67], "vagu": [66, 67], "inaccuraci": 66, "concert": 66, "everydai": 66, "discours": 66, "strictli": 66, "contract": 66, "agre": 66, "vagari": 66, "inher": 66, "rigid": 66, "judgment": 66, "revisit": 66, "insensit": 66, "me": [66, 68], "dismai": 66, "otherwis": 66, "invit": 66, "parti": 66, "pedant": 66, "she": 66, "conclud": 66, "smart": 66, "deserv": 66, "salari": 66, "refin": 66, "picki": 66, "emploi": 66, "01narr": 67, "misunderstand": 67, "unfamiliar": 67, "vocabulari": 67, "floater": 67, "pin": 67, "collid": 67, "scientist": 67, "biologi": 67, "xyphoid": 67, "sternum": 67, "invent": 67, "primatologist": 67, "chimp": 67, "nativ": 67, "habitat": 67, "januari": 67, "1977": 67, "libbi": 68, "shoop": 68, "macalest": 68, "colleg": 68, "saint": 68, "paul": 68, "2019": 68, "accompani": 68, "activ": 68, "life": 68, "substitut": 68, "begun": 68, "hand": 68, "strongli": 68, "techniqu": 68, "increasingli": 68, "postgr": 68, "instal": 68, "server": 68, "virtual": 68, "desktop": 68, "laptop": 68, "exhaust": 68, "piec": 68, "instructor": 68, "semest": 68, "nosql": 68, "drop": 68, "deal": 68, "audienc": 68, "undergradu": 68, "graduat": 68, "unpublish": 68, "manuscript": 68, "entitl": 68, "2015": 68, "death": 68, "edit": 68, "onlin": 68, "interleav": 68, "professor": 68, "copyright": 68, "1999": 68, "elizabeth": 68, "reserv": 68, "extend": 68, "brad": 68, "miller": 68, "runeston": 68, "interact": 68, "platform": 68, "happi": 68, "yiyi": 68, "yuan": 68}, "objects": {}, "objtypes": {}, "objnames": {}, "titleterms": {"brief": 0, "background": 0, "conceptu": [0, 1, 68], "data": [0, 1, 2, 5, 6, 11, 15, 17, 22, 64, 65, 68], "model": [0, 1, 3, 68], "transit": 0, "from": [0, 3, 68], "implement": [0, 5, 7, 9, 10], "beyond": 1, "begin": [1, 2, 11], "add": 1, "how": [1, 2, 14, 42], "what": [1, 4, 12, 18, 36, 62, 63, 68], "One": [2, 3, 6, 30], "entiti": [2, 3, 5, 7, 10], "shape": [2, 3, 5, 6, 7, 8, 9, 10], "consid": [2, 31, 41, 42, 45], "creatur": [2, 5, 21, 24, 25, 26, 27, 42], "instanc": [2, 3, 5], "tabl": [2, 5, 11, 68], "creation": [2, 68], "popul": [2, 5], "try": [2, 44, 46, 47, 52, 59, 62, 64], "yourself": [2, 59], "start": 3, "basic": 3, "we": [4, 12, 20, 22, 54, 62, 63], "have": 4, "seen": 4, "so": 4, "far": 4, "two": [5, 7, 59], "relat": [5, 11, 12, 14, 15, 16, 17, 18, 20, 26, 30, 36, 41, 51, 52, 53, 64, 65, 68], "databas": [5, 14, 15, 21, 22, 68], "creat": 5, "new": [5, 64], "town": [5, 26], "re": 5, "through": 5, "gotcha": 5, "peek": 5, "ahead": 5, "natur": [5, 24], "join": [5, 41, 42, 43, 53, 54, 55, 57, 58, 62, 63], "relationship": [6, 7, 10], "some": [6, 25, 35], "note": [6, 25], "about": [6, 24, 25, 26, 33], "The": [8, 9, 12, 15, 17, 24, 30, 38, 41, 43, 54, 58, 61], "chicken": [8, 9, 53], "feet": [8, 9, 53], "an": [8, 9, 14, 34, 39, 41], "intersect": [8, 9, 33, 34, 35], "arbitrari": 8, "identifi": 8, "summari": [8, 12, 15, 27, 28, 37], "concept": 8, "introduc": 8, "three": 10, "master": [11, 68], "analysi": [11, 12, 14, 22], "v": 11, "achiev": [11, 24, 27, 29, 31, 39, 44, 45, 59, 64], "algebra": [11, 12, 68], "diagram": 11, "mean": 12, "queri": [12, 14, 31, 35, 44, 46, 47, 52, 62, 64, 67, 68], "role": 12, "sql": [12, 31, 68], "end": 12, "product": 12, "initi": 12, "tool": 12, "practic": [12, 31], "disciplin": 12, "plan": 12, "instead": 12, "doe": 12, "big": 12, "pictur": 12, "recip": [13, 15], "stuff": 13, "think": [14, 26], "like": [14, 27, 38], "analyst": 14, "essenc": 15, "defin": 15, "connect": 16, "between": [16, 53], "most": [17, 54], "import": [17, 33], "notion": 17, "gain": 17, "masteri": 17, "input": [18, 30, 36, 41], "output": 18, "result": [18, 26], "i": [18, 26, 27, 36, 68], "preced": [19, 20], "chart": [19, 20, 23], "oper": [20, 23, 25, 26, 28, 29, 30, 31, 32, 33, 37, 38, 41, 54, 58, 59, 61], "outlin": 20, "journei": 20, "take": 20, "A": [21, 22, 24, 40, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55, 56, 62], "small": [21, 22], "exampl": [21, 22, 24, 25, 26, 27, 34, 35, 36, 40, 55, 60], "us": [22, 31, 35, 39, 40], "unari": [23, 28, 29, 30, 31, 32], "introduct": [23, 33, 41], "draw": 23, "filter": [24, 29, 31, 41], "simpl": 24, "condit": 24, "anoth": [24, 33], "combin": [24, 31, 32, 39, 41], "scope": 24, "date": 24, "datatyp": 24, "dbm": 24, "word": 24, "phrase": 24, "exercis": [24, 25, 26, 27, 29, 31, 34, 35, 36, 45, 48, 59], "project": [25, 26, 29, 31, 41], "column": [25, 26, 27, 35, 41, 42, 53, 55], "comput": [25, 26], "skill": [25, 27, 31, 42, 44, 45, 64], "reduc": [26, 27, 29, 31, 41], "let": [26, 58], "": [26, 46, 58, 60], "thi": [26, 43, 53, 68], "contribut": [26, 62], "compar": [26, 62, 63], "name": 26, "bad": [26, 27], "case": [26, 27, 58], "danger": [26, 27], "ar": 26, "group": [27, 29, 31], "1": [27, 36, 44, 45, 46, 48, 49, 50, 51, 53, 68], "over": [27, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 55], "one": 27, "2": [27, 36, 68], "multipl": 27, "3": 27, "characterist": 27, "more": [27, 59], "after": [31, 62, 63], "follow": [31, 40], "befor": 31, "first": [31, 54, 55], "avoid": 31, "non": [31, 33], "work": [31, 41, 42, 53, 66], "ad": [32, 61], "bit": 32, "complex": [32, 35, 54], "binari": [33, 37, 38, 54], "set": [33, 37, 38], "union": [33, 34, 35], "symmetr": 33, "minu": [33, 34, 35], "point": 33, "time": [33, 36, 41, 62, 63], "simplest": 34, "visual": 34, "aspir": [35, 46, 64], "all": 35, "addit": 35, "differ": [36, 38, 44, 45, 46, 47, 50, 53], "base": [36, 44, 45, 46, 47, 48, 49, 50, 53], "same": [36, 48, 49, 50, 51, 52, 53], "mathemat": 38, "often": 39, "put": 40, "piec": 40, "togeth": 40, "larger": 40, "well": 40, "pattern": [40, 41, 59, 61], "match": [41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 59, 61], "abstract": 41, "being": 41, "possibl": [41, 42, 53], "circumst": [42, 43, 53, 62], "For": [42, 43, 53], "symmetri": 42, "aspect": 42, "recap": 42, "common": [43, 54], "In": [43, 53], "chapter": [43, 53], "b": [44, 45, 46, 47, 48, 49, 50, 51, 52, 53], "m": [44, 45, 46, 47, 48, 51, 52, 53], "col": [44, 45, 46, 47, 48, 49, 50, 51, 52, 53], "aid": [44, 45, 46, 47, 48, 49, 50, 51, 52, 65], "d": [44, 45, 47, 51, 52], "bid": [44, 45, 46, 47, 48, 49, 50, 51, 52], "e": [44, 46, 49, 50, 51], "other": [44, 46, 47, 52, 62, 64], "null": 45, "valu": 45, "interpret": 50, "framework": 53, "itself": 53, "studi": 54, "outer": [55, 57, 58], "our": 55, "rescu": 55, "second": 55, "extra": 55, "right": 55, "both": 55, "gener": 56, "version": 56, "outerjoin": 56, "test": 57, "includ": 58, "those": 58, "degener": 58, "divid": [59, 61], "type": 59, "origin": 59, "least": 59, "exactli": 59, "less": 59, "joe": 60, "celko": 60, "page": 60, "sophist": 61, "variat": 62, "can": [62, 63], "do": [62, 63], "also": 62, "appli": 62, "aspiredcontribut": 62, "els": 63, "categori": [64, 65], "make": [64, 65], "miss": 64, "inform": 64, "analys": 65, "wai": [66, 67], "form": 67, "narr": 67, "mislead": 67, "book": 68, "part": 68, "content": 68, "recognit": 68, "thank": 68}, "envversion": {"sphinx.domains.c": 2, "sphinx.domains.changeset": 1, "sphinx.domains.citation": 1, "sphinx.domains.cpp": 8, "sphinx.domains.index": 1, "sphinx.domains.javascript": 2, "sphinx.domains.math": 2, "sphinx.domains.python": 3, "sphinx.domains.rst": 2, "sphinx.domains.std": 2, "sphinx": 57}, "alltitles": {"Brief Background of Conceptual Data Modeling": [[0, "brief-background-of-conceptual-data-modeling"]], "Transition from Conceptual Models to Implementation": [[0, "transition-from-conceptual-models-to-implementation"]], "Beyond Conceptual Data Modeling": [[1, "beyond-conceptual-data-modeling"]], "Beginning to add 'how' to the what": [[1, null]], "One-entity shapes: begin to consider \u2018how\u2019": [[2, "one-entity-shapes-begin-to-consider-how"]], "Creature Data Instances": [[2, "creature-data-instances"]], "Creature table creation": [[2, "creature-table-creation"]], "Populate Creature table with data instances": [[2, "populate-creature-table-with-data-instances"], [5, "populate-creature-table-with-data-instances"]], "Try it yourself": [[2, "try-it-yourself"]], "From model to instances: One-entity shapes": [[3, "from-model-to-instances-one-entity-shapes"]], "Start with the basics": [[3, null]], "What we have seen so far": [[4, "what-we-have-seen-so-far"]], "Implementing Two-entity Shapes in relational databases": [[5, "implementing-two-entity-shapes-in-relational-databases"]], "Create the new Town Table": [[5, "create-the-new-town-table"]], "Populate Town table with data instances": [[5, "populate-town-table-with-data-instances"]], "Re-create a new Creature table": [[5, "re-create-a-new-creature-table"]], "Relating instances through data": [[5, "relating-instances-through-data"]], "Gotcha!": [[5, null]], "Peek ahead: natural join": [[5, "peek-ahead-natural-join"]], "One-One to-be relationship Shape": [[6, "one-one-to-be-relationship-shape"]], "Some Notes about shape and data": [[6, "some-notes-about-shape-and-data"]], "Implementing relationships: Two-entity shapes": [[7, "implementing-relationships-two-entity-shapes"]], "Two-entity shapes": [[7, null]], "The Chicken-feet-in Shape: an intersection with arbitrary identifier": [[8, "the-chicken-feet-in-shape-an-intersection-with-arbitrary-identifier"]], "Summary of Concepts Introduced": [[8, "summary-of-concepts-introduced"]], "The Chicken-feet-in Shape: implementing an intersection": [[9, "the-chicken-feet-in-shape-implementing-an-intersection"]], "Implementing relationships: Three-entity shapes": [[10, "implementing-relationships-three-entity-shapes"]], "Three-entity shapes": [[10, null]], "Mastering relational data analysis": [[11, "mastering-relational-data-analysis"]], "Relations vs. Tables": [[11, "relations-vs-tables"]], "Achievement": [[11, "id1"], [24, "id2"], [27, "id1"], [29, "id1"], [29, "id2"], [29, "id3"], [31, "id2"], [39, "id1"], [44, "id1"], [45, "id1"], [59, "id7"], [64, "id3"]], "Beginning Analysis  with relational algebra diagrams": [[11, "beginning-analysis-with-relational-algebra-diagrams"]], "What We Mean by Querying and Analysis": [[12, "what-we-mean-by-querying-and-analysis"]], "The Role of SQL: the end product, not the initial tool": [[12, "the-role-of-sql-the-end-product-not-the-initial-tool"]], "Practice Discipline and Planning Instead": [[12, "practice-discipline-and-planning-instead"]], "What does \u201cRelational Algebra\u201d mean?": [[12, "what-does-relational-algebra-mean"]], "The Big Picture Summary": [[12, "the-big-picture-summary"]], "recipe-stuff": [[13, "id1"], [13, "id2"]], "Relational Databases, Querying, and Analysis": [[14, "relational-databases-querying-and-analysis"]], "How to think like an analyst": [[14, null]], "The Essence of Relational Databases": [[15, "the-essence-of-relational-databases"]], "Data in Relations": [[15, "data-in-relations"]], "Relation Defined": [[15, "relation-defined"]], "Recipe": [[15, "id1"]], "Summary": [[15, "summary"]], "Connections between Relations": [[16, "connections-between-relations"]], "Relational Data": [[17, "relational-data"]], "The most important notions for gaining mastery": [[17, null]], "Relations as input and output": [[18, "relations-as-input-and-output"]], "What the result relation is": [[18, "what-the-result-relation-is"]], "What the result is not": [[18, "what-the-result-is-not"]], "Precedence Charts": [[19, "precedence-charts"]], "Relational Operations and Precedence Charts": [[20, "relational-operations-and-precedence-charts"]], "Outlining the journey we will take": [[20, null]], "A small example database": [[21, "a-small-example-database"]], "Creature": [[21, "id1"], [24, "id1"], [25, "id1"], [26, "id1"], [27, "id2"], [42, "id5"]], "A Small Example Database": [[22, "a-small-example-database"]], "Data we will use for analysis": [[22, null]], "Unary Operator Introduction": [[23, "unary-operator-introduction"]], "Drawing Charts": [[23, "drawing-charts"]], "Filter": [[24, "filter"], [29, "filter"]], "Examples": [[24, "examples"], [25, "examples"]], "A simple condition": [[24, "a-simple-condition"]], "Another simple condition": [[24, "another-simple-condition"]], "Combining conditions": [[24, "combining-conditions"]], "The Scope and Nature of Filter": [[24, "the-scope-and-nature-of-filter"]], "Date datatype in DBMS": [[24, "date-datatype-in-dbms"]], "A word about phrasing": [[24, "a-word-about-phrasing"]], "Exercises": [[24, "exercises"], [25, "exercises"], [26, "exercises"], [27, "exercises"], [31, "exercises"], [34, "exercises"], [36, "exercises"], [59, "exercises"]], "Project": [[25, "project"], [29, "project"]], "Project some of the columns": [[25, "project-some-of-the-columns"]], "Projecting computed columns": [[25, "projecting-computed-columns"]], "Some notes about the project operator": [[25, "some-notes-about-the-project-operator"]], "Skill": [[25, "id2"], [27, "id3"], [31, "id1"], [42, "id6"], [44, "id2"], [45, "id2"], [45, "id3"], [64, "id1"]], "Reduce": [[26, "reduce"], [29, "reduce"]], "Example": [[26, "example"]], "Let\u2019s think about this operator": [[26, "let-s-think-about-this-operator"]], "Contribution": [[26, "id2"], [62, "id1"]], "Comparing Reduce to Project": [[26, "comparing-reduce-to-project"]], "Naming the result relation": [[26, "naming-the-result-relation"]], "Bad Case: Reduce is dangerous!": [[26, "bad-case-reduce-is-dangerous"]], "Town": [[26, "id3"]], "Bad Case: Computed columns in Reduce are dangerous.": [[26, "bad-case-computed-columns-in-reduce-are-dangerous"]], "Group": [[27, "group"], [29, "group"]], "Example 1: Group over one column": [[27, "example-1-group-over-one-column"]], "Example 2: Group over multiple columns": [[27, "example-2-group-over-multiple-columns"]], "Example 3: Group over no columns": [[27, "example-3-group-over-no-columns"]], "Summary of Group Characteristics": [[27, "summary-of-group-characteristics"]], "Group over no columns": [[27, "group-over-no-columns"]], "Group over one or more columns": [[27, "group-over-one-or-more-columns"]], "Bad Cases: Group, like Reduce, is dangerous!": [[27, "bad-cases-group-like-reduce-is-dangerous"]], "Summary of Unary Operators": [[28, "summary-of-unary-operators"]], "Exercises for Unary Operators": [[29, "exercises-for-unary-operators"]], "The Unary Operators": [[30, "the-unary-operators"]], "One relation as input": [[30, null]], "Combination Queries to Consider After Unary Operators": [[31, "combination-queries-to-consider-after-unary-operators"]], "Filter followed by Reduce": [[31, "filter-followed-by-reduce"]], "Filter followed by Project": [[31, "filter-followed-by-project"]], "Filter before a Group": [[31, "filter-before-a-group"]], "Reduce first, then Group": [[31, "reduce-first-then-group"]], "Group followed by Group": [[31, "group-followed-by-group"]], "Group then Filter": [[31, "group-then-filter"]], "Avoid non-useful work": [[31, "avoid-non-useful-work"]], "SQL Practice for Combination Queries": [[31, "sql-practice-for-combination-queries"]], "Combining the Unary Operators": [[32, "combining-the-unary-operators"]], "Adding a bit of complexity": [[32, null]], "Introduction to the Binary Set Operations": [[33, "introduction-to-the-binary-set-operations"]], "Union and Intersect: the Symmetric Operators": [[33, "union-and-intersect-the-symmetric-operators"]], "Minus: the Non-Symmetric Operator": [[33, "minus-the-non-symmetric-operator"]], "Important Points about Union, Intersect, and Minus": [[33, "important-points-about-union-intersect-and-minus"]], "Times, another Symmetric Operator": [[33, "times-another-symmetric-operator"]], "Simplest Examples of Union, Intersect, and Minus": [[34, "simplest-examples-of-union-intersect-and-minus"]], "Visualize an Example": [[34, "visualize-an-example"]], "Union example": [[34, "union-example"]], "Intersect example": [[34, "intersect-example"]], "Minus examples": [[34, "minus-examples"]], "Complex Examples of Union, Intersect, and Minus": [[35, "complex-examples-of-union-intersect-and-minus"]], "Aspiration": [[35, "id1"], [46, "id1"], [64, "id2"]], "Queries using all columns": [[35, "queries-using-all-columns"]], "Exercise": [[35, "exercise"], [45, "exercise"], [48, "exercise"]], "Queries with some, but not all columns": [[35, "queries-with-some-but-not-all-columns"]], "Additional Exercises": [[35, "additional-exercises"]], "Times": [[36, "times"]], "Example 1: different bases as input relations": [[36, "example-1-different-bases-as-input-relations"]], "Example 2: Same relation inputs": [[36, "example-2-same-relation-inputs"]], "What is the base?": [[36, "what-is-the-base"]], "Summary of Binary Set Operators": [[37, "summary-of-binary-set-operators"]], "The Binary Set Operators": [[38, "the-binary-set-operators"]], "Like mathematical sets, but different": [[38, null]], "An often-used Combination": [[39, "an-often-used-combination"]], "Putting pieces together": [[40, "putting-pieces-together"]], "A larger example that follows a well-used pattern": [[40, null]], "Introduction to Match Join": [[41, "introduction-to-match-join"]], "Times - Filter - Reduce/Project Pattern": [[41, "times-filter-reduce-project-pattern"]], "The Match Join Operator: an abstract combination": [[41, "the-match-join-operator-an-abstract-combination"]], "Considering input relations and the columns being matched": [[41, "considering-input-relations-and-the-columns-being-matched"]], "Works-on column possibilities for Match Join": [[41, "id1"], [42, "id4"], [53, "id1"]], "Circumstances For Match Joins": [[42, "circumstances-for-match-joins"]], "How to consider the Symmetry Aspect": [[42, "how-to-consider-the-symmetry-aspect"]], "Recap": [[42, "recap"]], "The Common Circumstances": [[43, "the-common-circumstances"]], "Circumstances For Match Joins In this Chapter": [[43, "id1"], [53, "id2"]], "Different Base A and B, M - 1 match over cols Aid(D), Bid(E)": [[44, "different-base-a-and-b-m-1-match-over-cols-aid-d-bid-e"]], "Other Queries to try": [[44, "other-queries-to-try"]], "Different Base A and B, M - 1 match over cols Aid(D),Bid(M)": [[45, "different-base-a-and-b-m-1-match-over-cols-aid-d-bid-m"]], "Considering NULL values": [[45, "considering-null-values"]], "Different Base A and B, M - 1 match over cols Aid(S),Bid(E)": [[46, "different-base-a-and-b-m-1-match-over-cols-aid-s-bid-e"]], "Other Queries to try:": [[46, "other-queries-to-try"], [47, "other-queries-to-try"], [52, "other-queries-to-try"], [64, "other-queries-to-try"]], "Different Base A and B, M - M match over cols Aid(D),Bid(D)": [[47, "different-base-a-and-b-m-m-match-over-cols-aid-d-bid-d"]], "Same Base A and B, 1 - 1 match over cols Aid(M),Bid(M)": [[48, "same-base-a-and-b-1-1-match-over-cols-aid-m-bid-m"]], "Same Base A and B, 1 - 1 match over cols Aid(E),Bid(E)": [[49, "same-base-a-and-b-1-1-match-over-cols-aid-e-bid-e"], [50, "same-base-a-and-b-1-1-match-over-cols-aid-e-bid-e"]], "A Different Interpretation": [[50, "a-different-interpretation"]], "Same Relation A and B, M - 1 match over cols Aid(D),Bid(E)": [[51, "same-relation-a-and-b-m-1-match-over-cols-aid-d-bid-e"]], "Same Relation A and B, M - M match over cols Aid(D),Bid(D)": [[52, "same-relation-a-and-b-m-m-match-over-cols-aid-d-bid-d"]], "Match Join Framework": [[53, "match-join-framework"]], "M - 1 match over cols between Different Base A and B": [[53, "m-1-match-over-cols-between-different-base-a-and-b"]], "M - M match over cols between Different Base A, B": [[53, "m-m-match-over-cols-between-different-base-a-b"]], "1 - 1 match over cols between Same Base A, B: chicken feet in": [[53, "match-over-cols-between-same-base-a-b-chicken-feet-in"]], "1 - 1 match over cols between Same Base A and B": [[53, "match-over-cols-between-same-base-a-and-b"]], "M - 1 match over cols between A and itself (Same Relation)": [[53, "m-1-match-over-cols-between-a-and-itself-same-relation"]], "M - M match over cols between A and itself (Same Relation)": [[53, "m-m-match-over-cols-between-a-and-itself-same-relation"]], "The Match Join Operator": [[54, "the-match-join-operator"]], "The most common operation, and the first of the complex binary operators that we will study.": [[54, null]], "Outer Join by Examples": [[55, "outer-join-by-examples"]], "Our first Example: Outer Join to the Rescue": [[55, "our-first-example-outer-join-to-the-rescue"]], "A second Example: over extra columns": [[55, "a-second-example-over-extra-columns"]], "Right Outer Join": [[55, "right-outer-join"]], "Both Outer Join": [[55, "both-outer-join"]], "A Generic Version of OuterJoin": [[56, "a-generic-version-of-outerjoin"]], "Test of Outer Join": [[57, "test-of-outer-join"]], "The Outer Join Operator": [[58, "the-outer-join-operator"]], "Let's include those degenerate cases": [[58, null]], "Divide Operator: two types": [[59, "divide-operator-two-types"]], "Divide, originally: \u201cmatches at least\u201d": [[59, "divide-originally-matches-at-least"]], "Exactly Divide: matching the pattern exactly (no more, no less)": [[59, "exactly-divide-matching-the-pattern-exactly-no-more-no-less"]], "Try yourself": [[59, "try-yourself"]], "Joe Celko\u2019s page examples": [[60, "joe-celko-s-page-examples"]], "The Divide Operator": [[61, "the-divide-operator"]], "Adding sophistication: pattern matching": [[61, null]], "A Variation: Compare Join": [[62, "a-variation-compare-join"]], "What can we do after a Times?": [[62, "what-can-we-do-after-a-times"]], "Other Circumstances also Apply": [[62, "other-circumstances-also-apply"]], "AspiredContribution": [[62, "id2"]], "Queries to try": [[62, "queries-to-try"]], "Compare Join": [[63, "compare-join"]], "What else we can do after a times": [[63, null]], "Category Relations": [[64, "category-relations"], [65, "category-relations"]], "Making missing information new data": [[64, "making-missing-information-new-data"]], "Making data to aid analyses": [[65, null]], "Ways of Work": [[66, "ways-of-work"]], "Ways of Forming Query Narratives": [[67, "ways-of-forming-query-narratives"]], "Misleading Narratives": [[67, "misleading-narratives"]], "Mastering Relational Databases: from Models to Querying": [[68, "mastering-relational-databases-from-models-to-querying"]], "What this book is for": [[68, "what-this-book-is-for"]], "What this book is not": [[68, "what-this-book-is-not"]], "Part 1: From conceptual models to SQL data creation": [[68, "part-1-from-conceptual-models-to-sql-data-creation"]], "Part 2: Mastering Database Querying with Relational Algebra and SQL": [[68, "part-2-mastering-database-querying-with-relational-algebra-and-sql"]], "Table of Contents": [[68, "table-of-contents"]], "Recognition and Thanks": [[68, "recognition-and-thanks"]]}, "indexentries": {}})