###

ROAD:BeanBox is a rich set of user interface (UI) and data access components that adhere to the JAVABeans™ API. They enable the access and data manipulation of JDBC-compliant database servers with virtually no programming. ROAD:BeanBox offers a data-cursor engine that provides developers in any IDE with lightweight, cross-platform data access and data-caching technology. ROAD:BeanBox allows developers to create high-performance database applications that work within any JDK™ 1.1 compatible VM or browser.

### Key Features

- Client-side data caches are in-memory data stores located and managed within the process space of the application. ROAD:BeanBox supports two types of data caches: Static Cursors and Batch Cursors.

> A static cursor fetches one or more rows of data and stores it on the client. Unlike the JDBC forward-only cursor, a static cursor is fully scrollable and updatable. Rows updated using static cursors are reflected immediately in the underlying table.

> In addition to providing all the features supported by static cursors, batch cursors support batch updates. Every time a new row is inserted or an old row is deleted or changed, only the client-side data cache is updated; the underlying table is not affected. Once the user has finished making changes to the data in the client-side cache, the user can commit the changes to the underlying table as a single batch operation.

| These cursors provide the following benefits:

- The number of requests for data between the client-side application components and the database server is reduced. The performance improvement is especially noticeable for data access across the Internet.
- Data is immediately available to the client-side application logic, without the application having to wait for data to travel across the network.
- Batch updates drastically reduce network traffic by committing all changes to the database as a single batch operation.

- ROAD:BeanBox includes data aware beans, such as CheckBox, ChoiceBox, ListBox, MaskText and ImageStore, that can be bound directly to a result set. Additionally, the ROAD:BeanBox data access programming model provides an extendable object interface, which can be used to enhance the user interface components to make them data aware.

- Data binding enables a user interface component, such as the TextArea object, to be bound directly to a column in an SQL result set. As the user navigates the rows, the TextArea object is automatically updated with the column's data from the current row in the result set. If the user changes the data in the TextArea object, the result set is updated automatically to reflect the changes in the data.

- The ROAD:BeanBox Application Wizard is a utility which allows the user to quickly design single, multiple row and master detail screens. The user can visually rearrange fields prior to code generation, with total flexibility in screen design. The generated code can be modified and reused.

- The ROAD:BeanBox Connection sharing capability creates and manages the database connections centrally to avoid making multiple connections to the same database. This sharing is totally transparent to the user.

- User developed beans can be made data aware by easily implementing the IDataBound interface to work with the ROAD:BeanBox DataAccessor components.

### Benefits

- Ease of use. Unlike low-level JDBC API, users no longer have to spend time learning how to write complicated programs to access and manipulate data from a database server. The development of complex database applications can be accomplished in a matter of minutes.

- Significant reduction in programming and testing time. ROAD:BeanBox components perform all SQL queries simply by setting a few properties. Since the amount of code written is significantly reduced, the amount of time spent in testing the code is also reduced dramatically.

- Significant reduction in maintenance overhead. Maintenance overhead likewise is significantly reduced because the amount of code required to build a database application is so small.

- Elimination of duplicate database connections. The ROAD:BeanBox Connection Sharing capability centrally manages database connections to minimize the usage of expensive database resources.

- Improved Performance. The backward scrolling feature of static cursors and the batch update feature of batch cursors substantially improve response time and reduce network traffic.

- Scalable and extensible platform. ROAD:BeanBox provides the user with a variety of reusable classes, which have specific functionality. All of these classes can easily be extended to incorporate individual business requirements.

| Specialized Software International, Inc. 120 Stafford Street Worcester, MA 01603 Phone: 1-800-328-2825 or 1-508-754-8566 ext.576
FAX: 1-508-754-8973
E-mail: info@BeanBox.com
Web: http://www.BeanBox.com

[ Catalog Home ]