Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old September 29th, 2003, 07:37 AM
mth1993 mth1993 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Detroit, MI
Posts: 9 mth1993 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Data warehouse MySQL vs Oracle

I am looking at a dataware house with 300 gb initially and considering what to use Mysql vs SQL Server vs Oracle. We will be running many complex queries often reading the whole DB, logic based on date calcuations, and likely reloading the whole DB on a weekly basis. Which DB seems best and why?

Reply With Quote
  #2  
Old September 29th, 2003, 08:50 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,917 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 52 m 3 sec
Reputation Power: 279
My personal list is:

1. Oracle 9.2: excellent feature set (views, stored procedures, external tables, upserts, unix platform, OWB ...)
2. MS SQL: good feature set (views, stored procedures, DTS ...)
3. MySQL: not really suitable (no views, no stored procedures ...)

I say this because I've already built some DWHs on Oracle and Ms SQL.

Reply With Quote
  #3  
Old September 30th, 2003, 04:38 PM
mth1993 mth1993 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Detroit, MI
Posts: 9 mth1993 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
What is your expriance on Oracle 9.2 vs MS SQL in this type of application.

Reply With Quote
  #4  
Old October 1st, 2003, 02:47 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,917 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 52 m 3 sec
Reputation Power: 279
Oracle has better features and handles larger database (Tb magnitude) and also runs on a more stable platform (Unix/Linux).
SQLServer is easier to use and comes with a whole built in ETL tool (DTS).

Reply With Quote
  #5  
Old October 2nd, 2003, 03:24 AM
wolfpacker94 wolfpacker94 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Posts: 2 wolfpacker94 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
1.) oracle is the best choice (if you can afford it), no doubt.
2.) sql server might be o.k.
3.) mysql is something my children will play with as soon as they learn to read.

Reply With Quote
  #6  
Old October 2nd, 2003, 06:00 AM
mth1993 mth1993 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Detroit, MI
Posts: 9 mth1993 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Wolfpacker94 - can you point me to some imperical data on this? I would really appricate any information.

Reply With Quote
  #7  
Old October 2nd, 2003, 09:20 AM
wolfpacker94 wolfpacker94 is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Posts: 2 wolfpacker94 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
first of all: excuse may english, it's not my mothertounge

oracle best choice: as pabloj mentioned before, oracle gives you many possiblies (functional and for performance) and can be VERY fast. It's impossible for me to discuss all this features (bitmap index, functional index, materialzed views, top n values ...etc.), it would take hours to explain all that.
if you can afford it: oracle licences are quite expensive and oracle needs permanent monitoring (my experience, the oracle salesman told us other things...) by a DBA.
sql server might be o.k.: i haven't much information about sql server, but all (serious) guys i talked to had been quite satisfied. sorry, i can't tell you more about that.
mysql: we use mysql as well, but just for smaller projects. we ran into many problems (performace) with complex applications.

why don't you try to get professional help by a serious company (don't go to oracle or ms, they will always tell you that their product is the best)? the bucks you invest now, will pay back soon.

greetings
w.

Reply With Quote
  #8  
Old October 2nd, 2003, 09:55 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,917 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 52 m 3 sec
Reputation Power: 279
wolfpacker94 has added a very important thing:

oracle needs permanent monitoring

that's true, you'll need an experienced DBA, possibly have him review the dwh before implementation, design for performance because datawarehousing really stresses the db.

MS SQL is very good, it will also need good tuning and monitoring, probably not as much as oracle, but I dont' think that it can scale up to Oracle's level.
But again, not every dwh goes into the terabyte range.

Reply With Quote
  #9  
Old August 9th, 2004, 01:46 PM
LinuxGold LinuxGold is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 3 LinuxGold User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Hmm, to revive this topic -- I'm looking for a good SQL with fast indexing -- so which one is better? I only need a fast indexing for my application...

Reply With Quote
  #10  
Old June 10th, 2005, 08:56 AM
Cliffb Cliffb is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2005
Posts: 6 Cliffb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 25 m 33 sec
Reputation Power: 0
SQL Server works pretty well for a Data Warehouse. We have a 2-3 TB DWH and have not had any issues with performance. DTS with stored procedures make the ETL jobs easy to maintain.

I've not used Oracle so I cannot speak to it's capabilities.

mySQL is great for smaller apps. Perhaps the next version will be suitable for more robust applications.

Reply With Quote
  #11  
Old June 10th, 2005, 10:37 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,917 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 15 h 52 m 3 sec
Reputation Power: 279
Cliffb, I'd like to know more about your environment, I've ventured in the Tb range with Oracle only and it would be great to hear some hands on experience with SQLServer.
Thanks in advance for any insight

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Data warehouse MySQL vs Oracle


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
Stay green...Green IT