Stories
Slash Boxes
Comments

News for nerds, stuff that matters

Slashdot Log In

Log In

Create Account  |  Retrieve Password

The Manga Guide to Databases

Posted by samzenpus on Mon May 04, 2009 01:00 PM
from the read-all-about-it dept.
thumbnail
stoolpigeon writes "Princess Ruruna, of the Kingdom of Kod, has a problem. Her parents, the King and Queen, have left to travel abroad. Ruruna has been left to manage the nations fruit business. Much is at stake, Kod is known as "The Country of Fruit." Ruruna is not happy though, as she is swamped by paperwork and information overload. A mysterious book, sent by her father, contains Tico the fairy. Tico, and the supernatural book are going to help Princess Ruruna solve her problems with the power of the database. This is the setting for all that takes place in The Manga Guide to Databases. If you are like me and learned things like normalization and set operations from a rather dry text book, you may be quite entertained by the contents of this book. If you would like to teach others about creating and using relational databases and you want it to be fun, this book may be exactly what you need." Read below for the rest of JR's review.
I was pleasantly surprised by this book. It really does do a great job of introducing relational database management systems. All the SQL is ANSI standard. (Except for one exception, joins, which I'll discuss later.) There is no mention that I could find of any certain RDBMS product. Barring any proprietary quirks, everything in here should work on just about anything from Access to Oracle. Teamed up with PostgreSQL or MySQL, I think that one would have everything they need to teach an extremely inexpensive (materials wise anyway) class on building and using databases. I think that the manga format would make it especially attractive to younger people. By younger, I think high school age students would really enjoy it and I think even college students would find it to be fun if they weren't too stuffy. If I were teaching professionals, I might worry that they wouldn't take it seriously, but the content is solid and anyone who can lighten up can also learn from this book.

It is an introductory level book. I wouldn't hand this to an entry level dba and turn them loose on a production system. It teaches what a relational database is, about the entity/relationship model, using standard sql, as well as transactions, recover, indexing and query optimization. That's a pretty decent foundation. There is also a final chapter that is half manga and half more traditional straight text. The manga section gives some information on real world uses for databases and wraps up the story. The second section covers things like multi-tier web applications, stored procedures, triggers, partitioning and replication. It does this all rather quickly and basically just gives the reader an idea of what the terms mean. There is no information on actually implementation details. It wouldn't have made sense anyway as this would have necessitated leaving the generic approach taken in the rest of the book to discuss specific RDBMS products.

The art work is well done and the side story of Ruruna, her assistant Cain and the fairy Tico is entertaining if a bit silly. I thought that it really helped to take what is really dry subject matter and lighten it up. It also introduces examples of real world situations that are being modeled in the data. They are a bit contrived as all examples are in these situations, but they still help to reaffirm how the various pieces fit together so that databases can be helpful. Each chapter picks up with the story and is graphics heavy. This is followed with a by a review section that reverts to a more text heavy mode and then there are review questions. The answers to the questions appear immediately following the questions. I think it would have been nice to have them further removed, so that one wouldn't have any opportunity to see the answers on accident. That said, the review and quiz do a nice job of letting one gauge if they have really picked up the material. If the quiz is a struggle, it is safe to say that going back over the chapter would not be a bad idea. The questions are pretty straight forward and apply the material directly. They are not vague or wishy washy, so not knowing the answers means the reader doesn't know the material.

As I mentioned, the books sticks to standard SQL. I was happy to see this. The only change I would make is that joins are done in the old style as a part of the where clause. The book discusses various types of joins but does not give examples of anything but a normal inner join. This may help someone considering this book to get a good feel for just how far it goes. I found the information on transactions, locking, and indexing to be very good. I really didn't expect much in this regard, but I've worked with experienced, decent developers that I think would learn some things from this book especially about rolling back transactions and the limits of recovery. (Of course these are the situations where DBAs and developers are going to have some of their more interesting interaction. My bonus tip of the day is the developer that calls you in the morning about the database problem, is the one who caused it right before he went home the night before.) That said the discussion on recovery is vendor agnostic like the rest of the book and so there are not really any implementation details. The indexing section is also a bit brief and while it does a good job of explaining what an index is, I think there is too much emphasis on them increasing read speed with enough emphasis on how they may not do that at all and how they can hurt writes. These things are all mentioned, but very briefly.

If I were teaching teenagers or even lower class college students, I wouldn't hesitate to build a class around this book. I think that the amount of fun and heightened interest it could bring to the table would far outweigh the need to supplement the book's few shortcomings. I like that it does not tie the reader to any database product. I would also not hesitate it to a friend who wanted to learn on their own. I think someone has much higher odds of making it through this book compared to the textbooks on relational databases that I had to work through in school. But it is just an introduction. It gives the readers the tools for basic interactions with a database, and a handle on the basic terminology of database administration. Assuming that one will get more than that could lead to trouble. All the way around this is a solid book and I wish there were more like it in the IT world.

You can purchase The Manga Guide to Databases from amazon.com. Slashdot welcomes readers' book reviews -- to see your own review here, read the book review guidelines, then visit the submission page.
+ -
story
This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More
Loading... please wait.
  • Honest Question (Score:5, Interesting)

    by x_IamSpartacus_x (1232932) on Monday May 04 2009, @01:02PM (#27818493)
    So I have an honest question. How did Manga/Anime become such a nerd thing? I have been a nerd for quite a few years now and none of my nerd friends (RL friends that is) are into Manga. However, whenever I browse online nerdy things (/. in this example) Manga seems a prevalent thing. Can people tell me how you got into it and why you like it?
    • by Rakshasa Taisab (244699) on Monday May 04 2009, @01:07PM (#27818573) Homepage

      Yes, how did it ever become such a nerd thing? It used to be here in Japan that it was for normal people.

      • Re:Honest Question (Score:5, Insightful)

        by creimer (824291) on Monday May 04 2009, @01:09PM (#27818639) Homepage
        Large eyes, large boobs, and flashing panties are definitely nerdy for Americans.
      • Re:Honest Question (Score:5, Interesting)

        by skine (1524819) on Monday May 04 2009, @01:23PM (#27818823)

        Well, here in the US (and I would assume in other parts of the world as well), we have a nerd subculture whose members are called "Japanophiles." These are non-Japanese people who love all things Japanese simply for being Japanese.

        Japanophiles are technically considered nerds because of their strong devotion to a subject area and antisocial stereotype. However, I'm not sure why the Japanophile subculture and Technophile subculture (what I would consider /. to overwhelmingly be) became mixed, aside for the overall classification as nerds.

        • Re:Honest Question (Score:5, Insightful)

          by ildon (413912) on Monday May 04 2009, @01:30PM (#27818909)

          Anime nerds needed to learn to be tech savvy in order to download the newest anime/manga as they're released in Japan without having to wait for them to be imported (and without paying for them, of course).

          • Re: (Score:3, Insightful)

            And technophiles are more likely to be exposed to manga and anime (which has only recently become widely available offline).

            Personally, I had the tech half first. I was drawn to anime mostly because of my interest in science fiction and fantasy, combined with an enjoyment of animation in general. There is a much broader variety of fantasy and sci-fi animation (and aimed at at least teenagers instead of toddlers) coming from Japan than in the US.

            Unfortunately, early exposure to actual decent films (Neon Gene

        • Because RPG nerds and techie nerds are heavily mixed, and RPG nerds and Japanophiles share bookstores.

          'tleast it's so here.

        • Re:Honest Question (Score:4, Insightful)

          by Daravon (848487) on Monday May 04 2009, @01:46PM (#27819185)

          Probably because the easiest way to get your dose of Japanese culture was via computer (ten or fifteen years ago). Around that time, computers were not still widely available.

          I'm not sure which came first. The love of Japan turned people into nerds so they could get their fix, or if nerds turned into Japanophiles when exposed to Japanese gamma radiation (manga, etc).

          Online is still the easiest way, but you can also find anime or manga in stores or (in the case of anime) on TV. So in the younger kids, you'll see less of computer nerd/Japanophile combinations.

        • For me, I liked the new (different) story telling style. In America, we tend to have a very Hollywood, everybody goes home happy at the end of the day, story telling style.

          Japan tends to focus more on their culture, which is often, "Do what is right, even though it'll make you unhappy."

          • Re: (Score:3, Informative)

            Well, here in the US (and I would assume in other parts of the world as well), we have a nerd subculture whose members are called "Japanophiles."

            I think the proper term is 'Otaku'.

            Otaku is a different sort of term. A Japanophile would be a particular type of otaku, since an otaku is someone who is thoroughly obsessed with something. AFAIK, the "something" is not limited to any particular subset, although anime, manga, videogames, and subgenres of those things are common subjects for an otaku to be obsessed with.

          • Re:Honest Question (Score:4, Insightful)

            by tknd (979052) on Monday May 04 2009, @03:00PM (#27820319)

            I have seen some manga/anime and, maybe because Japanese culture is so different from my own, find myself often annoyed with some of what seems absurd to me. Why do they have to SAY what they are doing ALL THE TIME? ("I'll use flaming arrow fart to confuse him while I kick high in the air to thwart his dragon breath insticts" (wat the hell?)).

            Some anime/manga are targeted at kids while others are targeted at older audiences. You're certainly not going to find that in something like Ghost in the Shell, but Dragonball...sure.

            This is no different from The Power Rangers and other kid shows in the US.

            I do think a lot of the recent stuff coming out from Japan is crap. It has mostly been loli shows about little school girls and harems. But once in a while you can find a good show suitable for adults.

            The main cultural difference between the States and Japan as far as content goes (this includes Japanese "live action" shows) is that things over in Asian tend to be plot driven while in the States things tend to be character driven. So in Japanese shows it isn't uncommon to have stupid characters with no purpose or have little character development. In the States, however, nothing can happen in an entire season yet people fall in love with the characters.

    • it's the closest any of them will ever come to nailing cute Japanese girls
    • Re: (Score:2, Funny)

      by Anonymous Coward

      I'm sorry, did you just ask a bunch of nerds why they like comic books?

      • He asked an international but mostly american bunch of nerds why they seemed to like a japanese comic book style of drawing. Several key differences.

        To the GP, since when did "nerd" move from an umbrella term covering anyone who has an unusual personal interest in something obscure/technical? Speaking as a biology nerd, I don't run into much manga.

        • Re:Honest Question (Score:5, Insightful)

          by orclevegam (940336) on Monday May 04 2009, @02:16PM (#27819639) Journal
          I think it has less to do with the art style than the content. Manga/Anime tends to have more scifi themes than just about anything else (primarily due to the costs involved in doing things like mecha in other media formats) which naturally tends to appeal to nerds/geeks who are often fans of scifi. For great examples of this check out any of Ghost In The Shell, Guyver, Gunslinger Girls, Cowboy Bebop, Serial Experiments Laing (explores psychological aspects of reality), Gundam (to a greater or lesser extent, depends on which of the hundred or so versions you're talking about), Akira, Armitage III, and plenty of others that are too numerous to name.
    • I have no idea (was going to mod you insightful, btw), but I'm ready to sic the Daleks on manga/anime nerds. Some of them are wonderful people, but most just seem creepy... like they got into exported Japanese culture because they couldn't fit into their own. It has resulted in a cultural mixing of the creepiest nerds of the West with the disturbing pre-existing nerdiness of the Far East.

      To solve it, I recommend a big-budget adaptation of "Dune". That'll give nerds a region to fall in love with that actually has a decent culture and a major impact on the world today!

    • Re:Honest Question (Score:4, Insightful)

      by DaleGlass (1068434) on Monday May 04 2009, @01:34PM (#27818977) Homepage

      Why do people like books?

      Manga is just a way to tell a story, and unlike the western idea of "comics are for kids" covers pretty much everything, from material for little children to mature subjects.

      Probably part of the interest comes from that Japan is culturally different, so things that have been done 50 times already still seem new to us.

      Manga also often has very weird takes on familiar concepts, for instance compare the One Piece pirates with what'd you expect from the western version.

      • Funny, because most of the westerners I know that read/love/collect comics are in their late 20s early 30s. I think the whole "comic are for kids" thing died out years ago.
        There is also a distinction between "comic books" and "graphic novels" too. Just as there are adult themed comics in Japan, I am sure there are also ones aimed at Japanese kids.
        • There is also a distinction between "comic books" and "graphic novels" too.

          The pretentiousness of the owner?
  • by Lumpy (12016) on Monday May 04 2009, @01:06PM (#27818547) Homepage

    The Power Rangers guide to VI.

    and for the little kids out there...

    Teletubbies do SQL and PHP

  • ... introducing relational database management ...

    Aw, that's a shame. Where's the book with the story of young Gogol who starts in his garage trying to find a single sacred shard [wikipedia.org] to save his father, Sir Adword, so the kingdom can prosper again. It lies somewhere in the several million other shards across many distant lands. There is only one way to identify the shard. He must first discover the fastest path to a land that may or may not have it and alert all the other lands if he finds it ...

  • by Kell Bengal (711123) on Monday May 04 2009, @01:07PM (#27818575)
    Manga: is there anything it can't teach?
  • Not Right Now (Score:2, Informative)

    by Anonymous Coward

    Too busy playing Katawa Shoujo.

    There must be a hidden Misha route here somewhere...

  • by CambodiaSam (1153015) on Monday May 04 2009, @01:07PM (#27818587)
    I get the feeling this discussion is going to go down the same road that the Manga guide to Statistics [slashdot.org] one did...

    So, now you can run reports on the instances of tentacle penetrations based on any number of hierarchies and dimensions!
  • I've bought both the database one and statistics one and I must say I agree with the review, these books does a great job of giving a novice a quick introduction to the world of databases/statistics. While not covering everything, they will build up some base for the reader to allow him to read more in-depth books that might have been to heavy to start out with.

    I for one sure as hell had a hard time understanding statistics.

  • ...and it *is* a nice intro book for anyone that is new to databases and wants a DIFFERENT way of learning the basics. The key word here is different and in this case I am not sure if that is a good thing or not. The Manga guides take concepts and present them in a cutesy anime way. I feel that the approach probably works well in Japan but I am not sure how much of a market there is for this in the USA. There are other books that teach subjects in a different way such as the 'Head First' line. I guess this

    • Re:I've read it... (Score:4, Insightful)

      by moniker (9961) on Monday May 04 2009, @01:56PM (#27819353)

      I guess this is one of those cases where you dilute the market with a whole bunch of different ways to get concepts out to people and some stick better than others.

      You nailed it. The important thing isn't how silly you might look, but whether or not the student gets the concepts.

      One of my students in my intro class where I've used this book (briefly) is failing her other classes and has a learning disability, but is getting an 'A' in my class and is excited about working on extra credit (some data modeling problem solving) that she doesn't even need.

      Today, in class, I talked about how the intro skills they have learned in Access scale up, and passed around Oracle books on SQL, PL/SQL, OAS Reports, and was pleasantly surprised when the students actually spent time looking through the books. (The books were Oracle only because that is my background and graduate focus.)

  • Other guides (Score:3, Informative)

    by Zarhan (415465) on Monday May 04 2009, @01:11PM (#27818661)

    I have always liked Britney Spears' guide to semiconductor physics. [britneyspears.ac]

    I especially like the illustration on conduction and valence bands [britneyspears.ac].

  • I'm going to hold out for the fan-service edition.

  • Seriously, I think we see this on Slashdot at least once a year. Or at least, we definitely see a lame Manga Guide to SOMETHING once a year.

  • Do you read this book from right to left like a traditional Japanese manga?

  • by discord5 (798235) on Monday May 04 2009, @01:37PM (#27819029)

    If you are like me and learned things like normalization and set operations from a rather dry text book, you may be quite entertained by the contents of this book.

    I'm sorry, but SQL should be taught dry, no lube and no sedative. Anything else would be blasphemous or at least disturb the natural order of things.

    In all seriousness though, if you need this medium to make databases interesting for the reader, you're probably pandering to the wrong crowd. Anyone who needs to learn SQL will probably get a less childish book. Teenagers (and certainly college students) will buy this for the few laughs they get out of it, and that's about all the novelty you'll get out of it.

    I personally can't wait for the "Manga guide to Systems Administration" where princess Ruruna is faced with her arch nemesis The User. I hear in chapter 3 she opens up her box to replace defective parts. In chapter 15 she learns about security and discovers evil hackers have exploited her badly configured server. 2 chapters later it happens again but then she learns about a strange magic called firewalling.

    Other guides I'd love to read:

    • Manga guide to Assembly: Princess Ruruna just can't get her code to run fast enough, so she takes a journey to the magical land of Registra and learns how to tighten those loops
    • Manga guide to Network Administration: Princess Ruruna has a hard time running around the office with a USB stick until she discovers switches and routers.
    • Manga guide to BOFH: Tired of it all, Princess Ruruna starts reading The Users email. When The User complains about the lack of diskspace, she decided to delete all his data.
    • Manga guide to LISP: Princess Ruruna inherits her fathers kingdom and parenthesis. Crazy adventures ensue
    • Manga guide to Recursive Programming: By far the most artistic book of them all, princess Ruruna decides to draw herself drawing a picture of herself drawing a picture of herself drawing a picture of herself drawing a picture of herself drawing a picture of herself drawing ...
  • by DoofusOfDeath (636671) on Monday May 04 2009, @01:40PM (#27819093)

    This book sounds like a way better option than the book I bought last week, "The Hentai Guide to Microsoft SQL Server."

  • by Suzuran (163234) on Monday May 04 2009, @01:57PM (#27819371)

    So now my DBA can be EVEN MORE disconnected from reality?

  • by Tablizer (95088) on Monday May 04 2009, @02:23PM (#27819757) Homepage Journal

    Her parents, the King and Queen, have left to travel abroad. Ruruna has been left to manage the nations fruit business. Much is at stake...

    They lifted this from a Nigerian Prince scam. Seen variations of it a hundred times in my spam box. Finally, a way for Nigerian scammers to get legitimate funds (royalty payments).

  • by Locke2005 (849178) on Monday May 04 2009, @02:45PM (#27820127)
    Princess Ruruna starts out trying to use MS Access, but after being tentacle-raped by it, she switches to MySQL.
    • Re:Wow. (Score:5, Funny)

      by eln (21727) on Monday May 04 2009, @01:30PM (#27818913) Homepage

      I think you're being harsh. I look forward to seeing how they relate being raped by a giant tentacle monster to enforcing referential integrity. It seems like a fairly obvious analogue to me, but to others it might provide some insight.

    • Re: (Score:3, Insightful)

      Why not? In this age of ADD, ADHD, and general low attention span, this might be the ONLY way for someone to learn a dry subject.