230 likes | 324 Views
Content Analysis. What the information wants. Modeling Exercise.
E N D
Content Analysis What the information wants
Modeling Exercise http://www.apartments.com/rent/Seattle-WA/Ava-Queen-Anne/102736.268?SearchCriteria=oTJ2f0Fp6Qg63H3Fcab38mhtprSVA0iTAXrzW9Yg9xrAiT9ATGcP-|uYFiZ-|RA3LFgFffma63tYsqmEbtofbSi2Gtce0/2ej6gahDREv7JJv8sU9ZO2CxRcZJih5ogLVVdSKWFJLI6Q085BaQvgmhkstfbWqiCR/2crmrDzjY3DTcIIS5rzu4sg==&prvpg=7&sid=6d187530-0f24-4724-b013-466a8563051b&stype=CityStateOrZip&productId=BA2110
Modeling Exercise • Team up with one person • Go to Apartments.com • Find a page like the one I showed • Produce an ERD with • Complexes, apartments, and features entities • Main attributes • Named relationships Entity attribute
The four forms • Hierarchy • Index • Association • Sequence
Functionality • Trigger • User action (button, link, etc.) • System action (time, event, etc.) • Parameter transfer • URL parameters • Form parameters • System parameters • Algorithm • Standardized logic • Parameterized operation • Response • Changes to info presented • Changes to functionality presented
There’s a lot in a URL http://www.apartments.com /rent/Seattle-WA/Ava-Queen-Anne/102736.268 ?SearchCriteria=oTJ2f0Fp6Qg63H… &prvpg=7 &sid=6d187530-0f24-4724-b013-466a8563051b &stype=CityStateOrZip &productId=BA2110
The pseudo query • What (select) • What specific elements do I want to use/show • Where (where) • How do I find the info I want • How (order by) • How should the results be sorted
What: Apartment elements Full view Thumbnail view vs Results view vs
Indexes Pseudo Query What: Apartment results elements Where: city AND state AND zip • Algorithm • Parse input • Validate input • Build the query • Where = AND
Indexes Pseudo Query What: Apartment results elements Where: A BETWEEN min and max AND B between min and max • Algorithm • Validate input • Build the query • BETWEEN • AND
Indexes Pseudo Query What: Apartment results elements Where: A = 1 OR 2 or 3 AND B = 4 OR 5 OR 6 • Algorithm • Build the query • OR within a control • AND between controls
Associations Pseudo Query What: Apartment results elements Where: search.id = the one in the link How: order by searches.dateTime(decending) • Algorithm • Build the query • single criterion • Order by dateTime
Associations Pseudo Query What: Apartment thumbnail elements Where: all user-apartment records How: order by user-apartment.dateTime orNumber of user-apartment records apartment.rent • Algorithm • Run canned query • Set ordering • Build display • rows/columns
Associations Algorithm Fancy idea of how apartments are related Fancy idea of how to order results Pseudo Query What: Apartment thumbnail elements Where: probably really complex How: order by how much you want them to click on each (also complex)
Hierarchy • What do all hierarchies have? • How do we represent that? sub sub feature sub feature sub sub feature sub sub feature sub sub feature Feature sub feature sub sub feature sub sub feature sub sub feature sub feature sub sub feature sub sub feature
The border between an index and a hierarchy A one-level hierarchy? Eh… more like an index
Exercise: Model this Pseudo Query What: Where: How: Algorithm xxx yyy
Function and flow revisited I’m unsure of what I want Browse feature Wizard user profiler I have an idea of what I want Facets products Viewed Favorites Social solidifiers You made me even more confused I am committed to some specific ones I can’t narrow down I can’t decide