<?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 Tanmay P. Deshmukh on Medium]]></title>
        <description><![CDATA[Stories by Tanmay P. Deshmukh on Medium]]></description>
        <link>https://medium.com/@tanmay.deshmukh20?source=rss-41bcd3825636------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*5ug_TphXQQgZa1xw3k4jcQ.jpeg</url>
            <title>Stories by Tanmay P. Deshmukh on Medium</title>
            <link>https://medium.com/@tanmay.deshmukh20?source=rss-41bcd3825636------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 23:33:21 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@tanmay.deshmukh20/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[The Dynamics of Project Success: A Management Guide]]></title>
            <link>https://medium.com/@tanmay.deshmukh20/the-dynamics-of-project-success-a-management-guide-a39824f3e99e?source=rss-41bcd3825636------2</link>
            <guid isPermaLink="false">https://medium.com/p/a39824f3e99e</guid>
            <dc:creator><![CDATA[Tanmay P. Deshmukh]]></dc:creator>
            <pubDate>Fri, 01 Dec 2023 12:16:39 GMT</pubDate>
            <atom:updated>2023-12-02T03:15:51.147Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ivuqPptPjVQ8qbwfWhLZpA.jpeg" /></figure><p>Welcome to our comprehensive guide on best practices in project management. Project management plays a critical role in the success of any organization, ensuring projects are completed on time, within budget, and to the satisfaction of stakeholders. In this article, we will explore the key principles, strategies, and techniques that can help you effectively manage projects from start to finish.</p><p>Whether you are a seasoned project manager or just starting out in your career, this guide will provide you with valuable insights and practical advice. We will delve into topics such as project planning, scheduling, risk management, communication, and leadership. By implementing these best practices, you can enhance your project management skills and increase your chances of delivering successful outcomes.</p><h3><strong>Importance of Project Management</strong></h3><p>Effective project management is crucial for organizations to achieve their goals and objectives. It provides a structured approach to planning, executing, and controlling projects, ensuring that they are completed efficiently and effectively. Without proper project management, projects can quickly become chaotic, leading to missed deadlines, budget overruns, and dissatisfied stakeholders.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/0*nlzrtBApPW4qFEkH" /></figure><p>One of the key benefits of project management is its ability to provide clarity and direction. By defining project goals, scope, and deliverables upfront, project managers can set clear expectations for all team members. This helps to minimize misunderstandings, improve collaboration, and keep everyone focused on the project’s objectives.</p><p>Additionally, project management enables organizations to optimize their use of resources. By carefully planning and allocating resources, project managers can ensure that the right people with the right skills are assigned to the project. This not only increases productivity but also reduces the risk of burnout and improves overall team morale.</p><p>In summary, project management is essential for organizations looking to achieve success in their projects. It provides structure, clarity, and resource optimization, leading to improved project outcomes and stakeholder satisfaction.</p><h3><strong>Project Management Methodologies</strong></h3><p>There are various project management methodologies available, each with its own set of principles, processes, and tools. The choice of methodology depends on the nature of the project, organizational preferences, and industry standards. Let’s take a look at some of the most commonly used project management methodologies:</p><blockquote><strong>Waterfall:</strong></blockquote><p>The waterfall methodology follows a linear, sequential approach to project management. It involves distinct phases, such as initiation, planning, execution, monitoring, and closure. Each phase is completed before moving on to the next, making it suitable for projects with well-defined requirements and a predictable environment.</p><blockquote><strong>Agile:</strong></blockquote><p>Agile methodologies, such as Scrum and Kanban, are iterative and flexible approaches to project management. They focus on delivering value in short increments called sprints. Agile methodologies are best suited for complex, dynamic projects that require frequent adaptation and collaboration.</p><blockquote><strong>Lean:</strong></blockquote><p>The lean methodology aims to eliminate waste and maximize value. It focuses on streamlining processes, reducing unnecessary steps, and continuously improving efficiency. Lean project management is commonly used in manufacturing and production industries.</p><blockquote><strong>PRINCE2:</strong></blockquote><p>PRINCE2 (Projects in Controlled Environments) is a structured project management methodology widely used in the UK and Europe. It provides a framework for managing projects of any size and complexity, emphasizing controlled processes, clear roles and responsibilities, and effective communication.</p><p>These are just a few examples of project management methodologies. It’s important to choose the methodology that best aligns with your project’s requirements and organizational culture.</p><h3><strong>Key Elements of Effective Project Management</strong></h3><p>Successful project management requires a combination of various elements working together harmoniously. Let’s explore the key elements that contribute to effective project management:</p><blockquote><strong>Clear project objectives:</strong></blockquote><p>Clearly defining project objectives is essential for project success. Objectives should be specific, measurable, achievable, relevant, and time-bound (SMART). This ensures that everyone involved in the project understands what needs to be accomplished and can work towards a common goal.</p><blockquote><strong>Competent project team:</strong></blockquote><p>Building a competent project team is crucial. It involves selecting individuals with the right skills, experience, and motivation for the project. Effective team communication, collaboration, and trust are also vital for project success.</p><blockquote><strong>Robust project planning:</strong></blockquote><p>Thorough project planning sets the foundation for a successful project. It includes defining project scope, creating a work breakdown structure, identifying tasks and dependencies, estimating resources and durations, and developing a realistic project schedule.</p><blockquote><strong>Effective risk management:</strong></blockquote><p>Identifying and managing project risks is essential to minimize their impact on project success. This involves conducting risk assessments, developing risk response strategies, and regularly monitoring and controlling risks throughout the project lifecycle.</p><blockquote><strong>Efficient communication and stakeholder management:</strong></blockquote><p>Effective communication is crucial for project success. Project managers should establish clear communication channels, regularly update stakeholders on project progress, and address any concerns or issues promptly. Stakeholder management involves identifying and engaging key stakeholders, understanding their needs and expectations, and keeping them informed throughout the project.</p><blockquote><strong>Strong leadership and decision-making:</strong></blockquote><p>Strong leadership is essential for guiding the project team, resolving conflicts, and making timely and informed decisions. A project manager should possess effective leadership skills, be able to motivate the team, and provide clear direction and support.</p><p>These key elements, when integrated and executed effectively, contribute to successful project management and increase the chances of delivering desired project outcomes.</p><h3><strong>Project Planning and Scope Management</strong></h3><p>Project planning and scope management are critical components of effective project management. They involve defining project objectives, deliverables, and boundaries, as well as creating a roadmap for project execution. Let’s explore these concepts in more detail:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*bYA6S8m2LorJZsX3PPQQXA.png" /></figure><blockquote><strong>Defining project objectives:</strong></blockquote><p>Clearly defining project objectives ensures that everyone involved in the project understands what needs to be achieved. Objectives should be specific, measurable, achievable, relevant, and time-bound (SMART). This helps to set clear expectations and provides a basis for project planning.</p><blockquote><strong>Creating a work breakdown structure (WBS):</strong></blockquote><p>A work breakdown structure breaks down the project into smaller, more manageable components. It helps to identify all the tasks required to complete the project and organizes them into a hierarchical structure. The WBS serves as a foundation for estimating resources, durations, and dependencies.</p><blockquote><strong>Developing a project schedule:</strong></blockquote><p>Developing a realistic project schedule is crucial for effective project planning. It involves estimating the time required to complete each task, considering dependencies and resource availability, and creating a timeline for project execution. A well-developed project schedule helps to ensure that tasks are completed in a logical sequence and that project milestones are achieved on time.</p><blockquote><strong>Managing project scope:</strong></blockquote><p>Project scope management involves defining and controlling what is included and excluded from the project. It helps to prevent scope creep, which refers to uncontrolled changes or additions to the project scope. Effective scope management ensures that the project remains focused, delivers the intended results, and avoids unnecessary delays and budget overruns.</p><p>By investing time and effort in project planning and scope management, project managers can set a solid foundation for project success. These activities provide clarity, direction, and control, enabling the project team to work towards a common goal.</p><h3><strong>Time and Resource Management in Project Management</strong></h3><p>Time and resource management are crucial aspects of effective project management. They involve optimizing the use of time and resources to ensure project tasks are completed efficiently and within budget. Let’s explore these concepts in more detail:</p><blockquote><strong>Estimating task durations:</strong></blockquote><p>Estimating task durations is a critical step in project planning. It involves predicting the time required to complete each task based on historical data, expert judgment, and input from the project team. Accurate task duration estimates help to create a realistic project schedule and ensure that project milestones are achievable.</p><blockquote><strong>Allocating resources:</strong></blockquote><p>Allocating the right resources to the right tasks is essential for project success. It involves identifying the skills and availability of team members, considering resource constraints, and assigning tasks accordingly. Effective resource allocation helps to maximize productivity, minimize bottlenecks, and ensure that project tasks are completed on time.</p><blockquote><strong>Managing project dependencies:</strong></blockquote><p>Project dependencies refer to the relationships between project tasks. Some tasks may be dependent on the completion of others before they can start. Managing project dependencies involves identifying and documenting these relationships, ensuring that tasks are scheduled in the correct sequence, and minimizing any delays or disruptions.</p><blockquote><strong>Monitoring and controlling project progress:</strong></blockquote><p>Regularly monitoring and controlling project progress is essential to ensure that tasks are on track and that any deviations from the project plan are addressed promptly. This involves tracking task completion, identifying and resolving issues, and making necessary adjustments to the project schedule and resource allocation.</p><blockquote><strong>Optimizing resource utilization:</strong></blockquote><p>Efficiently utilizing resources helps to minimize waste and maximize productivity. Project managers should regularly review resource allocation, identify any underutilized or overutilized resources, and make adjustments as necessary. This helps to ensure that resources are used effectively and that project tasks are completed efficiently.</p><p>By effectively managing time and resources, project managers can optimize project outcomes, minimize delays and budget overruns, and increase overall project efficiency.</p><h3><strong>Risk Management in Project Management</strong></h3><p>Risk management is an integral part of effective project management. It involves identifying, assessing, and controlling risks that may impact the project’s objectives. Let’s explore the key steps involved in risk management:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*vqAsiGunP0ROyZqQrkpk-w.png" /></figure><blockquote><strong>Risk identification:</strong></blockquote><p>The first step in risk management is identifying potential risks that may affect the project. This can be done through brainstorming sessions, historical data analysis, expert judgment, and stakeholder input. Risks can be categorized into different types, such as technical, organizational, environmental, and external risks.</p><blockquote><strong>Risk assessment and analyzation:</strong></blockquote><p>Once risks are identified, they need to be assessed in terms of their likelihood of occurrence and potential impact on the project. This helps to prioritize risks and determine which ones require immediate attention. Risk assessment techniques, such as qualitative and quantitative analysis, can be used to evaluate risks.</p><blockquote><strong>Risk response planning:</strong></blockquote><p>After assessing risks, project managers need to develop appropriate risk response strategies. These strategies can include risk avoidance, risk mitigation, risk transfer, or risk acceptance. Each risk response should be tailored to the specific risk and its potential impact on the project.</p><blockquote><strong>Risk monitoring and control:</strong></blockquote><p>Risk management is an ongoing process that requires regular monitoring and control. Project managers should continuously monitor identified risks, assess their effectiveness, and make necessary adjustments to risk response strategies. This helps to ensure that risks are effectively managed throughout the project lifecycle.</p><p>By implementing effective risk management practices, project managers can minimize the impact of risks on project objectives, enhance stakeholder confidence, and increase the likelihood of project success.</p><h3><strong>Communication and Stakeholder Management in Project Management</strong></h3><p>Effective communication and stakeholder management are crucial for project success. They involve establishing clear communication channels, keeping stakeholders informed, and managing their expectations. Let’s explore these concepts in more detail:</p><blockquote><strong>Establishing communication channels:</strong></blockquote><p>Project managers should establish clear communication channels to facilitate effective information exchange. This can include regular project status meetings, email updates, project management software, and collaboration tools. Clear and open communication helps to ensure that everyone involved in the project is on the same page and has access to relevant information.</p><blockquote><strong>Stakeholder identification and analysis:</strong></blockquote><p>Identifying and analyzing project stakeholders is essential for effective stakeholder management. Stakeholders can include project sponsors, clients, team members, end-users, and regulatory bodies. Understanding their needs, expectations, and influence on the project helps project managers to effectively engage and manage them.</p><blockquote><strong>Stakeholder engagement and communication:</strong></blockquote><p>Project managers should actively engage and communicate with stakeholders throughout the project lifecycle. This involves regular updates on project progress, addressing any concerns or issues raised by stakeholders, and involving them in decision-making processes when appropriate. Effective stakeholder communication helps to build trust, manage expectations, and maintain stakeholder satisfaction.</p><blockquote><strong>Managing conflicts and resolving issues:</strong></blockquote><p>Conflicts and issues are inevitable in any project. Project managers should be prepared to address conflicts and resolve issues promptly and effectively. This can involve facilitating open discussions, considering alternative solutions, and involving relevant stakeholders in the resolution process. Effective conflict management helps to maintain a positive project environment and ensures that project objectives are not compromised.</p><p>By prioritizing effective communication and stakeholder management, project managers can enhance collaboration, build strong relationships, and increase stakeholder satisfaction throughout the project lifecycle.</p><h3><strong>Project Monitoring and Control</strong></h3><p>Project monitoring and control are essential for ensuring that project tasks are completed as planned and that any deviations are addressed promptly. Let’s explore the key steps involved in project monitoring and control:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Igk2YW0McvMNBn1x.png" /></figure><blockquote><strong>Tracking project progress:</strong></blockquote><p>Project managers should regularly track project progress to ensure that tasks are being completed as planned. This can involve updating project schedules, comparing actual progress against planned progress, and identifying any variations or delays. Tracking project progress helps to identify potential issues early and enables timely corrective actions.</p><blockquote><strong>Performance measurement:</strong></blockquote><p>Measuring project performance involves assessing the performance of project tasks, team members, and overall project progress. Key performance indicators (KPIs) can be used to measure project performance against predefined targets. This helps project managers to identify areas of improvement, optimize resource allocation, and ensure that project objectives are being met.</p><blockquote><strong>Change management:</strong></blockquote><p>Change is inevitable in any project. Project managers should have a robust change management process in place to handle any requested changes effectively. This involves evaluating change requests, assessing their impact on the project, and making informed decisions on whether to approve or reject them. Effective change management helps to maintain project control and minimize disruptions.</p><blockquote><strong>Quality assurance:</strong></blockquote><p>Quality assurance ensures that project deliverables meet the required standards and expectations. Project managers should establish quality control processes, conduct regular inspections, and implement corrective actions if necessary. This helps to minimize rework, ensure customer satisfaction, and enhance project outcomes.</p><blockquote><strong>Project closure:</strong></blockquote><p>Proper project closure is essential for wrapping up the project and ensuring that all project tasks and deliverables are completed. This involves conducting a project review, documenting lessons learned, and preparing a final project report. Project closure provides an opportunity to evaluate project success, celebrate achievements, and identify areas for improvement in future projects.</p><p>By effectively monitoring and controlling the project, project managers can ensure that tasks are completed as planned, project objectives are achieved, and stakeholders are satisfied with the project outcomes.</p><h3>Evaluate and learn from each project</h3><p>To truly excel in project management and continuously improve your skills, it is essential to evaluate and learn from each project you undertake. Evaluating the outcomes and processes of your projects can provide valuable insights for future endeavors.</p><p>Take the time to reflect on what went well and what could have been improved. Analyze the project’s success in meeting objectives, staying within budget and timeline, and satisfying client expectations. Identify any challenges or issues that arose and consider how they could have been prevented or resolved more effectively.</p><p>By conducting thorough project evaluations, you can identify patterns, trends, and areas of improvement. This knowledge can then be used to refine your project management techniques and implement best practices for future projects.</p><p>In addition, don’t forget to celebrate successes and acknowledge the contributions of your team. Recognize the efforts that led to positive outcomes and identify the strategies that worked well. Sharing these lessons learned can benefit not only future projects but also the professional growth of your team members.</p><p>Remember, project management is an iterative process, and continuous learning is key to achieving effective results. By evaluating and learning from each project, you can refine your skills, optimize your approach, and consistently deliver successful outcomes</p><h3><strong>Conclusion and Key Takeaways</strong></h3><p>In this comprehensive guide, we have explored the best practices in project management. We have discussed the importance of project management, various project management methodologies, key elements of effective project management, and specific areas such as project planning, time and resource management, risk management, communication and stakeholder management, and project monitoring and control.</p><p>By implementing these best practices, you can enhance your project management skills and increase your chances of delivering successful outcomes. Remember to prioritize clear project objectives, build a competent project team, and invest time in robust project planning. Additionally, effective risk management, communication, and stakeholder engagement are crucial for project success.</p><p>We understand the importance of efficient project management. Our experienced team of project managers has honed their skills through years of hands-on experience, and we are excited to share our knowledge with you. By following the best.</p><h3><strong>Written By:</strong></h3><blockquote>1. Prof. Vijay Itnal</blockquote><blockquote>2. Atharva Agrawal</blockquote><blockquote>3. Tanmay Deshmukh</blockquote><blockquote>4. Vedant Bhosle</blockquote><blockquote>5. Aditya Bhartiya</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a39824f3e99e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Application Layer Protocols]]></title>
            <link>https://medium.com/@tanmay.deshmukh20/application-layer-protocols-cd37ac84e8c5?source=rss-41bcd3825636------2</link>
            <guid isPermaLink="false">https://medium.com/p/cd37ac84e8c5</guid>
            <dc:creator><![CDATA[Tanmay P. Deshmukh]]></dc:creator>
            <pubDate>Wed, 23 Nov 2022 18:01:35 GMT</pubDate>
            <atom:updated>2022-11-23T18:10:47.208Z</atom:updated>
            <content:encoded><![CDATA[<p>Computer Networks</p><p><strong>Introduction to Application layer protocols</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/967/1*9AemT-gC0a4cp3lkeCRIRQ.png" /></figure><p>The OSI model’s seventh and final layer is the application layer. This layer, known as the abstraction layer, uses the OSI and TCP/IP models to manage the sharing protocols over a computer network. Its proximity to the user suggests that the application layer and the user may have direct communication with the software programme. The application layer of the internet protocol suite includes interface techniques and communication protocols that are used to process communications over networks. The application layer in the TCP/IP model is created by integrating the top three layers: application layer, presentation layer, and session layer. Several protocols are included at the application layer, including Telnet, FTP, TFTP, SMTP, SNMP, DNS, and DHCP.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ooz6KHzT039to00JO3lH_A.png" /></figure><p><strong>What Services Are Offered by the Application Layer?</strong></p><p>The following services are offered by the application:</p><ol><li>The application layer ensures that the recipient is identified, reachable, and prepared to receive information from the sender.</li><li>It permits device-to-device authentication for an additional layer of network security.</li><li>At the application level, it chooses the protocol and data syntax rules.</li><li>The fundamental grammar of the message being transmitted or retrieved is also specified by the protocols of the application layer.</li><li>The presence of relevant communication interfaces, like an Ethernet or Wi-Fi interface, on the sender’s computer is also verified.</li><li>The user application is then shown the data on the receiving end.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1DzZGhlOdGc-qcSH7_CtUQ.png" /></figure><p><strong>Protocols for applications layers</strong></p><p>The numerous protocols used at the application layer facilitate quicker, more effective, dependable, and secure communication between sender and recipient. The protocols in question are covered below:</p><p><strong>1. TELNET:</strong></p><p>Telnet employs terminal connections for a text-based, bidirectional interactive communication function. It can be used to configure many networking hardware components. An 8-bit byte-oriented data connection at TCP uses information that is interspersed in-band with Telnet control information. The client-server protocol is used to access the command line on distant computers. It establishes connections with distant computers via port 23.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1004/1*ZgQntDTGVQiX5PSLt45QGQ.png" /><figcaption>Working of TELNET</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PE-iS_XoD4Eub-cbs7Awxw.png" /></figure><p><strong>2. File Transfer Protocol</strong></p><p>To move a file from one place to another, or from one host to another host, FTP is utilized. TCP/IP offers a common technique for doing so. Although moving files between systems appears to be fairly simple, there are certain issues that must be resolved first. Two TCP services are employed. A control connection and a data connection. It employs the well-known ports 21 and 20 for control and data connections, respectively.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DEZeHngbLTPpi5Nw3qAM7Q.png" /><figcaption>Working of FTP</figcaption></figure><blockquote>Emails can’t be sent using FTP.</blockquote><blockquote>FTP can transfer one file at a time.</blockquote><blockquote>FTP is a stateful protocol.</blockquote><p><strong>3. Trivial File Transfer Protocol</strong></p><p>It is used to deliver files from the server to the client. UDP, or User Datagram Protocol, is used here. It is typically used to transfer files between computers that are only connected to the local network. The fact that TFTP consumes less memory is its key strength. If computers lack hard drives, this application layer protocol could be used to transmit boot files. TFTP typically utilizes Protocol 69, however when it is configured, the communication port may be specified.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/991/1*LO70pgWHCh1ceVmPuS5DBg.png" /><figcaption>Working of TFTP</figcaption></figure><p><strong>4. Simple mail transfer protocol</strong></p><p>The emails are transferred using a SMTP. It outlines the requirements for sending back and forth between instructions and responses. It is used twice: once between the two mail servers and once between the sender and the sender’s mail server. Message Transfer Agents, or MTAs, handle the actual mail transfer. To send mail from one system to another, the system needs both client and server message transfer agents. SMTP uses the port number 25.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QfIlYJ8hvPAQAS52DK_6IQ.png" /><figcaption>Working of SMTP</figcaption></figure><blockquote>SMTP is a protocol that just uses text.</blockquote><blockquote>The restricted functionality of email is increased by MIME.</blockquote><blockquote>SMTP is a stateless protocol.</blockquote><blockquote>At the receiver’s end, we are unable to use SMTP.</blockquote><blockquote>SMTP cannot be used between the machines of the sender and the recipient.</blockquote><blockquote>Client authentication is not appropriate for SMTP.</blockquote><p><strong>5. Domain Name System</strong></p><p>A decentralized naming system called DNS is used by computers and other internet-connected devices to transform domain names from any private network or the internet to numerical IP addresses and vice versa. The user does not need to remember the domain’s IP address thanks to DNS. Both the TCP and UDP protocols are supported by DNS. The port 53 is used by DNS servers. Generic domains designate registered hosts based on their generic behavior, country domains utilize a two-character country abbreviation, and inverse domains map addresses to maps. These three categories make up all domains.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B_TeGH7aiaEJzUh32Di0vA.png" /><figcaption>Working of DNS</figcaption></figure><p><strong>Conclusion</strong></p><p>The suite is a collection of protocols that includes a variety of distinct protocols for various needs and purposes. This suite of protocols has a unique reference model that it adheres to online. There are fewer layers in this protocol paradigm than in the OSI model. A communications network’s hosts employ shared protocols and interface methods, which are specified by an abstraction layer called the application layer.</p><p>That’s it for this blog.</p><p>Keep Learning :)</p><p><strong>Team TY_13!</strong></p><h3>Writers :</h3><ul><li><a href="https://medium.com/u/41bcd3825636?source=post_page-----b15a7c868b38--------------------------------">Tanmay Deshmukh</a></li><li><a href="https://medium.com/u/9325131b0a25?source=post_page-----b15a7c868b38--------------------------------">Jay Deshmukh</a></li><li><a href="https://medium.com/u/cb3e726951ee?source=post_page-----b15a7c868b38--------------------------------">Pratik Dhamal</a></li><li>Aditya Bhartiya</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cd37ac84e8c5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[P Vs NP]]></title>
            <link>https://medium.com/@tanmay.deshmukh20/p-vs-np-38190e5926cf?source=rss-41bcd3825636------2</link>
            <guid isPermaLink="false">https://medium.com/p/38190e5926cf</guid>
            <dc:creator><![CDATA[Tanmay P. Deshmukh]]></dc:creator>
            <pubDate>Sun, 20 Nov 2022 11:07:35 GMT</pubDate>
            <atom:updated>2022-11-25T03:21:11.200Z</atom:updated>
            <content:encoded><![CDATA[<p>Design Analysis and Algorithm.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*IE4E6uqBRWhNQIQN.png" /></figure><p>The most well-known unsolved issue in theoretical computer science. Its solution may deepen our understanding of algorithm complexity or may provide us with a mathematical tool for effectively solving challenging problems. There has been a lot of effort put into finding a solution, but nobody has ever been successful.</p><p>It asks whether every problem whose solution can be quickly verified can also be solved quickly ??</p><p><strong>HISTORY: -</strong></p><p>Cook first proved that the Boolean satisfiability problem belongs to the NP-Complete class in a paper titled “The Complexity of Theorem Proving Procedures” in 1971. He also demonstrated that any NP problem could be converted to an NP-Complete one using a Turing machine in a polynomial amount of time.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/513/0*6wTD2PaLHQIvbtlc.jpg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*d2dFgfkM5wZaWXqL.jpg" /><figcaption>Stephen Arthur Cook and Richard M. Karp</figcaption></figure><p>Karp presented an additional 21 NP-Complete problems in 1973. Since then, enormous effort has been put forth in either finding an algorithm that will convert any NP problem to P or, on the other hand, establishing the distinction between these two kinds of problems.</p><h3>P-Class</h3><p>The class P includes all problems that can be solved in polynomial time, or, in the worst-case scenario, in time O(n^k), where k is constant.</p><p>These problems are called <strong>tractable</strong>, while others are called <strong>intractable or super polynomial</strong>.</p><p>A formal definition of a polynomial time algorithm is one in which any instance of size n may be solved by the algorithm in time O(p(n)).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Oz8YxIHKxiZUPFIzJ4hkkg.png" /></figure><p><strong>Examples of P-Class Problems:</strong></p><p>❏Multiplication ❏Recognizing relatively prime integers ❏Sorting</p><p>❏Divisibility ❏Recognizing palindromes ❏Factorization</p><p>❏Matching symbols in a string ❏Searching elements ❏Graph Connectivity</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/283/1*hvo9xlge7gt96jTcUJLwPA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/331/1*zVCVNiN1e9eagFH-XU4YmA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/496/1*MjXhvcNoH51gqAfeDDu9Xg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/699/1*bduVBe8nY39i0BodVGKdSg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/343/1*9U8VQ8pJQEGuTKHVVF1gKw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/542/1*MtieFrCfb2tPaXvlZO2fYQ.png" /></figure><h3>NP-Class:</h3><p>The problems that can be verified in polynomial time belong to the class NP. With the help of a little extra information, it is simple to verify the accuracy of a stated answer for the class of decision problems known as NP. So, instead of asking for a solution, we are just seeking confirmation that a purported answer is in fact correct.</p><p>Every problem in this class can be solved in exponential time using exhaustive search.</p><p><strong>THE FUNDAMENTAL DILEMMA:</strong></p><blockquote>If the correct solution to a problem can be verified in polynomial time, can it also be found in polynomial time?</blockquote><p>So P=NP means that for every problem that has an efficiently verifiable solution, we can find that solution efficiently as well. A solution to one exercise would give the key to all NP problems.</p><p>Most scientists, according to surveys, feel that P is not equivalent to NP because it is doubtful that we would be able to avoid exponential search and because a single trick would not likely be able to overcome all of these issues.</p><p><strong>NP Complete Problem</strong></p><p>A language must be a member of both the np class and the np hard class problem in order to be classified as a np complete problem.</p><p>Some of the problems from np and np hard can be considered for this class as it falls under both of the classes.</p><p>There are some important theorems related to np problems, they are</p><p>a. If any NP-Complete Language is in P then P=NP</p><p>b. If any NP-Complete is not in P then P != NP</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/759/1*7Dks9yTgonSkHIR_AuVrTA.png" /><figcaption>One Of The Example for NP class can be taken as <strong>Travelling Salesman Problem</strong></figcaption></figure><p>One of the most well-known “np complete” problem examples is this one. The goal of this issue is for a tourist to visit every city on a given list while keeping in mind that each city should only be visited once. The distances between each city are known in advance. What should be the quickest route that he travels through each city exactly once before returning to the starting city must be determined.</p><p>Solution to this is calculating all the possible routes by using the permutations and combinations. By using the brute force, the number of possibilities becomes <strong>(n-1)!</strong> .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/598/0*qln6peISSQeDue05.png" /></figure><p><strong>Are We supposed to care ?</strong></p><p>This is one of the millennium challenges with a significant reward for a solution. So, if there is a reward, we should endeavour to solve the challenges. Now, taking everything else into account</p><p>If P=NP :-</p><p>It would be simple to locate answers to search-related issues and evaluate their quality. The algorithmic problems we currently face would all be resolved as a result, and computers would be able to do practically any task.</p><p>Using the Fortnow’s example, if P=NP, then the robotic hand would be capable of doing anything an actual human hand can do.</p><p>Also if we could find the solution to show that P=NP, we could help cure the diseases like cancer and revolutionize society.</p><p>Now if P != NP :-</p><p>Most computer scientists already concur that P=NP, according to online polls. There won’t be any short cuts and a computer’s capacity to solve problems will remain fundamentally and indefinitely constrained if P does not equal NP.</p><p>Even if we established the universally accepted proposition that P does not equal NP, doing so would require fundamentally broadening our understanding of those skills.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/918/0*LqrU7k3hFDcFMxwR.png" /></figure><p><strong>Conclusion:</strong></p><p>We need to create a brand-new framework for creating algorithms in order to effectively solve some difficulties. That system might be based on quantum physics, where NN computations might be carried out concurrently on a single quantum computer and information could theoretically be transmitted immediately.</p><blockquote>I don’t think its going to happen, but 1000 years ago no one thought that you could have sorted a thousand items in one second.</blockquote><p>That’s it for this blog.</p><p>Keep Learning :)</p><p><strong>Team TY_13!</strong></p><h3>Writers :</h3><ul><li><a href="https://medium.com/u/41bcd3825636?source=post_page-----b15a7c868b38--------------------------------">Tanmay Deshmukh</a></li><li><a href="https://medium.com/u/9325131b0a25?source=post_page-----b15a7c868b38--------------------------------">Jay Deshmukh</a></li><li><a href="https://medium.com/u/cb3e726951ee?source=post_page-----b15a7c868b38--------------------------------">Pratik Dhamal</a></li><li>Aditya Bhartiya</li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=38190e5926cf" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Recommendation systems]]></title>
            <link>https://medium.com/@tanmay.deshmukh20/recommendation-systems-b15a7c868b38?source=rss-41bcd3825636------2</link>
            <guid isPermaLink="false">https://medium.com/p/b15a7c868b38</guid>
            <category><![CDATA[recommendation-system]]></category>
            <dc:creator><![CDATA[Tanmay P. Deshmukh]]></dc:creator>
            <pubDate>Wed, 01 Jun 2022 07:10:28 GMT</pubDate>
            <atom:updated>2022-06-29T02:28:24.552Z</atom:updated>
            <content:encoded><![CDATA[<p>System Engineering</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Ha-19k-a_U3BHNKr.png" /></figure><h3>What Is Recommendation System?</h3><p>What Is Recommendation System? A recommendation system could also be a mode of information filtering system that tries to forecast how a user would rate or prefer an item. In layman’s terms, it’s an algorithm that recommends products to consumers supported their interests. as an example, which movie to appear at on Netflix, which product to shop for for on e-commerce, which book to read on Kindle, and so on.</p><p>Companies have spent lots of make the foremost their development during the last decade. In 2009, Netflix gave a development team $1 million for an algorithm that improved the company’s recommendation engine’s accuracy by 10%.</p><h3>Use-Cases Of Recommendation System</h3><p>There are many use-cases of it. Some are</p><p><strong>A.</strong> <strong>Personalized Content: </strong>Helps to boost the on-site experience by creating dynamic recommendations for various styles of audiences like Netflix does.</p><p><strong>B</strong>. <strong>Better Product search experience</strong>: It aids within the categorization of products supported their features.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*0F5Wd7PwQZiL5bL_.png" /></figure><p><strong>What is a good recommendation?</strong></p><ul><li>The one that is personalized (relevant to that user)</li><li>The one that is diverse (includes different user interests)</li><li>The one that doesn’t recommend the same items to users for the second time</li><li>The one that recommends available products</li></ul><h3>TYPES OF RECOMMENDATION SYSTEM</h3><p>There are two main types of recommender systems — personalized and non-personalized.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*MhANydkEoWN-rFWREJYAOg.png" /><figcaption>Picture 1 — Types of recommendation systems</figcaption></figure><h3>PERSONALIZED</h3><p>More thorough analysis of user data, purchases, ratings, and connections to other users is performed through a personalized recommender system. Each user will therefore get unique recommendations.</p><p>The most popular types of personalized recommendation systems are content based and collaborative filtering.</p><h3>1. Content-Based Filtering</h3><p>Content-based recommender systems produce particular recommendations supported objects or user metadata. The user’s purchase history is observed. as an example, If a user has previously read a book by a particular author or purchased a product from a selected brand, for instance, That author or brand is a favorite of the patron, and he or she is probably visiting buy a comparable product within the long term. Assume Jenny enjoys fantasy novels which Walter Jon Williams is her favorite author. If she enjoyed the Aristoi story, she should read Walter Jon Williams’ phantasy novel Angel Station.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/768/1*SfIXiPb9j98ha2-waVzCaA.png" /><figcaption>Picture 2 — Content based recommendation system</figcaption></figure><h4>Advantages</h4><ul><li>Model doesn’t need data of other users since recommendations are specific to a minimum of one user.</li><li>It makes it easier to scale to an oversized number of users.</li><li>The model can capture the precise interests of the user and might recommend items that just some other users have an interest in.</li></ul><h4>Disadvantages</h4><ul><li>Feature representation of things is hand-engineered to some extent, this tech requires many domain knowledge.</li><li>The model can only make recommendations supported the prevailing interest of a user. In other words, the model’s capacity to build on the user’s current interests is restricted.</li></ul><h3>2. Collaborative Filtering</h3><p>Collaborative-based filtering is actually recommending new goods to consumers supported the interests and preferences of other like users. For eg:- after we shop on Amazon it recommends new products saying “Customer who brought this also brought”</p><p>There are two types of collaborative filtering: memory-based and model based.</p><h4>a) Memory based</h4><p>Memory-based algorithms are applied to information with none prior preparation. They’re easy to use, and thus the recommendations that follow are usually easy to speak. Each time, the recommender must make predictions over all of the knowledge, which slows it down.</p><p>Collaborative filtering can be divided into two types: user-based and item-based.</p><ul><li><strong>User based</strong> —“Users who shared your interests loved…” Products are recommended to users supported the actual undeniable fact that they need been purchased / enjoyed by users who are almost rather like the observed user. What does it mean once we state that users are similar? Jenny and Tom, as an example, are huge fans of fantasy novels. When a fresh sci-fi novel comes out and Jenny buys it, since Tom like them furthermore, we’ll recommend the book Jenny bought.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*v4aJZ-lGLdcteIGneR1zYw.png" /><figcaption>Picture 3 — User based collaborative filtering recommender system</figcaption></figure><ul><li><strong>Item based</strong> — “Users who liked this item also liked…” If John, Robert and Jenny highly rated sci-fi books Fahrenheit 451 and thus the machine, as an example gave 5 stars, then when Tom buys the book Fahrenheit 451 then the book The machine is additionally recommended to him because the system identified books as similar supported user ratings.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Oy8-SaGhlZYyEQVWWwxUHA.png" /><figcaption>Picture 4 — Item based collaborative filtering recommender system</figcaption></figure><h4>Advantage</h4><ul><li>It works well even if the data is small.</li><li>This model helps the users to induce a replacement interest in an exceedingly given item but the model might still recommend it because similar users have an interest therein item.</li><li>No need for Domain Knowledge</li></ul><h4>Disadvantage</h4><ul><li>It cannot handle new items because the model doesn’t get trained on the newly added items within the database. This problem is assumed as Cold Start Problem.</li><li>Side Feature Doesn’t have much importance. Here Side features are visiting be actor name or releasing year within the context of movie recommendation.</li></ul><h4>b) Model based</h4><p>These models were developed using machine learning algorithms. A model is formed, and supported it, instead of all data, recommendations are made, which quickens the system’s operation. This approach achieves better scalability. Dimensionality reduction is often utilized during this approach. Matrix factorization is that the foremost well-known example of this method.</p><ul><li><strong>Matrix Factorization</strong>—</li></ul><p>When a user provides feedback, like rating a movie or a book, the info is stored within the type of a matrix, with each row representing a definite user and every column indicating a special object. This matrix will have many empty places because it’s tough for the user to rate each item. this will be often called sparsity. Matrix factorization algorithms are accustomed determine user preferences by identifying a bunch of latent components. Latent Information could even be reported by analyzing user behavior. Features are another term for hidden components.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BnoOk2z_CMmhfVZfk0jw2Q.png" /><figcaption>Picture 5 — Matrix factorization</figcaption></figure><h3>3. Hybrid</h3><p>They represent a mixture of assorted recommenders. the concept is that combining several different recommenders will produce better results than employing one algorithm.</p><h3>NON-PERSONALIZED</h3><p>Non-personalized recommendation systems, like popularity-based recommenders, show consumers the foremost popular goods, rather like the top-10 movies, best-selling books, and most frequently purchased items.</p><h3>CONCLUSION</h3><p>This blog discussed a spread of subjects connected to recommendation engines, like what they’re and also the way they’ll be used. but that, there are several forms of recommendation systems, like content-based filtering and collaborative filtering, with user-based and item-based filtering in collaborative filtering, additionally as instances, advantages and downsides.</p><p>Recommender systems can be used by any business to modify its offers. While putting in place a system are often costly, the advantages of content targeting are undeniable.</p><p>A recommender system is the answer, whether you want to retain visitors on your platform (YouTube) or show them fresh, new offerings (Amazon).</p><p>That’s it for this blog.</p><p>Keep Learning :)</p><p><strong>Team SY_1!</strong></p><h3>Writers :</h3><ul><li><a href="https://medium.com/u/d56508da30d">Apurva Bhalerao</a></li><li><a href="https://medium.com/u/9325131b0a25">Jay Deshmukh</a></li><li><a href="https://medium.com/u/41bcd3825636">Tanmay Deshmukh</a></li><li><a href="https://medium.com/u/cb3e726951ee">Pratik Dhamal</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b15a7c868b38" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Dynamic SQL and Embedded SQL]]></title>
            <link>https://medium.com/@tanmay.deshmukh20/dynamic-sql-and-embedded-sql-2cada45fcc91?source=rss-41bcd3825636------2</link>
            <guid isPermaLink="false">https://medium.com/p/2cada45fcc91</guid>
            <dc:creator><![CDATA[Tanmay P. Deshmukh]]></dc:creator>
            <pubDate>Tue, 31 May 2022 11:42:32 GMT</pubDate>
            <atom:updated>2022-06-30T01:52:10.949Z</atom:updated>
            <content:encoded><![CDATA[<h3>What is SQL?</h3><p>SQL Meaning: It’s a domain-specific programming language. It allows a programmer to figure with data in an application development language. An on-line database is employed to store the data. we’ve on-line database management systems like SQL Server, MySQL, MS Access that employ SQL as a typical database language to manage this data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/485/1*-F0jSAqPYLhScsQi0Y3pcA.jpeg" /></figure><p><strong>How is SQL Statement Processed?</strong></p><p>It’s important to understand how the Structured Query Language statements are processed before moving on. The following steps are carried out by the DBMS, as illustrated in the diagram:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/959/1*5mBcNgPyexZEsCkgTZrYTA.png" /></figure><h2>What is an embedded and dynamic SQL?</h2><p>There are two types of SQL queries: embedded or static SQL and dynamic SQL. As a result, we’ll be learning about these two forms of SQL statements in this blog.</p><h3>Embedded / Static SQL</h3><p>Embedded SQL, often called static SQL, refers to SQL statements that are fixed in an application and can’t be modified at runtime. Only at compile time these statements get compiled. The advantage of using this statement is that you simply know the course of execution of statements because you have got the SQL statements with you, which allows you to optimize your SQL query and execute it as quickly as possible. the strategy of retrieving the information is predefined, and static SQL queries are commonly employed on uniformly distributed databases.</p><p>Because these statements are hardcoded within the programme, you ought to utilize the Dynamic SQL statement if you would like to construct an application that needs dynamic or run-time SQL statements.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/1*sG7hGyDUPC8WVZRpV2taVQ.jpeg" /></figure><h3>Dynamic SQL</h3><p>SQL statements that are produced or executed dynamically are called dynamic SQL statements. In some applications, users can run their own queries. At run-time, these assertions are compiled. When there’s a non-uniformity within the data contained within the database, these SQL statements are employed. it’s more adaptable than static SQL and might be utilized in a very type of applications.<br> <br> The system will only understand how to access the database at run-time because the compilation is completed at run-time. As a result, no proper execution and optimization planning might be done previously. The system’s performance will suffer as a result of this. Also, if you get the database query from the user at run-time, there’s an opportunity the user would type in some incorrect queries, which is admittedly risky because you’re managing plenty of information.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uoOvw_sAzS3E9jD8z-kt6Q.jpeg" /></figure><h3>Structure of Embedded SQL</h3><p>The structure of embedded SQL outlines the step-by-step procedure of connecting to a database and running code within the database employing a problem-oriented language.</p><h3>Connection to DB</h3><p>The first step in developing a question during a high-quality language is to write down a question. the primary database connection we’ve attempted must be established. The CONNECT keyword may be accustomed do that. It should, however, be preceded with ‘EXEC SQL’ to specify the SQL statement.</p><pre>EXEC SQL CONNECT db_name;<br>EXEC SQL CONNECT HR_USER; //connects to DB HR_USER</pre><h3>Declaration Section</h3><p>We can make database transactions once the connection has been established via database. Because the worth and adaptability of the host language are factors during this database procurement and in step with their values queries are written and executed. Similarly, the results of the database query are going to be delivered to the host language, which is able to be captured independently. As a result, we’ll need a variable declaration to transfer the worth to the question and retrieve the values. In host language, there are two forms of variables.</p><ul><li><strong><em>Host variable</em></strong>: These are modifications to the host language that are wont to convey the worth to the query and quote the values returned by the query. we must always employ host language variables since SQL relies on the host language, and this flexibility is mentioned as host flexibility. These hosting conditions, however, should be stated within the SQL area or SQL code. This necessitates the producer’s ability to tell apart between conventional C variables. As a result, the host variables should be announced between the BEGIN DECLARE and END DECLARE categories. Also, within EXEC SQL and ‘;’ , these announced blocks should be locked.</li></ul><pre>EXEC SQL BEGIN DECLARE SECTION;<br>int STD_ID;<br>char STD_NAME <strong>[</strong>15<strong>]</strong>;<br>char ADDRESS<strong>[</strong>20<strong>]</strong>;<br>EXEC SQL END DECLARE SECTION;</pre><ul><li>The variables are written within the SQL start and finish blocks, however the variables are rejected using C-code. Declares variables without using SQL code. Why? this can be because of the very fact that the handling conditions don’t seem to be flexible — changeable C language. As a result, we won’t be ready to publish them using SQL syntax. Int, char, long, float, double, pointer, array, string, structures, and then on are all supported by the host language.</li><li>To indicate that the host variable could be a dynamic host, it should be preceded by a colon — ‘:’ within the SQL query. As a result, the host value for the host and integration is replaced when the front-end compiler produces the SQL code.</li></ul><pre>EXEC SQL SELECT * FROM STUDENT WHERE STUDENT_ID =:STD_ID;</pre><ul><li>In the code above: When the preceding producer adds it, STD ID are replaced by its value within the code above.</li><li>Assume we’ve no idea what the information for the host variant or the other form of data within the oracle should be for some columns. therein scenario, we are able to tell the compiler to download the column type data and provides it a replacement host. The ‘BASED ON’ clause is employed to try to to this. However, the format of the announcement are within the host language.</li></ul><pre>EXEC SQL BEGIN DECLARE SECTION;<br>BASED ON STUDENT.STD_ID sid;<br>BASED ON STUDENT.STD_NAME sname;<br>BASED ON STUDENT.ADDRESS saddress;<br>EXEC SQL END DECLARE SECTION;</pre><ul><li><strong><em>Indicator Variable</em>:</strong> These variables are also manageable, but they are only two bytes long. These variables are used to INSTALL / UPDATE any NULL values in the tables or to take NULL values returned by questions. It catches any NULL value returned in any column when used in a SELECT query. It sets the column value to NULL when used with INSERT or UPDATE, even while the host variables have a value. If each host variable in the code must capture NULL values, we must define the variable variables in each host variable. This indicator variable is set directly after the host variance in question, or between the host and index variance.</li></ul><pre>EXEC SQL SELECT STD_NAME INTO :SNAME :IND_SNAME<br>      FROM STUDENT WHERE STUDENT_ID =:STD_ID;</pre><h3>Execution Section</h3><pre>EXEC SQL SELECT <strong>*</strong> FROM STUDENT WHERE STUDENT_ID =:STD_ID;<br>EXEC SQL SELECT STD_NAME INTO :SNAME :IND_SNAME<br>FROM STUDENT WHERE STUDENT_ID =:STD_ID;<br>INSERT INTO STUDENT <strong>(</strong>STD_ID, STD_NAME<strong>)<br></strong>VALUES <strong>(</strong>:SID, :SNAME<strong>)</strong>;<br>UPDATE STUDENT<br>SET ADDRESS = :STD_ADDR<br>WHERE STD_ID = :SID;</pre><p>Simple SQL queries/statements are demonstrated within the examples above. We can, nevertheless, have puzzling questions.<br> All queries during this integrated SQL are supported host variance values and are static. That is, within the SELECT question example above, it always draws the scholar ID information entered. Assume, however, that a user substitutes a student ID for a student ID. The query to download data supported the name isn’t changed by these SQLs. Consider the subsequent scenario: the question is predicated on the student’s name and address. The code will then alter the query to permit the student’s name and address to be wont to download information. this means that the queries are set in stone and can’t be changed supported user input. Static SQLs are the name for this manner of SQL.</p><h3>Structure of Dynamic SQL</h3><p>We have three clauses in dynamic SQL since the query must be prepared at runtime. These are mostly accustomed create queries, which are subsequently executed at runtime.</p><h3>PREPARE</h3><p>Because dynamic SQL generates an issue during execution, we must first record all of the user’s input. The character unit variable are wont to store it. A dynamic character unit is added to the input and SQL keywords looking on the user’s input. The SQL queries are created from a succession of SQL-like statements. The PREPARE statement is employed to try and do this.<br> <br> Small captions from a dynamic SQL, for instance, are seen below. Here, sql_stmt could be a string of characters that captures user input and SQL commands. However, because it’s still a unit number of characters, it’ll not be deemed a SQL query. It must be changed into a legitimate SQL query using the PREPARE statement within the last line. during this case, sql query may be a character unit that stores the series as a SQL query.</p><pre>sql_stmt = &quot;SELECT  STD_ID FROM STUDENT &quot;;<br>    if <strong>(</strong>strcmp<strong>(</strong>STD_NAME, &#39;&#39;<strong>)</strong> != 0<strong>){<br></strong> sql_stmt = sql_stmt <strong>||</strong> &quot; WHERE STD_NAME = :STD_NAME&quot;;<br><strong>    }<br></strong>    else if <strong>(</strong>CLASS_ID <strong>&gt;</strong> 0<strong>){<br></strong>       sql_stmt = sql_stmt <strong>||</strong> &quot; WHERE  CLASS_ID = :CLASS_ID&quot;;<br><strong>    }<br></strong>    if <strong>(</strong>strcmp<strong>(</strong>STD_NAME, &#39;&#39;<strong>)</strong> !=0 <strong>&amp;&amp;</strong> CLASS_ID <strong>&gt;</strong>0<strong>)<br></strong>       sql_stmt = sql_stmt <strong>||</strong> &quot;  AND CLASS_ID = :CLASS_ID&quot;;<br>    EXEC SQL  PREPARE sql_query FROM :sql_stmt;</pre><h3>EXECUTE</h3><p>Using this statement we can compile and execute the SQL statements prepared in the database.</p><pre>EXEC SQL EXECUTE sql_query;</pre><h3>EXECUTE IMMEDIATE</h3><p>This statement is used to prepare SQL statements as well as execute the SQL statements in DB. It performs PREPARE and EXECUTE tasks in a single line.</p><pre>EXEC SQL EXECUTE IMMEDIATE :sql_stmt;</pre><h3>Let’s Compare both Embedded and Dynamic SQL</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/1*bvbgf5FiPxqnjzs7qHe1bw.jpeg" /></figure><h3>Advantages of Embedded SQL</h3><ul><li><strong>Small footprint database</strong>: Because embedded SQL integrates the UltraLite database engine directly into each application, the footprint is usually but when utilizing the UltraLite component, especially for smaller numbers of tables. This benefit is lost when there are an outsized number of tables.</li><li><strong>High Performance</strong>: Embedded SQL is a wonderful alternative for developing high-performance applications because it combines the high performance of C and C++ applications with the event of produced code, which incorporates data access programme.</li><li><strong>Extensive SQL:</strong> Support With embedded SQL you’ll be able to use different SQL for your applications.</li></ul><h3>Advantages of Dynamic SQL</h3><ul><li><strong>Prediction Optimization:</strong> the most advantage of flexible SQL is that the applications created in each query request are tailored to the descriptions now in use. the basic issue with independent SQL systems that aren’t maintained is that extra predictions confuse the query editor, resulting in inefficient programmes. This problem is solved in Dynamic SQL by not adding anything to the question.</li><li><strong>Single Query Plan Caching: </strong>for every process request, each database includes a single cached query system with additional ad-program time (this may be checked using the view sys.dm exec cached plans). this suggests that whenever a replacement conflict is transferred to a stored course, mergers occur, killing performance. Because flexible query isn’t a parameter, redundant query programmes are created for various parameters</li></ul><h3>Disadvantages of Embedded SQL</h3><ul><li><strong>C or C ++ information required</strong>: You might want to use one of the UltraLite sites if you’re not comfortable with the C or C++ systems. A few prominent programming languages and tools are supported by UltraLite components.</li><li><strong>Complex development model:</strong> The integrated SQL development process is made more complicated by the usage of a website to manage the UltraLite web schema, as well as the necessity to process your source code files. UltraLite components have a relatively straightforward update procedure.</li><li><strong>SQL must be specified during design</strong>: Only SQL statements defined during the integration process can be used in your app. SQL statements can be used in a variety of ways with UltraLite components.</li></ul><h3>Disadvantages of Dynamic SQL</h3><ul><li><strong>Speed</strong>: Dynamic SQL tends to run slower than static SQL, as the SQL Server must produce a regular application during operation.</li><li><strong>Permissions</strong>: All accessible objects, like as tables and views, must have direct access permissions in Dynamic SQL. Users usually only have access to stored processes that relate to those tables, not to the tables themselves. The default SQL will not function in this scenario.</li><li><strong>Syntax</strong>: One distinct advantage of developing stored T-SQL procedures is that a syntax check is performed automatically. A minor syntax issue in variable SQL may not be detected till execution. Even if you double-check your code, there may be some queries or versions of the query that are only used in exceptional circumstances and are not included in your test programme.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aauEiJtePQIpxhIWyM0Zwg.jpeg" /></figure><h3>Conclusion</h3><p>You can design a flexible application with dynamic SQL, but make sure your users are experts who have been trained properly. Otherwise, you should use static or embedded SQL. This is more efficient than using dynamic SQL.</p><p>That’s it for this blog.</p><p>Keep Learning :)</p><p><strong>Team SY_1!</strong></p><h3>Writers :</h3><ul><li><a href="https://medium.com/u/d56508da30d">Apurva Bhalerao</a></li><li><a href="https://medium.com/u/9325131b0a25">Jay Deshmukh</a></li><li><a href="https://medium.com/u/41bcd3825636">Tanmay Deshmukh</a></li><li><a href="https://medium.com/u/cb3e726951ee">Pratik Dhamal</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2cada45fcc91" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>