Top Banner

LiveDB Data Server

LiveDB is designed to greatly improve application and web services access to data. Typical application access times through LiveDB are in the sub-millisecond range. 10-90 microseconds access times are common and access times remain the same even as your tables grow in size. LiveDB can serve hundreds of concurrent connections making it ideal for serving data for web services or applications. Performance like this is not available even in SQL databases that run entirely in memory. Now you no longer have to trade off write and read times and spend hours tweaking indexes to 'optimize' the database. LiveDB makes all that effort obsolete.

Advantages

LiveDB's benefits include:

  • Massive increase in concurrent users
  • Reduced latency
  • High speed write operations
  • Huge speed increases due to predictive caching, includes write-through cache management
  • Stateless operation
  • Superior Scalability
  • Reduced server workload so fewer servers needed, lower fixed costs, easier maintenance.
  • Low Cost - $200 per server instance.
  • Less coding to implement than typical SQL, resulting in lower cost product development, and simplified maintenance
  • Applications that can benefit include:
    • Data Collection and Analytical Systems
    • General Purpose Cloud Based Database Applications
    • General Purpose Intra-Net Based Database Applications
    • Data Driven Web Services
    • SAS Web Services
    • IOT Data Collection and Processing
    • Real-Time Mfg Systems Production Flow and Analysis
    • Gateway, Authentication and Financial Systems

Performance

Speed (or latency) is a real problem for major applications development but by using LiveDB you can turn a sluggish, not-very-scalable application into the quick and responsive service that your customers expect! Featuring write-through updates in memory, this tool will give you a much higher hit ratio than normal caching systems. Traditional databases (whether they do caching or not) just can't keep up. LiveDB is a complete database system that offers high-speed, highly concurrent data access.

Data is automatically returned in ordered form. This saves programming effort and further illustrates the performance benefit of this tool. There is usually no need to sort initial results before display! You can move through the data a record or a block at a time. There is typically no need to load excess data, add overhead to your application, and exacerbate client bandwidth issues. Or perhaps overload your server's bandwidth with unnecessary data requests.

Internet based solutions need speed even more because internet latency is added to every request. Having ultra fast access to data means that internet latency is largely mitigated. Internet based applications can be much more responsive and feel more like a local application.

Scalability

Major reductions in server count and system complexity are now possible. Now you can reduce the delay when accessing and writing data, reduce the costs of an extensive hardware 'work-arounds' and resulting maintenance costs), and actually simplifies the software development of your web and commerce applications. Higher performance give you a competitive edge, while decreasing fixed expenses and increasing reliability.

Greater Creativity

Now you can build applications with greater creative control and fewer tool based limitations. Be more creative and deliver high speed applications more quickly. Whether your application is browser based or an internet/LAN based stand alone application, LiveDB provides powerful options and remote monitoring capability you can leverage to build higher performance products with greater reliability and do it more quickly.

Typically data access and poor concurrency pose a serious bottleneck, limiting application performance. These deficiencies result in fewer features and/or poor performance. The need for robust performance requires us to go beyond the normal limits of 'standard' solutions and LiveDB makes that possible. By speeding up write and read operations more data can be collected and more meaningful analysis of that data becomes possible.

Many good engineers have assembled high quality applications only to discover that under load, performance becomes a real issue in spite of the fact they are using professional tools that worked well with a light load. Now you can avoid that trap.

Converting Existing Applications

Converting an existing SQL application to take advantage of LiveDB is usually a simple matter, and often results in tighter and cleaner code. By using ZAppSvr with LiveDB you can build highly sophisticated applications without typical framework constraints. Since ZAppSvr is so lightweight the learning curve is almost non-existent and you can usually convert an entire application in a short time.

What Comes With The LiveDB Package

LiveDB is a package that includes two server licenses, one for development and testing with another for deployment. Additional licenses are available. Several programs are included, they are:

  • LiveDB Core - LiveDBCore is the data engine for LiveDB and is licensed on a per instance basis.
  • LiveDB Data Converter - Import data from MySQL data dumps, or import/export with .csv files.
  • LiveDB Remote Console - This application allows you to monitor and control multiple LiveDB instances. Included is a powerful auto-code generator for creating database objects for your application, which can save hours of valuable development time.
  • ZAppStarter - This is a handy way to start/restart java applications in linux with preset delays to allow orderly application system startup.
  • ZConnLive - ZConnLive is a java library Jar that makes connecting to LiveDB easier.
  • Access to engineering help and application notes for developing applications using LiveDB.
  • 1 Year of product updates
screen image

This is a snapshot of ZCachePro in action. LiveDB performs the same on reads, and is 100x to 500x faster on write operations.
Courtesy of Mike Rich at ActionTRAK.com

Make it Happen

LiveDB solves one of the biggest challenges in web commerce today, the need for speed. Small sites with limited traffic can use existing technologies successfully but as demand grows access to data becomes a critical bottleneck. When you need to complete a search or transaction, the slow decline in performance as the database tables increase in size, can be the kiss of death to an otherwise great product or service. You lose customers... a consequence no business can afford to ignore.

If you would like to see the benefits for yourself, Watch the Demo Video In the video, a MySQL database without LiveDB is running on the left side, and LiveDB is running on the right. The requests are exactly the same for both systems. Requests are completely random throughout the database. By running several instances of the demo application you can sustain > 10,000 random requests per second. An average access cycle (includes data delivery) time of just 10us.

Give yourself and your application a critical edge! Use LiveDB.

Copyright © 2017, ZeroPoint, LLC.      Questions? Comments? Email Us.