Implementation Of Database System Research Articles

WEBSITE SISTEM PEMESANAN JASA FOTOGRAFI BERBASIS WEB PADA BUNGLON FOTOGRAFI

Information technology and the internet are currently experiencing very rapid development along with the growing human needs. One application that uses the internet is a website, with website mediation, communication and information can be presented quickly and precisely. With the availability of the internet that can be accessed by everyone, business entities that want to be widely known by the public need to create a website. Bunglon Photography is a business entity that is engaged in providing photo and video shooting services. Bunglon Photography requires an information system that can expand the dissemination of information about its photography services. Making this application is done by collecting data, system analysis, system and database design, system implementation and system testing. The program is made web-based using the wampserver server and MySQL database.

LoRa sensor database in offline scenario

One of the key success factors in implementing sensor towards internet of thing is database accessibility. Integrating data will be easier to run as the adequacy of internet connection. However, in the case of isolated area, need to consider a database system which able to perform data store and processing. This paper presents an implementation of Database system in the Local Network within Long-Range radio communication

РОЗРОБКА ТА РЕАЛІЗАЦІЯ МОБІЛЬНОГО ДОДАТКА ОРГАНІЗАЦІЇ ДИСТАНЦІЙНОГО НАВЧАННЯ

Зміни, що відбуваються останнім часом у сфері вищої професійної освіти, пов'язані з пандемією, призводять до необхідності застосування нових методів і форм роботи зі студентами. У даній статті мова йде про застосування дистанційного навчання при організації самостійної роботи з навчальним матеріалом. Дана робота присвячена особливостям дистанційного навчання в цілому. Пояснюється необхідність застосування дистанційних освітніх технологій в сучасному навчальному процесі, а також розкриваються переваги і недоліки такого навчання. Особлива увага приділяється практичним питанням дистанційного навчання, описуються форми і пропонуються ідеї щодо його застосування. На даному етапі головною проблемою являється відсутність єдиної уніфікованої електронної платформи для навчання. Адже в процесі дистанційного навчання викладач може використовувати різноманітні онлайн-сервіси, які він опанував. Візуально привабливий інтерфейс сприяє створенню позитивного враження від процесу взаємодії користувача з сайтом і, як наслідок, формує у учня позитивне ставлення до навчання. У роботі розроблено та реалізовано системи бази даних дистанційного навчання з двома рівнями доступу: «вчитель» та «учень», яку в подальшому можна розвивати, удосконалювати та згодом використовувати для організації освітніх процесів у закладах вищої освіти. Розроблений додаток являє собою програмний продукт, який написаний мовою програмування PHP 7-ої версії. В ході дослідження були проаналізовані сутність поняття системи дистанційної освіти, її структура, засоби і способи реалізації. Використаний в процесі розробки мобільного додатка об'єктно-орієнтований підхід, дозволяє здійснювати подальшу модернізацію системи. Слід зазначити, що створена платформа для дистанційного навчання є початковим етапом по впровадженню сучасних інформаційних технологій в процеси навчання. При подальшій роботі необхідно враховувати конкретні освітні вимоги закладу вищої освіти. В майбутньому вона може стати потужним інструментом з надання електронної підтримки навчання студентів.

RESEARCH ON MODERN FORENSIC METHODS OF DETECTION, RECORD, SEIZURE OF SHOEPRINTS AND THEIR FURTHER ACCOUNTING FOR CRIME DETECTION

Shoe prints that have been traced by crime scene investigators at the crime scene can provide information relating to a criminal or a group of criminals that have committed it, and serve as evidence while pre-trial investigation. Furthermore, shoe prints provide information on the possible participation of the same person in different types of crimes (to integrate crimes).
 At present, the number of crimes related to stealing civilian properties, including robbery, has significantly increased as a result of economic crisis in many countries around the world.
 As the studies and the practical experience while investigating crime scenes by police in many countries show, footwear evidence as much as physical evidence have not been given due attention.
 In order to improve the quality of crime scene examination when seizing traces of shoes, the quality of removed traces of shoes, and, as a consequence, increase the efficiency of crime detection using traces of shoes, there is a necessity in:
 
 Introduction of modern forensic tools and methods for detecting, seizing traces of shoes, and further comparative research.
 Establishment of the Unified National Automated System at the legislative level for accounting and identification of shoeprints seized from unsolved crime sites.
 Creating professional forums to share experiences with leading international forensic experts.
 Establishing the terms for traces and shoeprints storage and use registered (for example, not more than two years from the date of registration) at the legislative level.
 
 In addition, implementation and development of automatic database systems with the ability to conduct identification between shoeprints evidence seized from different crime scenes can provide the investigator with significant information on the possible involvement of the same person in commission of different crimes (to combine crimes), conduct so-called forensic intelligence.
 A shoeprint as a single piece of evidence may not be weighty enough but combined with additional evidence it is vital for detecting and investigating a crime.
 In conclusion, it should be noted that this area has great prospects for development and, undoubtedly, should be addressed by forensic experts in this field.

Design and Implementation of a Multi-Disaster Risk Assessment Database System in South Korea

To cope with natural disasters and their impact, various types of risk assessment tools have been developed to assess hazards from a scientific point of view as well as the socioeconomic impacts of a hazardous event. Because most of the assessment tools have been developed using local and regional characteristics, there are limitations when applying special cases consisting of various disaster-related datasets in Korea. In this paper, we collected open data scattered among various institutions and guaranteed data interoperability through a standardization process considering various formats. In addition, this study presents a scalable design method and implementation of a database system which can be easily employed in Korean loss estimation due to natural hazards. The proposed database system will be of great help in predicting the disaster scale and degree of damage, in supporting decision-making to minimize damage, and could serve as a data platform of disaster risk reduction and prevention.

IMPLEMENTASI DAN PENGUJIAN KINERJA ORACLE 10g REAL APLICATION CLUSTER (RAC) PADA SISTEM OPERASI SUN SOLARIS 10

During the implementation of database system, needs of getting fast, accurate and highavailabilitydata, has become major clauses for the implementation of “high-availability” system.Oracle 10g RAC is a clustered database solution that requires a two or more node hardwareconfiguration capable of working together under a clustered operating system. A clusteredhardware solution is managed by cluster management software, usually provided by the hardwarevendor. The operating system is also responsible for providing access to the shared disksubsystems. Parameters that used for the performance testing and analyzing of Oracle 10g RealApplication Cluster are the cpu idle, free memory, SGA, buffer cache, and shared pool. As result forthe performance testing and analyzing, it can be concluded that Oracle 10g Real ApplicationCluster was really good for the implementation of “high-availability system” concept. But it alldepends to the analysis for its system.

A Conceptual Framework of Information Security Database Audit and Assessment

Today, databases are on of the most important things in the IT world and it is also becoming more and more popular and organizations globally are gradually moving their traditional IT setup to database model to gain the benefits of securing the data and in terms of providing easy access to, and elasticity of IT services. With database security, the IT service roles within an organization become integrated hence giving the overall IT operating model a more structured layout. Such objectivity however can only be materialized when proper planning and execution are put in place. As such, a proper execution and implementation of database system would include a stringent set of checks and audit processes. The goal of database auditing is central towards determining if the services engaged and its―maintainers are meeting certain legal requirements in terms of protecting customers data and organization standards to achieve secure data assets success against various security threats. Therefore, this project explores the factors influencing security audit quality by collecting data using structured group discussion.

FineLine

Recovery is an intricate aspect of transaction processing architectures. In its traditional implementation, recovery requires the management of two persistent data stores---a write-ahead log and a materialized database---which must be carefully orchestrated to maintain transactional consistency. Furthermore, the design and implementation of recovery algorithms have deep ramifications into almost every component of the internal system architecture, from concurrency control to buffer management and access path implementation. Such complexity not only incurs high costs for development, testing, and training, but also unavoidably affects system performance, introducing overheads and limiting scalability. This paper proposes a novel approach for transactional storage and recovery called FineLine. It simplifies the implementation of transactional database systems by eliminating the log-database duality and maintaining all persistent data in a single, log-structured data structure. This approach not only provides more efficient recovery with less overhead, but also decouples the management of persistent data from in-memory access paths. As such, it blurs the lines that separate in-memory from disk-based database systems, providing the efficiency of the former with the reliability of the latter.

FineLine

