Reference Architectures to Measure Data Completeness Across Integrated Databases

Completeness is an important aspect of data quality and to determine data acceptability one needs to measure the completeness of the data set of concerned. One type of data completeness measure is population-based completeness (PBC). Nevertheless, the notion of PBC will be of little use until we can determine the eorts required (in terms of architectural design) to implement PBC. In this paper, we present the types of PBC system reference architecture and motivate the selection of each

Data Accessibility Model Using QR Code for Lifetime Healthcare Records

One factor that determines the quality of healthcareservices is the accessibility of patient records. Fast and seamless access to patient records is necessary in order to support sharing of complete lifetime patient records among healthcare providers while promoting the greater use of it. Nevertheless, studies on how complete lifetime patient record can be acquired by improving the way these records are accessed are limited. In this paper, the conceptual model of data accessibility in healthcare domain will be presented. QR code technology will be adopted in the model as a tool that enables multi-platforms data access points. Incremental data updates will be used as a mean to share complete, up-to-date lifetime patient records. Software prototype architecture and the interface design of the model will be also presented in this paper. The contribution of the work is on improving lifetime patient records accessibility that consequently promotes sharing of complete patient records among healthcare providers

Beginning Database: A Practical Approach for Non-relational Database

Developing any applications that involve storage of data in a database requires application developer to carefully and precisely build design plans in order to produce high quality and useful product. There are many approaches that can be adopted in order to explain database design. Furthermore, database technology is rapidly developed and changing. As the result, the way to describe database design should be updated in order to reflect the current and latest database technology. The primary objective of this book is to equip the students with basic knowledge on how to design database for other types of data model like object-oriented and object-relational data model

Database Performance Tuning Methods for Manufacturing Execution System

In manufacturing industry where data are produced and shared every day, data volumes could be large enough for the database performance to become an issue. Manufacturing Execution System (MES) is such a system that cannot tolerate with poor database performance as the system relies heavily on real-time reporting that requires instance query responses. Manufacturing products’ quality and production targets can be affected as the result of delayed queries. Therefore, the need to maintain the acceptable level of database performance in this domain is crucial. One task in maintaining database performance is identification and diagnosis of the root causes that may cause delayed queries. Poor query design has been identified as one major cause of delayed queries that affect real-time reporting. Nevertheless, as various methods available to deal with poor query design, it is important for a database administrator to decide the method or combination of methods that work best. In this paper, we present a case study on the methods used by a real manufacturing industry company called as Silterra and the methods proposed in the literature that deal with poor query design. For each method, we elicit its strength and weaknesses and analyse the practical implementation of it

Query Rewriting using Multitier Materialized Views for Cyber Manufacturing Reporting

Within cyber manufacturing context, Internet of Data (IoD) technology has enabled manufacturing sector to store and transfer mass data rapidly for processing.  Data growth which is driven by advancement in the way data are produced and interconnected has caused volume of data a crucial issue to address. As such, in monitoring delicate wafer processing in semiconductor manufacturing, reporting delay problem caused by databases of high data volumes is intolerable. This is because, various reports (that require access to large databases) need to be frequently generated in the shortest time possible. Reporting delay is usually handled through SQL query rewriting. In this paper, the results of experimenting SQL query rewriting by utilizing multitier materialized views structure is presented. In particular, we define sub-materialized views (SMVs) concept, and implement it using real data sets from SilTerra (a semiconductor industry). The outcome of the experiment supports the hypothesis that SQL query rewriting using SMV outperforms the classic rewriting. The results reveal that the performance of SMV is far better (than without SMV) for complex queries against large data sets. The benefits of SMV are not limited to cyber manufacturing domain as the use of SMV can contribute other industries with similar problem

The influence of graphitization catalyst electrode in electrical discharge machining of polycrystalline diamond-finishing condition

Electrical Discharge Machining (EDM) is a non-contact machining process that becomes famous in machining of Polycrystalline Diamond (PCD). The material is typically used as the cutting tools for aerospace and automotive industries. However, low electrical conductivity and high melting temperature of PCD has caused slower EDM process. This investigation purposely designed to investigate the influence of different types of electrode which are Copper (ordinary electrode) and Copper-Nickel (newly proposed graphitization catalyst electrode) on EDM performance of MRR and Ra. Interestingly the newly proposed electrode gave positive impact to the investigated performance indication. Cu-Ni electrode recorded 35% better in MRR than the Cu electrode, though with higher short-circuiting rate. Cu-Ni also provided the lowest Ra value with 10% better than the best Ra produced by Cu electrode. This phenomenon occurred as due to the high interaction between the catalyst materials of nickel and diamond which supported by the qualification data provided in this investigation

Malocclusion, psycho-social impacts and treatment need: A cross-sectional study of Tanzanian primary school-children

<p>Abstract</p> <p>Background</p> <p>studies on the relationship between children's malocclusion and its psycho-social impacts are so far largely unexplored in low-income countries. This study aimed to assess the prevalence of malocclusion, reported dental problems and dissatisfaction with dental appearance among primary school children in Tanzania. The relationship of dissatisfaction with socio-demographic characteristics, clinically defined malocclusion and psychosocial impacts of dental anomalies was investigated. Orthodontic treatment need was estimated using an integrated socio-dental approach.</p> <p>Method</p> <p>One thousand six hundred and one children (mean age 13 yr) attending primary schools in the districts of Kinondoni and Temeke completed face to face interviews and a full mouth clinical examination. The survey instrument was designed to measure a Kiswahili translated and culturally adapted Child Oral Impact on Daily Performance (Child-OIDP) frequency score, reported dental problems, dissatisfaction with dental appearance/function and socio-demographic characteristics.</p> <p>Results</p> <p>The prevalence of malocclusion varied from 0.9% (deep bite) to 22.5% (midline shift) with a total of 63.8% having at least one type of anomaly. Moderate proportions of children admitted dental problems; ranging from 7% (space position) to 20% (pain). The odds ratio of having problems with teeth position, spaces, pain and swallowing if having any malocclusion were, respectively 6.7, 3.9, 1.4 and 6.8. A total of 23.3% children were dissatisfied with dental appearance/function. Children dissatisfied with their dental appearance were less likely to be Temeke residents (OR = 0.5) and having parents of higher education (OR = 0.6) and more likely to reporting problem with teeth position (OR = 4.3) and having oral impacts (OR = 2.7). The socio-dental treatment need of 12% was five times lower than the normative need assessment of 63.8%.</p> <p>Conclusion</p> <p>Compared to the high prevalence of malocclusion, psycho social impacts and dissatisfaction with appearance/function was not frequent among Tanzanian schoolchildren. Subjects with malocclusion reported problems most frequently and malocclusion together with other psycho-social impact scores determined children's satisfaction with teeth appearance- and function.</p

Shaping the metaverse into reality: multidisciplinary perspectives on opportunities, challenges, and future research

The term metaverse is described as the next iteration of the Internet. Metaverse is a virtual platform that uses extended reality technologies, i.e., augmented reality, virtual reality, mixed reality, 3D graphics, and other emerging technologies to allow real-time interactions and experiences in ways that are not possible in the physical world. Companies have begun to notice the impact of the metaverse and how it may help maximize profits. The purpose of this paper is to offer perspectives on several important areas, i.e., marketing, tourism, manufacturing, operations management, education, the retailing industry, banking services, healthcare, and human resource management that are likely to be impacted by the adoption and use of a metaverse. Each includes an overview, opportunities, challenges, and a potential research agenda