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
   205   206   207   208   209   210   211   212   213   214   215