Recovery is an intricate aspect of transaction processing architectures. In its traditional implementation, recovery requires the management of two persistent data stores---a write-ahead log and a materialized database---which must be carefully orchestrated to maintain transactional consistency. Furthermore, the design and implementation of recovery algorithms have deep ramifications into almost every component of the internal system architecture, from concurrency control to buffer management and access path implementation. Such complexity not only incurs high costs for development, testing, and training, but also unavoidably affects system performance, introducing overheads and limiting scalability.This paper proposes a novel approach for transactional storage and recovery called FineLine. It simplifies the implementation of transactional database systems by eliminating the log-database duality and maintaining all persistent data in a single, log-structured data structure. This approach not only provides more efficient recovery with less overhead, but also decouples the management of persistent data from in-memory access paths. As such, it blurs the lines that separate in-memory from disk-based database systems, providing the efficiency of the former with the reliability of the latter.

Information system for selection of conditions and equipment for the cultivation of mammalian cells

The use of mammals cells and their products wide application, so the actual problem is a creation of an information system in the field of their cultivation for the organizing and structuring of information on process experimental data. This work is devoted the analysis of mammalian cell cultivation. The main technologies of cell cultivation, necessary equipment and matrices are considered. The main stages of database design and information system is described. The justification of software products are provided and the results of the database and information system implementation are done. The detailed description of all modules of the system, as well as a comparative analysis of the results of the search are in the system to verify correct operation of the system. The scientific and practical significance of the work lies in the fact that the effective tool for presenting knowledge and data for search by specific parameters is required. The convenience of the system is that it is not necessary to address in various data sources to get and conditions of cultivation of mammalian cells, it has already been collected and structured according to parameters. With help of the system, it is possible to select conditions for the cultivation of mammalian cells at the stage of scientific researches that will significantly reduce the time and cost of work, also to rank of recommended technological and hardware solutions. The system has a functional completeness, i.e. in a specific subject area, it ensures the fulfillment of user's requirements, and allows to accumulate and process information.

Special Issue on Programming Languages for Big Data Editorial

Ideas from programming languages play an important role in a range of advanced applications of databases, in database system implementation, distributed programming (MapReduce), streaming computation, and high-performance (GPU/multicore) computation. This creative research area is broadening into a subfield of data-centric computation. Although the interaction of databases and programming has a long history (the 16th biennial Database Programming Languages symposium was held in 2017), there has been a recent renewal of interest and broadening of programming language techniques for dealing with data from several quarters in the last few years, including workshops at Microsoft Research (RADICAL 2010), ICFP (XLDI 2012), POPL (DDFP 2013, DCM 2014) and a Dagstuhl Seminar on Programming Languages for Big Data (December 2014). This special issue recognises and encourages the publication of mature research contributions in this area.

Building Scalable and Resilient Database System to Mitigate Disaster and Performance Risks

This research is conducted to design database system implementation strategy that combines both backup management and performance management perspective. The backup management should address business continuity aspect and the performance management should consider its scalability factor. Methodology used is literature reviews and field studies. Result of this research is a multi-region availability database system architecture that is able to address 3 issue areas, namely regular backup, disaster recovery and performance by leveraging recent built-in database system feature. Integration of both management perspectives act as an enablement to combine cost incurred by both so that better efficiency of cost can be expected.

Створення та впровадження системи електронної бази даних і маркування для ідентифікації та отримання інформації про види рослин у ботанічних садах, дендрологічних парках та парках-пам’ятках садовопаркового мистецтва

Роботу виконано в рамках науково-технічного проекту «Створення та впровадження системи електронної бази даних і маркування для ідентифікації та отримання інформації по видах рослин у ботанічних садах, дендрологічних парках та парках-пам'ятках садово-паркового мистецтва» (Розпорядження Президії НАН України від 31.03.2016 р. № 197) в 2016 році.

The Development and Implementation of a Loan Classification Database System

The Development and Implementation of a Loan Classification Database System

IMPLEMENTASI DAN PENGUJIAN KINERJA ORACLE 10g REAL APLICATION CLUSTER (RAC) PADA SISTEM OPERASI SUN SOLARIS 10

During the implementation of database system, needs of getting fast, accurate and high-availabilitydata, has become major clauses for the implementation of “high-availability” system. Oracle 10gRAC is a clustered database solution that requires a two or more node hardware configurationcapable of working together under a clustered operating system. A clustered hardware solution ismanaged by cluster management software, usually provided by the hardware vendor. Theoperating system is also responsible for providing access to the shared disk subsystems. Parametersthat used for the performance testing and analyzing of Oracle 10g Real Application Cluster are thecpu idle, free memory, SGA, buffer cache, and shared pool. As result for the performance testingand analyzing, it can be concluded that Oracle 10g Real Application Cluster was really good for theimplementation of “high-availability system” concept. But it all depends to the analysis for itssystem.

