Author Archives: Helifromfinland

My plans for 2016

29 Tuesday Dec 2015

Posted by in Events, General

≈ 2 Comments

To me 2016 looks very exciting. I will start my doctoral studies at Helsinki University. I will be studying and researching Big Data, semistructured data and schema discovery. That research is related to the work I have done more than 20 years but it is also something completely new. I am really excited!

Another interesting new thing is that I have been invited to speak in many conferences just like Kellyn Pot’Vin-Gorman predicted (@dbakevlar) 🙂 and I am so glad about that because as a typical Finn I am not very good in abstracts and convincing I should be selected… I am really sorry I have said NO to some of those invitations 😦 I hope I can say YES next time…

In 2016 I will have completely new topics and areas as well as my “old” topics and areas to talk about. Topics for 2016 include SQL Developer, WIT, cloud, APEX and I am sure that later this year I cannot stop myself from talking about Big Data, schema discovery and other things I learn and study during this year. Now I am studying Machine Learning…. Of course I will be talking about database designing and Oracle SQL Developer Data Modeler!

So far I am planning to talk in these events in 2016:

GaOUG Tech Day 2016, March 3 in Atlanta, Georgia, USA

OUGN, March 10-12, Oslo, Norway

Ari Hovi Oy April 7.-8., Tietokannan suunnittelu Data Modelerilla, Helsinki, Finland

Collaborate, April 10-14, 2016, Las Vegas, USA

OUGF, EXA-SIG, April 21, Helsinki, Finland

APEX Connect 2016, 26.-28.4.2016 Berlin, Germany

AMIS 25 – Beyond the Horizon, June 2-3

ODTUG KScope16, June 26-30, Chicago, USA

 

And hopefully by OOW16 a book I have been coauthoring will be out, it is about SQL and PL/SQL.

 

Have a wonderful end of 2015 and a very happy and joyful 2016! Hope to see you in 2016!

Heli

Data Modeler 4.1.3 is OUT

23 Wednesday Dec 2015

Posted by in Data Modeler

≈ 1 Comment

The development team has been busy! 4.1.3 is now out and plenty of bugs fixed.

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

Bugs fixed (from the download pages):

22350565 String index out of bounds exception while importing structured type method bodies
22311829 Table report generating duplicate FK columns
22350611 Cannot select relationship/foreign key line
22339253 Change request report does not generate data in the report
22187312 Error when running design rules using Data Modeler version 4.1.2.895

Year 2015, wrap-up

09 Wednesday Dec 2015

Posted by in Events, General

≈ Leave a comment

I know, I know, 2015 is not over yet 😀

But I was thinking to wrap-up now so I can continue planning 2016 😉 2016 will be sooooo exciting….

Kirja

2015 was definitely the busiest year ever but I might as well say that it was a great year. My first book came out, I have been writing my second book (it should be out by OOW16) and speaking in (at least) 24 events. Please tell me if your event is not on this list, I have totally lost the track:

Oracle Cloud Day (2.12.2015), Helsinki, Finland

BGOUG (20.-22.11.2015), Pravets, Bulgaria

DOAG (17.-19.11.2015), Nuremberg, Germany

Oracle OpenWorld (25.-29.10.2015), San Francisco, USA

HrOUG (13.-16.10.2015) , Rovinj, Croatia

SIOUG 2015 (12.-13.10.2015) , Portoroz, Slovenia

Oracle Innovation Day (7.10.2015), Tallinn, Estonia

OUGF, Nordic ACE Director Tour (15.9.2015) , Helsinki, Finland

OTN LAD Tour 2015

  • 14.8. Mexico
  • 17.8. Guatemala
  • 19.8. El Salvador
  • 21.8. Panama
  • 24.-25.8. Ecuador

Kscope15 (21.-25.6.2015), Hollywood, Florida ,USA

BGOUG (12-14.6.2015), Plovdiv, Bulgaria

