An example of using a database in web development
The use of a database in the field of web programming is necessary only in some cases. Ask questions:
What information will you store and why?
In what form and how do you plan to store this information?
How and in what way can the contents of the database be accessed?
Free online intensive
Your IT Journey Starts Here
More
Consider a website with a diary. Here it is necessary to provide at least one type of form to fill out with several fields: date, mood, description of the day, main thoughts, and so on.
The user will write down his thoughts every day in an online diary, which means he should be able to return to the first pages in a day or a year. In this case, developers must consider how and where all this data will be stored so that they can be accessed at any time.
It can be a brief overview of the day, or something more complex and inventive.
Unlike their paper counterparts, electronic diaries can have many features. For example, a simple analysis: you can see which day was the most fun, the saddest, which day had the most entries, and so on.
Big Data Processing: Basic Methods
In order not only to store data and have access to them, but also to analyze them, process and make certain calculations, databases were created.
Information storage system in databases
The structure of the database is represented by three levels from largest to smallest:
database;
table;
record.
Database
A database is a high-level concept that means the collection of a collection of data stored for the same purpose.
For most modern sites, separate databases are created, inside which all information will be stored. For our example of a personal online diary, we will also need a specific database.
Information storage system in databases
Information storage system in databases
table
A table is part of a database. This is one of its components. One database can store a huge number of tables.
If you imagine that a large closet is a database, then everything that lies inside, for example, a bunch of boxes, is tables.
Tables are designed to contain one type of information, such as a list of cities, site users, or a library catalog.
It can be presented as a regular Excel file, or as a simple set of rows and columns.
