Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Design

 
Nigel Browne
Ranch Hand
Posts: 703
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
Regards
Nigel
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic