ThatJeffSmith

Tag: data modeling

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

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: , , ,

Oracle SQL Developer Data Modeler v3.3 is Now Available

Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of new features and download the tool on […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,