Lava Distributed SQL

• True data distribution to client
  • Removes processing load from server
  • Reduces or eliminates contention on popular data
  • Improves client responsiveness
  • Reduces programming complexity
• High speed data access
  • Data insertion up to 20,000 rows per second
  • Row update 30,000 rows per second on distributed data
  • Data retrieval up to 30,000 rows per second from server
  • Data retrieval up to 50,000 rows per second on distributed data
• Integrated LavaStream programming language
  • Powerful and flexible programming language
  • Fastest interpreted language available
  • Compiled images automatically distributed to all online clients
  • Integrated facilities for access to other databases
  • Extensive command set provides for all programming requirments
• Easy data import from major databases
  • Fast ODBC access to all major databases (including SQL Server, Oracle, MySQL)
  • Direct import of foreign tables into Dictionary / ERD
  • Full import facilities included in LavaStream programming language
  • Auto-generated import code from dictionary tables
• Comprehensive project and programming environment
  • Project management
  • Entity-relationship dictionary designer
  • Syntax-aware editor
  • 3GL and 4GL compilers and linkers
  • 3GL debugger
  • LavaStream debugger
• Fast backup and restore
  • Client-based backup at up to 5Mb per second over LAN
  • Server-based backup at up to 20Mb per second
  • Blank database creation within 10 seconds
  • Restore at up to 26Mb per second