alter /* unnormalized */ table
is_still_unnormalized_after add (
surrogate_key_id integer primary key,
Normalization is to do with the dependencies between the (business) attributes. As surrogate keys are additional system generated identifiers, they do nothing to change the dependencies between the original attributes!
One of my students asked how to convert MySQL Workbench’s default Crow’s Foot (IE) diagram to one of the other supported formats – Classic, Connect to Columns, UML, and IDEF1X. Crow’s Foot is also known as the Information Engineering Model method (covered in Chapter 3 of my MySQL Workbench: Data Modeling & Development.
I dropped a materialized view (without the preserve table option), but the object still exists! Here’s a copy and paste from my session:
The MySQL DB Development group posed a questions on how to handle images. Naturally, the argument always goes: Should images be deployed in the database or the file system? I believe they should be stored in the database because the cost and time associated is too high with regard to managing files, a file naming schema, and backing up the file system discretely from the database.
On my PL/SQL Challenge website, we have a feature called Roundtable, which offers an opportunity to discuss "big picture" questions relevant to Oracle programmers.
The current discussion (well, sharing, really) asks players to share the programming languages with which they work.
In part of my answer, I wrote:
Valid funny queries
select the join from join join join using(the,some)
select some join from left join join right using(some,the)
select 1 join from join join join join join using(the) on 1=1
select the some from join
where the=some( the(select some from join)
,the(select the from join)
Each June, ODTUG hold its highly respected and enthusiastically attended Kaleidoscope conference. this year it will take place in Seattle. Lots more details here.
And several years ago, ODTUG added a community service day (CSD) on the Saturday before the conference, to give attendees an opportunity to "do good" while they enjoy the perks of a software conference (they are, after all, very perky!).
Yesterday ODTUG announced their CSD for 2014:
Back on the film quizzes this time with a mathematical twist for the clues: