Page 210 -
P. 210
Figure 5-12a Q5-4 How Do Database Applications Make Databases More Useful? 209
Sample Query Form Used
to Enter Phrase for Search
Figure 5-12b
Sample Query Results of Query
Operation
Source: © Access 2013, Microsoft
Corporation
As stated, in the early years of your career, you will still see traditional applications, especially
for enterprise-wide applications like ERP and CRM. Most likely, you will also be concerned, as a user
if not in a more involved way, with the transition from such traditional applications into browser-
based applications.
Browser Forms, Reports, Queries, and Applications
The databases in browser-based applications are nearly always shared among many users. As
shown in Figure 5-13, the users’ browsers connect over the Internet to a Web server computer,
which in turn connects to a database server computer (often many computers are involved on the
server side of the Internet).
Browser applications are thin-client applications that need not be preinstalled on the users’
computers. In most cases, all of the code for generating and processing the application elements
is shared between the users’ computers and the servers. JavaScript is the standard language for
user-side processing. Languages like C# and Java are used for server-side code, though JavaScript
is starting to be used on the server with an open source product named Node.js.
Browser database application forms, reports, and queries are displayed and processed
using html and, most recently, using html5, css3, and JavaScript as you learned in Chapter 4.
Applications with both
client- and server-side code
Browser
Application
Browser Program A
Application
Browser Internet Program B DBMS DB
Application
Program C
Browser Application Database Server Computer
Program D
Browser Web Server
Computer(s)
Applications coded in: Applications coded in:
• html5 • C#
Figure 5-13
Four Application Programs • css3 • Java
• Node.js JavaScript
• JavaScript
on a Web Server Computer