The Path partitioning could be a thought describing the cluster of all the objects forming a composite object into a partition. A path partitioning can be hierarchy of nodes forming a structural index. Vertical partitioning divides a table into multiple tables that contain fewer columns.In scalability limited due to outgrowing capacity of largest system. More expensive (specialized severs) need to purchase next larger system for increased capability support.Online transaction Processing (OLTP) applications are business applications which are characterized byhigh-frequency short lived data transactions. In cloud domain, applications are expected to be highlyresponsive and low cost with optimized levels of consistency. Online Transaction Processing (OLTP) system record business interaction as they occur in the day-to-day operation of the organization, and support querying of this data to make interfaces .