This white paper describes how SQL Server 2008 consolidation can solve problems associated with multiple SQL servers in an organization. The paper offers several methods for consolidating applications using Microsoft SQL Server 2008 and compares those methods by linking key decision points to business requirements.

Network firewalls, IPS, and even some dedicated Web application firewall technologies attempt to identify SQL injection via traditional signature-based protections. Signature protections attempt to identify and block SQL injection-related text patterns within Web traffic flows. Unfortunately, real world experience has proven that reliance upon signatures alone is not enough to defeat SQL Inject...

Attribute information in a natural language query is one of the key features for converting a natural language query into a Structured Query Language1 (SQL) in Natural Language Interface to Database systems. In this paper, we explore the task of classifying the attributes present in a natural language query into different SQL clauses in a SQL query. In particular, we investigate the effectivene...

Many software systems include a web-based element that makes them available to the public via the internet and can expose them to a variety of web-based attacks. One of these attacks is SQL injection which can give attackers illegal access to the databases. This paper presents a way to prevent web applications against SQL injection. Pattern matching is a system that can be used to distinguish o...

Relational data query always plays an important role in data analysis. But how to scale out the traditional SQL query system is a challenging problem. In this paper, we introduce a fast, high throughput and scalable system to perform read-only SQL well with the advantage of NoSQL’s distributed architecture. We adopt HBase as the storage layer and design a distributed query engine (DQE) collabor...

SQL:2007, die sich momentan noch in Entwicklung befindende nächste Version der SQLNorm, erweitert den aus SQL:2003 bekannten SQL-Datentyp ” XML“. Als Instanzen dieses Datentyps sind nun auch komplette XQuery-Sequenzen erlaubt. Infolgedessen können SQL:2007-Anfrageergebnisse vollständige XQuery-Sequenzen als Attributwerte besitzen. Damit stellt sich die Frage, wie XQuery-Sequenzen, die im Anfrag...

Within the big data tsunami, relational databases and SQL are still there and remain mandatory in most of cases for accessing data. On the one hand, SQL is easy-to-use by non specialists and allows to identify pertinent initial data at the very beginning of the data exploration process. On the other hand, it is not always so easy to formulate SQL queries: nowadays, it is more and more frequent ...