|
Support & Services
Technical Documents
Document Types
White Paper-Technical
The Next Generation Database for Embedded Systems A high level technical overview of Sybase SQL Anywhere Studio's UltraLite deployment technology for embedded systems/intelligent appliances. |
||
As prices fall and technology offerings are brought to market at break-neck speed, developers of fax machines, routers, point-of-sale terminals and other hardware devices are looking for ways to provide greater strategic value for businesses, often by embedding business intelligence features that allow the devices to interact with enterprise servers. Some examples include vending machines that can inventory their stock and adjust prices for lunchtime rushes, photocopiers that call for support when they're down, even a coffee machine that starts brewing when you turn off your alarm. In the past designers of embedded systems have coded their own data management structures from scratch. By using standard relational database and synchronization technology, these developers could add more sophistication to embedded devices to give a company more of a competitive edge. To make it easier to develop data-enabled embedded systems, Sybase is delivering an UltraLite deployment option for SQL Anywhere Studio, its leading mobile database solution. UltraLite provides a flexible, in-memory, high-performance database technology optimized for the unique requirements of embedded systems. Sybase's revolutionary analyzer technology enables engineers to easily customize the capabilities of the database to match the memory requirements of an application running on the embedded device. Plus Sybase's MobiLink server synchronization technology allows users to seamlessly synchronize data from the embedded device directly to any major enterprise database including Sybase, Oracle, and Microsoft.
A Flexible, Customizable Database
Sybase's UltraLite deployment option provides the functionality and reliability of a SQL database running on an embedded system with the ability to synchronize data with a consolidated database server. Sybase UltraLite analyzer technology enables engineers to create an application-optimized database with only the necessary: tables, columns, and indices resulting in very fast updates and retrievals.
Rich SQL Functionality
UltraLite is designed to significantly enhance productivity by leveraging industry standard SQL for data storage, retrieval, and manipulation. UltraLite
databases have enterprise power with support for referential integrity, transaction processing, bi-directional scrolling cursors, and multi-table joins of all
varieties. Engineers don't need to re-invent the wheel. UltraLite provides a proven solution for data storage, retrieval, and manipulation saving engineers from
the complexity of coding their own data management structures from scratch. All access to the database is coded through Embedded SQL (ESQL), an
industry standard interface to access a database. The analyzer technology reads the ESQL and determines the functionality of the database required to run an
application on the targeted embedded system. This preprocessed SQL code is compiled together with the application code and the necessary parts of the
database library are linked to produce one executable file to deploy to the embedded system.
The UltraLite runtime is optimized for in-memory
use and also employs algorithms and data
structures that ensure the highest level of
performance. UltraLite generates a database as
small as 50K that is maintained in persistent
memory with the full power of referential integrity,
bi-directional synchronization and more.
Bi-Directional Synchronization to
the Enterprise
The MobiLink server synchronization technology
enables remote systems to receive information
from and send information to a consolidated
enterprise database. MobiLink will enable
seamless synchronization of data directly to any
major enterprise database including Sybase,
Oracle, and Microsoft. In addition, MobiLink will
support a wide variety of wire-based and wireless
communication transports for synchronizing data
including TCP/IP.
Increased Productivity
To enhance developer productivity, Sybase UltraLite is designed to leverage industry-standard tools, skills, and components. This means that systems
engineers will have the benefit of a familiar development environment while designing UltraLite databases. UltraLite also provides high-level programming
interfaces for engineers so they need not learn system-specific aspects and disparate operating systems interfaces. Similarly, the MobiLink server
synchronization technology hides the complexity of the various transmission channels for synchronization.
Enabling Faster, Easier Development with Sybase's Developer Network
Sybase's Developer Network is designed to offer everything developers and engineers need to make building applications with SQL Anywhere faster and
easier. It provides a central point of access to technical information and services including product and technical whitepapers, monthly newsletters, evaluation
product downloads, frequently asked questions, hints and tips, sample code, beta programs, solved cases and more.
Business Programs T o Help Partners Succeed
Sybase's Business Solutions Alliance Program offers programs to help its partners achieve outstanding success in their own businesses. It offers focused
programs, pricing, and services for Embedded Computing Partners(OEMs), Independent Software Vendors (ISVs), and System Integrators (SIs). In
addition, the programs offer developer and marketing support, sales tools and much more.
UltraLite Client Platforms supported include:
UltraLiteTechnology Features:
Creating a data driven embedded system
using Sybase UltraLite database technology
can be done in three easy steps:
The UltraLite database running on the embedded system synchronizes with a consolidated server through the MobiLink synchronization server. The MobiLink synchronization server
provides an interface between the communications from the UltraLite database and the database server. The UltraLite database running on the embedded
system keeps track of changes made to the UltraLite database between each synchronization with the consolidated database. The data uploaded to the
server is automatically determined by the UltraLite runtime. The downloaded data is defined using synchronization scripts. MobiLink synchronization is
managed through scripts written in the native language of the consolidated database. The MobiLink manager allows easy administration and definition of
synchronization and conflict-resolution rules.
The MobiLink
server
synchronization
technology
enables remote
systems to
seamlessly
synchronize data
from the
UltraLite
database residing
on the embedded
system directly to
any enterprise
database
including
Sybase, Oracle
and Microsoft.
In-Memory Performance
Document Attributes
|
