Basic Question about Users in a System (like the PF for example)

Click For Summary

Discussion Overview

The discussion revolves around the computing and networking models used for websites with multiple users, specifically in the context of user authentication, authorization, and data management. Participants explore how access is granted to users, the role of databases, and the underlying server architecture.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant inquires about the model for granting access to users on a site like Physics Forums, questioning whether it resembles a shared drive system.
  • Another participant explains that data is typically stored in a database, with common use of SQL, and mentions the role of web farms in managing physical resources.
  • A different viewpoint describes the interaction with a web application server, detailing how user inputs are processed and how access is controlled based on user permissions.
  • One participant emphasizes that websites operate through a series of "get" requests rather than as shared drives, highlighting the importance of security in modern web interactions.
  • Another participant notes that there is no single model for websites, suggesting a variety of possible data access models and user management systems.
  • There is a discussion about the use of SQL databases, with some participants asserting that many websites do utilize SQL, while others question this assertion.

Areas of Agreement / Disagreement

Participants express differing views on the specifics of database usage and access models for websites. There is no consensus on whether SQL is commonly used for all websites, and multiple perspectives on the architecture and user management systems remain present.

Contextual Notes

Participants mention various technologies and models without resolving the specifics of how they interrelate or the implications of different approaches. The discussion reflects a range of assumptions about user access and database management that are not fully explored.

WWGD
Science Advisor
Homework Helper
Messages
7,804
Reaction score
13,114
Hi just curious,
What is the computing/networking model for a site with many users, say, as PF? Is it to grant access to each user to a shared drive? Sorry if this is too simple. I mean, I understand that first I login and I have to be first authenticated, then authorized to access certain network resources. How is that all stored and organized. Is it a domain controller where I am part of a collection of users and/or groups with specified permissions? EDIT: In a database system such as SQL Server I understand I first get access to the general network with a login, either through Windows or through SQL Server. In order to use a database, I must be made into a user of said database. But tha t just gives me access to the database, without the ability to do anything. I must then be assigned a role, which brings with it a set of permissions. How does this work when granting access to different users to a general site/network?
Thanks.
 
Last edited:
  • Like
Likes   Reactions: OCR
Computer science news on Phys.org
Everything is stored in a database and SQL in one form or another is very popular.
The physical storage media can vary but very often the site operator simply rents server resources from a large provider, (these are known as web farms).
The web farm takes care of the physical resource management and maintenance, the site operator does not need to be involved in that.
Usually these web farms offer a complete package along with the physical resources, this would include all the necessary server software, for example a web server (Often it's Apache web server running under some version of Linux.)
The site operator uploads web pages and other material to their allocated space usually via FTP.
Depending on the package they can also upload their own unique 'server side' software, many languages are available, PHP is probably most widely used.
Site administrators have a 'control panel', which they use to assign permissions for different levels of normal users.
 
  • Like
Likes   Reactions: OCR and WWGD
Basically you are interacting with a web application server. You send it a URL and it sends back a web page. You enter some text in the web page and press the submit. Your browser sends a form to the server. The server parses the form stores the text in it database and returns a web page back to you with the updated information.

If you click a link to some media file then the web server streams it back to you and your browser knows how to display it on your screen.

Everything is very controlled. On the most open of web sites you can browse limited portions of the file system but it is controlled by the web server who processes your URL request.

In some ways this model of interaction is a lot like a command line session. You type a command and the shell runs the command and returns some text to you. Sometimes you'll get text and sometimes you'll get errors. To the user, the shell controls access to the files based on the user's access rights i.e. What groups they are a member of and the files permissions based on the file owner and group its in.
 
Last edited:
  • Like
Likes   Reactions: OCR and WWGD
WWGD said:
Hi just curious,
What is the computing/networking model for a site with many users, say, as PF? Is it to grant access to each user to a shared drive? Sorry if this is too simple. I mean, I understand that first I login and I have to be first authenticated, then authorized to access certain network resources. How is that all stored and organized. Is it a domain controller where I am part of a collection of users and/or groups with specified permissions? EDIT: In a database system such as SQL Server I understand I first get access to the general network with a login, either through Windows or through SQL Server. In order to use a database, I must be made into a user of said database. But tha t just gives me access to the database, without the ability to do anything. I must then be assigned a role, which brings with it a set of permissions. How does this work when granting access to different users to a general site/network?
Thanks.
Websites aren't shared folders or drives, they are a series of "get" requests for information and they are downloaded files from a file server and in the old days it was as unsecured as FTP (a protocol that simply allowed you to download files in plain text).

Now it ought to be a little bit more secured than that. But that's the gist of it.

As others have mentioned, when you login you are cross-referencing two objects with a database of objects, you download a landing page file that is the login webpage which contains script that when you press enter sends the information back, if there's an SSL connection it's somewhat encrypted.

If that information is correct then you are given access to other downloadable content of the website based on your account. Since everything is a downloadable or uploadable content, (such as I upload data to the webserver when writing this post) if your account has those permissions the webserver will allow it.

That's it in a nutshell.

Databases for Websites are not usually SQL, correct? Most webservers are Apache and not IIS based?
 
  • Like
Likes   Reactions: WWGD
There's no single model for a website. The WWW is a set of standards that essentially allow a universal client (the web browser) to communicate with a standard web server. Without this, every website might need its own client.

But, behind the front-end webserver there could be anything from a single PC to an IBM mainframe.

There are as many possible data access models as you can imagine. You may have access as a specific user (change your profile) or as part of a user group (moderators).

In many business applications you have a whole superstructure of access rules maintained by system administrators. More general things may be in something like Active Directory, but a lot of rules can be held in specific application software.
 
  • Like
Likes   Reactions: WWGD
IDNeon said:
Databases for Websites are not usually SQL, correct?

There are many flavors of SQL and many web sites use one of them. Apache servers are frequently paired with MySQL for instance.

BoB
 

Similar threads

Replies
7
Views
3K
  • · Replies 18 ·
Replies
18
Views
4K
  • · Replies 15 ·
Replies
15
Views
3K
Replies
4
Views
4K
  • · Replies 5 ·
Replies
5
Views
2K
Replies
5
Views
3K
Replies
2
Views
3K
Replies
1
Views
1K
  • · Replies 12 ·
Replies
12
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K