Best Embedded Database Systems in Canada - Page 2

Processing and storing tabular datasets, e.g. from CSV or Parquet files. Large result set transfer to client. Large client/server installations for centralized enterprise data warehousing. Writing to a single database from multiple concurrent processes. DuckDB is a relational database management system (RDBMS). That means it is a system for managing data stored in relations. A relation is essentially a mathematical term for a table. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific data type. Tables themselves are stored inside schemas, and a collection of schemas constitutes the entire database that you can access.

solidDB is known worldwide for delivering data with extreme speed. There are millions of deployments of solidDB in telecommunications networks, enterprise applications, and embedded software & systems. Market leaders such as Cisco, HP, Alcatel, Nokia and Siemens rely on it for their mission-critical applications. By keeping critical data in memory, rather than on disk, solidDB can perform significantly faster than conventional databases. It helps applications achieve throughput of hundreds of thousands to millions of transactions per second with response times measured in microseconds. Beyond game-changing performance, solidDB also provides built-in data availability features that help sustain uptime, prevent data loss and accelerate recovery. Additionally, solidDB supports administrators with the flexibility to tailor the software to precise application needs and features designed to simplify deployment and administration, helping drive down the total cost of ownership (TCO).

POS system brings the most advanced technology available in a full-featured suite of applications for retailers and distributors. The OneStep-JV™ Point of Sale system combines the power and flexibility of Java and Oracle. Written in Java with Oracle as the embedded database at its foundation, OneStep-JV™ point of sale systems bring the most advanced and reliable technology and inventory management software available to achieve operational stability and cross-platform portability for retailers and distributors. The use of Java enables the operation of OneStep-JV™ POS systems on single-user computers, small and very large-scale networks and portable devices like Palm Tops running over a multitude of operating systems such as Windows and Windows Networks, Novell, Unix and Linux. The stability of Oracle gives OneStep-JV™ POS systems a resilient database foundation designed with auto-recovery features to enable database and inventory control software integrity.

HSQLDB (HyperSQL DataBase) is the leading SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools. HSQLDB supports the widest range of SQL Standard features seen in any open source database engine: SQL:2016 core language features and an extensive list of SQL:2016 optional features. It supports full Advanced ANSI-92 SQL with only two exceptions. Many extensions to the Standard, including syntax compatibility modes and features of other popular database engines, are also supported.

OrientDB is the world’s fastest graph database. Period. An independent benchmark study by IBM and the Tokyo Institute of Technology showed that OrientDB is 10x faster than Neo4j on graph operations among all the workloads. Drive competitive advantage and accelerate innovation with new revenue streams.

Ultrafast, scalable, embeddable SQL database with commercial-grade data security, disaster recovery, and change synchronization. Cross-platform, zero-install, embedded database as a direct-access library. Cross-platform, zero-install, embedded database with database-level and column-level AES and DES encryption. Concurrent applications/client access to the database on Windows with database-level and column-level AES and DES encryption. Ultrafast, scalable, SQL server database for Windows and Linux with commercial-grade data security, disaster recovery and change synchronization. Attacks on databases and loss of data can be costly and lead to loss of customers’ trust (and business), regulatory action, and heavy fines. InterBase provides over-the-wire and at-rest encryption, separate security login, and role-based user security. InterBase maintains full on-disk encryption while adding negligible overhead to database speed and performance.

RocksDB uses a log structured database engine, written entirely in C++, for maximum performance. Keys and values are just arbitrarily-sized byte streams. RocksDB is optimized for fast, low latency storage such as flash drives and high-speed disk drives. RocksDB exploits the full potential of high read/write rates offered by flash or RAM. RocksDB provides basic operations such as opening and closing a database, reading and writing to more advanced operations such as merging and compaction filters. RocksDB is adaptable to different workloads. From database storage engines such as MyRocks to application data caching to embedded workloads, RocksDB can be used for a variety of data needs.

Welcome to H2, the Java SQL database. In embedded mode, an application opens a database from within the same JVM using JDBC. This is the fastest and easiest connection mode. The disadvantage is that a database may only be open in one virtual machine (and class loader) at any time. As in all modes, both persistent and in-memory databases are supported. There is no limit on the number of database open concurrently, or on the number of open connections. The mixed mode is a combination of the embedded and the server mode. The first application that connects to a database does that in embedded mode, but also starts a server so that other applications (running in different processes or virtual machines) can concurrently access the same data. The local connections are as fast as if the database is used in just the embedded mode, while the remote connections are a bit slower.

Empress Embedded Database engine is the heartbeat of EMPRESS RDBMS, a relational database management system specializing in embedded database technology – from car navigation systems to mission critical military command and control, from Internet routers to complex medical systems, EMPRESS beats steadily, 24/7 at the core of embedded systems applications everywhere. Empress kernel level mr API is a unique feature of Empress that gives users access to the Embedded Database kernel libraries. This Empress API provides the fastest means of accessing Empress databases. MR Routines give the developer maximum control over time and space in developing real-time embedded database applications. Empress ODBC and JDBC APIs applications to access Empress databases in both standalone and client/server mode. Empress ODBC and JDBC APIs enable many 3rd party ODBC and JDBC capable software packages to access a local Empress database or via Empress Connectivity Server.