Pinned Loading
-
My study on database, its structure ...
My study on database, its structure and working 1We all have been using various servers to create and store databases. With few queries, we all can store a large amount of data within a short time that most of us do not even bother exactly how those data are being saved physically. The server renders the data in a beautiful table with rows and columns, just how we prefer, but have you ever wondered exactly how those data are being stored physically?
23After completing my bachelor's in computer engineering and working for 3 years, I finally started to actually work in a database which previously I had some blur remembrance of studying it in my course. As I aspire to be a Full-stack engineer, I thought it is mandatory to know about databases but it is also very important to understand them from the ground level. Let us see what I found.
45First, let's go back to the time when there used to be no electronic means to store data and ponder how they managed to store it. Let's take an antique shop for an example, What were the sources and how a shop stored its sales and purchase records. Well, we all know it's all in the papers. People use to write each record on the pages of a book and there would be lots of such books with lots of pages with rows of data. Surprisingly enough our modern electronic databases also work in a similar format on a physical level. If we consider Data Files as book and Data Pages as the pages of the book but the difference is we could actually touch the book and the pages but the datafiles and data pages are just the allocated storage space in the disk.
-
-
-
-
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.