Possibilities of BLOB (Binary Large OBject) and CLOB (Character Large Object) Integration Into the Core of IoT and Using the SQL Platform for Distributing a Large Amount of Data to HTML, JAVA, and PHP Platforms

Abstract

This chapter identifies and describes the key concepts and techniques for BLOB and CLOB integration into the IoT core. Data system centralization has sped up the solution of problems with large amounts of data storage and processing, particularly if the data is large by its nature. In that sense, everyday stream of photos, audio and video content, large textual data files led to new concepts BLOB and CLOB. Adequate examples of stored procedures, views, C#, JAVA, HTML5 i PHP languages, follow the establishing communication methods. Finally, the chapter will illustrate two practical examples of IoT: the example for pagination on a large database with million BLOB and CLOB objects, and the example for dynamic mechatronic system of a fire truck with feedback.