Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: Database Choice For Small And Medium Sized Companies

    Access is a good database for relatively simple business applications owing largely to its user interface.However as a database technology for business applications that may need to scale over time Access has various limitations in how it manages transactions, handles security and manages data storage. Access doesnot support atomic transactions, Access does not support encryption of the database and hence security problem ad various other issues. There are lot of benefits in migrating to Guptas SQLBase. Contact Gupta Technologies for more info.

  2. #2
    Join Date
    Jul 2002
    Location
    Eastbourne, UK
    Posts
    9

    Unhappy

    Sorry, but Gutpa Corporation seems very difficult to find on the net, and there are no refrences to Gutpas SQL that I can find!

  3. #3
    Join Date
    Jul 2002
    Location
    Eastbourne, UK
    Posts
    9

    Talking Gupta now at http://www.centurasoft.com

    Gupta now seems to be at http://www.centurasoft.com.

    Evaluation downloads seem to be quite large ....

  4. #4
    Join Date
    Nov 2002
    Posts
    128
    Provided Answers: 1
    Rather than jumping to the selection of a database language and/or system for a small to medium business you should be identifying your business requirements first.

    Don't put the technology decision ahead of your business requirements decision.

    Too many times I have seen clients eventually lamenting having made business-critical application decisions based on the knowledge (and thereby limits) of their in-house staff, their own limited "visibility" of options, and/or salesman recommendations and promises.

    Additionally the question of "create it yourself" or purchase it "off-the-shelf" needs to be carefully considered. Along with all of its associated delivery timelines and costs (anticipated or not - today and future).

    Typically the best place to begin is with a Business Profile or your entire organization. From that you will better understand what the information needs are today and hopefully you will be better informed as to future needs and/or "wish list" issues which need to be taken into consideration.

    If you should decide to create the application in-house, you consider the availability of programming/support personnel. Despite some technology being superior to the task, if the number of people being available to use for development and for post-installation support is limited, you might be wise to look at other technologies.

    Good Luck,
    JRB
    VisionQuest Consulting
    Business Analyst & CIO Consulting Services
    CIOServices@Yahoo.com

  5. #5
    Join Date
    Jul 2002
    Location
    Eastbourne, UK
    Posts
    9
    Yep, all very well and good, but that doesn't make the downloads any smaller.

    I know what I want a database to do. I can do quite complex operations in Access, but I would like to look at scalable desktop alternatives - hence evaluation software.

    Anyway, thanks for the posting :-)

  6. #6
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Dekker -

    Let me muddy the waters a bit. If you are going to have a high number of concurrent users hammering at the DB, then you should look at mySQL (www.mysql.com). It's free, fast, and works with Apache (free) and PHP (free). Many commercial websites use it. It can be configured to use Berkley DB, ISAM and innoDB tables. I've created VB6 frontends with ADO2.5 using its ISAM tables and ODBC driver on WIN9X systems. What's nice is that you can create your tables in MSAccess and import both data and structure almost directly. You can expand stand-alone systems into networked versions with few changes. Its available for many O/S, such as Lenux, as are OLEDB providers and system admininstrative utilities, all online and for free.

  7. #7
    Join Date
    Jul 2002
    Location
    Eastbourne, UK
    Posts
    9
    Thanks vududoc - I'm thinking of giving mySQL a try. Iknow it has limitations with sub queries, but what the heck, I'm sure I can get round them!

    I'll try to keep you posted

  8. #8
    Join Date
    Sep 2002
    Location
    New york
    Posts
    4

    Post

    What about Alpha Five Software. It is a inexpensive database that is loaded with features. The only thing I see wrong is that it not for Linux as yet.

  9. #9
    Join Date
    Jul 2002
    Location
    Eastbourne, UK
    Posts
    9

    Smile

    Excellent point, papabear46 I used Alpha4 years ago when it was given away free on a cover disk. I was reliable, fast and quite challenging to code (that was my first introduction to databases).

    Since then Alpha seems to have disappeared from the UK market. It's not surprising that the current name is Alpha5. I'll try looking at it when I've had a go at mySQL.

Posting Permissions

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