Solved

web based database application design and maintenance

Posted on 2014-03-06
2
335 Views
Last Modified: 2014-03-06
Dear Experts,

I am an IT director for a company that heavily relies on several online database applications.  These applications were made by outside consultant firm, and certain issues came up, and I am trying to bring them in house.
Even though I have designed, created, and maintained several database systems in my past jobs, I do not have any experience in creating online database application that gets very heavy traffic, and I wanted to ask for your expertise.

I do not plan to port the existing applications, as they are written in older language, and exist on older technology.  I want to start brand new.

Obviously, I need to hire some workers to work with me, because I would like to keep development and maintenance in house, but I am considering data hosting company that specializes in cluster or VM technology to ensure no downtime. (almost none, anyway)

Here are my questions:
1. What is the recommended platform/language?  I am versed in MySQL, VBA, Java, C++, but that doesn't really matter, because I can always learn, and I will hire someone that is already comfortable with that language and platform.
2. Can you give me some pointers to how to find a good data hosting company that supports 24/7 solution?
3. Given a database schema, am I reasonable to assume that this is an undertaking that I will manage, or because of my lack of experience with online database application development, I should hire an expert just for that?  Of course, with budget in mind, I am not able to freely hire the best candidate for all of the components.

I know I am quite vague in my questions, but I see this problem as a big, nebulous cloud of potential problems, that I really need to tackle, so any advise is appreciated.

Thank you!!!
0
Comment
Question by:yballan
2 Comments
 
LVL 34

Accepted Solution

by:
Paul MacDonald earned 500 total points
ID: 39909430
1) HTML5, CSS, and javascript are the modern web programming tools.  What IDE or backend language you chose doesn't matter much as they'll all have similar capabilities.  We use ASP.Net and MSSQL, but many people like PHP and MySQL.

2)  Almost all hosting companies will negotiate an SLA with you.  The more uptime you demand, the more you'll pay, but downtime for distributed websites is almost a non-issue anyway.

3)  I can't answer this for you, but I can tell you online database design is almost identical to desktop database design when it comes to eking out best performance.

Start by choosing the tools you want to learn/use.  Find online resources that will educate you on the best practices for those tools.  Sketch out a design plan, then look for programmers that can help you implement that plan.  Test early and often.
0
 

Author Closing Comment

by:yballan
ID: 39909942
Dear paulmacd,

Thank you for a through explanation to exactly what I was looking for !
I will start looking into ASP.Net and PHP and decide on which go with.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
Thoughout my experience working on eCommerce web applications I have seen applications succumbing to increased user demand and throughput. With increased loads the response times started to spike, which leads to user frustration and lost sales. I ha…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now