EEJournal

industry news
Subscribe Now
January 12, 2012

Synchronize Android Embedded Data with Microsoft® SQL Server

January 11, 2012 — Bellevue, WA — Android application developers of intelligent devices, embedded systems and mobile devices are now able to share and communicate data stored in ITTIA DB SQL with a back-end Microsoft® SQL Server with just a few mouse clicks. This feature is made possible by ITTIA DB Sync, and allows developers not only to distribute mobile and embedded data between Android devices and Microsoft® SQL Server, but also to benefit from the replication environment necessary for improvement of data availability, reliability, modularity, mobility and interoperability.

The Synchronization Advantage

ITTIA DB Synch provides a bridge to back-end RDBMS servers for applications running ITTIA DB SQL on mobile devices and other embedded systems. When synchronization is enabled, shadow tables are added to the back-end database so that changes can be shared incrementally with the devices.

The advantage of this synchronization technology lies in the fact that in most distributed applications, only part of the data in a back-end RDBMS should be shared with each device. For this reason, ITTIA DB Sync can limit which rows are sent to each device using a device ID, group ID, or custom query. This flexibility allows applications to reduce overhead, protect access to data, and prevent conflicts. Conflicts are automatically detected whenever a shared row is modified both in the back-end and on the device, and can be resolved either through simple rules or custom stored procedures.

The Replication Advantage

ITTIA DB SQL’s built-in replication logging allows devices to record transaction history and exchange data bi-directionally between devices and the back-end. Every distributed application has different requirements for the distribution of data. ITTIA DB’s synchronous replication feature ensures that the distributed database as a whole adheres to the ACID properties while the asynchronous replication relaxes the ACID properties, allowing the data to be inconsistent between sites at certain times.

ITTIA DB SQL supports two-phase commit, which allows applications to perform distributed transactions over two or more ITTIA DB SQL database sites. In addition, ITTIA DB’s table snapshot protocol enables embedded and device developers to optimize network traffic by identifying and sending only modified rows. With this approach, even large tables can be updated without sending the full contents of the table over the network.

When replication is done between two ITTIA DB instances, conflicts are detected using either row comparison or STAMP columns. ITTIA DB supports policy-based conflict resolution and provides the replication environment needed to improve system availability using distributed commits or synchronous replication across multiple sites.

A free copy of ITTIA DB SQL is available for evaluation at:

http://www.ittia.com/products/evaluation

About ITTIA

ITTIA provides software and services for data management, offering standards, ease of use, and flexibility to our customers. Benefits of selecting ITTIA’s technologies include leading-edge software, comprehensive documentation, scalability, efficiency, exceptional performance, and low total cost of ownership. Learn how customers such as Freescale Semiconductor, Panasonic, Puget Sound Energy, Fresenius, Boeing, and others have valued from ITTIA by visiting:www.ittia.com

Leave a Reply

featured blogs
How Synopsys IP and TSMC’s N12e Process are Driving AIoT
May 8, 2024
Learn how artificial intelligence of things (AIoT) applications at the edge rely on TSMC's N12e manufacturing processes and specialized semiconductor IP.The post How Synopsys IP and TSMC’s N12e Process are Driving AIoT appeared first on Chip Design....
More from Synopsys...
Captivating Component Art
May 2, 2024
I'm envisioning what one of these pieces would look like on the wall of my office. It would look awesome!...
More from Max's Cool Beans...

featured video

Introducing Altera® Agilex 5 FPGAs and SoCs

Sponsored by Intel

Learn about the Altera Agilex 5 FPGA Family for tomorrow’s edge intelligent applications.

To learn more about Agilex 5 visit: Agilex™ 5 FPGA and SoC FPGA Product Overview

featured paper

Altera® FPGAs and SoCs with FPGA AI Suite and OpenVINO™ Toolkit Drive Embedded/Edge AI/Machine Learning Applications

Sponsored by Intel

Describes the emerging use cases of FPGA-based AI inference in edge and custom AI applications, and software and hardware solutions for edge FPGA AI.

Click here to read more

featured chalk talk

Accessing AWS IoT Services Securely over LTE-M
Sponsored by Mouser Electronics and AWS and SparkFun Electronics and u-blox
Developing a connected IoT design from scratch can be a complicated endeavor. In this episode of Chalk Talk, Amelia Dalton, Harald Kröll from u-blox, Lucio Di Jasio from AWS, and Rob Reynolds from SparkFun Electronics examine the details of the AWS IoT ExpressLink SARA-R5 starter kit. They explore the common IoT development design challenges that AWS IoT ExpressLink SARA-R5 starter kit is looking to solve and how you can get started using this kit in your next connected IoT design.
Click here for more information about the u-blox SARA-R510AWS LTE-M AWS IoT ExpressLink Module
Oct 26, 2023
25,886 views