Managing Data Using Structured Query Language

2021 ◽  
pp. 119-148
Author(s):  
Jagdish Chandra Patni ◽  
Hitesh Kumar Sharma ◽  
Ravi Tomar ◽  
Avita Katal
Keyword(s):  
Query Language ◽  
Structured Query Language

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 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).

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.

scholarly journals Performance Benchmarking of Key-Value Store NoSQL Databases

2018 ◽  
Vol 8 (6) ◽  
pp. 5333
Author(s):  
Omoruyi Osemwegie ◽  
Kennedy Okokpujie ◽  
Nsikan Nkordeh ◽  
Charles Ndujiuba ◽  
Samuel John ◽  
...  
Keyword(s):  
Data Storage ◽  
Web Applications ◽  
Query Language ◽  
Research Work ◽  
Database Systems ◽  
Nosql Databases ◽  
Performance Benchmarking ◽  
Nosql Database ◽  
Structured Query Language ◽  
Web Developers

<p>Increasing requirements for scalability and elasticity of data storage for web applications has made Not Structured Query Language NoSQL databases more invaluable to web developers. One of such NoSQL Database solutions is Redis. A budding alternative to Redis database is the SSDB database, which is also a key-value store but is disk-based. The aim of this research work is to benchmark both databases (Redis and SSDB) using the Yahoo Cloud Serving Benchmark (YCSB). YCSB is a platform that has been used to compare and benchmark similar NoSQL database systems. Both databases were given variable workloads to identify the throughput of all given operations. The results obtained shows that SSDB gives a better throughput for majority of operations to Redis’s performance.</p>

Structured Query Language (SQL)

DB2/2 kompakt ◽  
1994 ◽  
pp. 97-137
Author(s):  
Heinz Axel Pürner ◽  
Beate Pürner
Keyword(s):  
Query Language ◽  
Structured Query Language
Sign in / Sign up

Export Citation Format

Share Document