Exploiting Correlation to Rank Database Query Results

Author(s):  
Jaehui Park ◽  
Sang-goo Lee
Keyword(s):  
2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling

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.


2016 ◽  
Author(s):  
Vanessa Avelino Xavier de Camargo ◽  
Marcos Wagner de Souza Ribeiro

2021 ◽  
Vol 50 (1) ◽  
pp. 59-59
Author(s):  
Marcin Zukowski

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


Author(s):  
Mehdi Moghaddamfar ◽  
Christian Färber ◽  
Wolfgang Lehner ◽  
Norman May ◽  
Akash Kumar

Author(s):  
Xiangfu Meng ◽  
Xiaoyan Zhang ◽  
Jinguang Sun ◽  
Lin Li ◽  
Changzheng Xing ◽  
...  

2012 ◽  
Vol 433-440 ◽  
pp. 3335-3339
Author(s):  
Bo Zhu Wu

Through the in-depth study of the existing distributed database query processing technology, this paper proposes a distributed database query processing program. This program optimizes the existing query processing, stores the commonly used query results according to the query frequency, to be directly used by the subsequent queries or used as intermediate query results, thus avoiding possible transmission of a large number of data, thereby reducing the query time and improving query efficiency.


CCIT Journal ◽  
2016 ◽  
Vol 9 (3) ◽  
pp. 251-257
Author(s):  
Untung Rahardja ◽  
Deddy Pratama ◽  
Ely Susanti

Information Technology (IT) has been able to made improve the effectiveness, efficiency, competitiveness, and support the managerial activities of the organization. Here are discussed about the implementation of Viewboard application for an educational institution as a module assistant of leadership in making strategic decisions. Viewboard applications developed based on existing databases on other systems as a data warehouse. In the implementation, the Viewboard applications built using the PHP programming language for the front-office interface with the concept of Artificial Informatics as a result of the processed grain database query. The Viewboard application has been tested for statistical measure of student overview on Higher Education Academic Raharja as a development and research Viewboard done. The final results show that the test can pull Viewboard processed data from an existing repository database and display the information is critical to the presentation of the characteristics of Artificial Informatics.


Sign in / Sign up

Export Citation Format

Share Document