Study of Web-based Data Warehouse and Security

Zhang Mingjie

DOI: https://doi.org/10.3969/j.issn.1672-9722.2010.07.033

2010-01-01

Abstract:With the developing of information technology,especially the Internet,Web-based Data Warehouse became the research hot point.The paper presents the architecture of Web-based Data Warehouse and its advantages.The paper presents the security of the Web-based Data Warehouse and the related secure technique.

What problem does this paper attempt to address?

Construction of security architecture of web services based EAI

Di Wu,Yabo Dong,Jian Lin,Miaoliang Zhu

DOI: https://doi.org/10.1007/11563952_52

2005-01-01

Abstract:The fast development of E-Commerce and information technology brings much higher requirements for enterprise informationization. Because of the differences in platforms, development languages and standards etc, enterprise application integration (EAI) has become the important form of enterprise informationization to support complex business processes. Web services have emerged as the next generation of integration technology which provides the power to support interoperability. However EAI doesn’t just present new interoperability challenges; it also presents serious privacy and security challenges. This paper presents security architecture of Web Services based EAI which uses distributed Single Sign On authentication and distributed Role-based Access Control authorization. The basic concept and prototype system of the security architecture are described in detail.
Security Issues in Data Warehouse

Saiqa Aleem,Luiz Fernando Capretz,Faheem Ahmed

DOI: https://doi.org/10.48550/arXiv.1507.05644

2015-07-21

Abstract:Data Warehouse provides storage for huge amounts of historical data from heterogeneous operational sources in the form of multidimensional views, thus supplying sensitive and useful information which help decision-makers to improve the organizations business processes. A data warehouse environment must ensure that data collected and stored in one big repository are not vulnerable. A review of security approaches specifically for data warehouse environment and issues concerning each type of security approach have been provided in this paper.

Cryptography and Security
The research of web-based data warehouse using XML

Li Xiu,Wang Xuerui,Liu Wenhuang,Liao Lin

DOI: https://doi.org/10.1109/ICII.2001.983492

2001-01-01

Abstract:The traditional data warehouse systems based on client/server configuration meet many challenges when more and more people need to share the data. In this paper, the architecture of web-based warehouse using XML is presented as a solution. And the design of the application server is explained specifically. The architecture is promising because of its prominent advantages.
Study of Technique of Web Database Accessing

Guanding Yu

2011-01-01

Abstract:WEB-based database access technology is the combination of Web technology and database,accessing the database service system created in the B/S structure through a browser.Based on Web database access process,this paper describes the Web database architecture and implementation,moreover,the advantages and disadvantages of several major Web database access technologies are compared and discussed detailedly.All these will help to select the most suitable implementation technology under different applied conditions.
Web-based Data Warehouse System for Process Industry

陈义,宋执环,李平

DOI: https://doi.org/10.3969/j.issn.1006-5911.2003.06.015

2003-01-01

Computer Integrated Manufacturing Systems

Abstract:Based on the information system of large-scale papermaking corporation, this paper analyzes the information flow in process industry, which is consist of three layers such as Business Plan System (BPS), Manufacturing Executive System (MES) and Process Control System (PCS). Comparing the differences of three layers data among the Computer Integrated Production System (CIPS), we present the structure and method of web-based data warehouse.
A Security Model Of Data Warehouse Based-On Active-Defense Technique

Jf Wang,Xh Wang

2005-01-01

Abstract:The Passive-defense technique of data warehouse(DW) security and its limit is simply described in this paper. A security model of data warehouse based-on active-defense technique is presented. The model adopts and integrates the advantages of current Passive-defense technique while considering DW security dynamic properties. The model scans whole system from each aspect and reliably collects system and network information relating to DW security, then intelligent analyses the effective information and alarms or processes discovered security incident. It assesses current security state and implements security measurement through continual cycle feedback. It has secure and effective dynamic management platform and user interface.
WEB SERVICES SECURITY MECHANISM AND SECURITY TECHNOLOGY

Cheng Zhan,Xie Li

DOI: https://doi.org/10.3969/j.issn.1000-386X.2008.10.007

2008-01-01

Abstract:Web Service security problem is one of the highlighted topics in information security area recently.This article presents two security mechanisms for Web Services,transport-level security and message-level security.Then the security technology used to implement message-level security is introduces in detail.Finally,it gives a conclusion to Web Service security and proposes a new Web Service layered security model.
Research of Data Security of Distributed System-based Web Services

CUI Jian-Ming,FAN Li-Lin,WANG Xiao-Dong

DOI: https://doi.org/10.3969/j.issn.1672-6871.2006.03.012

2007-01-01

Abstract:Security and reliability of Web Services-based distributed system is introduced.Main technologies of current Web Services data transfer are analyzed and their weak points discussed.On this base,a detailed solution,which is a combination of encryption and digital signature to communicate with customer-end with canonical XML,is put forward.The transfer security of share data and the reliable trust relation between Web Services Server and customer is enhanced by this solution.
Research on Electric Power Marketing Decision Support System. Based on Data Warehousing

Yi Feng,Ming Zeng,Junguo Jia,Hongdong Li,Xiao Lin

DOI: https://doi.org/10.1049/cp:20061768

2006-01-01

Abstract:The electric power marketing DSS based on the online transaction processing for traditional database tends to fail to meet the requirement of modern power utilities. In recent years the data warehousing technique has been advancing vigorously, and a new decision support system based on data warehousing has become a major area for the study of DSS today. The paper has built up a framework for electric power marketing decision support system, based on the DSS theory and data warehousing, integrating the features of electric power industry. Therefore, an electric power marketing analytical and decision model is created, and a complete solution for the electric power marketing decision system is accomplished incorporating data warehousing products from COGNOS Corp. (6 pages)
Web-Based Distributed Data Communication Systems

Jingming Huang,Yi Zhang,Junhua Xu

DOI: https://doi.org/10.3321/j.issn:1002-8331.2001.10.016

2001-01-01

Abstract:Although Web-based Management Information Systems are accepted by more and more users and system developers,their usages are still restricted by the poor network conditions in many internal companies. According to this situation,this paper introduces a new resolution to the data communication and describes the system architecture and its implementation. The paper also fingers out the suitable conditions and advantages of the system and provides a practical example at last.
Web Log Analysis and Security Assessment Method Based on Data Mining

Jingquan Jin,Xin Lin

DOI: https://doi.org/10.1155/2022/8485014

IF: 3.12

2022-08-27

Computational Intelligence and Neuroscience

Abstract:Web content mining describes the classification, clustering, and attribute analysis of a large number of text documents and multimedia files on the web. Special tasks include retrieval of data from the Internet search engine tool W; structured processing and analysis of web data. Today's blog analysis has security concerns. We do experiments to investigate its safety. Through experiments, we draw the following conclusions: (1) Web log extraction can use efficient data mining algorithms to systematically extract logs from web servers, then determine the main access types or interests of users, and then to a certain extent, based on the discovered user patterns, analyze the user's access settings and behavior. (2) No matter in the test set or the mixed test set, the curve value of deep mining is very stable, the curve value has been kept at 0.95, and the curve value of fuzzy statistics method and quantitative statistics method is stable within the interval of 0.90–095. The results also show that the data mining method has the highest identification accuracy and the best security performance. (3) Web usage analysis requires data abstraction for pattern discovery. This data abstraction can be achieved through data preprocessing, which introduces different formats of web server log files and how web server log data is preprocessed for web usage analysis. One of the most critical parts of the web mining field is web log mining. Web log mining can use powerful data mining algorithms to systematically mine the logs in the web server and then learn the user's access or preferred interests and then conduct a certain degree of user preferences and behavior patterns according to the discovered user patterns. Based on the above analysis, the current web log analysis is faced with security problems. We conduct experiments to study to verify the security performance of web logs and draw conclusions through experiments.

mathematical & computational biology,neurosciences
Interface Design for Web-based Data Mining Algorithm and Data Warehouse

LIU Xinying,WANG Liya

DOI: https://doi.org/10.3969/j.issn.1000-3428.2006.21.031

2006-01-01

Abstract:Web-based data mining on data warehouse is becoming increasingly important.The interface between data mining algorithms and data warehouse is a critical issue.An interface approach is presented.By applying the interface,a Web-based data mining system is developed.Browsers of the client to find knowledge can call the algorithms in the system dynamically.And also the new algorithms can be conveniently added in the Web-based data mining system.
Research of Web Services Attack Technology

WU Ming-feng,ZHANG Yong-sheng,LI Yuan-yuan,HAN Yan-mei

DOI: https://doi.org/10.3969/j.issn.1673-629x.2012.01.055

2012-01-01

Abstract:Web service is characterized by its platform-independence,dynamic,openness and loose coupling.These characteristics greatly facilitate the application-to-application integration based on heterogeneous platform,that an increasing number of enterprise use it.Along with the development of Web services,its safe problem is more and more important.Web service art is attracting attackers and hackers to attack the Web services and the servers on which they run.Organizations are therefore facing the challenge of implementing adequate security for Web services.It detailedly analyzed the characteristics and principle of various attacks on Web service,and pointed out the corresponding detection and prevention countermeasures.On the basis of current research achievements,also presented a discussion on the future research directions and the challenges of Web service defenses against attacks.
DESIGN AND IMPLEMENTATION OF A MEDICAL INSURANCE FUND RISK PREVENTION AND CONTROL DATA WAREHOUSE

Qin Delin,Wang Airong,Chen Cheng,Lin Zhijie,Xiong Yun,Zhu Yangyong

DOI: https://doi.org/10.3969/j.issn.1000-386X.2011.07.022

2011-01-01

Abstract:The Shanghai medical insurance infrastructure is almost completed which is now covering all business sectors and has accumulated rich historical data.However due to the insufficient planning of database design in the past,the data resources are not fully utilised.Therefore it is incapable of providing efficient decision making support.Since the core of decision making support is the data warehouse,we have built a medical insurance fund risk prevention and control data warehouse which is integrated with meta-data management and ETL technology to realise the effective integration of heterogeneous medical insurance data sources to provide a fine database platform for medical insurance fund risk management.The system is performing well after being applied to Shanghai medical insurance fund risk management.
Survey of Security in Database

王德强,张锐,谢立,宋娇

DOI: https://doi.org/10.3969/j.issn.1002-137X.2002.12.004

2002-01-01

Computer Science

Abstract:Being an important part of Information System, Database Security has absorbed much attention fordecades. First, we bring forth the Database Security's contents, properties of data: sensitivity, integrity and availabil-ity. Several access control models to guarantee these properties are described in this paper. Due to the challengesbrought by advanced DBMSs such as OODBMS and ADBMS, we also discuss some security topics in these fields. Atthe end of this paper, the encryption control and inference control are reviewed together with some trend of thedatabase security technology in the future.
Data Warehouse System for Supporting the Financial Decision

Jinxian Lin,Junyi SHEN

DOI: https://doi.org/10.3321/j.issn:1002-8331.2001.08.034

2001-01-01

Abstract:According to the features of the financial computerizing information and its database systems,after analyzing the requirement of financial decision,this paper presents a broad outline of the data warehouse system and the technical essentials for the data-warehousing based on the financial operational data.
A Study on Building Data Warehouse of Hospital Information System.

Li Ping,Wu Tao,Chen Mu,Zhou Bin,Xu Wei-guo

DOI: https://doi.org/10.3760/cma.j.issn.0366-6999.2011.15.022

2011-01-01

