Whitepapers

High-Throughput Databases Using SQL Anywhere - In high-throughput systems, the database schema consists of many types of tables, ranging from configuration data, user data, and tables that store the high-throughput data.  These tables usually track rapidly changing information over time, such as statistics, usage measurements, and changing conditions.  Examples include temperature changes from a few thousand sensors, fluid flow information on a cas pipeline, or network traffic statistics.  This paper concentrates on data throughput for inserts and deletes, and examines how to get the most out of the SQL Anywhere database server.  I ocus on database design and tuning the database server with respect to these high-throughput tables.    

Download Paper     Download Presentation

A Java Database Framework for SQL Anywhere - There is nothing more detrimental to database performance than a team of Java programmers armed with a stack of requirements, a database, and a rudimentary knowledge of JDBC.  This paper presents a database framework that provides a layer of abstraction over the database to assist in taming the team of java developers.  It covers connection pooling, wrapping jdbc classes, performance monitoring, and resource tracking.

Download Paper    Download Presentation

.