permaculture playing cards
The moose likes Oracle/OAS and the fly likes Database Design Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Database Design" Watch "Database Design" New topic

Database Design

Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
I have inherited an excel workbook which has been used as a database. I would like to get all the infomation inside a properly design schema with as little fuss as possible. However the data on the spreadsheets is laid out along two time axies one being time period 1980 - 2012 and the other being age 0 - 25. What is the best way of designing tables that take into account time series data and what is the easiest method of extracting data from excel into oracle ?
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

I'd say the easiest is using SQL Loader. You can save your Excel spread sheet as a .csv comma seperated file, then you can load the data into any structure that you want. I wouldn't try to design the structure directly from the spreadsheet, but I would ask what is stored as data, what is the information about, what is needed, then design the data tables, then extract the data from the spreadsheet, and determine how to load the data.
But SQL Loader is the best route.

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Database Design
It's not a secret anymore!