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.
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.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.