Programming Language Database Research Articles

RANCANG BANGUN WEBSITE WISATA GEOL DESA KABUPATEN LANGKAT

This research is conducted with the aim of designing and building a tourist website in which it provides information on Wisata Geol in Pematang Serai Village. This research is based on the basis of the needs of containers as promotional media also provides information quickly and accurately, because the delivery of information on the current Wisata Geol is still done manually which is considered still not effective. In addition, this information system makes it easy to visitors to book ticket reservations via website previosly made by hand through celluler phone calls. With this information system it will make it easier for the administration of the misata to file a visitor’s report. These web tours use Mysql Database and use PHP Programming language and employ multiple support applications such as a Balsamiq Mockup for a design and CSS display for a website page view

Aplikasi Pengolahan Data Penjualan Pembangkit Listrik Tenaga Surya Menggunakan Model View Controler Berbasis Framework Codelgniter Dan White Box Testing

Solar power plants are engaged in providing services and selling solar cells. The design of the sales data processing application uses a database and generates archiving data reports on the sales data report maker. To meet the needs of inputting sales data, there is a special section that handles the admin section, the cashier section, but this work system already uses a web-based data processing application. The method used in data processing applications is in the form of observation, interviews, and documentation. While the application design method uses document flow charts, data flow diagrams, and use cases. Supporting software in making data processing applications using the php database programming language used mysql. The design of the product sales data application produces a database design, namely the goods data and sales table. Black box test results show the features in the application run accordingly and the white box test results in the login menu generate the same region and path value of 7 for the value of Cyclomatic Complexity=7 , Region=7 and Independent Path=7, meaning that the logic used in the program code is appropriate and running and in accordance with the research objectives that the input process of stock goods and transactions can be done optimally.

Data Science and Machine Learning Integrated Implementation Patterns for Cavernous Knowledge Discovery from COVID-19 Data

Pandemic is a well-known term for the year 2020. It’s essentially a disease that spreads across a region or the entire planet. The entire planet appears powerless, and a jerk triggered by a virus outbreak has halted. On 11 March 2020, WHO announced Corona Virus disease 2019 (COVID-19) a pandemic. The outbreak or epidemic of the virus differs widely from one nation to another. Society is the secret to solving the pandemic. Fever is one of the common, easily detectable symptoms of COVID-19. The COVID 19 in India is one of the most widespread pandemics caused by extreme acute corona viral syndrome2 (SARS-CoV-2) in coronvirus disease 2019 (COVID-19). On 30 January 2020, the original case of COVID-19 in India, arising in China, was registered. India currently has the highest number of confirmed cases in Asia and the second largest number after the United States of America in the world, with a combined number of confirmed cases exceeding the thresholds of 100,000 on 19 May and 1.000,000 confirmed cases on 17 July 2020. The largest one-day increase in COVID-19 cases of 78,761 cases was observed in Indian countries on 29 August 2020, surpassing the previous record in US cases of 77,368 on 17 July 2020. Nowadays, data science tasks are not limited to traditional data analysis with limited attributes and records. In current scenarios, the real-time datasets are huge with enormous attributes and such datasets are very complex to evaluate using classical data analysis tools. For example, the datasets of the medical domain integrate several attributes in which the information of symptoms, diagnosis, travel history, health parameters, and many others are evaluated. To deal with such types of datasets assorted database query tools and programming languages are used.

E-Sharing : Developing a Web Based Online Donation System

Nowadays there are so many people who are surviving on only one meal per day. Especially in developing countries, it is one of the major problems. On the other hand, there is so much wastage of food every day. Some poor people need clothes and vessels, and children need some books and study kits. Solution to this is that we only need to donate the leftover food to needy people, charities, and our old stuff. For that to happen, we need some sort of platform. This could be any online platform like a website/web application. In Saudi Arabia, there are so many people who are capable of making donations and also there are so many Nongovernmental Organizations (NGOs) which are helping poor and needy people of Saudi Arabia. But to connection gap is not as blur as it should be. There has to be some simple, fast, intuitive and secure way of doing such online donations so that users can donate easily with just a click. The aim of this work is to design and develop a Web Based Online charitable Donation System. Where, the charitable website will collect the charitable donations (such as clothes, toys, school tools) and delivers it to the children who need it. The proposed system will provide voluntary opportunities for those wishing to be volunteer in delivering the donations to the homes of the poor for free. The proposed work was designed and developed using the Unified Modeling Language (UML), SQL Server for implemented the database, and ASP.net and Visual basic programming languages.

