A Guide to SYBASE and SQL Server

David McGoveran, C. J. Date (Autoren)

Buch | Softcover

576 Seiten

1992
Addison Wesley (Verlag)
978-0-201-55710-7 (ISBN)

Infos

SQL Server is one of the leading relational database management systems on the market today. It effectively addresses the demanding requirements of distributed, on-line applications. Written by two leading database authorities, this book provides a convenient, comprehensive overview of the SYBASE relational database product line. Based on Chris Date's widely read Guide to DB2 and Guide to SQL/DS, this current text is the only volume that covers all of the key components of SYBASE and SQL Server. It is completely up to date with information on the current release as well as the forthcoming Release 5.0 of SYBASE. Emphasis throughout is on the user, with treatment of user-oriented material (such as the SQL language) being exceptionally thorough. This in-depth tutorial and reference does not assume any previous knowledge of SYBASE, though readers are assumed to have an appreciation of the overall structure, concepts, and objectives of database management systems in general. Features *Complete coverage of SQL Server, which handles all data management functions, and SQL Toolset, a complete set of tools for developing and using on-line applications.*
Detailed coverage of transaction processing. *Compatible with versions of SYBASE running on any supported platform. *Covers all of the important SYBASE advantages including: scalable high performance, server-enforced integrity and security, high application availability, open distributed DBMS, and window-based tools. 020155710XB04062001

Autor

C. J. Date is an independent author, lecturer, researcher, and consultant specializing in relational database systems, a field he helped pioneer. Among other projects, he was involved in technical planning for the IBM products SQL/DS and DB2. He is best known for his books, in particular, An Introduction to Database Systems (7th edition, Addison-Wesley, 2000), the standard text in the field, which has sold well over half a million copies worldwide. Mr. Date is widely acknowledged for his ability to explain complex technical material in a clear and understandable fashion. David McGoveran is the founding president of Alternative Technologies, a relational database consulting firm based in California. He has consulted for numerous users and virtually every major DBMS vendor, covering needs such as database design, development methodology, performance tuning, and migration and integration. He is co-author of A Guide to SYBASE and SQL Server and is best known for his ability to blend practical solutions with a technical understanding, resulting in robust and flexible systems. 020155710XAB04062001

Inhalt

I. AN OVERVIEW OF SYBASE.

SYBASE: A Relational System.
Client/Server Structure.
SQL Server Structure.
II. THE SYBASE DATABASE MANAGEMENT SYSTEM.

Basic Objects and Operators.
Data Definition.
Data Manipulation I: Retrieval Operations.
Data Manipulation II: Retrieval Operations (continued).
Data Manipulation III: Update Operations.
Data Manipulation IV: SQL Extensions.
The Catalog.
Views.
Security and Authorization.
Integrity.
Transaction Processing.
Storage Structure.
System Management.
III. THE SYBASE TOOLSET AND APPLICATIONS DEVELOPMENT.

Data Workbench.
SQL Interfaces.
Application Programming I: DB-Library and Open Client.
Application Programming II: Embedded SQL.
Application Programming III: Dynamic SQL.
APT Workbench Overview.
APT Workbench II: APT-EDIT.
APT-Workbench III: APT-SQL and APT-Library.
IV. RELATED PRODUCTS.

Secure SQL Server.
Microsoft SQL Server.
V. Distributed Processing Support.

Distribution and Fault Tolerant Services.
Open Server and Gateways.
VI. APPENDICES.

SYBASE Catalog Tables and System Procedures
Some Differences Between SYBASE and the SQL Standard
Abbreviations and Acronyms.
Bibliography.
Index. 020155710XT04062001

Produkt-Details

• Erscheint lt. Verlag: 6.7.1992
• Verlagsort: Boston
• Sprache: englisch
• Maße: 173 x 241 mm
• Gewicht: 900 g
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Themenwelt: Mathematik / Informatik ► Informatik ► Software Entwicklung
• ISBN-10: 0-201-55710-X / 020155710X
• ISBN-13: 978-0-201-55710-7 / 9780201557107
• Zustand: Neuware