TalkSQL: A Tool for the Synthesis of SQL Queries from Verbal Specifications

Obaido, George; Ade-Ibijola, Abejide; Vadapalli, Hima

doi:10.1109/imitec50163.2020.9334088

Cited by 7 publications

(6 citation statements)

References 30 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Database professionals are not the only ones requiring skills under the data category; these skills are needed in almost all IT fields. SQL, itself, is one of the sought-after languages required in the industry and academia [63]- [65]. Designers work with engineers to find a problem and brainstorm the features to solve the identified issues.…”

Section: Discussionmentioning

confidence: 99%

Hidden Gold for IT Professionals, Educators, and Students: Insights From Stack Overflow Survey

Dada

Obaido

Sanusi

et al. 2023

IEEE Trans. Comput. Soc. Syst.

Self Cite

View full text Add to dashboard Cite

It is undeniable that technological advancements have taken significant changes in the nature of work, resulting in the loss of many jobs and the emergence of new ones. As a result, information technology (IT) job seekers and professionals must be aware of changes required in their respective fields. This study identified and ranked the most-used technologies, such as programming languages, databases, operating systems (OSs), and collaborative tools, specific to twenty-three (23) different IT roles. Furthermore, this study advocates that individuals focus on critical skills required in various domains to achieve career success. Similarly, individuals with a set of valued technical skills may decide whether to change jobs or roles if they are interested in a position that requires their current competence. The findings of this study can be helpful to career counselors, instructors, students, professionals, recruiters, curriculum designers, and decision-makers.

show abstract

Section: Discussionmentioning

confidence: 99%

Hidden Gold for IT Professionals, Educators, and Students: Insights From Stack Overflow Survey

Dada

Obaido

Sanusi

et al. 2023

IEEE Trans. Comput. Soc. Syst.

Self Cite

View full text Add to dashboard Cite

show abstract

“…Scalability can be approached through horizontal or vertical scaling. Vertical scaling involves adding more resources, such as CPU and memory, to a single server to handle increased loads, but this approach has limitations and can quickly become cost-prohibitive (Obaido et al, 2020). Horizontal scaling, on the other hand, distributes the load across multiple servers, allowing the system to handle larger datasets more efficiently.…”

Section: Scalability Issuesmentioning

confidence: 99%

“…Horizontal scaling, on the other hand, distributes the load across multiple servers, allowing the system to handle larger datasets more efficiently. However, traditional SQL databases are inherently designed for vertical scaling and often struggle with horizontal scaling due to the complexity of maintaining data consistency and integrity across distributed systems (Obaido et al, 2020). This limitation restricts their ability to efficiently manage the vast volumes of data characteristic of big data workloads.…”

Section: Scalability Issuesmentioning

confidence: 99%

Optimizing SQL Databases Forbig Data Workloads: Techniques and Best Practices

Uzzaman,

Jim,

Nishat

et al. 2024

AJBAIS

View full text Add to dashboard Cite

In the era of big data, SQL databases face significant challenges in handling vast volumes of data efficiently. This article explores optimization techniques and best practices for enhancing the performance and scalability of SQL databases in handling big data workloads. The study addresses the significant challenges faced by traditional SQL databases, including scalability issues, performance bottlenecks, resource constraints, and data integration complexities. Through a comprehensive methodology involving literature review, case studies, expert interviews, and performance testing, the research identifies effective strategies such as indexing, partitioning, sharding, and caching. Findings from case studies in e-commerce and financial services sectors demonstrate substantial improvements in query performance and resource utilization, validating the practical benefits of these optimization techniques. The study underscores the importance of a multifaceted approach to database optimization, integrating both theoretical and practical insights to address the complexities of big data environments. By staying informed and adopting the latest optimization strategies, database administrators and IT professionals can ensure their SQL databases remain efficient, scalable, and capable of managing the increasing demands of large-scale data processing, ultimately enabling organizations to derive valuable insights from their data.

show abstract

“…Researchers have used various forms of text processing technique to automatically extract and analyse documents such as business documents [20], clinical notes [21], legal documents [2], [22] and so on. NLP techniques have been used to perform text information extraction [23], named entity recognition [24], language to SQL translator [25], [26], summarisation [27], classification and examination of other textual contents such as CVs [28], invoices [20] and social media texts [29]. These NLP techniques and others have been largely used around the text content of a document, and sometimes shorttext based documents.…”

Section: Gapmentioning

confidence: 99%

Structural Vetting of Academic Proposals

Iwashokun¹,

Ade-Ibijola²

2022

IJACSA

Self Cite

View full text Add to dashboard Cite

Increasing postgraduate enrollments gives rise to many proposal documents required for vetting and human supervision. Reading and comprehension of large documents is a boring and somewhat difficult task for humans which can be delegated to machines. One way of assisting supervisors with this routine screening of academic proposals is to provide an artificial intelligent (AI) tool for initial structural vetting -checking if sections of proposals are complete and appear where they are supposed to. Natural Language Processing (NLP) techniques in AI for document vetting has been applied in legal and financial domains. However, in academia, available tools only perform tasks such as checking proposals for plagiarism, spellings or grammar, word editing, and not structural vetting of academic proposal. This paper presents a tool named Autoproofreader that attempts to perform the task of structural document review of proposals on behalf of the human expert using formal techniques and document structure understanding hinged on context free grammar rules (CFGs). The experimental results on a corpus of 20 academic proposals using confusion matrix technique for evaluation gives an overall of 87% accuracy. This tool is expected to be a useful aid in postgraduate supervision for vetting students' academic proposals.

show abstract

TalkSQL: A Tool for the Synthesis of SQL Queries from Verbal Specifications

Cited by 7 publications

References 30 publications

Hidden Gold for IT Professionals, Educators, and Students: Insights From Stack Overflow Survey

Hidden Gold for IT Professionals, Educators, and Students: Insights From Stack Overflow Survey

Optimizing SQL Databases Forbig Data Workloads: Techniques and Best Practices

Structural Vetting of Academic Proposals

Contact Info

Product

Resources

About