|
|
|
|
|
|
|
Oracle Essentials
Rick Greenwald, Robert Stackowiak, Jonathan Stern |
|
|
O'Reilly Media, Inc.
Published: 11 February, 2004 | |
As with most O'Reilly books, Oracle Essentials is crammed full of information. The book is geared for DBA's, system admins and developers. The book assumes some general knowledge of databases, but most concepts are explained as they come up. For example, there are sidebars for normalization and RAID.
The third edition is updated for Oracle 10g. Since the authors point out which features are specific to Oracle 8i, 9i and 10g, this book is just as useful for older versions of Oracle. For readers of previous editions, the book has an appendix directing the reader to the new 10g content.
For developers, using Java with Oracle is explained. There are good sections on SQLJ, JDBC, EJBs and Java stored procedures. For DBA's and system admins, the book covers architecture, failover and deployment. The book uses a good mix of text, diagrams and examples. Many cutting-edge topics are explained with a non-platform specific background of the topic and examples. These topics include OLTP, Data Warehousing, Business Intelligence and of course -- Grid Computing.
I found the list of major technologies to be extremely useful. Chapter 1 has a paragraph on Oracle features in the database, application server and standalone development tools. The rest of the book focuses on the database itself. This book covers everything you would want to know about Oracle and provides references for more detail on each topic. If you are only going to buy one Oracle book, this is the one to buy.
(Jeanne Boyarsky - Bartender,
May 2004)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
SQL Performance Tuning
Peter Gulutzan, Trudy Pelzer |
|
|
Addison-Wesley Professional
Published: 20 September, 2002 | |
So you just bought that Surrey with the fringe on top, but the wagon wheels squeek and the horses are trotting slowly. What do you do? I'll tell you. You go out and buy SQP Performance Tuning.
While not written to a specific DBMS, this book examines every nook and cranny of SQL statements, table structure and storage, indexes, stored procedures and many more.
It would take many years of experience, through trial and error, to figure out half of these "Speed Fixes". But it is all right here in one book. Every SQL expert wishes they had had this book when they started. It would have saved them years of frustration. I just wish I could memorize all the great suggestions and how to's in one reading. So this will now be my #1 reference book when writing SQL queries et al.
Buy this book now.
(Mark Spritzler - Bartender,
March 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Expert Oracle JDBC Programming
R. M. Menon |
|
|
Apress
Published: 30 May, 2005 | |
"Expert Oracle JDBC Programming" is part of a new series called OakTable Press. This series is written by Oracle experts, making the quality very high. In fact, one of the technical reviewers of this book is "Ask Tom."
This strong relationship with Oracle results in trying to convince the reader to use stored procs/Oracle specific code. This isn't a good or a bad thing -- just something to know up front. The author clearly shows what is Oracle specific and describes the tradeoffs.
The book has three sections, starting with an introduction to JDBC. While JDBC knowledge is not required, it is helpful to get full benefit from the book as advanced concepts are introduced very quickly. The book relies heavily on code with all examples clearly explained. The second section goes into Oracle specific concepts. The last section explains best practices, issues and specific performance related concepts.
This book is distinguished from others by the emphasis on good quality, high performing code. Benchmarks are provided from the beginning. Chapter 1 even covers how to time your code.
As you can tell from the title, the book is Oracle specific. So you can copy/paste the code and run it on Oracle. All code examples specifically state whether they work on 9i, 10g or both. The focus of Oracle also allows the author to demonstrate exactly what needs to be done to run/test the examples on Oracle. I recommend this book for Java developers on Oracle.
(Jeanne Boyarsky - Bartender,
February 2006)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
The Definitive Guide to MySQL 5
Michael Kofler |
|
|
Apress
Published: 23 September, 2005 | |
My requirements for this book for quite light, so I can't say that I used it to its full potential, but I can say that it filled my requirements completely, and it clearly has so much more ready and waiting to show me in the future.
Ranging from first steps with MySQL all the way up to the advanced features, 'definitive' is a good description for the book. I've always found that there are great MySQL resources on the web, but the layout of the book, clear descriptions and concise examples will give you a single location and unified view of anything you'll need.
There isn't really any point mentioning individual sections. Readers experienced with other databases will find coverage for all of the sections they expect, and likewise new users will be provided the information they require. This is one of the few books I've seen that works for both picking up a new topic and as a reference for flipping to a specific section.
I was a little concerned that it was written in another language and translated to English for this copy, but apart from some of the sample data in the examples this is never an issue.
You won't find a better MySQL resource than "The Definitive Guide to MySQL"... until the next revision comes out!
(David O'Meara - Bartender,
December 2005)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
JDBC API Tutorial and Reference
Maydene Fisher, Jon Ellis, Jonathan Bruce |
|
|
Prentice Hall PTR
Published: 21 June, 2003 | |
Well, this certainly is a big book. Sun appears to have gathered its most knowledgeable people on JDBC and related topics, squeezed the information out of them and knitted it into "JDBC API Tutorial and Reference, Third Edition".
It sounds far too broad in scope to work, as it is both reference and tutorial for users ranging from beginner to advanced, but in this book they appear to get it right. I guess they could have written two or three books instead, but this way it works in your favour, since this may be the only JDBC book you'll ever need.
Due to its size, it's unlikely you'll read it cover to cover, so to be useful the information would have to be organised logically and indexed well. Luckily, it is! Novice and beginner JDBC users will get the most from the first section, which contains all of the introduction and tutorial data. The second section is a comprehensive reference that will be of enormous use to all JDBC users regardless of their skill level. The strength of the second section lies in the fact that it contains the sort of detail you wished was always available in Javadocs.
All in all, it is worth adding to your library even if you only program direct JBDC a few times a year.
(David O'Meara - Bartender,
July 2003)
| |
|
Prentice Hall PTR
Published: 21 June, 2003 | |
|
Whether you are a beginner, intermediate, or advanced JDBC programmer you will find useful information in this book. The book is divided into two sections. The first section is a tutorial on using JDBC. The tutorial starts with a look at JDBC 1.0. The next chapter looks at the additional features added to JDBC in 2.0 and 3.0. The third tutorial chapter looks at metadata. The final chapter examines the RowSet interface, which is complex enough to need its own chapter.
The remainder of the book (about 800 pages) is a reference containing a chapter for each class or interface in JDBC. Each chapter contains an overview of a class or interface, sections on anything of special interest or complexity, and a list of all the methods of the class or interface with complete descriptions. If a section applies to a particular version of JDBC, the version it applies to is clearly marked. The information contained in the reference is much more than you can find in the APIs. The reference section itself is well laid out to make the information you need easy to find.
This is probably the only JDBC book you will ever need. No matter which version of JDBC your database drivers support, you will find your answers in this book. he book is well written with clear explanations and plenty of code samples. Anyone working with JDBC will want this book by their side while they are coding.
(Thomas Paul - Sheriff,
July 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Mastering Data Mining
Michael J. A. Berry, Gordon S. Linoff |
|
|
Wiley
Published: 28 December, 1999 | |
I was looking for an introductive overview on "what is data mining", and I am more than satisfied.
This book is about data mining in practice rather than in theory. It describes the whole process, from deciding which data columns aren't very useful, to testing and tuning the model -- the very details they forgot to tell us in my statistics class. There are rules of thumb ("set a minimum node size for a decision tree around 50 or 100"), and estimations ("in general, you need at least several thousand records in the model set", "the ratio of the rarer outcome should comprise 15-30%"). Three main techniques: cluster-detection, decision trees, and neural networks are described, and the principles of their working explained in plain language. Details are provided concerning when to use each technique (neural networks cannot explain result while decision trees can), and what types of data each technique works best with (decision trees works with categorical variables (e.g. list of states), neural networks require numerical input and cannot deal with missing values).
Almost half of the book is devoted to case studies. It can be boring reading, unless you are a data obsessed person, and if you are not, you probably shouldn't go into data mining. I was surprised myself that I did not skip this part, instead reading it with increasing interest.
My only complaint about the content: there is no chapter about what software is available to perform data mining.
Almost no formulas are presented, except for a few simple diversity metrics given in a couple of sidebars. There are however plenty of graphics, diagrams, and screen-shots. The text is very dense, so I was a little overwhelmed after my first reading. A second pass was needed to improve my understanding.
The book is so practically oriented, that it's almost "learning by example". To get the most of it, read it after you read a more traditional, systematic tutorial -- it will be an indispensable supplement.
(Margarita Isayeva - Sheriff,
May 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
MySQL and JAVA Developer's Guide
Mark Mathews, Jim Cole, Joseph D. Gradecki |
|
|
Wiley
Published: 21 February, 2003 | |
Mark Mathews is the creator of the mm.mysql JDBC Type IV Driver. He was then hired by the MySQL Team to continue his development of the driver which then became Connector/J. What better person to co-author a book on MySQL and JAVA? I was really excited to get this book because I use MySQL and Connector/J for all of my JAVA Database needs. The first 5 chapters were pretty much review for me with the exception of some minor MySQL specific details that were really helpful. I learned a few things about MySQL that I had missed trying to get through MySQL's fairly cumbersome documentation. I found the remaining half of the book super informative and fairly rich for a "Getting Started" type of book. The appendix alone is worth its weight in gold since it contains all the data type mappings from MySQL to JAVA. This book also helped me learn how to use Connection Pools which I had not used until now. All the examples are straight forward and easy to understand. The book covered precisely what I expected from the title. I would recommend this book to anyone that wants to get started with JDBC and MySQL. However, I would not recommend this book to someone already fluent in these technologies. This is definitely a beginner to intermediate level book.
(Gregg Bolinger - Bartender,
March 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
MySQL
by Paul DuBois |
|
|
New Riders Publishing
Published: 28 December, 1999 | |
The book MySQL is an excellent book. My employer uses MySQL for many of our database needs and, being relatively inexperienced with databases, I had to be brought up to speed quickly and with good, accurate knowledge. This book is that resource. The coverage includes everything from setting up databases and tables to new users and permissions. When I have a question I almost always go directly to the book as opposed to the help pages that came with the database itself. The clear wording and solid explanations along with the excellent examples make it an extremely handy reference to have around at all times. I find myself referring to the book quite often for the finer points in creating SQL statements to do what I need them to do. The examples in the book cover almost every situation I've needed them to. Very rarely do I have the need to go elsewhere or seek additional resources for an answer. If you are going to be developing applications that interact with a MySQL database (whether your language is Java, C, PHP, or PERL) you need this book. It covers all of the functions and common tasks as well as database administration, security, and maintenance and repair. This is a great book and I would highly recommend it to everyone working with MySQL databases.
(David Vick - bartender,
April 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Java Programming with Oracle JDBC
by Donald K. Bales, Don Bales |
|
|
O'Reilly Media, Inc.
Published: 15 December, 2001 | |
A workmanlike book which achieves its aims.
This book is for Java developers who need to get the most out of using JDBC and Oracle (version 8.1.6). Choosing a specific database allows a lot more detail. Other JDBC books may skip database-dependent parts of the API; this book even gives code examples for the hard stuff. It is slow to read end-to-end, but "dipping" works well - there's almost always a helpful code example nearby.
There are problems, though. The author is obviously very familiar with Oracle, but lacks the experience to make comparisons with other products, this book won't help you choose when to use Oracle. Also I noticed other signs of lack of research - he sometimes gets abbreviations wrong, and the Java code is not particularly well-written.
The big problem for me is that the book assumes you only ever use Oracle. There is no consideration of code portability, it offers no wisdom about avoiding proprietary Oracle-specific extensions. The techniques in this book could easily lock your product into Oracle.
The book has minor discussion of extra features in Oracle8i and Oracle9i, but nothing about JDBC 3. It's less helpful if you are using a version older than 8.1.6, too.
If you have already sold your soul to Oracle, get this book. If you might use other databases, get a more generic book, and keep this one for emergencies.
(Frank Carver - Sheriff,
August 2002)
| |
|
O'Reilly Media, Inc.
Published: 15 December, 2001 | |
|
An excellent coverage of Oracle's implementation of JDBC, this book beats your expectations.
Meet the middle ground where the strengths of Java and Oracle work in synergy - the JDBC. Whether making simple database connections or using the Oracle 8i's sophisticated object-relational features, the authors peel the onion very well with detailed information and cleverly written examples. After a brief overview of JDBC, several different types of database clients are discussed in detail - the applets, the Servlets, the Server side internal drivers and those managed by J2EE using JNDI and connection pooling.
A whole section is dedicated to traditional uses of JDBC API such as cursors, submitting prepared statements and ResultSet manipulation. The chapter on Object-Relational SQL covers broad ground on both Weakly Typed Object SQL and Strongly Typed Object SQL.
Enterprise essentials such as Security, locking, transaction management supports for data encryption and SSL issues, performance tuning and testing strategies - are addressed in detail. This book is treasure trove if newer feats of Oracle are of Interest to you. I found immediate application for features such as creating object tables and column objects based on user-defined data types, support for really big streaming BFILEs and LONG RAW data types and batch processing for my project.
Overall, this book has everything you need to learn, know and master in order to leverage the essential two great technologies - JDBC and Oracle. Every serious Java developer should have this at arms reach.
(Ajith Kallambella - Sheriff,
February 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
JSP, Servlets, and MySQL
by David Harms |
|
|
John Wiley & Sons
Published: April, 2001 | |
This book will help you get your Java Servlets, JSPs and MySQL databases to work together and provide a full-fledged dynamic database-driven web site. The author, David Harms, masters at presenting the concepts clearly. Server-side Java components --JSP, Servlets and JavaBeans-- are briefly introduced. Then, the author explains what relational databases are and why the latter are so important when designing dynamic web sites. He also goes into the details of installing, configuring and running the MySQL server and client as well as how to properly design a database.
The Model-View-Controller (Model 2) design pattern is introduced in a way that definitely shows how each of its component areas perfectly map to server-side Java components and databases, that is Java servlets take the role of the Controller, JSP and custom tags the role of the View and JavaBeans and the database the role of the Model. Such decomposition makes any application very flexible and easily maintainable.
The final part is dedicated to some strategies one can use to make benefit of its database, like how to authenticate users, survey them, collect server statistics and so on. The Struts application framework which already implements perfectly the MVC design pattern is also briefly introduced.
(Valentin Crettaz - Bartender,
January 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Expert One-on-One: Oracle
by Thomas Kyte |
|
|
Wrox Press
Published: 2001 | |
This book is everything you would expect from Oracle Magazine's 'AskTom'! It does require a good understanding of SQL and a basic understanding of PLSQL as stated in the beginning. Tom gets right into the meat of things with tips on developing successful applications using an Oracle backend. This book is loaded with tips and examples that will improve the chances for success. I personally wished for more examples using JavaStored Procedures but on review, I knew that I could successfully implement this technology anytime it may be necessary.
Who needs this book? Definitely any Architect, Designer or Developer with a project involving Oracle. You may be assign the Java middleware but understanding how to best utilize your backend will help ensure success. Tom's tips actually extend to any Enterprise database system and while all the examples may not work in Informix or MS SQL7, most of the techniques for improving performance will be beneficial! I feel it is an absolute must for any PLSQL programmer!
(Carl Trusiak - Sheriff,
August 2001)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Database Programming with JDBC and Java, 2nd Edition
by George Reese |
|
|
O'Reilly Media, Inc.
Published: 15 January, 2000 | |
George Reese did an excellent job of providing a quick overview of the technologies and concepts require for developing an Enterprise System, beginning with the requirements for a true Enterprise System. The database is the heart of any enterprise system and Java provides strong, reliable database connectivity. He also covers basic SQL, intro to JDBC including its structure, alternatives, creating a connection, and basic database access. He then turns to more advanced JDBC including prepared statements,batch processing, rowsets, distributed transactions, and more.
In the second section, Applied JDBC, he covers topics such as JNDI, RMI, serialization, EJBs, system architecture (two-tier and three-tier), design patterns, distributed components, security, transaction handling, and other topics more peripherally related to JDBC, but necessary for developing an enterprise system. He also walks through an example distributed database application.
The final section of the book presents the JDBC Core API and the JDBC Optional Package as reference material.
The author's style of writing seemed very readable, clear and concise.
In summary, this 300-page book is a great introduction for those who want to approach Java distributed applications by way of database work as it discusses JDBC in the context of enterprise systems.
(Marilyn de Queiroz - Sheriff,
August 2001)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Professional Oracle 8i Application programming with Java
by John Carnell, et al |
|
|
WROX PRESS
Published: 2000 | |
To produce this book, Wrox took twenty expert Oracle developers and had each of them write about their area of expertise. The result is that whether you are a manager, a developer, or a DBA, if you are working with Oracle 8i this book should be on your desk. This book covers virtually every topic that you need to understand about the Oracle 8i development platform. It does not cover each topic completely but it provides a thorough and in most cases sufficient introduction on each topic. For a particular topic of interest you may need an additional book but to get all the information found in this book you would need ten volumes at least. The book opens with an introduction to Oracle 8i and some of its components including Net8 (Oracle's network solution) and Designer 6i (Oracle's development environment). The next section covers PL/SQL and PSP (this is similar to JSP). This is followed by an extensive section covering Java. This section covers JDBC, SQLJ, EJB, and interMedia (Oracle's powerful search tool). The last section covers XML and includes information on DOM and SAX parsers, SOAP, XSL, XSQL, and more. Extensive case studies are scattered throughout the book. Examples show how to use Oracle tools such as BC4J to develop enterprise applications. The book even includes primers on Java and XML. As a tour of all the features of Oracle 8i, this book is without competition.
(Thomas Paul - bartender,
June 2001)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Pro Hibernate 3
Dave Minter, Leff Linwood |
|
|
Apress
Published: 27 June, 2005 | |
So you are starting off with Hibernate and you want a book to learn from. If you want the basics and get up an running pretty quickly, then this book works well for you. If you intend to do some complex stuff that is using more underneath tools of Hibernate, then this book might be too surface for you.
I enjoyed the book and recommend it as a beginner's book just starting off. I think the examples and writing style make it an easy to read and understand book. But I also think it stays to high level with Hibernate. Hibernate has an interesting learning curve. The basic simple mappings are easy, but once you get more relational and complex, then the learning curve steepens. I would have liked to have seen this book delve into the more "gotchas" that everyone learning Hibernate always fall into, but it doesn't.
(Mark Spritzler - Sheriff,
September 2005)
| |
|
Apress
Published: 27 June, 2005 | |
|
The task of mapping objects to tables in a relational database (O/RM) has been the focus of many research projects as the O/RM problem domain is a very complex area that has long been short of efficient solutions. A host of vendors and open-source communities have tackled the O/RM problem and have come up with solutions, such as EJB, Toplink and JDO, which were either considered successful or inefficient depending on a wide range of subjective and objective point of views.
To the rescue comes the third release of the famous Hibernate framework, which is said to provide today's most elegant O/RM solution. I take as a proof the fact that the upcoming EJB 3.0 specification is heavily based on the design concepts underlying the Hibernate framework. The first part of this book focuses on presenting the basics of Hibernate 3 while the second part provides more detailed content that shows how to create mapping files, to query objects using HQL, SQL and the Criteria API, to use events, interceptors and filters, to manage sessions, etc. Minter and Linwood also explain how to fit Hibernate into an existing environment and how to upgrade from previous Hibernate releases.
In summary, intermediate and advanced Java developers who have good working knowledge of database management and who are in need of a powerful and cutting-edge O/RM solution will be very well served with this comprehensive, yet somewhat slim, APress reference.
(Valentin Crettaz - Sheriff,
August 2005)
| |
|
Apress
Published: 27 June, 2005 | |
|
I have several Apress "Pro Series" books and have yet to be disappointed. Pro Hibernate 3 is no exception. Dave Minter and Jeff Linwood do a superb job of getting the reader comfortable with the open source Object Relational Mapping tool, Hibernate.
Starting off with a simple example, the authors show you everything you need to create your first Hibernate application. From there you are shown more complex mappings, how to use the Session object, DAO pattern, Criteria API, well, you can read the TOC.
The book is very well written, clear, concise, and easy to read. The book is full of code and mapping examples that all work (yes, I tested them) with the exception of chapter 10 which points you to a download of the source. I have one complaint and that is between chapters 2 and 3 I felt I was flipping pages back and forth between the two chapters in order to get all the source code I needed for the example. Note also that the book lists required libraries for running Hibernate applications but seemed to miss one, asm.jar. So make sure you have that in your classpath if you are using the latest stable release of Hibernate.
If you are new to Hibernate or maybe you've used it minimally in the past, you'll find this book very informative and useful not only as a learning tool, but as a reference when you run into snags throughout the development of your applications.
(Gregg Bolinger - Sheriff,
July 2005)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Databases Demystified
Andrew Oppel |
|
|
McGraw-Hill Osborne Media
Published: 01 March, 2004 | |
Databases Demystified was written so you would not need all of the technical jargon that you find in other books. The only problem I find with it is that certain places are way too wordy. Overall this book is great for a broad view about databases. Some areas that the book covers are: a brief history on databases, database design, database models, using forms, and general SQL.
This book would be great for a supplemental text to other books. It contains quizzes at the end of the chapters, but I felt some of the questions were there to make sure that you actually were reading the book and were not that important.
Databases Demystified takes a general look at all databases so you can have a basic understanding how they all operate. Since the book is a broad overview of databases, those concerned only with Oracle or Microsoft Access will not find it helpful. I would recommend this book to anyone that needs a general knowledge about databases. I personally learned a great deal from the book.
(Eric Pascarello - Bartender,
April 2004)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Java Database Best Practices
George Reese |
|
|
O'Reilly Media, Inc.
Published: May, 2003 | |
JDO or EJB? JDBC? BMP or CMP? EJB BMP with JDBC and JDO on a RDMS?
Have you ever been caught up in the alphabet soup of Java database programming APIs? Have you ever questioned which approach might be best suited for your particular application? Sure you pride yourself on your skills in crafting some pretty mean EJBs, but is that the best path to head down with your latest project? O'Reilly's new book "Java Database Best Practices" attempts to answer these questions and more.
For such a relatively thin book (267pp), it touches on a wealth of topics vital to the subject at hand. Reese lends his insights concerning database architectures, database design, transaction management, and persistence methods using JDBC, EJB, and JDO. While this isn't intended to be an introductory tome, you are also not expected to be proficient with all these APIs. As such, the latter third of the book contains tutorials on relevant J2EE APIs, JDBC, JDO, and SQL.
Reese does not exhaustively go into detail on every topic, each of which could probably warrant its own book. Rather he arms us with just enough information to make informed decisions about which method might best serve our applications. Aside from merely determining which set of APIs might be best suited in a given situation, Reese also points out several best practices to help guide us in design and implementation (for example, "use join tables to model many-to-many relationships").
I do have a couple of small complaints about the book. For one, "best practices" are highlighted throughout the text, but they are not enumerated or indexed in any manner. An enumerated list of these best practices would be welcome. Secondly, MVC purists will likely cringe at the JSP examples. While the architecture shown (JSPs as view and control, database access through taglibs) may be valid for small web applications, I don't feel it should be highlighted as a "best practice", particularly for enterprise applications. None of these complaints are major however, and do not overly detract from the value of the book.
"Java Database Best Practices" accomplishes what it sets out to do. This is a book that might be handy to have to pass around your development team in the design phase to get you all on the same page when making some critical choices. This book could also well serve those, such as managers perhaps, seeking a broad survey of Java database programming. I also feel that this book would make an excellent companion text for a college database programming course using Java. While "Java Database Best Practices" won't make you an expert with all of these APIs, it will certainly point you in the right direction.
(Jason Menard - Bartender,
June 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Practical Issues in Database Management
Fabian Pascal |
|
|
Published: | |
"Practical Issues..." aren't practical in a popular sense of this word. The book is about fundamentals, and this is the author's belief that knowledge of fundamentals is the most practical asset. If you do not subscribe to this view, practical usefulness of this book wont be obvious.
The book was written to educate audience on most misunderstood points of data management theory, which for the author means the Relational Model, and to debunk most popular myths about it. The author formulates the problems with the current state of RM support in SQL and commercially accessible databases with stress on shortcomings, gives recommendations on workarounds where possible. Maybe the most important is a meta-lesson: a text written with such an intellectual rigor, where all the terms are given strict and precise definition, sets standards so high, so you will be looking for the same level of clarity ever since.
A prospective reader should be familiar with the basics of the relational model, normalization theory and SQL. My rusty knowledge was enough. The book is written in an easy-to-comprehend manner (I read it in few days), and I would recommend it for beginners as a must-read complementary book on database design, and for more experienced readers who want to accustom themselves with an account of the Relational Model as given by one of its most prominent champions.
(Margarita Isayeva - Sheriff,
December 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
OCP Introduction to Oracle9i: SQL Exam Guide
by Jason S. Couchman |
|
|
McGraw-Hill Osborne Media
Published: 29 October, 2001 | |
This book is very well organized and easy to understand. There are few errors and you can find corrections on the related web site: http://www.exampilot.com/bugrep.htm (you should always check a book's web site if there is one).
I haven't taken the test yet, so I can not tell you how good the coverage is, but it feels kind of light. Maybe the exam got easier or the book is not going deeply enough into details.
After reading this book, I did not feel 100% ready for the exam. By the way, do not expect to learn exam-related topics from this book; it is only for review. The book will certainly show you the path and lead you to your certification if you are experienced with Oracle.
(Ersin Eser - Bartender,
April 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Oracle PL/SQL 101
by Christopher Allen |
|
|
McGraw-Hill Osborne Media
Published: 01 December, 2000 | |
This book lives up to the promise on the cover. It gives the reader a rapid understanding of Basic SQL. And enough PL/SQL for the user to write flexible Programs in short order. There are 9 chapters, each a lesson kept to the perfect level to ensure understanding. All the chapters build on each other at an appropriate rate. Any developer working with an Oracle Database and needs to learn the basics needs to get this book. The understanding that Christopher gives of basic SQL and complicated joins and unions will be beneficial. You'll be able to apply everything you learn in your JDBC application even if you don't use any of the PL/SQL. However, once you learn the topics provided, you'll see areas where you could gain significant performance enhancements using PL/SQL Stored Procedures.
Excellent first book to learn SQL and PL/SQL!
(Carl Trusiak - Sheriff,
October 2001)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
JDBC Recipes
Mahmoud Parsian |
|
|
Apress
Published: 15 September, 2005 | |
The 600 page "JDBC Recipes" might make a decent 100 page book. Some problem/solutions are repeated verbatim and others are repeated with minimal changes. For example, there are at least 8 distinct sections on closing a database resource. The BLOB/CLOB and Statement/PreparedStatement chapters are at least 50% identical.
Despite all this repetition, coverage manages to be spotty on other topics. For example, CallableStatements are barely mentioned. Many ways are presented of doing a task, but the tradeoffs aren't covered. Except for connection pooling, there weren't many comments about JDBC in practice.
The stated audience is developers knowing the basics of Java, JDBC and databases. Examples span 1-4 pages of code with only minimal, high-level comments afterwards. Experienced developers know most of this stuff and shouldn't have to plow thru so much code to discern the important points.
The examples are tailored to Oracle and mySql. If you want to write code without vendor lock-in, this book doesn't help. The cover says "Java EE 5 compliant." While true, this is misleading. Most references are to the 1.4 JavaDoc. The 5.0 references don't use the new features.
The book serves a very narrow audience. If you want to copy/paste Oracle/mySql code verbatim, the book's website is very useful. If you have a database framework, want cross-database compatibility, best practices or are simply reading for understanding, I recommend a different book.
(Jeanne Boyarsky - Bartender,
December 2005)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Java Persistence for Relational Databases
Richard Sperko |
|
|
Apress
Published: 02 July, 2003 | |
As the title indicates, this book takes a look at different methods in Java for persisting data to a relational database. JDBC, EJB CMP 2.0, ODMG 3.0, JDO, open source frameworks (Hibernate and Castor), and commercial frameworks (TopLink, CocoBase) are all given a look. The author touches on rolling your own persistence framework, and throws in a little bit about relevant design patterns and unit testing.
Overall this book left me with more questions than answers. Often we are told what the capabilities of a given library or framework are, but not how to make use of those capabilities. Frequently we are teased with a bit of information, only to be told that we need to go to another source to find anything of substance. Just as often, a promising topic such as unit testing the persistence layer is left inadequately addressed.
If you are looking for a broad overview on the book's subject, then this book may be for you. However, while this book ostensibly should help a manager or developer choose a persistence method suitable for his project, I'm afraid no guidelines are given as to when one particular method may be preferable to another. Although we can't expect a book such as this to be all encompassing, many sections in this book urge the reader to look elsewhere for more information. In this case, that might not be such bad advice.
(Jason Menard - Bartender,
August 2003)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Beginning Database Design
Gavin Powell |
|
|
Wrox
Published: 05 December, 2005 | |
As the title states Beginning Database Design is aimed at people new to database design. The book does a reasonable job introducing this topic but has a fair number of problems.
What I liked:
Good coverage of the basics - datatypes, ERD, keys, SQL, indexes, normalization, denormalization.
Exercises at the end of most chapters.
A case study for an online auction house.
What I disliked:
The first two chapters can be skipped unless you are completely new to databases.
The same information is repeated throughout the book sometimes within the same paragraph. While this can be an aid in helping people to learn a new topic it gets old fast.
Some strange turns of phrase and typographic errors that required me to re-read sections of the book a few times before I understood what the author was saying.
Not enough exercises.
Overall, a fair introduction whose effect is reduced by repetition and poor writing.
Full disclosure: I received a complimentary copy of the book for review.
(John Wetherbie - Bartender,
June 2006)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Common Warehouse Metamodel
by John Poole, Dan Chang, Douglas Tolbert, David Mellor |
|
|
Wiley
Published: 15 November, 2001 | |
I'll say at the start that this is not my kind of book. I prefer books which are useful, enlightening or both. This didn't seem to be either. From page 3: "The mission of this book is to provide a single, coherent, and comprehensive overview of the OMG's Common Warehouse Metamodel, which is easy to read.". It may be slightly easier to read than the raw specification, but it's a lot less useful. The most telling point is further down the same page where it admits to really being just an introduction to a forthcoming "Warehouse Metamodel Developers Guide".
For an overview, the book is really short on examples. It's got lots of vague UML diagrams and pretty pictures like you might see on a powerpoint slide, but not a single worked example to show how all the buzzwords and technologies might actually fit together. I also have great problems with their use of UML as a language to actually specify data models, processes and so on. For me UML is a tool to help express intentions to people, not supply details to processing software, but this book seems to ignore the difference.
If you know nothing about meta-modelling, and want the sort of information you can get from the slides of a conference presentation, this may be a useful book. If you want to understand the details, or (gosh) actually get a job done, then this book will just frustrate you.
(Frank Carver - Sheriff,
June 2002)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Java Database Programming
by Jepson, Brian |
|
|
Wiley
Published: November, 1996 | |
This book is subtitled "Master Next Generation Web Database Techniques", so you might be forgiven for thinking that it has something to do with the web, or HTML, or distributed computing. No such luck. What you really get is mostly a collection of annotated source code listings for a simple SQL interpreter and database using plain text files,padded out with one or two chapters of introduction to SQL and JDBC. If you are interested in how an SQL database might be written, or you want to provide an SQL/JDBC interface to some plain text files then it could still be a ueful book, but I can't give a good review to any book which so wildly misrepresents itself.
(Frank Carver - Sheriff,
November 2000)
| |
|
More info at Amazon.com ||
More info at Amazon.co.uk
| |
Couldn't find the book you wanted?
Click here for some additional books that we have
not reviewed yet.
|
