- Twitter: @Helifromfinland
- I am
- – the author of Oracle SQL Developer Data Modeler for Database Design Mastery (McGraw-Hill, Oracle Press, 2015)
- – a co-author of Real World SQL and PL/SQL: Advice from the Experts (McGraw-Hill, Oracle Press, 2016)
- – a co-author of Machine Learning for Oracle Database Professionals: Deploying Model-Driven Applications and Automation Pipelines (Apress, 2021)
- – one of the first winners of Oracle Database Developer Choice Award, Devvy, on Database Design category in 2015
- – a frequent speaker in many conferences
- I am
- – the CEO for Miracle Finland Oy
- – an Oracle ACE Director, an Oracle Groundbreaker Ambassador
- – a PhD student/researcher/lecturer at the University of Helsinki
- I have been an Oracle user since 1993.
- I love cooking, reading, writing, and sports.
- In short: I am a database person and I come from Finland.
Oracle SQL Developer Data Modeler for Database Design Mastery
Machine Learning for Oracle Database Professionals: Deploying Model-Driven Applications and Automation Pipelines
Real World SQL and PL/SQL: Advice from the Experts
John Tesson said:
Heli, I’m looking for some advice. We have about 8 existing star schemas in our database and most of them are using conformed dimensions. Haven’t used DataModeler to create them. I’d like to reverse engineer all of them into DataModeler and then start on a new star schema design that is needed. Should I reverse engineer them all into one single relational model or what? Or do I create different/separate datamodeler files for each star schema? There are 4-5 schemas involved already. I don’t know how to approach this. By the way, we bought your Oracle SQL Developer Data Modeler book. Thanks, John from State Univ. of New York.
Usually when schemas have someting in common (foreign keys between the tables in different schemas, shared tables etc) I bring them into a single design and create a subview for each schema. If they have nothing in common I create several designs. Sometimes the problem with a single design can be that due to so many tables it can be too slow to work with. The latest release is better in that way and should have less issues.
Does this help?
John Tesson said:
Thank you for your advice Heli! I will try your idea. I’ll import everything into one relational design and then separate them out into subviews, one for each “star”. I guess the only issue might be if another person wants to do work on one of them at the same time then we only have one file.
not a problem at all: each element will be in a separate file (entity, table, diagram etc) and several people can work on them at the same time. The whole design is in one file only if you specifically tell the tool you want to have everything in one file (Design Properties, makes handling larger designs faster). Still if you use Subversion and DO NOT use locking you can use it in a multiuser environment. Several people can work on it at the same time and if conflicts arise you are able to solve them.
If you are not using Subversion yet, please consider that seriously: when everything is in version control you do not need to worry about making mistakes, you can always go back to the point before the mistake was made 🙂
John T said:
Heli, is there a technique in logical design to show the role playing dimensions as separate entities? right now we just see one entity with multiple relationship lines to the fact table. not very user understandable. Thanks again!
Hi John. I am not sure what would be the best but I suggest you add the role name as the Name on Source (for instance OrderDate, DeliveryDate) at the relationship properties (double click the relationship and edit Name on Source property). In the relational model you might want to use views for the different roles? Defining attributes (OrderDate, DeliveryDate,…) for each relationship is another way of thinking. There are several ways of doing it but I am not sure which one is the best. Have you used another tool before? If so how did you do it with that?
Olexandr Siroklyn said:
Thank you for a good blog. Being interested in Oracle security questions may I propose you to look at FCBCrypto software page http://www.oracleongpu.com/fcbcrypto/ if inexpensive row level data encryption for Oracle database Enterprise and Standard Edition 11g and 12c versions is interested for you?
I do apologize if you found out my “comment” as an inappropriate for your blog.
With best wishes,
Hi Heli, I read your book about Data Modeler and I liked it. Now I m searching information about process modeling with the tool, but I can’t find documents…. It’s true? In your book there is only an introduction
Hi! Unfortunately there is very little material on process modeling available. I have been planning to write about it for a long but unfortunately always ran to the same problem: not enough time.