ThatJeffSmith

Tag: data modeling

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

Similar Posts by Subject Areas: , ,

SQL Developer Data Modeler v3.3 Early Adopter: Collaborative Design via Excel?

As you may have heard last week, we have a new version of Oracle SQL Developer Data Modeler now available as an Early Adopter release. Version 3.3 has quite a few new features and I’ll be previewing them here. Today’s topic is our new Excel integration. It builds off of last week’s lesson: Search, so […]

Similar Posts by Subject Areas: , , ,

SQL Developer Data Modeler v3.3 Early Adopter: Search

The next version of Oracle SQL Developer Data Modeler is now available as an Early Adopter (read, beta) release. There are many new major feature enhancements to talk about, but today’s focus will be on the brand new Search mechanism. Data, data, data – SO MUCH data Google has made countless billions of dollars around […]

Similar Posts by Subject Areas: ,

Importing Multiple Schemas to a Model in Oracle SQL Developer Data Modeler

The schemas are automatically used to create default SubViews

Your physical data model might stretch across multiple Oracle schemas. Or maybe you just want a single diagram containing tables, views, etc. spanning more than a single user in the database. The process for importing a data dictionary is the same, regardless if you want to suck in objects from one schema, or many schemas. […]

Similar Posts by Subject Areas: , , , ,

Entity Relationship Diagrams (ERD)

I have a nasty habit of not thinking. I take something for granted or assume something for so long, that it corrupts my original learning or understanding of a concept. And then when someone calls me out, my first reaction is to defend my ‘shortcut’ thinking instead of re-evaluating my set of assumptions. So I’ve […]

Similar Posts by Subject Areas: , ,

Managing Different Physical Implementations of your Relational Data Model

Near the end of a product demonstration with a customer yesterday, someone asked how they could build physical models for each of their different environments using Oracle SQL Developer Data Modeler (SQLDev.) Imagine having a application and database setup ‘out of the box’ that adequately described your meta data. But, you might have one implementation […]

Similar Posts by Subject Areas:

Visualize Your DDL Scripts

Data models sure are handy. They tell a story – how does the information get stored as data? Just what is a ‘customer?’ Sometimes though our applications die and only leave legacy scripts behind. Or maybe you are a DBA and someone has given you a set of scripts to create some new objects in […]

Similar Posts by Subject Areas: , , ,

Generating HTML Data Dictionary Reports with Oracle SQL Developer

I’m going to go out on a limb and guess that most people who use SQL Developer do not realize it has a fully-baked data modeling tool built into it. It’s not like we hide it, but we kind of hide it. To open the Data Modeler inside of SQL Developer, navigate to the View […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,