Speeding up Spatial Database Query Execution using GPUs

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

Download Full-text

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

IEEE Transactions on Software Engineering ◽

10.1109/32.238579 ◽

1993 ◽

Vol 19 (8) ◽

pp. 749-764 ◽

Cited By ~ 19

Author(s):

G. Graefe ◽

D.L. Davison

Keyword(s):

Query Execution ◽

Database Query

Download Full-text

A query simulation system to illustrate database query execution

ACM SIGCSE Bulletin ◽

10.1145/1352322.1352301 ◽

2008 ◽

Vol 40 (1) ◽

pp. 493-497 ◽

Cited By ~ 1

Author(s):

Brett Allenstein ◽

Andrew Yost ◽

Paul Wagner ◽

Joline Morrison

Keyword(s):

Simulation System ◽

Query Execution ◽

Database Query

Download Full-text

What's Happening to Profits at Cazenovia Creations?

AIS Educator Journal ◽

10.3194/1935-8156-8.1.24 ◽

2013 ◽

Vol 8 (1) ◽

pp. 24-29 ◽

Cited By ~ 1

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.

Download Full-text