Tag: data modeling

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

SQL Developer Data Modeler Quick Tip: Use Oracle JOIN Syntax or ANSI

New for version 3.1, currently available as a EA download, when defining the queries used to populate views, the modeler can generate JOINs using either Oracle’s or the standard ANSI compliant syntax. Let’s step back a second. When working with a VIEW defined in a relational model, the modeler has twp choices for defining the […]

Similar Posts by Subject Areas: , , ,

How To: Generate an ERD for Selected Tables in SQL Developer

Entity Relationship Diagrams tell a story. An employee is assigned one department. A location can house one or more departments. Jeff doesn’t have a boss because he is ‘the man.’ It can be challenging to understand the nature of your data by simply reading through the list of Foreign Key constraints for a table. Who […]

Similar Posts by Subject Areas: , ,

SQL Developer Data Modeler Quick Tip: Use SubViews

Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,