Article Per Year (5 Year)
p-Index From 2020 - 2025
0.817
P-Index
This Author published in this journals
All Journal The Eastasouth Journal of Information System and Computer Science
Natti, Murali
Unknown Affiliation
Computer Science & IT

Published : 4 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 4 Documents
Search

 1 
Migrating from Oracle to PostgreSQL: Leveraging Open-Source to Reduce Database Costs and Enhance Flexibility Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 1 No. 02 (2023): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v1i02.433

Abstract

In today’s competitive landscape, organizations are under increasing pressure to reduce IT costs while maintaining or improving operational efficiency. One of the largest ongoing expenses for businesses with significant database infrastructure is the licensing and support fees associated with proprietary database systems, such as Oracle. While Oracle is renowned for its enterprise-grade capabilities and robust features, the escalating costs associated with scaling Oracle database environments can pose a significant financial burden. In contrast, PostgreSQL, a widely adopted open-source relational database, offers a powerful, cost-effective alternative that can provide comparable, and often superior, performance without the hefty licensing and support expenses. This white paper addresses the growing demand for cost-effective database solutions by exploring the migration process from Oracle to PostgreSQL. It highlights the financial and operational benefits of transitioning to PostgreSQL, including significant reductions in Total Cost of Ownership (TCO), improved performance, and greater flexibility in managing large-scale data environments. In particular, we delve into how PostgreSQL’s open-source nature enables organizations to avoid vendor lock-in, reduce upfront capital expenditure, and achieve scalability without compromising on features or functionality. Ultimately, this paper underscores the significance of transitioning to PostgreSQL, not just as a cost-saving measure, but as a strategic decision that enhances an organization’s ability to scale and innovate. By offering a comprehensive view of the migration process, from initial planning to post-migration performance optimization, this white paper equips IT decision-makers with the knowledge and tools to make informed decisions about database architecture and management. It highlights that PostgreSQL is not merely a viable alternative to Oracle, but a compelling choice for businesses looking to future-proof their data management infrastructure while maintaining high levels of performance and security.
Reducing Oracle RAC Wait Events by Using Instance-Specific Block Allocation for Production Applications Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 1 No. 01 (2023): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v1i01.447

Abstract

Oracle Real Application Clusters (RAC) is a robust and high-availability solution designed to enable multiple database instances to share the same physical database, offering benefits such as scalability and fault tolerance. However, while Oracle RAC can support critical production environments, it introduces significant complexities, particularly with regard to wait events. One of the primary performance bottlenecks in Oracle RAC is inter-instance communication, commonly referred to as cache fusion, where instances must exchange and synchronize shared data blocks across the cluster. This overhead becomes particularly problematic for production applications that access commonly used tables or objects, leading to increased wait times, slower response rates, and reduced throughput. This paper outlines a novel approach that aims to alleviate Oracle RAC wait events by binding specific application instances to individual Oracle RAC nodes. By allocating frequently accessed tables or objects to specific nodes, this method reduces contention, optimizes database access, and enhances overall application performance.
Building Trust and Transparency: Leveraging Quarterly Business Reviews to Drive 4-Nines Availability and Proactive Customer Support Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 2 No. 01 (2024): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v2i01.448

Abstract

In the digital age, customers have heightened expectations for both service availability and support, making it crucial for businesses to provide consistent uptime and quality service. Building long-term partnerships depends on fostering trust, transparency, and accountability with clients. Quarterly Business Reviews (QBRs) are one of the most effective strategies to meet these expectations. These structured meetings allow service providers to share performance insights, discuss improvements, and outline future initiatives, ensuring customers feel confident in the reliability of the service they receive. This approach helps reinforce relationships, demonstrating a business’s commitment to service excellence. This white paper explores how QBRs can be leveraged to achieve 4-nines availability (99.99%), proactive support, and enhanced customer satisfaction. By using QBRs, companies can deepen customer engagement, showcase accountability through Root Cause Analysis (RCA) of service incidents, and highlight ongoing service improvements. The paper details the key components of a successful QBR strategy, emphasizing the importance of high availability, proactive customer support, and continuous improvement in fostering stronger customer relationships and achieving mutual business success.
Identifying and Managing Noisy Neighbors in Multi-Tenant PostgreSQL Deployments (On-Premise) Natti, Murali
The Eastasouth Journal of Information System and Computer Science Vol. 2 No. 03 (2025): The Eastasouth Journal of Information System and Computer Science (ESISCS)
Publisher : Eastasouth Institute

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.58812/esiscs.v2i03.488

Abstract

In on-premise multi-tenant PostgreSQL deployments, multiple tenants share the same physical infrastructure to maximize resource utilization and reduce operational costs. However, this shared environment can give rise to significant resource contention, particularly when one tenant exhibits the “noisy neighbor” effect—where its workload consumes a disproportionate amount of CPU, memory, or disk I/O relative to others. This unbalanced resource consumption can lead to widespread performance degradation, manifesting as increased query latency, reduced throughput, and overall service instability. The present article investigates the challenges inherent in multi-tenant setups, focusing on the detection and management of noisy neighbors. It explores both native PostgreSQL monitoring techniques (such as system views and performance statistics) and external solutions including Linux control groups (cgroups) for isolating and limiting resource usage. Additionally, the article outlines best practices for proactive monitoring, query optimization, and resource allocation to ensure a balanced and efficient multi-tenant environment. By providing a comprehensive framework for understanding and mitigating the noisy neighbor phenomenon, this work aims to equip database administrators and system architects with effective strategies for maintaining robust performance, even under heavy and unevenly distributed workloads.
Co-Authors