Design And Build A Room Security System Based On Internet Of Things (IOT)

Workspace or home security systems required special attention, especially in the issue of locks for room security that must be unique, not easily opened by unauthorized people to enter the room. In this research, indoor security systems applied Internet of things (IoT), the use of MQTT Broker which functions as a getway for data transactions between publishers and subscribers, power supply and ESP8266. The method to building the smart doorlock was use prototype method, designed the system and design diagrams, used UML (Unified Manipulation Language), the analysing problem used the PIECES method. The use of the MQTT broker functions as a gateway to connect publishers, subscribers, power supplies and the ESP8266 wifi module which functions as a gateway between devices to the mobile. The result of this researched was prototype the smart door lock system using IoT.

PENERAPAN MODEL WATERFALL PADA SISTEM INFORMASI BEASISWA BERBASIS WEB

Kemajuan teknologi informasi yang berkembang di dunia pendidikan, membuat kampus Atma Luhur selalu ingin mengembangkan teknologi informasi termasuk dalam pemberian beasiswa. Informasi beasiswa pada kampus Atma Luhur belum banyak diketahui oleh mahasiswa dan calon mahasiswa baru. Saat ini tidak ada sistem yang terkomputerisasi untuk membantu proses pendaftaran serta pengelolaan beasiswa pada kampus Atma Luhur. Oleh karena itu dibutuhkan suatu sistem informasi beasiswa berbasis web agar mempermudah mahasiswa untuk mendapatkan informasi serta melakukan pendaftaran beasiswa sehingga setiap mahasiswa berhak untuk mendaftar dan mendapatkan beasiswa untuk membantu bagian kemahasiswaan dalam mengelola data. Untuk menunjang sistem beasiswa ini penulis menggunakan model waterfall dalam proses penganalisa sistem. Pemodelan perangkat lunak digambarkan dengan UML (Unified Manipulation Language).Hasil dari penelitian ini adalah Sistem Informasi Beasiswa berbasis web menggunakan Model waterfall dengan Metode berorientasi objek. Pengujian perangkat lunak menggunakan metode User Acceptance Test mendapatkan hasil sebesar 84%.

Extract, Transform, Load Framework for the Conversion of Health Databases to OMOP

ABSTRACTObjectiveDevelop an extract, transform, load (ETL) framework for the conversion of health databases to the Observational Medical Outcomes Partnership Common Data Model (OMOP CDM) that supports transparency of the mapping process, readability, refactoring, and maintainability.Materials and MethodsWe propose an ETL framework that is metadata-driven and generic across source datasets. The ETL framework reads mapping logic for OMOP tables from YAML files, which organize SQL snippets in key-value pairs that define the extract and transform logic to populate OMOP columns.ResultsWe developed a data manipulation language (DML) for writing the mapping logic from health datasets to OMOP, which defines mapping operations on a column-by-column basis. A core ETL pipeline converts the DML in YAML files and generates an ETL script. We provide access to our ETL framework via a web application, allowing users to upload and edit YAML files and obtain an ETL SQL script that can be used in development environments.DiscussionThe structure of the DML and the mapping operations defined in column-by-column operations maximizes readability, refactoring, and maintainability, while minimizing technical debt, and standardizes the writing of ETL operations for mapping to OMOP. Our web application allows institutions and teams to reuse the ETL pipeline by writing their own rules using our DML.ConclusionThe research community needs tools that reduce the cost and time effort needed to map datasets to OMOP. These tools must support transparency of the mapping process for mapping efforts to be reused by different institutions.

An Improved Framework for Bitmap Indexes and their Use in Data Warehouse Optimization

Compression technique is basically used to compress the size of table or reduce the storage area. Oracle already gives this feature for the table compression as well as for the index compression. when index is created on particular column of a table then it contain some space, which require some storage or disk space by this technique we can save our disk space because in industry the company have to purchase the disk space according to the size of the their data and pay according to their disk space. To utilize this disk space for useful records data rather than wasting it. In this paper used the data pump utility for the compression of Bitmap index and table. Data pump utility performed for the logical backups in database.in this paper implemented data pump for compression, to release the space and change the index pointing location. It will not release the space even after deletion of records. This is of special interest for the case to compress the bitmap index and table space along with the’S (Data Manipulation Language).

Layanan Cloud Computing untuk Mendukung Kinerja Administrasi Database Tanpa Menggunakan Perintah SQL

Penelitian ini memiliki tujuan untuk menyediakan layanan dalam bentuk aplikasi untuk melakukan kegiatan Database Manipulation Language (DML) yang diterapkan dalam bentuk cloud computing . Sebanyak tiga buah computer dimanfaatkan untuk memberikan layanan pemrosesan dan penyimpanan database tanpa menggunakan perintah yang ada pada Structure Query Language (SQL) dan satu buah computer digunakan sebagai server yang melayani pengguna untuk melakukan kegiatan DML tanpa menggunakan perintah SQL . Dengan menggunakan teknologi cloud pengelolaan database berbasis SQL yang biasanya menggunakan perintah berbasis command line dapat dilakukan dengan cara yang lebih mudah. Layanan yang diberikan oleh cloud untuk mengelola database berbasis SQL khususnya fungsi DML. Hasil dari implementasi layanan pada jaringan internet, Wireless lan, dan LAN dapat berjalan dengan baik dengan kasus pengujian fungsi pada ketiga media jaringan tersebut. Dengan demikian para pengguna yang sama sekali tidak mengerti bahasa SQL dapat menggunakan layanan ini dengan mudah untuk mengolah database SQL secara mandiri.

