<?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 KarpeOmkar on Medium]]></title>
        <description><![CDATA[Stories by KarpeOmkar on Medium]]></description>
        <link>https://medium.com/@omkarbkarpe02?source=rss-1d68dbaf8b3f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*ut643AswcJrbyrZPg6HM4g.jpeg</url>
            <title>Stories by KarpeOmkar on Medium</title>
            <link>https://medium.com/@omkarbkarpe02?source=rss-1d68dbaf8b3f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 24 May 2026 02:29:34 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@omkarbkarpe02/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[Machine learning in E-commerce]]></title>
            <link>https://medium.com/@omkarbkarpe02/machine-learning-in-e-commerce-363d098d9fa5?source=rss-1d68dbaf8b3f------2</link>
            <guid isPermaLink="false">https://medium.com/p/363d098d9fa5</guid>
            <dc:creator><![CDATA[KarpeOmkar]]></dc:creator>
            <pubDate>Tue, 21 May 2024 03:27:16 GMT</pubDate>
            <atom:updated>2024-05-21T03:27:16.947Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Introduction</strong><br>E-commerce has revolutionized the way we shop, and machine learning (ML) is at the forefront of this transformation. By leveraging ML algorithms, e-commerce platforms can enhance user experience, streamline operations, and boost sales. In this blog, we’ll explore the various ways machine learning is being utilized in e-commerce and the benefits it brings to both businesses and consumers.</p><p><strong>1. Personalized Recommendations</strong></p><p>One of the most notable applications of machine learning in e-commerce is personalized recommendations. By analyzing user behavior, purchase history, and browsing patterns, ML algorithms can suggest products that are tailored to individual preferences. This not only enhances the shopping experience but also increases the likelihood of conversion.</p><p>Case Study: Amazon’s recommendation engine, which contributes significantly to its sales by suggesting relevant products to users based on their browsing and purchasing history.</p><p><strong>2. Dynamic Pricing</strong></p><p>Dynamic pricing involves adjusting the prices of products in real-time based on demand, supply, competition, and other factors. Machine learning models analyze vast amounts of data to determine the optimal price point, maximizing profits while remaining competitive.</p><p>Example:Airlines and hotel booking sites often use dynamic pricing to offer competitive rates that reflect current market conditions.</p><p><strong>3. Inventory Management</strong></p><p>Efficient inventory management is crucial for e-commerce businesses. Machine learning can predict demand trends, helping retailers maintain optimal inventory levels. This reduces the risk of overstocking or stockouts, ensuring that popular items are always available while minimizing storage costs.</p><p>Case Study: Zara uses ML to predict fashion trends and manage inventory, ensuring that its stores are stocked with the latest trends.</p><p><strong>4. Customer Segmentation</strong></p><p>Machine learning enables e-commerce platforms to segment their customer base more effectively. By analyzing data such as purchase history, demographics, and browsing behavior, ML algorithms can identify distinct customer segments and tailor marketing strategies accordingly.</p><p>Example: Targeted email campaigns that cater to different customer segments, increasing engagement and conversion rates.</p><p><strong>5. Fraud Detection and Prevention</strong></p><p>E-commerce platforms are vulnerable to fraudulent activities. Machine learning models can detect unusual patterns and behaviors indicative of fraud, such as unusual purchase volumes or atypical login locations. This allows businesses to take proactive measures to prevent fraud and protect their customers.</p><p>Example: PayPal uses ML algorithms to monitor transactions in real-time and flag suspicious activities, reducing the incidence of fraud.</p><p><strong>6. Customer Service Automation</strong></p><p>Machine learning-powered chatbots and virtual assistants are becoming increasingly common in e-commerce. These tools can handle a wide range of customer inquiries, from order status to product information, providing quick and accurate responses while freeing up human agents for more complex issues.</p><p>Case Study: Sephora’s virtual assistant, which helps customers find products, offers makeup tutorials, and provides personalized beauty advice.</p><p><strong>7. Image Recognition</strong></p><p>Image recognition technology, powered by machine learning, allows customers to search for products using images. This is particularly useful in fashion and home decor, where customers may want to find items that match a particular style or design they have seen elsewhere.</p><p>Example: ASOS’s visual search feature, which lets users upload photos to find similar products on the platform.</p><p><strong>8. Enhanced Search Functionality</strong></p><p>Machine learning improves the accuracy and relevance of search results on e-commerce platforms. By understanding user intent and context, ML algorithms can deliver more accurate search results, enhancing the overall shopping experience.</p><p>Case Study: eBay’s use of natural language processing (NLP) to improve search results and help users find exactly what they’re looking for.</p><p><strong>Conclusion</strong></p><p>Machine learning is transforming the e-commerce landscape, offering numerous benefits from personalized shopping experiences to efficient inventory management and robust fraud detection. As ML technology continues to evolve, its impact on e-commerce will only grow, paving the way for more innovations and improved customer experiences. Embracing machine learning can provide e-commerce businesses with a significant competitive edge, driving growth and customer satisfaction.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=363d098d9fa5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Impact of AI on Marketing]]></title>
            <link>https://medium.com/@omkarbkarpe02/artificial-intelligence-ai-has-become-an-non-separable-part-of-our-lives-and-its-impact-can-be-3808c85da213?source=rss-1d68dbaf8b3f------2</link>
            <guid isPermaLink="false">https://medium.com/p/3808c85da213</guid>
            <category><![CDATA[marketing]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[KarpeOmkar]]></dc:creator>
            <pubDate>Sun, 16 Apr 2023 10:57:56 GMT</pubDate>
            <atom:updated>2023-05-02T05:32:52.827Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/964/1*-rLfvpZLuw5CjLU0cJlLqg.png" /></figure><p>Artificial intelligence (AI) has become an non-separable part of our lives and its impact can be seen across all industries, including marketing and advertising. The use of artificial intelligence in these areas has increased over the past few years, and the benefits are becoming more apparent. From automating tasks to delivering personalized experiences to customers, AI is proving to be gamechanger in the world of marketing and advertising.</p><h3>What Is Artificial Intelligence in Marketing?</h3><p>AI Marketing leverages user data and artificial intelligence concepts such as machine learning to predict the customer’s next step and improve the customer journey.<br> The chart below shows how marketers are integrating AI and machine learning into every step of the customer’s life.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*6hEeSOkGJuXtk2ny8ZVa5Q.png" /></figure><p>If you haven’t thought about the power of AI in business yet, now is the time to learn more. We’ve compiled some great AI marketing examples to get you started.</p><ol><li><strong>Amazon</strong> — When shopping on Amazon, you may see options such as “recommended for you”, “Items you liked” or “Customers also bought”. This is one of the most popular AI-powered strategies Amazon uses to drive sales, powered by Amazon’s powerful recommendation engine. Amazon leverages product-to-product integration to power its recommendation engine. Unlike content-based filtering, collaborative filtering uses other users’ information to generate recommendations.</li><li><strong>ClickUp Increases Blog Traffic by 85% Using NLP AI — </strong>Project Management ClickUp Uses Surfer SEO’s Natural Language Processing Artificial Intelligence Tools and Machine Learning To:<br> • Identify content optimization methods;<br> • Understand what elements to include in the product (and density);<br> • Get an idea of ​​the best article structure, from the number of images included to the length of subheadings.</li><li><strong>Starbucks uses predictive analytics to deliver personalized recommendations</strong> —<strong> </strong>Starbucks is an example of a brand that uses its loyalty card and mobile app to collect and identify customers. Records purchases, including where and when they were purchased. Starbucks uses predictive analytics to provide personalized messages to customers.<br>It includes suggestions and special offers to increase the customer’s average order value when the user visits the local store.</li><li><strong>Nike — </strong>Last year Nike launched a new system that allowed customers to <a href="https://www.businessinsider.com/nikes-new-tech-creates-custom-sneakers-in-under-2-hours-2017-9/?IR=T">design their own sneakers in store</a>. Not only is this a great gimmick to drive sales, but it also collects a huge amount of useful data that machine learning algorithms can use to design future products and deliver personalized recommendations and marketing messages.</li><li><strong>eBay Uses Brand Language Optimization to Drive Email Marketing Success — T</strong>he company has been working with the artificial intelligence-powered customer experience platform <a href="https://f.hubspotusercontent20.net/hubfs/4094824/ebay_CaseStudy_Updated.pdf">Phrasee</a> to enhance its marketing copy, focusing on email. Which uses a combination of natural language generation and deep learning to create copy at scale while dynamically optimizing performance.</li></ol><p><strong>How AI is changing marketing and advertising..?</strong></p><p>Artificial Intelligence is already changing marketing and advertising, and its widespread use is changing the way businesses interact with consumers. One of the most visible areas of AI impact is personalization, which involves tailoring advertising and advertising campaigns to consumers’ interests, preferences, and behaviors.</p><p>Artificial intelligence technologies such as machine learning algorithms and natural language processing (NLP) can help businesses analyze large volumes of customer data and generate better insights for targeting and messaging.<br>Another area where artificial intelligence comes into play is the use of chatbots, which are computers that can attempt to chat with a human user.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*VIQRYkcvrL0hDQIyYZ08ZQ.png" /><figcaption>Use of Chatbots by various tech giants</figcaption></figure><p>Predictive analytics is also gaining attention in marketing and advertising. This includes using machine learning algorithms to analyze customer data and predict future behavior such as which products they will buy or which channels they will like the most.</p><p><strong>Potential drawbacks of AI in marketing and advertising</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/853/0*wNk3Cn5VFbUKBoGV" /></figure><p>One of the biggest concerns is <strong>privacy</strong>. As AI gathers more and more information about customers and their behavior, this information can be misused or fall into the wrong hands. Data or algorithms used in AI can also be biased, leading to discrimination.<br>To mitigate these risks, companies must take steps to ensure their AI systems are transparent, ethical and secure.<br>This includes being transparent about what data is collected and how it is used, and giving consumers control over their data. Companies should regularly review their AI systems for bias and take steps to resolve any issues that arise.<br>Another drawback of having AI in marketing and advertising sector is the <strong>risk of over-dependance</strong> on technology. While AI can help companies multitask and make better decisions, it should not replace human thinking and creativity. Companies need to strike a balance between artificial intelligence and human intelligence techniques to achieve the best results.</p><p><strong>The Future of AI in marketing and advertising</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*Y45kc72oM8x5anip2u-MsQ.jpeg" /></figure><p>As artificial intelligence (AI) continues to evolve and evolve, its role in marketing and advertising will only expand. In the future, AI will play a larger role in these areas, providing new and innovative ways for companies to connect with customers and build brands.<br>One difference that will be important is voice search. As more users use Amazon’s voice-activated assistants like Alexa and Google Home, companies must optimize their content and ads for voice search queries. This will require a different approach to SEO and keywords, with a focus on creating content that is easy to understand and answer with voice.<br> Another area where AI can have a significant impact is augmented reality (AR). AR technology is already being used in advertising and marketing, allowing consumers to try on clothes or see how the furniture will look in their home. As AI becomes more effective, AR experiences will likely become more personalized and interactive, providing new ways for companies to engage with customers.</p><p>The AI is also expected to continue to improve targeting and identity. With its ability to analyze large amounts of data and make predictions based on that data, AI can help companies better understand their customers and deliver personalized content and experiences the way they want and like it.<br>However, there are risks and challenges which come along new oppurtunities . Companies need to be vigilant to make sure their use of AI is fair and transparent, and to protect consumer privacy. Additionally, AI can impact businesses and operations as it continues to become more automated and decision-making processes.<br>Overall, the future of AI in marketing and advertising is exciting and full of potential. By being aware of events and technologies, companies can use artificial intelligence to create effective and engaging campaigns while being aware of the risks and opportunities posed by this new technology.</p><p><strong>Conclusion</strong></p><p>As a result, increased efforts in marketing and advertising have a significant impact on the business. While this technology has some downsides and risks, the benefits are clear, including improved performance, improved customer experience, and better campaigns. As AI continues to evolve and evolve, it will become an even more important tool for marketers and advertisers, helping them prioritize and reach their target customers more effectively. Companies that embrace AI and use it responsibly and ethically are reaping the benefits, while companies that ignore the technology may find themselves lagging behind their peers. It is clear that artificial intelligence is permanent and its impact on business and advertising could be significant in the years to come.</p><h3>References</h3><p>[1] Ameen, N., Tarhini, A., Reppel, A., &amp; Anand, A. (2021). Customer experiences in the age of artificial intelligence. Computers in Human Behavior, 114, 106548.</p><p>[2] Brynjolfsson, E., &amp; Mcafee, A. N. D. R. E. W. (2017). Artificial intelligence, for real. Harvard business review, 1, 1–31.</p><p>[3] Brynjolfsson, E., Rock, D., &amp; Syverson, C. (2018). Artificial intelligence and the modern productivity paradox: A clash of expectations and statistics. In The economics of artificial intelligence: An agenda (pp. 23–57). University of Chicago Press.</p><p>[4] Dwivedi, Y. K., &amp; Wang, Y. (2022). Guest editorial: Artificial intelligence for B2B marketing: Challenges and opportunities. Industrial Marketing Management, 105, 109–113.</p><p>[5] <a href="https://www.analyticsvidhya.com/blog/2023/03/ai-marketing-strategies/">https://www.analyticsvidhya.com/blog/2023/03/ai-marketing-strategies/</a></p><h3><strong>Authors</strong></h3><ol><li>Omkar Karpe</li><li>Sakshi Ozarde</li><li>Ganesh Karode</li><li>Rutika Masane</li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3808c85da213" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Scrum Artifacts]]></title>
            <link>https://medium.com/@omkarbkarpe02/scrum-artifacts-55060719695e?source=rss-1d68dbaf8b3f------2</link>
            <guid isPermaLink="false">https://medium.com/p/55060719695e</guid>
            <category><![CDATA[scrum]]></category>
            <category><![CDATA[sprint]]></category>
            <category><![CDATA[backlog]]></category>
            <dc:creator><![CDATA[KarpeOmkar]]></dc:creator>
            <pubDate>Mon, 20 Jun 2022 09:35:51 GMT</pubDate>
            <atom:updated>2022-06-20T09:35:51.159Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Scrum Artifacts</strong></h3><p>Agile scrum artifacts are information that a scrum team and stakeholders use to detail the product being developed, actions to produce it, and the actions performed during the project. The main agile scrum artifacts are product backlog, sprint backlog, and increments.</p><h3><strong>The Three Scrum Artifacts</strong></h3><p>Scrum uses three artifacts to help manage work. And these are following:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/840/0*GJTuPsCRRwSfFMXe" /></figure><p><strong>Product Backlog — </strong>The product backlog is an ordered list of everything that is known to be needed in a product based on the product goal. It is constantly evolving and is never complete.</p><p><strong>Sprint Backlog — </strong>The sprint backlog is a list of everything that the team commits to achieve in a given sprint. Once created, no one can add to the sprint backlog except the development team.</p><p><strong>Potentially Releasable Product Increment — </strong>At the end of every sprint, the team delivers a product increment that is potentially releasable, meaning that it meets their agreed-upon definition of done. (An example might be fully tested and fully approved.)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/743/0*TnAmhBMbvVbVSIjC" /></figure><h3><strong>Product Vision</strong></h3><p>A Scrum project mostly starts with a vision of the product or system to be developed. The product vision in Scrum is a brief statement of the desired future state that would be achieved by developing and deploying a product. A properly envisioned project provides a definitive path that can best fulfill the project’s objectives or goals. It also provides a common understanding of the direction they want to move towards. Besides that, the Product vision also supports the <a href="https://www.visual-paradigm.com/scrum/what-is-project-owner-role-in-scrum/">Product Owner</a> in prioritizing what features to build first, in what order, and what not to build for the Product.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/500/0*myiUFCOZPXEBZJnq" /></figure><h3><strong>Sprint Goal</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/275/0*W3-RaPf20_0Wu3-6" /></figure><p>Sprint goal is a high-level summary of the goal the product owner would like to accomplish during a sprint, frequently elaborated through a specific set of product backlog items. A sprint goal is a short, one- or two-sentence, description of what the team plans to achieve during the sprint. It is written collaboratively by the team and the product owner.</p><h3><strong>Backlog</strong></h3><p>A well-prioritized agile backlog not only makes release and iteration planning easier, it broadcasts all the things your team intends to spend time on — including internal work that the customer will never notice. This helps set expectations with stakeholders and other teams, especially when they bring additional work to you, and makes engineering time a fixed asset.</p><p><strong>Product Backlog</strong></p><p>A product backlog is a prioritized list of work for the development team that is derived from the roadmap and its requirements. The most important items are shown at the top of the product backlog so the team knows what to deliver first. The development team doesn’t work through the backlog at the product owner’s pace and the product owner isn’t pushing work to the development team. Instead, the development team pulls work from the product backlog as there is capacity for it, either continually (kanban) or by iteration (scrum).</p><p><strong>Sprint Backlog</strong></p><p>The Sprint Backlog is a plan by and for the Developers. It is a highly visible, real-time picture of the work that the Developers plan to accomplish during the Sprint in order to achieve the Sprint Goal. Consequently, the Sprint Backlog is updated throughout the Sprint as more is learned. It should have enough detail that they can inspect their progress in the Daily Scrum.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/803/0*Bnu6X7kt4Jw7WWd2" /></figure><p><strong>Components of Sprint Backlog</strong></p><ul><li><em>User story: features written from the perspective of the customer.</em></li><li><em>Task name: name of each sprint task.</em></li><li><em>Task description: brief description of each sprint task.</em></li><li><em>Task prioritization: priority of each task relative to each other</em></li><li><em>Sprint burndown chart: graph of work left to do vs time to complete it.</em></li><li><em>Daily time allocation: amount of time it takes to complete each task.</em></li></ul><h3><strong>Burndown Chart</strong></h3><p><strong>What is a Burndown Chart?</strong></p><p>During sprint meetings, teams determine the work breakdown of the project and predict the time in which each task can be completed. From this task breakdown, the plots of the burndown chart can be created.Once created, a line is shown to reflect the ideal number of effort hours needed to complete the project. As the project progresses, teams can use the burndown chart to:</p><ul><li><em>Determine the amount of work done in each iteration</em></li><li><em>Show the work completed</em></li><li><em>Visualize the remaining work</em></li><li><em>Predict when a project will be finished</em></li></ul><p>A burndown chart in software development shows the progress of ‘burning down’ the pile of remaining work.</p><p>In short, a burndown chart shows how much work remains to be done (y-axis) at any given day since work started (x-axis) and until the work is complete.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*D_A0zWcd5sL5vCjB" /></figure><p><strong><em>Author:</em></strong></p><p><strong><em>Rohit Jadhav</em></strong></p><p><strong><em>Omkar Karpe</em></strong></p><p><strong><em>Ganesh Karode</em></strong></p><p><strong><em>Sushil Kandhare</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=55060719695e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Microsoft SQL Server]]></title>
            <link>https://medium.com/@omkarbkarpe02/microsoft-sql-server-a8839a6addac?source=rss-1d68dbaf8b3f------2</link>
            <guid isPermaLink="false">https://medium.com/p/a8839a6addac</guid>
            <category><![CDATA[microsoft-sql-server]]></category>
            <dc:creator><![CDATA[KarpeOmkar]]></dc:creator>
            <pubDate>Mon, 06 Jun 2022 13:19:42 GMT</pubDate>
            <atom:updated>2022-06-06T13:23:20.350Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jGpRUuBdWJBEsLWi" /></figure><p><strong>MS SQL Server History</strong></p><p><em>MS SQL Server History started with the first product; SQL Server 1.0. It was a 16-bit widescreen server for OS / 2 in 1989. The history of Microsoft SQL Server continues even today.</em></p><p><strong>In 1987, Microsoft partnered with Sybase Solutions to develop a website management system that could compete with existing giants such as IBM and Oracle.</strong></p><p>It was determined that Sybase would have all the commercial rights and benefits derived from the Product version of the Non-Microsoft forum while Microsoft will have exclusive copyright to the Web site developed by Microsoft Platforms.</p><p>So the first product of the website server was released in 1989. Later, Sybase sold all the rights to Microsoft and now the brand name has been changed to MS SQL Server. To date, about 15 versions of this product have been released.</p><p><strong>From these 15 here are the versions that are still supported and can be utilized by you:</strong></p><p>1. <em>MS SQL Server 2012</em></p><p>2. <em>MS SQL Server 2016</em></p><p>3. <em>Azure SQL Database(latest version)</em></p><p>4. <em>MS SQL Server 2017 (latest version)</em></p><p>5. <em>And, MS SQL Server RC 2019 (preview version)</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/807/1*pw8rPKYLdzc6oMQoTLxPdw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/651/1*4tR4VzauKzOkHKw1H1-M5A.png" /></figure><p><strong>Introduction:</strong></p><p>In today’s world, for data to be useful, it needs to be organized, efficient, timely and accurate. Almost all information sites provide reporting functionality as a closely related aspect. This project focuses on producing web-based reports using MS SQL Server and MySQL. This case study will help to acquire and improve information about Web-based reporting on websites.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/570/0*_oZuqc1r1t1Wpgaq" /></figure><p>Microsoft provides a server-based reporting platform to generate comprehensive reports using a variety of data sources.</p><p><strong><em>SQL Server is an affiliate database management program, or RDBMS, developed and marketed by Microsoft.</em></strong></p><p>SQL Server has been operating exclusively for Windows environments for over 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 was usually available in October 2016 running on both Windows and Linux.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/721/0*SVt47juBBCq5FyiI" /></figure><p>Microsoft SQL Server is a market-leading business solution that is used by a large number and variety of applications where their data is stored and stored. Microsoft SQL Server is an incredibly powerful, scalable and robust solution, yet its durability often leads customers to the wrong idea of ​​security.</p><p><strong>Uses of the MS SQL:</strong></p><p>● To create databases.</p><p>● To maintain databases.</p><p>● To analyze the data through SQL Server Analysis Services (SSAS).</p><p>● To generate reports through SQL Server Reporting Services (SSRS).</p><p>● To carry out ETL operations through SQL Server Integration Services (SSIS).</p><h3>SQL Server Components</h3><p>The SQL server operates in a client server configuration, which is why it supports two types of components − (a) Workstation and (b) Server.</p><p>● Workstation components are installed on all SQL Server devices / machines. These are just interactive areas for Server components. Example: SSMS, SSCM, Profiler, BIDS, SQLEM etc.</p><p>● Server components are installed on the central server. These are services. Example: SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL browser, SQL Server for full text search etc.</p><p><strong>Sql server Architecture :</strong></p><p><strong>Diagram:</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1001/0*G2eDuk5u7czuE1mj" /></figure><p><strong>SQL Server consists of two main components:</strong></p><ol><li>Database Engine</li><li>SQLOS</li></ol><h3>Database Engine</h3><p>The core component of SQL Server is Database Engine. Database Engine contains a related search engine and a search engine that retains web files, pages, pages, indexes, etc. Website features such as saved processes, views, and triggers are also created and used by the Web Engine.</p><h4>1)Relational Engine</h4><p>Relational Engine contains components that determine the best way to use the query. Communication engine is also known as query processor.</p><p>The related engine requests data from the backup engine based on the input query and analyzes the results.</p><p>Other related engine functions include query processing, memory management, thread and task management, bath management, and distributed queries.</p><h4>2)Storage Engine</h4><p>The storage engine handles the storage and retrieval of data from storage systems such as disks and SANs.</p><h3>SQLOS</h3><p>Below the engine associated with the last engine is the SQL Server Operating System or SQLOS. SQLOS provides many operating system resources such as memory and I / O management. Other services include separate administration and synchronization services.</p><h3>Advantages of Instances</h3><p>● To install different versions in one machine.</p><p>● To reduce cost.</p><p>● To maintain production, development, and test environments separately.</p><p>● To reduce temporary database problems.</p><h3>Pros of Microsoft SQL Server:</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/973/0*xa_heTdxIV2si4Yz" /></figure><h3>1. Increases data security</h3><p>One of the main goals of Microsoft SQL Server is to ensure the security of your site, especially through the Microsoft SQL Server website management service. This software allows you to work with a table structure that integrates tasks and data elements, helping to protect the data you own. With customer information and other sensitive information, site security and integrity are required</p><h3>2. Optimized data storage</h3><p>With Microsoft SQL Server, you do not have to have another data storage on the same website if you are using a different device. This allows you to manage data easily and efficiently with problem-solving and minimal maintenance. As a result, you can save time and work on other important aspects of your business.</p><h3>3. Data recovery support</h3><p>In the event of a power outage or server shutdown, the data may be corrupted, which poses a serious problem for businesses with little or no backup. The Microsoft SQL server eliminates the risk of data loss by having data recovery features. As a result, you will have more peace of mind knowing that your data is protected by caching, log files, and common backups, no matter what may happen to your server.</p><h3>The cons of Microsoft SQL Server:</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/0*ZLKkG9Qs4Tngnlsc" /></figure><h3>1. Restricted compatibility</h3><p>Making additional investments in Microsoft software may be needed if your business uses little to no Microsoft infrastructure. These extra commitments might also cost your company more, but they will allow you to use Microsoft SQL Server on your platform.</p><h3><strong>2.Cost</strong></h3><p>There is a free version of Microsoft SQL Server that you can use. But with highly advanced data and features applications, you will need to make huge investments in high-end software versions.</p><p><strong>Reference:</strong></p><p><a href="https://www.sqlservertutorial.net/getting-started/what-is-sql-server/">https://www.sqlservertutorial.net/getting-started/what-is-sql-server/</a></p><p><a href="https://www.tutorialspoint.com/ms_sql_server/index.htm">https://www.tutorialspoint.com/ms_sql_server/index.htm</a></p><p><a href="https://www.geeksforgeeks.org/advantages-and-disadvantages-of-sql/">https://www.geeksforgeeks.org/advantages-and-disadvantages-of-sql/</a></p><p><a href="https://en.wikipedia.org/wiki/Microsoft_SQL_Server">https://en.wikipedia.org/wiki/Microsoft_SQL_Server</a></p><p><strong>By-</strong></p><p><strong>CS-B, Batch-3, Group-SY35</strong></p><p><strong>Authors-</strong></p><p><strong>Omkar Karpe</strong></p><p><strong>Ganesh Karode</strong></p><p><strong>Sushil Khandare</strong></p><p><strong>Rohit Jadhav</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a8839a6addac" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Post Machine]]></title>
            <link>https://medium.com/@omkarbkarpe02/post-machine-2c2bf62ec09d?source=rss-1d68dbaf8b3f------2</link>
            <guid isPermaLink="false">https://medium.com/p/2c2bf62ec09d</guid>
            <category><![CDATA[post-machine]]></category>
            <category><![CDATA[turing-machine]]></category>
            <dc:creator><![CDATA[KarpeOmkar]]></dc:creator>
            <pubDate>Mon, 06 Jun 2022 13:06:39 GMT</pubDate>
            <atom:updated>2022-06-06T13:06:39.395Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>INTRODUCTION</strong></p><p>The Post-Turing Machine is a very simple type of Emil Post’s Turing Machine-equivalent calculation model.</p><p>The Shipping Machine works by first reading the program, which ends as a string list, and then obtains the user input in the form of a series.</p><p><strong>HISTORY</strong></p><p>In 1936 he introduced the Turing Machine, and shortly thereafter Emil Leon Post (1897–1954) invented the postal machine.</p><p>They hoped it would become a “Universal Algorithm”. The condition that must be met with “such an algorithm” is that any language that can be accurately described by People, must be adopted by another version of this machine.</p><p>This can make it much more powerful than the FA or PDA</p><p><strong>1.</strong></p><p><a href="https://www.wolframscience.com/prizes/tm23/images/Post.pdf"><strong>Finite Combinatory Processes — Formulation 1</strong></a></p><p>Post’s model of a computation differs from the Turing-machine model in a further “atomization” of the acts a human “computer” would perform during a computation.</p><p>1936</p><p><strong>2.</strong></p><p><a href="https://www.wolframscience.com/prizes/tm23/images/Post2.pdf"><strong>Recursive Unsolvability of a Problem of Thue.</strong></a></p><p>Atomized the Turing 5-tuples to 4-tuples:</p><p>“Our quadruplets are quintuplets in the Turing development. That is, where our standard instruction orders either a printing (overprinting) or motion, left or right, Turing’s standard instruction always order a printing and a motion, right, left, or none”</p><p>1947</p><p><strong>3.</strong></p><p><a href="https://en.wikipedia.org/wiki/Wang_B-machine"><strong>Wang model.</strong></a></p><p>Reduction to only four instructions of the Wang model (Wang B-machine) as the source of the “program formulation” of binary-tape Turing machines using numbered instructions from the set {write 0, write 1, move left, move right, if scanning 0 then goto instruction i, if scanning 1 then goto instruction j}.</p><p>1957</p><p><strong>4.</strong></p><p><a href="https://thtsearch.com/content/Post%E2%80%93Turing_machine/"><strong>Davis model (Turing–Post machine).</strong></a></p><p>Davis assigns the numbers “1” to Post’s “mark/slash” and “0” to the blank square. To quote Davis: “We are now ready to introduce the Turing–Post Programming Language. In this language there are seven kinds of instructions: {PRINT 1, PRINT 0, GO RIGHT, GO LEFT, GO TO STEP i IF 1 IS SCANNED, GO TO STEP i IF 0 IS SCANNED, STOP}.</p><p>1978</p><p><strong>5.</strong></p><p><a href="https://tinman.cs.gsu.edu/~raj/8910/f18/DavisSigalWeyukar.pdf"><strong>Davis–Sigal–Weyuker’s Post–Turing program model.</strong></a></p><p>This model allows for the printing of multiple symbols. The model allows for B (blank) instead of S0. The tape is infinite in both directions. Either the head or the tape moves, but their definitions of RIGHT and LEFT always specify the same outcome in either case (Turing used the same convention).</p><p>1994</p><p><strong>WHAT IS TURING MACHINE ?</strong></p><p>The Turing Machine was invented by Alan Turing in 1936.</p><p>The Turing machine contains a tape of unlimited length at which literary work can be done. Tape contains endless cells where each cell contains an insertion mark or a special marker called blank. It also contains a header pointer that identifies the current read cell and can navigate in both directions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/357/0*TMRM39ft1baGQzts" /></figure><p><strong>EXPRESSING TURING MACHINE</strong></p><ul><li>A Turing Machine is presented as a 7-tuple (Q, T, B, ∑, δ, q0, F) where:</li><li>Q is a set of limitations</li><li>T is the alphabet of tape (symbols that can be written on Tape)</li><li>B is an empty symbol (all cells are filled with B except input characters)</li><li>∑ Input alphabet (symbols that are part of input characters)</li><li>Δ is a transition function that sets the map Q × T → Q × T × {L, R}.</li><li>q0 is the first condition</li><li>F a set of endpoints. If any F status is reached, the input unit is accepted.</li></ul><p><strong>WORKING</strong></p><p>PM’s accept some context-free languages and some non-context- free languages.</p><p>For any Turing Machine there exists a Post Machine which accepts the same language, and vice versa. The proof that for any Post Machine there exists a Turing Machine, say M, which accepts the same language, follows from the fact that the queue of the Post Machine can be represented by the leftmost part of the tape of the Turing Machine M and the operations on the queue can be simulated by operations on the tape.</p><p>A Turing machine consists of an infinitely long tape, which has been divided up into cells. Each cell can contain either a 1, a 0, or an empty space. Above one cell of the tape is a head, which can either move left or right, and can read the symbols written in the cells. The head is also capable of erasing symbols and writing new symbols into the cells.</p><p><strong>OPERATIONS</strong></p><p>There are three different tasks the Shipping Machine can complete:</p><p>O1: The machine goes into an unusable state: you must label the cell that already has the label, or delete the cell without the label. Then the execution is stopped And an ineffective suspension occurs.</p><p>O2: The machine comes to a command setting. The machine has completed the process.</p><p>O3: The machine never stops or comes to an unusable command: it goes into an endless loop.</p><p><strong>PROPERTIES</strong></p><p>Alphabet for input letters and special mark # (aabb #). A linear end is called a store or line containing a complete input unit (using the <strong>FIFO</strong> stack). This area can be read, which means that the left-hand character can be removed for testing.</p><p><strong>STORE</strong> can be added as well, which means the new character can be connected to the right of anything that already exists.</p><p>Read the provinces — which removes the left-hand character from the <strong>SHOP</strong> and branch accordingly. The end of the branch on the machine occurs in <strong>READ</strong> provinces. Branch which means empty Store has been read. PMs determine, so no two edges from <strong>READ</strong> have the same label.</p><p><strong>Add states</strong> — which concatenate a character onto the right end of the string in STORE. This is different from PDA PUSH states, which concatenate characters onto the left. Post machines have no PUSH states. No branching can take place at an ADD state.</p><p>A <strong>START </strong>and some halt states called <strong>ACCEPT </strong>or <strong>REJECT — </strong>If we are in a READ state and there is no labeled edge for the character we have read then we crash, which is equivalent to taking a labeled edge into a REJECT state. We can draw our PM’s with or without REJECT states.</p><p><strong>Example,</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/575/0*0q_NmugsSXbXGq1Z" /></figure><p>Post machine is deterministic. So, we do not have the edges that lead to REJECT states but instead we allow the path to crash in the READ state if there is no place for it to go. {a^n, b^n}</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/571/0*NcftHeFtG8U72Scv" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/609/0*az3_hG0TYuAC2Atw" /></figure><p><strong>REFERENCES</strong></p><ol><li><a href="https://www.researchgate.net/publication/264301619_Turing_Machine_and_Automata_Simulators">https://www.researchgate.net/publication/264301619_Turing_Machine_and_Automata_Simulators</a></li><li><a href="https://upscfever.com/upsc-fever/en/gatecse/en-gatecse-chp144.html">https://upscfever.com/upsc-fever/en/gatecse/en-gatecse-chp144.html</a></li><li><a href="https://www.youtube.com/watch?v=uvqh0EToQSQ">https://www.youtube.com/watch?v=uvqh0EToQSQ</a></li><li><a href="https://www.wolframscience.com/prizes/tm23/images/Post.pdf">https://www.wolframscience.com/prizes/tm23/images/Post.pdf</a></li><li><a href="https://www.wolframscience.com/prizes/tm23/images/Post2.pdf">https://www.wolframscience.com/prizes/tm23/images/Post2.pdf</a></li><li><a href="https://en.wikipedia.org/wiki/Wang_B-machine">https://en.wikipedia.org/wiki/Wang_B-machine</a></li><li><a href="https://thtsearch.com/content/Post%E2%80%93Turing_machine/">https://thtsearch.com/content/Post%E2%80%93Turing_machine/</a></li><li><a href="https://tinman.cs.gsu.edu/~raj/8910/f18/DavisSigalWeyukar.pdf">https://tinman.cs.gsu.edu/~raj/8910/f18/DavisSigalWeyukar.pdf</a></li></ol><p><strong>By-</strong></p><p><strong>CS-B, Batch-3, Group-SY35</strong></p><p><strong>Authors-</strong></p><p><strong>Omkar Karpe</strong></p><p><strong>Ganesh Karode</strong></p><p><strong>Sushil Khandare</strong></p><p><strong>Rohit Jadhav</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2c2bf62ec09d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>