7,770 Hits in 3.8 sec

Facilitating SQL Query Composition and Analysis [article]

Zainab Zolaktaf, Mostafa Milani, Rachel Pottinger
2020 arXiv   pre-print
These results are encouraging and confirm that SQL query workloads and data-driven machine learning methods can be leveraged to facilitate query composition and analysis.  ...  Formulating efficient SQL queries requires several cycles of tuning and execution, particularly for inexperienced users.  ...  We introduce additional problems related to facilitating query composition and analysis, e.g., session classification.  ... 
arXiv:2002.09091v1 fatcat:bvvvrugpbvh2tmmohz32anf47m

SQL/SDA: a query language for supporting spatial data analysis and its Web-based implementation

Hui Lin, Bo Huang
2001 IEEE Transactions on Knowledge and Data Engineering  
The client side of SQL/SDA, programmed in the Java language, provides a query interface by introducing visual constructs such as icons, listboxes, and comboboxes to assist in the composition of queries  ...  The server side of SQL/SDA, which is composed of a query processor and Spatial Database Engine (SDE), carries out query processing on spatial databases after receiving user requests.  ...  In this sense, the design of SQL/SDA is an attempt to advance the current spatial query languages and specifications mentioned above to facilitate stepwise analysis of spatial data.  ... 
doi:10.1109/69.940739 fatcat:rcbi54msdva3zez54am2jwimly

The Detection Model of Malignant Query and Personal Information Leakage based on Log Analysis

Gei-Young Kim, Kyung-Jin Jung, Yongtae Shin, Sangphil Kim, Jong-Bae Kim
2015 International Journal of Multimedia and Ubiquitous Engineering  
detect malignant queries and personal information leakage through security log analysis.  ...  Also we showed that the analysis method suggested by this treatise is excellent in availability and credibility in detection of malignant queries and personal information leakage, by comparing traditional  ...  Multi-Dimensional Model of Security Log Analysis This model is composed in a way to facilitate analyzing security log files by domain, such as DB server access analysis, SQL implementation analysis, SQL-based  ... 
doi:10.14257/ijmue.2015.10.11.10 fatcat:6lvspyb7gjcidbudpwmgp7nhhy

A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL

Alka Malik, Rahul Rishi
2015 International Journal of Computer Applications  
End user is required to issue SQL query to retrieve information from the database.  ...  To provide the direct access of user on dataset, some unstructured query processor is required. The present work is an interface that will convert the unstructured text query to structured SQL query.  ...  Author defined the text to query processing under the SQL query analysis and processing.  ... 
doi:10.5120/20325-2444 fatcat:vdjjmag3ajhjpougqjkguopc7a

SQLAS: Tool To Detect And Prevent Attacks In Php Web Applications

Vandana Dwivedi, Himanshu Yadav, Anurag Jain
2015 International Journal of Security Privacy and Trust Management  
In this paper we present SQL Attack Scanner (SQLAS) a Tool which can detect & prevent SQL injection Attack in web applications.  ...  Web application injection attacks, such as SQL injection (SQLIA), Cross-Site Scripting (XSS) and Cross-Site Request Forgery (XSRF) are major threats to the security of the Web Applications.  ...  EXPERIMENTAL ANALYSIS For the Experimental analysis of proposed method we developed a Testbed, which is coded in JAVASCRIPT and able to run SQL queries of web Applications.  ... 
doi:10.5121/ijsptm.2015.4103 fatcat:aywiwd35zfajvbg56r42x77tle

FFI: a software tool for ecological monitoring

Duncan C. Lutes, Nathan C. Benson, MaryBeth Keifer, John F. Caratti, S. Austin Streetman
2009 International journal of wildland fire  
A new monitoring tool called FFI (FEAT/FIREMON Integrated) has been developed to assist managers with collection, storage and analysis of ecological information.  ...  FFI provides software components for: data entry, data storage, Geographic Information System, summary reports, analysis tools and Personal Digital Assistant use.  ...  Queries, reports and analysis FFI includes the query features found in FEAT with added functionality to allow data to be queried from user defined protocols designed in the Protocol Manager.  ... 
doi:10.1071/wf08083 fatcat:4ed5k42tpbecldn77ae32mjw7a

Synergistic graph and SQL analytics inside IBM Db2

Yuanyuan Tian, Wen Sun, Sui Jun Tong, En Liang Xu, Mir Hamid Pirahesh, Wei Zhao
2019 Proceedings of the VLDB Endowment  
Db2 Graph is an in-DBMS graph query approach. It is implemented as a layer inside an experimental IBM Db2™, and thus can support synergistic graph and SQL analytics efficiently.  ...  We use an example scenario on health insurance claim analysis to demonstrate how Db2 Graph is used to support synergistic graph and SQL analytics inside Db2. PVLDB Reference Format:  ...  In Db2 Graph, we add optimized strategies in the Traversal Strategy component to combine multiple steps into one composite step and to translate the composite step into an optimized SQL query.  ... 
doi:10.14778/3352063.3352065 fatcat:o3z57sctrnfv5bahwty3r2k6oi

Business Rules For Data Warehouse

