Presentations on Web Database Presented by Saddam Hussain Roll No 29
What is Web Database? Why Web Database? Client/server architecture Web interface to database Communication protocol and web address Database driven web architecture Advantage and disadvantages of web DB Web Aplications Future of web DB Contents
A web database is a system for storing and displaying information that is accessible from the Internet / web. A web database is a system for storing information that can then be accessed via a website. What is Web Database?
A web database is a database that can be queried and/or updated through the World Wide Web (WWW). As web technologies are evolving, the WWW turned out to be the preferred medium for many applications, e.g., e-commerce and digital libraries. These applications use information that is stored in huge databases and can only be retrieved by issuing direct queries to the back-end databases. Database-driven web sites have their own interfaces and access forms that create HTML pages on-the-fly. Web database technologies define the way that these forms can connect to and retrieve data from database servers. WEB DATABASE
L arge businesses rely on databases to store customer information. Because this information is accessible wherever Internet access is available, customers don't have to go to a local banking branch, for example, to access their account information. Why web database??
6 Two-tier Application First Tier Second Tier Client Database Server Tasks Tasks User interface Main business and data processing logic Server-side validation Database access
7 Web client/server architecture
8 Three-tier Application First Tier Second Tier Client Application Server Tasks Tasks User interface Business logic Data processing logic Third Tier Database Server Tasks Data validation Database access
9 Database-driven Web site Architecture
Web interface provides attractive, even for database applications that are used only with a single organization. The HyperText Markup Language(HTML) standard allows text to be neatly formatted , with important information highlighted. Hyperlinks which are links to other documents.Clicking the Hyperlink fetches and displays the linked document. 10 How Web Interface interacts with the Database
Client interacting with web server. Step 1: The GET request. 11 Client interacting with web server. Step 2: The HTTP response.
Checking that the request is authorized The server first responds by sending a line of text that indicates the HTTP version, followed by a numeric code and a phrase describing the status of the transaction. For example, HTTP/1.1 200 OK (Indicates success) Whereas HTTP/1.1 404 Not found informs the client that the web server could not locate the requested resource. 12
Simplicity Platform Independence GUI Standardization Cross-Platform Support 13 Web-DB Advantages
Reliability Security Cost – commercial web site Scalability 14 Web-DB Disadvantages
MySql Microsoft Access Oracle DB2 Web DBMS Examples
Banking System : Education sector : Online shopping : Industry Applications of WEB DB
Two new scale-out technologies are leading the newest database revolution NoSQL , Hadoop Future of Database
UNIVERSAL MEMORY BLOCKCHAIN QUANTUM COMPUTING Future of Web DB
A web database is a wide term for managing data online. A web database gives us the ability to build our own databases/data storage without being a database guru or even a technical person. conclusion