Fungsi Date dalam Data Manipulation Language Dengan Bahasa Query Menggunakan SQL Server 2008

Abstrak: Fungsi date dalam melakukan manipulasi data dengan bahasa query merupakan fungsi yang diperuntukkan bagi data, variable atau field yang berkaitan dengan data tanggal dan dapat pula diterapkan untuk data dari tanggal sistem komputer yang sedang aktif. Fungsi tanggal dalam SQL (Structured Query Language) meliputi fungsi DateAdd, DateIff, DatePart, DateName dan GetDate. Data Manipulation Language (DML) merupakan bahasa basis data yang berfungsi untuk melakukan penelusuran data pada suatu basis data didalam DBMS (Database Management System) diantaranya melakukan insert data, delete data, update data dan penelurusan data (query). SQL (Structured Query Language) terdiri dari sintaks sederhana dalam bentuk instruksi-instruksi dalam melakukan manipulasi data, instruksi tersebut sering disebut dengan query. Sedangkan untuk proses query merupakan kemampuan untuk melakukan penelusuran data dari basis data, data yang ditampilkan bisa dari satu atau lebih tabel, dimana kolom-kolom yang dipilih bisa kita tentukan sendiri. Pada penulisan ini akan dibahas tentang bagaimana melakukan operasi query untuk fungsi date dengan menggunakan SQL Server 2008. Langkah awal yang dilakukan adalah dengan mengambil studi kasus database Nilai Mahasiswa yang telah terbentuk diagrammnya beserta isi datanya. Selanjutnya bagaimana melakukan operasi dengan menggunakan fungsi DateAdd, DateIff, DatePart, DateName dan GetDate untuk melakukan penelusuran data dengan menggunakan DBMS SQL Server 2008. Kata Kunci: Fungsi date, DML, Query, Sql Server 2008, Nilai Mahasiswa. Abstract: The date function in manipulating data with the query language is a function that is intended for data, variables or fields relating to date data and can also be applied to data from the date of an active computer system. Date functions in SQL (Structured Query Language) include DateAdd, DateIff, DatePart, DateName and GetDate functions. Data Manipulation Language (DML) is a database language that functions to search data in a database in a DBMS (Database Management System) including inserting data, deleting data, updating data and searching data (query). SQL (Structured Query Language) consists of simple syntax in the form of instructions in manipulating data, these instructions are often called queries. As for the query process, it is the ability to search data from a database, the data displayed can be from one or more tables, where the columns we choose can be determined by us. At this writing will be discussed about how to perform a query operation for the date function using SQL Server 2008. The initial step is to take a case study of the Student Value database that has been formed diagramm along with the contents of the data. Next how to perform operations using the DateAdd, DateIff, DatePart, DateName and GetDate functions to perform data tracing using SQL Server 2008 DBMS. Keywords: Date function, DML, Query, Sql Server 2008, Student Value.

Modern Tools of Political Manipulation

The article proves that political manipulation is one of the conditions for the stable existence of political regimes and allows to control people and their consciousness. Tools and means of political manipulation are being continuously developed and improved, because they help political regimes function stably. Political manipulation is usually planned and organized, and can carry potential risks for the development of society as a whole. Political manipulators actively attract the media, which effectively distribute needed information and have the fullest impact on social consciousness. Peculiarities of political manipulation as a specific form of political influence, involve creating additional psychological levers of effective action in the process of the struggle for power. Political manipulators, with the help of various technologies of political manipulation, latently correct mass consciousness; include artificial stimulus (motivations) for action; redirect public moods and social activity in the direction they need. The author studies the current manifestations of political manipulation in the society: influence on public opinion; state authorities discredit; political advertising. To achieve success in the political struggle, the manipulator needs the support of society, which is guaranteed by the actions of mechanisms to influence public opinion. The author identifies and analyzes the following mechanisms of the means of political manipulation: language suggestion (speech influence), neuro-linguistic programming, and negative campaigning.

Protein-bound uremic toxins are associated with cognitive function among patients undergoing maintenance hemodialysis

Patients with chronic kidney disease have a greater risk of cognitive impairment. Cerebral uremic solute accumulation causes uremic encephalopathy; however, the association of protein-bound uremic toxins on cognitive function remains unclear. The present study aimed to investigate the association of two protein-bound uremic toxins, namely indoxyl sulfate (IS) and p-cresyl sulfate (PCS), on cognitive function in patients receiving hemodialysis (HD) for at least 90 days. Circulating free form IS and PCS were quantified by liquid chromatography/mass spectrometry. Mini-Mental State Examination (MMSE) and Cognitive Abilities Screening Instrument (CASI) were used to evaluate cognitive function. In total, 260 HD patients were recruited with a mean age of 58.1 ± 11.3 years, of which, 53.8% were men, 40% had diabetes, and 75.4% had hypertension. The analysis revealed that both free IS and free PCS were negatively associated with the CASI score and MMSE. After controlling for confounders, circulating free IS levels persisted to be negatively associated with MMSE scores [β = −0.62, 95% confidence interval (CI): −1.16 to −0.08] and CASI scores (β = −1.97, 95% CI: −3.78 to −0.16), mainly in the CASI domains of long-term memory, mental manipulation, language ability, and spatial construction. However, there was no correlation between free PCS and total MMSE or total CASI scores after controlling for confounders. In conclusion, circulating free form IS, but not PCS is associated with lower cognitive function test scores in HD patients. Thus, a further study is needed to evaluate whether a decrease in free IS levels can slow down cognitive decline in HD patients.