Product Review: PointBase Mobile Edition/Server Edition 2.0 @ JDJ

转载 2008年05月01日 06:16:00
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src=""> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </script><script type="text/javascript" src=""> </script>

  PointBase, formerly known as DataBahn and DataBean, is legendary Oracle founder Bruce Scott's latest venture. PointBase, an embedded database that's written entirely in Java, is available for a wide variety of platforms. The main advantages of embedded databases are their ultra-small size, self-management capabilities and portability. The PointBase Server Edition is designed to run on a wide variety of hosting platforms and uses a very small footprint. In fact, the Mobile Edition can reportedly consume as little as 270K of memory on the client. These types of databases are ideal for embedded systems and applications that require the services of a full object-relational database without all the associated overhead. PointBase's Mobile Edition, the smaller of the two versions, has been designed to run as part of a lightweight client application. With the Mobile Edition you can store Web data at the client level without requiring complex client-side installation routines. Typically, developers have avoided using such a technique because the complexity in synchronizing the Mobile database with a back-end database is more trouble than it's worth. PointBase's clever "unisync" capability has been designed to address this problem. Through this option you can synchronize data at both ends, making it much more practical to use a client-side Mobile database in your applications.

  PointBase allows you to manage the database directly using a JDBC-based API. Therefore, programs that interact with the data can also manage the database as part of their normal processing. Despite the fact that the Product is meant to use a small amount of real estate, it still comes with an impressive number of database features. PointBase supports both SQL-92 and SQL-99 standards as well as Java stored procedures.

  With the Server Edition you can create a complete small-footprint Web Server platform that includes both the database and an application by using Server-side Java code with PointBase.

  Installation and Configuration

  PointBase offers restricted versions of the Mobile and Server Editions that you can download free from their Web site. While they're fully functioning, they only let you create a scaled-down database limited to 5MB. The software is packaged in a zip archive format and the installation files are InstallShield Java Edition. I downloaded the PointBase Server Edition archive that contains the Server installation, the client installation kit and the documentation in Adobe PDF format. The installation process itself is incredibly simple and requires little interaction to complete. I had the Server software and the client tools installed in under 10 minutes and the Server utility running shortly after that, as shown in Figure 1.

  Working with PointBase

  The PointBase Server includes a simple but useful interface for starting and stopping the database as well as monitoring any activity. You can set different levels of messaging that allow you to watch the activities of the Server as it works. PointBase provides three separate interfaces for working with the database - PointBase Commander, PointBase Console and the JDBC APIs. Although I worked mostly with the console, the Commander utility provides a command-line-based interface that allows you to run scripts of commands against the database as necessary. This allows a developer to create batch scripts to build and populate databases without having to write a Java program or being forced to use a visual interface (which doesn't work well for batch-type processing). The PointBase Console provides an interactive interface for working with the database, as shown in Figure 2.

  PointBase's marketing literature and documentation are geared toward presenting PointBase as an embedded solution, which is evident when you work with an interactive console. Although I was able to perform most of the standard types of database operations, such as creating tables, viewing the database catalog and importing data, the utility itself is very basic. There are no frills whatsoever, and the forms tend to be sluggish at times, even while running on a fast desktop machine. End users typically wouldn't interact directly with PointBase except through programs that you provide them, so this isn't a real big issue. However, if you're somewhat new to Java and relational databases, you're going to have a tough time working with this interface. Experienced object and relational database developers will have no trouble working with the console; I easily imported some existing Oracle database scripts. The console interface provides a tool for importing data from flat files or from an existing database, and I successfully moved data between the two without difficulty.

  The real power of PointBase is its ability to manage all aspects of the database at a low level. Although the database itself is easy to maintain, there are an incredible number of parameters you can set, such as database page size and even encryption algorithms for the database pages. PointBase supports row-level locking, repeatable reads and automatic lock-escalation - quite impressive when you consider the small footprint of the database. With the programming interface you can completely handle backup and recovery within your application code.

  Data Synchronization

  One of the main features of PointBase is its ability to synchronize data between client and Server databases. PointBase uses a publish/subscribe model that allows data to be moved over a variety of protocols such as TCP/IP, HTTP, SNA, JINI, IIOP, e-mail and MAPI.

  While most database vendors provide similar capabilities for their Mobile versions, PointBase supports heterogeneous database synchronization. For example, client databases can be stored in PointBase and then synchronized with a master database that's stored in Oracle. PointBase even provides interfaces for managing the inevitable data conflicts that occur with distributed databases, as well as a sophisticated API for managing the synchronization process. If you don't have a lot of experience working with databases and Java, you might find yourself getting a little lost, as the documentation and example code that comes with PointBase tends to be a bit skimpy.


  Embedded databases will play an increasingly larger role as Web-based applications require more sophisticated client-side data storage options. Relational databases are well known and widely understood, so it makes sense to leverage this experience for lightweight clients and embedded systems. PointBase offers a very comprehensive package from an engineering team with vast experience in the development of database engines. I'd recommend evaluating PointBase if you're in the market for an embedded database.

<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src=""> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </script><script type="text/javascript" src=""> </script>

Product Review: InstallShield Java Edition 3.0 @ JDJ

  • zgqtxwd
  • zgqtxwd
  • 2008年05月01日 06:06
  • 153

The Microsoft Visual J# 2.0 Second Edition installer returned error code '4113'

解决方案:        卸载所有先前版本的 Microsoft Visual J#,然后安装 vSphere Client。该安装包含一个更新的 Microsoft Visual J# 软件...
  • minwang593
  • minwang593
  • 2013年12月26日 11:33
  • 1246

使用SVN最简洁,最快速,最有效,最上手的办法---VisualSVN Server + TortoiseSVN

VisualSVN Server  -----服务端TortoiseSVN          -----客户端 重要的是两个都是免费的(注意免费的VisualSVN Server 是Standard ...
  • idjoy
  • idjoy
  • 2010年03月15日 12:57
  • 4031

Windows Server 2003 Standard Edition安装心得

Windows Server 2003 Standard Edition序列号:C4C24-QDY9P-GQJ4F-2DB6G-PFQ9WM6RJ9-TBJH3-9DDXM-4VX9Q-K8M8M我的...
  • china2wto
  • china2wto
  • 2005年03月02日 19:03
  • 3502

MySQL Enterprise Audit

  • yumushui
  • yumushui
  • 2014年07月21日 15:33
  • 566

HOW Pro Edition 2.0 @ JDJ

  • zgqtxwd
  • zgqtxwd
  • 2008年05月01日 06:07
  • 120

AshnaMQ 2.0 Standard Edition @ JDJ

  • zgqtxwd
  • zgqtxwd
  • 2008年05月01日 06:03
  • 121

XP安装VMware-viclient提示:microsoft virtual j# 2.0 second edition 安装程序返回错误代码“4121”

在XP中安装VMware-viclient出错,提示:microsoft virtual j# 2.0 second edition 安装程序返回错误代码“4121”。这是由于VMware-vicli...
  • lophyxp
  • lophyxp
  • 2013年09月22日 17:17
  • 7876

选择 SQL Server 2005 Compact Edition 还是 SQL Server 2005 Express Edition

今天本来是在看microsoft sync service,中间不断的提到server compact版本,这才知道原来还有这么一个版本,对于开发小型的软件还是非常有帮助的,至少可以把access p...
  • lanman
  • lanman
  • 2009年03月11日 16:35
  • 1866

Windows Mobile 6《注册表优化指南》

  • xiaolei05
  • xiaolei05
  • 2011年03月06日 07:56
  • 687
您举报文章:Product Review: PointBase Mobile Edition/Server Edition 2.0 @ JDJ