ThatJeffSmith

Tag: data modeling

Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?

I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, […]

Similar Posts by Subject Areas: , , , , , ,

Modeling Function Based Indexes in Oracle

@thatjeffsmith Is there a way to define a function-based index in #SQLDevModeler? — Kent Graziano (@KentGraziano) October 29, 2014 Function based indexes [DOCS] have been part of Oracle Database since at least version 8. Instead of just indexing someone’s name, you could also index the values returned by a function call over that name. Example […]

Similar Posts by Subject Areas: , , ,

Importing Your Data Dictionary to a new Oracle SQL Developer Data Modeler Design

I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer. So let’s do that now. Warning: Lots of pictures coming up. Want to import from SQL […]

Similar Posts by Subject Areas: , , ,

Data Modeling via Excel?

In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get […]

Similar Posts by Subject Areas: , , ,

30 SQL Developer Posts in 30 Days, Day 25: Importing Partitioned Tables to a Data Model

We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT […]

Similar Posts by Subject Areas: , , , ,

My Favorite SQL Developer Data Modeler Features

I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports […]

Similar Posts by Subject Areas: ,

Configuring Memory Usage in Oracle SQL Developer

Sometimes you need more memory. Here’s an example: you want to model a database that has 1500 tables in it. What would that even look like? If you zoom out far enough… Now, ‘large’ is a subjective term. But lets put it this way – if you’re dealing with more than several hundred tables or […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,