We present the SQL Performance Analyzer, a novel approach in Oracle Database 11g to testing database changes, such as upgrades, parameter changes, schema changes, and gathering optimizer statistics. The SQL Performance Analyzer offers a comprehensive solution to enable users to forecast and analyze how a system change will impact SQL query plans and run time performance, so they can tune their ...

Актуальність. Розмір баз даних, який відноситься до обсягу збережених може значно варіюватися. Зрозуміло, що чим більший розмір бази тим більше часу потрібно на пошук необхідної інформації, призводить збільшення обробки запитів сервером. З одного боку, цю проблему вирішують шляхом підвищення продуктивності комп'ютерів, яких розташовані системи управління базами даних (СУБД). Однак, просто комп'...

<span>SQL injections attacks have been rated as the most dangerous vulnerability of web-based systems over more than a decade by OWASP top ten. Though different static, runtime and hybrid approaches proposed to counter SQL injection attacks, no single approach guarantees flawless prevention/ detection for these attacks. Hundreds components open source commercial software products are repo...

Recent developments in atomic physics have enabled the experimental generation of many-body entangled states to boost performance quantum sensors beyond Standard Quantum Limit (SQL). This limit is imposed by inherent projection noise a measurement. In this Perspective article, we describe commonly used methods create operate SQL. particular, focus on potential applying entanglement state-of-the...

Devising a scheme for efficient and scalable querying of Resource Description Framework (RDF) data has been an active area of current research. However, most approaches define new languages for querying RDF data, which has the following shortcomings: 1) They are difficult to integrate with SQL queries used in database applications, and 2) They incur inefficiency as data has to be transformed fr...

Queries that involve words like "every", "only", etc., are generally difficult to formulate in SQL. In this paper, we analyze the problems and propose a set of set-comparison operators to enhance the usability of SQL. These operators allow users to formulate conventionally difficult queries in an easier way, greatly enhancing the user-friendliness of SQL. Keywords-Query Processing, SQL language...

In this paper, we define models for automatically translating a factoid question in natural language to an SQL query that retrieves the correct answer from a target relational database (DB). We exploit the DB structure to generate a set of candidate SQL queries, which we rerank with an SVM-ranker based on tree kernels. In particular, in the generation phase, we use (i) lexical dependencies in t...