Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Comparison of Business Intelligence Strategies between SQL and Oracle Expand / Collapse
Author
Message
Posted Friday, May 16, 2003 12:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:21 PM
Points: 175, Visits: 107
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp
Post #12267
Posted Monday, May 19, 2003 2:43 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1
Hi there

One item you may have overlooked - its important to remember that the "user experience" in all of this is poorly served in both areanas of dbms's. For example the pivot control is hardly useful for any serious BI and the oracle express tools (name has probably changed) are clunky and somewhat limiting. When making a decision, take a careful look at the packages to deliver the real functionality to the end user such as Cognos and others (I cant remember the freaking names!). These tools all "plug in" to the underlying BI infrastructure and their associated API's, the plug in's may also be limitinng based on the company/version your connecting to, and worst still, if the GUI vendor does or does not support XYZ feature from the dbms vendor's cubes/bi framework. The other end of the stick is that the GUI vendor like cognos also gens its own the cubes, with a good security model wrappered around it; so then the matrix of choice broadens for you...

Dont expect to be coding up screens using API's, it may be very costly for you, and there are a huge number of vendors out there will all the hooks to MS and Oracle with extremely function UI's for your hardcore and "standard" users. Perhaps code up the "executives" BI screens yourself, but Id be supprised that you can pull off the rest.

Cheers

Chris





Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Post #62631
Posted Monday, May 19, 2003 11:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 5, 2007 10:21 AM
Points: 3, Visits: 1
Hello Everybody
Dinesh has done a good job in pointing the difference betwwen SQL Server and Oracle in favour of Sql Server.Since this place is only for SQL Server everybody will readily accept this but if you this article in an open place(where both Oracle & SQL Server guys can read) we would see a real debate between these two products and can evaluate better.
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp
[/quote]



Post #62632
Posted Monday, May 19, 2003 9:20 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:21 PM
Points: 175, Visits: 107
Hi all,
I received an email from Oracle expert saying it is not so much cost as I have mentioned. As per him, by using only Oracle Express, you can create BI platform even without DW Builder. Any idea?

Another thing, Cognos has so many products for BI like Decision Stream, PowerPlay. For entire BI platform, should buy all these products?


mcp mcse mcsd mcdba
Post #62633
Posted Tuesday, May 20, 2003 5:12 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 4, 2007 4:36 AM
Points: 27, Visits: 1
The costing is a very valid argument. Feature for feature you could make Oracle match SQL (or vice versa) to the point where the business wouldn't really care as long as they got their reports. The simple reality of it all is that the SQL option will be cheaper - and I have seen clients implement a SQL DW + a dedicated resource for the same price it would have cost them to take the Oracle route. In this period of IT Budget contraints (yada yada) price counts for an awful lot...




Post #62634
Posted Tuesday, May 20, 2003 5:15 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 4, 2007 4:36 AM
Points: 27, Visits: 1
...and besides, the SQL option is just sooooo much easier to implement! Less headache factor :)




Post #62635
Posted Tuesday, May 20, 2003 5:48 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Monday, October 20, 2014 1:24 PM
Points: 8,370, Visits: 743
I would have also added the difference in cost between and Oracle developer and a SQL developer for ongoing maintainence which can cause a TCO (Total Cost of Ownership) blowup.




Post #62636
Posted Tuesday, May 20, 2003 6:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:21 PM
Points: 175, Visits: 107
I wonder why the cost of Oracle developer so high. Because of Orcal DBA has wide knowledge than SQL DBA or besoming Oracle DBA is too difficult and too cost.

mcp mcse mcsd mcdba
Post #62637
Posted Thursday, May 22, 2003 9:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:17 AM
Points: 129, Visits: 2,440
Obviously an Oracle Fan wrote the following article. In relation to the article mentioned above and the very long discussion about Oracle VS SQL. Are all the arguments that the author makes correct and if so would the cost of Oracle be worth it??

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci834319,00.html


David Weil





Post #62638
Posted Thursday, May 22, 2003 10:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:21 PM
Points: 175, Visits: 107
As I think, this is depend on cost and familirity. I read the page what you have mentioned but can't agree to all like partitioning, triggers, external file accessing. Even bitmap indexing is also available in SQL 64-bit version. Some parts are unknown to me as I do not have much experience in Oracle. It is better to read this page by someone who has good knowledge on both sides and let us know.

mcp mcse mcsd mcdba
Post #62639
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse