Skip navigation
garek007
garek007
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
2050 Views   10 Replies   Latest reply: cornell, May 28, 2009 7:09 PM
 
Replies
  • LenHewitt
    Currently Being Moderated
    1. LenHewitt,
    Apr 9, 2008 1:58 PM   in reply to garek007
    Report
    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:
  • garek007
    Currently Being Moderated
    2. garek007,
    Apr 9, 2008 4:22 PM   in reply to garek007
    Report
    Len,

    Thanks for your response. I want to link it to our company Intranet and the primary usage is information and photos linked to that information. Image searchability is probably the most important thing. What does RDBMS stand for? How can I look into MySQL a bit more? Do you have a website?

    Thanks,
    Stan
     
    |
    Mark as:
  • Neil_Keller
    Currently Being Moderated
    3. Neil_Keller,
    Apr 9, 2008 4:30 PM   in reply to garek007
    Report
    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:
  • Don McCahill
    Currently Being Moderated
    4. Don McCahill,
    Apr 10, 2008 4:58 AM   in reply to garek007
    Report
    > 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:
  • MichaelKazlow
    Currently Being Moderated
    5. MichaelKazlow,
    Apr 10, 2008 5:55 AM   in reply to Don McCahill
    Report


    Mike
     
    |
    Mark as:
  • LenHewitt
    Currently Being Moderated
    6. LenHewitt,
    Apr 10, 2008 9:59 AM   in reply to garek007
    Report
    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:
  • Neil_Keller
    Currently Being Moderated
    7. Neil_Keller,
    Apr 10, 2008 10:04 AM   in reply to garek007
    Report
    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:
  • garek007
    Currently Being Moderated
    8. garek007,
    Apr 11, 2008 8:31 AM   in reply to garek007
    Report
    Don,

    Thanks that sounds like EXACTLY what I want. I think I want to hire a private programmer to set it up. We are using Cosential currently, and so far we haven't gotten it off the ground, because they haven't performed as promised on their end.

    I'm thinking a MySQL solution that can be set up by an individual. Something on the cheaper end, but still quality. And I think a private programmer could make that happen.

    I don't necessarily need FREE, but I want cost effective. To date, we've already spent 9K and we haven't even really gotten started.

    Can an Access database be integrated into MySQL?
     
    |
    Mark as:
  • Don McCahill
    Currently Being Moderated
    9. Don McCahill,
    Apr 14, 2008 5:43 AM   in reply to garek007
    Report
    > 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:
  • cornell
    Currently Being Moderated
    10. cornell,
    May 28, 2009 7:09 PM   in reply to garek007
    Report

    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:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)