ThatJeffSmith

Tag: data modeling

Oracle Open World 2012: SQL Developer Recap

Last week was the ‘big show’ in San Francisco. I was very happy to meet many of you in person. And many of you had questions – lots of questions! We had full or overflowing rooms for our sessions and hands-on-labs. The SQL Developer ‘booths’ were also slammed several times. So exciting to see so […]

DDL Script Previews in Oracle SQL Developer Data Modeler

Data Definition Language (DDL) is used to describe an object in SQL. When you model a table in your relational model using Oracle SQL Developer Data Modeler, you are probably very curious as to the code that is being generated to represent that object. You can peek into this code using your mouse – You […]

Entity Relationship Diagrams (ERD)

I have a nasty habit of not thinking. I take something for granted or assume something for so long, that it corrupts my original learning or understanding of a concept. And then when someone calls me out, my first reaction is to defend my ‘shortcut’ thinking instead of re-evaluating my set of assumptions. So I’ve […]

Managing Different Physical Implementations of your Relational Data Model

Near the end of a product demonstration with a customer yesterday, someone asked how they could build physical models for each of their different environments using Oracle SQL Developer Data Modeler (SQLDev.) Imagine having a application and database setup ‘out of the box’ that adequately described your meta data. But, you might have one implementation […]

SQL Developer Data Modeler Quick Tip: Preferred Data Types

There are many data types to choose from when defining your table columns. The eighty percent rule tells us we can probably get away with a smaller subset of data types eighty percent of the time. Here is what the ‘TYPE’ control looks like in the modeler when defining a column: I was curious to […]

Visualize Your DDL Scripts

Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in […]

SQL Developer Data Modeler Quick Tip: Use Oracle JOIN Syntax or ANSI

New for version 3.1, currently available as a EA download, when defining the queries used to populate views, the modeler can generate JOINs using either Oracle’s or the standard ANSI compliant syntax. Let’s step back a second. When working with a VIEW defined in a relational model, the modeler has twp choices for defining the […]

SQL Developer Data Modeler Quick Tip: Hide and Resize

Ever seen a table with so many columns you wonder if the designer had fallen out of the de-normalization tree and had hit every branch on the way down? Oracle currently allows a max of 1,000 columns per table. Please do not test this limit. Maybe you do need that many columns, but I doubt […]

How To: Generate an ERD for Selected Tables in SQL Developer

Entity Relationship Diagrams tell a story. An employee is assigned one department. A location can house one or more departments. Jeff doesn’t have a boss because he is ‘the man.’ It can be challenging to understand the nature of your data by simply reading through the list of Foreign Key constraints for a table. Who […]

SQL Developer Data Modeler Quick Tip: Use SubViews

Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying […]

You Know What Grinds My Gears? – Database Design Edition

I think one of the dirty secrets in the software business is how LITTLE feedback we get from our end-users. You know they are out there though, gritting their teeth, cursing the day someone trusted you with a keyboard and mouse. Some of this software is very expensive to boot, so one would expect these […]