Search Results - "SQL Query"
-
1
The Examination of SQL Queries Efficiency in Chosen IT System
ISSN: 2544-0764, 2544-0764Published: Lublin University of Technology 30.09.2023Published in Journal of Computer Sciences Institute (30.09.2023)“…Optimization of SQL queries is an important part of any system using a database. Several different optimization methods have been selected and presented in…”
Get full text
Journal Article -
2
A declarative approach to detecting design patterns from Java execution traces and source code
ISSN: 0950-5849, 1873-6025Published: Elsevier B.V 01.07.2024Published in Information and software technology (01.07.2024)“…Design patterns are invaluable for software engineers because they help obtain well-structured and reusable object-oriented software components and contribute…”
Get full text
Journal Article -
3
ASKSQL: Enabling cost-effective natural language to SQL conversion for enhanced analytics and search
ISSN: 2666-8270, 2666-8270Published: Elsevier Ltd 01.06.2025Published in Machine learning with applications (01.06.2025)“…Natural Language to SQL (NL2SQL) for database query and search has been a significant research focus in recent years. However, existing methods have…”
Get full text
Journal Article -
4
Research on Question Understanding Method Combining Database Structure and Content
ISSN: 1000-3428Published: Editorial Office of Computer Engineering 01.03.2021Published in Ji suan ji gong cheng (01.03.2021)“…Question understanding is an important basis for the model to transform natural language questions into SQL.At present,most of the models using deep learning…”
Get full text
Journal Article -
5
The big data system, components, tools, and technologies: a survey
ISSN: 0219-1377, 0219-3116Published: London Springer London 01.09.2019Published in Knowledge and information systems (01.09.2019)“…The traditional databases are not capable of handling unstructured data and high volumes of real-time datasets. Diverse datasets are unstructured lead to big…”
Get full text
Journal Article -
6
Data generation for testing and grading SQL queries
ISSN: 1066-8888, 0949-877XPublished: Berlin/Heidelberg Springer Berlin Heidelberg 01.12.2015Published in The VLDB journal (01.12.2015)“…Correctness of SQL queries is usually tested by executing the queries on one or more datasets. Erroneous queries are often the results of small changes or…”
Get full text
Journal Article -
7
Integrity Authentication for SQL Query Evaluation on Outsourced Databases: A Survey
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.04.2021Published in IEEE transactions on knowledge and data engineering (01.04.2021)“…Spurred by the development of cloud computing, there has been considerable recent interest in the Database-as-a-Service (DaaS) paradigm. Users lacking in…”
Get full text
Journal Article -
8
Speech-to-SQL: toward speech-driven SQL query generation from natural language question
ISSN: 1066-8888, 0949-877XPublished: Berlin/Heidelberg Springer Berlin Heidelberg 01.07.2024Published in The VLDB journal (01.07.2024)“…Speech-based inputs have been gaining significant momentum with the popularity of smartphones and tablets in our daily lives, since voice is the most popular…”
Get full text
Journal Article -
9
Enabling Smart Transportation Systems: A Parallel Spatio-Temporal Database Approach
ISSN: 0018-9340, 1557-9956Published: New York IEEE 01.05.2016Published in IEEE transactions on computers (01.05.2016)“…We are witnessing increasing interests in developing "smart cities" which helps improve the efficiency, reliability, and security of a traditional city. An…”
Get full text
Journal Article -
10
A novel method for SQL injection attack detection based on removing SQL query attribute values
ISSN: 0895-7177, 1872-9479Published: Elsevier Ltd 2012Published in Mathematical and computer modelling (2012)“…SQL injection or SQL insertion attack is a code injection technique that exploits a security vulnerability occurring in the database layer of an application…”
Get full text
Journal Article -
11
Program execution summarization by novel design pattern specification, detection, and consolidation techniques
ISSN: 2590-0056, 2590-0056Published: Elsevier Inc 01.12.2025Published in Array (New York) (01.12.2025)“…Programming languages have evolved to embrace higher levels of abstraction, with object-oriented languages like Java and C# becoming dominant in large-scale…”
Get full text
Journal Article -
12
Interactively discovering and ranking desired tuples by data exploration
ISSN: 1066-8888, 0949-877XPublished: Berlin/Heidelberg Springer Berlin Heidelberg 01.07.2022Published in The VLDB journal (01.07.2022)“…Data exploration—the problem of extracting knowledge from database even if we do not know exactly what we are looking for —is important for data discovery and…”
Get full text
Journal Article -
13
Automated Grading of SQL Queries
ISSN: 2375-026XPublished: IEEE 01.04.2019Published in Data engineering (01.04.2019)“…Grading student SQL queries manually is a tedious and error-prone process. The XData system, developed at IIT Bombay, can be used to test if a student query is…”
Get full text
Conference Proceeding -
14
Scalable and data-aware SQL query recommendations
ISSN: 0306-4379, 1873-6076Published: Oxford Elsevier Ltd 01.02.2021Published in Information systems (Oxford) (01.02.2021)“…SQL query recommendation suggests an SQL statement to a user, based on his submitted requests and on queries of other users stored in a log. Such methods need…”
Get full text
Journal Article -
15
The method of student's query analysis while intelligent computer tutoring in SQL
ISSN: 1814-4225, 2663-2012Published: National Aerospace University «Kharkiv Aviation Institute 02.06.2021Published in Radìoelektronnì ì komp'ûternì sistemi (Online) (02.06.2021)“…Recently, IT specialties have become one of the most demanded specialties in the world labor market. Simultaneously the traditional teaching in conditions of…”
Get full text
Journal Article -
16
On the Usefulness of SQL-Query-Similarity Measures to Find User Interests
ISSN: 1041-4347, 1558-2191Published: New York IEEE 01.10.2020Published in IEEE transactions on knowledge and data engineering (01.10.2020)“…In the sciences and elsewhere, the use of relational databases has become ubiquitous. An important challenge is finding hot spots of user interests. In…”
Get full text
Journal Article -
17
Guided SQL-Based Data Exploration with User Feedback
ISSN: 2375-026XPublished: IEEE 13.05.2024Published in Data engineering (13.05.2024)“…The exploration of large, real-world databases poses major challenges to users due to their volume and complexity. SQL is the preferred language for data…”
Get full text
Conference Proceeding -
18
A hybrid framework for detecting structured query language injection attacks in web-based applications
ISSN: 2088-8708, 2722-2578, 2088-8708Published: Yogyakarta IAES Institute of Advanced Engineering and Science 01.10.2022Published in International journal of electrical and computer engineering (Malacca, Malacca) (01.10.2022)“…Almost every web-based application is managed and operated through a number of websites, each of which is vulnerable to cyber-attacks that are mounted across…”
Get full text
Journal Article -
19
Multi-Tenant Intrusion Detection Framework as a Service for SaaS
ISSN: 1939-1374, 2372-0204Published: Piscataway IEEE 01.09.2022Published in IEEE transactions on services computing (01.09.2022)“…Information technology (IT) service providers are nowadays moving toward cloud computing. Software-as-a-service (SaaS) refers to cloud service-oriented web…”
Get full text
Journal Article -
20
Bootstrap aggregative mean shift clustering for big data anti-pattern detection analytics in 5G/6G communication networks
ISSN: 0045-7906, 1879-0755Published: Amsterdam Elsevier Ltd 01.10.2021Published in Computers & electrical engineering (01.10.2021)“…•Identify anti-patterns in SQL query log database.•Minimize false-positive rate while detecting anti-patterns.•Improve the performance of anti-patterns…”
Get full text
Journal Article