By Mana Takahashi, Shoko Azuma, Trend-Pro Co. Ltd.
Are looking to know about databases with out the tedium? With its special mix of Japanese-style comics and critical academic content material, The Manga advisor to Databases is simply the e-book for you.
Princess Ruruna is wired. With the king and queen away, she has to control the dominion of Kod's humongous fruit-selling empire. in another country departments, scads of stock, conflicting costs, and such a lot of clients! It's all one of these complicated mess. yet a mysterious e-book and a priceless fairy promise to unravel her organizational problems-with the sensible magic of databases.
In The Manga consultant to Databases, Tico the fairy teaches the Princess easy methods to simplify her information administration. We stick to alongside as they layout a relational database, comprehend the entity-relationship version, practice easy database operations, and delve into extra complex issues. as soon as the Princess understands transactions and easy SQL statements, she will be able to retain her facts well timed and exact for the complete country. eventually, Tico explains how one can make the database extra effective and safe, they usually talk about equipment for concurrency and replication.
Examples and workouts (with solution keys) assist you examine, and an appendix of often used SQL statements provides the instruments you must create and retain full-featured databases.
(Of direction, it wouldn't be a royal country with no a few drama, so learn directly to discover who will get the girl-the boastful prince or the common-or-garden servant.)
This EduManga ebook is a translation of a bestselling sequence in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.
Read or Download The Manga Guide to Databases PDF
Best databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can constantly come up over the perfect meanings of phrases, misunderstandings which could have a significant impact at the luck of your database initiatives. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating team, subscribe to dependency.
Additional resources for The Manga Guide to Databases
See Also: Chapter 8, "Configuring the Recovery Manager Environment" for configuration procedures, and Oracle9i Recovery Manager Reference for CONFIGURE syntax. ■ Automatic Channel Configuration The CONFIGURE command stores a persistent set of channel settings. RMAN automatically allocates these channels when you execute commands such as BACKUP or COPY at the RMAN prompt, abolishing the necessity for manual channel allocation. Use the CONFIGURE command to define backup attributes such as parallelism, duplexing, and channel control options.
See Also: Oracle9i Recovery Manager Reference for REPORT syntax ■ CREATE CATALOG Command The CREATE CATALOG command creates the recovery catalog. /dbs/admin directory. See Also: Oracle9i Recovery Manager Reference for CREATE CATALOG syntax ■ UPGRADE CATALOG Command Previously it was necessary to run a SQL script to perform a recovery catalog upgrade. Now you can upgrade the catalog with the UPGRADE CATALOG command. See Also: Oracle9i Recovery Manager Reference for UPGRADE CATALOG syntax ■ DROP CATALOG Command The DROP CATALOG command removes the recovery catalog schema.
See Also: Chapter 12, "Duplicating a Database with Recovery Manager" ■ Disk Affinity in Oracle Real Application Clusters When backing up on multiple nodes of an Oracle Real Application Clusters configuration, it is possible that some disks have affinity to certain nodes in the cluster such that access to those disks is faster from those nodes than from other nodes in the cluster. RMAN recognizes node affinity, if it exists, and attempts to schedule datafile backups on channels allocated at nodes that have affinity to those files.