Encapsulation of parallelism and architecture-independence in extensible database query execution

1993 ◽  
Vol 19 (8) ◽  
pp. 749-764 ◽  
Author(s):  
G. Graefe ◽  
D.L. Davison
Keyword(s):  
Query Execution ◽  
Database Query

scholarly journals Optimasi Query untuk Sistem Informasi Penjadwalan Mata Pelajaran Sekolah Menggunakan View (Studi Kasus : SMK VIP Purworejo)

Respati ◽  
2018 ◽  
Vol 13 (2) ◽  
Author(s):  
Pipit Kurnia Safitri ◽  
Wing Wahyu Winarno ◽  
Eko Pramono
Keyword(s):  
Response Time ◽  
Education Technology ◽  
Query Execution ◽  
Database Query ◽  
Web Based ◽  
Central Java ◽  
The Hours ◽  
Speed Performance ◽  
Long Time ◽  
Speed Up

INTISARI Perkembangan teknologi pendidikan di Jawa Tengah kususnya di daerah purworejo berkembang dengan pesat. SMK VIP Purworejo saat ini menggunakan sistem informasi penjadwalan berbasis web. Jumlah mata pelajaran yang banyak dan sering berubah sewaktu-waktu sering menimbulkan masalah. Banyaknya jumlah mata pelajaran dan guru yang mengajar maka akan semakin membutuhkan waktu yang lama untuk mengetahui mata pelajaran yang diampu oleh guru tersebut dan untuk mengetahui jam mengajar. View merupakan virtual table dimana isinya (kolom dan baris) didefinisikan dari satu query yang dapat melibatkan beberapa tabel sekaligus. Tujuan dari pembuatan view adalah untuk kenyamanan (mempermudah penulisan query), untuk keamanan (menyembunyikan beberapa kolom yang bersifat rahasia), atau bisa digunakan untuk mempercepat proses menampilkan data (terutama jika kita akan menjalankan query tersebut secara berulang). Eksekusi query basisdata membutuhkan response time. Apabila query yang dieksekusi membutuhkan response time yang lama, maka performansi basisdata berkurang. Salah satu cara untuk meningkatkan performansi basisdata adalah dengan menerapkan view.Tujuan dari penelitian ini adalah untuk mengetahui efisiensi sintak dan performa kecepatan dengan menggunakan query join dan view.Kata Kunci— Database, Optimasi query, view ABSTRACT The development of education technology in Central Java kususnya in the region purworejo growing rapidly. SMK VIP Purworejo currently uses web-based scheduling information system. The number of subjects that are overwhelming and often changing at times often creates problems. The large number of subjects and teachers who teach it will take a long time to find out the subjects being taught by the teacher and to know the hours of teaching. View is a virtual table where the contents (columns and rows) are defined from a single query that can involve multiple tables at once. The purpose of view creation is for convenience (ease of writing queries), for security (hiding some secret columns), or can be used to speed up the process of displaying data (especially if we will run the query repeatedly). Database query execution requires response time. If the query that is executed requires a long response time, then the performance of the database is reduced. One way to improve database performance is by applying view. The purpose of this research is to know the efficiency of syntax and speed performance by using join and view query.Keywords- Database, query optimization, view

scholarly journals Speeding up Spatial Database Query Execution using GPUs

2012 ◽  
Vol 9 ◽  
pp. 1870-1879 ◽  
Author(s):  
Bogdan Simion ◽  
Suprio Ray ◽  
Angela Demke Brown
Keyword(s):  
Spatial Database ◽  
Query Execution ◽  
Database Query

A query simulation system to illustrate database query execution

2008 ◽  
Vol 40 (1) ◽  
pp. 493-497 ◽  
Author(s):  
Brett Allenstein ◽  
Andrew Yost ◽  
Paul Wagner ◽  
Joline Morrison
Keyword(s):  
Simulation System ◽  
Query Execution ◽  
Database Query

What's Happening to Profits at Cazenovia Creations?

2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling
Keyword(s):  
Financial Analysis ◽  
Financial Statements ◽  
Internal Controls ◽  
Net Income ◽  
Database Query ◽  
Microsoft Access ◽  
Level Data ◽  
Query Tool ◽  
Transaction Level

ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong as expected. The students must first analyze a set of financial statements to identify areas of possible concern. After determining the areas to investigate, the students use a database query tool to see if they can determine causes by examining transaction level data. Finally, the students are asked to professionally communicate their findings and recommendations to their client. The case provides students with experience in using query-based approaches to answering business questions. It is appropriate for students with basic query and financial analysis skills and knowledge of internal controls. A Microsoft Access database with transaction details for the final seven months of the current year as well as financial statements for the current and prior year are provided.

Visualization of Database Query Improved by Fuzzy Logic Using Virtual Reality

2016 ◽  
Author(s):  
Vanessa Avelino Xavier de Camargo ◽  
Marcos Wagner de Souza Ribeiro
Keyword(s):  
Virtual Reality ◽  
Fuzzy Logic ◽  
Database Query

Technical Perspective

2021 ◽  
Vol 50 (1) ◽  
pp. 59-59
Author(s):  
Marcin Zukowski
Keyword(s):  
Query Processing ◽  
Hash Tables ◽  
Database Query ◽  
Query Performance ◽  
Research Opportunities ◽  
Database Query Processing

Hash tables are possibly the single most researched element of the database query processing layers. There are many good reasons for that. They are critical for some key operations like joins and aggregation, and as such are one of the largest contributors to the overall query performance. Their efficiency is heavily impacted by variations of workloads, hardware and implementation, leading to many research opportunities. At the same time, they are sufficiently small and local in scope, allowing a starting researcher, or even a student, to understand them and contribute novel ideas. And benchmark them. . . Oh, the benchmarks. . . :)

Sign in / Sign up

Export Citation Format

Share Document