Spatial analysis is a fundamental function for geographic information systems. Although it is popular in many commercial desktop GIS packages, this capability is very limited in a Web-GIS environment, especially when relational database is used for geospatial data management. This paper proposes and prototypes a methodology to enhance spatial analysis capabilities of Web-GIS by extending and en...

This paper describes an advanced SQL injection technique where DNS resolution process is exploited for retrieval of malicious SQL query results. Resulting DNS requests are intercepted by attackers themselves at the controlled remote name server extracting valuable data. Open source SQL injection tool sqlmap [1] has been adjusted to automate this task. With modifications done, attackers are able...

This paper proposes an approach to generate XML views of relational data, using SQL/XML. The paper first specify the conditions for a set of correspondence assertions to fully specify the view in terms of the relational schema and, if so, we show that the mappings defined by the view correspondence assertions can be expressed as SQL/XML view definition. This paper focuses on an algorithm that a...

We show how to translate expressions in a higher-order programming language into SQL queries. Somewhat surprisingly, we show that any suitable expression translates to a single SQL query, where the suitability is determined by a type-and-e ect check. Thus, unlike in Hollywood where a script-writer can never be sure a movie sequel will be popular, we show how to be sure that your SQL|written in ...

Quantum sensors offer the capability to reach unprecedented precision by operating at standard quantum limit (SQL) or beyond using entanglement. But an emerging class of that use Rydberg electromagnetically induced transparency (EIT) detect rf electric fields have yet SQL. In this work we prove discrepancy is due fundamental limitations in EIT probing mechanism. We derive optimum sensitivity a ...

Current SQL aggregation functions have evident limitations for computing percentages, for which this paper proposes two SQL aggregation functions. The two novel aggregation functions are easy to use, which have wide applicability and can be efficiently evaluated. They may be used as a framework to study percentage queries and to generate efficient SQL code. Experiments compare our proposed perc...

This paper presents the development of a graphical SQL query tool that allows novice and non-technical users to navigate through database tables and generate their own queries. The tool enables the query output to be presented in graphical and tabular forms, which can help users, especially top management in better understanding and interpreting query results. The algorithms to construct comple...

This paper describes a model that integrates the execution of triggers with the evaluation of declarative constraints in SQL database systems. This model achieves full compatibility with the 1992 international standard for SQL (SQL92). It preserves the set semantics for declarative constraint evaluation while allowing the execution of powerful procedural triggers. It was implemented in DB2 for ...

In the last years, many research directed for concurrency control mechanism, scheduling policy and query language in real-time database are being done. This paper presents an extensions of standard query language (SQL), called SQL-99. SQL-99 includes oriented-object functionalities. The query language for real-time database (QL-RTDB) to provide support the real-time requirements imposed the bot...

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