Enhancements in data mining for effective information retrieval is an emerging trend. This growth in turn has motivated researchers to seek new techniques for knowledge extraction. This research paper, induce the need for an incremental data mining approach based on data structure called the Bookshelf tree. The provoked approach is shown to be effective for solving problems related to efficiency of handling data updates, accuracy, processing input transactions, and answering user queries. This paper proposes a Branch and Bound Bookshelf Tree incorporated with association mining for self organization of the results retrieved from the RFDDb. This research work focus on the new techniques for keyword search over a mass of tables, and show that they can achieve substantially higher relevance than solutions based on a traditional search engine using Referenced attribute Functional Dependency Database (RFDDb). Branch and Bound is for best optimized result and the bookshelf tree is for organizing result for effective and efficient Information Retrieval (IR).B3-Vis Technique is proposed for visualizing the results retrieved from the Branch and Bound Bookshelf Tree. The relevant queries are arranged in each frame of Book Shelf for effective Information Retrieval. Finally, the search results are presented in visual mode, which allows a user to navigate between extracted schemas. leaves. At level i the members of the solution space are partitioned by their x i values. Members with x i = 1 are in the left subtree.Members with x i = 0 are in the right sub tree and could exchange roles of left and right subtree.Association mining that discovers dependencies among values of an attribute was introduced by Agrawal et al.(5) and has emerged as a prominent research area. The association mining (5) problem also referred to as the market basket problem can be formally defined as follows. Let I = {i 1 , i 2 , . . . , i n } be a set of items. Let D = {t 1 , t 2 , . . .,t m } be a set of transactions called the database. Each transaction in D has a unique transaction ID and contains a subset of the items in I. A rule is defined as an implication of the form X ⇒ Y where X, Y ⊂ I and X ∩ Y = ∅ . The sets of items (6) (for short itemsets) X and Y is called antecedent (left-hand-side or LHS) and consequent (right-hand-side or RHS) of the rule respectively. Several measures have been introduced to define the strength of the relationship between itemsets X and Y such as support, confidence, and interest. The definitions of these measures, from a probabilistic model is (7) given below.