Type of bind: Paperback
EAN num: 9788183331852
Format: Import
ISBN number: 8183331858
Label: BPB Publications
Manufacturer: BPB Publications
Page Count: 473
Printing Date: 2006-12
Publishing house: BPB Publications
Studio: BPB Publications
Other books you might be interested in perusing:
User popularity level:
Rated by buyers -
Adaptive Server Enterprise (ASE) 15 is the newest relational database management system (RDBMS) from Sybase and succeeds ASE 12.5.3. The numeric skip reflects the superstitious avoidance of "13" (Europe and the Americas) and "14" (China). The skip also reflects upon the scale of changes in the two releases; the query processor, for instance, was completely rewritten in ASE 15. Most of the authors are database administrators at Nielsen Media Research where they participated in beta testing of ASE 15. The book appears to be a byproduct of their beta testing and subsequent production usage.
After a mild jibe at Larry Ellison (Oracle CEO) on the very first two pages, we encounter the disclaimer "SYBASE, INC., AND ITS SUBSIDIARIES DO NOT TAKE ANY RESPONSIBILITY FOR THE CONTENT OF THE BOOK. SYBASE DISCLAIMS ANY LIABILITY FOR INACCURACIES, MISINFORMATION, OR ANY CONTENT CONTAINED IN, OR LEFT OUT OF THIS BOOK." I'm rather dumbstruck by the disclaimer and the usage of "official" in the book title. It smacks of false advertising and the inclusion of "official" in the title is not beneficial.
Progressing to the introduction we see that the intended audience is (primarily) database administrators, technical managers, system architects, and developers. The very first two chapters provide an overview of the new features and some pre-15 features. A layered approach has been well-established with these two chapters. (But have the authors created an onion or a cultured pearl?)
The heart of the book follows with chapters on semantic partitions and very large database (VLDB) support, scrollable cursors, query processing (features, performance issues, and availability of processing metrics), computed columns, and functional indexes. The topics are covered thoroughly (purpose, extensive sample code, usage rules, benefits, limitations, and impact to current code are usually included). Many subtle feature complexities are addressed within these topics. Some of the thoroughness is provided by pasting large SQL outputs (e.g., outputs of sp_help for all 12 valid combinations of clustered/nonclustered and local/global indexes are included). Shorter chapters on the graphical plan analyzer, software asset management, and server installation complete the new features.
The authors provide considerable repetition throughout the book. The same DDL for the Rental table is specified on pages 243, 247, and 250. This can be helpful since the reader is not inconvenienced with having to flip back pages to understand specific contexts - unless he is checking to see if there had been a subtle change to the table definition to illustrate a point. A blanket statement at the beginning of the book that states that DDL code is unchanged within sections of the book would have been helpful. On the top of page 199 a subtle critique of the old Oracle optimizer is made: "Remember, ASE uses a cost-based optimizer, not something like a `rules-based' optimizer." Three sentences later we have "ASE employs a cost-based optimizer or query processor." The difficulty that many technicians have in presenting well-written information is shown on page 113: "A global index can also be prefixed. Prefixed global indexes are available for all data partitioning strategies. Non-prefixed global indexes are not supported in ASE 15 as the industry deems this concept to not be useful in real applications." A good editor would have been helpful.
On page 152 the authors characterize non-scrollable cursor processing: "In prior releases of ASE, subsequent fetches from a cursor set were often performed within a while loop. The while loop would check for @@sqlstatus of 2." A check for @@sqlstatus UNEQUAL to 2 is actually intended. A better practice is to check for a status value of 0 for the "while" loop and have a separate "if" check for 2 after the loop. Still, the valid point is made that one will have to check both @@fetch_status (new) and @@sqlstatus with scrollable cursors.
Some mention of the Volcano query processing system, which the ASE query processor is based upon, would be nice. (Why did Sybase choose this model? What are its theoretical strengths and weaknesses?) But I readily admit that this would have been a fringe benefit.
The latter part of the book covers some pre-15 improvements: multiple temporary databases, Monitoring Diagnostics API (MDA) tables, JAVA, XML and Web Services. I wish that the authors had also included the "kill with statusonly" command. This option for "kill" does not seem to be in any of the current (June 2006) Sybase documentation.
There are two appendixes. For those who believe in certification, the very first appendix is a useful sample ASE 15 certification exam with 80 questions and answers. The second appendix is on three fictional use cases involving historical data, XML storage, and an order processing system using ... Read More
Find other books like this one:
