Explore chapters and articles related to this topic
Data Storage
Published in Chandrasekar Vuppalapati, Building Enterprise IoT Applications, 2019
SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. The relational databases, generally, have a server process that provides callable interfaces to host or client application over the network (TCP/IP) and does not allow writing to the database directly. SQLite architecture is different from that of the traditional relational databases in that SQLite allows the process to write to SQLite directly on the file.
Database querying using SQL
Published in Benjamin S. Baumer, Daniel T. Kaplan, Nicholas J. Horton, Texts in Statistical Science, 2017
Benjamin S. Baumer, Daniel T. Kaplan, Nicholas J. Horton
SQLite: a lightweight, open-source version of SQL that has recently become the most widely used implementation of SQL, in part due to its being embedded in Android, the world’s most popular mobile operating system. SQLite is an excellent choice for relatively simple applications—like storing data associated with a particular mobile app—but has neither the features nor the scalability for persistent, multi-user, multi-purpose applications.
Mobility Solution Architecture
Published in Jithesh Sathyan, Anoop Narayanan, Navin Narayan, K V Shibu, A Comprehensive Guide to Enterprise Mobility, 2016
Jithesh Sathyan, Anoop Narayanan, Navin Narayan, K V Shibu
The appropriate mobile database selection is also a key activity in thick-application development. The following are some of the popular mobile databases: DB4: It offers a very lightweight database management system with a footprint that is less than 500 KB. Although concurrency is handled in mobile db4, it needs to be noted that this database management system is not relational. Moreover, support for procedures is not available, although triggers can be defined. DB4 also supports encryption and is a preferred option for basic database management requirements. SQLite: Mobile SQLite offers an even lesser footprint compared with DB4. SQLite is a relational database management system. It supports concurrency and offers the capability to write database procedures and triggers. It also supports encryption, and its source code is available on the public domain. SQLite is the most widely used mobile database solution for mobile applications.Oracle Lite: This is a lightweight database solution from Oracle for mobile applications. Being a commercial product, it is rich in features. It offers support for encryption, replication, procedures, triggers, and concurrency. Its mobile server component provides secure, bidirectional data synchronization ability.SQL Server Compact Edition: This is an embedded database engine from Microsoft. The footprint of this solution is approximately 2—3 MB. It offers a robust relational database management solution for development of application intended to run on Windows handsets.SQL Anywhere: This is a mobile and embedded database management solution from Sybase. It is a relational database management solution. The database engine supports stored procedures, triggers, and encryption. Interface support is offered for open database connectivity, Java database connectivity (JDBC), and ActiveX Data Objects.
Air quality monitoring platform with multiple data source support
Published in Energy Sources, Part A: Recovery, Utilization, and Environmental Effects, 2021
Dessislava Petrova-Antonova, Jelyazko Jelyazkov, Irena Pavlova
The architecture of the platform consists of 5 layers as follows: Data storage layer – stores data in SQLite database. Since the SQLite does not require separate server process and related configuration, it is used as an embedded SQL database engine. Thus, minimal requirements to the deployment environment are achieved.Object Relational Mapping (ORM) layer – provides a level of abstraction between the database and the business layer. Thus, the database could be easily replaced. The mapping is implemented by a Hibernate ORP provider.Business layer – processes data collected from the external APIs and provides data to the services called by the client’s interface.Interface layer – implements services for communication with the external APIs and client’s interface.External APIs layer – delivers data from different sources, which the platform aggregates.Client’s interface layer – implements the user interface for interaction with the platform.