Analytical Processing Systems Research Articles

An UML Profile and SOLAP Datacubes Multidimensional Schemas Transformation Process for Datacubes Risk-Aware Design

Spatial Data Warehouses (SDWs) and Spatial On-Line Analytical Processing (SOLAP) systems are new technologies for the integration and the analysis of huge volume of data with spatial reference. Spatial vagueness is often neglected in these types of systems and the data and analysis results are considered reliable. In a previous work, the authors provided a new design method for SOLAP datacubes that allows the handling of vague spatial data analysis issues. The method consists of tailoring SOLAP datacubes schemas to end-users tolerance levels to identified potential risks of misinterpretation they encounter when exploiting datacubes containing vague spatial data. It this paper, the authors further their previous proposal by presenting different formal tools to support their method: it is an UML profile providing stereotypes needed to add vague, risks and tolerance levels information on datacubes schemas plus the formal definition of SOLAP datacubes schemas transformation process and functions.

Analytical Analysis of Electromagnetic Processes in System "MHD Stirrer - Bath with Melt"

The present article describes the analysis of electromagnetic field carried out by an analytical method in the system inductor–bath with melt (liquid metal) taking into account different winding characteristics of the inductor. It also defines integral and differential characteristics of the system for the most widespread windings of an MHD-stirrer.

Development of a Process Analysis System Oriented to Discrete Manufacturing Industry

The existing problems on the manufacturing process planning and management of China are introduced, a variety of manufacturing process analysis and optimization processes are integrated, product, process and technology resources are systematized, then the information model is established. The architecture of a process analysis is proposed, on the basis, a platform of process planning, management, analysis and improvement is constructed, through integration with the CAPP system, the function of process planning, analyzing and optimizing has been implemented. By application in an auto heavy plant, the desired effect of data sharing, staff collaboration, process optimization is achieved.

Analysis of pharmacist-patient communication using the Roter Method of Interaction Process Analysis System.

Effective communication between pharmacists and patients is a crucial factor in ensuring that medications are used properly. However, few studies have examined the contents of actual on-site communications between pharmacists and patients. To identify the characteristics of and problems with routine communications between pharmacists and patients using the Roter Method of Interaction Process Analysis System (RIAS). Conversations between pharmacists and simulated patients (SPs) were recorded and transcribed. Using the RIAS technique, their utterances were classified into 42 categories, and these were further divided into 11 clusters, such as open- and closed-ended questions, and analyzed. Furthermore, the influence that the different scenarios performed by the pharmacists may have had on the structure of their communication was investigated. All of the transcripts were double-coded by two certified coders. A total of 57 pharmacists took part in the study. The mean ratio of utterances made by SPs and pharmacists were 44% and 56%, respectively. The percentage of pharmacists' questions was more than double that of SPs' for both open- and closed-ended questions. In the influence that the different scenarios, the scenarios for patients with cancer was significantly higher ratio of utterances by the pharmacists. Pharmacists' communications tended to focus more on information-gathering activities that concentrated on closed-ended questions and frequent counseling, or directing utterances about the medication than on considering the patient's background. On the other hand, the pharmacists did communicate in ways that matched each patient's disease. This study identified the structure of pharmacists' on-site communications, and revealed the associated characteristics and problems.

Contextualized Text OLAP Based on Information Retrieval

Current data warehousing and On-Line Analytical Processing (OLAP) systems are not yet particularly appropriate for textual data analysis. It is therefore crucial to develop a new data model and an OLAP system to provide the necessary analyses for textual data. To achieve this objective, this paper proposes a new approach based on information retrieval (IR) techniques. Moreover, several contextual factors may significantly affect the information relevant to a decision-maker. Thus, the paper proposes to consider contextual factors in an OLAP system to provide relevant results. It provides a generalized approach for Text OLAP analysis which consists of two parts: The first one is a context-based text cube model, denoted CXT-Cube. It is characterized by several contextual dimensions. Hence, during the OLAP analysis process, CXT-Cube exploits the contextual information in order to better consider the semantics of textual data. Besides, the work associates to CXT-Cube a new text analysis measure based on an OLAP-adapted vector space model and a relevance propagation technique. The second part is an OLAP aggregation operator called ORank (OLAP-Rank) which allows to aggregate textual data in an OLAP environment while considering relevant contextual factors. To consider the user context, this paper proposes a query expansion method based on a decision-maker profile. Based on IR metrics, it evaluates the proposed aggregation operator in different cases using several data analysis queries. The evaluation shows that the precision of the system is significantly better than that of a Text OLAP system based on classical IR. This is due to the consideration of the contextual factors.

Spatial Online Analytical Processing for Hotspots Distribution Based on Socio-economic Factors in Riau Province Indonesia

Hotspot data analysis will generate more useful information if the data are combined with socio-economics condition. The relation between hotspots and socio-economic conditions is important to be explored in order to identify the human factors that may cause forest fires. In the previous research, a spatial data warehouse and Spatial Online Analytical Processing (SOLAP) system for hotspots distribution were developed. However, the system does not provide other useful information such as socio-economy to analyse the cause of forest fires. The purpose of this study is to create socio-economy dimensions in the spatial data warehouse system.

Spatial OLAP integrity constraints: From UML-based specification to automatic implementation: Application to energetic data in agriculture

Spatial OnLine Analytical Processing systems (SOLAP) are Business Intelligence technologies allowing efficient and interactive analysis of large spatial data cubes. In this type of systems, the correctness of analysis depends on the warehoused data quality, how aggregations are performed and how data cubes are explored. In this paper, we study quality control techniques (based on integrity constraints) related to exploration of spatial data cubes. We extend our Unified Modeling Language (UML) framework previously proposed with a UML profile allowing the conceptual design of several classes of exploration integrity constraints. We also propose a tool for their automatic implementation. We validate our proposal in the context of a real case study concerning the analysis of energetic farm indicators.

WideTable

This paper presents a technique called WideTable that aims to improve the speed of analytical data processing systems. A WideTable is built by denormalizing the database, and then converting complex queries into simple scans on the underlying (wide) table. To avoid the pitfalls associated with denormalization, e.g. space overheads, WideTable uses a combination of techniques including dictionary encoding and columnar storage. When denormalizing the data, WideTable uses outer joins to ensure that queries on tables in the schema graph, which are now nested as embedded tables in the WideTable, are processed correctly. Then, using a packed code scan technique, even complex queries on the original database can be answered by using simple scans on the WideTable(s). We experimentally evaluate our methods in a main memory setting using the queries in TPC-H, and demonstrate the effectiveness of our methods, both in terms of raw query performance and scalability when running on many-core machines.

Query Processing on OLAP System with Cloud Computing Environment

The conventional researches on a distributed On-Line Analytical Processing (OLAP) system have been in hardship to be adapted to real business environment. However, the recent spread of Cloud PaaS (Platform as a Services) provides new chances in the field of a distributed OLAP. OLAP query execution costs many minutes by its enormous data and OLAP query properties. On the other hand, MOLAP has fast responses. But it has a physical space limit to materialize all cells in possible combinations. Therefore, MOLAP is unsuited to analyze large data. In this paper, to provide not only flexibility and expandability of ROLAP but also the speediness of MOLAP, the cloud server architecture is proposed which shares clients’ cube cache by P2P and manages central index on cube data on P2P nodes. In this paper, each node acts as not only a P2P duplicator of aggregated data cubes but also a hybrid server to process queries on sub-cubes. Also, the requests on server are confined to non-aggregated areas and multiple client nodes exchange data simultaneously and asynchronously in the proposed Cloud P2P OLAP. In particular, data are retrieved from physically or logically adjacent nodes. With time series properties, the volume of requested data is minimized and the reuse of past cache data is focused. While central managed P2P has blocked the extendibility, Cloud P2P OLAP guarantees the performance and the extendibility. While Grid OLAP should keep self-distributed system, Cloud use services as much as used by public services. Therefore, Cloud P2P OLAP solves a lot of theoretical limits of conventional distributed OLAP.

A New Model for Software Engineering Systems Quality Improvement

In the continuing effort to improve the system analysis and design process, several different approaches have been developed. This study will propose a new process methodology solves some problems in traditional system development methodologies it will study the strength and limitation of existing system development methodologies from traditional waterfall to iterative model including (Prototyping, Spiral, Rapid Application Development, XP and RUP) to Agility. Propose a new methodology focus on produce a high quality product and suitable for all kind of project. Compare the new methodology with others to view some features that is differentiating it from previous methodologies.

Research on the Signal Process of a Bell-Shaped Vibratory Angular Rate Gyro

A bell-shaped vibratory angular rate gyro, which is inspired by the Chinese traditional bell, is a kind of axisymmetric shell resonator gyroscope. Its sensitive element is a vibratory-like Chinese traditional bell, using a piezoelectric element on the wall of the vibrator to detect the standing wave's precession to solve the input angular rate. This work mainly studies the circuit system of a bell-shaped vibratory angular rate gyro. It discusses the process of circuit system design, analysis and experiment, in detail, providing the foundation to develop a bell-shaped vibratory angular rate gyro. Since the bell-shaped resonator's curved structure has the characteristics of large noise in the piezoelectric signal and large harmonics, this paper analyzes its working and signal detection method, then gives the whole plan of the circuit system, including the drive module, the detection module and the control loop. It also studies every part of the whole system, gives a detailed design and analysis process and proves part of the circuit system using digital simulation. At the end of the article, the test result of the circuit system shows that it can remove the disadvantages of the curved structure having large noise in the piezoelectric signal and large harmonics and is more effective at solving the input angular rate.

Evaluating a systematic voiding programme for patients with urinary incontinence after stroke in secondary care using soft systems analysis and Normalisation Process Theory: Findings from the ICONS case study phase

BackgroundUrinary incontinence (UI) affects between 40 and 60% of people in hospital after stroke, but is often poorly managed in stroke units. ObjectivesTo inform an exploratory trial by three methods: identifying the organisational context for embedding the SVP; exploring health professionals’ views around embedding the SVP and measuring presence/absence of UI and frequency of UI episodes at baseline and six weeks post-stroke. DesignA mixed methods single case study included analysis of organisational context using interviews with clinical leaders analysed with soft systems methodology, a process evaluation using interviews with staff delivering the intervention and analysed with Normalisation Process Theory, and outcome evaluation using data from patients receiving the SVP and analysed using descriptive statistics. SettingAn 18 bed acute stroke unit in a large Foundation Trust (a ‘not for profit’ privately controlled entity not accountable to the UK Department of Health) serving a population of 370,000. ParticipantsHealth professionals and clinical leaders with a role in either delivering the SVP or linking with it in any capacity were recruited following informed consent. Patients were recruited meeting the following inclusion criteria: aged 18 or over with a diagnosis of stroke; urinary incontinence (UI) as defined by the International Continence Society; conscious; medically stable as judged by the clinical team and with incontinence classified as stress, urge, mixed or ‘functional’.All patients admitted to the unit during the intervention period were screened for eligibility; informed consent to collect baseline and outcome data was sought from all eligible patients. ResultsOrganisational context: 18 health professionals took part in four group interviews. Findings suggest an environment not conducive to therapeutic continence management and a focus on containment of UI. Embedding the SVP into practice: 21 nursing staff took part in six group interviews. Initial confusion gave way to embedding of processes facilitated by new routines and procedures. Patient outcome: 43 patients were recruited; 28 of these commenced the SVP. Of these, 6/28 (21%) were continent at six weeks post-stroke or discharge. ConclusionIt was possible to embed the SVP into practice despite an organisational context not conducive to therapeutic continence care. Recommendations are made for introducing the SVP in a trial context.

Design of a Unified Data with Business Rules Storage Model for OLTP and OLAP Systems

This paper reviews the literature concerning the practice of using Online Analytical Processing (OLAP) systems to recall information stored by Online Transactional Processing (OLTP) systems. Such a review provides a basis for discussion on the need for the information that are recalled through OLAP systems to maintain the contexts of transactions with the data captured by the respective OLTP system. The paper observes an industry trend involving the use of OLTP systems to process information into data, which are then stored in databases without the business rules that were used to process information and data stored in OLTP databases without associated business rules. This includes the necessitation of a practice, whereby sets of business rules are used to extract, cleanse, transform and load data from disparate OLTP systems into OLAP databases to support the requirements for complex reporting and analytics. These sets of business rules are usually not the same as business rules used to capture data in particular OLTP systems. The paper argues that differences between the business rules used to interpret these same data sets risk gaps in semantics between information captured by OLTP systems and information recalled through OLAP systems. The literature concerning the modeling of business transaction information as facts with context as part of the modelling of information systems was reviewed to identify design trends that are contributing to the design quality of OLTP and OLAP systems. The paper then argues that the quality of OLTP and OLAP systems design has a critical dependency on the capture of facts with associated context, encoding facts with contexts into data with business rules, storage and sourcing of data with business rules, decoding data with business rules into the facts with the context and recall of facts with associated contexts. The paper proposes UBIRQ, a design model to aid the co-design of data with business rules storage for OLTP and OLAP purposes. The proposed design model provides an opportunity for the implementation and use of multi-purpose databases and business rules stores for OLTP and OLAP systems. Such implementations would enable the use of OLTP systems to record and store data with executions of business rules, which will allow for the use of OLTP and OLAP systems to query data with business rules used to capture the data, thereby ensuring that information recalled via OLAP systems preserves the contexts of transactions as per the data captured by the respective OLTP system.

The Complex Effects of Shared Domain Knowledge on IS Development: A Simulation-Based Theory Development

Information systems development (ISD) requires the integration of both application domain knowledge and technology knowledge. However, knowledge specialization complicates the IS analysis and design process. The business unit, who is ultimately responsible for making business design choices for the system, holds ample functional domain knowledge but possesses less technology knowledge, while the IS unit, who is responsible for making technical design choices, has deep technology knowledge but less functional domain knowledge. Furthermore, ISD projects are characterized by interdependencies in design choices not only within but also across business and technical domains. Prior research tends to suggest a uniform positive effect of shared domain knowledge between business and IS units on ISD performance. Although a few studies have argued that the effect may not be uniformly positive, little research has explored the complex effect of shared domain knowledge. Since organizations invest substantial resources to develop shared domain knowledge, it is crucial to uncover the conditions under which it affects ISD performance differently. We model the systems analysis and design process as an iterative design problem solving process by which the ISD team, composed of business and IS units with heterogeneous and overlapping knowledge bases, seeks to discover a system design that produces the greatest business value. Using simulations based on the NK fitness landscapes model, we find that shared domain knowledge does not affect ISD performance when ISD complexity is very low or when all interdependencies of design choices exist within the same unit, that it increases robustness of ISD performance across different distributions of design choice interdependencies, and that ISD performance is higher when shared domain knowledge is unevenly distributed between business and IS units or when its distribution matches that of the design choice interdependencies. Based on these findings and our reasoning, we posit eight propositions that advance the theory of shared domain knowledge.

A development of a web-based and user-centered process analysis system for quality improvement

In order to manage and control quality of the products in a real-time manner, statistical process control methodology, one of the most popular quality control activities, is utilized as a software service in many manufacturing industries. However, these quality control systems are not affordable to small and medium sized industries due to their expense in installation and difficulty in the systems. To reduce installation cost and difficulty of the systems, this research paper suggests web-based statistical process control system with user-centered design. Although number of non-traditional and web-based SPC systems exists, they tend to focus their designs to either beginners or experts of SPC system. The suggested system, PAS, aims to develop the system to be compatible with frequently used browsers and acceptable in both beginners and experts. Lastly, it accepts diverse forms of data so that it attempts to support data from industry to be used directly to the system.

