Best Embedded Database Systems for SQL

MySQL is the most widely used open-source database in the world. MySQL is the most popular open source database for web-based applications. It has been proven to be reliable, performant, and easy-to-use. This database is used by many high-profile web properties, including Facebook, Twitter and YouTube. It is also a popular choice for embedded databases, distributed by thousands ISVs and OEMs.

Apache Phoenix combines the best of both worlds to enable OLTP and operational analysis in Hadoop. This allows for low-latency Hadoop applications. HBase is used as the backing store for Apache Phoenix, which combines the power of SQL and JDBC with ACID transaction support and flexibility of late bound, schema-on read capabilities from the NoSQL realm. Apache Phoenix is fully compatible with other Hadoop tools such as Spark and Hive. It also integrates with Pig, Flume and Map Reduce. Become the trusted Hadoop data platform for OLTP, operational analytics and Hadoop via well-defined APIs. Apache Phoenix compiles your SQL query into a series HBase scans and orchestrates their running to produce regular JDBC results sets. Direct use of HBase API along with coprocessors, custom filters and other tools results in performance of milliseconds or seconds for small queries.

Companies need to find a way to guarantee the uninterrupted operation of their system, high-speed data processing, and reliable storage. In-memory technology has proven to be a good solution for these problems. Tarantool has helped companies around the world for more than 10 years build smart caches and data marts while saving server capacity. Reduce the cost of credentials storage compared to siloed solution and improve service and security for client applications. Reduce the costs of data management by consolidating a large number disparate systems for storing customer identities. Improve the quality and speed of customer recommendations by analyzing user data and behavior. Improve mobile and web channels by speeding up frontends in order to reduce user exit. IT systems in large organizations are operated within a closed network loop, where data is not protected.

The Mimer SQL codebase has the most advanced technology in the world. It is portable, modular, easy to maintain, and expandable. Mimer SQL knows how to get the most out of computers and operating systems. Our brand-new SQL compiler, with the latest optimization techniques, combined with a world class storage engine, and no limitations other than what the hardware imposes lays the foundation for speed and efficiency second to none. Mimer SQL's security features are constantly improved and refined. Algorithms that are time-tested, documented, and reliable cover data in use, data on the move, and data in rest. Mimer SQL is a perfect companion for a modern in-vehicle computing solution. Its performance and reliability meet the high demands of today's autonomous cars and connected cars for secure, flexible and reliable data management.

The ITTIA DB family of products combines time series, real time data streaming and analytics to reduce development costs and time. ITTIA DB IoT, a small embedded database designed for 32-bit microcontrollers with limited resources for real-time data streaming, and ITTIA DB SQL are high-performance embedded databases for time-series for single-core or multicore microprocessors. Both ITTIA DB product enable devices to monitor real-time data, process it, and store it. ITTIA DB also offers products for Electronic Control Units in the automotive industry. ITTIA DB's data security protocols protect data from malicious access through encryption, authentication and DB Seal. ITTIA SDL conforms to the principles of IEC/ISO 62443. ITTIA DB can be embedded in a SDK designed for edge devices to collect, enrich, and process real-time data streams. Search, filter, combine, and aggregate data at the edge.

Processing and storage of tabular datasets, e.g. CSV or Parquet files. Large result set transfer to client. Large client/server installations are required for central enterprise data warehousing. Multiple concurrent processes can be used to write to a single database. DuckDB is a relational database management software (RDBMS). It is a system to manage data stored in relational databases. A relation is basically a mathematical term for a particular table. Each table is a named collection. Each row in a table has the same number of named columns. Each column is of a particular data type. Schemas are used to store tables, and a collection can be accessed to access the entire database.