Digital Edition

SYS-CON.TV
PointBase: J2EE Development with PointBase Embedded
The only database to use when you're programming in Java

Click here for more information on PointBase


Steve Jones is the managing director for engineering and support at PointBase. He is responsible for PointBase product development, which includes an innovative family of 100% Java, SQL Relational Database Management (RDBMS), and Synchronization products that are ideal for embedding in a wide range of applications. Because they are all Java, they are highly portable.

Here, he talks about the need for embedded products and what they can do.

Can you briefly describe the reason PointBase exists in the market today? Where did DataMirror see a need for this type of offering?
PointBase Embedded provides full SQL functionality for the Java developer. By being implemented in Java itself, it can be deployed along with your application, retaining all the benefits of a 100% Java solution, such as complete platform portability.

What is an embedded Java database?
It is an RDBMS that not only provides full SQL functionality, but can be embedded within, and deployed with, the application. For a Java application, the RDBMS must itself be implemented 100% in Java. Additionally, it must be designed to run without requiring a DBA. All functionality must be accessible to the program through API calls, not requiring separate utilities to be run. And it must be small enough to make it feasible to include within the application.

A few years back, object-oriented databases had also come up with an alternative to RDBMS-based data storage. That didn't last long. Why are embedded databases such a good thing?
PointBase is ANSI standard SQL so you don't have to learn a new paradigm like OODBMS. And the storage is still relational; therefore, the transformation to and from standard relational databases is straightforward.

What issues in traditional RDBMS databases do embedded Java databases address?
Complexity, difficulty in installation, overhead in administration. PointBase can, for example, quickly and painlessly create a database without all the hassles of tablespaces, etc. associated with an enterprise system.

What are the main benefits of using embedded databases?
A big one is simplifying testing, packaging, and deployment of software. Java gives you portability across a variety of OS and hardware platforms. By bundling or embedding your Java database, you can have a single offering, which can be tested, packaged and deployed. You lose that if you have a native DBMS that has different binaries for each platform.

What is the overall feature set that PointBase provides?
PointBase Embedded has a very rich SQL implementation, including views, triggers, stored procedures, integrity constraints, hash joins, SQL security and more. PointBase UniSync and DataMirror Transformation Server provide powerful capabilities to exchange data with your corporate database, enabling web services and data marts, for example.

In what way is PointBase Embedded a better option as compared to similar products?
Often times the Java database contains a cached subset from a corporate database. PointBase has the superior ability to extract this subset and remain synchronized with the database of record. PointBase Embedded is more mature. It has a more complete feature set and is much faster.

How does the product scale for enterprise applications in terms of transaction volumes, robustness, and security?
Very well. Our architects previously worked on major enterprise systems (Oracle, IBM, Sybase, Informix), so under the hood we're very advanced in locking, logging, and recovery. One of our customers does 12,000 queries a second.

Has PointBase Embedded been applied in the real world?
Can you give us some success stories?

Both BEA and Sun bundle PointBase Embedded with their application servers to demonstrate their products. They, of course, need a fully functional DBMS of the highest quality. NetNumber has developed an ENUM system, which essentially maps IP addresses to cell phones. Their application performs many thousands of address translations per second using PointBase Embedded. Leadscope switched from Oracle to PointBase for their data mining software for the drug discovery industry, achieving performance and usability benefits.

At what stage in development should Java application teams consider PointBase Embedded?
Most architects like to make the choice early in the project.

How can our readers familiarize themselves with your product?
Are there any sample/blueprint applications available?

Visit our site at www.pointbase.com. There you can read more about our products and download evaluation versions with sample applications.

If you had one message to send to the Java community that sums up why PointBase Embedded is invaluable for Java applications, what would that be?
If you are programming in Java, PointBase should be your database. To achieve all the benefits available through implementing in Java, use a Java database.

*The Standish Group CHAOS Chronicles, 2000. www.standishgroup.com


Click here for more information on PointBase

About IT Solutions Guide
IT Solutions Guide (ITSG), aimed at development and corporate managers, is a free quarterly supplement focusing on the most competitive tools, solutions, and services available in the IT and infrastructure technology world today.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1



ADS BY GOOGLE
Subscribe to the World's Most Powerful Newsletters

ADS BY GOOGLE

DX World EXPO, LLC, a Lighthouse Point, Florida-based startup trade show producer and the creator of...
SYS-CON Events announced today that Conference Guru has been named “Media Sponsor” of the 22nd Inter...
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily ...
The next XaaS is CICDaaS. Why? Because CICD saves developers a huge amount of time. CD is an especia...
Companies are harnessing data in ways we once associated with science fiction. Analysts have access ...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to ...
"Akvelon is a software development company and we also provide consultancy services to folks who are...
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native a...
In his session at 21st Cloud Expo, James Henry, Co-CEO/CTO of Calgary Scientific Inc., introduced yo...
The question before companies today is not whether to become intelligent, it’s a question of how and...
In his session at 21st Cloud Expo, Carl J. Levine, Senior Technical Evangelist for NS1, will objecti...
22nd International Cloud Expo, taking place June 5-7, 2018, at the Javits Center in New York City, N...
"Cloud Academy is an enterprise training platform for the cloud, specifically public clouds. We offe...
Agile has finally jumped the technology shark, expanding outside the software world. Enterprises are...
"MobiDev is a software development company and we do complex, custom software development for everyb...
"Codigm is based on the cloud and we are here to explore marketing opportunities in America. Our mis...
High-velocity engineering teams are applying not only continuous delivery processes, but also lesson...
"CA has been doing a lot of things in the area of DevOps. Now we have a complete set of tool sets in...
While some developers care passionately about how data centers and clouds are architected, for most,...
"NetApp is known as a data management leader but we do a lot more than just data management on-prem ...