Catch up on stories from the past week (and beyond) at the Slashdot story archive


Forgot your password?

Submission + - The Manga Guide to Databases

DesiVideoGamer writes: In the same spirit as The Manga Guide to Statistics, "The Manga Guide to Databases" can give you some basic pointers on how to design, create and manage a database. Due to its nature of being a dumbed down introductory book, its requires the reader to do additional reading in order to set something up in practice. However, for anime/manga lovers, or for people who want a brief overview of the otherwise boring field of databases, this book can be both fun and helpful.

First, I would like to say that I am by no means a database expert. Most of my programming knowledge and experience is front-end work. I like having some humor in my technical books. As a matter of fact, I got into programming after reading the humorous book C For Dummies. With a future project that my require me to know a few things about databases, I thought I should pick up "The Manga Guide to Databases". This manga is part of the "The Manga Guide to ..." series being published in English by No Starch Press with many more along the way.

The story takes place in a Magical Kingdom of Kod where Princess Ruruna was left to take care of the kingdom's fruit selling business while her parents are away. Princess Ruruna instantly realizes that the business was being handled inefficiently and wishes for a more effective way to handle her work. Enter Tico: the "Database Fairy". She teaches Princess Ruruna and her dependable assistant Cain the basics of creating and managing a database. The story is interleaved with the technical explanations throughout the book with a summary and quiz at the end of each chapter.

The first chapter, entitled "What is a Database?" explains why you would want to store your data inside a database. The chapter explains why the reader Princess Ruruna would want to use a database rather than sharing a single file between various people or entities. The second chapter justifies using a relational database as opposed to "Hierarchical" or "Network data" based database. They didn't seem to address situations where you wouldn't want to use a database or where a relational database would be an overkill. I guess that's for a more in-depth book to cover.

The third chapter goes into the design of the database. They talk about how to create an ER Model and how to create a database that is in 3rd normal form. The fourth chapter gets into the actual SQL syntax along with many examples (which is extremely useful for reasons I will explain later). These two chapters are very dense in information (compared to all the other chapters) and felt very odd to read. Sadly, I am so used to not having to "think" while reading a manga so this chapter actually took much longer to read than expected.

The last two chapters go over basic management of a database like security, disaster recovery, how to distribute the load to other servers and some more high level tips along with some examples. I will not spoil the ending of the story but it will at least bring you a smile in your face after reading it.

The biggest strength of this book, which is also its biggest weakness is that the authors tried to be very generic when they explained everything from networking to the SQL syntax. Hence, they didn't really go over how to install a database on your computer or how to bring up the SQL console. However, this allowed the manga to not waste time with vendor specific features and gotchas or risk being outdated in just a year. Personally, I am more of a hands-on person that would like to try out commands here and there with an actual database. Therefore, it was hard to understand some of the topics without me replicating the examples into a database of my own. However, the examples that are provided are nice and clean-cut (compared to the one had I had to read in college) and the quizzes help out in making sure I actually understood the material.

After reading this book, the reader will be expected to read up on the manuals for whatever vendor they choose. This also became a problem when they were talking about creating logs for the database and triggers or stored procedures. As mentioned before, this is also a good thing since I wouldn't have wasted my time learning how to do a function for only one kind of database.

So, who should read this book? People who are into anime/manga and want to learn the basics will definitely enjoy this book. The rather cliche manga/anime parts didn't really bother me since the story is not epic or complex. Even if you are not into anime or manga and just want a brief overview, this book is fairly good as it explain things without being bogged down with any specific vendor. Anybody that wants to get something done quickly will find this book useless as it will not even explain the first step of where to download and install a database on to your computer. Overall, I felt that the book brough a little bit of fun in a previously too boring world of databases.
This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.

The Manga Guide to Databases

Comments Filter:

"It may be that our role on this planet is not to worship God but to create him." -Arthur C. Clarke