• About Heli

HeliFromFinland

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

HeliFromFinland

Monthly Archives: June 2015

ilOUG Tech Days 2015

17 Wednesday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

I finally have time to sit down and write about my experience at the ilOUG Tech Days 2015!

The Tech Days took place in Haifa, Israel 9.-10.6.2015. I had three sessions to present: Database Design in Agile Projects, Reporting with Oracle SQL Developer Data Modeler and Is Your Database Secured? This was my second time in Israel (two years ago I attended the ilOUG Tech Days 2013 in Jerusalem) so I knew a little bit what to expect: fantastic food, great questions and surprisingly many women in the audience. And of course Ami and Liron from the user group to do everything they can to make you feel welcome and comfortable. And they really do a great job!

During my Data Modeler sessions I gave some copies of my new book away and signed them. The Data Modeler talks were well received but I think the security one was the best. It is not an easy task to go to Israel and talk about security: those guys know everything about security! I even had some solders is my audience! But I think the presentation went well and the audience liked my ideas and comment on the topic. I had many excellent questions and many people thanked me afterwards. My favourite was the gentleman who asked me if I will write my next book on security… Who knows what happens…

I think the conference was excellent and I really hope I will have a chance to go to Israel again. Thank you for the “Bambas”! And halvas!

Which tables are partitioned? Which tables are index organized?

16 Tuesday Jun 2015

Posted by Helifromfinland in Data Modeler

≈ 1 Comment

This requirement calls for reporting…

Start Search by right-clicking the physical model name in Browser and by selecting Search.

Fig1

Select Advanced Mode and select Table as Object Type.

Fig2

Press Add Property.

Select Partitioned as a Property and type “yes” to the value field.

Fig3

Press Search.

Fig4

Now you have a list of partitioned tables in physical model Oracle 12c.

Maybe you want to have a nice report of them?

Press Report.

Fig5

You can generate the report as it is

Fig8

or you can use Custom Templates.

Fig6

Fig7

How about my IOTs?

In Advanced Mode select Organization as Property and type “Index” on value field.

Fig9

Press Search. Press Report. And either generate the report as is or use one of your Templates.

Fig10

Fig11

And if I want to have tables that are both partitioned AND index organized?

Fig12

First select Partitioned=yes. Then press Add Property again and select Organization=index. Remember to set the logical operator to AND. Then press Search.

Fig13

And generate the report wanted.

Note: If you run the report in Microsoft Excel format you are able to edit the content in Excel and then upload it back to Data Modeler.

Fig14

BGOUG, thank you!

15 Monday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

It is easy to say BGOUG is one of my favourite conferences. Not only because Milena is a dear friend, the venue is always wonderful, food is excellent etc but because I simply love the Bulgarian audience! They are extremely interested in learning, they ask a lot of questions and the best for a shy Finn like me is that they give you wonderful face-to-face feedback.

After my first session a gentleman came to me and he said he saw my session two years ago and it changed his life for better: now he knows a better way to talk to the end users to get better requirements to be able to create better databases and applications for end users. Another person came to me and said he really hope I will be there in November to share my knowledge again because he learns so much in every presentation. A lady wrote to me that she admires my work and enjoys my sessions very much. Etc.

I am usually very bad with feedback: good or bad. But these people can give it in a way I do not feel embarrassed but honored and privileged. Thank you all for your nice comments! You do not know how much it means to me! I was really tired after the conference (I just realized I have not had any free weekends for two months!) but extremely happy: my travelling and speaking has a meaning! Thank you!

And Thank you Philip Stoyanov for the fantastic speech!

Heli

Closing the FY

14 Sunday Jun 2015

Posted by Helifromfinland in Events, General

≈ Leave a comment

It’s the end of Oracle fiscal year and now it’s time to close the books for that fiscal. I did have a busy year. I wrote my first book

http://www.mheducation.co.uk/9780071850094-emea-oracle-sql-developer-data-modeler-for-database-design-mastery

I attended two OTN Tours. I had four sessions at the Oracle Open World, I taught the first time at the OU Expert Summit and much more. And being honest I was very sick for 4 months so I actually only had 8 months to do that all 🙂 I spoke in (at least) these events:

21.-26.5.2015 OTN EMEA Tour: Portugal, Jordan, South Africa

16.5.2015 Wildcard Unconference, Riga, Latvia

23.4.2015 Oracle University Expert Summit, Bucharest, Romania

22.4.2015 RoOUG, Bucharest, Romania

12.-14.3.2015 OUGN, Norway

