scholarly journals Novel Model for the Computation of Linguistic Hedges in Database Queries

2011 ◽  
Vol 6 (1) ◽  
Author(s):  
Bala Murugan Vanniappan
Keyword(s):  
Query Language ◽  
Query Languages ◽  
Application Layer ◽  
Data Repositories ◽  
Database Queries ◽  
Complex Queries ◽  
Fuzzy Query ◽  
Structured Query Language ◽  
Linguistic Hedges ◽  
Novel Model

Most query languages are designed to retrieve information from databases containing precise and certain data using precisely specified commands. Due to the advancements in various kinds of data repositories in the recent years, there is a steep increase in complex queries. Most of the complex Queries are uncertain and vague. The existing Structured Query Language exhibits its inefficiency in handling these complex Queries. This paper proposes a model to handle the complexities by using fuzzy set theory. In this model, the Fuzzy Query with linguistic hedges is converted into Crisp Query, by deploying an application layer over the Structured Query Language.

scholarly journals Design principles of the Metadata Querying Language (MQL) implemented in the ATLAS Metadata Interface (AMI) ecosystem

2020 ◽  
Vol 245 ◽  
pp. 04044
Author(s):  
Jérôme Fulachier ◽  
Jérôme Odier ◽  
Fabian Lambert
Keyword(s):  
Query Language ◽  
Design Principles ◽  
Domain Specific Language ◽  
Specific Language ◽  
Domain Specific ◽  
Complex Queries ◽  
Structured Query Language

This document describes the design principles of the Metadata Querying Language (MQL) implemented in ATLAS Metadata Interface (AMI), a metadata-oriented domain-specific language allowing to query databases without knowing the relation between tables. With this simplified yet generic grammar, MQL permits writing complex queries more simply than with Structured Query Language (SQL).

A Comparison of Natural and Structured Query Languages

1978 ◽  
Vol 22 (1) ◽  
pp. 705-707
Author(s):  
Duane W. Small ◽  
Linda J. Weldon
Keyword(s):  
Natural Language ◽  
Query Language ◽  
Data Retrieval ◽  
Query Languages ◽  
Problem Structure ◽  
Computer Terminal ◽  
Structured Query Language ◽  
Data Search ◽  
Speed Advantage ◽  
The Ideal

It is often assumed that natural language would be the ideal user-oriented language for communicating with computers. However, languages structured to fit particular tasks may be easier to use. Twenty subjects solved a set of data retrieval problems on a computer terminal using English, and solved another set using SEQUEL, a structured query language. No differences in accuracy were observed. Problems were solved more quickly using SEQUEL, although only by those subjects whose English session preceded their SEQUEL session. The speed advantage of SEQUEL appeared primarily for problems concerned with structuring the data search, rather than for problems involving logical complexities in what was to be sought. The fact that the structured language provided advantages for those aspects of the task that were reflected in the language's syntax indicates that the conceptual aspects of language and problem structure, and not such general matters as length of commands, are responsible for the advantages of structured language.

scholarly journals An adaptive spark-based framework for querying large-scale NoSQL and relational databases

PLoS ONE ◽  
2021 ◽  
Vol 16 (8) ◽  
pp. e0255562
Author(s):  
Eman Khashan ◽  
Ali Eldesouky ◽  
Sally Elghamrawy
Keyword(s):  
Big Data ◽  
Data Storage ◽  
Relational Databases ◽  
Large Scale ◽  
Query Languages ◽  
Heterogeneous Data ◽  
Query Execution ◽  
Database Queries ◽  
Nosql Databases ◽  
Complex Queries

The growing popularity of big data analysis and cloud computing has created new big data management standards. Sometimes, programmers may interact with a number of heterogeneous data stores depending on the information they are responsible for: SQL and NoSQL data stores. Interacting with heterogeneous data models via numerous APIs and query languages imposes challenging tasks on multi-data processing developers. Indeed, complex queries concerning homogenous data structures cannot currently be performed in a declarative manner when found in single data storage applications and therefore require additional development efforts. Many models were presented in order to address complex queries Via multistore applications. Some of these models implemented a complex unified and fast model, while others’ efficiency is not good enough to solve this type of complex database queries. This paper provides an automated, fast and easy unified architecture to solve simple and complex SQL and NoSQL queries over heterogeneous data stores (CQNS). This proposed framework can be used in cloud environments or for any big data application to automatically help developers to manage basic and complicated database queries. CQNS consists of three layers: matching selector layer, processing layer, and query execution layer. The matching selector layer is the heart of this architecture in which five of the user queries are examined if they are matched with another five queries stored in a single engine stored in the architecture library. This is achieved through a proposed algorithm that directs the query to the right SQL or NoSQL database engine. Furthermore, CQNS deal with many NoSQL Databases like MongoDB, Cassandra, Riak, CouchDB, and NOE4J databases. This paper presents a spark framework that can handle both SQL and NoSQL Databases. Four scenarios’ benchmarks datasets are used to evaluate the proposed CQNS for querying different NoSQL Databases in terms of optimization process performance and query execution time. The results show that, the CQNS achieves best latency and throughput in less time among the compared systems.

Simulation of emotional differences in the structured query language for databases of financial markets

2021 ◽  
Vol 14 (2) ◽  
pp. 156-173
Author(s):  
Semen Yu. BOGATYREV
Keyword(s):  
Information Systems ◽  
Financial Market ◽  
Behavioral Finance ◽  
Query Language ◽  
Learning Technologies ◽  
Financial Decisions ◽  
Self Confidence ◽  
Structured Query Language ◽  
The Face ◽  
Modern Information

Subject. The article addresses a simulation in the structured query language (SQL) for the Bloomberg information base, the scientifically grounded tools for measuring emotions in markets in the face of financial and pandemic crisis and market imbalances, in addition to classic financial indicators, the creation of analytical tools based on state-of-the-art software tools that integrate the latest advances in behavioral finance and in financial and coefficient analysis, machine learning technologies, and open financial market data. Objectives. The aim is to create a usable toolkit for balanced evaluation of financial and economic situation of companies, based on the analysis of the main Russian and foreign modern means to measure emotions. Methods. The study employs methods of induction, deduction, and modeling. It demonstrates the link between methods and methodologies with new technical means of modern information systems. Results. The paper studies the effect of the heuristics of insufficient reaction and heuristics of excessive self-confidence, using the examples of market drawdown. I developed and implemented a model, using the behavioral finance tools as a factor in stabilizing financial decisions. Conclusions. New software and hardware tools enabled to identify and measure the actions of the heuristics of financial market participants. Financial analysts, when applying the new capabilities of modern information systems for programming and creating user models with required parameters and extensive database, will have new opportunities in the described models. The procedure for collecting and processing the original information required for valuation is simplified.

Structured Query Language

2002 ◽  
pp. 1-5 ◽  
Author(s):  
Susan Sales Harkins ◽  
Martin W. P. Reid
Keyword(s):  
Query Language ◽  
Structured Query Language

scholarly journals Sistem Informasi Pendataan Siswa/Siswi di RA Sami’na Waathanaa Berbasis Web

KREA-TIF ◽  
2017 ◽  
Vol 5 (2) ◽  
pp. 58
Author(s):  
Dahlia Widhyaestoeti ◽  
Guntara Guntara
Keyword(s):  
Data Collection ◽  
Query Language ◽  
Problem Analysis ◽  
Collection System ◽  
Web Based ◽  
Data Collection System ◽  
Student Data ◽  
Structured Query Language ◽  
Student Data Collection ◽  
Microsoft Office

<h1 align="center">Abstrak</h1><p>Sistem informasi pendataan siswa Di RA Sami’na Waathanaa, proses pendataan siswa/siswi baik ketika siswa/siswi yang baru masuk, atau yang sudah lulus di data oleh operator sekolah tersebut masih menggunakan Microsoft Office. Hal tersebut menghambat pekerjaan operator serta data-data siswa mudah hilang atau rusak. Pengembangan sistem berupa sistem informasi pendataan siswa berbasis web, sehingga membantu kecepatan dan kualitas dalam penyampaian informasi. Tujuan dari penelitian ini adalah untuk menyediakan Sistem Pendataan Siswa terkomputerisasi dalam database. Metode pengembangan sistem informasi yang digunakan model waterfall, dari mulai analisis masalah, perancangan, hingga implementasi. Menu pada sistem pendataan siswa ini dapat diakses oleh user tertentu yaitu siswa, guru dan admin. Sistem informasi pendataan siswa ini berbasis web dengan pemanfaatan bahasa pemprogram Personal Hypertext Prepocessor (PHP) dan Structured Query Language (SQL). Pengunaan sistem informasi pendataan siswa ini dapat menghemat waktu dan menghasilkan informasi yang dibutuhkan.</p><h1 align="center"><em>Abstract</em></h1><p><em>Student data collection system At RA Sami’na Waathanaa, the student data collection process is good when students who have just entered, or who have graduated in data by the school operator are still using Microsoft Office. This hinders the work of operators and student data is easily lost or damaged. The development of the system in the form of a web-based student data collection system, so that it helps speed and quality in delivering information. The purpose of this study is to provide a computerized Student Data Collection System in a database. The information system development method used is the waterfall model, from problem analysis, design, to implementation. Menus in the student data collection system can be accessed by certain users, namely students, teachers and admins. This student data collection system is web based with the use of Personal Hypertext Prepocessor (PHP) and Structured Query Language (SQL) programming languages. Using this student data collection system can save time and produce the information needed.</em></p><p align="left"> </p>

scholarly journals Uso de linkage entre diferentes bases de dados para qualificação de variáveis do Sinan-TB e a partir de regras de scripting

2019 ◽  
Vol 35 (12) ◽  
Author(s):  
Marli Souza Rocha ◽  
Gisele Pinto de Oliveira ◽  
Luis Carlos Torres Guillen ◽  
Claudia Medina Coeli ◽  
Valéria Saraceni ◽  
...  
Keyword(s):  
Rio De Janeiro ◽  
Query Language ◽  
Structured Query Language

Resumo: O Sistema de Informação de Agravos de Notificação (Sinan) é a principal ferramenta utilizada pelos programas de controle da tuberculose (TB), para avaliar as ações de controle e a taxa de incidência da doença. Para tal, faz-se necessário que os dados provenientes desse sistema sejam, dentre outros, confiáveis e acurados. Dessa forma, o objetivo deste estudo foi qualificar as variáveis tipo de entrada, situação de encerramento, teste para HIV, agravo associado aids e diabetes. Foi realizado um linkage entre a base de dados do Sinan-TB, do Sistema de Informações sobre Mortalidade (SIM) e a base única da aids do Município do Rio de Janeiro, Brasil. Os critérios para qualificação das variáveis estão fundamentados em materiais técnicos sobre a TB e sobre o Sinan, e foram implementados em um script em Structured Query Language (SQL). Observou-se um aumento de 115% do abandono de tratamento decorrente da diminuição das transferências, dos registros sem encerramento e de pacientes encerrados por cura com menos de 150 dias. Houve acréscimo de 2,4% de registros com agravo associado diabetes na categoria sim, após utilizada a informação contida no SIM. Para as variáveis teste para HIV e agravo associado à aids o acréscimo foi de 5,3% e 8,7%, respectivamente, com a consideração da informação contida na base da aids. Concluiu-se que a qualificação da base de dados do Sinan-TB, valendo-se da integração com outros sistemas de informação, aprimorou a qualidade da informação para a tomada de decisão para o controle da TB.

scholarly journals Implementasi Sistem Keamanan SQL Injection Dalam berbasis web

2020 ◽  
Vol 4 (1) ◽  
pp. 8-13
Author(s):  
Zulkifli ◽  
Samsir
Keyword(s):  
Query Language ◽  
Sql Injection ◽  
Structured Query Language ◽  
Sql Query

Kemanan website akses jaringan internet  merupakan hal yang perlu diperhatikan sangat serius. Serangan yang diakibatkan oleh sql injection mampu membobol sistem pertahanan website yang kita miliki jika tidak dilengkapai dengan pengamanan yang kuat.  Mengingat website ini dapat diakses secara luas, maka dinilai perlu memperhatikan keamanan website. Terdapat beberapa cara yang dapat digunakan untuk melakukan pengujian terhadap kemanan website, salah satunya adalah dengan melakukan SQL Injection. SQL injection adalah kerentanan yang terjadi ketika penyerang memiliki kemampuan untuk mempengaruhi Structured Query Language (SQL) query yang melewati suatu aplikasi ke database back-end. Dengan diadakannya penelitian ini, diharapkan dapat diperoleh kelemahan dari website. Kelemahan tersebut akan dianalisa sehingga memperoleh solusi kedepan guna pengembangan website yang lebih aman.

Sign in / Sign up

Export Citation Format

Share Document