<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Eric Maniraguha on Medium]]></title>
        <description><![CDATA[Stories by Eric Maniraguha on Medium]]></description>
        <link>https://medium.com/@emanirag?source=rss-85a5cdf408c4------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*9VvDG-tBLEdB24pIBG-Dlw.png</url>
            <title>Stories by Eric Maniraguha on Medium</title>
            <link>https://medium.com/@emanirag?source=rss-85a5cdf408c4------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 07:37:16 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@emanirag/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[ Unlocking the Hidden Power of PL/SQL: How Triggers Revolutionize Industries]]></title>
            <link>https://emanirag.medium.com/unlocking-the-hidden-power-of-pl-sql-how-triggers-revolutionize-industries-ca337615fc27?source=rss-85a5cdf408c4------2</link>
            <guid isPermaLink="false">https://medium.com/p/ca337615fc27</guid>
            <dc:creator><![CDATA[Eric Maniraguha]]></dc:creator>
            <pubDate>Sat, 25 Jan 2025 04:02:46 GMT</pubDate>
            <atom:updated>2025-01-25T04:02:46.435Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>🚀 Unlocking the Hidden Power of PL/SQL: How Triggers Revolutionize Industries</strong></p><p>Imagine a world where your database does the heavy lifting for you — automatically ensuring data integrity, alerting you to potential fraud, and logging every critical transaction without you lifting a finger. A few months ago, while teaching a <em>Programming with PL/SQL</em> course at the Adventist University of Central Africa (AUCA), I witnessed the spark in my students’ eyes as they discovered the transformative power of triggers.</p><p>Whether you’re building systems for banking, healthcare, or e-commerce, triggers are game-changers. They automate tasks, secure data, and drive efficiency. This article dives deep into the fascinating world of triggers — what they are, how they work, and their incredible applications across industries.</p><h4><strong>What is a Trigger?</strong></h4><p>A trigger is a piece of procedural code automatically executed in response to specific events on a table or view within a database. Triggers are immensely useful for automating tasks, ensuring data consistency, and enforcing business rules. They respond to events like insertions, deletions, or updates, saving time and reducing human error.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*mJbcabP8tieZHkKapl0rUg.jpeg" /></figure><p><strong>Real-World Applications of Triggers</strong></p><p>Triggers have extensive applications across various industries. Let’s explore some scenarios:</p><p><strong>1. Banking Sector — ATM and Teller Transactions</strong></p><p>In the banking industry, triggers can:</p><ul><li><strong><em>Track Transactions:</em></strong><em> Automatically log every ATM withdrawal or teller transaction in an audit table.</em></li><li><strong><em>Alert Suspicious Activity:</em></strong><em> Monitor withdrawal limits and send alerts if a customer exceeds a threshold.</em></li><li><strong><em>Ensure Data Resilience:</em></strong><em> Back up critical transaction data to safeguard against database failures.</em></li></ul><p><strong>2. Logging User Activities</strong></p><p>In systems with roles like administrators or managers, triggers can:</p><ul><li><em>Track changes to sensitive data by logging who made modifications, what was changed, and when.</em></li><li><em>Monitor logs to detect unusual activities or system errors.</em></li></ul><p><strong>3. Data Validation</strong></p><p>Triggers enforce business rules, ensuring data integrity by validating inputs before they’re saved in the database.</p><p><strong>Example: Creating a Trigger</strong></p><p>Here’s a simple example to demonstrate how triggers work in a banking system.</p><p><strong>Scenario:</strong><br>When a customer withdraws money, the system should:</p><ol><li><em>Log the transaction details (e.g., amount, date, and customer ID).</em></li><li><em>Prevent overdrafts by ensuring the withdrawal amount does not exceed the balance.</em></li></ol><pre>CREATE OR REPLACE TRIGGER log_withdrawals  <br>BEFORE INSERT ON transactions  <br>FOR EACH ROW  <br>DECLARE  <br>    current_balance NUMBER;  <br>BEGIN  <br>    -- Fetch the current balance  <br>    SELECT balance INTO current_balance  <br>    FROM accounts  <br>    WHERE account_id = :NEW.account_id;  <br><br>    -- Validate the withdrawal amount  <br>    IF :NEW.amount &gt; current_balance THEN  <br>        RAISE_APPLICATION_ERROR(-20001, &#39;Insufficient funds.&#39;);  <br>    END IF;  <br><br>    -- Log the transaction  <br>    INSERT INTO transaction_logs (account_id, amount, transaction_date)  <br>    VALUES (:NEW.account_id, :NEW.amount, SYSDATE);  <br>END;  <br>/</pre><p><strong>Explanation:</strong></p><ul><li><strong><em>Event:</em></strong><em> Trigger fires before an insert operation on the </em><em>transactions table.</em></li><li><strong><em>Validation:</em></strong><em> Ensures withdrawal amount doesn’t exceed the customer’s current balance.</em></li><li><strong><em>Logging:</em></strong><em> If validation passes, transaction details are logged in the </em><em>transaction_logs table.</em></li></ul><p><strong>Advanced Use Case: Resolving ATM Notification Discrepancies</strong></p><p><strong>Problem: </strong>Sometimes, customers may receive ATM notifications for transactions that didn’t occur.</p><p><strong>Solution:</strong> A trigger can monitor and log transaction statuses to align notifications with actual events.</p><p>Trigger Code Example:</p><pre>CREATE OR REPLACE TRIGGER atm_transaction_monitor  <br>AFTER INSERT ON atm_transactions  <br>FOR EACH ROW  <br>BEGIN  <br>    -- Log the initial request as pending  <br>    INSERT INTO transaction_logs (transaction_id, account_id, amount, status, timestamp)  <br>    VALUES (:NEW.transaction_id, :NEW.account_id, :NEW.amount, &#39;Pending&#39;, SYSDATE);  <br><br>    -- Update status based on transaction success  <br>    IF :NEW.success = &#39;Y&#39; THEN  <br>        UPDATE transaction_logs  <br>        SET status = &#39;Completed&#39;  <br>        WHERE transaction_id = :NEW.transaction_id;  <br>    ELSE  <br>        UPDATE transaction_logs  <br>        SET status = &#39;Failed&#39;  <br>        WHERE transaction_id = :NEW.transaction_id;  <br>    END IF;  <br>END;  <br>/</pre><p><strong>How This Helps:</strong></p><ul><li>Provides a complete audit trail of ATM transactions.</li><li>Quickly resolves customer complaints by tracking discrepancies.</li><li>Enables real-time alerts for failed transactions to prevent systemic issues.</li></ul><p><strong>Why Use Triggers?</strong></p><p>Triggers offer several advantages:</p><ul><li><strong>Automation:</strong> Eliminate repetitive tasks like logging and data validation.</li><li><strong>Efficiency:</strong> Speed up operations by reducing manual intervention.</li><li><strong>Data Integrity:</strong> Enforce business rules and maintain consistency.</li><li><strong>Real-Time Monitoring:</strong> React instantly to database events with alerts or actions.</li></ul><p><strong>Conclusion</strong></p><p>PL/SQL triggers are a powerful tool in database management, offering automation, security, and efficiency. Whether you’re in banking, healthcare, or e-commerce, triggers can enhance your system’s functionality and reliability.</p><p>By understanding their applications and capabilities, you can unlock the full potential of triggers to streamline operations and ensure data integrity in your next database project.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ca337615fc27" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Rwanda’s National AI Policy: Paving the Way for Innovation and Growth]]></title>
            <link>https://emanirag.medium.com/rwandas-national-ai-policy-paving-the-way-for-innovation-and-growth-59bbd2d7e1f8?source=rss-85a5cdf408c4------2</link>
            <guid isPermaLink="false">https://medium.com/p/59bbd2d7e1f8</guid>
            <dc:creator><![CDATA[Eric Maniraguha]]></dc:creator>
            <pubDate>Tue, 05 Mar 2024 23:19:06 GMT</pubDate>
            <atom:updated>2024-03-05T23:19:06.050Z</atom:updated>
            <content:encoded><![CDATA[<p>In a bid to position itself as a leading hub for artificial intelligence (AI) innovation in Africa, Rwanda has unveiled its National AI Policy. This strategic roadmap aims to harness the transformative power of AI to drive economic growth, improve quality of life, and foster inclusive development.</p><p>One of the key pillars of the policy is the emphasis on data availability and accessibility. Recognizing data as the fuel for Rwanda’s AI ambitions, the government plans to establish a multi-sectoral task force to develop data governance frameworks and protocols. By setting standards for ethical and secure data sharing, Rwanda aims to enhance its AI readiness and unlock the potential of both public and private sector data.</p><p>Trust is identified as a critical factor in the successful adoption of AI technologies. To build public confidence, the policy focuses on strengthening AI policy and regulation aligned with global standards. By empowering regulatory authorities to understand and regulate AI effectively, Rwanda aims to promote transparency and trust in AI applications.</p><p>The policy also highlights the importance of developing a skilled AI workforce. Through a National Skills Building Program and partnerships with the private sector, Rwanda plans to equip its citizens with 21st-century skills and AI literacy. By investing in AI education at the university level and adapting school curricula to include AI and data-related subjects, Rwanda aims to nurture a new generation of AI talent.</p><p>Infrastructure plays a crucial role in enabling AI adoption. Rwanda plans to ensure access to affordable, reliable, and secure high-performance storage and compute capacity. By investing in digital infrastructure and partnering with global players, Rwanda aims to position itself as a host for cloud infrastructure with AI-ready capabilities, serving both the region and the continent.</p><p>Overall, Rwanda’s National AI Policy sets a clear vision for leveraging AI to drive sustainable and inclusive growth. By prioritizing data governance, trust-building, skills development, and infrastructure investment, Rwanda is paving the way for innovation and economic advancement in the AI era.</p><p>Source: <a href="https://www.minict.gov.rw/index.php?eID=dumpFile&amp;t=f&amp;f=67550&amp;token=6195a53203e197efa47592f40ff4aaf24579640e">https://www.minict.gov.rw/index.php?eID=dumpFile&amp;t=f&amp;f=67550&amp;token=6195a53203e197efa47592f40ff4aaf24579640e</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=59bbd2d7e1f8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Evolution of Ops: How AIOps is Revolutionizing Enterprise IT]]></title>
            <link>https://emanirag.medium.com/the-evolution-of-ops-how-aiops-is-revolutionizing-enterprise-it-c485441ca155?source=rss-85a5cdf408c4------2</link>
            <guid isPermaLink="false">https://medium.com/p/c485441ca155</guid>
            <dc:creator><![CDATA[Eric Maniraguha]]></dc:creator>
            <pubDate>Tue, 30 Jan 2024 10:02:06 GMT</pubDate>
            <atom:updated>2024-01-30T10:02:06.222Z</atom:updated>
            <content:encoded><![CDATA[<p><strong><em>I.</em></strong><em> </em><strong><em>Introduction</em></strong></p><p>In today’s rapidly evolving technological sphere, the ascent of various ‘Ops’[1] methodologies has profoundly reshaped the approach of businesses towards development, data management, and IT operations. This transformative shift is intricately woven into the fabric of digital transformation, particularly beneficial for Small and Medium-Sized Enterprises (SMEs), equipping them with invaluable tools for streamlined management, real-time monitoring, and seamless remote control of operations. From the pioneering era of DevOps to the cutting-edge frontier of AIOps, each successive iteration has heralded novel efficiencies and capabilities, propelling organizations towards heightened agility and fostering a culture of relentless innovation</p><p><strong><em>II.</em></strong><em> </em><strong><em>The Ops Evolution</em></strong></p><ol><li><strong>DevOps:</strong> It all began with DevOps, a fusion of software development and IT operations aimed at accelerating the delivery of high-quality software. DevOps introduced automation and collaboration, breaking down silos and fostering a culture of continuous integration and delivery.</li><li><strong>DataOps</strong>: As organizations recognized the need to apply DevOps principles to their data practices, DataOps emerged. DataOps extends agile methodologies to data analytics, emphasizing collaboration, automation, and monitoring throughout the data lifecycle.</li><li><strong>MLOps</strong>: With the rise of machine learning and AI, MLOps entered the scene to streamline the lifecycle of machine learning models. MLOps integrates DevOps practices with machine learning workflows, ensuring efficient model deployment, monitoring, and optimization.</li><li><strong>AIOps</strong>: The latest evolution, AIOps, harnesses artificial intelligence and machine learning to transform IT operations. AIOps platforms automate mundane tasks, analyze vast amounts of data, and provide actionable insights to enhance decision-making and performance.</li></ol><p><strong><em>III. The Synergy of Ops</em></strong></p><p>While each Ops methodology has its distinct focus, they are interconnected, forming a cohesive ecosystem that drives efficiency and innovation across the enterprise.</p><ul><li><strong>DevOps Drives the Foundation:</strong> DevOps lays the groundwork for collaboration, automation, and continuous improvement. Its principles permeate through DataOps, MLOps, and AIOps, shaping their practices and methodologies.</li></ul><p><strong>Example:</strong> Code, build, test, deploy, monitoring</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*GC3ibe2d_xJnwe5jmoKRIQ.png" /><figcaption>Figure 1: DevOps as a joint effort and areas of responsibility for R&amp;D, QA, and ITOps</figcaption></figure><ul><li><strong>DataOps Bridges the Data Divide:</strong> DataOps brings agility and efficiency to data management, ensuring that data pipelines are robust, scalable, and reliable. By applying DevOps principles to data analytics, organizations can unlock the full potential of their data assets.</li><li><strong>MLOps Powers Intelligent Decision-Making:</strong> MLOps operationalizes machine learning models, enabling organizations to deploy, monitor, and iterate on models efficiently. By integrating with DevOps practices, MLOps ensures that AI initiatives are seamlessly integrated into the software development lifecycle.</li><li><strong>AIOps Transforms IT Operations:</strong> AIOps represents the pinnacle of Ops evolution, leveraging AI and machine learning to revolutionize IT operations. By automating routine tasks, detecting anomalies, and predicting issues before they occur, AIOps empowers IT teams to deliver superior performance and reliability.</li></ul><p><strong><em>IV. Simplified Representation Diagram</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/906/1*8_Okj7GfkmVmjXpE3RVZpA.png" /><figcaption>Figure 1 illustrates how the various Ops methodologies — DevOps, DataOps, MLOps, and AIOps — collaborate to enhance efficiency.</figcaption></figure><p>A prime example of this collaborative approach is ChatOps, which seamlessly integrates people, tools, processes, and automation into a transparent workflow.</p><p><strong><em>V.</em></strong><em> </em><strong><em>Implementing AIOps: The Path Forward</em></strong></p><p>As enterprises embrace AIOps, they embark on a journey of transformation and optimization. A successful AIOps implementation requires a strategic approach, focusing on three key pillars:</p><ul><li><strong>Observability</strong>: Establishing robust monitoring capabilities to capture real-time data across systems and applications.</li><li><strong>Resource Optimization</strong>: Leveraging insights from data analysis to optimize resource utilization and mitigate potential issues.</li><li><strong>Problem Determination</strong>: Proactively identifying and resolving issues through predictive analytics and automated remediation.</li></ul><p><strong><em>VI.</em></strong><em> </em><strong><em>Embracing the Future with AIOps</em></strong></p><p>As organizations navigate the complexities of modern IT environments, AIOps emerges as a beacon of innovation and efficiency. By embracing AIOps, enterprises can unlock new possibilities, driving productivity, resilience, and competitive advantage.</p><p>In conclusion, the evolution of Ops — from DevOps to AIOps — reflects a journey of continuous improvement and adaptation. By embracing the principles of collaboration, automation, and intelligence, organizations can thrive in an era of rapid technological advancement.</p><p><strong><em>VII. References</em></strong></p><p><em>[1] S. H. U. May 10, 2023 | Published March 13, and 2023, “All the Ops: DevOps, DataOps, MLOps, and AIOps,” IBM Developer. Accessed: Jan. 30, 2024. [Online]. Available: </em><a href="https://developer.ibm.com/articles/all-the-ops-devops-dataops-mlops-and-aiops/"><em>https://developer.ibm.com/articles/all-the-ops-devops-dataops-mlops-and-aiops/</em></a></p><p><em>[2] Y. Liu, Z. Ni, M. Karlsson, and S. Gong, “Methodology for Digital Transformation with Internet of Things and Cloud Computing: A Practical Guideline for Innovation in Small- and Medium-Sized Enterprises,” Sensors, vol. 21, no. 16, Art. no. 16, Jan. 2021, doi: 10.3390/s21165355.</em></p><p><em>[3] “OpsPAI/awesome-AIOps.” OpsPAI, Jan. 29, 2024. Accessed: Jan. 30, 2024. [Online]. Available: </em><a href="https://github.com/OpsPAI/awesome-AIOps"><em>https://github.com/OpsPAI/awesome-AIOps</em></a></p><p><em>[4] I. C. Education, “What Are the Benefits of ChatOps?,” IBM Blog. Accessed: Jan. 30, 2024. [Online]. Available: </em><a href="https://www.ibm.com/blog/benefits-of-chatops/www.ibm.com/blog/benefits-of-chatops"><em>https://www.ibm.com/blog/benefits-of-chatops/www.ibm.com/blog/benefits-of-chatops</em></a></p><p><em>[5] Z. Cybulski, “What Is AIOps, BizDevOps, CloudOps, DevOps, ITOps, NoOps? A Gentle Introduction to Digital Business Transformation.” Accessed: Jan. 30, 2024. [Online]. Available: </em><a href="https://www.stxnext.com/blog/aiops-bizdevops-cloudops-devops-itops-noops-introduction-digital-business-transformation/"><em>https://www.stxnext.com/blog/aiops-bizdevops-cloudops-devops-itops-noops-introduction-digital-business-transformation/</em></a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c485441ca155" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>