I am developing a software program, which uses databases to store
information. My goal is to find the best match and value for my
application.
I would like information on the following databases:
* MySQL
* Oracle
* Microsoft SQL Server
* IBM DB2
* PostgreSQL
* Interbase
* Sybase (Optional)
* Informix (Optional)
* MaxDB (Optional)
* Any others you think that might be of interest to me.
I would like to know my overall cost for using each database. I would
like to know the inital cost I would need to pay for using/developing
with the database. The database would either need to be installed on a
client's server or embedded with the program, since most companies
charge extra (royalties). I would also like to know what editions of
each database exists, the price for each and the edition
limitations/differences. (Ex: MySQL provides both Classic and Pro
licenses, I would like to know why classic is priced differently than
the pro edition)
Additional Information:
* The database would be installed on a single server using one processor.
* My program will only be available on Windows.
* The program will not be open source (Under the MySQL license this
requires the commercial license and there is a fee)
* Databases that charge only one time fee for using them with my
product would probably be most interesting to me. (If any exist)
If possible, I would like it in a format similar to this:
Example Format:
-----------------------------------------------------------------------
NAME PRICE ROYALTIES COMMENTS
-----------------------------------------------------------------------
MySQL: shop.mysql.com/?sub=vt&id=software
Classic $295 $295 Limitation: Non-Transactional
Tables. Volume licensing
options available.
Pro $595 $595 Volume licensing options
available.
Example 2: www.example2.com/products
Enterprise $20,000 N/A One-time fee of $3,000 for
embedding with software.
Standard $500/month $100/year
-----------------------------------------------------------------------
Legend:
* NAME: Name of database, or specific version/edition (Indented
under the database name)
* PRICE: The inital price charged for using the database on my own system.
Example: Microsoft charges $19,999 for the Enterprise Edition for
each processor.
* ROYALTIES: Price needed to pay for each product you sell. Some
companies offer Independent Software Vendor(ISV) Licenses, which
should go here if it is charged for each product you sell. (However,
if it is a one-time charge, it should be listed under PRICE with a
note saying how much is the one time fee).
* COMMENTS: Any additional info related to the product main
advantages/disadvantages and license limitations (why each edition is
priced differently), pricing information, or anything else you think
would be useful to know. For the database name, it would be helpful if
you could include a link to the page with pricing information.
If you need any additional information, please don't hesitate to ask.
Thank you! |
Clarification of Question by
eagle6-ga
on
22 Apr 2005 20:06 PDT
The program will have 2 different versions, one for small businesses
(Standard) and one for medium/large businesses (Professional). Due to
royalties I may be forced to use 2 different databases, one for each
version, in order to keep prices down.
Speed is also an issue, but is more of a concern in the professional edition.
My only big table is a word indexing table which has currently around
500,000 records, and can be up to 10 times as that.
My indexing table is the only one that requires updating a large
amount of records at a time, if that's what you mean by bulk updating.
But I might consider removing it from the standard edition if it means
a much higher cost.
The reason I'm asking for more than one database that might work for
me, is because I would like to explore all my options and then decide
which features should and shouldn't be included in each version. (Ex:
If a database can only handle upto 100,000 records, I might use it for
the standard edition and disable the indexing functions in that
version.) Regardless of this, what do you think my best options are
for both versions?
The following are just rough estimates:
Standard Professional
Concurrent users: up to 20 up to 200
Average table
data size: 10,000 records (around 100 MB) 100,000 records
Index table size: atleast 500,000 atleast 5,000,000
I'm not sure what you mean by ACID, I found a definition but still
don't understand it... is it similar to the difference between
transactional and non-transactional databases?
Thank you
|
