ThatJeffSmith

Tag: data modeling

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

Similar Posts by Subject Areas: , ,

How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler

Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing […]

Similar Posts by Subject Areas: , ,

SQL Developer Data Modeler v3.3 Early Adopter: Link Model Objects Across Designs

The third post in our “What’s New in SQL Developer Data Modeler v3.3” series, SQL Developer Data Modeler now allows you to link objects across models. If you need to catch up on the earlier posts, here are the first two: New and Improved Search Collaborative Design via Excel Today’s post is a very simple […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,