Journaling tables in Data Modeler 4.1

Creating journaling tables is very easy with Oracle SQL Developer Data Modeler.

1. If you have not done so yet copy the file dr_custom_scripts.xml from datamodeler\datamodeler\types\ to your Default System Types Directory. Now you will have the journaling script ready for Data Modeler to use.

If you do not remember where your Default System Types Directory is, go and check from Preferences:

Journaling_05

2. If you want to test the script or change it, go to Table DDL Transformations:

Journaling2

Select the script Journal tables. Test  by pressing the Test button and Save any changes by pressing the Save.

Journaling3

3. Generate the journal tables

Start by selecting Export, DDL File from File Menu.

Journaling4

Select the script and tables you want to create the journal table in Include Table DDL Scripts tab:

Journaling5

Check the SQL generated:

Journaling6

If you are happy with it just save the DDL file.

Creating journaling tables could not be easier than this 🙂

First day of the OTN EMEA Tour

The first day of the OTN EMEA Tour is now over. Loooong day but I think very good and successful.

The first leg was Lisbon, Portugal. The local user group is rather new and it was great to help Luis and Nuno to build the community. It was great to hear they had 65 (!) registrations for the day!

I gave two sessions. The first one was about database design and Oracle SQL Developer Data Modeler. In the end of the session I gave away one of my books. Many people were sad that the book still cannot be bought in Europe. Well, hopefully in June… Before I started my second session I gave an ex tempore presentation about Journaling tables in Data Modeler because there were people in the audience interested in that and it is really easy with Data Modeler. My second presentation was Agile database design.

I think it was a great day and I am looking forward to the rest of the tour. But now I better get to bed: tomorrow we will fly to Amman, Jordan. It will be a looooong day again…

The Dream

I have always loved reading but while I was writing my book I simply could not read; did not matter how interesting the book was…

About a month ago I was able to read again and luckily I took just the right book: The Alchemist by Paulo Coelho. That was the best therapy I could have got at that moment! My book was finished and there was nothing more I could do… and what did I do? I started to worry that the book might be really terrible and even I might hate it myself! My husband tried to calm me down and said that many smart people have read it and it cannot be too horrible…but I still kept worrying…

But it calmed me a bit to read The Alchemist and especially the words Paulo Coelho wrote in the beginning of the book 10 years after the book was published. He said that there are four obstacles for a human being to reach the dream (forgive me if I am using the wrong words, I read the book in Finnish, so this is my translation of what he said).

  1. Since childhood we have been told that whatever we are trying to do is impossible.
  2. We are afraid that if we try to reach the dream our loved ones will suffer.
  3. If we really try and then fail there is no way to say that I really did not try and did not really want to reach my dream.
  4. If we reach the dream we start feeling guilty: why did I reach it since so many did not.

I was very fortunate not to have the first obstacle at all: my parents and grandparents have always told me that I can do whatever I want. I do not remember any of them saying not even once that something would be too difficult or impossible for me. I can only be very grateful for having such a wonderful childhood!

The second one has been a challenge to me because I love my husband and boys so much and was worried that writing the book will take all the time away from being with them. But I should have known that I have a strong and loving family and one book is not going to be a problem 🙂 I remember several Sundays when one of my family members came to ask me weather we will eat lunch today…I did not realize it was lunch time because I was just writing. My family solved the problem and prepared the meals without disturbing my writing and just invited me to the table 🙂 I must have the best family in the world…

The third one is very tough for me. I have always been a perfectionist. And my biggest challenge in life has been to learn to live with it. I am not good with feedback weather it is good or bad, and I am afraid I will never learn to be good in that 😦 But I passed this obstacle and wrote a book even though I know somebody will hate it and say it in public. But luckily I now know that some people like my book. That should help me to get over the bad moments.

The fourth one hit me the biggest. I have always worried about other people (I was about 3-4 years old when I refused to eat and my explanation was that people in Ethiopia are starving and my food must be sent to them) and I started to worry why I have got this fantastic opportunity, a dream come true, and so many people will never get it. But this is the moment I took The Alchemist in my hands and understood that this is my last obstacle on reaching the dream. My book does not take anything away from anybody: everybody who wants to write a book can do it if they want it hard enough and are willing to work for the dream.

I wrote this post probably as the last therapy session for myself 😀 but I hope this will give the spark to somebody to start reaching the dream. I assure you it is worth it!

Take care!

Heli

OTN EMEA Tour is about to start…

It’s time to pack again. Tomorrow I will head to Lisbon, Portugal to start the OTN EMEA Tour. There are four speakers (I, Debra Lilley, Björn Rost, and Tariq Farooq) travelling in three countries (Portugal, Jordan, and South Africa). To my joy my friend Osama Mustafa will join us as a speaker in Jordan.

This is a completely free event for the benefit of the local Oracle communities. You can read more: www.otnemea.com

I hope you will be able to join us!

P.S. Even before the trip started I learnt that moving a flight from Sunday to Wednesday is not cancelling but rescheduling 😀 I only hope we will make it in time to all the locations without learning new tricks from air companies 😉

The launch event of my book

Today was the official day for my book to be published and we had a small launch party in Finland at the Miracle office.

We were ready for the guests an hour before the start…

launch0

launch05

And then they arrived…

launch1

I gave my speech and told about the writing process etc.

launch3

Kirja

Then Jaripetri Kalske from Oracle Finland gave a fantastic speech about the importance of database design and about the fact how proud the local Oracle is that the author of the book is a Finn. Thank you, Jaripetri!