22.1.2015 Riga Dev Day, Riga, Latvia

18.–20.11.2014 DOAG Deutsche ORACLE-Anwendergruppe e.V., Nüremburg, Germany

13.11.2014 Oracle Roadshow, Turku, Finland

6.11.2014 Oracle Roadshow, Espoo, Finland

28.10.2014 Oracle Roadshow, Tampere, Finland

20.- 23.10.2014 Nordic ACE Director Tour: Sweden, Norway, Denmark, Finland 28.9.–2.10.2014 Oracle OpenWorld, San Francisco, USA

22.-26.6.2014 KScope14, Seattle, USA

13.-15.6.2014 BGOUG, Bulgaria

5.-6.6.2014 Harmony, Finland

20 events… wow! But I did have a wonderful year and I enjoyed every moment of it. Thank you for inviting me to speak in those amazing events and thank you OTN and the ACE program for funding many of my tours! Thank you Oracle Press for asking me to write the book.  I wonder what will happen this year…

BGOUG, Day 2

13 Saturday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

It’s the second day of BGOUG conference. The first day was excellent and was highlighted by a great party in the evening: good food and drinks, great company and lots of dancing! Not to mention the nice speech Philip Stoyanov gave at the party before we had a raffle for two lucky winners for a copy of my book 🙂

The second day started with a breakfast at 8 and the sessions at 10. I have been working the whole morning (answering questions from customers about Data Modeler, preparing my sessions etc) and I just realized that while you are travelling you do not make a difference if the day is a weekday or Saturday/Sunday. It’s 11.30 am now and I was wondering why people do not reply my emails. Now I know: it’s Saturday 🙂

Today I will have two sessions: one about comparing designs and database (at 14:00) and another one about reporting (at 15:00). Both sessions are in Plovdiv 3. I hope to see you there!

Cheers,

Heli

BGOUG is about to start

12 Friday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

Now I am in Plovdiv, Bulgaria and the BGOUG conference is about to start…

Travelling around and trying to do your job on the side is not always easy: usually it means you will not sleep much… Well here we go… and this will be a great conference as BGOUG always is!

Oracle SQL Developer Data Modeler for Database Design Mastery available in EMEA!

12 Friday Jun 2015

Posted by Helifromfinland in Data Modeler, Database design, General

≈ 6 Comments

My book is finally available in EMEA:

Amazon
http://www.amazon.co.uk/Oracle-Developer-Modeler-Database-Mastery/dp/0071850090/ref=sr_1_1?s=books&ie=UTF8&qid=1434007533&sr=1-1&keywords=9780071850094

M-H Education EMEA
http://www.mheducation.co.uk/9780071850094-emea-oracle-sql-developer-data-modeler-for-database-design-mastery

ilOUG Tech Days 2015

08 Monday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

Tomorrow it starts: the ilOUG Tech Days 2015 in Haifa, Israel. I travelled all day yesterday to be here in time to attend the fantastic guided tour by Ika, the best guide in Israel. We had a wonderful day at the Nazareth area. After the tour I needed to work a little and then to dinner. Then I prepared my slides for tomorrow. I will be talking about agile database design, reporting with Data Modeler and about database security. And I will give one copy of my new book away in each Data Modeler session…

Hope to see you tomorrow! Now it’s time to go to bed…

Why does my Data Modeler look different from yours?

06 Saturday Jun 2015

Posted by Helifromfinland in Data Modeler

≈ Leave a comment

There is still some confusion on different appearances of Oracle SQL Developer Data Modeler. I hope this will explain a bit.

There are two different appearances of Data Modelers: the one integrated in Oracle SQL Developer and the standalone Data Modeler. And they do look different and using them is different. If you want to design the databases I would recommend the standalone version. I would use the integrated version mainly as a viewer to Data Modeler.

Integrated version:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html

Standalone:

http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

The #EOUC2015 in Lisbon

04 Thursday Jun 2015

Posted by Helifromfinland in Events

≈ Leave a comment

I just got back from the EMEA user group leaders’ meeting in Lisbon. It was so great to see so many amazing friends again!

During the meeting we for instance agreed on the Ambassador program (DOAG and UKOUG will organize the election for new Ambassadors pretty soon) and the new and improved way of counting votes for the OOW when we select our EOUC speakers. I posted about these to Oracle community platform.

I hope I will have time later to blog more about the meeting. Unfortunately my pictures are not very good so cannot share them 😦

Now back to work. On Sunday I will fly to ilOUG and so much work I must finish before that…

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
 

Loading Comments...