ilOUG Tech Days (9.-10.6.2015), Israel

OTN EMEA Tour 2015

  • Portugal 21.5.2015
  • Jordan 23.5.2015
  • South Africa 26.5.2015

Wildcard Unconference (16.5.2015), Riga, Latvia

Oracle Expert Summit (21.-24.4.2015), Bucharest, Romania

RoOUG 22.4.2015, Bucharest, Romania

OUGN (12.-14.3.2015), Norway

Riga Dev Day (22.1.2015), Riga, Latvia

In 2015 I was re-elected as the Ambassador for EOUC (EMEA Oracle Users group Community) for the next two years. At the OOW I was jumping to the cloud in Larry’s Keynote, met Mark Hurd and was awarded with a Oracle Database Developer Choice Award in Database Design category. And in December I was listed as the 12th of 100 TOP influencers on IT in Finland (http://okimoclinic.com/2015/12/04/announcement-top-finnish-ict-influencers-in-social-media-of-the-year/, http://summa.talentum.fi/article/tv/12-2015/100-tivi-vaikuttajaa/242826#). Just to mention some of the highlights of 2015.

I want to thank everybody who has bought my book, attended my sessions, invited me to speak and especially those wonderful collegues of mine who have been travelling with me around this beautiful globe. And of course the biggest THANK YOU to Roland, Vikki, Jennifer and the whole ACE Program and OTN for supporting many of my trips. Without your support this would not have been possible.

 

Thank you and have a wonderful December!

Heli

Oracle Cloud Day, Helsinki

09 Wednesday Dec 2015

Posted by in Events

≈ Leave a comment

My last presentation this year was extremely interesting: it was both my first presentation (EVER!) about cloud as well as APEX. I was speaking at the Oracle Cloud Day in Helsinki, Finland on a real customer case on building APEX applications on Oracle Cloud. Thank you Carus for letting me tell your story!

 

Thank you for attending the session and thank you so much for all the positive feedback! I guess I will keep on talking about both Cloud and APEX 🙂

 

Cheers

Heli

DOAG and BGOUG

09 Wednesday Dec 2015

Posted by in Events

≈ Leave a comment

My last trips this year were two amazing conferences: DOAG in Germany and BGOUG in Bulgaria. I am not sure if there would be a better way to end your travelling year!

Thank you very much for having me and thank you so much for the great hospitality! And please forgive me this blog post only comes out now: I have been far too busy lately.

 

Best wishes,

Heli

 

 

Data Modeler 4.1.2.1.899 is out!

03 Thursday Dec 2015

Posted by in Data Modeler

≈ 1 Comment

Data Modeler 4.1.2.1.899 is out with plenty of important bug fixes. Go and try!

 

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

From the download pages:

Oracle SQL Developer Data Modeler 4.1.2.1: Bugs Fixed

Date: December 2015

This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.2.

22109015 Table structure not available in browser for versioned designs
22120662 “Oracle errors to mask” tab is always disabled
22112910 Table has columns with undefined security properties’ for xmltype column
22186607 Constraint definition is missing in ddl when custom ddl script is used
22187312 Error when running design rules using Data Modeler version 4.1.2.895

Cheers

Heli

#DOAG2015 and #BGOUG

13 Friday Nov 2015

Posted by in Events

≈ 1 Comment

It’s time to pack again, the last time this year. Early on Monday morning I will fly to Germany to start my week-long tour in Germany and Bulgaria.

On Monday we will have an EOUC (EMEA Oracle Users Group Community) leaders’ meeting in Germany. I look forward seeing all the leaders of the user groups in EMEA, it will be a good meeting. In three hours I will have the final call with the organizing team and we will finalize the agenda based on the ideas about the content the leaders have told us.

Then on Tuesday the DOAG2015 starts! I will have two presentations about Data Modeler to present. This year I am not in that big and scary room 🙂 I hope to see you in my sessions!

On Thursday I will fly to Sofia, Bulgaria to present at BGOUG. I also have two presentations there. Milena (the president of BGOUG) informed us that there will be 370 registered attendees! That is an impressive number! Congrats Milena and BGOUG! Good job!

And on Sunday I will fly home.

It will be an interesting and wonderful week. See you all soon!

Heli

An Official Mentor

13 Friday Nov 2015

Posted by in General

≈ Leave a comment

I have been mentoring younger people on IT (or who ever has wanted me to mentor him/her 🙂 ) occasionally and unofficially for many years and I have been teaching anybody who is interested 🙂 But now I do have an official Mentor status!

My University (Helsinki University) has just nominated the first two mentors in the whole history of the department of Computer Science and guess what…I am one of them! This is a real honor! I am a bit surprised how excited I am about it. I will meet my students in less than two weeks and then it all starts…

Life is good,

Heli

Early Morning

11 Wednesday Nov 2015

Posted by in Events, General

≈ Leave a comment

This morning I woke up at 4 am to be able to finish “everything” before leaving for a super interesting training day:  The Logical Data Warehouse – Design, Architecture, and Technology by Rick van der Lans.

Last night I gave a webinar for the wonderful ODTUG people. It was about New Features of Data Modeler. I have always said NO when people have asked me to do a webinar. “No, I cannot talk to a camera, I need real people as an audience”, has always been my justification for saying no. But I must say that it was not actually bad at all. I definitely will never, ever listen to the recording (I would only find plenty of mistakes and my voice is terrible etc) but I must say it was not bad at all…I might be saying YES from now on…

I will be giving this same presentation at the DOAG conference in Germany next week and in Bulgaria at BGOUG in the end of next week. I just finished polishing my slides and updating my manuscripts for DOAG. On Monday I will fly to Germany. In Germany I will also talk about comparing functionalities in Data Modeler and in Bulgaria I will talk about how to manage changes in database structures.

Oh and I have found a new hobby: I answer questions on Oracle Community Platform. It’s actually very fun!

Now back to work so I will make it on time to the training…

Have a nice day!

Heli

Oracle SQL Developer Data Modeler 4.1.2

04 Wednesday Nov 2015

Posted by in Data Modeler

≈ 1 Comment

The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult. Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast!

If you have not downloaded it yet, this is the place to do it:

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

Some bug fixes (http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/data-modeler-bugsfixed-v412-2714842.html):

This list contains only a selection of higher priority bugs, customer bugs and issues raised by the community on the OTN Forum since the release of version 4.1.1.

21310122 Interactive DDL for automatically generated Indexes contains an invalid semi-colon
21436619 Different formatting causes Table Check Constraint to be marked as changed
21450718 Missing check constraint ddl (arc constraint) during merge
21471733 Save doesn’t remove deleted foreign keys
21627534 Grant flashback on an oracle table not supported
21617909 Domain can’t be locked without opening design
21487134 Not possible to populate the supertype table without having to populate subtypes
21805334 Journal trigger ddl refers to arbitrary “emp2” table instead of generated table
21417244 Table to view wizard to copy column comments in rdbms to view column
21935378 SVN – processing of outgoing changes is too slow
21935571 Unicode characters in domain definition are changed when save/reopen
21943476 Mandatory fields being reset to optional – model in single file mode

What has changed? Some things from the release notes (http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/data-modeler-relnotes-v412-2714825.html):

  • “Mozila Rhino” script engine is not distributed with JVM any more. It’s replaced with “Oracle Nashorn” scripting engine. Engine need to be changed in existing scripts.
  • Predefined RDBMS sites are no longer distributed in file defaultRDBMSSites.xml and will be removed from existing versions of that file.

  • Added new logical data type String

    Changed mapping for Oracle 12c for following types:

    • Binary – from BLOB to RAW
    • Boolean – from CHAR to Number

Let the database design work continue!

Cheers

Heli