Unix Technical Forum

Evaluating which database to choose

This is a discussion on Evaluating which database to choose within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi all, I wonder is there a list of topics/excel sheet/questions to be answered or asked from vendor when ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 05:29 AM
Kalle
 
Posts: n/a
Default Evaluating which database to choose

Hi all,

I wonder is there a list of topics/excel sheet/questions to be answered
or asked from vendor when you are choosing the correction database
software among like oracle/teradata/db2 etc... And now we are talking
about terabyte amount of data...

All points to links would be nice and all other comments as well...

Thank you in advance...

Kalle

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 05:29 AM
DA Morgan
 
Posts: n/a
Default Re: Evaluating which database to choose

Kalle wrote:

> Hi all,
>
> I wonder is there a list of topics/excel sheet/questions to be answered
> or asked from vendor when you are choosing the correction database
> software among like oracle/teradata/db2 etc... And now we are talking
> about terabyte amount of data...
>
> All points to links would be nice and all other comments as well...
>
> Thank you in advance...
>
> Kalle


There are lists created by vendors but, no surprise, all are
self-serving: As well they should be.

Here's my list:
1. What skills exist inside the organization?
2. What skills exist in the local/regional marketplace?
3. What will support third-party applications and tools we want to use?
4. What books are available to support us?
5. What on-line resources are available to support us?
6. What are the chances the company/product will not exist in 10 years?
7. What programming languages does the product support?
8. What is required to secure the data?
9. What is required to recover from hardware failure?

Generically you will find all three products you mention can easily
handle terabytes of data. But I challenge you to find a book on
Amazon.com about teradata or to find a pool of potential employee
candidates.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-08-2008, 05:29 AM
HansF
 
Posts: n/a
Default Re: Evaluating which database to choose

On Thu, 30 Dec 2004 10:00:34 -0800, DA Morgan wrote:

My favorite addition to your list, if I'm developing something from
scratch:

What does the vendor include that helps me minimize the development
time/cost and ongoing maintenance cost?

AKA

What does the vendor provide that I do not have to buy or create?

Oh, and beware of the vendor or third-party that hypes 'vendor neutral'.
Aside from self-interest, this generally demonstrates ignorance of the
possible environments.

/Hans
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-08-2008, 05:30 AM
Alan
 
Posts: n/a
Default Re: Evaluating which database to choose


"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:41d44135$1_3@127.0.0.1...
> Kalle wrote:
>
> > Hi all,
> >
> > I wonder is there a list of topics/excel sheet/questions to be answered
> > or asked from vendor when you are choosing the correction database
> > software among like oracle/teradata/db2 etc... And now we are talking
> > about terabyte amount of data...
> >
> > All points to links would be nice and all other comments as well...
> >
> > Thank you in advance...
> >
> > Kalle

>
> There are lists created by vendors but, no surprise, all are
> self-serving: As well they should be.
>
> Here's my list:
> 1. What skills exist inside the organization?
> 2. What skills exist in the local/regional marketplace?
> 3. What will support third-party applications and tools we want to use?
> 4. What books are available to support us?
> 5. What on-line resources are available to support us?
> 6. What are the chances the company/product will not exist in 10 years?
> 7. What programming languages does the product support?
> 8. What is required to secure the data?
> 9. What is required to recover from hardware failure?
>
> Generically you will find all three products you mention can easily
> handle terabytes of data. But I challenge you to find a book on
> Amazon.com about teradata or to find a pool of potential employee
> candidates.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)


Your list is good from a general point of view, but, for example, #6- the
question first needs to be asked- How far out to we require technical
support?" For one project I am working on, we only care about the next 5
years. #7 could be restated- "Does it support programming languages we now
use or are willing to use?" Basically, you have put together a list of
technical questions, but this needs to be preceeded by a list of business
questions and requirements. The answers to those help determine how much
weight each technical question gets, and and what the specific parameters of
these questions need to be.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-08-2008, 05:30 AM
DA Morgan
 
Posts: n/a
Default Re: Evaluating which database to choose

HansF wrote:
> On Thu, 30 Dec 2004 10:00:34 -0800, DA Morgan wrote:
>
> My favorite addition to your list, if I'm developing something from
> scratch:
>
> What does the vendor include that helps me minimize the development
> time/cost and ongoing maintenance cost?
>
> AKA
>
> What does the vendor provide that I do not have to buy or create?
>
> Oh, and beware of the vendor or third-party that hypes 'vendor neutral'.
> Aside from self-interest, this generally demonstrates ignorance of the
> possible environments.
>
> /Hans


Generally demonstrates? Vendor neutrality is a synonym for "don't look
at our performance and scalability."
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-08-2008, 05:30 AM
DA Morgan
 
Posts: n/a
Default Re: Evaluating which database to choose

Alan wrote:

> "DA Morgan" <damorgan@x.washington.edu> wrote in message
> news:41d44135$1_3@127.0.0.1...
>
>>Kalle wrote:
>>
>>
>>>Hi all,
>>>
>>>I wonder is there a list of topics/excel sheet/questions to be answered
>>>or asked from vendor when you are choosing the correction database
>>>software among like oracle/teradata/db2 etc... And now we are talking
>>>about terabyte amount of data...
>>>
>>>All points to links would be nice and all other comments as well...
>>>
>>>Thank you in advance...
>>>
>>>Kalle

>>
>>There are lists created by vendors but, no surprise, all are
>>self-serving: As well they should be.
>>
>>Here's my list:
>>1. What skills exist inside the organization?
>>2. What skills exist in the local/regional marketplace?
>>3. What will support third-party applications and tools we want to use?
>>4. What books are available to support us?
>>5. What on-line resources are available to support us?
>>6. What are the chances the company/product will not exist in 10 years?
>>7. What programming languages does the product support?
>>8. What is required to secure the data?
>>9. What is required to recover from hardware failure?
>>
>>Generically you will find all three products you mention can easily
>>handle terabytes of data. But I challenge you to find a book on
>>Amazon.com about teradata or to find a pool of potential employee
>>candidates.
>>--
>>Daniel A. Morgan
>>University of Washington
>>damorgan@x.washington.edu
>>(replace 'x' with 'u' to respond)

>
>
> Your list is good from a general point of view, but, for example, #6- the
> question first needs to be asked- How far out to we require technical
> support?" For one project I am working on, we only care about the next 5
> years. #7 could be restated- "Does it support programming languages we now
> use or are willing to use?" Basically, you have put together a list of
> technical questions, but this needs to be preceeded by a list of business
> questions and requirements. The answers to those help determine how much
> weight each technical question gets, and and what the specific parameters of
> these questions need to be.


Good points all. The reason I stated #6 as I did is that anyone with TB
to store and considering Teradata is likely planning on being around a
very long time.

In Washington State, for example, the organizations with Teradata are
Boeing, two telecoms, and one of the nation's largest retailers.
Teradata is not for the faint of heart or for those with limiting
budgets. Though I must say they can be fun to work with though far more
limiting than either Oracle or DB2.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:32 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com