Results 91 to 100 of about 327,421 (217)
Optimizing Database Performance in Complex Event Processing through Indexing Strategies
Complex event processing (CEP) systems have gained significant importance in various domains, such as finance, logistics, and security, where the real-time analysis of event streams is crucial. However, as the volume and complexity of event data continue
Maryam Abbasi+4 more
doaj +1 more source
Optimizing queries in distributed systems [PDF]
This research presents the main elements of query optimizations in distributed systems. First, data architecture according with system level architecture in a distributed environment is presented.
Ion LUNGU, Anca Georgiana FODOR
doaj
This article reviewed the methods directed at optimizing the database. The goal was to find the most suitable method for the quick execution of queries.
openaire +2 more sources
Optimizing object queries using an effective calculus [PDF]
Leonidas Fegaras, David Maier
openalex +1 more source
Learning From User-Specified Optimizer Hints in Database Systems
Recently, numerous machine learning (ML) techniques have been applied to address database performance management problems, including cardinality estimation, cost modeling, optimal join order prediction, hint generation, etc.
Zakrzewicz Maciej
doaj +1 more source
Learned Offline Query Planning via Bayesian Optimization [PDF]
Analytics database workloads often contain queries that are executed repeatedly. Existing optimization techniques generally prioritize keeping optimization cost low, normally well below the time it takes to execute a single instance of a query. If a given query is going to be executed thousands of times, could it be worth investing significantly more ...
arxiv
Query optimization by using derivability in a data warehouse environment [PDF]
Jens Albrecht+3 more
openalex +1 more source
The integration of Mixed Reality (MR) technology into Autonomous Vehicles (AVs) has ushered in a new era for the automotive industry, offering heightened safety, convenience, and passenger comfort. However, the substantial and varied data generated by MR-
Daniel Mawunyo Doe+5 more
doaj +1 more source
The Unreasonable Effectiveness of LLMs for Query Optimization [PDF]
Recent work in database query optimization has used complex machine learning strategies, such as customized reinforcement learning schemes. Surprisingly, we show that LLM embeddings of query text contain useful semantic information for query optimization.
arxiv
Can Large Language Models Be Query Optimizer for Relational Databases? [PDF]
Query optimization, which finds the optimized execution plan for a given query, is a complex planning and decision-making problem within the exponentially growing plan space in database management systems (DBMS). Traditional optimizers heavily rely on a certain cost model constructed by various heuristics and empirical tuning, probably leading to ...
arxiv