• About Heli

HeliFromFinland

~ Heli's thoughts on Database Designing, Oracle SQL Developer Data Modeler, User Groups etc.

HeliFromFinland

Monthly Archives: April 2014

These short notes…

24 Thursday Apr 2014

Posted by Helifromfinland in General

≈ Leave a comment

I have been and I am asked many questions about Data Modeler and database design almost every day. Some of those questions are asked more frequently than others and almost in the same way. That is why I decided to write short notes on those topics. I try to keep them as short as possible.

– the title is the question

– the post includes the reply

You will find these posts either under Data Modeler or database design, depending which one it concerns.

I hope somebody finds these useful. And feel free to send me more questions to reply:-). Maybe in Twitter: @helifromfinland?

Is phone number an entity or an attribute?

24 Thursday Apr 2014

Posted by Helifromfinland in Database design

≈ Leave a comment

Short answer: it depends.

At first I would say it is an attribute but…

if you need to:

– have many different kinds of phone numbers and you cannot say how many (0-n) and maybe the type of the number varies in different cases (home number for a person, office number for a company, fax number for both) and maybe the types for phone number do not remain the same

– have history data for the numbers (which number was valid at certain time)

or something similar.

You might actually have an entity in hands.

Or if you know there might be max four phone numbers but two of them are mandatory, we come back to the conclusion it is an attribute.

So it depends on the requirements weather phone number is an attribute or an entity.

How do I draw an arc on my logical model?

22 Tuesday Apr 2014

Posted by Helifromfinland in Data Modeler

≈ Leave a comment

Select the relationships you need for the arc (hold Ctrl to select) AND the entity. Then the arc symbol on tool bar is enabled and you can draw the arc.

OUGF Harmony in June

19 Saturday Apr 2014

Posted by Helifromfinland in Events

≈ Leave a comment

I am so excited about the coming Harmony conference! It will be awesome!

Many of the top speakers in the world in a middle of a Finnish forest sharing their knowledge and experience. Amazing!

We will have topics on database, DW/BI, application development,…

Plenty of ACE Directors, ACEs and ACE Associates. The Oaktable World. RACAttack (special sauna edition!). Roundtables, sessions,…

Dinner outside by a lake (#DineWHeli :-)). Sauna, swimming in a lake.

Several excellent keynotes. 6 tracks + 3 tracks in tents.

And last but not least THE C.J.Date will give a seminar on Temporal Data in the Relational Model and SQL.

And all this on the same fee!

Who can afford to miss this?!

 

Register NOW:

http://www.eventbrite.com/e/ougf-2014-harmony-tickets-10410222255

 

I do not want to see the FK names in my relational diagram

18 Friday Apr 2014

Posted by Helifromfinland in Data Modeler

≈ Leave a comment

What should I do?

Simple. Just select from top bar View -> View details and select what you want to see. If you take All details you will see all details, including the FK names. All details is the default so go and see what is your preferred setting for information in relational diagram! This can be changes when ever you want. Hundred times a day if wanted:)

Is social security number a good primary key?

18 Friday Apr 2014

Posted by Helifromfinland in Database design

≈ Leave a comment

Short answer: no.

Why? Well I can give you at least 10 reasons but just to start with….

– social security number (SSN) is not unique, at least not world wide

– it does not identify a person (for instance my father has two social security numbers, exceptional but possible)

– it can be changed: you come to another country and are given a temporary SSN. You get the citizenship and get the real one. Changed.  There are plenty of cases when the SSN is changed.

– it is not something you can define yourself, it comes from another system and is controlled by other organization and their rules. What if they change the rules? Do not have PKs from another system’s data (history data etc)

– it is many times defined as sensitive data. It will be quit a job to get reduction or masking done to all the columns in child tables.

etc.

I prefer natural primary keys over surrogates but social security number is not one. So please save your time and energy and do not define SSN as a primary key.

EOUC presidents’ meeting next month

16 Wednesday Apr 2014

Posted by Helifromfinland in Events

≈ Leave a comment

The next four weeks I will only travel inside Finland to speak in various Oracle events but May 20th I will fly to Sofia, Bulgaria for the EOUC presidents’ meeting.

EOUC stands for EMEA Oracle Usergroups Community and I am one of the two ambassadors/spokespersons for the Community. It is about the time to start preparing the meeting on behalf of the user groups. Most of the content for the meeting comes from Oracle but we also have some slots of our own. And since those slots are not big they must be used wisely and prepared well.

I already know people want to share best practices, talk about their issues, share the information on their future events and speakers. They want to know about the different tours we are planning in EMEA, vote for the new logo for the EOUC, hear about the OOW14 preparations and to meet each others. What else would be valuable?

Data Modeler 4.0.1

11 Friday Apr 2014

Posted by Helifromfinland in Data Modeler

≈ Leave a comment

Have you tried it yet?

Please do so! This version is the best so far. So many new features and improvements. I asked for many things for this version but totally forgot them. Now to my surprise they are here. And why am I surprised because I know the best team is working on Data Modeler!

Design level properties (used to be on preferences) in right place, handling sensitive information, masking, …

On the next version I want to see synonyms working so I better start telling the best team in Oracle what I want…

Adding a new Database Site

08 Tuesday Apr 2014

Posted by Helifromfinland in Data Modeler

≈ Leave a comment

You probably want to have database sites with names you understand or you might want to have several physical models for same technology (Oracle 11g, Oracle 12c, …) maybe for test and production. Whatever the reason is you might want to have database sites that do not exist in Data Modeler already. How to do that?

Go to Tools -> RDBMS Sites Administration

Press Add site: define the name and select the technology (RDBMS Type)

Apply

Close

Now you will have the newly created site on your list of Database Sites when creating a new physical model.

Thank you Tim Hall

05 Saturday Apr 2014

Posted by Helifromfinland in General

≈ Leave a comment

I want to thank my Oracle-Dad (long story:-)) Tim Hall for the best advice ever: I complained to him I never have time to update my blog and he suggested I write when I have time and publish my stories when I get to internet. He was so right! My blog will be so much more active now! Thank you Tim! This method really works!

← Older posts

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • October 2022
  • October 2021
  • April 2020
  • October 2019
  • October 2018
  • June 2018
  • December 2017
  • October 2017
  • September 2017
  • July 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • June 2014
  • May 2014
  • April 2014
  • January 2014
  • December 2013
  • November 2013

Categories

  • Data Modeler
  • Database design
  • Events
  • General
  • Oracle
  • SQL Developer

Meta

  • Register
  • Log in

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • HeliFromFinland
    • Join 48 other followers
    • Already have a WordPress.com account? Log in now.
    • HeliFromFinland
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar