scholarly journals Data Warehouse Testing and Security: A Conspectus

Data warehouse is a central storage facility that stores information from many sources which can be in structured or unstructured format, queries this information for retrieval based on certain input facts and delivers the outcome analysis to many analysts, to meet decision support and business intelligence requirement. Not much research has been carried out in this research area in the past few years. In this research paper, we are discussing the data warehouse architecture and the testing techniques that are used for best suited to be used for the data warehouses. Literature for the testing techniques is integrated at one place and the outcome is to focus on security issues while performing data warehouse testing.

2020 ◽  
Vol 10 (4) ◽  
pp. 21-34
Author(s):  
Sonali Mathur ◽  
Shankar Lal Gupta ◽  
Payal Pahwa

Data warehouses are the most valuable assets of an organization and are basically used for critical business and decision-making purposes. Data from different sources is integrated into the data warehouse. Thus, security issues arise as data is moved from one place to another. Data warehouse security addresses the methodologies that can be used to secure the data warehouse by protecting information from being accessed by unauthorized users for maintaining the reliability of the data warehouse. A data warehouse invariably contains information which needs to be considered extremely sensitive and confidential. Protecting this information is invariably very important as data in the data warehouse is accessed by users at various levels in the organization. The authors propose a method to protect information based on an encryption scheme which secures the data in the data warehouse. This article presents the most feasible security algorithm that can be used for securing the data stored in the operational database so as to prevent unauthorized access.


2020 ◽  
Vol 6 ◽  
pp. 1-8
Author(s):  
Tin Wong Chi ◽  
Imran Mahmud

The rapid development of Artificial Intelligence (AI) in recent years has greatly improved humans’ quality of life and promoted Information Systems (IS) development progress. Business Intelligence (BI) system is one of the tools in the field of IS which obtained benefits from the development of AI. The adoption of BI can enhance the competitive aspect of a business organization in today’s highly competitive business environment and play an important role in determining a business organization’s success. However, literature shows that the adoption rate of the BI system is low and it is predicted that the adoption rate will not increase a lot in near future. Prior research studies paid less attention in a comprehensive study that review research articles related to BI system adoption in regard to discuss the issues and research gaps. There is an absence of a clear agenda or roadmap in the research area of BI adoption. Therefore, this study aims to synthesize and analyze research studies of BI adoption in the past two decades, identify the major theories that researchers have used to predict the adoption of BI, and summarize key antecedents that influence the adoption of BI. This study reviewed 44 research articles published on the adoption of BI between the year 2000 and the first quarter of 2020. The findings first indicate that the analysis of BI adoption literature is not comprehensive enough. Researchers in the past two decades commonly rely on TAM and its modifications to measure the adoption of BI. The finding also indicates that there are limited research studies on the negative stimulus of BI adoption. This study proposes the agenda for continued research in the area of BI adoption that targets identified gaps in the literature.


Author(s):  
Sagar T. Malsane ◽  
Smita S. Aher ◽  
R. B. Saudagar

Oral route is presently the gold standard in the pharmaceutical industry where it is regarded as the safest, most economical and most convenient method of drug delivery resulting in highest patient compliance. Over the past three decades, orally disintegrating tablets (FDTs) have gained considerable attention due to patient compliance. Usually, elderly people experience difficulty in swallowing the conventional dosage forms like tablets, capsules, solutions and suspensions because of tremors of extremities and dysphagia. In some cases such as motion sickness, sudden episodes of allergic attack or coughing, and an unavailability of water, swallowing conventional tablets may be difficult. One such problem can be solved in the novel drug delivery system by formulating “Fast dissolving tablets” (FDTs) which disintegrates or dissolves rapidly without water within few seconds in the mouth due to the action of superdisintegrant or maximizing pore structure in the formulation. The review describes the various formulation aspects, superdisintegrants employed and technologies developed for FDTs, along with various excipients, evaluation tests, marketed formulation and drugs used in this research area.


2020 ◽  
Author(s):  
Jelena O'Reilly ◽  
Eva Jakupčević

Although the second language (L2) acquisition of morphology by late L2 learners has been a popular research area over the past decades, comparatively little is known about the acquisition and development of morphology in children who learn English as a foreign language (EFL). Therefore, the current study presents the findings from a longitudinal oral production study with 9/10-year-old L1 Croatian EFL students who were followed up at the age of 11/12. Our results are largely in line with the limited research so far in this area: young EFL learners have few issues using the be copula and, eventually, the irregular past simple forms, but had considerable problems with accurately supplying the 3rd person singular -s at both data collection points. We also observed a be + base form structure, especially at the earlier stage, which appears to be an emergent past simple construction.


Author(s):  
Harkiran Kaur ◽  
Kawaljeet Singh ◽  
Tejinder Kaur

Background: Numerous E – Migrants databases assist the migrants to locate their peers in various countries; hence contributing largely in communication of migrants, staying overseas. Presently, these traditional E – Migrants databases face the issues of non – scalability, difficult search mechanisms and burdensome information update routines. Furthermore, analysis of migrants’ profiles in these databases has remained unhandled till date and hence do not generate any knowledge. Objective: To design and develop an efficient and multidimensional knowledge discovery framework for E - Migrants databases. Method: In the proposed technique, results of complex calculations related to most probable On-Line Analytical Processing operations required by end users, are stored in the form of Decision Trees, at the pre- processing stage of data analysis. While browsing the Cube, these pre-computed results are called; thus offering Dynamic Cubing feature to end users at runtime. This data-tuning step reduces the query processing time and increases efficiency of required data warehouse operations. Results: Experiments conducted with Data Warehouse of around 1000 migrants’ profiles confirm the knowledge discovery power of this proposal. Using the proposed methodology, authors have designed a framework efficient enough to incorporate the amendments made in the E – Migrants Data Warehouse systems on regular intervals, which was totally missing in the traditional E – Migrants databases. Conclusion: The proposed methodology facilitate migrants to generate dynamic knowledge and visualize it in the form of dynamic cubes. Applying Business Intelligence mechanisms, blending it with tuned OLAP operations, the authors have managed to transform traditional datasets into intelligent migrants Data Warehouse.


2020 ◽  
Vol 24 (6) ◽  
pp. 1311-1328
Author(s):  
Jozsef Suto

Nowadays there are hundreds of thousands known plant species on the Earth and many are still unknown yet. The process of plant classification can be performed using different ways but the most popular approach is based on plant leaf characteristics. Most types of plants have unique leaf characteristics such as shape, color, and texture. Since machine learning and vision considerably developed in the past decade, automatic plant species (or leaf) recognition has become possible. Recently, the automated leaf classification is a standalone research area inside machine learning and several shallow and deep methods were proposed to recognize leaf types. From 2007 to present days several research papers have been published in this topic. In older studies the classifier was a shallow method while in current works many researchers applied deep networks for classification. During the overview of plant leaf classification literature, we found an interesting deficiency (lack of hyper-parameter search) and a key difference between studies (different test sets). This work gives an overall review about the efficiency of shallow and deep methods under different test conditions. It can be a basis to further research.


2013 ◽  
Author(s):  
Mustafa Insel ◽  
Ziya Saydam

A substantial amount of research has been carried out in the past to enhance the testing techniques and to increase the accuracy associated with tank testing of sailing yachts. The majority of this work was associated with high budgeted campaigns; large models, long waiting times and high budgets became standard practice in the field. This led to lack of accessibility for low budgeted campaigns and for designers of ordinary sailing yachts to these tests. A research study has been initiated to investigate the scale effects associated with tank testing of sailing yachts. The intention has been to make best use of modern experimental and computational methods to understand the scale effects in conjunction with systematic tank tests. Both viscous and wave components were considered for investigation of scale effects in sailing yacht performance prediction. Four different scale models ranging from 1/4 to 1/10 of a TP52 yacht have been tested in the towing tank in upright and heeled condition while full, half and quarter scale computational analysis have been carried out with a RANS code. The wave pattern measurements were conducted for all upright and heeled cases with the use of three wave probes on each side. Variation of drag, side force, running attitude and wave pattern have been investigated. This paper focuses on the experimental investigations both in the upright and heeled conditions.


Author(s):  
Michael Yulianto ◽  
Abba Suganda Girsang ◽  
Reinert Yosua Rumagit

Electronic ticket (eticket) provider services are growing fast in Indonesia, makingthe competition between companies increasingly intense. Moreover, most of them have the sameservice or feature for serving their customers. To get back the feedback of their customers, manycompanies use social media (Facebook and Twitter) for marketing activity or communicatingdirectly with their customers. The development of current technology allows the company totake data from social media. Thus, many companies take social media data for analyses. Thisstudy proposed developing a data warehouse to analyze data in social media such as likes,comments, and sentiment. Since the sentiment is not provided directly from social media data,this study uses lexicon based classification to categorize the sentiment of users’ comments. Thisdata warehouse provides business intelligence to see the performance of the company based ontheir social media data. The data warehouse is built using three travel companies in Indonesia.As a result, this data warehouse provides the comparison of the performance based on the socialmedia data.


2020 ◽  
Vol 6 (3) ◽  
pp. 0416-0420 ◽  
Author(s):  
Joshua Ighalo ◽  
Adewale George Adeniyi ◽  
Kevin Shegun Otoikhian

Over the years, Nigerian researchers in environmental engineering and chemistry have been evaluating a variety of technologies for the remediation of petroleum industry polluted surface and groundwater. In this mini-review, the recent advances in this regard over the past two years were evaluated. This was done as an appraisal of research efforts to understand the current research trend and gain a proper perspective of the required/needed future approach in the research area. It was observed that most studies are still focusing on evaluating the problems instead of finding actual solutions. Development of workable and novel solutions are urgently needed. It can be in the form of better remediation techniques or via the development of alternative technologies for utilizing the waste/pollutant materials. The paper has given a clear opinion on the progress of environmental protection and sustainability in the Nigerian context. The environmental regulations scenario in the country is marred by malpractices and corruption more stringent policy enforcement will help in the achievement of environmental protection.


Sign in / Sign up

Export Citation Format

Share Document