BEGIN:VCALENDAR
PRODID:-//hacksw/handcal//NONSGML v1.0//EN
METHOD:PUBLISH
BEGIN:VEVENT
DESCRIPTION:Click for Latest Location Information: http://edw2014.dataversity.net/sessionPop.cfm?confid=79&proposalid=5941\nTo create stable systems that are responsive to change, essential ER models can be abstract—in ways that appear impractical to implement.  The argument against such models is often “We couldn’t possibly create a database from that!” Your author disagrees. The generalization that makes the data models robust makes databases equally robust if they follow the structures.\nNevertheless, the design should not be completely “from that”.  Design must account for the physical realities of a particular computing environment, and account for the way systems based on the design are expected to be used.  The trick is to be controlled and cautious, so as not to lose the benefits of the generalized models.\n \nThis presentation addresses steps required to convert an abstract data model into a database design.  Beginning with the automated conversion, it then describes the steps required to fit the result onto a real computer with real performance constraints.\n  \nOutline:\n Sub-types and super-types\n Abstraction, attributes, and parameters\n Derived attributes\n Physical constraints\nThe steps:\n Define usage patterns\n Resolve super-type / sub-type structure, based on usage patterns\n Convert the model using an automated tool.\n Optimize for performance, in terms of usage patterns.\n Deal with derived columns\n Convert stable, single-valued parameters to attributes\n De-normalize inherited and summary values\n Divide tables horizontally and/or vertically, based on expected usage patterns.\nTest performance under various assumptions.\nDe-normalize as necessary \n Document rationale for everything.\n
DTSTART:20140501T093000
SUMMARY:Converting An Abstract Entity/Relationship Model Into A Real Database Design
DTEND:20140501T101459
LOCATION: See Description
END:VEVENT
END:VCALENDAR