957 reputation
49
bio website
location
age
visits member for 3 years, 9 months
seen 4 hours ago

Retired. Once a programmer, then a DBA.


4h
comment Professor told us to store Serialized java objects as blobs instead of defining relational tables
Sure. This formulation amounts to objects pretending to be data. And they are data, but not very useful data.
11h
comment Professor told us to store Serialized java objects as blobs instead of defining relational tables
What you said, plus my two cents. Reusability is about modularity and sharing. The object model focusses on sharing objects and reusing code. The database model focusses on sharing and reusing data. Neither model is completely moronic. Neither model is perfection. And it's very, very difficult to reconcile the two.
1d
answered Database Normal Form (financial statement)
2d
revised embedded wiki excerpt
added 83 characters in body
2d
revised embedded wiki description
added 799 characters in body
2d
wiki created embedded description
2d
wiki created embedded excerpt
2d
suggested suggested edit on embedded tag wiki
2d
suggested suggested edit on embedded tag wiki excerpt
2d
comment Is it always bad to have an own table for value objects?
The word "rules" is misleading when it comes to design in general and database design in particular. Even for good rules, there are times when disregarding them is the pathway to good design.
Nov
12
answered MySQL taking significantly longer to query via PHP than CLI
Nov
1
revised Database design: 4 types of users but have different functionality , separate or one table?
added sutypes tag
Nov
1
suggested suggested edit on Database design: 4 types of users but have different functionality , separate or one table?
Oct
29
revised Database design: 4 types of users but have different functionality , separate or one table?
Added the subtypes tag. Incorrect tage the first time.
Oct
29
suggested suggested edit on Database design: 4 types of users but have different functionality , separate or one table?
Oct
27
comment Don't know how to transform variable entity into relational table
@miracle173 not all implementations of class table inheritance combine it with shared primary key. I recommend it. It's a little more work at insert time, but easier and faster at joined retrieval time.
Oct
27
comment Don't know how to transform variable entity into relational table
@miracle173 a valid point. For some reason, Fowler doesn't include the PKs and FKs in the diagram. There are other articles under class table inheritance that provide this detail.
Oct
27
revised Don't know how to transform variable entity into relational table
added 13 characters in body
Oct
27
answered Don't know how to transform variable entity into relational table
Oct
27
revised Confused about Primary Keys, and Foreign Keys
typo