ITTIA DB SQL Embedded Database

Overview

ITTIA DB SQL is an embedded relational database management system for intelligent applications on mobile devices and other embedded systems. Products built with ITTIA DB SQL are scalable, fast, and reliable because they are protected by ACID transactions.

With the ITTIA DB SQL database library embedded in an application, developers can open database files directly on the file system, connect to a stand-alone server, or even run a server within the application itself. Data is accessible through SQL queries and cursor API functions. ITTIA DB SQL manages data stored on disk or flash media, entirely in memory, or a combination of both. The file format, network protocol, and API are all cross-platform, so data can be accessed anywhere.

  • Fast: High performance insert, select, update, and delete.
  • Reliable: Automatic crash recovery and integrity checks.
  • Convenient: Pure relational model, SQL, ODBC, and ADO.NET.
  • Affordable: Minimal development time and cost.
  • Cross-Platform: Support for desired operating system and architecture.
  • Data Distribution: Replication and enterprise database synchronization.
  • No DBA: No database administrator required.
  • Quality support: Knowledgeable technical staff who care about your success.
  • Secure: AES file encryption, SSL/TLS communications, SCRAM authorization.

ITTIA DB SQL is an ideal choice for modern operating systems including Windows, Linux, Android, QNX, ThreadX, and VxWorks on variety of hardware platforms such as x86, ARM, x86_64, and PowerPC.

ITTIA DB SQL Architecture

Customer Experiences with ITTIA

"I worked with ITTIA to develop an innovative home automation device. During development, they treated us like a partner and we very much enjoyed the support they provided. I highly recommend ITTIA DB to anyone in need of a great embedded database solution." Laurent S. – Product Lead – Panasonic

"By embedding ITTIA DB into our applications, we obtained reliable data exchange between mobile devices operating on multiple platforms and the corporate back-end database. ITTIA has provided us significant support to step into the next level of our mobile solutions." Frank V. – CTO – Conges GmbH

"In the database world promises are easy, but delivery is a challenge. ITTIA is the first database organization that has supported us to complete our project on time and under budget! A very professional and trustworthy group." John S. – President – Maintenance and Test Engineering

"I enjoyed working with ITTIA. They always offered great value and could see that every business deal is much much more than 'just a deal.' ITTIA has great character." Marlan W. – Manager – Freescale

more...

Rich Features

  • Standard SQL: A truely relational database model provides developer the benefit of SQL and sub-divided elements such as clauses, expressions, predicates, queries and statements.
  • Flexible C and C++ API: Fast, flexible database API that ideal for environments with limited memory and processor resources. ITTIA DB contains a solid, extensible database kernel that is embedded directly into the application to ensure excellent performance.
  • Direct Table Access: Read and write tables directly with table cursor API functions. Use indexes to search, scan, filter, and sort rows in application-defined increments.
  • On-Disk, In-Memory, Hybrid: ITTIA DB SQL provides different storage back-ends: memory and file storage offer application developers a trade off between durability and performance. Hybrid ITTIA databases, which use a mixture of memory and disk tables, allow applications to seamlessly integrate both storage models.
  • Performance: ITTIA DB SQL empowers embedded applications through reliable and flexible data management that exhibits excellent performance characteristics under real-world workloads.
  • Small Footprint: ITTIA DB is designed for small footprint environments. Developers can reduce the size to as low as 150K, depending on features and options selected.
  • Robust Shared Access: ITTIA DB SQL supports concurrent shared access, either directly opening the same database file in multiple threads, or using a lightweight server to broker connections.
  • High Availability: Many features in ITTIA DB SQL aid application developers in building both distributed and high-availability systems, including: distributed transactions, table snapshots, synchronous commit, replication on commit, single-master replication on demand, multiple master replication on demand and online backup.
  • Synchronization: Applications embedded with ITTIA DB SQL can utilize the ITTIA DB Sync utility to reliably and synchronize data with enterprise server back-end databases such as Microsoft SQL Server, Oracle, IBM, MySQL, and more.
  • Supported Operating Systems: Developers can build applications with ITTIA DB SQL for any operating system and any 32-bit or 64-bit hardware architecture.