Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Florian.

Asked: February 10, 2017 - 9:05 am UTC

Last updated: February 11, 2017 - 1:55 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hello Tom,

some time ago, I've read a very good article on "Ask Tom" about your database anti-pattern "4 table-schema".
I use your thoughts to tell my junior engineers about how NOT to do database modelling and why.

Now I've tried to find your article again, so they can read the details. But I do not find it anymore.

Could you please provide me with the link to it?

Thanks

Florian

and Connor said...

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:10678084117056

https://www.simple-talk.com/opinion/opinion-pieces/bad-carma/


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Edge (and vertex) cases...

Duke Ganote, February 10, 2017 - 8:15 pm UTC

My key takeaway from Tim Gorman's article is "...what works very well for a CASE application supporting 1-5 developers who think a lot and type only a little may not work well at all for a mission-critical order-entry application supporting 300-400 reservation agents who think very little and type very rapidly. The database workload generated by a small number of users generating transactions intermittently has little in common with the database workload generated by an order-entry application."

Similarly, Oracle also offers a "property graph" database (within Oracle Spatial) which seems to store properties in key-value format. But generally, property graphs are queried much differently than, say, a high-volume data warehouse.
https://blogs.oracle.com/bigdataspatialgraph/entry/from_relational_table_s_to

(And yes, I own and have repeatedly read "Oracle Insights: Tales of the Oak Table")
Connor McDonald
February 11, 2017 - 1:55 am UTC

Indeed - I think the key takeaway from any database design discussion is - decide on what you *think* will work, and then *prove* that it will under all the circumstances you're aware of
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.