CLIENT SERVER MODEL - DBMS

-

 The Client-Server model is a distributed architecture system that divides the task between the servers and clients. Here, when the client sends a request to the server through the internet, the server accepts the requested process and delivers the requested data packets back to the client. 


The browser interacts with server as:
  • User enters the URL(Uniform Resource Locator) of the website. The browser then requests the DNS (Domain Name System) server.
  • DNS Server looks up for the address of the WEB Server.
  • DNS Server responds with the IP Address of the WEB Server.
  • Browser sends over an HTTP/HTTPS request to the WEB Server's IP
  • Server sends over the necessary files of the websites.
  • Browsers then renders the files and website is displayed.


Advantages:
  • Centralized System
  • Cost Efficient
  • Data recovery
  • Capacity of client and servers can be changed
Disadvantages:
  • Clients are prone to virus if present in server or uploaded into the server
  • Servers are prone to Denial of Service (DOS) attacks
  • Data packets may be spoofed or removed during transmission
  • Phishing or capturing login credentials or other useful information of the user are common and MITM(Man in the Middle) attacks are common.







Source: GeeksForGeeks

Comments

Post a Comment

Popular posts from this blog

THREE LEVELS OF DATA INDEPENDENCE

-
Image
THREE LEVELS OF DATA INDEPENDENCE It divides the entire system into three inter-related but independent modules: Physical Level: Here, information about the location of database objects in the data store is kept. Various DBMS users are unaware of the locations of these objects. The Physical level of database describes how the data is stored in secondary storage devices such as disks and tapes. Conceptual Level: Here, data is represented in the form of various tables. For Example, STUDENT database may contain NAME and COURSE tables, but the users are unaware of their storage. It refers to what kind of data to be stored in a database. External Level: Here, it specifies the view of data in terms of conceptual level tables. It can generate different views of the database for different users. It focuses main on data abstraction.  Data Independence: It means change of data at one level must not affect the another level. Physical Data Independence: Any change in the physical location of t...
Read more

NESTED QUERIES DBMS

-
Image
In Nested Queries , a query is written inside a query. The result of inner query is used in the execution of the outer query. There are mainly two types of nested queries: Independent Nested Queries: In independent nested queries, query execution starts from inner query to outer query. The execution of inner query is independent of the outer query, but the result of inner query is used in the execution of the outer query.                            For Example: select S_NAME from STUDENT where S_ID IN                                                                                                                        ...
Read more

WEB SCRAPING

-
 WEB SCRAPING Web scraping is Data Scraping used for extracting data from websites. It is also known as Web harvesting, Web data Extraction. It is basically copying where specific data is gathered and copied from the web, to a database or a spreadsheet for Data Analysis. Web scraping a web page involves fetching it and extracting from it. Fetching is the downloading of a page (which a browser does when a user views a page). Therefore, web crawling is a main component of web scraping, to fetch pages for later processing. Once fetched, then extraction can take place.The content of a page may be parsed, searched, reformatted, its data copied into a spreadsheet or loaded into a database. Web scrapers typically take something out of a page, to make use of it for another purpose somewhere else. An example would be to find and copy names and telephone numbers, or companies and their URLs, or e-mail addresses to a list (contact scraping). Click here to go through the example of We...
Read more