This paper presents the evaluation of the architecture of healthcare data warehouse specific to cancer diseases. This data warehouse containing relevant cancer medical information and patient data. The data warehouse provides the source for all current and historical health data to help executive manager and doctors to improve the decision making process for cancer patients. The evaluation mode...

This white paper examines the application of managing Microsoft SQL Server in a storage environment utilizing multiple storage configurations to optimize performance cost-effectiveness of storage allocations. Practical examples are provided of automated data movement between Storage Types to meet performance requirements for SQL Server databases and cost-effectiveness of EMC Symmetrix VMAXTM re...

Microsoft SQL Server is a multi-component database management system taking advantage of many features of the underlying operating system. Obtaining a breakdown of its workload by categories such as users and applications requires a non-standard approach. This paper describes such an approach as well as architectural features of MS SQL Server relevant for workload analysis and capacity planning.

Event-condition-action (or ECA) rules are used to capture active capability. While a number of research prototypes of active database systems have been built, ECA rule capability in Relational DBMSs is still very limited. In this paper, we address the problem of turning a traditional database management system into a full-fledged active database system without changing the underlying system. Th...

Selectivity estimation refers to the ability of SQL query optimizer estimate size results a predicate in query. It is main calculation based on which can select least expensive plan execute. While problem has been known since mid-1970s, we were surprised that there are no solutions literature for selectivity inequality joins. By testing four common database systems: Oracle, SQL-Server, PostgreS...

As the capabilities and service levels of enterprise database systems have evolved, they have collided with incumbent technologies such as TP-Monitors or Message Oriented Middleware (MOM). Webelieve this trend will continue and have architected the upcoming release of SQL Server to advance thistechnology trend. This paper describes the Service Oriented Database Architecture (SODA) devel...

With the increasing importance of the internet in our day-to-day life, data security in web application has become very crucial. Ever increasing online and real time transaction services have led to manifold rise in the problems associated with the database security. Attacker uses illegal and unauthorized approaches to hijack the confidential information like username, password and other vital ...

SQL Injection attacks and Cross-Site Scripting attacks are the two most common attacks on web application. Proposed method is a new policy based Proxy Agent, which classifies the request as a scripted request, or query based request, and then, detects the respective type of attack, if any in the request. This method detects both SQL injection attack as well as the Cross-Site Scripting attacks. ...