So I told you before that I will present in Finland and in Finnish and that is what I did. And I must say I loved it. Maybe I will do it again!
Amazing thing happened. In the audience there was somebody very knowledgeable dba I know from years and years. After my presentation he came to me and said that he would love to learn more about database design and if possible he would like me presenting for a longer session to teach the basics and how to do the design on Data Modeler. I was really happy for this kind of feedback. So no choice: starting to prepare a presentation about database design on Data Modeler...
sunnuntai 18. joulukuuta 2011
Database design with Data Modeler and problem solving with OEM 12c
That is what I have done lately: designed databases and solved performance problems. My nice idea was that if you design your database well you will not need to solve so many performance problems. Ok, I was partially right but also partially wrong. Good database is nothing if you use it wrongly. And I told about this problem also in my presentations about database design. Now I just need to solve this problem as well...
So two new presentations coming from me (do not know the real titles yet but just to get the idea):
- Database design with Data Modeler
- Solving performance problems with Data Modeler and OEM 12c
Interesting times...
So two new presentations coming from me (do not know the real titles yet but just to get the idea):
- Database design with Data Modeler
- Solving performance problems with Data Modeler and OEM 12c
Interesting times...
tiistai 13. joulukuuta 2011
ER model
Yesterday I was solving (again) a problem on an sql clause that did not perform well enough.
When I solve this kind of problems I usually draw a picture of the query: tables, joins, where conditions etc. Just yesterday I got a great idea: use the ER model as the base for the drawing! So print out the ER model and draw the aliases, joins, wheres etc on that picture. You will save time and the drawing looks very clear!
I did solve the problem and the ER helpped me a lot: missing join, too many outer joins (on tables where the relationship is mandatory) etc.
Feel free to use this tip unless you are already using this method.
When I solve this kind of problems I usually draw a picture of the query: tables, joins, where conditions etc. Just yesterday I got a great idea: use the ER model as the base for the drawing! So print out the ER model and draw the aliases, joins, wheres etc on that picture. You will save time and the drawing looks very clear!
I did solve the problem and the ER helpped me a lot: missing join, too many outer joins (on tables where the relationship is mandatory) etc.
Feel free to use this tip unless you are already using this method.
SQL Developer and Data Modeler
Today I will present in Finland and in Finnish. I am going to talk about SQL Developer and Data Modeler. What are they? What can you do with them? And most importantly how can you design your database with Data Modeler. Fingers crossed...
I am sure my time will run out, so much to say!
I am sure my time will run out, so much to say!
torstai 8. joulukuuta 2011
From Oracle Designer to Data Modeler
As I have mentioned before I am in a project where we are replacing Oracle Designer (for a huuuge environment) with Data Modeler. I did not get this idea myself but somebody came to me and asked why am I not speking to other Designer/ Erwin etc users how to do it? Is it difficult? What changes? What is the same? ect...
That is actually a great idea! I think 30 min should do because it is actually really simple. The difficult parts are the changes in system development processes but I speak about those in my other presentations already and they have nothing to do with Data Modeler but with the changing world. This is actually very good continuation to my presentations about database design. Thank you!
That is actually a great idea! I think 30 min should do because it is actually really simple. The difficult parts are the changes in system development processes but I speak about those in my other presentations already and they have nothing to do with Data Modeler but with the changing world. This is actually very good continuation to my presentations about database design. Thank you!
perjantai 18. marraskuuta 2011
BGOUG
Milena and her team have organized an excellent conference again!
So in Bulgaria now enjoying an excellent presentation about APEX from Dimitri Gielis.
My presentation will be tomorrow so today I have plenty of time to enjoy these great presentations.
In the evening there will be a big party with Bulgarian dances so I just hope at least some of the people are awake in the morning for my presentation...it's so great to be the first presenter in the morning after a party ;)
P.S. The party was great and people did come to my presentation in the morning! Even though the great Doug Burns was presenting in the next room... Thank you for attending my session and thank you for the great feedback!
So in Bulgaria now enjoying an excellent presentation about APEX from Dimitri Gielis.
My presentation will be tomorrow so today I have plenty of time to enjoy these great presentations.
In the evening there will be a big party with Bulgarian dances so I just hope at least some of the people are awake in the morning for my presentation...it's so great to be the first presenter in the morning after a party ;)
P.S. The party was great and people did come to my presentation in the morning! Even though the great Doug Burns was presenting in the next room... Thank you for attending my session and thank you for the great feedback!
Data Modeler
Just heard the rumour again: Data Modeler is not going to live long.
Where does that rumour comes from and everywhere around the globe? Oracle, please do something to stop that.
I must say I do not believe in that rumour. I am very sure Data Modeler will live for long. I have heard about many projects where people are replacing their previous tool with Data Modeler and the support I get from Oracle to my project has been fantastic (thank you Philip!) so I have all the reasons to believe Data Modeler will live for long.
Where does that rumour comes from and everywhere around the globe? Oracle, please do something to stop that.
I must say I do not believe in that rumour. I am very sure Data Modeler will live for long. I have heard about many projects where people are replacing their previous tool with Data Modeler and the support I get from Oracle to my project has been fantastic (thank you Philip!) so I have all the reasons to believe Data Modeler will live for long.
Tilaa:
Blogitekstit (Atom)