1. Quote of the Week
Logical design is where the Architect defines entities (which will become tables in a database), attributes (which will become columns in a database), etc. This is typically the level that SMEs are most comfortable. I think that a Logical design may deal with data types and keys, but it does not cater to any specific platform or engine.2. To Laugh or Cry?
Physical design is where the Architect translates the logical design into tables, columns, datatype specifics like INT versus NUMERIC, indexes, partitions, etc. This is where "the rubber meets the road" and the logical design gets mapped into a form that can exist and be tested on a database server.
While I'm sure that someone will object to this link on religious grounds, the discussion does a pretty good job of making the distinctions that concern me. --LinkedIn.com
"From the department of "we haven't really thought this feature through" comes this gem, one of several schema migration systems that allow "reverse migrations" or "downward migrations". Whereas a forward migration creates tables, columns, etc., a reverse migration drops them. The video proudly shows them "reverse migrating" their database until all tables are dropped. Another vendor patiently explains why they don't offer this feature."
3. Online Debunkings
- Is the Relational Data Model Spent?
- 4 Table Types you Need to Scale a Relational Database
- A data model of the SAP Bill of Material Explosion tables
- What are people's opinions on nosql
- Is Data Science a combination of Data Architecture and System Engineering?
4. Interesting Elsewhere
5. And now for something completely different
The "productive" business and tech elite:
- Snapchat CEO Evan Spiegel 'mortified and embarrassed' over leaked emails
- Police-friendly tech CEO charged with hit-and-run
- Billionaire claims he owns the road, the beach and the tides
- Mystery millionaire hides $100 bills around US city ...
- Perkins On 'Nazi' Quote Inequality
Do you like this post? Please link back to this article by copying one of the codes below.URL: HTML link code: BB (forum) link code: