Database query evaluation with the STARBASE method

1996 ◽  
pp. 321-342
Author(s):  
Estrella Pulido
Keyword(s):  
Query Evaluation ◽  
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

scholarly journals Query Rewriting for Incremental Continuous Query Evaluation in HIFUN

Algorithms ◽  
2021 ◽  
Vol 14 (5) ◽  
pp. 149
Author(s):  
Petros Zervoudakis ◽  
Haridimos Kondylakis ◽  
Nicolas Spyratos ◽  
Dimitris Plexousakis
Keyword(s):  
Query Optimization ◽  
Query Language ◽  
Computational Cost ◽  
Continuous Queries ◽  
Continuous Query ◽  
Query Rewriting ◽  
Query Evaluation ◽  
Clear Separation ◽  
Complete Dataset ◽  
High Level

HIFUN is a high-level query language for expressing analytic queries of big datasets, offering a clear separation between the conceptual layer, where analytic queries are defined independently of the nature and location of data, and the physical layer, where queries are evaluated. In this paper, we present a methodology based on the HIFUN language, and the corresponding algorithms for the incremental evaluation of continuous queries. In essence, our approach is able to process the most recent data batch by exploiting already computed information, without requiring the evaluation of the query over the complete dataset. We present the generic algorithm which we translated to both SQL and MapReduce using SPARK; it implements various query rewriting methods. We demonstrate the effectiveness of our approach in temrs of query answering efficiency. Finally, we show that by exploiting the formal query rewriting methods of HIFUN, we can further reduce the computational cost, adding another layer of query optimization to our implementation.

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

GoFast: Graph-based optimization for efficient and scalable query evaluation

2021 ◽  
Vol 99 ◽  
pp. 101738
Author(s):  
Ishaq Zouaghi ◽  
Amin Mesmoudi ◽  
Jorge Galicia ◽  
Ladjel Bellatreche ◽  
Taoufik Aguili
Keyword(s):  
Query Evaluation

Resource-Efficient Database Query Processing on FPGAs

2021 ◽  
Author(s):  
Mehdi Moghaddamfar ◽  
Christian Färber ◽  
Wolfgang Lehner ◽  
Norman May ◽  
Akash Kumar
Keyword(s):  
Query Processing ◽  
Database Query ◽  
Database Query Processing
Sign in / Sign up

Export Citation Format

Share Document