Generating a Data Dictionary Report and Diagram for a SubView

thatjeffsmith SQL Developer 5 Comments

Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll …

User Defined Properties in SQL Developer Data Modeler

thatjeffsmith SQL Developer 5 Comments

There are tons of properties you can set in your design objects. In fact, I discovered a ‘new’ one this week thanks to my friend David. #Oracle #SQLDev Data Modeler users please up vote my feature request to allow additional “display as” componentshttps://t.co/2fIbVXmIn9::: — david schleis (@dschleis) October 12, 2016 Display as…what’s he talking about? Oh, this. But what if …

Discovering Foreign Keys in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 4 Comments

Columbus didn’t exactly discover America. And we’re not really going to discover your long, lost foreign keys. But, we’ll do our best to guess where they might be. Our data modeling tool is often the bearer of bad news – your database doesn’t actually have any referential integrity defined. Oh, it’s defined somewhere, in the application. Probably. Just not in …

More Fun with Data Modeler Diagrams

thatjeffsmith SQL Developer 6 Comments

Everyone likes pictures. Generate a report without any pictures, graphs, or charts and see how many ‘likes’ you get at work. Everyone gets excited about data modeling, and in some circles, folks think that data models are synonymous with diagrams. But really, the diagram is just the ‘pretty picture’ you add to your office report. Don’t get me wrong, these …

‘Modeling’ View Dependencies in SQL Developer Data Modeler

thatjeffsmith SQL Developer 8 Comments

Today’s question: Please let me know how can I represent relation between view and base table in ER diagram created using sql datamodeler version4. So I know what the person is getting at here. They want to see the dependencies. Generally speaking, there are no actual relations between views and tables. Exception: you CAN define foreign key constraints on VIEWS, …

Oracle SQL Developer Data Modeler 4 User Interface Improvements

thatjeffsmith SQL Developer 2 Comments

The name probably gives it away, but just in case you weren’t aware of this, Oracle SQL Developer Data Modeler is an extension of Oracle SQL Developer. They share a framework that is derived from JDeveloper. The latest framework has some new user interface widgets that were adopted directly from Netbeans. I’ve blogged a bit on this topic in regards …

Oracle SQL Developer Data Modeler Primer: Navigating Designs, Models, and Diagrams

thatjeffsmith SQL Developer 15 Comments

It’s worth a few moments to get your bearings when using a new program. Or maybe you’ve been using SQL Developer Data Modeler for awhile now, and just haven’t taken the time to understand how designs, models, and diagrams are handled. This short post will fill in a few gaps and increase your comfort level with the tool, so please …