Parallel Class Ranking Model Using Analytic Hierarchy Process With Multi Criteria

Madrasah Aliyah Negeri (MAN) Banyuwangi using a worksheet which can lead to error occurrences and slow decision making. A system for decision support that can improve the ranking process and quality were developed in this paper. The proposed system implemented the codeigniter framework, MySQL database, and PHP programming language. The system provided three user roles which are teacher, student, and administrator role. These four parameters are used as ranking system input, including academic values, non-academic values, violation scores, and student attendance. The ranking process was conducted by applying the analytic hierarchy process (AHP) method. The developed decision support system was tested using two ways: the black box testing method and providing questionnaires. Black box testing result shows that the system has functionally worked, while user’s questionnaire gives 92,29% well accepted by users. The results show that the decision support system can help manage values and determine the parallel ranking list.

Decision support system design for determining brown sugar quality with weighted product method

Brown sugar is the result of processing the coconut juice with a distinctive taste, so that its use cannot be replaced by other types of sugar. The purpose of this research is to design of Decision Support System (DSS) using a Multi Attribute Decision Making (MADM) model by applying Weighted Product (WP) method to determine the quality of brown sugar. WP method was chosen because the problem in this research is a ranking problem. The WP method is able to select the best alternative from a number of alternatives and its superiority in weighting technique. This system is designed by using PHP and MySQL as the database programming language. This system can rank the brown sugar by calculating the criteria weight. The weight value is searched for each attribute, then conduct the ranking process to determine the optimal alternative, which is the best brown sugar and decent in terms of ranking. Based on the tests performed, a system capable to produce the best ranking in accordance with the calculations used, so that the system this can be speed up the selection of brown sugar.

APLIKASI LAYANAN MONITORING PROGRES HASIL PLASMA PERKEBUNAN KELAPA SAWIT BERBASIS WEB

Koperasi Plasma Baringin Siduampan West Pasaman regency is Koperasi focus cultivate palm oil plantation, its profit sharing. During time there is no monitoring system for the progress amount of product oil palm, the problem in the plasma. any member has difficulty getting information about the progress of oil palm plantation because Koperasi Plasma management does not have the tools to deliver information to koperasi plasma members . regularly, the process of monitoring plasma product is still manually by recording collection data in some books and records into the Microsoft Excel application. That needs a long time and mistakes can be in creating progress reports on koperasi plasma of palm oil plantations. Therefore, the requirement for a web-based application applying the PHP programming language and database MySQL that can help every member of the Koperasi Plasma Baringin Siduampan in monitoring the progress of plasma palm oil palm plantation products. Applying the PHP programming language database MySQL can design a monitoring system for the production of palm oil plantations. Aim of the research is to help the Koperasi Plasma Siduampan palm oil in monitoring the growth of oil palm plantations and profit sharing. In the monitoring system that is implemented, the administrator makes progress data entry including progress photos, oil palm plantation product, and amount of income for any group member. any group member can be accessed and monitor the system based on data that has been identified by the administrator. So that with the information system this monitoring service can produce information simplify for each member of the Koperasi Plasma Baringin Siduampan in monitoring the progress of oil palm products.

COMPUTER MODEL OF VIRTUAL SOCIAL NETWORK WITH RECOMMENDATION SYSTEM

