Efficient Processing and Optimization of Queries with Set Predicates using Filtered Bitmap Index

2017 ◽  
Vol 5 (11) ◽  
pp. 33-39
Author(s):  
A.Regita Thangam ◽  
◽  
◽  
S.John Peter
Keyword(s):  
Bitmap Index ◽  
Efficient Processing

scholarly journals Efficient Processing of Queries using Filtered Bitmap Index with Multi-Join Multiple Set Predicates

2019 ◽  
Vol 8 (10S) ◽  
pp. 363-370
Keyword(s):  
Time Complexity ◽  
Bitmap Index ◽  
Data Set ◽  
Complex Query ◽  
Query Process ◽  
Processing Approach ◽  
Huge Data ◽  
Benchmark Datasets ◽  
Efficient Processing ◽  
The Given

Efficient query process is an essential task in numerous environments that relate large sum of information. The performance degradation occurs when the sum of information is increased. It will further degrade when the amount of joins in the queries is increased. These problems emphasize a need for good query processing approach. Thus, in this report, we take a various method to optimize the multi-join query with multiple set predicates in Data warehousing environment. So we have proposed an effective algorithm as Filtered Bitmap Index with multi-join multiple set predicates processing approach and examine the time complexity on huge data set with multiple tables. In this approach, the multi-join query is processed by selecting the tabular array based on their level number from lower to higher. A simple rewritten query was created from the given complex query exploitation uses the lowest level table and executed. If the result exists then only continue the join processing in the rewritten query, by taking the next lower level table from the complex query and do the execution. The ratio of our technique is to demonstrated with moving experiment using WorldCup98 and TPC-H benchmark datasets

Regional Bitmap Index: A Secondary Index for Data Management in Could Computing Environment

2012 ◽  
Vol 35 (11) ◽  
pp. 2306 ◽  
Author(s):  
Bi-Ping MENG ◽  
Teng-Jiao WANG ◽  
Hong-Yan LI ◽  
Dong-Qing YANG
Keyword(s):  
Data Management ◽  
Computing Environment ◽  
Bitmap Index ◽  
Secondary Index

Multi-dimensional query optimization algorithm for bitmap index with binning

2010 ◽  
Vol 30 (8) ◽  
pp. 2013-2016 ◽  
Author(s):  
Li-ming WANG ◽  
Xiao CHENG ◽  
Yu-mei CHAI
Keyword(s):  
Query Optimization ◽  
Optimization Algorithm ◽  
Bitmap Index

Efficient processing of distance–time kth-order skyline queries in bicriteria networks

2019 ◽  
Vol 13 (5) ◽  
pp. 796-802
Author(s):  
Jiping Zheng ◽  
Shunqing Jiang ◽  
Jialiang Chen ◽  
Wei Yu
Keyword(s):  
Skyline Queries ◽  
Efficient Processing

scholarly journals MAC5, an RNA-binding protein, protects pri-miRNAs from SERRATE-dependent exoribonuclease activities

2020 ◽  
Vol 117 (38) ◽  
pp. 23982-23990 ◽  
Author(s):  
Shengjun Li ◽  
Mu Li ◽  
Kan Liu ◽  
Huimin Zhang ◽  
Shuxin Zhang ◽  
...  
Keyword(s):  
Rna Binding ◽  
Rna Binding Protein ◽  
Dual Role ◽  
Mirna Biogenesis ◽  
Core Component ◽  
Stem Loop ◽  
Loop Region ◽  
Nuclear Rna ◽  
Efficient Processing ◽  
The Stability

MAC5 is a component of the conserved MOS4-associated complex. It plays critical roles in development and immunity. Here we report that MAC5 is required for microRNA (miRNA) biogenesis. MAC5 interacts with Serrate (SE), which is a core component of the microprocessor that processes primary miRNA transcripts (pri-miRNAs) into miRNAs and binds the stem-loop region of pri-miRNAs. MAC5 is essential for both the efficient processing and the stability of pri-miRNAs. Interestingly, the reduction of pri-miRNA levels inmac5is partially caused by XRN2/XRN3, the nuclear-localized 5′-to-3′ exoribonucleases, and depends on SE. These results reveal that MAC5 plays a dual role in promoting pri-miRNA processing and stability through its interaction with SE and/or pri-miRNAs. This study also uncovers that pri-miRNAs need to be protected from nuclear RNA decay machinery, which is connected to the microprocessor.

scholarly journals The Energy-Efficient Processing of Fine Materials by the Micropyretic Synthesis Route

2012 ◽  
Vol 2012 ◽  
pp. 1-8 ◽  
Author(s):  
H. P. Li
Keyword(s):  
Energy Efficient ◽  
Processing Time ◽  
Combustion Temperature ◽  
Processing Parameters ◽  
The Novel ◽  
Diffusion Controlled ◽  
Efficient Processing ◽  
The One ◽  
Processing Techniques ◽  
Diffusion Controlled Reaction

Energy-efficient processing of TiB compound with nanowhiskers by micropyretic synthesis is investigated in this paper. Micropyretic synthesis not only offers shorter processing time but also excludes the requirement for high-temperature sintering and it is considered as the one of the novel energy-saving processing techniques. Experimental study and numerical simulation are both carried out to investigate the correlation of the processing parameters on the microstructures of the micropyretically synthesized products. The diffusion-controlled reaction mechanism is proposed in this study. It is noted that nanosize TiB whiskers only occurred when the combustion temperature is lower than the melting point of TiB but higher than the extinguished temperature. The results generated in the numerical calculation can be used as a helpful reference to select the proper route of processing nanosize materials. The Arrhenius-type plot of size and temperature is used to calculate the activation energy of TiB reaction. In addition to verifying the accuracy of the experimental measures, the reaction temperature for producing the micropyretically synthesized products with nanofeatures can be predicted.

Efficient processing of MPEG-21 metadata in the binary domain

2005 ◽  
Author(s):  
Christian Timmerer ◽  
Thomas Frank ◽  
Hermann Hellwagner ◽  
Jörg Heuer ◽  
Andreas Hutter
Keyword(s):  
Efficient Processing

Feature Based Comparison and Selection of SDN Controller

2019 ◽  
Vol 16 (05) ◽  
pp. 1950029
Author(s):  
Mohammed Abdul Rahman AlShehri ◽  
Shailendra Mishra
Keyword(s):  
Network Performance ◽  
Campus Network ◽  
Analytic Hierarchy ◽  
Decision Logic ◽  
Feature Based ◽  
Efficient Processing ◽  
Hierarchy Process ◽  
Entire Network ◽  
Sdn Controller ◽  
Selection Of

Software defined network (SDN) controller selection in SDN is a key challenge to the network administrator. In SDN, control plane is an isolated process and operate on control layer. The controller provides a universal view of the entire network and support applications and services. The three focused parameters for controller selection are productivity, campus network and open source. In SDN, it is vital to have a good device for the efficient processing of all requests made by the switch and for good behavior of the network. For selecting best controller for the specified parameters, decision logic has to be developed that allow us to do comparison of the available controllers. Therefore, in this research we have suggested a methodology that uses analytic-hierarchy-process (AHP) to find a best controller. The approach has been studied and verified for a big organization network setup of Al-Majmaah University, Saudi Arabia. The approach is found to be more effective and increase the network performance significantly.

Sign in / Sign up

Export Citation Format

Share Document