scholarly journals Query Processing for Time Efficient Data Retrieval

2018 ◽  
Vol 9 (3) ◽  
pp. 784
Author(s):  
Muhammad Qasim Memon ◽  
Jingsha He ◽  
Aasma Memon ◽  
Khurram Gulzar Rana ◽  
Muhammad Salman Pathan
Keyword(s):  
Query Language ◽  
Data Retrieval ◽  
Structure Query Language ◽  
Database Management System ◽  
Execution Plan ◽  
Database Constraints ◽  
Efficient Data ◽  
Real Time Database ◽  
Structure Query ◽  
Language Environment

<p class="TTPAbstract">In database management system (DBMS) retrieving data through structure query language is an essential aspect to find better execution plan for performance. In this paper, we incorporated database objects to optimize query execution time and its cost by vanishing poorly SQL statements. We proposed a method of evolving and inserting database constraints as database objects embedded with queries either to add them for the sake of transactions required by user to detect those queries for the betterment of performance. We took analysis on several databases while processing queries itself and assimilate real time database workload with the bunch of transactions are invoked in comparison with tuning approaches. These database objects are coded in procedural language environment pertaining rules to make it worth and are merged into queries offering improved execution plan.</p>

scholarly journals ANALYSIS OF QUERY RESTRUCTURIZATION MODELS IN OPTIMIZING DATA EXECUTION RESPONSE TIME ON MYSQL PHP 7.2.27 RELATIONAL DATABASES

2021 ◽  
Vol 9 (1) ◽  
pp. 1-10
Author(s):  
Olivia Maria Inacio Tavares ◽  
Sartje Mala Rangkoly ◽  
Sarah Bunda Desi Bawan ◽  
Khifni Beyk Ahmad ◽  
Ema Utami ◽  
...  
Keyword(s):  
Response Time ◽  
Data Management ◽  
Relational Databases ◽  
Query Language ◽  
Response Times ◽  
Information Service ◽  
Structure Query Language ◽  
Database Management System ◽  
Test Analysis ◽  
Structure Query

Database is a collection of data that forming an information that useful for managers in an organization to facilitate data management process to become more effective and safely guarantee. A good database has fast and accurate response time performance in data execution processing. To manage the database, it requires a special language or query known as Structure Query Language (SQL). Increase need for fast information, will need a proper SQL as well. Therefore, through this research, a test analysis will be used to optimize the query response time in database management system commonly used today, namely the My Structured Query Language (MySQL) using PHP version of 7.2.27 relational database which will be tested on the Oebufu Village Aspiration and Information Service System (SELMA) that acessed from localhost panels with a total of 1000 test data records. The test is devoted to the effectiveness of using SELECT queries in calling and displaying data through restructuring the use of clauses. This study aims to help improve data management by providing the results of the comparative analysis of response times between the general query model and the optimized query results in order to determine the correct and efficient query structure. The result is proven by doing query optimization, it is found that the presentation of time optimization is significant, which is 78% much faster than the initial query, through this test it can be concluded that optimization plays an important role in streamlining the response time of database queries.  

scholarly journals Generating SQL Command Syntax Using MySQL Based on Typing Command Sentence

Jurnal INFORM ◽  
2021 ◽  
Vol 6 (1) ◽  
pp. 1-7
Author(s):  
Bonifacius Vicky Indriyono ◽  
Zudha Pratama
Keyword(s):  
Query Language ◽  
Group Analysis ◽  
Research Problem ◽  
Structure Query Language ◽  
Database Management System ◽  
Main Process ◽  
Data Manipulation ◽  
Translation Stage ◽  
Structure Query ◽  
Two Stages