The subject matter of the article is the process of modeling social networks. The goal is to develop a computer model of a social network with a recommendation system. The tasks to be solved are to research the methods of generating social networks, to realize the computer model of a social network with a recommender system. The methods used are graph theory, theory of algorithms, statistics theory, probability theory, object-oriented programming. The following results: the research of existing methods for modeling social networks was conducted, in particular, such social network models as the Barabasi-Albert model, the Erdős-Renyi model and the Bollobаs-Riordan model were considered. The concept of complex networks was considered. The research of the basic properties of graphs of social networks was considered. The social network computer model with a recommender system based on the modified Barabasi-Albert model with using graph database Neo4j and programming language Python was developed. The developed model allows to model a network with users and text posts and may contain following connections friends, follower, published, viewed, like, similar, recommended, and also allows testing of algorithms of recommender systems and conduct research to changes in a social network after creating and proposing recommendations. The testing of the developed computer model of virtual social network with a recommender system was conducted. Conclusions. The research of various methods of modeling social networks was conducted. The concept of complex networks was investigated. The main properties of social network graphs are considered. The computer model of a social network with a recommendation system that contains various types of nodes and connections that allow testing a recommender system algorithm has been developed. The developed model of a social network with a recommender system was tested to check its similarity with real social networks. The developed computer model of a social network has the values of network graph parameters corresponding to the values characteristic of real social networks, which allows using the developed model to research the processes that can occur in real social networks.

Expert System Design for Web-Based Lecturer Scheduling

In this study contains an expert system design for web-based lecturer scheduling that can facilitate the Chair of the Study Program in scheduling courses for lecturers. This system was built using Notepad ++ software, XAMPP with HTML, CSS, JavaScript, PHP and database programming languages using MYSQL. Subjects in this study are expert system applications as the media schedule lecturer subjects. Data collection in this study uses the interview method and questionnaire method. This system is built with the Waterfall model namely analysis, design, coding and testing. This application in the inference engine used is the forward chaining method. The results of this study are expert system applications to schedule lecturers’ subjects according to the questionnaire data. Based on the results of the trial it can be concluded that this expert system application can facilitate the Chair of the Study Program in accurately scheduling courses, classes, days, hours, space, and lecturers

MEDIA PEMBELAJARAN SERVIS DAN REPARASI MOBIL BERBASIS SISTEM PAKAR (Studi Kasus di SMK Kyai Ageng Pandanaran)

SMK Kyai Ageng Pandanaran Semarang is one of the private vocational high school that want to improve quality of teaching and learning to produce quality graduates. During these teaching and learning methods that are used less than maximum, students are easily saturated, study time is limited and there are no facilities for new teachers to learn service and auto repair material efficiently. The authors develop a learning media services and auto repair expert system based that aims to resolve the issue.
 Learning media is developed by prototype approach. Expert system technology advanced trace method is applied into the learning media through the facilities of diagnosis and troubleshooting to help new teachers and student learning to identify the damage automobile. Database can be managed and updated by senior teachers by utilizing the MySQL database and PHP programming language. In addition, this learning media also features video demonstration of the *.swf file and the theoretical material in the form of a *.pdf file.
 The results of the development has produced a new system of web-based expert system as a supplement learning media services and auto repair in the process of teaching and learning activities.

Leveraging synergy between database and programming language courses

Undergraduate courses in database systems and programming languages are frequently taught without much overlap. This paper argues that there is a substantial benefit to emphasizing some areas of commonality, both old and new, between the two subjects. Examples of such cross-fertilization that may be used to enhance one or both of the courses include query language design and implementation, object-relational mapping, transactional memory, and various aspects of the recent NoSQL movement.

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.

PERANCANGAN WEB-GIS PENYEBARAN WABAH PENYAKITDEMAM BERDARAH DENGUE (DBD) DAN MALARIADI KOTA BANDAR LAMPUNG

