Failure in the process of loading data from the Online Transactional Processing(OLTP) system to the Normalized Data Store (NDS) database can occur. This caused by a disruption in the network so that ...the OLTP system is unable to save data to the OLTP and NDS databases. Backup and synchronization data scenarios are needed to maintain data consistency and data availability. In this research, the process of data backup and synchronization is done by providing an identity column for the table in the OLTP database. An identity column is used to give status data, value '0' if the inserting process fails, and value '1' if successful. Data backup is done by storing temporary data into a CSV file format, then the CSV file is read, and an insert process is carried out into the OLTP database. After the insertion process into the OLTP database is successful, it continues with the synchronization process between the OLTP database and the NDS. Data synchronization between OLTP and NDS databases is done by checking the value of the Identity Column in each table in the OLTP database.
Updates the data in the data warehouse is not traditionally done every transaction. Retail information systems require the latest data and can be accessed from anywhere for business analysis needs. ...Therefore, in this study will be made data warehouse model that is able to produce the information near real time, and can be accessed from anywhere by end users application. Modeling design integration of nearly real time data warehouse (NRTDWH) with a service oriented architecture (SOA) to support the retail information system is done in two stages. In the first stage will be designed modeling NRTDWH using Change Data Capture (CDC) based Transaction Log. In the second stage will be designed modeling NRTDWH integration with SOA-based web service. Tests conducted by a simulation test applications. Test applications used retail information systems, web-based web service client, desktop, and mobile. Results of this study were (1) ETL-based CDC captures changes to the source table and then store it in the database NRTDWH with the help of a scheduler; (2) Middleware web service makes 6 service based on data contained in the database NRTDWH, and each of these services accessible and implemented by the web service client.
PT Arpan Bali Utama as an industrial company must always be responsive to the company's needs, because the company's production supplies the existing inventory. In this study, the design of an ...inventory information system for stock opname and warehouse card activities at PT Arpan Bali Utama. The design of this inventory information system is intended to solve problems related to the management of stock opname data and warehouse cards, both in data input and in computerization of stock opname reports and warehouse cards. This system was developed using the Visual Basic for Applications (VBA) programming language and a database developed using the Microsoft Access 2016 application. The results obtained from this study are an inventory information system designed to assist accounting and warehouse departments in carrying out stock opname activities. data input, data search, and production of stock opname reports and warehouse cards. In addition, this system can also help the accounting department through warehouse cards to see the movements of goods in the warehouse.
Image segmentation is a very important process in object detection. The segmentation process becomes a critical determinant of the success of object detection. Various methods have been developed for ...this image segmentation process, but there is no general solution that can be applied. Associated with object detection, the image segmentation method based on color dissimilarity turns out to be able to give good results. This segmentation method divides the image based on the dissimilarity of the values of R, G and B on the adjacent image pixels. Color is considered different if the difference in the values of R, G and B of this pixel pair produces a Delta E value whose value exceeds the threshold that is able to distinguish eyes. If this comparison shows the color dissimilarity detected, the pixel is changed to white, and the resulting image is then converted into a black-and-white image. From the resulting segmentation space, the bounding box is then made. Based on this bounding box, then the object can be detected properly. The results of object detection shown by this method are very good. The weakness of this model is not being able to detect objects that overlap one another.
Information technology developments are beneficial to businesses worldwide, particularly in Indonesia. Businesses that use information technology effectively can store and manage data, expedite ...business operations, and manage data. Information systems used in accounting are one area where technology is crucial. The purpose of this project is to develop and construct an information system application for the UD Kelambi Anyar clothing firm that will be used for financial report preparation and worker salary payment. For worker salaries, this company historically used manual records, which presented a number of challenges including the possibility of errors, information delays, and difficulty in finding data. This application was developed using the Software Development Life Cycle (SDLC) approach using the Waterfall paradigm. Planning, analyzing, designing, implementing, testing, and implementing are the stages of system development. Microsoft Access 2019 was used to create the database for this application, while Visual Basic Applications (VBA) was used to write the code. An information system application that facilitates the recording of worker service payments and the preparation of financial reports, such as profit and loss statements and balance sheets, is the outcome of this research project for UD Kelambi Anyar. In addition to a filter menu to make data searching for employee salary reports easier, this program has a username and password feature to ensure user security. It is envisaged that using this application will improve the financial transaction process' accuracy and efficiency and speed up the process of making management choices.
This study examines the effectiveness of implementing a project performance-based employee incentive system at a state-owned construction company in Indonesia, PT PP (Persero) Tbk. The data were ...analyzed using a quantitative approach, with the Key Performance Indicator (KPI) for each project before and after the implementation of the project performance-based incentive system. The data was tested using the Wilcoxon test to see if there were statistical differences in project performance before and after the implementation of the project performance-based employee incentive system. The results show that there are statistically significant differences in project KPIs before and after the implementation of the project performance-based employee incentive system. The project KPIs show a higher average value than before the implementation of this system. This research contributes especially for construction companies regarding the pros and cons of implementing a project performance-based incentive system because it is proven to be effective in motivating employees in increasing the average performance of their projects which affect the company's overall performance.