Design and Implementation of Web-Based Archive Dispatching Management System

University graduate archives are very important to graduates, but for now, there exist a number of problems in archive management, especially in archive dispatching. This paper proposes a web-based graduate archive dispatching management system, and introduces the process of system analysis and design from system modules, system framework and key technologies used in this system. Finally, it summarizes the subsequent directions of deep research and improvement.

Improving adolescent judgment and decision making.

Human judgment and decision making (JDM) has substantial room for improvement, especially among adolescents. Increased technological and social complexity "ups the ante" for developing impactful JDM interventions and aids. Current explanatory advances in this field emphasize dual processing models that incorporate both experiential and analytic processing systems. According to these models, judgment and decisions based on the experiential system are rapid and stem from automatic reference to previously stored episodes. Those based on the analytic system are viewed as slower and consciously developed. These models also hypothesize that metacognitive (self-monitoring) activities embedded in the analytic system influence how and when the two systems are used. What is not included in these models is the development of an intersection between the two systems. Because such an intersection is strongly suggested by memory and educational research as the basis of wisdom/expertise, the present paper describes an Integrated Judgment and Decision-Making Model (IJDM) that incorporates this component. Wisdom/expertise is hypothesized to contain a collection of schematic structures that can emerge from the accumulation of similar episodes or repeated analytic practice. As will be argued, in comparisons to dual system models, the addition of this component provides a broader basis for selecting and designing interventions to improve adolescent JDM. Its development also has implications for generally enhancing cognitive interventions by adopting principles from athletic training to create automated, expert behaviors.

GCUBE Indexing

Spatial Online Analytical Processing System involves the non-categorical attribute information also whereas standard Online Analytical Processing System deals with only categorical attributes. Providing spatial information to the data warehouse (DW); two major challenges faced are;1.Defining and Aggregation of Spatial/Continues values and 2.Representation, indexing, updating and efficient query processing. In this paper, we present GCUBE(Geographical Cube) storage and indexing procedure to aggregate the spatial information/Continuous values. We employed the proposed approach storing and indexing using synthetic and real data sets and evaluated its build, update and Query time. It is observed that the proposed procedure offers significant performance advantage.

UML-based Requirements Analysis on Risk Pre-control System in Coal Enterprise

Combining with the present situation of risk management in domestic coal enterprises,the overall flow of risk pre-control system of coal enterprise is designed on the basis of the ISO/FDIS31000 “Risk management—Principles and guidelines” released by the International Standards Organization and risk precontrol management system of safety in coal mine, UML(unified modeling language) is used as a tool to establish the model of system requirements analysis, risk management subsystem is taken as an example to elaborate the modeling process of system analysis, the merit of ensuring the accuracy and consistency of system analysis when using UML as the tool of object-oriented system requirements analysis is verified. DOI: http://dx.doi.org/10.11591/telkomnika.v11i7.285 3

Mejora en el proceso de pruebas de metales en una empresa de servicio de inspección y laboratorio empleando simulación con Promodel

En las empresas hoy en día, se hace necesario el uso de tecnologías y herramientas que permitan estudiar los procesos, de acuerdo al comportamiento del mercado de forma eficiente, rápida y económica. En el presente documento, se desarrolla la aplicación de la simulación con ProModel, con el fin de mejorar el proceso de pruebas de metales sílice y aluminio, en una empresa de servicio de inspección y de laboratorio de productos petroquímicos y petróleos. Para esto, se hace necesario metodológicamente describir el proceso productivo, determinar el modelo conceptual y la recolección de datos de entrada, construir el modelo, analizar los resultados de salida y, por último, plantear una mejora, a través del análisis del sistema y de indicadores del proceso, que permita incrementar significativamente el nivel de servicio.