Dengue Fever (DBD) and Malaria are kinds of diseases that often caused an extraordinary occurrence in Indonesia. Both diseases can spread rapidly and cause death in short time. The prediction of occurrence of Dengue Fever (DBD) and Malaria diseases in Bandar Lampung, still processed manually and presented in form of tables and graphs. In this research, Web-based Geographic Information System (WEB-GIS) was developed to provide information of the spreading of Dengue Fever (DBD) and Malaria diseases in the City of Bandar Lampung. Data was obtained from the Department of Health of the City government. The WEB-GIS was implemented using Arcview, MapServer, MySQL database, and PHPMapscript programming language. The result shows that WEB-GIS could provide information of spreading area of Dengue Fever (DBD) and Malaria diseases in Bandar Lampung until village level. Keywords : Dengue Fever, Malaria, WEB-GIS

Analisis dan Perancangan Halaman Website Simulasi Perakitan Sepeda

Recently, Bike shop only sells bicycle in full bike or you can build it with components that suit you at the shop. However, these days many customer needs e-commerce web so that potential customers or buyers can shop online for their custom build bike. But if they want to see how it built, they have to see it on the shop or see other builds. The main idea of this study is to make a custom build simulation for bicycle web application for bike shop so that potential buyers could do a simulation first before they buy a custom build bike so that they know what components that suits them and know the weight, price and etc.
 The objective of this study is to make the potential buyer easier to find a bike that suits their needs. The methodology of system design in this study is using Rapid Application Development Method because the method could made the process very fast and always interact with the bike shop owner so that the application right on track. The website application was built by using MySQL Database and PHP programming language. The website is divided into 2 parts, which are one for customer and one for admin for maintaining the app. In this study use Spinwarrior bike shop for the example of the website implementation
 Index Terms: Bicycle, custom build, simulation, PHP, website.

Analysis and Design Web Based System in LPPM UMN

Institute for Research and Community Service, or called LPPM is a forum for researchers to conduct studies with internal and national scales. LPPM UMN is one of the institutions that provide the container for UMN researchers. However, in the LPPM UMN itself still does not have a webbased system that can be accessed anywhere. This website will be able to share knowledge amongst lecturers by downloading study results that have been done before. After collecting all the requirements, an application is designed using the Rapid Application Development for a limited time spent. The application is built by designing a website and applying MySQL database and PHP programming language with CodeIgniter framework 2.2.2. This website is divided into 3 parts; admins, reviewers, and researcher. Admins are able to see the whole proposal which is sent and appoint a reviewer for one of the proposals. Reviewers have some facilities to review research proposals that have been uploaded. Researchers are able to upload a research proposal.
 Index Terms - LPPM, Knowledge Management, Research, Website.

Rancang Bangun Aplikasi Penjurusan Minat Bakat Menggunakan Metode Forward Chaining

Plentiful choices of Student Activities Unit that offered by a campus like Multimedia Nusantara University can help students who want to choose a unit that suitable for them. The decision support system application with Forward Chaining method is built to help students choosing the Student Activity Unit that suits them. Multiple Intelligence method is used as the knowledge base at making the rules. The aspects that considered as attributes to choosing the Student Activities Unit is the initial interest and also the multiple intelligence scores that the level of conformity will be searched by using Forward Chaining method. This research has produced a knowledge-based decision support system that can help students at choosing Student Activities Unit that suitable for them with the highest accuracy of 86.67 percent. This system is designed in website with PHP and MySQL database programming language.
 Index Terms—Forward Chaining, Knowledge-based, Multimedia Nusantara University, Multiple Intelligence, Student Activities Unit

TU-F-CAMPUS-I-05: Semi-Automated, Open Source MRI Quality Assurance and Quality Control Program for Multi-Unit Institution

