Skip to content
Free planNo credit card requiredStart writing
AI for Research home
AI for Research home
Dashboard
Sign inGet started

Search 250 million research papers

Read the abstract, see who wrote it and who cites it, and get the citation in APA, MLA, Chicago or Harvard.

About 3,718 papers for “SQL query language”

Structured Query Language (SQL)

Heinz Axel Pürner, Beate Pürner · 1994

DB2/2 besitzt als relationales Datenbankmanagement-System natürlich Befehle der Structured Query Language (SQL), die Sie im Query Manager oder in der DBM-Kommandozeile eingeben. Mit diesen Befehlen können Sie in der Datenbank

Cited by 1

Basic Structured Query Language (SQL)

Jonathan Eckstein, Bonnie R. Schultz · 2017

This chapter presents the basics of Structured Query Language (SQL) through numerous examples. It describes all the principle components of the SELECT statement, including the FROM, WHERE, and ORDER BY clauses. It covers aggregation queries, including aggregation functions, the GROUP BY clause, the HAVING clause, and how WHERE and HAVING differ. It also describes the principles of inner joins and the conceptual sequence of operations in every SELECT query.

Cited by 1

Conversion of Natural Language Query to SQL Query

Abhilasha Kate, Satish Kamble, Aishwarya Bodkhe et al. · 2018 Second International Conference on Electronics, Communication and Aerospace Technology (ICECA) · 2018

This paper present an approach to automate the conversion of Natural Language Query to SQL Query effectively. Structured Query Language is a powerful tool for managing data held in a relational database management system. To retrieve or manage data user have to enter the correct SQL Query. But the users who don't have any knowledge about SQL are unable to retrieve the required data. To overcome this we proposed a model in Natural Language Processing for converting the Natural Language Query to SQL query. This helps novice user to get required content without knowing any complex details about SQL. This system can also deal with complex queries. This system is designed for Training and Placement cell officers who work on student database but don't have any knowledge about SQL. In this system, user can also enter the query using speech. System will convert speech into the text format. This query will get transformed to SQL query. System will execute the query and gives output to the user.

Cited by 46

Structured query language (SQL) related tools

Wei Ke · Iowa State University Digital Repository (Iowa State University) · 2006

The widespread adoption of web services as an instant means of information dissemination and various other transactions, including those having financial consequences, have essentially made them a key component of today's Internet infrastructure. Underneath the infrastructure, relational database plays an important role, in a sense, as organizing data and making the retrieval and insertion of the data in an efficient and secure fashion. Structured Query Language (SQL) is designed to query data contained in a relational database. SQL is important as it is the only way for a user to interact with a relational database. But little focus has been put on SQL because people consider SQL as a simple language. But in fact, SQL legacy code repository could be as huge as some mainstream languages such as C, Java etc. In this paper, we focus on SQL Injection Attacks and SQL Code Coverage.

Cited by 0

Structured Query Language (<scp>SQL</scp>) Fundamentals

D. Curtis Jamison · Current Protocols in Bioinformatics · 2003

Relational databases provide the most common platform for storing data. The Structured Query Language (SQL) is a powerful tool for interacting with relational database systems. SQL enables the user to concoct complex and powerful queries in a straightforward manner, allowing sophisticated data analysis using simple syntax and structure. This unit demonstrates how to use the MySQL package to build and interact with a relational database.

Cited by 40

Intelligent SQL query generation from natural language

Kudrin, Semen · Theseus (Ammattikorkeakoulujen) · 2025

The development of information processing technologies has traditionally aimed to simplify the interaction between humans and machines. The shift from machine code to high-level programming languages has made software development more accessible, but working with databases still demands specialized knowledge and remains inaccessible to a wide range of users. The purpose of this thesis was to create a system that allows users to obtain data using common language queries without the need to learn specialized programming languages. This approach aimed to remove the main technical barrier, making information more accessible. The thesis addresses several technical challenges in dealing with SQL: accurately interpreting natural language, automatically retrieving relevant data, and minimizing errors in command generation. Particular emphasis was placed on ensuring system flexibility for diverse data types and usage scenarios. The theoretical foundation explores how people can interact with databases using everyday language. It discusses the difficulties of translating such language into correct data requests, especially when working with location-based information. The study looks at existing solutions and highlights the need for tools that help users get the right results without needing to understand technical query languages. The result is a tool that not only simplifies access to information but also opens new opportunities for integration with analytical and visualization platforms where ease of data retrieval is fundamentally important.

Cited by 0Open access

Natural Language Statement to SQL Query Translator

Pranali P.Chaudhari · International Journal of Computer Applications · 2013

A Database is an organized collection of data. It is created to store large amount of data and retrieve it efficiently in less amount of time. To retrieve data from the database Structured Query Language (SQL) is used. SQL has its own syntax of query. To retrieve correct data from the database this query should be written in proper or correct syntax. Thus users should have sufficient knowledge of SQL to retrieve data. In this paper a light weight technique of converting a natural language statement into equivalent SQL statement is highlighted which when executed on database provides us with the accurate results. The main advantage of this technique is the users which are unknown to the syntax of SQL can also use the system and retrieve data.

Cited by 6Open access

Spatial SQL: a query and presentation language

Max J. Egenhofer · IEEE Transactions on Knowledge and Data Engineering · 1994

Recently, attention has been focused on spatial databases, which combine conventional and spatially related data, such as geographic information systems, CAD/CAM, or VLSI. A language has been developed to query such spatial databases. It recognizes the significantly different requirements of spatial data handling and overcomes the inherent problems of the application of conventional database query languages. The spatial query language has been designed as a minimal extension to the interrogative part of SQL and distinguishes from previously designed SQL extensions by: the preservation of SQL concepts; the high-level treatment of spatial objects; and the incorporation of spatial operations and relationships. It consists of two components, a query language to describe what information to retrieve and a presentation language to specify how to display query results. Users can ask standard SQL queries to retrieve nonspatial data based on nonspatial constraints, use Spatial SQL commands to inquire about situations involving spatial data, and give instructions in the Graphical Presentation Language, GPL to manipulate or examine the graphical presentation.< <ETX xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">&gt;</ETX>

Cited by 377

Gamifying Structure Query Language (SQL): Learning through Competitive Query-Based Challenges

Darwin G. Raralio · International journal of research and scientific innovation · 2026

Structured Query Language (SQL) is a foundational skill in database management; however, many students struggle to master it due to its abstract structure and logical complexity. While gamification has been widely recognized as an effective strategy for increasing engagement and motivation, elimination-based competition often limits participation and reduces learning opportunities for students who are removed early from play. This study introduces a Point-Based SQL Survival Challenge designed to promote continuous participation while strengthening logical reasoning and query accuracy. Using a quasi-experimental design, undergraduate students were divided into control and experimental groups. The experimental group engaged in a team-based, turn-driven SQL challenge where correct queries earned points and incorrect queries resulted in penalties without eliminating participants. The system integrated roulette-based actions—SELECT, INSERT, DELETE, SAFE, and JOKER—to combine skill-based reasoning with strategic decision-making. Results indicate that students exposed to the gamified approach demonstrated significantly higher gains in SQL proficiency, engagement, and collaborative problem-solving skills compared to traditional instruction. The findings suggest that point-based competitive mechanics can balance motivation with inclusivity while reinforcing logical reasoning and practical competence. This study contributes to emerging research on gamified database education and provides insights into designing inclusive competitive learning environments.

Cited by 0Open access

Structured Query Language (SQL) based College Management System

S.Sharmila Devi, M.Krisshna Kumar, Kv. Naveen · 2022 7th International Conference on Communication and Electronics Systems (ICCES) · 2022

This work focuses on online approval of requests in universities and digitization like leave requests, out pass requests, on-duty approval, and university admission management system. The most difficult challenge that college students face is getting permissions and leaves granted. For all sorts of approval, many colleges still employ manual and archaic methods. Maintaining attendance and reports for students is also a difficult process and a lot of manpower is required. To make it easier and simpler, an app is created and published among universities to make all the processes digital and online. The main objective of this work is to develop an application that solves the difficulties of the traditional method. The application is developed from a hyper-automation development platform designed for all business sizes. Structured Query Language (SQL) is used for creating tables and managing data in the database. This application will be useful for teachers and students to become automated in permissions, leaves requests, and related reports and records.

Cited by 2