No label defined (Q4234034)
From MaRDI portal
!
This is the item page for this Wikibase entity, intended for internal use and editing purposes. Please use the normal view instead:
scientific article; zbMATH DE number 1263037
| Language | Label | Description | Also known as |
|---|---|---|---|
| default for all languages | No label defined |
||
| English | No label defined |
scientific article; zbMATH DE number 1263037 |
Statements
16 March 1999
0 references
management systems
0 references
SQL
0 references
object-relational databases
0 references
Oracle8
0 references
In 1998 Hanser Verlag edited a book in the German language which is a comprehensive reference for Oracle 7 and 8. Altogether, the book numbers 1201 pages. It is accompanied by a CD-ROM, running under Windows-95, that contains the complete reference and the examples from the book, ready to use. The motivation for the book was to offer the most important information on Oracle to several kinds of users. The Oracle documentation consists of around 50 volumes. Knowing this, the 1201 pages don't seem too much for a comprehensive reference guide. The book aims at three kinds of users: end-users, starting application developers, and experienced application developers. The reviewer can guarantee that this book is indeed to be recommended to these users. The strength of the book is mainly built on its clear structure, a clear language, the consequent use of easily understandable examples, and references to further explanations within the several chapters of the book. The content is structured rather problem-oriented, but complemented by an alphabetically ordered reference. The reviewer would have appreciated to find also references to the systems documentation volumes. The content is as follows: Part 1: Critical database concepts; gives an introduction to the relational data model, refers to common mistakes, explains term and especially the potential of the relational model. Part 2: SQL: From beginner to expert; is a systematical guide to SQL and SQLPlus, pays attention to an efficient use, pitfalls, and an advantageous use of terms, giving names etc. It also gives information on: code-generation, program-technical loading of variables, nesting of start-file and host-processes in SQLPlus, use of distributed databases, triggers and Stored Procedures. The chapters: basic SQL elements, basis of object-relational databases, basic SQLPlus-reports and commands, getting and changing text information, a numerical game, date (also: the year 2000), converting- and transforming functions, having, group, order, subqueries, some complex possibilities, making a report with SQLPlus, updating, inserting and deleting data, advanced applying of functions and variables, DECODE, creating, updating and deleting tables and views, authorization, changing the Oracle environment, SQLPlus: generating code for a query, nesting of start files etc., database links, PL/SQL, trigger, procedures, implementing types, object-view and methods, collectors, LOBs, snapshots, text search with ConText, advanced object-oriented concepts in Oracle8. Part 3: Per hitch-hiking to the Data Dictionary of Oracle8; is a problem-oriented guide to the data dictionary views of Oracle8 and gives hints for applying them in the right manner. Part 4: Design and Productivity; is especially recommended to developers because concepts and functionality are discussed, which is hardly to be found in other places (among others: 10 commandments for a human design, rules for the design process itself, performance issues and design, optimize, merge join, nested loops, hash join, connect by, sequences, database links, tuning issues). Part 5: The alphabetical reference; is a complete reference for the Oracle server (commands, key terms, products, performance hints, functions, cross references). Part 6: Appendix; completely illustrates the examples (commands and data), the tables are the same as on the CD.
0 references