Rajeev Kaula
2009 Zenodo  
The star schema structure and the business rules are stored within a relational database. The approach is explained through a prototype in Oracle-s PL/SQL Server Pages.  ...  Business rules and data warehouse are concepts and technologies that impact a wide variety of organizational tasks.  ...  Essentially, each business rule is processed through a SQL query using dynamic SQL concepts. Once the query is executed, its results are further processed to validate the business rule.  ... 
doi:10.5281/zenodo.1059611 fatcat:fibldmhtwrg5hjxu2i77ov7wk4

Cross-platform provenance

Ashish Gehani, Dawood Tariq
2013 Proceedings of the Joint EDBT/ICDT 2013 Workshops on - EDBT '13  
To facilitate the development of crossplatform query and analysis tools, we have collected data * provenance (using SPADE [6, 12]) from the same applications (Apache, BLAST, and PostMark) run on different  ...  be augmented to facilitate query interoperability [4].  ...  To facilitate the development of crossplatform query and analysis tools, we have collected data Copyright is held by the author/owner(s).  ... 
doi:10.1145/2457317.2457378 dblp:conf/edbt/GehaniT13 fatcat:yiorm2kbqjckfn3ur5d4yyzu7a

A Comparative Analysis of Spatial Indexing Schemes in PostGreSQL/PostGIS Using Java-API

Monika Yadav
2018 International Journal of Emerging Research in Management and Technology  
The comparison is performed on five categories of spatial and non spatial queries ,namely Simple SQL, Geometry, Spatial Relational ship, Spatial Join and Nearest Neighborhood based on benchmark dataset  ...  In this paper a comparative analysis is performed on three spatial indexing techniques- GiST (Generalized Search Tree), SP_GiST (Space partition Generalized Search Tree) and R-tree (Rectangle tree) in  ...  for executing simple SQL queries.  ... 
doi:10.23956/ijermt.v6i6.291 fatcat:26oqpt3rsfhhjluxqpklqstbj4

Enhancing ER Diagrams to View Data Transformations Computed with Queries

Carlos Ordonez, Ladjel Bellatreche
2019 International Workshop on Data Warehousing and OLAP  
The explanation is simple: a relational database has a collection of tables that are joined and aggregated with complex relational queries, and whose columns are transformed with complex SQL expressions  ...  More importantly, similar SQL queries tend to be written multiple times, creating problems in database evolution, disk space utilization and software maintenance.  ...  The first consideration is notation for queries. SQL has bag semantics and SQL queries tend to be verbose.  ... 
dblp:conf/dolap/0001B19 fatcat:x7b253w2uvasdfhzgvah75sncm

Genome sequence analysis with MonetDB

Robin Cijvat, Stefan Manegold, Martin Kersten, Gunnar W. Klau, Alexander Schönhuth, Tobias Marschall, Ying Zhang
2015 Datenbank-Spektrum  
Biologists are often exposed to excessively time consuming and error-prone data management and analysis hurdles.  ...  In this paper, we propose a database management system (DBMS) based approach to accelerate and substantially simplify genome sequence analysis.  ...  Moreover, this work does not consider additional DBMS functionality to facilitate genomic data analysis. Schapranow et al.  ... 
doi:10.1007/s13222-015-0198-x fatcat:jt7wfikh7jfdpfnb2ohhutqfha

Unlocking Data for Clinical Research – The German i2b2 Experience

S. Mate, K Helbing, U. Sax, H.U. Prokosch, T. Ganslandt
2011 Applied Clinical Informatics  
Limitations were found regarding query performance in comparison to native SQL and certain temporal queries.  ...  Query performance was measured in comparison to native SQL queries. A setup and administration tool for i2b2 was developed. An extraction tool for CDISC ODM data was programmed.  ...  analysis.  ... 
doi:10.4338/aci-2010-09-cr-0051 pmid:23616864 pmcid:PMC3631913 fatcat:xziannsm2jf53cupmftjamu3v4

Datenbank-DIALOG and the relevance of habitability

Harald Trost, Wolfgang Heinz, Johannes Matiasek, Ernst Buchberger
1992 Proceedings of the third conference on Applied natural language processing -  
The parser l)erforms syntactic and semantic analysis creating one or--in case of ambiguities--more caseframes containing the query representation at the domain level.  ...  The scanner breaks up the natural language query into tokens for morphological analysis.  ...  The scanner breaks up the natural language query into tokens for morphological analysis.  ... 
doi:10.3115/974499.974547 dblp:conf/anlp/TrostHMB92 fatcat:sv3cec2tyffznmljooqe25kz5e

A Hybrid Semantic Parsing Approach for Tabular Data Analysis [article]

Yan Gao, Jian-Guang Lou, Dongmei Zhang
2019 arXiv   pre-print
This paper presents a novel approach to translating natural language questions to SQL queries for given tables, which meets three requirements as a real-world data analysis application: cross-domain, multilingualism  ...  We also achieve promising results on a small dataset for more complex queries in both English and Chinese, which demonstrates our language expansion and quick-start ability.  ...  , and then further convert it to SQL query.  ... 
arXiv:1910.10363v2 fatcat:56juld4hkrd5rlgvxduatguvca
« Previous Showing results 1 — 15 out of 7,770 results