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

<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...

Exporting XML views of relational data gives rise to the problem of translating XML queries into SQL. To date, the focus of most of the work in the published literature [9, 14, 20] has been on mechanisms for correctly translating complex XML queries into SQL queries, with less emphasis on evaluating the quality of the resulting SQL queries. The efficiency of the SQL queries generated by the tra...

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...

We propose a new approach to temporal extensions of SQL. Unlike the current proposals, e.g., SQL/Temporal, we use point-based references to time as the basis of our approach. The proposed language| SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a single data type to represent a linearly ordered universe of individual time instants. Such an extension allows th...

Formulating SQL queries involving joins is tedious, error-prone, and requires in-depth schema knowledge. We demonstrate a modified version of SQL [2] that does not require specification of table references and joins. The Schema-Free SQL system can expresses queries not supported in keyword-based searches [1]. Unlike Universal Relation approaches, the system is scaleable to large schemas, and it...

This paper introduces the algorithm that MatBase (an intelligent knowledge and database management system prototype) uses for enforcing acyclicities of binary Cartesian function products, characterizes it -proving is complete, sound, optimal, linear- and, besides its pseudocode embedding SQL, also provides an example implementation in standard ANSI-99 SQL MS VBA.