|
|
 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
Bert |
Created: |
Monday, October 30, 2006 2:02 PM |
 |
 |
Bert Scalzo is a product architect for Quest Software, a member of the Toad team and an Oracle ACE. He has worked with Oracle databases for over two decades; his key areas of interest are data modeling, database benchmarking, tuning and optimization, "Star Schema" data warehouses and Linux. Bert is the author of several books and has written articles for many online outlets and publications, and has presented at numerous Oracle conferences and user groups.
Bert's blog provides useful Toad “how to” and “tips and tricks” covering topics on database admin and benchmarking.
Recent postings:
|
|
|
We don’t need no stinking modeling tool |
|
Bert
|
Friday, April 13, 2007 3:49 PM
|
|
|
|
You’ll have to forgive me for spoofing the famous movie line “We don’t need no stinking badges” (Treasure of the Sierra Madre, 1948 and Blazing Saddles, 1974), it just seemed quite apropos
 |
|
|
Read More...
|
|
|
Toad Data Modeler 3.0 Preview |
|
Bert
|
Monday, March 19, 2007 1:09 PM
|
|
|
|
In this installment I thought I'd write about the exciting, and soon to debut, Toad Data Modeler 3.0 release rather than yet another boring academic or technical topic on data modeling. TDM 3.0 is quite exciting. While it has not yet been made available for public beta – it will be very soon (so please email the product manager
|
|
|
|
|
Read More...
|
|
|
Irrational Relationships and their Ramifications |
|
Bert
|
Friday, February 16, 2007 8:25 AM
|
|
|
|
Over the decades I’ve worked with many data modelers – and I’ve learned something key to building a great model that is not always intuitively obvious: spend at least 50% of your data modeling time on the relationships. Often modelers are so overly concerned with the entities, attributes and unique identifiers or keys ...
|
|
|
|
|
Read More...
|
|
|
Normalization in Non-Gobbledygook Language |
|
Bert
|
Friday, January 12, 2007 8:45 AM
|
|
|
|
Probably one of the most often discussed and hotly debated topics in both data modeling and database design is that of normalization. Many database designers, architects, DBAs and senior developers have differing positions and/or beliefs on the topic. However quite ...
|
|
|
|
|
Read More...
|
|
|
Forward Engineering – A Better Approach to Design |
|
Bert
|
Wednesday, November 29, 2006 8:10 AM
|
|
|
|
Last month I wrote about “Why Reverse Engineering is Always Worthwhile.” So the logical next issue to examine is forward engineering – its different approaches and its many comparative benefits. The best way to do this is via an analogical example
|
|
|
Read More...
|
|
|
Why Reverse Engineering is Always Worthwhile |
|
Bert
|
Monday, October 30, 2006 1:04 PM
|
|
|
|
In many shops that I visit, neither the DBA’s nor the database developers place much value on performing data modeling. Often there are seemingly sound reasons for this exclusion: the historically high price of data modeling tools, data models are not required as a project milestone or deliverable, and quite often the database was simply either inherited or supports a third party application – ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|