Did you mean: MICROSOFT OFFICE 2000 MS WORD MS EXCEL MICROSOFT EXCEL 2000 ELEMENTS OF MECHANISMS; MACHINERY, KINEMATICS OF; MACHINERY, DAYNAMICS O; MECHANICAL MOVEMENTS LASER BEAMS.OPTICAL MATERILS- DEFECTS.OPTICAL MATERILS-EFFECTS OF RADIATION ON DESIGN OF ENGINEERING MATERIALS.SCIENCE OF ENGINEERING MATERIALS DEFORMATION MECHANICS FRACTURE MECHANICS MECHANICS OF ENGINEERING MATERIALS ENGINEERING MATERIALS-MECHANICS OBJECT ORIENTED TECHNIQUES OBJECT ORIENTED METHODOLOGY OBJECT ORIENTED MODELING-EMBEDDED SYSTEMS MICROSOFT WORD 2000 MICROSOFT EXCEL 2000 MICROSOFT POWERPOINT 2000 MICROSOFT ACCESS 2000 MICROSOFT OUTLOOK 2000 WORD 2000 EXCEL 2000 POWERPOINT 2000 ACCESS 2000 OUTLOOK 2000 MICROSOFT OFFICE 2000 OFFICE 2000 MICROSOFT OFFICE XP. MICROSOFT-PUBLISHER; MICROSOFT INTERNET EXPLORER; MICROSOFT OUTLOOK; MICROSOFT ACCESS; MICROSOFT POWER POINT; MICROSOFT EXCEL; MICROSOFT WORD; MICROSOFT OFFICE XP BUILDINGS-ENERGY CONSERVATION -HANDBOOK MANUALS ETC.BUILDINGS- ENERGY CONSUMPTION-HANDBOOKS MANUALS ETC. BUILDINGS-MECHANICAL EQUIPMENT- MAINTENANCE AND REPAIR-HANDBOOKS MANUALS ETC.OPERATIONS AND MAINTENANCE MANUAL.ENERGY MANAGEMENT MS-MECH-MIT.MEASUREMENT AND ANALYSIS OF PISTON INTER-RING PRESSURES AND OIL FILM THICKNESS AND THEIR EFFECTS ON ENGINE OIL CONSUMPTION HUMAN ELEMENT IN ENGINEERING MANAGEMENT CREATIVITY MANPOWER PLANNING AND CONTROL ENGINEERING PROJECTS-SELECTION PROJECT MANAGEMENT MANAGEMENT OF TECHNICAL PROPOSALS AND SPECIFICATIONS MANAGEMENT OF ENGINEERING DESIGN MS-CSE-15 MSTHESIS ABSTRACT. Database management Systems (DBMS) are one the most critical component of a software application. Searching data from DBMS is an enormous part in software performance. Text search engines are also used for searching, but these engines lack sophisticated DBMS features. Relational database management systems (RDBMS) are not quite compatible with modern objectoriented languages. To overcome the complexity of data and object-oriented programming, modern development practices adopted Object Relation Mapping frameworks (ORM). ORM bears a layer of abstraction between object models and database. This layer automatically bridges objects in OOP languages to database records, which results in significantly reducing custom mapping code complexity. ORM has its advantages but on the other side it comes with be some challenges too. In process of mapping objects and data, ORM keeps the relations between objects intact and that results in retrieval of multiple objects from multiple tables. When the data is big and have a hieratical structure, data retrieval or search becomes more complex. Database performance for the retrieval of data are optimized by adding indexing to each table. Indexing makes search significantly fast but also makes other processes slow because tables are required to be re-index every time a record is changed. Hence an optimized solution is required to resolve this problem in ORM search process. To overcome this problem, this research proposes a java-based framework that can interact between ORM and search engine. It consumes search engine web APIs to provide a layer that can convert and search objects to/from XML. It makes search process faster and support ORM with its object-oriented methodology. Moreover, this framework not only reduces performance load on databases but also makes search queries simpler when implemented in development process. The results have been validated by two case studies, which were carried out by implementing each approach. 1000 similar search queries were processed on each framework and results shows 30 to 40 % improvement in query time. Keywords: DBMS Search, Indexing, Text Search Engines, Solr inedexes, Object oriented programming (OOP), Object Relation Mapping (ORM), Search optimization, Information Retrieval, database indexing MECHANICAL ENGINEERING - HANDBOOKS MANUALS.MECHANICS OF SOLIDS.ENGINEERING THERMODYNAMICS.FLUID MECHANICS.HEAT AND MASS TRANSFER.ELECTRICAL ENGINEERING.CONTROL MECHANICAL SYSTEMS.CONTROL SYSTEM ANALYSIS.CONTROL SYSTEM DESIGN.ENERGY RESOURCES.ENERGY CONVERSION.AIR CONDITIONING AND REFRIGERATION.TRANSPORTATION.ENGINEERING DESIGN.MATERIALS.MODERN MANUFACTURING.ROBOTICS.MEMS TECHNOLOGY.ENVIRONMENTAL ENGINEERING.ENGINEERING ECONOMICS.PROJECT MANAGEMENT.NANOTECHNOLOGY.MATHEMATICS.PATENT LAW.PRODUCT LIABILITY AND SAFETY.BIOMECHANICS.MECHANICAL ENGINEERING CODES AND STANDARDS.OPTICS.WATER DESALINATION.NOISE CONTROL.LIGHTING TECHNOLOGY ENGINEERING HANDBOOKS,MANUALS,ETC STATICS MECHANICS OF MATERIALS DYNAMICS AND VIBERATION KINEMATICS AND MECHANISMS STRUCTURES FLUID MECHANICS THERODYNAMICS AND HEAT TRANSFER SEPARATION PROCESS FUELS AND ENERGY CONVERSION KINETICS AND REACTION ENGINEERING GEOTECHNICAL TRANSPORTATION COASTAL AND OCEAN ENGINEERING WATER RESOURCE ENGINEERING LINEAR SYSTEMS AND MODELS DIGITAL SYSTEMS COMMUNICATION AND SIGNAL PROCESSING COMPUTERS SURVEYING CONTROL SYSTEMS MANUFACTURING AERONAUTICAL AND AEROSPACE SAFETY ENGINEERING ENGINEERING ECONOMIC AND MANAGEMENT MATERIALS ENGINEERING MATHEMATICS-INTRODUCTION Partial differential equations -- General topics -- Methods of ordinary differential equations. ORGANIZATIONAL EFFECTIVENESS ORGANIZATIONAL LEARNING MANAGEMENT-EMPLOYEE PARTICIPATION INCENTIVES IN INDUSTRY INTERNAL COMBUSTION ENGINE -MATHEMATICS MODELS.CONTROL OF INTERNAL COMBUSTION ENGINE SYSTEMS SCHOOL MANAGEMENTAND ORGANIZATION-HANDBOOK MANUAL ETC; EDUCATIONAL LEADERSHIP-HANDBOOKS, MANUAL,ETC ENCYCLOPEDIA OF MATHEMATICS. MATHEMATICS - ENCYCLOPEDIA MECHANICS OF ENGINEERING MATERIALS.STRENGTH OF MATERIALS IN SI UNITS