• banner

    “The PCA crew is leagues above
    the competition” - Pepsico

  • "a prior vendor failed to develop
    the application, which (Practical) delivered." - Franklin Park

  • "the application (is) easier to use, with a
    much simpler, more intuitive use interface" - Royal Administration Services

  • "Sometimes it's the things you don't ask for
    that are important" - Royal Administration Services

  • "PCA turned our raw data and algorithms into easy to use
    and understand features and reports." - CareScout

  • "The quality and professionalism ... has been
    so outstanding that we want to send you a letter of thanks." - USALCO

  • "PCA people and applications stand out by
    far exceeding our expectations." - USALCO

  • "The resulting application greatly increas(ed)...
    our business effectiveness and efficiency." - The Advest Group

  • "PCA completes projects
    efficiently and effectively" - Pepsico

Web Based Databases

Practical Computer Application (PCA) designs and builds custom web based database for business applications. Web database applications are generally easy to deploy and update and require no installation on the client computer. This approach comes with two primary trade-offs: usability and cost. Web browser applications are limited to the tools and functionality that is supported by a standard web browser. Significant engineering is required to overcome browser behavior deficiencies, at a cost. Typically, browser-based applications host their data in a database server that provides the necessary scalability, performance and database-level security.

Well designed browser-based database applications run under any browser and consequently can be deployed to disparate operating systems, from PCs to handheld computers and even to web-enabled cell phones. The asynchronous click-and-refresh communication between the Client application and the Server do however limit the browser-based approach to application that are suitable to simple forms and workflows.

Client-Server Scorecard

# End Users Unlimited Browser Compatibility issues (e.g. IE and Firefox)
Deployment LAN and Internet Anywhere an Internet connection is available
Performance Good Browser refresh issues impair performance and usability
Reliability Excellent SQL Server design-dependent
Data Integrity Excellent Assumes proper use of SQL Server database constraints and keys
Security Good Browser security flaws can be exploited
Data Limit Unlimited SQL Server datastore
Maintenance Low Standard SQL Server maintenance
# of Records Unlimited SQL Server datastore
Internet Access Yes Anywhere an Internet connection is available

Shortcomings of Browser-based Applications

Web browser-based database applications are typically less secure than desktop based database applications because the interface is asynchronous which can be exploited by ill-intentioned individuals. The complexity of Web application security issues may also limit the application to non critical data. Intranet (private) applications are inherently much more secure than Internet (public facing) web based database applications, simply due to the limited accessibility of the user.

PCA’s programmers have the experience needed to design and build custom web based database applications that meet your needs. Call us today at (617) 527-4722.