To see the other types of publications on this topic, follow the link: DBMS Testing.
Journal articles on the topic 'DBMS Testing'
Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles
Consult the top 50 journal articles for your research on the topic 'DBMS Testing.'
Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.
You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.
Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.
1
Wen, Shihao, Peng Jia, Pin Yang, and Chi Hu. "Squill: Testing DBMS with Correctness Feedback and Accurate Instantiation." Applied Sciences 13, no. 4 (February 15, 2023): 2519. http://dx.doi.org/10.3390/app13042519.
Full textAbstract:
Database Management Systems (DBMSs) are the core of management information systems. Thus, detecting security bugs or vulnerabilities of DBMSs is an essential task. In recent years, grey-box fuzzing has been adopted to detect DBMS bugs for its high effectiveness. However, the seed scheduling strategy of existing fuzzing techniques does not consider the seeds’ correctness, which is inefficient in finding vulnerabilities in DBMSs. Moreover, current tools cannot correctly generate SQL statements with nested structures, which limits their effectiveness. This paper proposes a fuzzing solution named Squill to address these challenges. First, we propose correctness-guided mutation to utilize the correctness of seeds as feedback to guide fuzzing. Second, Squill embeds semantics-aware instantiation to correctly fill semantics to SQL statements with nested structures by collecting the context information of AST nodes. We implemented Squill based on Squirrel and evaluated it on three popular DBMSs: MySQL, MariaDB, and OceanBase. In our experiment, Squill explored 29% more paths and found 3.4× more bugs than the existing tool. In total, Squill detected 30 bugs in MySQL, 27 in MariaDB, and 6 in OceanBase. Overall, 19 of the bugs are fixed with 9 CVEs assigned. The results show that Squill outperforms the previous fuzzer in terms of both code coverage and bug discovery.
2
Lo, Eric, Carsten Binnig, Donald Kossmann, M. Tamer Özsu, and Wing-Kai Hon. "A framework for testing DBMS features." VLDB Journal 19, no. 2 (August 1, 2009): 203–30. http://dx.doi.org/10.1007/s00778-009-0157-y.
Full text
3
Thüm, Thomas, Sandro Schulze, Mario Pukall, Gunter Saake, and Sebastian Günther. "Secure and Customizable Data Management for Automotive Systems: A Feasibility Study." ISRN Software Engineering 2012 (March 18, 2012): 1–7. http://dx.doi.org/10.5402/2012/424230.
Full textAbstract:
Custom tailor-made database management systems (DBMS) are an essential asset, especially for embedded systems. The continuously increasing amount of data in automotive systems and the growing network of embedded devices can profit from DBMS. Restrictions in terms of processors, memory, and storage require customizable DBMS that contain only the needed functionality. We present AutoDaMa, a customizable DBMS designed for automotive systems. With AutoDaMa, it is possible to generate tailor-made DBMS for different scenarios, for example, by restricting the storage size of the DBMS or adding security-related features such as asymmetric and symmetric encryption. We demonstrate the feasibility of our approach through applying different tailor-made DBMS versions derived from AutoDaMa in an automotive testing environment. Our experience is that AutoDaMa can dramatically reduce the development effort and can increase reliability using efficient reuse mechanisms.
4
Bruno, N., S. Chaudhuri, and D. Thomas. "Generating Queries with Cardinality Constraints for DBMS Testing." IEEE Transactions on Knowledge and Data Engineering 18, no. 12 (December 2006): 1721–25. http://dx.doi.org/10.1109/tkde.2006.190.
Full text
5
Sitnov, Vladimir E., Alexander I. Senchenko, and George A. Fatkin. "Archiving System Software for LIA-20." Vestnik NSU. Series: Information Technologies 18, no. 3 (2020): 69–80. http://dx.doi.org/10.25205/1818-7900-2020-18-3-69-80.
Full textAbstract:
The control system of the X-ray complex LIA-20 is based on the Tango Controls framework. Data archiving subsystem HDB++ was improved during the work for efficient storage of waveforms. PostgreSQL DBMS support as a storage was added. PostgreSQL extension “pguint” for unsigned numbers support was modified to support the binary transfer mode during this work. Performance testing of the modified “pguint” extension and the new DBMS interface was performed. This solution allowed to significantly increase the performance of HDB++, reduce the amount of data stored in the database, as well as remove restrictions on the size of the stored data.
6
Győrödi, Cornelia A., Diana V. Dumşe-Burescu, Robert Ş. Győrödi, Doina R. Zmaranda, Livia Bandici, and Daniela E. Popescu. "Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases." Applied Sciences 11, no. 15 (July 23, 2021): 6794. http://dx.doi.org/10.3390/app11156794.
Full textAbstract:
Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.
7
Berski, Szymon, and Martyna Bilau. "Safety Mechanisms in Relational Database as Part of the IT System of the Enterprise." New Trends in Production Engineering 2, no. 2 (December 1, 2019): 12–23. http://dx.doi.org/10.2478/ntpe-2019-0068.
Full textAbstract:
Abstract The work examines the effectiveness of the replication mechanism of the X production company database. In order to extend the functionality of the computer database of the enterprise, a model of its resource flow was created and an intensional and extensional part was created for a test database based on real enterprise resources. The model has been simplified to 3-rd normal form. The implementation was done in the MySQL database system. Two different operating systems were selected for testing: Windows and Linux. The database management system (DBMS) is working under the GPL license. MySQL DBMS offers many security mechanisms, and to secure the database, system of users permissions to objects have been selected and also an encryption of access passwords for users and connections to servers was used. A replication engine based on the binary log and the model “main server and backup server” was used to create a copy of the enterprise data.
8
Darma Kotama, I. Nyoman, Made Sudarma, and I. Made Arsa Suyadnya. "Rancang Bangun Sistem Informasi Manajemen Konferensi Ilmiah Berbasis Web." Jurnal SPEKTRUM 4, no. 2 (January 8, 2018): 36. http://dx.doi.org/10.24843/spektrum.2017.v04.i02.p05.
Full textAbstract:
This paper is projecting website system built on top of PHP Framework Laravel 5.2 and MySQL DBMS which contains 6 modules of scientific conference management needs, Master Conference, User Management, Submission, Website Management, Schedule, and Post Conference. From the development and testing system with Black Box method concluded that the system is running well and feasible to be applied to the management of the conference in Electrical Engineering Program Faculty of Engineering Udayana University.
9
He, Haochen, Erci Xu, Shanshan Li, Zhouyang Jia, Si Zheng, Yue Yu, Jun Ma, and Xiangke Liao. "When Database Meets New Storage Devices: Understanding and Exposing Performance Mismatches via Configurations." Proceedings of the VLDB Endowment 16, no. 7 (March 2023): 1712–25. http://dx.doi.org/10.14778/3587136.3587145.
Full textAbstract:
NVMe SSD hugely boosts the I/O speed, with up to GB/s throughput and microsecond-level latency. Unfortunately, DBMS users can often find their high-performanced storage devices tend to deliver less-than-expected or even worse performance when compared to their traditional peers. While many works focus on proposing new DBMS designs to fully exploit NVMe SSDs, few systematically study the symptoms, root causes and possible detection methods of such performance mismatches on existing databases. In this paper, we start with an empirical study where we systematically expose and analyze the performance mismatches on six popular databases via controlled configuration tuning. From the study, we find that all six databases can suffer from performance mismatches. Moreover, we conclude that the root causes can be categorized as databases' unawareness of new storage devices characteristics in I/O size, I/O parallelism and I/O sequentiality. We report 17 mismatches to developers and 15 are confirmed. Additionally, we realize testing all configuration knobs yields low efficiency. Therefore, we propose a fast performance mismatch detection framework and evaluation shows that our framework brings two orders of magnitude speedup than baseline without sacrificing effectiveness.
10
Indriyono, Bonifacius Vicky, and Zudha Pratama. "Generating SQL Command Syntax Using MySQL Based on Typing Command Sentence." Inform : Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi 6, no. 1 (January 31, 2021): 1–7. http://dx.doi.org/10.25139/inform.v6i1.3305.
Full textAbstract:
Information retrieval system is a system that is widely used to retrieve information. This research will discuss how the system finds back the information stored in database tables. Tables in the database are arranged to store all forms of data entered by database users so that later the stored data can be used again. Re-accessing the database's information must go through a mechanism known as a database management system (DBMS). One of the most widely used DBMS is MySQL. By using a DBMS, information and data can be manipulated according to user needs. Data manipulation in the database is done in a special language, namely SQL (Structure Query Language). Mastery of SQL commands is an obligation for database users so that the manipulated data can produce the required information. However, many database users still do not understand how the actual SQL command syntax manages and manipulates data into information. This is, of course, very risky if the solution is not immediately sought because it will hinder the process of retrieving information from the data stored in the database. For this problem to be resolved, it is necessary to design a system that can help database users translate their wishes into SQL command syntax. This paper will discuss how a command in Indonesian can be translated into SQL command syntax. The method used to solve this research problem is rule-based. There are two stages in the main process: the pre-processing stage, which consists of a word tokenization process, and a translation stage, including a keyword grouping process. This keyword grouping process consists of the keyword group analysis phase, table and column analysis, identification of SQL commands, and mapping of SQL commands. From all stages that have been passed and testing of 7 scenarios with ten (10) commands for each scenario, the accuracy is 81.42%. The inaccuracy in the testing process is more a problem of displaying data from two or more tables, for example, using the join table command. This problem can be addressed by adding new rules for the use of table joins.
11
IORDACHE, Dorin. "DATABASE – WEB INTERFACE VULNERABILITIES." STRATEGIES XXI - Security and Defense Faculty 17, no. 1 (November 1, 2021): 279–87. http://dx.doi.org/10.53477/2668-2001-21-35.
Full textAbstract:
The importance of information security in general, of managed information at the level of a database has increased with the expansion of the Internet. On the other hand, it has acquired new facets with the increase of the accessibility of the users to as many resources as possible. Large volume of private data in use and the limitation of unauthorized actions to information have brought new aspects to the issue of ensuring their protection. The scope of this field is wide and allows the operation in several directions: identification, description, creation, implementation and testing of mechanisms aimed at improving the working environment in which database management systems operates. Due to the importance of the information managed by a DBMS[1], it is necessary to define a framework safe and easy to use. The database fulfills not only the role of storage, but also of data provider to users. Thus, the information must be protected throughout the interaction process: generation, storage, processing, modification, deletion, etc. Therefore, the security of databases must not only be reduced to the protection of certain data considered sensitive, but also to the creation of a secure, authorized and controlled global environment through which information becomes available to users.
[1] DBMS – DataBase Management System
12
Albert, Albert, Dali Santun Naga, and Ery Dewayani. "SISTEM INFORMASI PENJUALAN PAKAIAN BERBASIS WEB PADA TARGET FACTORY OUTLET." Jurnal Ilmu Komputer dan Sistem Informasi 8, no. 1 (January 1, 2020): 7. http://dx.doi.org/10.24912/jiksi.v8i1.11194.
Full textAbstract:
Website “Sistem Informasi Penjualan Pakaian Berbasis Web Pada Target Factory Outlet” aimed at helping Target Factory Outlet to expand market share and increase the credibility of Target Factory Outlet itself. The results obtained are websites with the domain name ‘targetfo.store’ which have been hosted can be accessed by website visitors. The making of the website uses System Development Life Cycle (SDLC) method which is carried out in several phases namely analysis, design, implementation, installation, testing, and maintenance. This website uses several design tools, namely Flowchart, Data Flow Diagram, Entity Relationship Diagram, Context Diagram and Relationship Between Tables. Testing this website uses Black Box Testing and User Acceptance Test(UAT) method. This website is created using HTML and PHP programming languages and uses MySQL as a Database Management Software (DBMS). The website ‘targetfo.store’ has the advantage of having goods import reports, sales reports and financial reports that can be seen by Target Factory Outlet owner.
13
Mutrofin, Siti, Eko Candra Dinata, and Erliyah Nurul Jannah. "Implementasi push notification dalam rancang bangun sistem informasi manajemen evaluasi pembelajaran di perguruan tinggi." Teknologi 12, no. 1 (January 1, 2022): 9–14. http://dx.doi.org/10.26594/teknologi.v12i1.2970.
Full textAbstract:
The Student Academic Administration Agency (BAAK) STIE PGRI Dewantara Jombang experienced inefficient evaluation (exam) administration problems. Such as: 1) BAAK has difficulty dividing exam supervisors so that schedules do not clash, 2) Study Programs have difficulty in making evaluation schedules so that there are no clashing schedules, and 3) Lecturers forget or are late in collecting questions and evaluation scores. In this study, it is proposed to create a web-based learning evaluation management information system equipped with a push notification feature to overcome these problems. The software development method used is waterfall, programming language using PHP and HTML5 with CodeIgniter Framework technology and Apache Cordova, notifications using Firebase Cloud, database management system (DBMS) using MySQL, and interface design using Balsamic. Based on the results of testing using blackbox testing, it is concluded that the system can be used to divide supervisors, make scheduling without conflicting times or places, and send notifications to remind when to collect exam questions.
14
Christian, Efrans, Septian Geges, and Firdaus Zailami. "Aplikasi Sistem Pencatatan Keuangan Berbasis Website." Journal of Information Technology and Computer Science 2, no. 1 (March 31, 2022): 29–36. http://dx.doi.org/10.47111/jointecoms.v2i1.8832.
Full textAbstract:
Financial management is a company activity related to how to obtain funds, use funds, and manage assets in accordance with the overall company goals. Financial management is quite complicated because it contains calculations to support a more structured financial system. However, currently there are still many who use the financial system manually and do not use technology such as websites or applications. Waterfall software development method. For the manufacture of the software Sublime Text 3 software as the code. The DBMS (Database Management System) used in this application system is MySQL. The programming languages used are HTML, PHP, CSS, and JavaScript. Based on the results of testing using the blackbox method, it was found that this financial system application was running well.
15
Timofееva, Nadezhda, Alеksеy Gеraskin, and Kristina Polulyakh. "Research and Construction of Stress Testing DBMS Models to Increase Speed and Performance of Distributed Computing System." Vestnik Volgogradskogo gosudarstvennogo universiteta. Serija 1. Mathematica. Physica, no. 1 (January 2017): 75–89. http://dx.doi.org/10.15688/jvolsu1.2017.1.8.
Full text
16
Br Sinurat, Purnama Indah Sari, Dini M. Hutagalung, Riah Ukur Ginting, and Burhanuddin Damanik. "Sistem Informasi Penerimaan Siswa Baru Berbasis Web di SMP Swasta Tunas Harapan." JURNAL UNITEK 14, no. 2 (December 27, 2021): 20–29. http://dx.doi.org/10.52072/unitek.v14i2.231.
Full textAbstract:
Penerimaan siswa baru di SMP Swasta Tunas Harapan masih bersifat manual yaitu calon siswa dan orangtua harus datang mendaftar kesekolah.Sementara dimasa pandemic covid-19 seharusnya lebih efektif dilaksanakan secara online guna memutus penyebaran covid-19, sehingga tujuan penelitian ini adalah merancang sistem informasi penerimaan siswa baru berbasis webpada sekolah menengah pertama (SMP) di Tunas Harapan. Perancangan sistem ini menggunakan bahasa pemograman PHP dengan pemrograman berbasis objek Hyperlink Text Markup Languange (HTML), Database Management System (DBMS) menggunakan MySQL dan XAMPP serta melakukan pengujian system menggunakan metode Black Box Testing. Setelah melewati tahap uji coba dengan baik, maka hasil yang didapatkan yaitu sebuah media informasi yang dapat membantu sekolah untuk proses penerimaan siswa baru. Peneliti menyimpulkan bahwa sistem informasi penerimaan siswa baru berbasis web ini membantu memudahkan calon siswa baru untuk memperoleh semua informasi tentang penerimaan siswa baru dan melakukan proses pendaftaran online
17
Guterres, Jesuino Jhesz. "SISTEM INFORMASI PERPUSTAKAAN BERBASIS WEB DI SEKOLAH MENENGAH PERTAMA SWASTA SANTA THERESIA 1 TUAPUKAN KUPANG TIMUR." Jurnal Pendidikan Teknologi Informasi (JUKANTI) 3, no. 2 (November 26, 2020): 33–38. http://dx.doi.org/10.37792/jukanti.v3i2.223.
Full textAbstract:
Penelitian ini bertujuan membangun sistem informasi perpustakaan berbasis web menggunakan bahasa pemrograman PHP dan DBMS MySQL untuk: menciptakan sebuah sistem informasi perpustakan berbasis web. Yang dapat memberikan informasi perpustakaan yang cepat, tepat, dan akurat untuk guru, siswa, petugas perpustakaan, dan pimpinan. Jenis penelitian yang digunakan adalah penelitian R&D (Research and Development). Pengembangan sistem infromasi perpustakaan berbasis web pada penelitian ini, menggunakan model pengembangan waterfall atau air terjun yang meliputi tahap Analisis, Design, Coding, Testing, dan Maintenance. Hasil pengujian untuk aspek functionality dengan nilai X lebih dari 0,5 atau mendekati 1. Maka pengujian sistem pada aspek functionality dikatakan baik karena nilai mendekati 1. Sedangkan untuk aspek usability dari hasil presentase pengujian dengan nilai 81,4% masuk dalam kategori “Layak” dan memenuhi aspek usability. Berdasarkan hasil tersebut maka sistem informasi yang di hasilkan dapat mengurangi kesalahan manajemen perpustakaan dengan cara konvensional sebelumnya.
18
Yuferov, Anatoliy G. "Infological models of the ENDF-format nuclear data." Nuclear Energy and Technology 5, no. 1 (March 20, 2019): 53–59. http://dx.doi.org/10.3897/nucet.5.33984.
Full textAbstract:
Issues involved in the infologic modeling of the ENDF-format nuclear data libraries for the purpose of converting ENDF files into a relational database have been considered. The transfer to a relational format will make it possible to use standard readily available tools for nuclear data processing which simplify the conversion and operation of this data array. Infological models have been described using formulas of the “Entity (List of Attributes)” type. The proposed infological formulas are based on the physical nature of data and theoretical relations. This eliminates the need for a special notation to be introduced to describe the structure and the content of data, which, in turn, facilitates the use of relational formats in codes and solution of nuclear data evaluation problems. The concept of nuclear informatics has been formulated based on relational DBMS technologies as one of the tools for solving the “big data” problem in modern science and technology. The organizational and technological grounds for the transfer of ENDF libraries to a relational format are presented. Requirements to the nuclear data presentation formats supported by relational DBMS are listed. Peculiarities of the infological model construction, conditioned by the hierarchical nature of nuclear data, are identified. The sequence for the ENDF metadata saving is presented, which can be useful for the verification and validation (testing of the structural and syntactical validity and operability) of both source data and the procedures for the conversion to a relational format. Formulas of infological models are presented for the cross sections file, the secondary neutron energy distributions file, and the nuclear reaction product energy-angle distributions file. A complete array of infological models for ENDF libraries and the generation modules of respective relational tables are available on a public website.
19
Afuan, Lasmedi, Nofiyati Nofiyati, and Nasichatul Umayah. "Rancang Bangun Sistem Informasi Bank Sampah di Desa Paguyangan." Edumatic: Jurnal Pendidikan Informatika 5, no. 1 (June 25, 2021): 21–30. http://dx.doi.org/10.29408/edumatic.v5i1.3171.
Full textAbstract:
Garbage is the residual material resulting from a production process, both industry and households. Based on Brebes district's statistical data, the Paguyangan sub-district is in fourth place with an average of 249.62 m3 of garbage per day. Paguyangan is one of the villages in the Paguyangan sub-district. Paguyangan has a garbage problem where people still have the habit of throwing garbage in the river and yards around the house. Based on this, the Paguyangan Village Hall plans to build a garbage bank to overcome the problem. A garbage bank managed activities such as recording saving's transactions. This study conducted a web-based design of the Garbage Bank Information System (SIBS). SIBS is an information system used to help process garbage transactions at a garbage bank. The purpose of this SIBS is to facilitate officers and customers in processing services at the garbage bank. The methodology used in system development is the Waterfall method. SIBS development uses PHP as a programming language and MySql as the DBMS. The result of this research is an information system that can be used in the management of Waste Management transactions. The results of system testing using Black box Testing and Mean Opinion Score (MOS) obtained that all components in this system are running well according to needs.
20
Sagala, Dame Christine, Ali Sadikin, and Beni Irawan. "PERANCANGAN SISTEM PENGOLAHAN DATA JEMAAT BERBASIS WEB PADA GEREJA GKPI KOTA JAMBI." JOURNAL V-TECH (VISION TECHNOLOGY) 1, no. 2 (December 14, 2018): 14–24. http://dx.doi.org/10.35141/jvt.v1i2.92.
Full textAbstract:
The data processing systems is a very necessary way to manipulate a data into useful information. The system makes data storage, adding, changing, scheduling to reporting well integrated, so that it can help parts to exchange information and make decisions quickly. The problems faced by GKPI Pal Merah Jambi are currently still using Microsoft Office Word and in disseminating information such as worship schedules, church activities and other worship routines through paper and wall-based worship services. To print worship and report reports requires substantial operational funds, in addition to data collection and storage there are still deficiencies including recording data on the book, difficulty in processing large amounts of data and stored in only one special place that is passive. Based on the above problems, the author is interested in conducting research with the title Designing Data Processing Systems for Web-Based Churches in the GKPI Pal Merah Church in Jambi. The purpose of this study is to design and produce a data processing system for the church. Using this system can facilitate data processing in the GKPI Pal Merah Jambi Church. This study uses a waterfall development method, a method that provides a systematic and sequential approach to system needs analysis, design, implementation and unit testing, system testing and care. Applications built using the web with MySQL DBMS database, PHP programming language and Laravel.
21
Prabowo, Yudi, Ike Pertiwi Windasari, and Kodrat Iman Satoto. "Perancangan Sistem Informasi Surat Referendum Usulan Kenaikan Pangkat atau Jabatan Berbasis Web." Jurnal Teknologi dan Sistem Komputer 3, no. 1 (January 30, 2015): 110–15. http://dx.doi.org/10.14710/jtsiskom.3.1.2015.110-115.
Full textAbstract:
The rapid growth of information and communication technology (ICT) facilitate human activity. Senate of the Faculty of Engineering, University of Diponegoro , as the highest representative body of normative and within the faculty , has one of the tasks that provide feedback on a proposed referendum letter promotion . In the current procedure , the data is stored in the form of the proposed paper form . This method is less efficient , time-consuming addition , members often did not give his opinion because of forgotten or busy with other activities . The purpose of this study is to design a new, computerized information system that is capable of handling data storage process in the Senate , a notice of the proposed promotion, and management approval of the proposed increase in the post. Development of Information System was developed using FAST ( Framework for the Application of System Technique) . This information system development using PHP programming language ased on CodeIgniter framework . Storage and management of databases using a DBMS ( Database Management System MySQL . Testing Information System using User Acceptance testing , that using BlackBox Methodology . The results of this study is to produce a system that can accommodate the proposed promotion, responses senate , and spread in the form of an SMS message to the senate . So that this system can replace the system that is currently running are still less efficient and is manual .
22
Wicaksono, Erwin, Fauziah Fauziah, and Deny Hidayatullah. "Implementasi Electronic Customer Relationship Management menggunakan Metode Framework of Dynamic berbasis Web." Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi) 5, no. 4 (October 1, 2021): 371. http://dx.doi.org/10.35870/jtik.v5i4.226.
Full textAbstract:
The purpose of this study is to build soft devices for electronic customer relationship management (e-CRM) with the Framework of Dynamic method which will facilitate customer relationship management that can help relationships between stores and customers so that customers can enjoy and feel comfortable with the store services that can eventually be formed. In implementing this software, the author uses the system development lifecycle (SDLC) method then produces a web-based e-CRM prototype with PHP programming languages and MySQL DBMS. This e-CRM prototype has been tested in terms of verification, validation, and prototype testing. To design this system Use Cases, ERD, LRS, Class Diagrams, and Sequence Diagrams are used. From the test results, it can be seen that the e-CRM prototype has been successful and is in accordance with the planning objectives. The result of this Marketplace Design is as a forum to make it easier for shop owners in the field of Building Materials and the like to market the products they have here.Keywords:e-CRM, Framework of Dynamic CRM, Customer, System Development Life Cycle.
23
Vandevoort, Brecht, Bas Ketsman, Christoph Koch, and Frank Neven. "Robustness against read committed for transaction templates." Proceedings of the VLDB Endowment 14, no. 11 (July 2021): 2141–53. http://dx.doi.org/10.14778/3476249.3476268.
Full textAbstract:
The isolation level Multiversion Read Committed (RC), offered by many database systems, is known to trade consistency for increased transaction throughput. Sometimes, transaction workloads can be safely executed under RC obtaining the perfect isolation of serializability at the lower cost of RC. To identify such cases, we introduce an expressive model of transaction programs to better reason about the serializability of transactional workloads. We develop tractable algorithms to decide whether any possible schedule of a workload executed under RC is serializable (referred to as the robustness problem). Our approach yields robust subsets that are larger than those identified by previous methods. We provide experimental evidence that workloads that are robust against RC can be evaluated faster under RC compared to stronger isolation levels. We discuss techniques for making workloads robust against RC by promoting selective read operations to updates. Depending on the scenario, the performance improvements can be considerable. Robustness testing and safely executing transactions under the lower isolation level RC can therefore provide a direct way to increase transaction throughput without changing DBMS internals.
24
Elizabeth, Triana, and Tinaliah Tinaliah. "Rancang Bangun Aplikasi Penjualan dan Stok Barang Material (Studi Kasus: Toko Bangunan XYZ)." JATISI (Jurnal Teknik Informatika dan Sistem Informasi) 4, no. 2 (March 18, 2018): 177–86. http://dx.doi.org/10.35957/jatisi.v4i2.100.
Full textAbstract:
Meningkatnya persaingan bisnis toko bahan bangunan di kota Palembang membuat beberapa pelaku bisnis di bidang penjualan bahan bangunan sulit bertahan dan beberapa yang lain harus mengalami penurunan dalam penjualanannya. Oleh sebab itu, pelaku bisnis harus pintar-pintar menyiasati barang-barang apa saja yang harus distok untuk mencegah penumpukan stok barang yang tidak laku sehingga merugi. Toko Bangunan XYZ merupakan salah satu toko yang ingin mempertahankan bisnisnya. Oleh sebab itu, perlu adanya suatu aplikasi penjualan dan persediaan barang yang dapat memberikan informasi mengenai jumlah stok barang yang tersedia, dan barang yang paling laris. Metode yang digunakan dalam rancang bangun aplikasi ini menggunakan metode iterative. Pembuatan database menggunakan DBMS SQL Server serta visual basic sebagai bahasa pemrograman. Pengujian aplikasi menggunakan black box testing untuk mengetahui fungsi dan kinerja untuk setiap menu dari aplikasi. Hasilnya, aplikasi ini telah memenuhi atau telah sesuai dengan kebutuhan. Selain itu, aplikasi ini juga dapat meningkatkan kinerja dan efisiensi waktu dalam transaksi penjualan serta mengetahui stok barang terkini sehingga membantu pemilik toko bangunan XYZ mengambil keputusan dalam menyetok barang.
25
Adhi, Candra Hidayat, M. Husnul Holqi Psb, M. Basyir, Ridwan Syarif, Rizki Novri Yanda, Roni Efendi, and Hariyadi Hariyadi. "SISTEM INFORMASI PENGOLAHAN DATA MAHASISWA UNIVERSITAS MUHAMMDIYAH SUMATERA BARAT." Ensiklopedia Research and Community Service Review 1, no. 3 (August 1, 2022): 1–7. http://dx.doi.org/10.33559/err.v1i3.1230.
Full textAbstract:
Sistem Informasi Pengolahan Data Mahasiswa Universitas Muhammdiyah Sumatera Barat,Sistem pengolahan data adalah suatu kesatuan yang saling berhubungan atau terintegrasi untuk membentuk suatu sistem antara data, perangkat keras, perangkat lunak, prosedur pengolahan, dan tenaga pelaksana.Pembuatan sistem ini menggunakan metode blackbox testing karena pengujian yang dilakukan hanya mengamati hasil eksekusi melalui data uji dan memeriksa fungsional dari perangkat lunak. Jadi dianalogikan seperti kita melihat suatu kotak hitam, kita hanya bisa melihat penampilan luarnya saja, tanpa tau ada apa dibalik bungkus hitamnya. Sama seperti pengujian black box, mengevaluasi hanya dari tampilan luarnya (interfacenya), fungsionalitasnya.tanpa mengetahui apa sesungguhnya yang terjadi dalam proses detilnya (hanya mengetahui input dan output).Hasil pembuatan sistem ini menghasilkan sebuah sistem yang mampu mencegah terjadinya duplikasi data serta dapat menampilkan data yang terkait pada setiap individu,dalam pembuatan sistem ini menggunakan framework Admin Lte 2, bahasa pemrograman PHP dan DBMS XAMPP, serta untuk pemogramannya menggunakan aplikasi visual studio code. Pembuatan website ini bertujuan untuk menggantikan system yang semula menggunakan google form, digantikan dengan website pengolahan data yang dapat menampilkan data yang terkait degan setiap individuKata Kunci: Sistem Informasi, Mahasiswa, bahasa pemograman
26
Repas, Diogo, Zhicheng Luo, Maxime Schoemans, and Mahmoud Sakr. "Selectivity Estimation of Inequality Joins in Databases." Mathematics 11, no. 6 (March 13, 2023): 1383. http://dx.doi.org/10.3390/math11061383.
Full textAbstract:
Selectivity estimation refers to the ability of the SQL query optimizer to estimate the size of the results of a predicate in the query. It is the main calculation based on which the optimizer can select the least expensive plan to execute. While the problem has been known since the mid-1970s, we were surprised that there are no solutions in the literature for the selectivity estimation of inequality joins. By testing four common database systems: Oracle, SQL-Server, PostgreSQL, and MySQL, we found that the open-source systems PostgreSQL and MySQL lack this estimation. Oracle and SQL-Server make fairly accurate estimations, yet their algorithms are secret. This paper, thus, proposes an algorithm for inequality join selectivity estimation. The proposed algorithm was implemented in PostgreSQL and sent as a patch to be included in the next releases. We compared this implementation with the above DBMS for three different data distributions (uniform, normal, and Zipfian) and showed that our algorithm provides extremely accurate estimations (below 0.1% average error), outperforming the other systems by an order of magnitude.
27
Permatasari, Carolina Lita, and Dwi Iga Luhsasi. "DEVELOPMENT OF NON-PROFIT ACCOUNTING INFORMATION SYSTEMS." Media Riset Akuntansi, Auditing & Informasi 22, no. 2 (November 10, 2022): 191–212. http://dx.doi.org/10.25105/mraai.v22i2.14851.
Full textAbstract:
This research is included in information system development research. The output product of this research is an Accounting Information System. The stages used in this study adapt the waterfall model from Pressman. Implementation of web-based system development using MySQL database on PHPMyAdmin. MySQL is one of the Database Management System (DBMS). The backend development of the accounting information system of this non-profit organization focuses on system logic starting from input, process and output. Input financial transactions in cash and bank as well as transactions that affect capital excluding income and costs. Automatically processes the inputted data in the report recapitulation according to the primary key that is set. Cash, bank, and capital transaction inputs are automatically recorded in the cash, bank and capital ledger, income ledger, expense ledger, income details, expense details, cash flow, and year-end reports. The output of the inputted report is a print preview to print the report by connecting to the hardware (printer). The testing procedure in this study was carried out with 2 tests, namely white-box testing, testing of the buttons on the system and black-box testing, testing of functions or processes that occur in the system. The data obtained from the results of filling out a set of instruments in the form of a questionnaire given to experts and users to assess the feasibility of the developed system. The results of the development research state that the accounting information system for non-profit organizations is feasible to be applied. This is evidenced by the results of the validation test of material experts, technology experts, and trials to users who are in the outstanding categories. The average on the material expert validation test shows the outstanding category with a score of 4.8. Technology experts show the outstanding category with a score of 4.78. Meanwhile, the trials on users belong to the very good category with a score of 4.7.
28
Pasha Bhimasty and Endah Sudarmilah. "DONATION MANAGEMENT INFORMATION SYSTEM IN BAITUL MAAL MITRA USAHA MANDIRI USING THE WATERFALL METHOD." Jurnal Teknik Informatika (Jutif) 3, no. 5 (October 24, 2022): 1195–202. http://dx.doi.org/10.20884/1.jutif.2022.3.5.291.
Full textAbstract:
Fund management in financial institutions is a fundamental thing. Baitul Maal Mitra Usaha Mandiri as a microfinance institution plays a role in collecting and distributing donations to those in need. Data recording of receipts and distribution of donations at the Baitul Maal is still done manually where staff enter data into Microsoft Excel and send WhatsApp messages one by one, causing data not to be integrated and allowing for errors such as repeated recording, data loss, or other human errors. This problem has led to the development of a website-based donation management information system that can be accessed online. The system was built to make it easier for staff to manage financial data, make it easier for managers to monitor financial reports, and as an effort to be transparent to the public. The system was developed using the System Development Life Cycle (SDLC) waterfall model. System development is carried out using the Hypertext Preprocessor (PHP) programming language with Laravel framework and MySQL database management system (DBMS). The system was tested using black-box testing and System Usability Scale (SUS). The results of this study are the creation of a website-based Baitul Maal donation management information system that can be used to manage data on receiving and distributing donations and publishing financial reports to the public. The system has been tested using black-box testing and System Usability Scale with a test result of 80.81.
29
Murdianingsih, Yuli, and Ulfah Sitiumayah. "Sistem Rekomendasi Pembelian Sepeda Motor Bekas Menggunakan Metode Fuzzy Tahani." Jurnal ICT : Information Communication & Technology 19, no. 1 (September 9, 2020): 17–26. http://dx.doi.org/10.36054/jict-ikmi.v19i1.111.
Full textAbstract:
A used motorcycle is an option in the quest to buy a motorcycle, reliability is one factor. Accessibility means the size and the sum of the installment. Affordability is very important given the Covid-19 pandemic and economic recession, particularly in an environment of economic downturn. This research aims to establish a used motorcycle purchase recommendation system using the year's criteria for the manufacture of used motorcycles, prices, and installments in the purchase of used motorcycles, as well as to assess how high the reliability of the used motorcycle purchase recommendation system is. Firstly, twenty used motor data were obtained which were used to analyze recommendations, secondly to determine the domain size, thirdly to determine the function and degree of membership for each parameter, fourth to measure fire intensity and fifth to determine recommendations for the purchase of used motorbikes. Testing device reliability using the MAE tool. The framework was implemented using the interface MySQL DBMS and PHP. Using the Fuzzy Tahani method, the search for used motorbikes can be carried out, with the benefit of providing the installment quantity parameter and fifty-eight percent of the device reliability for buying used motorcycles. Â
30
Cornachione Jr, Edgard B. "Objective tests and their discriminating power in business courses: a case study." Revista de Administração Contemporânea 9, spe2 (2005): 80–94. http://dx.doi.org/10.1590/s1415-65552005000600007.
Full textAbstract:
Evaluating students' learning experiences outcomes cannot be considered a simple task. This paper aims at investigating students' overall performance and the discriminating power of particular tests' items in the context of business courses. The purpose of this paper is to contribute with this issue while analyzing it, with scientific approach, from an accounting information systems standpoint: two experiments based on a database management system (DBMS) undergraduate course, involving 66 and 62 students (experiments E1 and E2, respectively). The discriminant analysis generated discriminant functions with high canonical correlations (E1= 0.898 and E2= 0.789). As a result, high percentages of original grouped cases were correctly classified (E1= 98.5% and E2= 95.2%) based on a relatively small number of items: 7 out of 22 items from E1 (multiple-choice), and 3 out of 6 from E2 (short-answer). So, with only a few items from the analyzed instruments it is possible to discriminate "good" or "bad" academic performance, and this is a measure of quality of the observed testing instruments. According to these findings, especially in business area, instructors and institutions, together, are able to analyze and act towards improving their assessment methods, to be of minimum influence while evaluating students' performance.
31
Aditama, Rizky, Anita Anita, and Windarini Cahyadiana. "A Sistem Informasi Penilaian Kinerja Karyawan Pada Rumah Sakit Mitra Delima." J-INTECH 10, no. 2 (December 23, 2022): 171–80. http://dx.doi.org/10.32664/j-intech.v10i2.768.
Full textAbstract:
Rumah sakit umum Mitra Delima merupakan institusi pelayanan kesehatan masyarakat yang berada di Bululawang Malang. Salah satu upaya yang dilakukan untuk menjaga kompetensi karyawan adalah pelaksanaan penilaian kinerja yang dilakukan setiap tahun yaitu dua bulan sebelum masa kontrak kerja habis. Penilaian kinerja ini sekaligus merupakan suatu mekanisme untuk menentukan perpanjangan atau penutusan kontrak kerja karyawan. Banyaknya jumlah karyawan dan tahapanan yang harus diakukan serta banyaknya personal yang terlibat dalam proses penilaian menimbulkan keterlambatan penjadwalan dan penundaan masa kontrak kerja karyawan. Oleh karena itu tujuan dari penelitian ini adalah membangun suatu sistem informasi yang dapat membantu bagian kepegawaian untuk mendeteksi karyawan yang harus di jadwalkan untuk penilaian kinerja, menugaskan personal yang melakukan penilaian serta menginformasikan jadwal maupun hasil penilaian kerja pada karyawan maupun petugas sehingga penilaian kinerja dapat dilakukan tepat waktu dan lebih efeisien. Sistem yang dibangun berbasis web dengan menggunakan menggunakan script PHP dan framework CodeIgnater serta Mys sql sebagai DBMS. Sistem yang dibangun telah melewati tahapan ujicoba menggunakan blackbox testing dan setiap fitur telah memiliki fungsi sesuai yang dibutuhkan sehingga diharapkan dapat menjadwalkan penilaian kinerja tepat waktu dan tidak terjadi penundaan masa kontrak kerja yang tidak seharusnya.
32
Tomakova, R. A., D. K. Reutov, E. A. Astapov, S. Yu Lyakhov, and N. G. Nefedov. "Development of a Software and Information System for Testing the Emotional Sphere of a Person." Proceedings of the Southwest State University. Series: IT Management, Computer Science, Computer Engineering. Medical Equipment Engineering 13, no. 1 (May 25, 2023): 23–38. http://dx.doi.org/10.21869/2223-1536-2023-13-1-23-40.
Full textAbstract:
The purpose of research is to develop a software and information system for conducting psychological testing of the emotional sphere of a person, with the possibility of determining the diagnosis for subsequent consultation with a psychologist.Methods. To implement the software system, the C# programming language was used using libraries: Net Framework 4.7.2, ASP.NET Core. To form the tests, the methods of "Determination of emotionality" by V. V. Suvorova, express diagnostics of the tendency to affective behavior by V. V. Boyko, express diagnostics of the tendency to hyperthymia by V. V. Boyko, express diagnostics of the personal tendency to low mood (dysthymia) by V. V. Boyko, "Tendency to euphoria" by V. V. Boyko, "Determination of the state of frustration" V. V. Boyko. The input data of the program are the user's responses, and the diagnosis calculated based on the test results obtained. The MSSQL Server 2014 DBMS was used for data storage.Results. As a result of the development of the software product, the interface and architecture of the program were developed. Implemented functionality for testing according to the above methods. An algorithm has been developed designed to diagnose the psychoemotional state of the individual, in accordance with the test results obtained. In the course of the conducted studies, it was shown that the accuracy of the methods is 95%. A database has been developed to store information about users, their roles, as well as information about questions included in tests for their interaction. The test results showed that the software system fully meets the functional requirements and is ready for use.Conclusion. The developed web-service allows psychological testing of the emotional sphere of a person according to certain methods, with the possibility of determining the diagnosis for further interaction with a psychologist. The prospect of further development is to expand the functionality of the created software and information system by adding new methods of express diagnostics of psychological or emotional states of a person.
33
Tekavec, Jernej, Anka Lisec, and Eugénio Rodrigues. "Simulating Large-Scale 3D Cadastral Dataset Using Procedural Modelling." ISPRS International Journal of Geo-Information 9, no. 10 (October 11, 2020): 598. http://dx.doi.org/10.3390/ijgi9100598.
Full textAbstract:
Geospatial data and information within contemporary land administration systems are fundamental to manage the territory adequately. 3D land administration systems, often addressed as 3D cadastre, promise several benefits, particularly in managing today’s complex built environment, but these are currently still non-existent in their full capacity. The development of any complex information and administration system, such as a land administration system, is time-consuming and costly, particularly during the phase of evaluation and testing. In this regard, the process of implementing such systems may benefit from using synthetic data. In this study, the method for simulating the 3D cadastral dataset is presented and discussed. The dataset is generated using a procedural modelling method, referenced to real cadastral data for the Slovenian territory and stored in a spatial database management system (DBMS) that supports storage of 3D spatial data. Spatial queries, related to 3D cadastral data management, are used to evaluate the database performance and storage characteristics, and 3D visualisation options. The results of the study show that the method is feasible for the simulation of large-scale 3D cadastral datasets. Using the developed spatial queries and their performance analysis, we demonstrate the importance of the simulated dataset for developing efficient 3D cadastral data management processes.
34
Anik, Muhamad, Fety Fatimah, and Hersanto Fajri. "Sistem Informasi Akademik Berbasis Web Di Madrasah Aliyah Muhamadiyah Jasinga." INOVA-TIF 3, no. 1 (June 6, 2020): 19. http://dx.doi.org/10.32832/inova-tif.v3i1.4060.
Full textAbstract:
<p><em>SISTEM INFORMASI AKADEMIK BERBASIS WEB</em><em> </em><em>DI </em><em>MADRASAH ALIYAH MUHAMADIYAH JASINGA</em><em> </em><em>merupakan lembaga pendidikan yang hingga saat ini proses pencatatan data masih secara manual </em><em>dan menyebabkan MA</em><em> Muhamadiyah mengalami kesulitan dalam melakukan kegiatan mencari data siswa</em><em>,</em><em> data guru,</em><em> jadwal mata pelajaran dan transkip nilai</em><em>, </em><em>S</em><em>ehingga akan</em><em> </em><em>memperlambat kinerja </em><em>staf TU</em><em> untuk</em><em> membuat </em><em>informasi secara </em><em>cepat.</em><em> Sistem informasi akademik ini menggunakan metode waterfall yang mempunyai beberapa proses yaitu proses requirement definition, system and software design, implementation and unit testing, integration and system testing yang berfungsi sebagai rancangan pembuatan sistem untuk memenuhi kebutuhan pengguna dan sistem yang dibuat ini menggunakan DBMS (database management system) sebagai tempat penyimpanan data sekolah. Untuk mengatasi masalah tersebut perlu </em><em>adanya </em><em>suatu sistem informasi yang terkomputerisasi.</em></p>
35
Tarmuji, Ali, and Cantya Dhanurendra. "Rancang Bangun Sistem Pengukuran Indikator Pelayanan Pasien Rawat Inap Untuk Peningkatan Mutu Layanan Puskesmas Menggunakan Rumus IPRI." JURIKOM (Jurnal Riset Komputer) 9, no. 6 (December 30, 2022): 1933. http://dx.doi.org/10.30865/jurikom.v9i6.4766.
Full textAbstract:
Health agency service indicators are used to determine the level of utilization, quality, and efficiency of health agency services. The measurement of service indicators is determined by applying the correct IPRI (Indicator of Inpatient Service) method/formula. Based on the results of observations in the Medical Record unit of the Berbah Public Health Center, Sleman Yogyakarta, it was found that the delay in returning the daily inpatient census sheets affected the value of each service indicator. In addition, inaccuracy in calculating the daily inpatient census data recapitulation resulted in inaccurate data. Therefore, a computer-based inpatient service indicator measurement system is needed in order to produce a faster and more accurate value for each service indicator in inpatient services. The stages of the research carried out adopted the stages in the SDLC Waterfall method, including the first stage of communication (project initiation & requirement gathering). The second stage is planning (estimating, scheduling, tracking). The third stage of modeling (analysis & design). The fourth stage of construction (code & test). The last stage, deployment (delivery, support, feedback). The application of the IPRI method/formula in PHP coding and supported by MySQL DBMS storage is part of the construction phase which is combined with testing using the black box test and alpha test methods. The goal has been achieved with the establishment of the Service Indicator Measurement System Application based on IPRI in inpatient services at the Berbah Health Center, Sleman Yogyakarta. The system is categorized as good and feasible to use based on the results of black box testing of 84.62% true. Alpha testing obtained a very high level of acceptance (approved) of 100%. The use of this application is proven to be able to produce IPRI calculations quickly and accurately so as to improve the quality of inpatient services, especially related to the daily census, so that leaders can make decisions faster.
36
Novaliendry, Dony, and Afiful Azkia. "DESIGN OF WEB-BASED INFROMATION SYSTEM FOR THE BUNG HATTA UNIVERSITY PROFESSIONAL CERTIFICATION INSTITUTE." Jurnal Teknologi Informasi dan Pendidikan 14, no. 1 (June 18, 2021): 64–72. http://dx.doi.org/10.24036/tip.v14i1.446.
Full textAbstract:
Professional certification is an effort to recognize a person's competence by the required work competency standards. Bung Hatta University Professional Certification Institute (LSP) is an agency implementing competency certification activities that have received a license from the National Professional Certification Agency (BNSP) to certify students from various fields of science and professions at Bung Hatta University. Bung Hatta University LSP has the status of the first party LSP educational institutions. The registration process for certification at the Bung Hatta University LSP is still done manually by filling in several paper forms. This is considered ineffective considering the current technological advances. By developing a website-based information system, this can be overcome. The purpose of designing a website-based information system is to produce an information system that can assist the certification process and can be accessed by any relevant user anytime and anywhere. This information system was developed using the waterfall method. This method has several stages, namely the needs analysis, design, implementation, and testing stage. The design of this information system used Unified Modeling Language (UML) and implemented using the Yii2 framework as a PHP framework and MySQL as a Database Management System (DBMS). The design of this information system resulted in a web-based Information System for Bung Hatta University LSP, which focused on the initial administrative process.
37
Dedi Pradnya Iswara, I. Made, I. Made Arsa Suyadnya, and Putu Arya Mertasana. "APLIKASI MARKETPLACE BERBASIS SISTEM PENDUKUNG KEPUTUSAN UNTUK PEMESANAN DAN PEMASANGAN IKLAN PADA BILLBOARD DI KOTA DENPASAR." Jurnal SPEKTRUM 9, no. 1 (April 1, 2022): 72. http://dx.doi.org/10.24843/spektrum.2022.v09.i01.p9.
Full textAbstract:
Billboards are a great form of outdoor advertising. Billboards containing text or images ofinformation promoting a product are usually taken by the advertising agency. Advertisingcompanies promote curated billboards using individual websites, requiring clients to switchbetween sites to get billboards that meet the criteria. The purpose of marketplace creation is toavoid customers having to switch sites for billboards that meet the criteria. The marketplace isbuilt using Laravel 7 framework with additional features of a business intelligence system tohelp customers get billboards based on their criteria. The decision support system uses aweighted accumulation method that uses multiplication to relate the scoring criteria, where thescore of each criterion will be increased by the weight of the related criteria. The use of adecision support system with a weighted product approach as a support function on a marketsite is the use of a decision support system as a recommendation for the application market.The result of this research is that a web-based marketplace with a decision support system hasbeen successfully built using the Laravel 7 framework and MySQL DBMS. Based on the blackbox tests performed on the app, it performs according to its function and based on theoreticalcomparison testing related to the use of the weight product method, the results of therecommendations on the billboard application are in accordance with manual calculations.
38
Irawan, Ridwan Dwi, Muh Adha, Muhamad Paliya Sadana, Zitnaa Dhiaaul Kusnaa Washilatul Arba’ah, and Ema Utami. "MODELING OF THE “IDRESM” ELECTRONIC JOURNAL PUBLICATION PORTAL USING THE WATERFALL MODEL." Jurnal Teknik Informatika (Jutif) 3, no. 6 (December 26, 2022): 1539–47. http://dx.doi.org/10.20884/1.jutif.2022.3.6.349.
Full textAbstract:
The utilization of various information technologies can increase the effectiveness and efficiency of the scientific publication process. Design can realize one of the uses of Information Technology in designing an electronic journal information system is that tools can use to solve these problems. The electronic journal information system is the collection, data collection, management, and or publication of scientific journals electronically. In addition, if the correct information can accompany the selection of journals, it will increase the effectiveness of publication activities in terms of time efficiency. Therefore, to support time management must be supported by a system design that includes journal subsystem information in planning the selection of open access journals when publishing. Based on the description above, this integration system aims to assist in compiling a journal integration system design based on software requirements analysis. In addition, the system development method used is the waterfall which consists of requirement analysis, system design, implementation, testing, deployment, dan operation & maintenante. The design uses a DBMS, UML, ERD, Wireframe, and database implementation.The results indicate that the system can assist in selecting journals that are following their fields to estimate open access journals based on the estimated submission time. In addition, the integrated approach that has been successfully implemented as a system has four subsystems: the primary database, human resource system, index system, and payment system.
39
Suleman, Fitriyanti, and Wati. "Aplikasi Pemasaran Kue Tradisional Gorontalo Menerapkan User Centered Design." JSAI (Journal Scientific and Applied Informatics) 5, no. 3 (November 26, 2022): 228–35. http://dx.doi.org/10.36085/jsai.v5i3.3592.
Full textAbstract:
Masyarakat Gorontalo memiliki kebiasaan mengkonsumsi kue saat sarapan pagi dan tradisi menyediakan kue pada acara hajatan. Namun adanya kesibukan masyarakat perkotaan yang banyak beraktivitas di luar rumah untuk bekerja, sehingga membuat mereka lebih memilih untuk membeli kue ditempat-tempat penjualan kue. Berdasarkan survei saat ini kue tradisional gorontalo kurang terekspos karena semakin banyaknya kue moderen yang mulai masuk pasaran terutama di café dan restoran sehingga berdampak menurunnya pedapatan pedagang kue tradisional. Penelitian ini bertujuan untuk membantu pedagang kue tradisional gorontalo agar mendapatkan media penjualan digital guna mengahadapi persaingan bisnis diera digital ekonomi saat ini. Aplikasi dirancang berbasis website dengan menerapkan metode User Centered Design sehingga pengguna dalam setiap tahapan pengembangan sistem juga terlibat dan sistem yang dibentuk dapat digunakan sesuai dengan kebutuhan user. Parancangan aplikasi menggunakan bahasa pemograman PHP dan Pengolahan data degan DBMS MySQL, User interface sistem dibuat sederhana sehingga proses penginputan dan pengolahan data penjualan serta transaksi pemasaran lebih praktis. Akses user pada sistem dibuat untuk administrator sebagai kontrol system dan di sisi client akan dibukakan akses untuk pedagang kue tradisional dan user masyarakat sebagai pembeli atau konsumen. Hasil pengujian sistem menggunakan blackbox testing di uji pada tampilan halaman semua pengguna sistem yaitu halaman admin, halaman pedagang dan halaman user pembeli atau masyarakat, hasil uji blackbox diperoleh hasil sesuai dengan rancangan tampilan dan fungsi sistem yang diharapkan oleh pengguna sistem.
40
Zarnelly, Zarnelly. "KLASIFIKASI PERMASALAHAN AGENSTOK MENGGUNAKAN ALGORITMA NAIVE BAYES CLASSIFIER PADA PT. HPAI-PEKANBARU." Jurnal Ilmiah Rekayasa dan Manajemen Sistem Informasi 5, no. 2 (August 15, 2019): 208. http://dx.doi.org/10.24014/rmsi.v5i2.7611.
Full textAbstract:
Abstrak—Kecendrungan seseorang untuk mengakses informasi khususnya permasalahan agenstok melalui dunia maya pun menjadi semakin tinggi. Informasi merupakan hal yang sangat penting dalam kehidupan masyarakat. Salah satu sumber infomasi adalah media sosial. Klasifikasi ini ditekankan untuk data permasalahan agenstok. Pada umumnya permasalahan yang disampaikan terdiri dari beberapa kategori seperti permasalahan mengenai kesehatan, konsultasi produk dan marketing. Namun dalam membagi permasalahan kedalan kategori-kategori tersebut untuk saat ini masih dilakukan secara manual.hal ini sangat merepotkan apabila permasalahan yang ingin di unggah berjumlah banyak. Oleh karena itu, perlu adanya sistem yang bisa mengklasifikasikan permasalahan secara otomatis. Text mining merupakan metode klasifikasi yang merupakan variasi dari data mining yang berusaha menemukan pola menarik dari sekumpulan data tekstual yang berjumlah banyak. Sedangkan algoritma naive bayes classsifier merupakan logartitma pendukung utuk melakukan klasifikasi. Kategori memiliki jumlah data permasalahan yang sama dan terdiri dari 400 data permasalahan; 360 data permasalahan digunakan untuk proses training dan 40 data permasalahan digunakan untuk proses testing. Pada penelitian ini metode yang digunakan yaitu waterfall dan pengujian perfomance measure, uji black box, dan uji sistem oleh pengguna. Adapun pengujian perfomance measure memperoleh nilai akurasi 97,5%, precision 97,6%, recall 97,5% dan f-measure 97,4%. Dari hasil-hasil tersebut dapat disimpulkan bahwa sistem yang menerapkan algoritma naive bayes classifier dapat digunakan untuk mengklasifikasikan permasalahan agenstok berbasis web, dengan menggunakan bahasa pemrograman PHP dan Database Management System (DBMS) menunjukkan bahwa klasifikasi permasalahan agenstok bisa terklasifikasi secara otomatis.Kata Kunci: agenstok, akurasi, klasifikasi, naïve bayes, text mining
41
Qorik, Moh Febri Nurul, Slamin Slamin, and Priza Pandunata. "Sistem Pendukung Keputusan Seleksi Beasiswa Situbondo Unggul Menggunakan Metode Simple Additive Weighting dan Profile Matching." INFORMAL: Informatics Journal 3, no. 1 (February 25, 2019): 20. http://dx.doi.org/10.19184/isj.v3i1.9853.
Full textAbstract:
This study is about the use of simple additive weighting (SAW) and profile matching methods for the construction of information systems supporting the decision selection of scholarships. The case study of this research is the selection of superior situbondo scholarships in the Education Office of Situbondo Regency. The purpose of this study was to apply the profile matching method and SAW in resolving the problem of selecting the Situbondo Superior Scholarship recipients who had 2 aspects of assessment, namely aspects of poverty and academics which made it difficult to select scholarships, this difficulty is caused by the value of the aspect of poverty must be the smaller the difference in the value of students with the value of the scholarship it will be better while the academic value must go far beyond the minimum value, the better. The profile matching method is used to calculate the value of the aspect of poverty and SAW is used to calculate the value of the academic aspects. To determine the final results of this study using the criteria for decision-making scale determined by the District Education Office of Situbondo, one of the final methods of the method is less than 30 worth not funded, one of the final method values less than 60 is considered to be funded. The development of information systems supporting superior decision making for the Situbondo scholarship using the profile matching and simple additive weighting methods using a website-based system with system design using the SDLC waterfall model, implementation of the system using the laravel framework and program code using the hypertext pre-processor programming language (PHP ), while for managing the database using MySQL DBMS and system testing using black box and white box ( testing unit). The results of this research method of profile matching and simple additive weighting can be applied properly in a superior situbondo scholarship decision support system.
42
Telegina, M. V., I. M. Yannikov, and D. V. Pshennikova. "Development of an Expert System for Diagnostic Postcovidal Syndrome." Intellekt. Sist. Proizv. 19, no. 4 (2021): 130–37. http://dx.doi.org/10.22213/2410-9304-2021-4-130-137.
Full textAbstract:
The paper is devoted to the development of an expert system for the diagnosis of postcoid syndrome. The introduction provides basic concepts and definitions related to expert diagnostic systems. An analytical review of them is given. Due to the lack of knowledge of the problem of postcovid syndrome in the work, much attention is paid to substantiating the relevance of the issue under consideration. Based on the analysis of the considered expert diagnostic systems, it was concluded that the problem is poorly studied and its further consideration is relevant. The proposed solution provides the main functions and capabilities of the system being developed, the structural diagram of the expert diagnostic system and the description of the system architecture, provides a physical model, and describes the developed knowledge base in sufficient detail. On the basis of the developed rules of the postcovid syndrome, the rules for their scoring are formulated. When calculating the final assessment of the likelihood of diagnosis of postcovid syndrome, the likelihood of influencing the diagnosis of chronic diseases in diagnosed patients was taken into account. The calculation algorithm is described in detail. The system for diagnosing the postcovid syndrome was developed using the C# programming language, Visual Studio 2019, and implemented under the Windows OS. The data storage layer in the system is built on the basis of a modern relational DBMS - MySQL. The paper describes in detail the procedure for working with the system and the procedure for editing it. When describing the testing of the proposed diagnostic system, it is stated that the diagnostic system has passed the testing of all functions; examples of changing the rule base and editing the system are given. In conclusion, it is argued that the diagnostic system proposed by the authors will help medical specialists in determining the postcovid syndrome in patients; in particular, it helps to increase the clarity, reliability of the diagnosis and reduce the time for diagnosis.
43
Effendy, Muhammad Yusuf, Euis Nurninawati, and Ahmad Ari Setiyawan. "Design And Build A Web-Based Asset Management Information System at Pt Thamrin Telekomunikasi Network." Aptisi Transactions on Technopreneurship (ATT) 4, no. 1 (January 28, 2022): 48–58. http://dx.doi.org/10.34306/att.v4i1.233.
Full textAbstract:
Asset management is a series of activities related to identify the assets needed, identify the need for funds, acquire assets, provide logistics and maintenance support systems for assets, delete or update assets so that the objectives are effectively and efficient. At PT Thamrin Telekomunikasi Network data collection for each IT asset companies in the form of laptops, servers, network devices and peripheral devices others are done manually using Microsoft Excel. But sometimes, IT staff forgot to update data such as data on the expiration of the asset warranty period and transfer of ownership of assets, as well as marking on assets still using stickers handwritten manually. Through this research, the author aims to designing and implementing a management information systemweb-based IT assets at PT Thamrin Telekomunikasi Network. Which method used in this study include interviews, observations and studies References. The analytical method used is the PIECES method and the design method The system created is described by the UML (Unified Modeling) method Language), for application development will use the SDLC method with the Xtreme Programming model, as well as the application testing method, namely the Black Box. The final result of this research is an IT asset management system web-based programming language built with HTML and Javascript, with MariaDB as the DBMS and using Laravel and Bootstrap as a framework of PHP and CSS. It is hoped that with this application, IT asset management process at PT Thamrin Telekomunikasi Network can be run more effectively, organized and more efficiently.
44
Dmytrenko, Tetiana, Andrii Dmytrenko, and Tetyana Derkach. "The «Wooden Structures» Discipline Educational and Methodological Complex Development on the Basis Of Informational Intelligent System." International Journal of Engineering & Technology 7, no. 3.2 (June 20, 2018): 92. http://dx.doi.org/10.14419/ijet.v7i3.2.14381.
Full textAbstract:
This article is devoted to the problem of implementation of computer systems into the educational system, which will help higher educational institutions to increase the level of training professionals.The work analyzes the modern educational informational intelligent systems. It was figured out that they do not completely satisfy the educational process of students of construction specialties. It is proposed to develop a technical task to create an informational intelligent system which could provide teachers and students with effective provision and usage of educational material in the discipline “Wooden Structures”.The main tasks of the discipline, methods and methodologies of teaching this discipline are analyzed. On the basis of analysis the outline of the educational and methodical complex “Wooden Structures” was created.The system offers the possibility of self-testing and self-assessment of knowledge by the student, also the ability to control the process of revising course material.Informational intelligent system of the discipline, which is described in this work, has the principles of training openness and flexibility, individualization and interactivity. The system is implemented on the basis of SCORM standards and the concept of SMART-education.The principles of designing GUI interfaces were used for user interface designing and the most common model for creating the interface for the teacher (editor) and teacher with extended rights (administrator) was chosen.UML-models were used, charts of precedents were created, a database was developed during the system’s designing.Informational intelligent system of the educational and methodological complex of the discipline “Wooden structures” is based on the language of PHP-7, DBMS, Open Server, CMS Wordpress.
45
Ma, Pingchuan, and Shuai Wang. "MT-teql." Proceedings of the VLDB Endowment 15, no. 3 (November 2021): 569–82. http://dx.doi.org/10.14778/3494124.3494139.
Full textAbstract:
Natural Language Interface to Database (NLIDB) translates human utterances into SQL queries and enables database interactions for non-expert users. Recently, neural network models have become a major approach to implementing NLIDB. However, neural NLIDB faces challenges due to variations in natural language and database schema design. For instance, one user intent or database conceptual model can be expressed in various forms. However, existing benchmarks, using hold-out datasets, cannot provide thorough understanding of how good neural NLIDBs really are in real-world situations and its robustness against such variations. A key difficulty is to annotate SQL queries for inputs under real-world variations, requiring considerable manual effort and expert knowledge. To systematically assess the robustness of neural NLIDBs without extensive manual effort, we propose MT-Teql, a unified framework to benchmark NLIDBs against real-world language and schema variations. Inspired by recent advances in DBMS metamorphic testing, MT-Teql implements semantics-preserving transformations on utterances and database schemas to generate their variants. NLIDBs can thus be examined for robustness utilizing utterances/schemas and their variants without requiring manual intervention. We benchmarked nine neural NLIDBs using 62,430 inputs and identified 15,433 defects. We analyzed potential root causes of defects and conducted a user study to show how MT-Teql can assist developers to systematically assess NLIDBs. We further show that the transformed (error-triggering) inputs can be used to augment popular NLIDBs and eliminate 46.5%(±5.0%) errors made by them without compromising their accuracy on standard benchmarks. We summarize lessons from this study that can provide insights to select and design NLIDBs that fit particular usage scenarios.
46
Afuan, Lasmedi, Nurul Hidayat, and Siti Nurhayati. "Aplikasi untuk Mengenerate dan Pengiriman Sertifikat Webinar di Masa Pandemi Corona Virus Disease 19." Jurnal Teknologi Informasi dan Ilmu Komputer 8, no. 4 (July 22, 2021): 735. http://dx.doi.org/10.25126/jtiik.2021844984.
Full textAbstract:
<p>Pandemi <em>Coronavirus Disease</em> (COVID-19) terjadi di lebih dari 200 negara termasuk Indonesia, telah mengubah kebiasaan masyarakat dalam berkomunikasi dan berinteraksi. Covid-19 memaksa masyarakat untuk berkomunikasi dan berinteraksi secara <em>online</em> dengan menggunakan <em>platform</em> seperti <em>Zoom</em>, <em>Google-meet</em>, <em>Webex</em>, dan <em>platform</em> lainnya. Salah satu sektor yang mengalami dampak yang mengharuskan berkomunikasi dan berinteraksi secara <em>online</em> adalah sektor pendidikan, hal tersebut bertujuan untuk mencegah penyebaran dan penularan Covid-19. Salah satu kegiatan di sektor pendidikan yang harus dilaksanakan secara <em>online</em> adalah seminar. Seminar yang dilaksanakan secara <em>online</em> di masa pandemi Covid-19 ini dikenal dengan sebutan Webinar. Pada webinar, pengelola webinar menghadapi permasalahan setelah pelaksanaan webinar yaitu bagaimana men<em>generate</em> dan mengirimkan sertifikat kepada peserta webinar secara massal. Penelitian ini telah mengembangkan aplikasi berbasis web yang diberi nama Cobinar. Cobinar merupakan aplikasi yang digunakan untuk membantu pengelola webinar dalam mengatasi permasalahan yang berkaitan <em>generate</em> dan pengiriman sertifikat massal kepada peserta webinar. Aplikasi Cobinar dikembangkan dengan menggunakan bahasa pemrograman PHP dan menggunakan <em>Database Management System (</em>DBMS) MySql. Sedangkan metode pengembangan perangkat lunak yang digunakan adalah <em>Waterfall.</em> Berdasarkan hasil uji coba, aplikasi Cobinar ini mampu men<em>generate</em> dan mengirimkan sertifikat ke peserta webinar dengan lebih efektif dan efisien, hal ini dapat dilihat dari hasil pengujian menggunakan <em>User Acceptance Test</em> (UAT) yang menyatakan bahwa 95 persen pengguna menyatakan bahwa aplikasi Cobinar mudah untuk dijalankan. Kontribusi utama dari penelitian ini adalah pengembangan sebuah aplikasi yang dapat digunakan oleh pengelola webinar untuk men<em>generate</em> dan mengirimkan sertifikat webinar kepada peserta.</p><p> </p><p><em><strong>Abstract</strong></em></p><p><em>The Coronavirus Disease (COVID-19) pandemic occurred in more than 200 countries, including Indonesia, which has changed people's habits in communicating and interacting. Covid-19 forces people to communicate and interact online using Zoom, Google-meet, Webex, and other platforms. One sector that has experienced the impact of communicating and interacting online is the education sector, which aims to prevent the spread and transmission of Covid-19. One of the activities in the education sector that must be carried out online is a conference. This conference, which was held online during the Covid-19 pandemic, is known as a Webinar. The webinar manager faced a problem after the webinar, namely, how to generate and send certificates to webinar participants. This research has developed a web-based application called Cobinar. Cobinar is an application used to assist webinar managers in overcoming problems related to generating and sending mass certificates to webinar participants. The Cobinar application was developed using the PHP programming language and using the MySql Database Management System (DBMS). While the software development method used is Waterfall. The Cobinar application can generate and send certificates to webinar participants more effectively and efficiently based on testing. It can be seen from the results of testing using the User Acceptance Test (UAT), which states that 95 percent of users state that the Cobinar application is easy to operate. The main contribution of this research is the development of an application that webinar administrators can use to generate and send webinar certificates to participants.</em></p>
47
Kurniadi, Dede, Asri Mulyani, Marshal Firmansyah, and Nia Abania. "Sistem Informasi Geografis Pemetaan Data Terpadu Kesejahteraan Sosial di Kabupaten Garut." Jurnal Teknologi Informasi dan Ilmu Komputer 9, no. 6 (December 22, 2022): 1307. http://dx.doi.org/10.25126/jtiik.2022956098.
Full textAbstract:
<p class="Abstrak">Dinas Sosial Kabupaten Garut berusaha dalam meningkatkan pelayanannya kepada masyarakat terutama dalam transparansi jumlah Data Terpadu Kesejahteraan Sosial (DTKS) per Kecamatan di Kabupaten Garut. Tetapi Dinas Sosial Kabupaten Garut saat ini belum mempunyai sistem informasi geografis yang menyediakan informasi jumlah DTKS per Kecamatan di Kabupaten Garut kepada masyarakat. Tujuan dari penelitian ini membangun sistem informasi geografis pemetaan data terpadu kesejahteraan sosial untuk memudahkan masyarakat mengetahui informasi jumlah DTKS per Kecamatan di Kabupaten Garut dengan memanfaatkan Teknologi Sistem Informasi Geografis (SIG). Metode yang digunakan adalah <em>Rapid Application Development (RAD)</em>, dengan menggunakan tiga tahapan yaitu <em>requirements planning, RAD design workshop, </em>dan<em> implementation</em>. Bahasa pemrograman yang digunakan <em>PHP </em>dengan<em> DBMS MySQL</em>, dan <em>Leaflet JavaScript Library</em>. Penelitian ini menghasilkan Sistem Informasi Geografis Pemetaan Data Terpadu Kesejahteraan Sosial di Kabupaten Garut yang memiliki fitur peta DTKS kecamatan, pencarian data, fitur <em>login super admin </em>dan<em> admin</em>, serta fitur pengelolaan semua data oleh <em>admin</em> dan <em>super admin</em>. Penggunaan Metode RAD telah berhasil mengefektifkan waktu dalam pembangunan SIG ini, disamping hal tersebut hasil penilaian <em>blackbox testing </em>menunjukan hasil pengujian<em> </em>telah memenuhi semua hasil yang diharapkan oleh pengguna pada kebutuhan fungsional, dengan hasil tersebut diharapkan dapat memudahkan masyarakat untuk mengetahui informasi dan memeriksa status terdaftar di DTKS salah satunya melalui fitur pencarian data berdasarkan NIK (Nomor Induk Kewarganegaraan).</p><p class="Abstrak"> </p><p class="Abstrak"><em><strong>Abstract</strong></em></p><p class="Abstract"><em>The Garut Regency Dinas Sosial is trying to improve its services to the community, especially in the transparency of the amount of Social Welfare Integrated Data (DTKS) per District in the Garut Regency. However, the Garut Regency Dinas Sosial currently does not have a geographic information system that provides information on the number of DTKS per sub-district in the Garut Regency to the public. This study aims to build a geographic information system for integrated social welfare data mapping to make it easier for the public to find information on the number of DTKS per sub-district in Garut Regency by utilizing Geographic Information System (GIS) technology. The method used is Rapid Application Development (RAD), using three stages, namely requirements planning, RAD design workshop, and implementation. The programming language used is PHP with MySQL DBMS and Leaflet JavaScript Library. This research resulted in a Geographical Mapping Information System for Social Welfare Integrated Data in Garut Regency, which features a sub-district DTKS map, data search, super admin and admin login features, and features for managing all data by admin and super admin. The RAD method has succeeded in streamlining time in the construction of this GIS. In addition to this, the results of the BlackBox testing assessment show that the test results have met all the results expected by users on functional requirements, with these results expected to make it easier for the public to find information and check the registered status in DTKS, one of which is through the data search feature based on NIK (Citizenship Identification Number).</em></p><p class="Abstrak"><em><strong><br /></strong></em></p>
48
Mulyani, Fitri, Suratun Suratun, and Puspa Eosina. "SISTEM PENDUKUNG KEPUTUSAN LOMBA KINERJA KELURAHAN DENGAN METODE AHP DI KOTA BOGOR." INOVA-TIF 1, no. 2 (December 3, 2018): 67. http://dx.doi.org/10.32832/inova-tif.v1i2.5444.
Full textAbstract:
<p>Badan Pemberdayaan Masyarakat dan Keluarga Berencana (BPMKB) Kota Bogor setiap tahunnya melaksanakan lomba kinerja kelurahan melalui proses perlombaan kelurahan, yaitu untuk mengevaluasi tingkat keberhasilan pembangunan dikelurahan dengan kriteria-kriteria tertentu dalam penyeleksiannya. Berdasarkan hasil wawancara dan observasi lapangan penyelenggaraan perlombaan dilakukan melalui tiga jenis seleksi yaitu seleksi administrasi, seleksi presentasi (ekspos) dan seleksi kunjungan lapang dengan mengacu pada Peraturan Menteri Dalam Negeri nomor 13 tahun 2007 tentang penyelenggaraan perlombaan desa dan kelurahan. Untuk seleksi administrasi sudah ada aturan dan sistem tersendiri untuk menghitung hasil skor penilaian, sedangkan dalam penentuan penetapan pemenang lomba kinerja kelurahan dinilai pada seleksi presentasi dan kunjungan lapang masih menghitung secara manual sehingga dibutuhkan Sistem pendukung Keputusan (SPK) yang mampu memberikan solusi alternatif untuk penilaian presentasi dan kunjungan lapang. Metode yang digunakan dalam sistem pendukung keputusan lomba kinerja kelurahan menggunakan metode <em>Analytical Hierarchy Process </em>(AHP) untuk pembobotan kriteria dan alternatif. Perancangan SPK lomba kinerja menggunakan Model SDLC. Model SDLC terdiri atas perencanaan, analisis, perancangan, implementasi, pengujian, dan pemeliharaan. SPK menggunakan 3 jenis hak akses (roles) yaitu admin, juri dan pimpinan. Keluaran sistem disajikan dalam bentuk hasil angka perhitungan AHP yang dapat dipertimbangkan lebih lanjut oleh pihak pengambil keputusan. Sistem pendukung keputusan dibangun menggunakan <em>Database Managament System </em>(DBMS) MySQL Xampp dan bahasa pemrograman PHP. Pengujian sistem menggunakan <em>Black-Box Testing</em>. Berdasarkan hasil perhitungan diperoleh hasil perhitungan bobot kriteria yaitu : 0,1667 untuk kriteria penguasaan materi ekspos, 0,0556 untuk kriteria penampilan pemberi materi ekspos, 0,1111 untuk kriteria ketepatan waktu ekspos, 0,2222 untuk kriteria produk unggulan, dan 0,4444 untuk kriteria inovasi , sedangkan hasil perhitungan alternatif urutan ranking terbaik yaitu kelurahan Menteng, kelurahan Cibadak, kelurahan Ciparigi, kelurahan Katulampa, kelurahan Cikaret, dan kelurahan Babakan Pasar.</p>
49
Ipo, Ego Suparius, Yus Shova, and M. Azhar Irwansyah. "Rancang Bangun Sistem Informasi Geografis Persebaran Bengkel, Tambal Ban dan Minyak Eceran di Kota Pontianak Berbasis Web." Jurnal Sistem dan Teknologi Informasi (JustIN) 11, no. 1 (January 31, 2023): 119. http://dx.doi.org/10.26418/justin.v11i1.47917.
Full textAbstract:
Meningkatnya jumlah kendaraan bermotor memunculkan masalah kemacaten khususnya di perkotaan termasuk Kota Pontianak. Dari sisi pengendara kendaraan bermotor pasti pernah mengalami masalah saat berkendara seperti kehabisan bensin, ban bocor, mogok, kerusakan kendaraan dan sebagainya. Saat mengalami masalah di jalan, misalnya kehabisan bensin atau ban bocor, maka pengendara sangat memerlukan informasi dimana lokasi pom bensin dan bengkel. Jika masalah tersebut terjadi pada malam hari dimana pom bensin dan bengkel sudah tutup maka pengendara memerlukan informasi kios bensin eceran atau bengkel yang masih buka untuk mendapatkan bantuan. Untuk membantu mengatasi masalah yang dihadapi pengendara maka dibangunlah sistem informasi geografis persebaran bengkel, tambal ban dan minyak eceran di Kota Pontianak yang dapat memberikan petunjuk arah jalan serta informasi yang berguna bagi pengendara. Sistem yang dibangun ini sangat penting mengingat data bengkel kecil, kios tambal ban, dan kios bensin eceran belum tersedia atau belum dikelola oleh Google yang selalu menjadi sumber untuk mencari informasi. Sistem ini didesain untuk memudahkan pihak pengguna (pengendara) mencari lokasi layanan terdekat dengan lokasi/posisi keberadaannya dengan menerapkan layanan berbasis lokasi (location based service/LBS) yang disediakan Google Maps. Data lokasi layanan (bengkel, tambal ban, dan minyak eceran) diperoleh dari hasil survey lapangan dan dikelola menggunakan DBMS MySQL. Dengan LBS dan Haversin Formula sistem dapat menghitung jarak radius serta menampilkan lokasi layanan terdekat dan rute perjalanan ( google direction) menuju lokasi layanan tersebut. Berdasarkan hasil pengujian black box testing dengan menggunakan nilai jarak radius tetap (default) maupun nilai jarak radius yang ditentukan oleh pengguna, sistem mampu menunjukkan lokasi layanan tersebut. Sementara berdasarkan pengujian user acceptance test (UAT) dengan menggunakan metode kuesioner skala likert diperoleh nilai rata-rata 83,4%, yang menunjukan bahwa aplikasi mudah untuk digunakan.Kata kunci: sistem informasi geografis, bengkel, tambal ban, minyak eceran, petunjuk arah, skala likert.
50
Putra, Mardi Yudhi, and Jafar Shadiq. "Sistem Informasi Penerimaan Siswa Baru pada SMK Bekasi Berbasis Website." BINA INSANI ICT JOURNAL 7, no. 1 (June 28, 2020): 43. http://dx.doi.org/10.51211/biict.v7i1.1335.
Full textAbstract:
Abstrak: Sekolah Menengah Kejuruan masih menjadi favorit para siswa dalam menimba ilmu pengetahuan dibangku sekolah, salah satu yang menjadi alasannya adalah biaya yang terjangkau. Hal ini dibuktikan dengan semakin bertambahnya siswa SMK yang ada pada kota Bekasi sehingga pihak sekolah membutuhkan peningkatan pelayanan yang cepat tanggap yang didukung dengan teknologi informasi, ruang belajar yang nyaman dan pendidik yang profesional. Seiring dengan bertambahnya jumlah siswa membuat pihak sekolah kesulitan dalam mengelola data siswa yang mendaftar secara akurat sampai dengan proses pembuatan laporan yang membutuhkan waktu yang lama. Pada saat penerimaan siswa baru pihak sekolah masih menggunakan sistem manual yakni calon siswa mengisi kertas formulir yang diberikan panitia pendaftaran. Berdasarkan permasalahan yang dihadapi maka tujuan dari penelitian ini adalah membantu pihak sekolah mengelola data siswa dalam proses penerimaan siswa baru menggunakan website yang mana dapat diakses melalui smartphone sehingga kegiatan penerimaan dapat berjalan dengan efektif. Metode yang digunakan pada penelitian ini adalah metode Waterfall karena dianggap memiliki tahapan yang terurut atau sekuensial yaitu analisis kebutuhan, desain, pengkodean, pengujian dan pemeliharaan. Sedangkan bahasa pemrograman untuk membangun sistem menggunakan PHP dengan CodeIgniter web framework, karena dianggap dapat mempermudah dan mempercepat proses pembangunan aplikasi yang memiliki banyak library dan DBMS yang digunakan menggunakan mysql yang kompatibel dalam pembangunan aplikasi berbasis website. Hasil penelitian ini berupa sistem informasi penerimaan siswa baru berbasis web menggunakan framework codeigniter sehingga dapat membantu mempermudah siswa dalam mendaftar dan pihak sekolah dalam melakukan kegiatan penerimaan siswa baru secara online.
Kata kunci: penerimaan siswa baru, sistem informasi, metode waterfall
Abstract: Vocational High School is still a favorite of students in studying at school, one of the reasons is the affordable cost. This is evidenced by the increasing number of vocational students in the city of Bekasi so that the school needs an increase in responsive services that are supported by information technology, comfortable learning spaces and professional educators. As the number of students increases, it is difficult for schools to manage the data of students who register accurately up to the process of making reports that require a long time. At the time of admission of new students the school still uses a manual system where the prospective student fills out the paper form provided by the registration committee. Based on the problems faced, the purpose of this study is to help the school manage student data in the process of admitting new students using a website which can be accessed via a smartphone so that the reception activity can run effectively. The method used in this study is the Waterfall method because it is considered to have sequential or sequential stages namely requirements analysis, design, coding, testing and maintenance. While the programming language for building systems using PHP with CodeIgniter web framework, because it is considered to be able to simplify and accelerate the process of building applications that have lots of libraries and DBMS that are used using mysql that are compatible in building website-based applications. The results of this study in the form of a web-based new student admission information system using a codeigniter framework so that it can help facilitate students in registering and the school in conducting new student admission activities online.
Keywords: new student admissions, information systems, waterfall methods