Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vkushwaha
Starting Member
1 Post |
 Posted - 2007-12-14 : 15:35:43
|
| Hi, I am new to SQL 2005. I have to design schema for scientific data warehouse. Data is available in 2 or more flat data files recorded at 1 sec interval. At Least 2 of the data files have 100+ columns. I am inclined to create a table per data file type. I want to know If this is correct/optimal for me to do? I don't think I can create normalize tables based on the headers in these Data files.Primary Objective of this data warehouse is make it available for reporting services and Analysis Services.Any suggestions or tutorials for me?Thanks,Vinod Kushwaha |
|
|
JasonL
Starting Member
35 Posts |
Posted - 2007-12-18 : 19:50:29
|
| It sounds like a DataWarehouse project.If so:You need to ask yourself a few questions:1. How big is the database(table) going to be (DW terminolgy: mainly your FACT tables)2. What is accetaple performance level -- 3 hour? 3 minutes?4. What are the driving columns for query? (DW terminology: Dimensions table)The above questions/answers help you size your database, hardware and also designing your indexes and eventually your sql queries. Sorry could not too specific here based on information we have here. Seems like you need to readup a bit too or just prototype it :)Good luck.JasonL - http://blogs.msdn.com/usisvde/ http://ushipoisv.spaces.live.com/ |
 |
|
|
|
|
|
Scientific Data Table Design