Skip navigation
Currently Being Moderated

Database systems

Apr 9, 2008 1:42 PM

Hi,

does your company have a database? If so is it tied to your intranet? If so, who do you use? My company is looking to get a database and we don't know where to start. Just wondering what others are doing.

Thanks,

STan
 
Replies
  • Currently Being Moderated
    Apr 9, 2008 1:58 PM   in reply to garek007
    Stan,

    Choice of database depends upon the amount of data to be stored, and how
    it will be used, which includes the number of simultaneous requests
    envisigaed.

    For an enterprise level solution Oracle would be hard to beat, but for
    on-line use MySQL would be in my forefront of possibilities.

    There is little that MySQL 5 cannot do that other RDBMSs can and it is
    optimized for web accessibility.

    I couldn't recommend MSSQL and ACCESS has considerable problems when it
    comes to heavy network usage.
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 9, 2008 4:30 PM   in reply to garek007
    Stan,

    My company developed custom code over the past 10 years which revolves around Cold Fusion and SQL in enterprise-level flavors, all accessible via our custom admin pages, so it's easy to use, and upwardly expandable as our client base grows. We use it for both our internal analysis and reporting and for contracted client access (although we place restrictions on who can access what). We have our own servers, but they are remotely located and backed up, and access is from across the country.

    Neil
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 10, 2008 4:58 AM   in reply to garek007
    > RDBMS

    Relational Database Management System.

    I can also vouch for MySQL. Image searchability will depend on how the images are being searched. If it is by filename, and there is an indexed filename field in the database, then the results will be returned in milliseconds. If you want something that finds the picture of the company president standing in front of the red display, then searching will depend entirely on how complete you have indexed keywords for the database.
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 10, 2008 5:55 AM   in reply to Don McCahill
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 10, 2008 9:59 AM   in reply to garek007
    Stan,

    I see you've already had the RDBMS explained...and ponted to mysql.com.

    Advantages of MySQL is that for web use it is free and it has API's for
    a wide variety of programming languages - PHP, Perl, C, C++ Python and
    Tcl last time I looked.

    It is also the fastest database around in the majority of circumstances
    and now that it supports stored procedures written in standard SQL:1999
    (SQL3) there are very few things you can't do with it that you could do
    with, say, Oracle. Just take a look at MySQL.com Customer list!

    If you do go with MySQL, I would recommend taking a look also at Navicat
    (http://www.navicat.com/ ) as a maintenance tool. It doesn't do an awful
    lot more than the free MySQL QueryBrowser + MySQL Administrator, but it
    does it so much more conveniently and can be used over an SSL connection
    to remotely administer any MySQL database you have legitimate Admin
    access to.
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 10, 2008 10:04 AM   in reply to garek007
    Len,<br /><br />Of course, I'm not saying that Cold Fusion/SQL is the only way to go. But it does work very nicely for us. And granted, it costs a bit more than "free".   <g><br /><br />Neil
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 14, 2008 5:43 AM   in reply to garek007
    > Can an Access database be integrated into MySQL?

    Yes. You have to create a special header, and then a text dump from Access that will load the file into MySQL. There are even programs that will do it automatically ($40 or so, well worth it for me).

    However, you don't want to be going back and forth. Once out of Access, stay out. Create the update and review tools you need in php to deal with any steps you might have used Access for in the past.

    Contact your local college and see if they have programs that teach php and MySql. They might allow you to post a notice that will let you hire a grad.
     
    |
    Mark as:
  • Currently Being Moderated
    May 28, 2009 7:09 PM   in reply to garek007

    Hi,

    My name is Dan Cornish and I am the CEO of Cosential.  Please contact me directly and I will make it my sole project in life to successfully implement ad get off the ground Cosential. We have had many successful implementations. We have a large team of  developers working 6 days a week trying to build the best application there is. You can contact me at dcornish@cosential.com.  If anything else I want to find out why the system is not working for you.

     

    Respectfully,

    Dan

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)