After the official part we all enjoyed some finger food my masterchef Mother made for us and talked about database design and Data Modeler.

launch2

Thank you all for attending! And I hope you like my book 🙂

– Heli

Wildcard Unconference 2015, #wcuc15

The Wildcard conference was once again a great experience. Thank you Vladimir, Natalija et al!

I was more nervous than usually because the audience was not my “regular” Oracle audience but developers of different technologies. I prepared a completely new session for them: Managing the changes in database structure. The audience was extremely good and interested in the topic. The questions during and after the session were excellent. Thank you Natalija Knaidele for taking this photo!

WCUC151

In the end of the session I signed and gave away a copy of my brand new book. Guna was kind enough to help me to pick the lucky winner: Andris Enins. I hope you like the book, Andris!

WCUC152

Once again the conference was great and I really had no reason to be nervous: the audience is always fantastic in Latvia! Thank you for inviting me!

Finding an older version of the design from Subversion

You might want to see an older version of your database design. Maybe to get the DDLs to create a database of that version or maybe to compare to another version of the database design or the data dictionary.

How to get that version from Subversion?

First select Team, Check Out…

v11_1

Enable Use Revision and press Select Revisions…

v11_2

Select the revision that matches your version and press OK.

Open the design from the working directory.

v11_3

Maybe you would like to get the DDLs to create a database of version 1.1?

Select File, Export, DDL File.

v11_4

Select the RDBMS Site wanted (for the SQL syntax).

v11_5

Select the elements you want in the DDL.

v11_6

See the SQL and if you like it press Save.

v11_7

Run the saved SQL script to your database.

Now you have a design of version 1.1 and a database with version 1.1 structures.

Wildcard Unconference 2015

On Friday I will fly to Riga, Latvia to present on Saturday at the Wildcard Unconference 2015 (#wcuc15). I am extremely honored because the speakers were not selected by the organizer but by the attendees!

This time my audience is not the typical Oracle audience: it will be developers with different backgrounds and technologies. Because of that I have prepared a special presentation for them: Managing the changes in database structure. In my presentation I will share my vision of managing changes in database structures and show how that can be done using my fav tool Oracle SQL Developer Data Modeler. I hope the audience likes it and can use that knowledge to better manage their changes.

I hope to see you there too! http://wildcardconf.com/e/201505/program.html

Cheers

Heli

Heli’s Tips on writing a book

I just wrote my first book and enjoyed that experience very much: this will not be my last book 😉

While writing the book I suddenly remembered that as a teenager I wanted to be an author and now my dream just came true! Life is strange…

I have been contacted by several people asking for advice on writing a book. This is what I have answered:

  1. Do not wait for the inspiration

The inspiration will come when you write. Writing is 99% of hard work and 1% of inspiration.

  1. Try not to be perfect

Good enough is enough. If you try to be perfect the book will never be ready. Besides nobody is perfect…

  1. Keep the schedule

Tomorrow will not be an easier day so stretching the schedule will not make your life easier. If you finish everything in schedule you will feel better and writing will be easier and more fun!

That’s all I have to say. I hope this was useful to somebody!

Cheers,

Heli

My first Oracle Expert Summit

Once again I am sitting at the airport, this time in Prague. I had a wonderful week and I feel extremely blessed.

On Tuesday I flew to Bucharest, Romania for the Oracle University Romania Expert Summit. I arrived in the afternoon just in time to meet Chris Date and a Romanian friend of mine Mirela Ardelean. Mirela took us for a sightseeing walk and for a lovely meal. Oracle was very kind to us and sent some wine and fruits in our rooms. After the nice tour and meal Chris and I ended up to the hotel room drinking wine and talking about relational theory and everything. The next morning the Summit really started for me and Chris: he was presenting and I was attending his session on Aspects of Relational Theory. Chris mentioned there are at least two articles by Codd that everybody should read once a year; I think everybody should attend this session once a year! It is so easy to forget the basics and make terrible mistakes.

It was not an easy decision to attend Chris’ session: at the same time Pete Finnigan was teaching Oracle Database Security Audit and Jonathan Lewis explaining how to write optimal SQL. After the long and very useful day I gave a talk at the local user group (RoOUG) about agile database design. The audience was absolutely fantastic! I had so much fun that without my friend Ciprian (president of the Romanian Oracle user group) I would have talked until the morning and missed the speakers’ dinner Dan, Cosmin and Joel organized for us in a lovely Italian restaurant.

Thursday was “my day”: I talked the whole day about database designing and Oracle SQL Developer Data Modeler. I was quite surprised to see the room was totally packed! After all there was Chris explaining Time and Relational Theory and Pete continued his talk about security at the same time with me. When we finished teaching both me and Chris realized we are too tired to attend the Big Data roundtable led by Alex and instead ended up having a glass of red wine.

In the evening there was a light festival in Bucharest: a lot of lights everywhere and people having a party. I, Chris and Mirela went for a late dinner in old town. The late dinner turned out to be very late because the chefs were too busy since everybody wanted to eat out that evening and we really waited for the meal very long. But the meal came and it was delicious. Then we had to get to sleep because Chris had an early flight in the morning and I wanted to attend Alex’ session on Big Data the next morning.

Friday was the Big Data day: Alex was the only speaker and did get the room full with people interested in the topic. Unfortunately I had to leave in the middle to catch my plane.

I must say the Expert Summit was really worth doing! It was an excellent event and Oracle really made me feel like a member of royal family! Joel, Dan, Cosmin and the team: you really were spoiling us! Thank you! I only have one more thing to say: please invite me again to an Expert Summit! Thank you Oracle University!