Results 1 to 9 of 9
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    review of databases (all)

    Charlotte, if this is out of place, please recommend a forum for its home. I posted here because I'm specifically interested in databases.

    I'd like to compare different database technologies in order to be better informed for clients. I searched the web looking for "comparable/comparative reviews database", but came up dry. If anyone knows of a resource I'd appreciate hearing about it.


    I'm specifically interested in some sort of checklist table that shows, for relational and for object(?) databases characteristics such as:
    Rollback available? Transaction logs?
    Maximum recommended simultaneous users
    Maximum size of object (e.g JPEG file)
    Security
    Indexing (mid-taable inserts?, backround re-index)


    I have a client with a slow, drop-data database, and want to know (a) whether the current system is at all suitable and ([img]/forums/images/smilies/cool.gif[/img] if not, a few general leads as to what MIGHT work.

    It seems to me that a crude table, such as see comparing printers of digital cameras, would be a starting-point to promote efficient investigation of the most likely candidates.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: review of databases (all)

    It isn't out of place, but it is awfully vague. Security alone is a huge topic, so where would you start? Unfortunately, comparing database products, which is what you seem to be talking about, is a lot different from comparing printers or digital cameras. Think of comparing your inkjet printer to the complex presses they use to print glossy magazines or ice cream wrappers. That's a closer match to what you would be trying to do then a comparison of digital cameras.

    Are you going to compare only current products and versions? Do you want to compare desktop databases to database servers? If you get specific, then maybe some of us can contribute information, but as a general topic, it's a good way to fiddle away a lot of time without getting anything really coherent out of it.

    Just as a for instance, I have no idea what "mid-table inserts" or "backround re-index" means. In Access and SQL Server, records are *always* added to the end of the table because record position has no real meaning. Nor do I know what a "dropdown database" is ... unless it's one that bounces when it crashes. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Charlotte

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Hornsby Heights, New South Wales, Australia
    Posts
    3,822
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: review of databases (all)

    Chris,

    Try entering "database feature comparison" here: http://google.com, you'll be amazed <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Cheers, Claude.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: review of databases (all)

    The folks who do mySQL have a nice little test suite that will give you a detailed comparison of all the different features of different databases - that's the database that the Lounge is based on as I understand it. Unfortunately it produces a page that is MANY pages long, so it isn't simple or crude. In point of fact, unless you client has some very strange requirements, any of the major database products should be able to meet their needs. It would help to know what product they are currently using.
    Wendell

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: review of databases (all)

    Claude, thanks. I did, and I am!

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: review of databases (all)

    > any of the major database products should be able to meet their needs.

    Wendell, this is the part that struck gold. I generally feel that for most small companies, a very simple database should address most needs, just as the average city dweller needs little more than a 4-cylinder runaround.

    The checklist is, initially, for me, so that as client issues come up, I can say/think "They all have that feature; the choice is still open", but when a special requirement comes up, such as "Must be able to store a JPEG image of up to 10MB", I can quietly eliminate some of the not-so-hopefuls.

    Until recently most of my database work was essentially text-based. I am being dragged, kicking and screaming, into the world of AV (grin!)

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: review of databases (all)

    "AV"?
    Charlotte

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: review of databases (all)

    I'm with Charlotte - what the heck is AV?

    In any event, Access (which is the topic of this forum) is ideal for small companies. From a cost perspective, it cost about $100-150 per installation, and can do anything from a simple list kind of database to a very powerful front-end to main-frame databases. And if you really want to be economical, you can deploy run-time versions. But the real cost in databases is usually the development cost. Putting in a database usually requires that you study, evaluate, and perhaps change the business rules and all that takes time and money.

    Finally, if your client is insisting on putting a 10MB JPEG image in a database, find another client. They obviously don't understand the problem - and insisting on their solution suggests they don't know enough to know that they don't understand the problem. That's a situation which invariably leads to trouble.
    Wendell

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: review of databases (all)

    Audio Visual ?
    (Not Anti Virus in this context, I presume)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •