Menu
Could anyone recommend me a clear introductory article on the inner workings of each element composing a database system:
Optionally with illustrations and comparisons between MySql, PosgreSql, Oracle, Access etc.
===
I am looking for articles with some technical details and keywords. The information I am looking for could answer the following question: I want to program a database engine from scratch, now what? Where do I start? How do I move from reading/writing parameters in a .ini file to sending requests to a SQL server? Of course I am not willing to program a whole database system from scratch, just a guidethrough of challenges, concepts, architecture tips etc. to better undertand the tools I am working with. Thanks in advance.
699
Database systems store data in memory and on disk. In-memory database management systems (sometimes called main memory DBMS) store data primarily in memory and use the disk for recovery and logging. Disk-based DBMS hold most of the data on disk and use memory for caching disk contents or as a temporary storage.
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).
Have you ever wondered how SQL server physically stores table data internally? Well, data in tables is stored in row and column format at the logical level, but physically it stores data in something called data pages. A data page is the fundamental unit of data storage in SQL Server and it is 8KB in size.
A database is information that is set up for easy access, management and updating. Computer databases typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information.
Here is a good course from Stanford University. You can review the lecture notes if you want lots of details:
http://infolab.stanford.edu/~hyunjung/cs346/
77
This article really helped my understanding of indexes. I would highly recommend reading it.
22
This is a good introductory article, with links to more detailed information.
http://databases.about.com/od/specificproducts/a/whatisadatabase.htm
And of course, Wikipedia always has good nov-techie explanations, such as this one:
http://en.wikipedia.org/wiki/Database
As a matter of fact, this google search yielded many results that have the info you're asking about.
1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
