What’s new in Data Modeler 4.2EA? Part 3: A View and a Query

Starting in version 4.2.0 (build 917) known as 4.2EA you can define the query for a view without using the Query Builder. You can simply type or copy/paste the SQL query wanted to the new Query box in a new Query tab located in the View Properties:

ea2_6

You can test the query by pressing the Test Query button. If I had pressed that button I had noticed that I made a typo on table name (load vs. loan) 😀 This button is very useful…

Of course the Query Builder is also available if you rather use that. But when and why would I like to use this new functionality? I know that using this functionality there will be no lost of formatting, no problems with hints, no problems with the comments inside the query etc. In short no editing that is not done by me 🙂

 

 

What’s new in Data Modeler 4.2EA? Part 2: Change Requests

Enhancements in Change Requests

Starting in version 4.2.0 (build 917) known as 4.2EA you can create Change Requests in the Browser. Right-click the Change Request in the Browser and select New Change Request.

ea2_3

 

There is also a new tool for managing the Change Requests called Change Requests Administration. You can find it under the Tools menu:

ea2_4

And this is how the tool looks like:

ea2_5

Are you interested in learning more about Change Requests?

https://helifromfinland.wordpress.com/2014/10/18/handling-change-requests-with-data-modeler/

 

 

What’s new in Data Modeler 4.2EA? Part 1: Design Rules

4.2EA is mostly bug fixes but there are also some new features that I think you should know about. I will blog about some of them in a serie of What’s new in Data Modeler 4.2EA posts. This is the first one of that serie.

Design rules for a subview or a selected set of objects

Starting in version 4.2.0 (build 917) known as 4.2EA you can apply design rules to objects in a subview (they will not be applied to objects that do not exist in this subview). Simply right-click on the canvas of a subview and select Design Rules.

ea2_1

You can also select one or more objects from the canvas, right-click and select Design Rules. The rules will only apply to the selected objects.

ea2_2

 

 

What is a Design Rule?

https://helifromfinland.wordpress.com/2016/07/21/design-rules/

 

 

ACED Briefing and OOW16

I am home! After a very intense 10 days in San Francisco.

Quite jetlagged and so much work waiting for me to finish 🙂 But I am happy. It was such a privilege to be able to attend both the Oracle ACE Director briefing and the Oracle Openworld 2016!

People often ask me, after the OOW, what is new in the Oracle space. I am sorry but I cannot answer that question. The ACED briefing has a very strict NDA that does not allow me to tell anything I heard during those two days and because I am always too busy during the OOW to really see and hear what is publicly announced I have decided not to say anything, just to be sure I do not violate the NDA. So please do not get upset that my answer is I do not say anything.

It all started with the ACED briefing at the Oracle HQ. I was staying at the Sofitel hotel with a beautiful view (too bad I was not in my room except for sleeping):

sofitel

The ACED briefing was for two days (Thursday and Friday), including highlights like meeting Thomas Kurian:

thomas

Working intensively with my friends and colleagues:

aced

And attending a morning exercise session by my friend Kent Graziano:

kent

After the intense two days at the HQ we moved to San Francisco to start the OOW. I gave two sessions during the event: one about Big Data together with my friend Elise Valin-Raki and another sessions about (still) my favourite topic on how to design databases using Oracle SQL Developer Data Modeler. Elise and I were pretty cordinated with our dresscode:

bigdata

I also attended the WIT panel organized by OTN and Laura Ramsay:

wit

And stayed after the panel to talk with people and answer their questions as well as I could:

wit2

OTN and Oracle Press also organized a book signing event for our new book:

book1book2

It was a fun book to write. I hope you will like reading it🙂

I am a member of the ACE community but also a member of the user group community. Part of that commitment is helping at the user group kiosk. I scanned everybody with my new toy😀

scanner

Besides of the huge amount of content OOW is also all about parties and meeting people. Every evening there are plenty of parties… This photo is from the reception organized by Loïc Le Guisquet:

loic

The best part of both these events is still meeting friends and making new friends. Just a few eaxmples🙂

friends5friends6friends7friends1friends2friends3friends4ace

And to meet these friends from the Oracle community gets even more exciting when you start to know them better. This year I learned that my friend Arup Nanda is not just a great Oracle expert and a wonderful person but also a gifted artist. This is a painting he gave me as a present:

painting

I love it!

Now the OOW is over and I’m back to home again. It was a great 10 days. Thank you for letting me speak, thank you for all the great feedback and thank you Oracle ACE Program and OTN for treating me so well! I cannot wait for OOW17!

 

Cheers,

Heli

Data Modeler 4.1.5 is OUT!

I love the Oracle OpenWorld time: interesting things happen!

Data Modeler 4.1.5 is out but so is the EA for 4.2!

Go and download:

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

 

What’s new in 4.1.5? Plenty of bugs fixed:

“Date: September 2016

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.3.

24642626 – MODIFIED OBJECTS DO NOT APPEAR IN INCOMING CHANGES
23214498 – NEED TO DELETE TWICE WHEN DELETE STRUCTURED TYPE
24618730 – CANNOT GENERATE DDL WHEN TABLE HAS $ IN THE NAME – FOR AUTOINCREMENT COLUMN
24570374 – LIKE CONDITION IS IMPORTED AS LOV CONSTRAINT
22596042 – FOREIGN KEYS NOT RECOGNIZED IN SYNC USING THIRD PARTY JDBC DRIVER
23504656 – UDP LIBRARIES PUT INTO DESIGN’S FILES DIRECTORY ARE NOT LOADED
23258992 – [IMPLICIT] AS OWNER SHOULD NOT BE INCLUDED IN DDL FOR DB2/390
24009706 – ADVANCED SEARCH – CANNOT USE TWO OR MORE FILTERS WITH THE SAME PROPERTY
23561479 – DYNAMIC/USER DEFINED PROPERTIES DO NOT APPEAR IN SECOND LEVEL OBJECTS IN REPORT
23737449 – CHANGING PRIMARY KEY NAME IS NOT SAVED
22681021 – SAVED MODEL INCOMPLETE AFTER SAVE UPON EXIT
22761767 – LABELS IN RELATIONAL MODEL ARE NOT SIZED PROPERLY AND TEXT IS WRAPPED AND HIDDEN
22394744 – EDIT ONE DOMAIN PROPERTY – CAN NOT ADD COMMENT
22462199 – MANY TO MANY RELATIONSHIP NOT ENGINEERED PROPERLY – RELATIONSHIP ATTRIBUTES

Let’s talk more about EA 4.2 a bit later…

 

Cheers,

Heli

OOW16

It’s that time of year again, OOW is getting closer… This year I will have two presentations:

  • Introduction to the Big Data World [UGF2116]
    Sunday, Sep 18, 11:45 a.m. – 12:30 p.m. | Moscone South—305
  • Design Your Databases Using Oracle SQL Developer Data Modeler [CON2120]
    Monday, Sep 19, 4:15 p.m. – 5:00 p.m. | Park Central—Concordia

I hope to see you there!

I will also attend the #OTNWIT Panel on Sunday. You can find more information about it here: https://community.oracle.com/events/3592

Please join us!

Before OOW we will have the Oracle ACE Director briefing at the Oracle HQ. That is one of the highlights of my year🙂

Oh, and this will be a bit special OOW too because my new book just came out:

SQL-231x300

https://www.amazon.com/Real-World-SQL-PL-Experts/dp/1259640973/

I wrote it together with my good friends Arup, Brendan, Martin and Alex. Chet, our own Oraclenerd, was our tech editor. He also wrote the foreword together with my very own Oracle-dad Tim Hall. I hope you like the book! And if you want it signed OOW is a great place for that because we will all be there🙂

 

See you soon in San Francisco!

— Heli

 

Delete Object/Delete View

What is the difference between Delet Object and Delete View?

If you right-click and object in a diagram there might be two options: Delete Object and Delete View. “Might” because the Delete View is only available if you have that object in more than one diagram.

DeleteObject

Delete Object removes that object totally from the design: from this diagram and from all diagrams where it exists. The object is totally deleted from the design. If the object exists in more than one diagram, you will also see the Delete View option. That will delete the object BUT only from this diagram, not from the whole design.

Let’s see an example with an entity called Product.

This is the Logical Model:

DeleteObject2

This is a subview:

DeleteObject3

Now in the subview I select Delete View for the entity Product.

The Logical Model still has the entity Product:

DeleteObject2

But the subview does not:

DeleteObject4