ThatJeffSmith

Tag: data modeling

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

Similar Posts by Subject Areas: ,

Oracle SQL Developer Data Modeler 4 User Interface Improvements

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

Similar Posts by Subject Areas: , , , ,

SQL Developer Data Modeler: On Notes, Comments, and Comments in RDBMS

Ah the beautiful data model. They say a picture is worth a 1,000 words. And then we have our diagrams, how many words are they worth? So our models describe how the data ‘works’ – whether that be at a logical-business level, or a technical-physical level. Developers like to say that their code is self-documenting. […]

Similar Posts by Subject Areas: , ,

Increased Flexibility for Oracle SQL Developer Data Modeler Diagrams in v4

I recently talked about how you could tell the modeler to use custom classification types for your tables. But, I forgot to tell you where you could find these settings in version 4! Surprise – we moved them. Excellent… Sometimes I think developers change stuff because they’re bored or maybe even because they don’t realize […]

Similar Posts by Subject Areas: , ,

Defining Redaction Policies for Oracle Database 12c Data Models in Oracle SQL Developer

Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it here and read about the new features here. A snippet of those new feature release notes… Masking Mask templates can be defined and used in definition of columns with sensitive information. Support for REDACTION […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer Data Modeler: What Tables Aren’t In At Least One SubView?

Organizing your data model makes the information easier to consume. One of the organizational tools provided by Oracle SQL Developer Data Modeler is the ‘SubView.’ In a nutshell, a SubView is a subset of your model. The Challenge: I’ve just created a model which represents my entire ____________ application. We’ll call it ‘residential lending.’ Instead […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,