“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.
Most Popular Pages
Recent Posts: Practical Blog
- Power View empowered practical Smart Client applications
- Tableau vs Qlikview and Tableau vs Spotfire
- Data, Story, View: Prototype and Update
- 2012 starts with Tableau 7.0
- SQL Server 2012 is good for Data Visualization
- Spotfire 4.0 is available
- Introduction of QlikView 11
- VisiCalc jubilee and history of Excel
- Data Visualization 2011: Omniscope 2.6
- Data Visualization 2011: Spotfire 3.3, Silver 2.0
- Data Visualization 2011: Tableau 6.1
- SQL Server 2012 is released for Preview