Abstract:Background Existing hospital information systems with simple statistical functions cannot meet current management needs. It is well known that hospital resources are distributed with private property rights among hospitals, such as in the case of the regional coordination of medical services. In this study, to integrate and make full use of medical data effectively, we propose a data warehouse modeling method for the hospital information system. The method can also be employed for a distributed-hospital medical service system.Methods To ensure that hospital information supports the diverse needs of health care, the framework of the hospital information system has three layers: datacenter layer, system-function layer, and user-interface layer. This paper discusses the role of a data warehouse management system in handling hospital information from the establishment of the data theme to the design of a data model to the establishment of a data warehouse. Online analytical processing tools assist user-friendly multidimensional analysis from a number of different angles to extract the required data and information.Results Use of the data warehouse improves online analytical processing and mitigates deficiencies in the decision support system. The hospital information system based on a data warehouse effectively employs statistical analysis and data mining technology to handle massive quantities of historical data, and summarizes from clinical and hospital information for decision making.Conclusions This paper proposes the use of a data warehouse for a hospital information system, specifically a data warehouse for the theme of hospital information to determine latitude, modeling and so on. The processing of patient information is given as an example that demonstrates the usefulness of this method in the case of hospital information management. Data warehouse technology is an evolving technology, and more and more decision support information extracted by data mining and with decision-making technology is required for further research. Chin Med J 2011;124(15): 2372-2377
Analysis and research on current situation of structured data desensitization technology

Xiaojuan Guan,Huiqin Li,Wenhua Zhao

DOI: https://doi.org/10.1117/12.2628435

2022-04-22

Abstract:The security of enterprise users' personal privacy information and business sensitive data is the top priority of enterprise information security. This paper analyzed the necessity of data desensitization technology research from the perspective of the severity of sensitive data leakage, expounded the current research status of structured data desensitization from three aspects, such as domestic, foreign and power industry, summarized the classification and technology of structured data desensitization and analyzed their advantages and disadvantages. At the same time, the SQL statement parsing method was analyzed and studied. Finally, the future research direction of structured data desensitization and SQL statement parsing was prospected.
APPLICATION OF DATA WAREHOUSE AND DATA MINING TECHNIQUES TO POWER SYSTEMS

路广,张伯明,孙宏斌

DOI: https://doi.org/10.3321/j.issn:1000-3673.2001.08.013

2001-01-01

Abstract:A data warehouse is a decision supporting, sub- ject-oriented, assemble, stable and time-dependent collection of data, comparing with data warehouse a data mart is a smaller and centralized one. Data Mining is a data-analyzing and knowledge-acquiring procedure by use of artificial intelli- gence. These new database technologies are introduced in this paper, their application achievements in electric power enter- prises are analyzed, and the current situation and prospect of applying data warehouse and data mart to electric power en- terprises are discussed.
Design and Implementation of Data Integrating and Publication System Based Web

田志博,孙政顺

DOI: https://doi.org/10.3969/j.issn.1000-1220.2003.12.051

2003-01-01

Abstract:By analyzing the diversiform storage of enterprise data and their mode, this paper presents the design and implementation of a data integrating and publication system based on web. This information system solves the integrated application of structured data and unstructured data, and integrates some important enterprise applications.

Study of Web-based Data Warehouse and Security

Construction of security architecture of web services based EAI

Security Issues in Data Warehouse

The research of web-based data warehouse using XML

Study of Technique of Web Database Accessing

Web-based Data Warehouse System for Process Industry

A Security Model Of Data Warehouse Based-On Active-Defense Technique

WEB SERVICES SECURITY MECHANISM AND SECURITY TECHNOLOGY

Research of Data Security of Distributed System-based Web Services

Research on Electric Power Marketing Decision Support System. Based on Data Warehousing

Web-Based Distributed Data Communication Systems

Web Log Analysis and Security Assessment Method Based on Data Mining

Interface Design for Web-based Data Mining Algorithm and Data Warehouse

Research of Web Services Attack Technology

DESIGN AND IMPLEMENTATION OF A MEDICAL INSURANCE FUND RISK PREVENTION AND CONTROL DATA WAREHOUSE

Survey of Security in Database

Data Warehouse System for Supporting the Financial Decision

A Study on Building Data Warehouse of Hospital Information System.

Analysis and research on current situation of structured data desensitization technology

APPLICATION OF DATA WAREHOUSE AND DATA MINING TECHNIQUES TO POWER SYSTEMS

Design and Implementation of Data Integrating and Publication System Based Web