Information retrieval system is a system that is widely used to retrieve information. This research will discuss how the system finds back the information stored in database tables. Tables in the database are arranged to store all forms of data entered by database users so that later the stored data can be used again. Re-accessing the database's information must go through a mechanism known as a database management system (DBMS). One of the most widely used DBMS is MySQL. By using a DBMS, information and data can be manipulated according to user needs. Data manipulation in the database is done in a special language, namely SQL (Structure Query Language). Mastery of SQL commands is an obligation for database users so that the manipulated data can produce the required information. However, many database users still do not understand how the actual SQL command syntax manages and manipulates data into information. This is, of course, very risky if the solution is not immediately sought because it will hinder the process of retrieving information from the data stored in the database. For this problem to be resolved, it is necessary to design a system that can help database users translate their wishes into SQL command syntax. This paper will discuss how a command in Indonesian can be translated into SQL command syntax. The method used to solve this research problem is rule-based. There are two stages in the main process: the pre-processing stage, which consists of a word tokenization process, and a translation stage, including a keyword grouping process. This keyword grouping process consists of the keyword group analysis phase, table and column analysis, identification of SQL commands, and mapping of SQL commands. From all stages that have been passed and testing of 7 scenarios with ten (10) commands for each scenario, the accuracy is 81.42%. The inaccuracy in the testing process is more a problem of displaying data from two or more tables, for example, using the join table command. This problem can be addressed by adding new rules for the use of table joins.

Distributed Geographic Structure Query Language-DGSQL

2015 ◽  
Vol 9 (2) ◽  
pp. 328-336 ◽  
Author(s):  
Liang Wu ◽  
Zhanlong Chen ◽  
Xincai Wu ◽  
Zhong Xie
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Geographic Structure ◽  
Structure Query

Detection of structure query language injection vulnerability in web driven database application

2020 ◽  
Author(s):  
Muhammad Saidu Aliero ◽  
Kashif Naseer Qureshi ◽  
Muhammad Fermi Pasha ◽  
Awais Ahmad ◽  
Gwanggil Jeon
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Database Application ◽  
Structure Query

scholarly journals PERANCANGAN APLIKASI POINT OF SALE BERBASIS WEB PADA TOKO PROJECT SALFA TARAKAN

Sebatik ◽  
2021 ◽  
Vol 25 (2) ◽  
pp. 624-631
Author(s):  
Suprianto Suprianto ◽  
Muhammad Fadlan ◽  
Denis Prayogi
Keyword(s):  
Query Language ◽  
Structure Query Language ◽  
Point Of Sale ◽  
Structure Query

Aplikasi Point of Sale yang biasa disebut POS merupakan aplikasi yang dapat membantu proses transaksi penjualan seperti pada toko yang umumnya terjadi kegiatan jual beli. Toko Project Salfa yang bergerak di bidang penjualan dan penyedia jasa saat ini masih menggunakan pencatatan manual di setiap transaksi sehingga menyulitkan pemilik ketika akan melakukan rekapitulasi terkait laporan penjualan maupun pemasukan. Penelitian ini membuat aplikasi POS berdasarkan kebutuhan dari pemilik toko dengan menggunakan model Waterfall sebagai perancangan dan pengembangan aplikasinya. Dari penerapan model Waterfall, dapat dihasilkan aplikasi yang memiliki fitur-fitur yang sesuai dengan kebutuhan pemilik toko seperti dapat melakukan pendataan barang, member, seller, transaksi penjualan, pengeluaran serta laporan-laporan dari transaksi tersebut yang dicatat dalam bentuk kas di aplikasi POS. aplikasi dibuat berbasis web agar memudahkan pengembangan ke depannya dengan menggunakan bahasa pemrograman PHP (Hypertext Pre-processor) dan database berbasis jaringan seperti MySQL (My Structure Query Language).

Book Subscription System Design in High School Based on Web Technology

2012 ◽  
Vol 220-223 ◽  
pp. 2641-2644
Author(s):  
Shu Lan Gao
Keyword(s):  
High School ◽  
High Education ◽  
System Design ◽  
Query Language ◽  
Database System ◽  
Structure Query Language ◽  
School Based ◽  
Information Center ◽  
Structure Query ◽  
Education In China

Library is the information center of high school. With the development of high education in China, the construction of library is of great importance in high school. Since the knowledge of all kinds of subjects increase dramatically in nowadays, the book subscription has become a heavy task in the library. The recent manual works for book subscription in many schools have not met the requirements from different departments of them. Hence, a book subscription system is designed based on Web. In this system, the active sever page technology is used, together with the structure query language sever database system.

Sign in / Sign up

Export Citation Format

Share Document