Results 91 to 100 of about 327,421 (217)

Optimizing Database Performance in Complex Event Processing through Indexing Strategies

open access: yesData
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]

open access: yesInformatică economică, 2006
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  

Database query optimization

open access: yesВІСНИК СХІДНОУКРАЇНСЬКОГО НАЦІОНАЛЬНОГО УНІВЕРСИТЕТУ імені Володимира Даля, 2019
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

Learning From User-Specified Optimizer Hints in Database Systems

open access: yesFoundations of Computing and Decision Sciences
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]

open access: yesarXiv
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]

open access: bronze, 2000
Jens Albrecht   +3 more
openalex   +1 more source

Edge-assisted indexing for highly dynamic and static data in mixed reality connected autonomous vehicles

open access: yesIntelligent and Converged Networks
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]

open access: yesarXiv
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]

open access: yesarXiv
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  

Home - About - Disclaimer - Privacy