Purpose: Phantom measurements allow for the performance of magnetic resonance (MR) systems to be evaluated. Association of Physicists in Medicine (AAPM) Report No. 100 Acceptance Testing and Quality Assurance Procedures for MR Imaging Facilities, American College of Radiology (ACR) MR Accreditation Program MR phantom testing, and ACR MRI quality control (QC) program documents help to outline specific tests for establishing system performance baselines as well as system stability over time. Analyzing and processing tests from multiple systems can be time-consuming for medical physicists. Besides determining whether tests are within predetermined limits or criteria, monitoring longitudinal trends can also help prevent costly downtime of systems during clinical operation. In this work, a semi-automated QC program was developed to analyze and record measurements in a database that allowed for easy access to historical data. Methods: Image analysis was performed on 27 different MR systems of 1.5T and 3.0T field strengths from GE and Siemens manufacturers. Recommended measurements involved the ACR MRI Accreditation Phantom, spherical homogenous phantoms, and a phantom with an uniform hole pattern. Measurements assessed geometric accuracy and linearity, position accuracy, image uniformity, signal, noise, ghosting, transmit gain, center frequency, and magnetic field drift. The program was designed with open source tools, employing Linux, Apache, MySQL database and Python programming language for the front and backend. Results: Processing time for each image is <2 seconds. Figures are produced to show regions of interests (ROIs) for analysis. Historical data can be reviewed to compare previous year data and to inspect for trends. Conclusion: A MRI quality assurance and QC program is necessary for maintaining high quality, ACR MRI Accredited MR programs. A reviewable database of phantom measurements assists medical physicists with processing and monitoring of large datasets. Longitudinal data can reveal trends that although are within passing criteria indicate underlying system issues.

An approach for aggregating upstream catchment information to support research and management of fluvial systems across large landscapes.

The growing quality and availability of spatial map layers (e.g., climate, geology, and land use) allow stream studies, which historically have occurred over small areas like a single watershed or stream reach, to increasingly explore questions from a landscape perspective. This large-scale perspective for fluvial studies depends on the ability to characterize influences on streams resulting from throughout entire upstream networks or catchments. While acquiring upstream information for a single reach is relatively straight-forward, this process becomes demanding when attempting to obtain summaries for all streams throughout a stream network and across large basins. Additionally, the complex nature of stream networks, including braided streams, adds to the challenge of accurately generating upstream summaries. This paper outlines an approach to solve these challenges by building a database and applying an algorithm to gather upstream landscape information for digitized stream networks. This approach avoids the need to directly use spatial data files in computation, and efficiently and accurately acquires various types of upstream summaries of landscape information across large regions using tabular processing. In particular, this approach is not limited to the use of any specific database software or programming language, and its flexibility allows it to be adapted to any digitized stream network as long as it meets a few minimum requirements. This efficient approach facilitates the growing demand of acquiring upstream summaries at large geographic scales and helps to support the use of landscape information in assisting management and decision-making across large regions.Electronic supplementary materialThe online version of this article (doi:10.1186/2193-1801-3-589) contains supplementary material, which is available to authorized users.

Systematic program design: from clarity to efficiency

A systematic program design method can help developers ensure the correctness and performance of programs while minimizing the development cost. This book describes a method that starts with a clear specification of a computation and derives an efficient implementation by step-wise program analysis and transformations. The method applies to problems specified in imperative, database, functional, logic, and object-oriented programming languages with different data, control, and module abstractions. Designed for courses or self-study, this book includes numerous exercises and examples that require minimal computer science background, making it accessible to novices. Experienced practitioners and researchers will appreciate the detailed examples in a wide range of application areas including hardware design, image processing, access control, query optimization, and program analysis. The last section of the book points out directions for future studies.

Functions are data too

We demonstrate a full-fledged implementation of first-class functions for the widely used PL/SQL database programming language. Functions are treated as regular data items that may be (1) constructed at query runtime, (2) stored in and retrieved from tables, (3) assigned to variables, and (4) passed to and from other (higher-order) functions. The resulting PL/SQL dialect concisely and elegantly expresses a wide range of new query idioms which would be cumbersome to formulate if functions remained second-class citizens. We include a diverse set of application scenarios that make these advantages tangible. First-class PL/SQL functions require featherweight syntactic extensions only and come with a non-invasive implementation-- the defunctionalization transformation--that can entirely be built on top of existing relational DBMS infrastructure. An interactive demonstrator helps users to experiment with the "function as data" paradigm and to earn a solid intuition of its inner workings.