Digital Edition

SYS-CON.TV
Rich Content with a Database Server
Serving rich content from a SQL Anywhere database server

Enterprises are increasingly being called upon to provide a high level of user experience with compelling and interactive content. Serving enterprise content and data securely to internet / intranet has become a very common necessity and is routinely handled by web servers. Web services technology, on the other hand, addresses the application-to-application transparent interaction over the web using industry standards. Delivery of web services can also be handled by databases which are responsive to HTTP requests. In this article a simple example of serving a static web page containing dynamic content from a SQL Anywhere 11 database server is described. The web page has examples of jQuery, DOJO, as well as an embedded ADOBE flash file.

Web servers and database web servers
Web servers enable enterprises to expose their data and information to intranet and internet users. This procedure involves nothing more than the client sending an HTTP request to the web server. The web server sends out any data processing in the request to backend server(s), formats the returned information in HTML, and serves the HTTP response to the user (Figure 1). In the case of static HTML content, the requested HTML files containing resources (images, videos, etc) will be returned to the user as an HTML response. For delivering streaming media, the content is delivered to the user via a browser plug-in accessing a streaming media server for maximum efficiency. Although, a standard web server can also be configured to serve streaming media files. AJAX has become popular where a partial refresh of a web page is needed. In this case, the web server is accessed via a XMLHTTP request with the response returning in XML \ HTML.

A basic request / response pair that connects a web browser with a web server is shown in Figure 1. Although an internet cloud is shown, the browser and the server can also be on the same computer.

About Jayaram Krishnaswamy
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1



ADS BY GOOGLE
Subscribe to the World's Most Powerful Newsletters

ADS BY GOOGLE

To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitori...
Consumer-driven contracts are an essential part of a mature microservice testing portfolio enabling ...
DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, ...
Containers and Kubernetes allow for code portability across on-premise VMs, bare metal, or multiple ...
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use ...
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 20...
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st I...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, disc...
In this presentation, you will learn first hand what works and what doesn't while architecting and d...
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22n...
In his session at 20th Cloud Expo, Scott Davis, CTO of Embotics, discussed how automation can provid...
Everyone wants the rainbow - reduced IT costs, scalability, continuity, flexibility, manageability, ...
Founded in 2000, Chetu Inc. is a global provider of customized software development solutions and IT...
The standardization of container runtimes and images has sparked the creation of an almost overwhelm...
SYS-CON Events announced today that DatacenterDynamics has been named “Media Sponsor” of SYS-CON's 1...
Most DevOps journeys involve several phases of maturity. Research shows that the inflection point wh...
Dynatrace is an application performance management software company with products for the informatio...
Today, we have more data to manage than ever. We also have better algorithms that help us access our...
Andi Mann, Chief Technology Advocate at Splunk, is an accomplished digital business executive with e...
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: D...