While work in Techniques based on sharing data and computation among queries developed algorithms and systems that are shown to be effective, there is a lack of logical foundation for query processing and optimization. In this paper, we present PsiDB, a system model for processing a large number of database queries in a batch. The key idea is to generate a single query expression that returns a global relation containing all the data needed for individual queries. For that, we propose the use of a type of relational operators called $\psi -$operators in combining the individual queries into the global expression. We tackle the algebraic optimization problem in PsiDB by developing equivalence rules to transform concurrent queries with the purpose of revealing query optimization opportunities. Experiments conducted on an early prototype of PsiDB show a major performance improvement over a mainstream commercial DBMS.

/pdf/psidb-a-framework-for-batched-query-processing-and-1k6i3bi3vm.pdf

PsiDB: A Framework for Batched Query Processing and Optimization

Assessment of lecturers is a tool used to measure lecturer performance. Lecturer's assessment variable can be measured from three aspects : teaching activities, research and community service. Broad aspect to measure the performance of lecturers requires a special framework, so that the system can be developed in a sustainable manner. Issues of this research is to create a API web service data tool, so the lecturer assessment system can be developed in various frameworks. The research was developed with web service and php programming language with the output of json extension data. The conclusion of this research is API web service data application can be developed using several platforms such as web, mobile application

https://iopscience.iop.org/article/10.1088/1742-6596/953/1/012069/pdf

API REST Web service and backend system Of Lecturer’s Assessment Information System on Politeknik Negeri Bali

Attendance system is a system that is used to track the attendance of a particular person and it is applied in many institutions. However, many systems for taking attendance has drawbacks, such as the traditional way has drawback in the data of the attendance that the list is hard to reuse, a biometric attendance system has drawback of the existence of human error such as fingerprint scans are not acceptable, due to the condition of a wet finger, dirty, too dry or peeling fingertips. In this paper, we propose mobile attendance system with NFC and face authorization to add security feature using Raspberry Pi and afford possibility to store the data in cloud. This paper first review the related works in the field of attendance management, NFC, face authorization, microcomputer and cloud storage. Then, it introduces our methodology and design system structure and plan. The result of this research is the system that reduce the amount of paper usage, eliminate the time and effort wasted in taking attendances by Mobile-based attendance system.

NFC Based Mobile Attendence System with Facial Authorization on Raspberry Pi and Cloud Server

With the onset of the fourth industrial revolution (industry 40), IIoT (Industrial Internet of Things) connectivity has greatly evolved, making a significant impact in a Smart Factory This implies the ability of having interconnected sensors and devices, crucial in supporting such industry 40 developments and applications However, different vendors, protocols and technologies hinder the development as it requires arguably specific skillsets and their implementation is not straightforward, requiring a high level of training and specific knowledge that may not be available all the time This could potentially prevent or slow down the adoption of smart factory technologies in the current manufacturing industry In this paper, we introduce a unified IIoT cloud platform to solve interoperability problems, by using Service-Oriented Architecture (SOA) within a cloud platform Our solution tries to bridge some of the gaps in implementing connectivity technologies in a smart factory context The proposed solution is implemented as a configurable edge connector to stream telemetry data meant to be used for new IIoT projects, without the need to develop new platforms from scratch A multi-platform analytic dashboard is included for different project needs The platform serves to achieve “True IIoT” by being able to provide sensor data beyond the corporate firewall securely in the cloud, supporting the digital transformation of the factory

Unified IIoT Cloud Platform for Smart Factory

Due to the complexity of the modern world, parents are busy with their office work and might not have enough time to focus on their children's education Furthermore, small children might get bored or easily lose their concentration in education due to traditional teaching methods The purpose of this research paper is to propose and implement an interactive educational tool for child based education This research examines the possibility of using a voice and gesture based gamification approach to make educational activities more interesting to the child A variety of educational activities have been designed in the form of games to cover fundamental learning contents of primary education such as basic mathematics, spelling and pronunciation An initial testing has been carried out to verify the accuracy of core functional modules including gesture recognition and voice command detection, which provided an overall accuracy rate of 84% for the gesture recognition module

HomeSchool: An interactive educational tool for child education

The enormous amount of data flow has made Relation Database Management System the most important and popular tools for persistence of data. While open-source RDBMS systems are not as widely used as proprietary systems like Oracle DB or SQL Server, but over the years, systems like MySQL have gained massive popularity. In a stereotypical view, SQL Server is considered to be an enterprise-level tool, MySQL has carved a niche as a backend for website development. This paper is an attempt to set a benchmark in comparing the performance of MySQL against SQL Server in Windows Environment. To test and evaluate the performance the Resort Management System named Repose is considered. The result shows that SQL Server is still a significantly better performer when compared to MySQL.

/pdf/comparative-performance-analysis-of-mysql-and-sql-server-2m7skf67tn.pdf

Dhondup Dolma

Papers

Comparative Performance Analysis of MySQL and SQL Server Relational Database Management Systems in Windows Environment