Data Sorting in Flash Memory

Because flash memory now provides an economical solution for various portable devices and embedded systems, an NAND flash-based storage system has replaced the hard disk drive in many applications. Recently, the implementation of database systems using an NAND flash-based storage system has become an important research topic. In particular, the external sorting is an important operation in database systems. With the very distinctive characteristics of flash memory, the typical external sorting system that adopts a clustered sorting process can result in performance degradation and reduce the reliability of flash memory. In this article, we will propose an unclustered sorting method that considers the unique characteristics of flash memory, and we then propose a decision rule to exploit the advantages of both clustered and unclustered sorting. The decision rule can separate records according to their record length, sort them appropriately by the clustered and unclustered sorting, and merge the sorted results. The experimental results show that the proposed method can improve performance in an NAND flash-based storage system (i.e., solid-state drive).

THE MATHEMATICAL ANALYSIS OF COLUMN ORIENTED DATABASE

There are two obvious ways to map a two-dimension relational database table onto a one-dimensional storage interface: store the table row-by-row, or store the table column-by-column. Historically, database system implementations and research have focused on the row-by row data layout, since it performs best on the most common application for database systems: business transactional data processing. However, there are a set of emerging applications for database systems for which the row-by-row layout performs poorly. These applications are more analytical in nature, whose goal is to read through the data to gain new insight and use it to drive decision making and planning. In this paper, we study about the facts responsible for making Column Oriented database when traditional Row-oriented databases are already present, analysis of generation of Column Oriented databases, etc. Finally It will be conclude by giving a probabilistic analysis of Column Oriented database.

Offloading data encryption to GPU in database systems

Graphics processing units have proved their capability for general-purpose computing in many research areas. In this paper, we propose the mechanism and implementation of a database system that encrypts and decrypts data by using GPU. The proposed mechanism is mainly designed for database systems that require data encryption and decryption to support high security level. The outsourced database systems or database cloud service could be a good candidate for our system. By exploiting the computation capability of GPU, we achieve not only a fast encryption and decryption time per operation, but also a higher overall performance of a database system by offloading computation to GPU. Moreover, the proposed system includes a mechanism which can decide whether to offload computation to GPU or not for more performance gain. We implemented the AES algorithm based on CUDA framework and integrate with MySQL, a commodity database system. Our evaluation demonstrates that the encryption and decryption on GPU show eight times better performance compared to that on CPU when the data size is 16 MB and the performance gain is proportional to the data size. We also show that the proposed system alleviates the utilization of CPU, and the overall performance of the database system is improved by offloading heavy encrypting and decrypting computation to GPU.

Ophidia: Toward Big Data Analytics for eScience

This work introduces Ophidia, a big data analytics research effort aiming at supporting the access, analysis and mining of scientific (n-dimensional array based) data. The Ophidia platform extends, in terms of both primitives and data types, current relational database system implementations (in particular MySQL) to enable efficient data analysis tasks on scientific array-based data. To enable big data analytics it exploits well-known scientific numerical libraries, a distributed and hierarchical storage model and a parallel software framework based on the Message Passing Interface to run from single tasks to more complex dataflows. The current version of the Ophidia platform is being tested on NetCDF data produced by CMCC climate scientists in the context of the international Coupled Model Intercomparison Project Phase 5 (CMIP5).

Performance Analysis of Column Oriented Database Vs Row Oriented Database

There are two obvious methods to map a two-dimension relational database table onto a one-dimensional storage interface: store the table row-by-row, or store the table column-by-column. Traditionally, database system implementations and research have focused on the row-by row data layout, since it performs best on the most common application for database systems: business transactional data processing. However, there are a set of emerging applications for database systems for which the row-by-row layout performs poorly. These applications are more analytical in nature, whose goal is to read through the data to gain new insight and use it to drive decision making and planning. In this paper, we study the poor performance of row-by-row data layout for these emerging applications, and evaluate the column-by-column data layout opportunity as a solution to this problem. The solution will be analyzed and represented by graph. At the end of the paper we will see the comparative performance of Oracle 10g and MSSQLServer database.