ThatJeffSmith

Tag: data modeling

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

Similar Posts by Subject Areas: , , ,

Querying Your Oracle SQL Developer Data Modeler Designs

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then […]

Similar Posts by Subject Areas: , , , ,

How to Synch your Oracle SQL Developer Data Model to a Different Database

First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different […]

Similar Posts by Subject Areas: , , , , ,

How to Quickly Set Classification Types for Tables in Oracle SQL Developer Data Modeler

Your relational model may for a data warehouse or star schema where you need to define a table as being a dimension or fact. Or maybe you’re like my friend who asked me this question last night: If I’m looking at about 90 Dimension tables which all have the name prefaced by “Dim” how can […]

Similar Posts by Subject Areas: , , ,

Won’t You Be My Neighbor? Selecting Related Objects in Oracle SQL Developer Data Modeler

I loved Fred Rogers. He helped raise me. Nicest guy ever? So what does he have to do with Oracle SQL Developer Data Modeler? One word, ‘neighbors.’ I got a good question from a new user yesterday: Is there a quick way to add all the tables (to a subview) directly related to a specific […]

Similar Posts by Subject Areas: , , ,

How to Create or Open a Data Model in Oracle SQL Developer

The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products: Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL […]

Similar Posts by Subject Areas: ,

Managing Table and Column Comments in Oracle SQL Developer

An interesting question came up on the ORACLE-L mailing list this morning regarding table comments: Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”. Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data […]

Similar Posts by Subject Areas: , ,

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

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

Similar Posts by Subject Areas: , , , ,

Synching your Oracle SQL Developer Data Model with the Database

So you’ve been working on your data model, and you’re wondering how far ‘out of whack’ it is with the production or development database instance. Sometimes folks manage to compile changes into the database, bypassing your design process and rules. If you’re wondering how to compare 2 models instead of your model with the database, […]

Similar Posts by Subject Areas: , , ,

Configuring Display of Model Relationships in Oracle SQL Developer Data Modeler

The end goal for many users of Oracle SQL Developer Data Modeler is a a nicely formatted, easy to read diagram. Diagrams are composed of two primary components: Tables or Entities Relationships Today’s post is all about how to manage the display of the relationships. How can I move the lines around? You might not […]

Similar Posts by Subject Areas: , ,

Managing Storage Properties for Multiple Tables in Oracle SQL Developer Data Modeler

There were more than a few questions I didn’t get a chance to answer in last week’s webcast with @ODTUG, ‘Data Modeling 101 with Oracle SQL Developer.’ If you’re a member of ODTUG, then you can watch or download the webcast. If you’re NOT a member, you can still sign up to attend KSCOPE13 in […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,