Business rules and data warehouse are concepts and technologies that impact a wide variety of organizational tasks. In general, each area has evolved independently, impacting application development and decision-making. Generating knowledge from data warehouse is a complex process. This paper outlines an approach to ease import of information and knowledge from a data warehouse star schema thro...

As the database environment changing, database is no longer accessed only by using SQL to communicate with DBMS as in the two-tier client-server architecture. In modern enterprise distributed systems, applications are developed and deployed as components in n-tier architecture. Database system is integrated with related applications and can only be accessed via interfaces provided by the applic...

Microsoft SQL Server was successful for many years for transaction processing and decision support workloads with neither merge join nor hash join, relying entirely on nested loops and index nested loops join. How much difference do additional join algorithms really make, and how much system performance do they actually add? In a pure OLTP workload that requires only record-to-record navigation...

This paper describes the design, implementation and testing of a set of software modules that are used for remote database access in a distributed computing environment. The goal of our research and development is to implement a client server model using Structured Query Language (SQL) functions in the Open Software Foundation’s (OSF) distributed computing environment (DCE). This design is comp...

Storing large amounts of data in an efficient way from the point of view of very fast retrieval is an important requirement for many industries like KEMA, a company offering consulting, testing and certification in the energy business. Because their relational database could not cope fast enough with the large amounts of data involved, an alternative way for data storage was proposed, called Hi...

SQL Injection (SQLI) is a common vulnerability found in web applications. The starting point of SQLI attack is the client-side (browser). If attack inputs can be detected early at the browse side, then it could be thwarted early by not forwarding the malicious inputs to the server-side for further processing. This paper presents a client-side approach to detect SQLI attacks. The client-side acc...

Traditional database security mechanisms are very limited in defending successful data attacks. Authorized but malicious transactions can make a database useless by impairing its integrity and availability. This paper presents the design of a real-time data attack isolation system, denoted DAIS. DAIS isolates likely suspicious actions before a definite determination of intrusion is reported. In...

We present the results of an availability benchmarking study of a three-tier transactionprocessing-oriented database system based on Microsoft SQL Server 2000. Following the general availability benchmarking methodology introduced by our previous work on software RAID systems, we carried out a set of fault-injection experiments in which we measured the effects of 14 different types of realistic...

This project deals with the problems of utilization of mobile equipment working in the biomedicine field, particularly telemedicine. The whole system is based on the architecture of .NET Compact Framework, and other products, such as SQL Server by Microsoft too. The mobile equipments are used primarily for measuring and processing of data from the sensors and their visualization as a graph. The...