3 ms·

My knowledge is at very basic level. Current projects are extremely modern and exploit very sophisticated techniques. I'm in the "Hello, World" step. I need som

My knowledge is at very basic level. Current projects are extremely modern and exploit very sophisticated techniques. I'm in the "Hello, World" step. I need some basic text or papers to get some ideas.

brudgers 10y ago
Oh, I think I misunderstood. My goto introduction is Database Systems: The Complete Book by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. The first edition can often picked up online in used but reasonable condition for very little money. On the other hand, another way to approach storage is from the bottom up using file systems. My understanding is that this (files on disk) is what Hacker News has traditionally used. There are 'state of the art' systems that use this approach, notably Hadoop and the Hadoop Distributed File System [HDFS]. That brings me to my last point which is 'skating to where the puck is going' and by that I mean that much of what matters in data storage today are more related to distributed systems and less related to how data is stored on disk because storage of files on disk is best treated as a solved problem in almost every case. Partly because getting block level storage correct is hard and partly because storage is cheap and fast relative to engineering for high efficiency. Lastly, my direct advice is to that the best 'Hello World' for running Database Management Systems [DBMS] is to install and run several DBMS's. On Linux, this it is highly practical to run production quality systems on a laptop even for a hobbyist. And that reminds me that running Linux is probably a valuable first step if it is not your current operating system because Linux is the most common operating system for running DBMS's in production and competency in 'the next layer down' is going to be useful.
- majidazimi 10y ago
  I think I didn't explain my problem well. What I really need is a book (or a set of papers) that describes and compares for example LSM Trees or ISAM or other techniques (Which I'm not aware of many of them). I'm not a basic developer in database world. I want to dig into it and understand how actually it works (This is where I am basic).
  - brudgers 10y ago
    Ok, then I'd start with a bibliographic serach in The Red Book, though for something like ISAM, previous editions might also be relevant. http://www.redbook.io/ http://www.redbook.io/

brudgers 10y ago

Oh, I think I misunderstood. My goto introduction is Database Systems: The Complete Book by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom. The first edition can often picked up online in used but reasonable condition for very little money. On the other hand, another way to approach storage is from the bottom up using file systems. My understanding is that this (files on disk) is what Hacker News has traditionally used. There are 'state of the art' systems that use this approach, notably Hadoop and the Hadoop Distributed File System [HDFS]. That brings me to my last point which is 'skating to where the puck is going' and by that I mean that much of what matters in data storage today are more related to distributed systems and less related to how data is stored on disk because storage of files on disk is best treated as a solved problem in almost every case. Partly because getting block level storage correct is hard and partly because storage is cheap and fast relative to engineering for high efficiency. Lastly, my direct advice is to that the best 'Hello World' for running Database Management Systems [DBMS] is to install and run several DBMS's. On Linux, this it is highly practical to run production quality systems on a laptop even for a hobbyist. And that reminds me that running Linux is probably a valuable first step if it is not your current operating system because Linux is the most common operating system for running DBMS's in production and competency in 'the next layer down' is going to be useful.

majidazimi 10y ago
I think I didn't explain my problem well. What I really need is a book (or a set of papers) that describes and compares for example LSM Trees or ISAM or other techniques (Which I'm not aware of many of them). I'm not a basic developer in database world. I want to dig into it and understand how actually it works (This is where I am basic).
- brudgers 10y ago
  Ok, then I'd start with a bibliographic serach in The Red Book, though for something like ISAM, previous editions might also be relevant. http://www.redbook.io/ http://www.redbook.io/