SQL Anywhere Studio 9 Development Guide (Includes Disc)

Author: (CA) Carter iAnywhere Documentation Group
Publisher:
Publish Date: 2006-01-01
Features: Breck Carter's work is an excellent reference for every application developer using SQL Anywhere Studio. The book contains Mr. Carter's rich experience and profound insights into SQL Anywhere Studio, along with explanations, usage tips, and code examples based on this foundation. It serves as an ideal supplementary material for SQL Anywhere Studio documentation. —David Jonker, SQL Anywhere Studio Product Manager, iAnywhere Solutions
Sybase database products have been widely used in key industries in our country, including finance, telecommunications, energy and transportation, retail and manufacturing. In recent years, Sybase has achieved rapid development in the mobile database field, giving us even greater confidence in the future prospects of Sybase database solutions. Currently, there is a lack of books on Sybase database development in China. However, this book is clearly positioned, with professional and detailed content, making it well-suited to meet the learning and work needs of Sybase database developers. —Editorial Department of "Programmer"
The "SQL Anywhere Studio 9 Development Guide" focuses on describing how to manage and program SQL Anywhere, a relational database that dominates mobile, distributed, and embedded applications. This book highlights the execution of various tasks throughout the typical database lifecycle, such as creating tables and other schema objects, as well as insert, select, update, and delete operations. Additionally, it discusses how to integrate SQL code in procedures, triggers, and events; use Mobilink for data distribution across multiple databases; implement disaster recovery for data; and perform regulatory adjustments.
Key Features:
- Creating and normalizing tables using various data types and constraints
- Inserting and managing data
- Querying data with SELECT statements
- Synchronizing data with MobiLink
- Protecting data using logs, backups, and data validity
- Optimizing databases with SQL Anywhere performance tuning tools: request-level logging, Index Consultant, Execution Profiler, and Graphical Plan
The "SQL Anywhere Studio 9 Development Guide" provides a detailed introduction to database development methods based on SQL Anywhere Studio. Organized in ten chapters, it follows the order of tasks executed in the typical database lifecycle, covering creation, insertion, querying, updating, deletion, reading, synchronization, packaging, protection, and optimization, with numerous examples. The book is rich in content and serves as a valuable learning and reference resource for database professionals.