ThatJeffSmith

Tag: data modeling

12c Temporal Validity Support in SQL Developer Data Modeler

Today’s question: can I design a table that takes advantage of the new Temporal Validity feature in Oracle Database 12c? Today’s answer: ‘Yes.’ In a nutshell: Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the […]

Similar Posts by Subject Areas: , , ,

SQL Developer Data Modeler, Pending Changes & Versioning

Oracle SQL Developer Data Modeler supports the one-gal design boutique shoppe and the mega-huge development team. It HAS a file-based repository (Subversion aka SVN.) You don’t have to use it, but you should. You can optionally store your designs and data dictionaries in a database for reporting purposes. I strongly recommend you do so. If […]

Similar Posts by Subject Areas: , , , ,

More Fun with Data Modeler Diagrams

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. […]

Similar Posts by Subject Areas: , , , , ,

Adding Common Columns to Tables via Templates and Transformation Scripts

In Oracle SQL Developer Data Modeler, you can create a table in your relational design that stores columns that you want to be added to all of your other tables. Call it, ‘table_template.’ Now call the transformation script. Tools > Design Rules & Transformations > Transformations. Before After These are cool, but they don’t belong […]

Similar Posts by Subject Areas: , , , , , ,

SQL Developer Data Modeler Screenshots

I’ve taken a TON of screenshots of both SQL Developer products to demonstrate features. I was playing around with Flickr to see if there was a better way to re-purpose this content other places. Here’s what that COULD look like. I have a few hundred more to add to this photo album. This is just […]

Similar Posts by Subject Areas: , ,

Are Invisible Columns Really Invisible?

Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding […]

Similar Posts by Subject Areas: , , , , , ,

‘Modeling’ View Dependencies in SQL Developer Data Modeler

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 […]

Similar Posts by Subject Areas: , , , , ,

Oracle SQL Developer Data Modeler v4.1 Early Adopter is now Available

We have a new version of SQL Developer Data Modeler for you to check out – version 4.1. It’s an ‘EA’ – or early adopter. So, no official support – all feedback should be provided via the OTN Forum/Community. It requires Java 8. If you see a message about not supporting Java 8 – ignore […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,