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

Retired. Once a programmer, then a DBA.


1d
comment avoiding unique key collisions across tables
I'm more of an Oracle person myself. But I think this conversation is going around in circles until we all clarify why partitioning is useful and why multiple tables with the same structure and semantics is an antipattern. You and Raymond are saying the right things, but it isn't getting through.
1d
comment Additional info on some rows in the table
The techniques I describe here apply to the design of tables for a relational database. You can apply these techniques in an ms access situation. The actual building of tables is different if you use the access GUI than if you were using SQL DDL, but the design techniques are the same.
1d
revised Additional info on some rows in the table
added subtypes tag
1d
revised Additional info on some rows in the table
added 64 characters in body
1d
answered Additional info on some rows in the table
1d
suggested suggested edit on Additional info on some rows in the table
2d
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
What's the course? Is it Database Design or is it Object Oriented Programming?
Nov
23
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.
Nov
23
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.
Nov
22
answered Database Normal Form (financial statement)
Nov
21
revised embedded wiki excerpt
added 83 characters in body
Nov
21
revised embedded wiki description
added 799 characters in body
Nov
21
wiki created embedded description
Nov
21
wiki created embedded excerpt
Nov
21
suggested suggested edit on embedded tag wiki
Nov
21
suggested suggested edit on embedded tag wiki excerpt
Nov
21
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?