Transaction File Research Articles

Rancang Bangun Sistem Informasi Pengarsipan di PLN Rayon Rancaekek

In today's era, information systems are an important factor in a company, one of which is in the field of archiving. Archiving at the State Electricity Company (SEC) Rayon Rancaekek still uses a semi-computerized method, which raises several problems, namely difficulty in finding data, not yet integrated transaction files with reports so that reports cannot be generated automatically, the length of the data calculation process because it is still done manually, there is a risk of data being double input and deleted, as well as lost or damaged documents. The purpose of this final project is to simplify data retrieval, integrate transaction files with reports so that reports can be presented after the transaction process, streamline the calculation of archived data, avoid double input and deleted data, and anticipate lost or damaged documents. The research and system development method used is the System Development Life Cycle (SDLC) with the Waterfall model. This system is made using Microsoft Visual FoxPro 9.0 and FoxPro database. System analysis and design tools used in this final project are Flow map, Data Flow Diagram (DFD), Entity Relationship Diagram (ERD), database relation schema, and Structure Chart. With the system design made, it can be concluded that the search for archive data becomes easier, all files are integrated so that reports can be presented at any time, the data calculation process can be carried out more effectively, double input data and the risk of data loss can be anticipated, as well as loss and damage data can be anticipated.

Stackable Transactional File System Using Kernel-Level WAL

User applications that require transactional file access generally use user-level transactional protocols such as logging, atomic rename, since the POSIX interface does not support transactional file operations. The user-level protocols are complex and require specific persistence properties of file systems for correctness. If the kernel provides transactional access to file data, application developers can avoid the complex and error-prone application-level protocols. Many previous studies on kernel-level transactional support have several critical limitations such as complex APIs, file system-dependence, and low transaction concurrency. In this paper, we propose a kernel-level write-ahead logging (WAL) technique, called KWAL. KWAL maintains user-transparent WAL files and redirects transactional IOs to them. Since KWAL is implemented as a stackable file system, it can be mounted over any native file systems, without modifying them. To provide a higher transaction concurrency while guaranteeing isolation, KWAL supports byte-level write conflict detection and repeatable read isolation. We also utilize a block remap technique to resolve the duplicate write problem of WAL-based transaction scheme. To demonstrate the usefulness of KWAL, we implemented a simple key-value store using KWAL APIs, fixed the wrong transaction implementation of the Git application, and simplified the implementation of the storage engines of MySQL and SQLite.

The impact of cognitive style on the level of satisfaction and image search behavior in the textual and content search system of Google Images

PurposeThe purpose of this study aims to identify the impact of verbal-visual cognitive styles on the level of satisfaction and behavior in the textual and content search of Google Images.Design/methodology/approach“Riding” cognitive style test and satisfaction questionnaire were used as data collection tools. Also, to collect data related to the image search behavior, the subjects’ transaction files were recorded using Camtasia software and then the files observed and reviewed. The research sample was 90 postgraduate students of Shiraz University.FindingsThe results showed that cognitive styles in interaction with the text-based and content-based search system of “Google Images” affected user’s satisfaction. Text-based image retrieval, in which vocabulary-based information needs were expressed, was more compatible with the verbal cognitive style and resulted in greater satisfaction. In contrast, in content-based image retrieval, where it was possible to express information needs in the form of images, users were more satisfied with the visual cognitive style. Verbal users performed more positively in text-based search and visual users in content-based search.Originality/valueConsidering the research gap, which has identified the performance of visual text-based and content-based systems in terms of satisfaction and cognitive style search behavior, the present study could be considered a small effort to promote science.

SISTEM INFORMASI MONITORING TRANSAKSI PADA KANTOR PERWAKILAN BANK INDONESIA PROVINSI LAMPUNG BERBASIS WEB

The information system of transaction monitoring at the Representative Office of Bank Indonesia in the Lampung Province is a system that aims to provide features in accordance with the needs of related information systems such as managing transaction data, monitoring transaction files, and verifying transaction data. The system development process uses the extreme programming method, and in the system testing process uses black box testing and user acceptance tests. Initial data collection was carried out by conducting observations and interviews with Bank Indonesia employees in Lampung Province to obtain functional requirements related to user stories, and to obtain system acceptance criteria or user acceptance criteria. System functionality testing is carried out using the black box testing method, while system acceptance testing is carried out using the user acceptance test method. Based on the black box testing, and the user acceptance test, the entire functional system has been accepted, and can be used at the Bank Indonesia Representative Office, Lampung Province.

TxFS

We introduce TxFS, a transactional file system that builds upon a file system’s atomic-update mechanism such as journaling. Though prior work has explored a number of transactional file systems, TxFS has a unique set of properties: a simple API, portability across different hardware, high performance, low complexity (by building on the file-system journal), and full ACID transactions. We port SQLite, OpenLDAP, and Git to use TxFS and experimentally show that TxFS provides strong crash consistency while providing equal or better performance.

Reconciling Parent-Child Relationships across US Administrative Datasets

IntroductionPopulation data capture children, parents, relatives, and others moving in and out of households. The U.S. has seen falling marriage rates, and increases in multigenerational households and complex families, young children living with grandparents, and adult children living with parents. Robust parent-child linkages are critical to understand these demographic shifts.
 Objectives and ApproachWe construct and validate parent-child linkages over a century to observe how U.S. households are changing over time. The three largest person-based datafiles in the U.S. are the decennial censuses, the Social Security Administration transaction file, and individual tax returns from the Internal Revenue Service. These sources operationalize relationships differently, capture data at various frequencies, and gather the data for unique purposes. We use probabilistic matching to observe and reconcile parent-child relationships across these sources. The data include a variety of personal identifiers including name, date of birth, parents’ names, address, and place of birth that support matching and validation.
 ResultsWe find that understanding the content, consistency, and coverage of the files before matching is critical for high quality linkages. The representativeness of the parent-child relationship file improves over time, with the weakest coverage for the Greatest Generation and the strongest coverage for Millennials. Coverage varies by source: tax data underrepresent non-white children and have duplicate records for SSNs, while names and dates of birth are missing from Census data. Multiple match rates differ among demographic groups and over time. In the matching process, the blocking variables rely on common variables across the population datasets. Our approach provides robust entity resolution for women, despite married-maiden name changes. We describe challenges due to data problems in old census records and validation changes in social security data.
 Conclusion/ImplicationsWe conduct a successful reconciliation of parent-child relationships in U.S. population level files. The project supports operational and research uses, such as the 2020 Census. We will extend this work using graph matching and will expand the method to validate other relationship links including spouses and siblings.

Efficient Free Space Reclamation in WAFL

NetApp ® WAFL ® is a transactional file system that uses the copy-on-write mechanism to support fast write performance and efficient snapshot creation. However, copy-on-write increases the demand on the file system to find free blocks quickly, which makes rapid free space reclamation essential. Inability to find free blocks quickly may impede allocations for incoming writes. Efficiency is also important, because the task of reclaiming free space may consume CPU and other resources at the expense of client operations. In this article, we describe the evolution (over more than a decade) of the WAFL algorithms and data structures for reclaiming space with minimal impact to the overall performance of the storage appliance.

Pharmacologic Management of Non-Cancer Pain Among Nursing Home Residents

ContextPain is common in nursing home settings. ObjectivesTo describe scheduled analgesic use among nursing home (NH) residents experiencing non-cancer pain and evaluate factors associated with scheduled analgesic use. MethodsWe identified 2508 residents living in one of 185 NHs predominantly from one for-profit chain, with pain recorded on two consecutive Minimum Data Set assessments. Pharmacy transaction files provided detailed medication information. Logistic regression models adjusted for clustering of residents in NHs identified factors related to scheduled prescription analgesics. ResultsTwenty-three percent had no scheduled analgesics prescribed. Those with scheduled analgesics were more likely to have excruciating pain (5.5% vs. 1.2%) and moderate pain documented (64.7% vs. 47.5%) than residents without scheduled analgesics. Hydrocodone (41.7%), short-acting oxycodone (16.6%), and long-acting fentanyl (9.4%) were common, and 13.8% reported any nonsteroidal anti-inflammatory agent use. Factors associated with decreased odds of scheduled analgesics included severe cognitive impairment (adjusted odds ratio [AOR] 0.56; 95% confidence interval [CI] 0.36 to 0.88), age more than 85 years (AOR 0.57; 95% CI 0.41 to 0.80), and Parkinson's disease (AOR 0.55; 95% CI 0.30 to 0.99). Factors associated with increased odds of scheduled analgesic use included history of fracture (AOR 1.79; 95% CI 1.16 to 2.76), diabetes (AOR 1.30; 95% CI 1.02 to 1.66), and higher Minimum Data Set mood scores (AOR 1.11; 95% CI 1.04 to 1.19). ConclusionSome improvements in pharmacologic management of pain in NHs have been realized. Yet, presence of pain without scheduled analgesics prescribed was still common. Evidence-based procedures to assure adherence to clinical practice guidelines for pain management in this setting are warranted.

Aussenwirtschaftsrecht and corporate investments in Germany – new hurdles for foreign investors

The newAussenwirtschaftsrechtgenerates new insecurity with regards to M&A transactions: On the one hand every industry may be affected by a prohibition, whereas certain sectors (telecommunications, energy incl. oil or natural gas, universal postal services, railway nets, banks, pharmaceutical industry or chemicals industry) are presumably of special importance. On the other hand, vendors should preventively ask any potential buyers from abroad but also German based prospects (given the fact that external investors could be one of their main shareholders) for a written declaration that they comply with the new law or that they have received anUnbedenklichkeitsbescheinigungfrom the BMWi. Additionally, investors from outside the EU or EFTA seeking to purchase of at least 25 percent of a German enterprise should consider anUnbedenklichkeitsbescheinigungat an early stage, ideally in combination with passing on the complete transaction files to the BMWi. Only in this way is a high level of legal and transaction safety possibly achieved. Conversely, investors prepared to risk of prohibtion and considering the intended purchase as unproblematic should desist from an announcement to the BMWi but bear in mind that theBaFinor theBundeskartellamtcould inform the BMWi, thereby triggering an assessment.Due to the new law, the BMWi will get an improved overview of planned or ongoing M&A transactions in Germany, given that many investors or vendors will apply for anUnbedenklichkeitsbescheinigungas a precaution. But the German state gains this increased level of regulation only through significant administrative efforts.

Forensic analysis of the Firefox 3 Internet history and recovery of deleted SQLite records

Firefox 3 uses a new system, based on various SQLite databases, to store Internet history, bookmarks, form field data and cookies. This paper presents the main properties of these databases, what fields are of forensic interest and what information the available tools can extract. It shows that even if records in these databases are deleted, remnants may be found in unallocated disk space, due to the fact that SQLite utilizes temporary transaction files. The paper proposes an algorithm to recover deleted SQLite entries based on known internal record structures. The tool developed can recover deleted history records and the methodology applied in this work can be used with other applications that also employ SQLite databases.

Toward supporting real-time mining for data residing on enterprise systems

As data mining techniques are explored extensively, incorporating discovered knowledge into business strategies gives superior competitive advantage to corporations. Most techniques in mining association rules nowadays are designed to solve problems based on transaction files transformed to horizontal or vertical format. Namely, the transaction-normalized tables should be transformed before such methods could be applied, and some previous works have pointed out that such tasks of performing data transformation usually consume a lot of resources. As a result, traditionally, data mining technique has seldom being applied in real-time. However, in many cases, the decisions have to be made in a short time, such as the decisions of promoting fresh agriculture goods in retailing stores should be made daily and in the limit of one or two hours. This study therefore proposes a new method which incorporates mining algorithms with enterprise transaction databases directly to perform real-time mining. In addition, the proposed method has following advantages to support real-time mining performed in enterprise systems: *raw data of enterprise systems are used directly, *when the threshold is tuned, only newly qualified data are read and the data structure built for original data is kept intact, *product assortments centered on particular product can be effectively performed, *the performance of the mining algorithm is better than that of popular mining algorithms.

An Anatomy of the Magnet Effect: Evidence from the Korea Stock Exchange High-Frequency Data

We examine the existence and the forms of the magnet effect using transaction files and limit order book of the Korea Stock Exchange. A significant magnet effect exists in all five market microstructure variables (the rate of return, trading volume, volatility, order flow, and order type) when the limit hit becomes imminent. Specifically, investors place increasingly more orders, choose proportionally more market orders, and frequently reposition existing orders to advance transactions. We also find that: (i) a narrower price limit exhibits higher acceleration rates in all five variables compared to a wider price limit; and (ii) the upper limit hits draw heavier volumes of transactions, order submissions and market orders than the lower limit hits. We confirm that the magnet effect is a phenomenon unique only to markets with daily price limit systems.

Fuzzy Web Usage Mining for User Modeling

The interest of data mining in artificial intelligence with fuzzy logic has been increased. Data mining is a process of extracting desirable knowledge and interesting pattern ken large data set. Because of expansion of WWW, web data is more and more huge. Besides mining web contents and web structures, another important task for web mining is web usage mining which mines web log data to discover user access pattern. The goal of web usage mining in this paper is to find interesting user pattern in the web with user feedback. It is very important to find user`s characteristic fer e-business environment. In Customer Relationship Management, recommending product and sending e-mail to user by extracted users characteristics are needed. Using our method, we extract user profile from the result of web usage mining. In this research, we concentrate on finding association rules and verify validity of them. The proposed procedure can integrate fuzzy set concept and association rule. Fuzzy association rule uses given server log file and performs several preprocessing tasks. Extracted transaction files are used to find rules by fuzzy web usage mining. To verify the validity of user`s feedback, the web log data from our laboratory web server.

Age and gender user differences of a touch-screen kiosk: a study of kiosk transaction log files

More and more health information is provided to the consumer in a digital form but research on who actually accesses and uses this information is unclear. This research identifies age and gender user differences of a touch-screen health kiosk. In a departure from previous research, extensive use is made of electronically recorded user transaction files. In all 1378 user sessions covering 17 039 page views were analysed for this study. This research forms part of a research project funded by the Department of Health. Men accounted for about 53% of use but this hides an important gender difference: additionally women under 15 are significant under-users of such facilities. Qualitative research is needed to clarify the relationship. Further, it was found that those aged over 75 were not making use of kiosk content pages when compared to other age groups.

Fault-Tolerant File-I/O for Portable Checkpointing Systems

The ftIO-system provides portable and fault-tolerant file-I/O by enhancing the functionality of the ANSI C file system without changing its application programmer interface and without depending on system-specific implementations of the standard file operations. The ftIO-system is an extension of the porch compiler and its runtime system. The porch compiler automatically generates code to save bookkeeping information about ftIO's transactional file operations in portable checkpoints. These portable checkpoints can be recovered on a binary incompatible architecture. We developed a new algorithm for supporting transactional file operations in ftIO. Rather than using the well-known two-phase commit protocol, this algorithm uses only a single bit of information and an atomic rename file operation to guarantee fault tolerance. In this paper, we describe our new ftIO algorithm, discuss design choices for ftIO, and provide experimental data of our ftIO prototype.

Managing data for a randomised controlled clinical trial: experience from the WHO Antenatal Care Trial. WHO Antenatal Care Trial Research Group.

The World Health Organisation, in collaboration with four developing countries, is conducting a randomised controlled clinical trial to evaluate a new programme of antenatal care. In a city or region in Argentina, Cuba, Saudi Arabia and Thailand, 53 clinical units were randomly allocated to provide either the new programme or the programme currently in use. This paper describes the organisation of the data management system used to collect the data. Each woman participating in the trial is uniquely identified, and information such as her name, address and expected delivery date is recorded in the trial 'subject number list'. If the clinic belongs to the intervention group, information about the woman's eligibility is recorded on the classification form. Details of the outcome of the pregnancy are indicated on two additional case report forms: the antenatal hospital admission form and the summary form. When forms are completed by the investigators, they are submitted to the country data coordinating centre (CDCC). The CDCCs are responsible for the processing of the country study forms. This includes verification of the batch of forms, data capture into computer files, data verification, data validation, production of query sheets for data problems, maintenance and updating of study master files. All operations on data such as additions or modifications are performed using transaction processing. At monthly intervals, recruitment reports and transaction files are sent to the trial coordinating centre in Geneva. All transaction files are processed to accumulate data on the trial's consolidated master files. A monthly report including number of women recruited in the trial, adverse events reported by the countries, recruitment charts by clinic and analyses on eligible women in the intervention group is prepared and submitted to the data safety and monitoring committee. A workshop was organised in 1995, before the start of the trial, to introduce the data management system to the four participating countries. Annual site visits were made to each CDCC to monitor progress. Additional visits were made when major or critical problems could not be solved by the CDCC. At the closure of data collection, a visit is made to review and assess all data management procedures including form filling, maintenance of registers, computer files, query sheets, data modifications. In addition, final cleaning of the data is performed, and an analysis file is produced for inclusion in the centralised trial analyses and in the country-specific analyses. Based on the experience gained in this trial, the decentralised data management model can be advocated only if CDCCs that will be involved in the trial are already in place with competent and experienced staff. Uniformity of the data management system and of standard operating procedures across countries is also a crucial issue for the effective management of the data collection phase.

PDF417 portable data files a new dimension in barcodes

Outlines research work based on the application of coding theory and information theory to barcode systems design, with the aim of developing a replacement for traditional linear barcodes. The coding device needs to be cheap to print and easy to read but also have the ability to store and retrieve a complete transaction file. The result of this work was PDF417, a symbol which can contain over a kilobyte of binary data or almost 2,000 alphanumeric characters. Describes the key features of PDF417 and gives examples of applications in the automotive industry, supply chain communications and military ID card systems. Concludes that PDF417 Portable Data File technology opens the door to a wide range of important new application opportunities, sometimes complimenting and other times replacing the traditional linear barcodes.

The great PRISM ILL cutover

Reviews some of the day‐to‐day benefits of introducing the PRISM interlibrary loan system to a college reference library. Discusses the editing of workforms, main and copy displays, creating a “new” request from a recently produced “pending” one, searching the transaction and message files, system changes, database choices, as well as the helpful advice offered in the Interlibrary Loan User Guide.

A distributed file server for embedded applications

This paper describes the design and implementation of a distributed file system (dfs) for embedded applications. The services provided in dfs include transaction management, file management and file access. Client processes use message passing to access these services. The file system provides client processes with different types of files. These include replicated files, with identical copies stored at multiple nodes, and consistent files, stored at a single node. Both are accessed only within transactions. Multiple readers or a single writer are allowed access to the files, and updates are performed atomically using a co-ordinated commit protocol over multiple sites. A novel concurrency control algorithm which provides deterministic response and avoids deadlock has been designed to resolve contention. Other types of file are also provided for low-overhead storage of less critical data. This paper motivates the need for different types of file, and describes the design and implementation of dfs using the CONIC programming environment for the construction of distributed systems.

An information system for village handpumps

The need for a computerised information system for handpumps installed in any state is brought out. A system with organisational and software aspects is presented. The organisational aspect covers the generation and transmission of data on handpumps at the users’ and the government level. The software consists of a Fortran program, data files, an updating program and a transaction file. The periodic updating of data files is discussed. The system output covers many items of vital information needed for formulating maintenance and research and development policies. A test run of the program with an arbitrarily selected data base is discussed.