Rough relational database and query optimization techniques.
نویسندگان
چکیده
منابع مشابه
Testing relational database query optimization strategies
Query optimization is one of the most important problems in databases. Query optimization can be talked about in different scenarios with different tools and different results. In this paper we’ll talk about query processing and optimization and test strategies in different context, starting from simple queries continuing with correlated queries, joins with or without different indexing strateg...
متن کاملNested Query Optimization in Relational Database
Many database applications perform complex data retrieval and update tasks. Nested queries, and queries that invoke user-defined functions, which are written using a mix of procedural and SQL constructs, are often used in such applications. A straight-forward evaluation of such queries involves repeated execution of parameterized sub-queries or blocks containing queries. This work discusses imp...
متن کاملExploring Query Optimization Techniques in Relational Databases
In the modern era, digital data is considered as the more valuable asset of an organization, and the organizations assign more significance to it than the software and hardware assets. Database systems are computer-based record keeping systems, which have been developed to store data for efficient retrieval and processing. One particular approach is the relational databases in which all the inf...
متن کاملRelational Databases Query Optimization using Hybrid Evolutionary Algorithm
Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...
متن کاملThe Efficiency of Histogram-like Techniques for Database Query Optimization
One of the most difficult tasks in modern day database management systems is information retrieval. Basically, this task involves a user query, written in a high-level language such as the Structured Query Language, and some internal operations, which are transparent to the user. The internal operations are carried out through very complex modules that decompose, optimize and execute the differ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Computer Science and Cybernetics
سال: 2012
ISSN: 1813-9663,1813-9663
DOI: 10.15625/1813-9663/19/4/1543