SQL Developer Data Modeler Quick Tip: Hide and Resize

thatjeffsmith SQL Developer 8 Comments

Tell Others About This Story:

Ever seen a table with so many columns you wonder if the designer had fallen out of the de-normalization tree and had hit every branch on the way down? Oracle currently allows a max of 1,000 columns per table. Please do not test this limit. Maybe you do need that many columns, but I doubt it.

If you were to visualize this data model, imagine how easily you might be overwhelmed with all the white-noise, or extra information.

In an earlier post I advocated using SubViews to alleviate the headaches you get when working with many hundreds or thousands of entities.

Well maybe you only have several dozen entities but the number of attributes is overwhelming.

So just hide them

A new feature in v3.1 – now in Early Adopter Release – allows you to auto-hide attributes that don’t meet the following requirements:

Just show me the 'important' stuff

Model TMI

Modeling TMI? There's a medicated cream for that.

The Goldilocks View

After you apply the model view options, the ‘extra’ attributes/columns will be hidden. However, the entity objects in the diagram will still be REALLY big. So just right-mouse-click and use the ‘Resize objects to visible’ call.

Ah, that feels so much better! And my eyes thank you SQL Developer!

What else is new in v3.1 and where can I go get it?

Tell Others About This Story:

Comments 8

    1. thatjeffsmith Post
      Author
  1. Hello,
    I have a big problem with inheritance, identifying relationship and pk.

    I have
    tableA with pk : id_A
    tableB empty.
    tableC with pk : id_C

    I make a relation (identifying relationship) between tableA and tableB( tableB will receive the pk of tableA),
    until now everything is ok!!!

    tableB is a subtype of tableC ( tableC is a supertype of tableB), so normaly it will have also the pk of tableC.
    until now everything is ok!!!

    The problem is that:
    When I pass from the logical to the relationnal model, the first pk of TableB (I mean idA) turn to “unique Key” not a primary key) and I have only id_C as a pk .

    I want to to have a pk with the two ID , I mean (id_A,id_C).

    I know how to change it after the generation of the relational model but I want to do it automatically from the logical model.

    Please excuse my bad English.

    Thank you

  2. Once I resize all my entity objects are far apart, is there a way to bring them all together? or do I need to do it manually ?
    Rgds,
    meera

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *