Solved

web based database application design and maintenance

Posted on 2014-03-06
2
354 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

New Relic: Our company recently started researching several products to figure out what were the best ways for us to increase our web page speed and to quickly identify performance problems that we may be having. One of the products we evaluated wa…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

623 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