Comparison of Business Intelligence Strategies between SQL and Oracle

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Priyankara » Comparison of Business Intelligence...

12 posts, Page 1 of 2

1 2 »»

Comparison of Business Intelligence Strategies between SQL and Oracle

Rate Topic

Display Mode

Topic Options

Author

Message

Dinesh Priyankara

Posted Friday, May 16, 2003 12:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp

Post #12267

ckempste

Posted Monday, May 19, 2003 2:43 AM

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

vipulaye

Posted Monday, May 19, 2003 11:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 05, 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

Dinesh Priyankara

Posted Monday, May 19, 2003 9:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

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

Mike Pearson

Posted Tuesday, May 20, 2003 5:12 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 04, 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

Mike Pearson

Posted Tuesday, May 20, 2003 5:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 04, 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

Antares686

Posted Tuesday, May 20, 2003 5:48 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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

Dinesh Priyankara

Posted Tuesday, May 20, 2003 6:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

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

dweil

Posted Thursday, May 22, 2003 9:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 8:05 AM
Points: 127, Visits: 2,114

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

Dinesh Priyankara

Posted Thursday, May 22, 2003 10:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174, Visits: 95

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 »

12 posts, Page 1 of 2

1 2 »»

Permissions