Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Databases Suck 5 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.

  • I am stuck with an Oracle database that I can't change, has spaces filling up every table regardless of what is actually in the table and everything is a CHAR.

  • The real world is not hierarchical. Some parts of it are, some aren't. A system like MV which only lets you express hierarchical relationships is not going to be a better model of the real world than a SQL system.

    Your schema reflects your business rules. If you require that all customers have an address, there should be a constraint to this effect. If customers can have more than one address, I'm sure you know quite well how to model that as well.

    Also, SQL is not relational. It's a poor second cousin o

  • I forgot to mention this though I don't know how I forgot.

    All tables (all 1500 of them); every field is NOT NULL. Every field.

  • Anyone who has worked with software long enough knows that the relational model does not map well to the real world.

    Then pick any of the following:

    s/relational/procedural/
    s/relational/object oriented/
    s/relational/functional/
    s/relation/logical/
    s/relation/aspect oriented/
    s/relational/hierarchical/

    Continuing this list is left as an exercise for the reader :-)

    Models are not the real world. They're an abstraction chosen to make a particular problem domain easier to manipulate. Sometimes people pick the w

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.