ThatJeffSmith

Tag: data modeling

My Favorite SQL Developer Data Modeler Features

I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports […]

Similar Posts by Subject Areas: ,

How to Preserve System Generated Constraint Names in Oracle SQL Developer Data Modeler

The risk of posting a question here, is that I might take it and turn it into a blog post. And that’s where today’s topic comes from. I imported data dictionary into SQL data modeler and cannot found out how to disable predefined constraint names. Table “T” was created in database without specifying primary key […]

Similar Posts by Subject Areas: ,

Finding Calculated View Columns

Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the […]

Similar Posts by Subject Areas: , ,

Adding and Removing Objects from a SQL Developer Data Modeler SubView

SubViews are a sub-collection of model objects. They are very useful for breaking up very large designs into smaller, easier to digest pieces. If you need to brush up on the topic a bit, try these posts. I recently received a note from a user, we’ll call him ‘Galo’ – who was having problems figuring […]

Similar Posts by Subject Areas: , , ,

How To Version Control Your SQL Developer Data Modeler Designs

Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free. So for no money, you can design your database objects, and version control them for one or more people. I’ve put together some slides for your enjoyment: Oracle SQL […]

Similar Posts by Subject Areas: , , ,

Defining Storage Properties for Primary and Unique Columns in SQL Developer Data Modeler

Going through our enhancement requests in The Exchange this week, I was struck by how many folks were asking for features that are already there. There were at least three requests for being able to define how the Indexes are handled for table columns defined as Primary Keys or Unique. Here’s an example that summarizes […]

Similar Posts by Subject Areas: , ,

Defining 12c IDENTITY Columns in Oracle SQL Developer Data Modeler

You’re excited to see that defining triggers and sequences to populate identity columns in Oracle Database is no longer required. You have an Oracle Database 12c instance up and running, and you’re ready to hit the ground running. Wait, what is Jeff talking about? Ok, let’s say I have a ‘BEER’ table. My Primary Key […]

Similar Posts by Subject Areas: , , ,

Dimensional Modeling in Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler (SDDM) is a free data modeling solution. It supports many types of modeling levels, including: logical relational physical (multi-)dimensional When I present overviews on our database tools, I have this slide that shows what SDDM is capable of: I am not a real data modeler. However, I can fake my […]

Similar Posts by Subject Areas: , ,

Oracle SQL Developer Data Modeler v4.0 Is Now Available

The title says it all. Version 4 is now available, replacing v3.3 as the current version. What you need to know: Downloads New Features Release Notes Docs My Two Favorite New Features Comment Only Views If you need to publish or produce a diagram for less technical users, with just an overview of entities or […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,