CINXE.COM
Real-Time Upserts | Startree
<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><title>Real-Time Upserts | Startree</title><meta name="robots" content="index,follow"/><meta name="description" content="Quickly and easily ingest upserts into your real-time analytics database for accurate, up-to-date business insights with StarTree Cloud."/><meta property="og:title" content="Real-Time Upserts | Startree"/><meta property="og:description" content="Quickly and easily ingest upserts into your real-time analytics database for accurate, up-to-date business insights with StarTree Cloud."/><meta property="og:url" content="https://startree.ai/products/real-time-upserts"/><meta property="og:image" content="https://startreecms.wpenginepowered.com/wp-content/uploads/2024/08/Open-Graph.jpg"/><link rel="canonical" href="https://startree.ai/products/real-time-upserts"/><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/><link rel="apple-touch-icon" sizes="180x180" href="/favicon/apple-touch-icon.png"/><link rel="icon" type="image/png" sizes="32x32" href="/favicon/favicon-32x32.png"/><link rel="icon" type="image/png" sizes="16x16" href="/favicon/favicon-16x16.png"/><link rel="manifest" href="/favicon/site.webmanifest"/><link rel="mask-icon" href="/favicon/safari-pinned-tab.svg" color="#5bbad5"/><meta name="msapplication-TileColor" content="#ffffff"/><meta name="theme-color" content="#ffffff"/><meta name="twitter:card" content="summary"/><meta name="next-head-count" content="18"/><link rel="preload" href="/_next/static/media/f7040064460a9b21-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/media/122c360d7fe6d395-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/css/bc63c7c42c15cc71.css" as="style"/><link rel="stylesheet" href="/_next/static/css/bc63c7c42c15cc71.css" data-n-g=""/><link rel="preload" href="/_next/static/css/25cae41c71aa3ee0.css" as="style"/><link rel="stylesheet" href="/_next/static/css/25cae41c71aa3ee0.css" data-n-p=""/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/_next/static/chunks/polyfills-78c92fac7aa8fdd8.js"></script><script id="brightEdge" src="//cdn.bc0a.com/autopilot/f00000000304780/autopilot_sdk.js" data-cfasync="false" defer="" data-nscript="beforeInteractive"></script><script defer="" src="/_next/static/chunks/114.c67adae6ed23d0f1.js"></script><script defer="" src="/_next/static/chunks/442.2c3608a8ab0d9442.js"></script><script src="/_next/static/chunks/webpack-7f5c6789c515ac4f.js" defer=""></script><script src="/_next/static/chunks/framework-9620da855a94eb57.js" defer=""></script><script src="/_next/static/chunks/main-4c5a65bf32bd6706.js" defer=""></script><script src="/_next/static/chunks/pages/_app-af3bd3ce1347445d.js" defer=""></script><script src="/_next/static/chunks/31d4e3d1-0a655c6d6ff6e9de.js" defer=""></script><script src="/_next/static/chunks/9e82d048-ffb998b39e497a2e.js" defer=""></script><script src="/_next/static/chunks/854-338aa8ccdafb1663.js" defer=""></script><script src="/_next/static/chunks/927-252a7a71f883e286.js" defer=""></script><script src="/_next/static/chunks/463-f9292cf30fcf41ef.js" defer=""></script><script src="/_next/static/chunks/399-7a231d8f7c5f17a1.js" defer=""></script><script src="/_next/static/chunks/78-432c7488e888c80f.js" defer=""></script><script src="/_next/static/chunks/pages/%5B...slug%5D-b6cc7d45f8a3bac1.js" defer=""></script><script src="/_next/static/fjFePtEzv4OGhiMlhwN32/_buildManifest.js" defer=""></script><script src="/_next/static/fjFePtEzv4OGhiMlhwN32/_ssgManifest.js" defer=""></script><style id="__jsx-3450457828">:root{--font-mulish:'__Mulish_1ed915', '__Mulish_Fallback_1ed915';--font-fira:'__Fira_Code_74c79e', '__Fira_Code_Fallback_74c79e'}</style></head><body class="font-body"><div id="__next"><header class="fixed inset-x-0 top-0 z-50 h-[60px] w-full bg-indigo transition-all duration-300 lg:h-[89px] bg-transparent"><div class="header-container h-full"><div class="flex h-full items-center justify-between gap-4"><div class="z-50 flex items-center gap-[71px]"><div class="relative z-50 w-[100px] cursor-pointer lg:w-[118px]"><a aria-label="Back to Home" class="nav-logo transition-colors text-indigo" href="/"><svg width="100%" height="100%" viewBox="0 0 119 21" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M12.65 15.607c0 3.3-2.893 4.893-6.186 4.893-3.078 0-5.357-1.286-6.464-3.64l3.446-1.928c.433 1.257 1.479 1.99 3.018 1.99 1.265 0 2.122-.43 2.122-1.315 0-2.236-7.94-1.01-7.94-6.393 0-3.118 2.679-4.86 5.847-4.86 2.5 0 4.643 1.128 5.846 3.239L8.954 9.429a2.607 2.607 0 0 0-2.465-1.561c-.982 0-1.785.428-1.785 1.257 0 2.26 7.942.854 7.942 6.482M36.785 12.425c0-2.568-1.817-4.31-4.285-4.31s-4.247 1.742-4.247 4.31c0 2.568 1.815 4.311 4.247 4.311s4.285-1.74 4.285-4.31Zm3.972-7.643v15.29h-3.971V18.26c-1.108 1.375-2.772 2.232-5.018 2.232-4.093 0-7.479-3.518-7.479-8.075 0-4.557 3.386-8.071 7.479-8.071 2.246 0 3.91.853 5.017 2.232V4.775l3.972.007ZM51.615 4.475v4.403c-2.06-.243-4.679.675-4.679 3.886v7.307h-3.971V4.781h3.971v2.63c.8-2.08 2.74-2.936 4.679-2.936ZM71.369 8.571v6.361c0 1.654 1.2 1.682 3.475 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.975v4.286h3.475v3.79h-3.475M85.146 4.475v4.403c-2.06-.243-4.675.675-4.675 3.886v7.307H76.5V4.781h3.971v2.63c.797-2.08 2.736-2.936 4.675-2.936ZM97.61 10.99a3.732 3.732 0 0 0-3.817-3.086c-2.121 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.286 4.286 0 0 0 3.45-1.528l3.214 1.832c-1.428 2.082-3.753 3.275-6.71 3.275-5.168 0-8.433-3.518-8.433-8.075 0-4.557 3.293-8.072 8.126-8.072 4.557 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621H89.822c.553 2.015 2.25 2.872 4.339 2.872l.007.003ZM114.603 10.99a3.733 3.733 0 0 0-3.818-3.086c-2.125 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.284 4.284 0 0 0 3.45-1.528l3.214 1.832c-1.446 2.082-3.757 3.275-6.71 3.275-5.172 0-8.432-3.518-8.432-8.075 0-4.557 3.292-8.072 8.125-8.072 4.553 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621h-11.625c.557 2.015 2.246 2.872 4.339 2.872l.007.003ZM20.043 8.571v6.361c0 1.654 1.2 1.682 3.479 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.97v4.286h3.48v3.79h-3.48M63.114 10.857h-4.596V4.643a.282.282 0 0 0-.06-.175.304.304 0 0 0-.154-.103.268.268 0 0 0-.183 0 .275.275 0 0 0-.142.117l-5.415 8.958a.333.333 0 0 0-.042.142.297.297 0 0 0 .143.254.311.311 0 0 0 .146.04h4.6v6.217a.286.286 0 0 0 .21.279c.06.018.123.018.183 0a.293.293 0 0 0 .142-.118l5.411-8.957a.26.26 0 0 0 .043-.147.282.282 0 0 0-.143-.25.26.26 0 0 0-.146-.043" fill="currentColor"></path></svg></a></div><nav class="flex items-center gap-8 max-lg:hidden"><a class="nav-link z-50 relative text-indigo" aria-label="Platform" href="/products/startree-cloud"><span style="will-change:opacity">Platform</span></a><button type="button" class="nav-link z-50 relative text-indigo" aria-label="Solutions"><span style="will-change:opacity">Solutions</span></button><a class="nav-link z-50 relative text-indigo" aria-label="For Developers" href="https://dev.startree.ai/"><span style="will-change:opacity">For Developers</span></a><a class="nav-link z-50 relative text-indigo" aria-label="Resources" href="/resources"><span style="will-change:opacity">Resources</span></a><a class="nav-link z-50 relative text-indigo" href="/partners"><span style="will-change:opacity">Partners</span></a><a class="nav-link z-50 relative text-indigo" href="/pricing"><span style="will-change:opacity">Pricing</span></a><div class="pointer-events-none absolute inset-0 h-screen min-w-full backdrop-blur-xl" style="opacity:0;will-change:opacity"></div><div class="absolute inset-x-0 top-0 z-30 min-w-full origin-top overflow-hidden rounded-[3px] bg-white pt-[89px]" style="pointer-events:none;opacity:0;will-change:opacity"><div class="min-h-[250px]"></div></div></nav></div><div class="flex gap-2"><div class="flex items-center gap-x-6"><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors text-indigo hover:text-ocean" href="/search"><svg class="w-[14px]" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 14"><path d="M6.125 10.5a4.375 4.375 0 1 0 0-8.75 4.375 4.375 0 0 0 0 8.75ZM9.219 9.219l3.031 3.031" stroke="currentColor"></path></svg></a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" target="_blank" href="https://startree.cloud/login">Login</a><a class="gradient-border-mask nav-button text-indigo" href="/saas-signup">Start for free</a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" href="/demo">Book a demo</a></div><div class="-mr-[15px] lg:hidden" role="button" tabindex="0"><div class="hamburger-react" aria-label="Show menu" aria-expanded="false" role="button" style="cursor:pointer;height:48px;position:relative;transition:0.4s cubic-bezier(0, 0, 0, 1);user-select:none;width:48px;outline:none" tabindex="0"><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:17px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:23px;transition:0.2s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:29px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div></div></div></div></div></div></header><main class=""><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-sky"><div class="pt-[60px] lg:pt-[89px] container"><div><div aria-hidden="true" class="pointer-events-none absolute rounded-full top-[-1430px] left-[-1100px] size-[2000px] md:size-[2117px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #F94F8D 0%, rgba(233,244,252,0.02) 75.48%, rgba(233,248,255,0.00) 92.49%)"></div><div aria-hidden="true" class="pointer-events-none absolute rounded-full bottom-[-2000px] right-[-3120px] size-[3750px] lg:size-[4309px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #21C6DC 8.43%, rgba(233, 248, 255, 0.00) 92.49%)"></div><div class="relative isolate overflow-hidden pb-12 lg:pb-[120px]"><div class="container pt-6 md:pt-[72px] md:grid md:grid-cols-2 md:items-center md:gap-6"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h1 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">Real-Time Upserts</h1><h2 class="w-full text-h1 md:w-full text-indigo mb-3 md:mb-6">Scale up, costs down</h2><div class="prose w-full max-md:text-balance text-18 md:max-w-lg text-ocean"><p>StarTree performs upserts at ingest for millions of rows per second while reducing infrastructure costs.</p> </div><div class="flex w-auto items-center gap-[18px] md:gap-6 mt-[22px] justify-center md:justify-start md:mt-11"><a target="" class="hero-button w-auto " href="/demo"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden w-auto py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo" type="button" text="[object Object]"><div>Book a demo</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a target="" class="hero-button w-auto " href="/saas-signup"><div class="text-link-m group flex items-center gap-2 w-auto text-indigo">Start for free<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-indigo" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div></div></div><div class="relative w-full max-sm:mx-auto md:ml-auto md:mt-0 mt-14"><img alt="10212024 Upserts Hero V1" loading="lazy" width="490" height="510" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full max-sm:mx-auto max-sm:w-[80%] md:ml-auto" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10212024-upserts_hero-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10212024-upserts_hero-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10212024-upserts_hero-v1.svg&w=1080&q=75"/></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white sticky top-[60px] z-20"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class="flex items-center justify-between gap-6 border-y border-indigo/5 max-md:hidden"><div class="size-8_ w-8_ shrink-0"><img alt="32x32 Upserts Icon V1" loading="lazy" width="32" height="32" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-8 w-auto" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F32x32-upserts_icon-v1.svg&w=32&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F32x32-upserts_icon-v1.svg&w=64&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F32x32-upserts_icon-v1.svg&w=64&q=75"/></div><nav class="flex gap-x-10"><a class="relative cursor-pointer py-5 text-[15px] leading-[1.1] tracking-[-0.15px] text-ocean transition-colors duration-200 hover:text-indigo"><span>Why StarTree?</span></a><a class="relative cursor-pointer py-5 text-[15px] leading-[1.1] tracking-[-0.15px] text-ocean transition-colors duration-200 hover:text-indigo"><span>The Challenge</span></a><a class="relative cursor-pointer py-5 text-[15px] leading-[1.1] tracking-[-0.15px] text-ocean transition-colors duration-200 hover:text-indigo"><span>Overview</span></a><a class="relative cursor-pointer py-5 text-[15px] leading-[1.1] tracking-[-0.15px] text-ocean transition-colors duration-200 hover:text-indigo"><span>Features</span></a></nav></div></div></section><section id="why" class="relative isolate overflow-hidden_ overflow-clip bg-indigo-900 pt-12 lg:pt-[120px] pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-[50px] md:space-y-20 lg:space-y-24 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h3 md:max-w-5xl text-white" style="max-width:700px">StarTree performs upserts at ingest, making it incredibly efficient, fast, and scalable</h2></div></div><div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-3 lg:gap-6"><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Lowest Price" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Flowest-price.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Flowest-price.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Flowest-price.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Reduce costs by minimizing compute and memory intensive operations</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Freshest Data" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffreshest-data.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Increase data freshness by removing a step</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="64x64 Scalability Icon Yellow V1" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F64x64-scalability-icon_yellow-v1.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F64x64-scalability-icon_yellow-v1.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F64x64-scalability-icon_yellow-v1.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Massive scalability through minimizing processing overhead</h3></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-12 lg:pt-[120px] pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div aria-hidden="true" class="pointer-events-none absolute left-[-1480px] top-[-1800px] -z-10 size-[2200px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(233,248,255,0.00)_100%)] lg:size-[2400px]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-1800px] right-[-1280px] -z-10 size-[2200px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(233,248,255,0.00)_100%)] lg:size-[2400px]"></div><div style="opacity:0;will-change:opacity"><div class="flex flex-col justify-center text-center"><div class="mb-8"><img alt="18px Amberdata Logo Dark" loading="lazy" width="141" height="18" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto max-h-[26px] w-auto self-start" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F18px-amberdata_logo-dark.svg&w=256&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F18px-amberdata_logo-dark.svg&w=320&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F18px-amberdata_logo-dark.svg&w=320&q=75"/></div><h3 class="text-h4 text-inidgo mx-auto mb-10 max-w-[700px]">Amberdata: Real-Time Analytics for the Entire Cryptoeconomy</h3><a href="/user-stories/amberdata-powering-real-time-blockchain-analytics-with-startree"><div class="text-link-m group flex items-center gap-2 justify-center text-indigo">Read the full story<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-indigo" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div><div class="mx-auto mt-14 grid max-w-[792px] gap-4 sm:grid-cols-2"><div class="flex flex-col justify-between gap-6 rounded-lg bg-white/80 p-4 ring-1 ring-sky-25/10 md:gap-7 md:rounded-xl md:p-6"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-sky text-indigo border-white/50">Results</p><dl class="space-y-4 md:space-y-[22px]"><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">reduced infrastructure costs</dt><dd class="order-first font-semibold text-indigo-900">66%</dd></div><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">insert events per second</dt><dd class="order-first font-semibold text-indigo-900">350k</dd></div><div class="flex max-w-xs gap-x-1.5 gap-y-4 text-[16px] leading-[1.12] tracking-[-0.18px] sm:gap-x-3.5 sm:text-[18px]"><dt class="text-ocean">query latencies</dt><dd class="order-first font-semibold text-indigo-900">Sub-second</dd></div></dl></div><div class="flex flex-col justify-between gap-6 rounded-lg bg-white/80 p-4 ring-1 ring-sky-25/10 md:gap-7 md:rounded-xl md:p-6"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-sky text-indigo border-white/50">Uses Cases</p><div class="flex flex-col gap-4"><div class="text-18 flex items-center gap-2.5"><div class="size-8 shrink-0 rounded bg-sky-400"></div><span>Financial Analysis</span></div></div></div></div></div><div class="mt-14 inline-flex w-full items-center justify-center overflow-visible"><div class="relative"><div class="safari-blur absolute inset-0 h-full w-full rounded-full bg-gradient-to-r from-grape to-river blur-[10px]"></div><div class="py-[13px]_ px-[17px]_ relative flex items-center gap-x-6 rounded-full bg-indigo"><button type="button" disabled="" class="py-3.5 pl-4 transition-opacity duration-500 cursor-not-allowed opacity-50"><div class="sr-only">Previous</div><svg xmlns="http://www.w3.org/2000/svg" width="7" height="12" viewBox="0 0 7 12" fill="none"><path d="M6 10.5L1.5 6L6 1.5" stroke="#E9F8FF" stroke-width="1.1" stroke-linecap="round" stroke-linejoin="round"></path></svg></button><div class="relative flex overflow-hidden font-mono text-[13px] uppercase leading-[1.1] tracking-[1.3px] text-sky"><div class="overflow-hidden" style="will-change:transform;transform:none">01</div>/<!-- -->02</div><button type="button" class="pr-4 transition-opacity duration-500 opacity-100"><div class="sr-only">Next</div><svg class="rotate-180" xmlns="http://www.w3.org/2000/svg" width="7" height="12" viewBox="0 0 7 12" fill="none"><path d="M6 10.5L1.5 6L6 1.5" stroke="#E9F8FF" stroke-width="1.1" stroke-linecap="round" stroke-linejoin="round"></path></svg></button></div></div></div></div></div></section><section id="challenge" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-12 lg:pt-[120px] pb-12 lg:pb-[120px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class="flex gap-x-8 gap-y-9 max-lg:flex-col lg:gap-x-[126px] md:items-center"><div class="relative min-h-[385px] w-full shrink-0 overflow-hidden rounded-xl lg:max-w-[40%] md:order-last xl:max-w-[588px]"><img alt="Masthead" loading="lazy" width="510" height="568" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMasthead-5.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMasthead-5.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMasthead-5.svg&w=1080&q=75"/></div><div class="w-full max-w-xl lg:mx-0 lg:max-w-[547px]"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h2 md:w-full text-indigo mb-3 md:mb-6">The challenge with upserts</h2><div class="prose w-full max-md:text-balance text-18 md:w-full text-ocean"><p>An upsert is a database operation that combines update and insert functions into a single operation, offering improved insight accuracy, enhanced data freshness and simplified architecture.</p> <p>Upserts, while simple in operational databases, can pose challenges in analytical databases by disrupting efficient bulk-loading, conflicting with columnar storage, and degrading query performance due to re-indexing.</p> </div></div></div></div></div></div></section><section id="overview" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="flex w-full flex-col text-center md:text-center"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">overview</h6><h2 class="w-full text-h2 md:custom md:mx-auto text-indigo" style="max-width:800px">What makes StarTree upserts unique</h2></div></div><div class="relative overflow-hidden"><div class="absolute inset-y-0 -left-4 w-[2px] max-lg:hidden xl:inset-x-0 xl:mx-auto bg-ocean/5"><div class="absolute left-0 top-0 flex h-full w-full flex-col" style="transform:none"><div class="relative h-[240px] w-full bg-gradient-to-t from-river to-sky"><div class="absolute bottom-0 left-[-4px] mt-auto size-2.5 rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_#E9F8FF_100%)] drop-shadow-[drop-shadow(0px_0px_1.19px_#FFF)_drop-shadow(0px_0px_2.381px_#FFF)_drop-shadow(0px_0px_8.333px_#FFF)_drop-shadow(0px_0px_16.665px_#A6E8F1)_drop-shadow(0px_0px_28.569px_#7ADDEA)_drop-shadow(0px_0px_49.996px_#21C6DC)]"></div></div></div></div><div class="w-full space-y-14 md:space-y-20"><div class="grid items-center gap-y-9 md:gap-x-10 lg:grid-cols-2 xl:gap-x-0"><div class="max-w-[509px] lg:ml-auto"><h5 class="text-label-l mb-3 text-balance md:mb-6 text-ocean">StarTree upserts</h5><h3 class="text-h3 text-balance text-balance text-indigo">Ingestion-time reconciliation</h3><div class="text-18 mt-3 md:mt-6 text-ocean"><p>StarTree revolutionizes upserts with ingestion-time reconciliation. It appends new records, uses metadata for status, marks obsolete records, and balances storage between memory and external systems. This approach improves scalability and reduces memory overhead.</p> </div></div><img alt="10242024 Upserts Diagram 3 Web Light V1" loading="lazy" width="510" height="500" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full lg:max-w-[510px] max-xl:lg:max-w-[100%] order-first" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_3-web_light-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_3-web_light-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_3-web_light-v1.svg&w=1080&q=75"/></div><div class="grid items-center gap-y-9 md:gap-x-10 lg:grid-cols-2 xl:gap-x-0"><div class="max-w-[509px] lg:ml-auto"><h5 class="text-label-l mb-3 text-balance md:mb-6 text-ocean">Traditional upserts</h5><h3 class="text-h3 text-balance text-indigo">Pre-ingestion reconciliation</h3><div class="text-18 mt-3 md:mt-6 text-ocean"><p>Many vendors attempt to determine if a record is an insert or an update before data enters the database. This method increases data pipeline complexity and memory usage. It requires large volumes of temporary data, slows ingestion, and leads to ballooning overhead as data volumes grow</p> </div></div><img alt="10242024 Upserts Diagram 1 Web Light V1" loading="lazy" width="510" height="500" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full lg:max-w-[510px] max-xl:lg:max-w-[100%] order-first" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_1-web_light-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_1-web_light-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_1-web_light-v1.svg&w=1080&q=75"/></div><div class="grid items-center gap-y-9 md:gap-x-10 lg:grid-cols-2 xl:gap-x-0"><div class="max-w-[509px] lg:ml-auto"><h5 class="text-label-l mb-3 text-balance md:mb-6 text-ocean">Traditional upserts</h5><h3 class="text-h3 text-balance text-indigo">Query run-time ingestion</h3><div class="text-18 mt-3 md:mt-6 text-ocean"><p>Query-time reconciliation works for low-volume scenarios but becomes costly and inefficient as queries increase. It adds processing time, requires extra resources, and impairs real-time analytics performance</p> </div></div><img alt="10242024 Upserts Diagram 2 Web Light V1" loading="lazy" width="510" height="500" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full lg:max-w-[510px] max-xl:lg:max-w-[100%] order-first" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_2-web_light-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_2-web_light-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_diagram_2-web_light-v1.svg&w=1080&q=75"/></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-indigo pt-12 lg:pt-[120px] pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="flex w-full flex-col text-center md:text-center"><h2 class="w-full text-h2 md:max-w-4xl md:mx-auto text-white mb-3 md:mb-6">Ready for real-time?</h2><div class="prose w-full max-md:text-balance text-18 md:w-full md:mx-auto text-sky"><p>StarTree Cloud customers experience over 50% infrastructure cost savings. Book a demo to learn how your organization can get started.</p> </div><div class="flex w-auto items-center gap-[18px] md:gap-6 mt-[22px] justify-center md:justify-center md:mt-11"><a target="" class="w-auto " href="/demo"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden w-auto py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo" type="button"><div>Book a demo</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a target="" class="w-auto " href="/saas-signup"><div class="text-link-m group flex items-center gap-2 w-auto text-white">Start for free<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-white" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div></div></div><img alt="Real-world benefits of real-time upserts from StarTree customers" loading="lazy" width="1520" height="309" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_numbers-web_graphic-v3.svg&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_numbers-web_graphic-v3.svg&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2F10242024-upserts_numbers-web_graphic-v3.svg&w=3840&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full left-[-750px] top-20 xl:left-[-1666px] xl:top-[-360px] size-[1000px] xl:size-[2256px]" style="background:radial-gradient(50% 50% at 50% 50%, #21C6DC 0%, rgba(0,38,84,0.00) 100%)"></div><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full right-[-750px] top-20 xl:right-[-1666px] xl:top-[-360px] size-[1000px] xl:size-[2256px]" style="background:radial-gradient(50% 50% at 50% 50%, #F94F8D 0%, rgba(0,38,84,0.00) 100%)"></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[56px] md:pt-24 lg:pt-[160px] pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="relative isolate overflow-hidden rounded-lg bg-indigo-900 py-14 md:rounded-xl md:py-[104px]"><div class="mx-md:text-balance mx-auto max-w-2xl md:max-w-[721px]" style="opacity:0;will-change:opacity"><div style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><img alt="Amberdata Logo White" loading="lazy" width="564" height="72" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto h-6" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Famberdata_logo_white.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Famberdata_logo_white.svg&w=1200&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Famberdata_logo_white.svg&w=1200&q=75"/></div><figure class="mt-10 md:mt-12"><blockquote class="text-28 text-center text-sky max-lg:px-3" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><div><p>“The benefits of migrating to StarTree and Pinot center around three areas: query performance, SLAs, and cost. With Pinot, we are now in the subseconds to milliseconds range, the higher query concurrency means we can serve more customers faster, and we’ve been able to reduce our infrastructure costs.”</p> </div></blockquote><figcaption class="mt-10 flex items-center justify-center gap-x-5 md:mt-12"><div class="size-12 overflow-hidden rounded-full bg-sky-25 md:size-16" style="opacity:0;will-change:opacity"><img alt="Amberdata Joanes Espanol" loading="lazy" width="130" height="130" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FAmberdata-Joanes-Espanol.jpg&w=256&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FAmberdata-Joanes-Espanol.jpg&w=320&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FAmberdata-Joanes-Espanol.jpg&w=320&q=75"/></div><div><div class="text-h8 text-white" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Joanes Espanol</div><div class="text-16 mt-px text-sky-200" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">CTO and Co-Founder</div></div></figcaption></figure></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-900px] left-[-50%] -z-10 size-[1950px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(20,92,132,0.00)_100%)] opacity-70 md:bottom-[-1492px] md:left-[-30%]"></div></div></div></div></section><section id="features" class="relative isolate overflow-visible bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-[50px] md:space-y-20 lg:space-y-24 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">features</h6><h2 class="w-full text-h2 md:custom text-indigo mb-3 md:mb-6" style="max-width:700px">Perform upserts for millions of rows per second</h2><div class="prose w-full max-md:text-balance text-18 md:custom text-ocean" style="max-width:460px"><p>Achieve real-time data insights with scalable, efficient storage.</p> </div></div></div><div class="grid gap-6 lg:grid-cols-4 lg:pt-10"><nav class="max-lg:hidden lg:sticky lg:top-40 lg:space-y-[26px] lg:self-start"><a href="#deletes" class="text-label-s flex text-left transition-colors text-indigo">Deletes</a><a href="#partial-upserts" class="text-label-s flex text-left transition-colors text-ocean">Partial upserts</a><a href="#compaction" class="text-label-s flex text-left transition-colors text-ocean">Compaction</a><a href="#comparison-column" class="text-label-s flex text-left transition-colors text-ocean">comparison column</a><a href="#bootstrap-and-backfill" class="text-label-s flex text-left transition-colors text-ocean">Bootstrap and backfill</a></nav><div class="space-y-[27px] lg:col-span-3"><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="deletes"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Deletes</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Remove obsolete data from your database that you don’t want to see in future queries. Once our real-time engine encounters a record with a delete column, the primary key will no longer be part of queryable documents — saving you headaches.</p> </div></div></div><img alt="Deletes Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fdeletes_upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fdeletes_upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fdeletes_upserts.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] left-[-577px] top-[-660px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="partial-upserts"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Partial upserts</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Update some of the fields in a record, but not all of them. Partial upserts enable flexible handling of data streams with partial information — perfect for Change Data Capture (CDC) streams where only updated columns are received.</p> </div></div></div><img alt="Partial Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fpartial_upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fpartial_upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fpartial_upserts.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#F94F8D_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#07ACC2_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="compaction"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Compaction</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Minimize disk space and overall infrastructure costs by periodically replacing obsolete records in your database with newer compacted segments that only contain valid records.</p> </div></div></div><img alt="Compaction Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcompaction_upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcompaction_upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcompaction_upserts.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="comparison-column"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Configurable comparison column</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Select a different time column for resolving upserts, rather than using the default. Perfect for when you need to prioritize records based on a different timestamp — not the most up-to-date record.</p> </div></div></div><img alt="Comparison Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcomparison_upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcomparison_upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fcomparison_upserts.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#48809F_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="bootstrap-and-backfill"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Bootstrap and backfill</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Efficiently bootstrap (initialize) and backfill (update past data) into an upsert-enabled table, using a batch data pipeline to directly upload segments.</p> </div></div></div><img alt="Bootstrap Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fbootstrap_upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fbootstrap_upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F10%2Fbootstrap_upserts.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] left-[-577px] top-[-660px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFC61F_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] bg-[radial-gradient(50%_50%_at_50%_50%,_#002654_0%,_rgba(242,251,255,0.00)_100%)]"></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-12 lg:pt-[120px] pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class="overflow-hidden_"><h4 class="text-label-l text-ocean">resources for upserts</h4><div class="swiper !mx-0 mt-9 !overflow-visible will-change-transform"><div class="swiper-wrapper"><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><img alt="The Dialpad product is an AI powered platform" loading="lazy" width="1200" height="630" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 !absolute inset-0 -z-10 h-full w-full object-cover blur" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FThe-Dialpad-product-is-an-AI-powered-platform.png&w=1200&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FThe-Dialpad-product-is-an-AI-powered-platform.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FThe-Dialpad-product-is-an-AI-powered-platform.png&w=3840&q=75"/><div class="absolute inset-0 bottom-0 z-10 bg-gradient-to-b from-[#00152E]/90 to-[#00152E]/40"></div><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"></div><h3 class="mt-[14px] md:mt-5 text-white text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/user-stories/dialpad-powers-real-time-customer-intelligence-with-startree-cloud"><span class="absolute inset-0"></span>Dialpad Powers Real-Time Intelligence with StarTree</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-white"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white w-2.5" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#FFE8A5_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></div><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-white/80 text-indigo border-white/50">Blog</p></div><h3 class="mt-[14px] md:mt-5 text-indigo text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/resources/scaling-upserts-efficiently-with-startree"><span class="absolute inset-0"></span>Scaling Upserts Efficiently: How StarTree Delivers Real-Time Performance for Modern Analytics</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-indigo"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-indigo w-2.5" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#AE95DC_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></div><div class="swiper-slide"><article class="relative isolate overflow-hidden rounded-xl bg-[#F1FAFF] p-[19px] lg:p-7 xs:aspect-[259/289] lg:aspect-[384/428]"><img alt="1697675458-real-time-upserts-blog-preview.png" loading="lazy" width="1920" height="1080" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 !absolute inset-0 -z-10 h-full w-full object-cover blur" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1697675458-real-time-upserts-blog-preview.png&w=1920&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1697675458-real-time-upserts-blog-preview.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2F1697675458-real-time-upserts-blog-preview.png&w=3840&q=75"/><div class="absolute inset-0 bottom-0 z-10 bg-gradient-to-b from-[#00152E]/90 to-[#00152E]/40"></div><div class="relative z-20 flex h-full flex-col justify-between overflow-hidden max-xs:min-h-[320px]"><div><div class="flex items-center gap-3"><p class="text-label-s inline-flex items-center self-start rounded-full border px-2.5 py-[5px] xs:px-3 xs:py-1.5 bg-white/15 text-white border-white/25">Blog</p></div><h3 class="mt-[14px] md:mt-5 text-white text-h6 lg:max-w-[280px]"><a class="cta-button" target="" href="/resources/real-time-upserts-in-apache-pinot-and-startree-cloud"><span class="absolute inset-0"></span>Real-Time Upserts in Apache Pinot and StarTree Cloud</a></h3></div><div class="mb-0.5"><div class="text-link-m flex items-center gap-2 text-white"><div class="flex items-center gap-2" style="will-change:transform;transform:translateX(-91%)"><span style="opacity:0;will-change:opacity">Read article</span><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white w-2.5" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg></div></div></div></div><div aria-hidden="true" class="pointer-events-none absolute left-[-250px] top-[-250px] -z-10 size-[468px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#FFE8A5_0%,_rgba(242,251,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-500px] right-[-580px] -z-10 size-[937px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#7ADDEA_0%,_rgba(242,251,255,0.00)_100%)]"></div></article></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[56px] md:pb-24 lg:pb-[160px]"><div class="space-y-12 md:space-y-20 lg:space-y-[120px] container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">keep exploring</h6><h2 class="w-full text-h2 md:max-w-2xl text-indigo">The most powerful real-time analytics platform</h2></div></div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-12 lg:gap-6"><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[690/490]_ lg:col-span-7 group" href="/products/tiered-storage"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Simplified tiered storage</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[540px]">Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.</div></div><img alt="Tiered Storage Horizontal V1" loading="lazy" width="626" height="236" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=1920&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=1920&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full left-[-889px] top-[-1400px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90 absolute bottom-[-1400px] right-[-1006px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(233,248,255,0.00)_100%)]"></div></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[486/490]_ lg:col-span-5 group" href="/products/indexing"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Powerful, flexible indexing</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4">Harness extensive indexing to analyze your data, any way you want. Unlike other techniques which work on a single column, the star-tree index is built on multiple columns, using pre-aggregated results.</div></div><img alt="Simplified Tiered Storage 1" loading="lazy" width="968" height="532" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=1080&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=2048&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=2048&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/multi-stage-query-engine"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Multi-stage query engine</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Trust StarTree to handle your multi-stage data processing. Run complex SQL queries without sacrificing blazing fast query performance. And gain the business insights your teams need, in real-time.</div></div><img alt="Real Time Upserts" loading="lazy" width="588" height="580" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=1200&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Freal-time-upserts.svg&w=1200&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/autoscaling-minions"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Autoscaling minions</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Save costs on your cloud infrastructure with auto scaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.</div></div><img alt="Auto Scaling Minions 2" loading="lazy" width="1176" height="902" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=1200&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full right-[-813px] top-[-1300px] size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#AE95DC_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90"></div></a></div></div></section></main><div class="space-y-4 bg-indigo py-4 md:pb-[60px] md:pt-16"><div class="header-container"><div class="relative isolate overflow-hidden rounded-lg bg-white/[0.03] px-6 py-10 md:rounded-xl md:px-8 md:py-16 lg:px-20 lg:py-[125px]"><h2 class="text-cta relative z-10 max-w-xl text-sky-25">Ready to deploy real-time analytics?</h2><div class="text-18 prose prose-sky relative z-10 mt-3 !max-w-xl !text-sky-200 md:mt-6"><p>Start for free or book a demo with our team.</p> </div><div class="relative z-10 mt-[22px] flex items-center gap-x-[18px] sm:gap-x-6 md:mt-[47px]"><a class="cta-button block" href="/saas-signup"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo"><div>Start for free</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a class="cta-button block" href="/demo"><div class="text-link-m group flex items-center gap-2 text-white">Book a demo<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-white" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div><div class="pointer-events-none absolute left-[-90%] top-[-40%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(77,_209,_227,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] sm:w-[150%] xl:top-[-110%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div><div class="pointer-events-none absolute bottom-[-50%] right-[-90%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(111,_66,_193,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] md:w-[130%] xl:bottom-[-140%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div></div></div></div><footer class="pb-8 pt-10 md:pb-10 md:pt-[60px] bg-indigo" aria-labelledby="footer-heading"><h2 id="footer-heading" class="sr-only">Footer</h2><div class="container"><div class="be-ix-link-block"></div><div class="grid grid-cols-2 gap-x-6 gap-y-10 sm:grid-cols-3 md:gap-9 lg:flex lg:justify-between lg:gap-[9px]"><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Platform</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-cloud">Platform Overview</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-thirdeye">Anomaly Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/real-time-upserts">Real-Time Upserts</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/tiered-storage">Tiered Storage</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/indexing">Indexing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/multi-stage-query-engine">Multi-Stage Query Engine</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/autoscaling-minions">Autoscaling Minions</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/data-manager">Integrations</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/security-compliance">Security & Compliance</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/deployment-options">Deployment Options</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/partners">Partner</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/pricing">Pricing</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Industries</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/financial-services">Financial Services</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/retail">Retail</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/gaming">Gaming</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/delivery-and-ridesharing">Delivery & Ridesharing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/human-resources">Human Resources</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/healthcare">Healthcare</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Use cases</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/fraud-detection">Fraud Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/personalization">Personalization</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/business-metrics-monitoring">Business Metrics Monitoring</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">For Developers</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/">Docs</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://support.startree.ai/">Support</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/community/">Community</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Resources</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/user-stories">User Stories</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/blog">Blog</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/videos">Videos</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/glossary">Glossary</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/events-webinars">Events & Webinars</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/fundamentals">Fundamentals</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/rta-summit">RTA Summit</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/all-stars">StarTree All-Stars</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Company</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/about">About</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/careers">Careers</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/news">Press</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/contact-us">Contact</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/legal">Legal</a></li><li></li></ul></div></div><div class="mt-10 flex gap-x-6 gap-y-6 max-sm:flex-col-reverse lg:mt-[140px] lg:gap-x-[167px]"><img alt="Svg 223107605 1699873195" loading="lazy" width="80" height="80" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-sm:max-w-14" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=96&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75"/><div class="w-full max-w-[459px] shrink-0"><h3 class="text-22-t mb-5 !font-normal !leading-[1.2] !tracking-[-0.22px] text-sky md:mb-7">Get the latest updates</h3><form class="flex w-full items-center gap-x-4 rounded-full border border-white/10 bg-white/[0.03] px-5 py-3.5 md:px-6 md:py-3.5"><input type="email" name="email" required="" class="flex-1 border-0 bg-transparent p-0 text-[15px] leading-[1.1] tracking-[-0.3px] text-sky outline-0 ring-0 placeholder:text-white/50 focus:ring-0" placeholder="Your email address"/><button type="submit" class="w-2.5 shrink-0"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg><span class="sr-only">Subscribe</span></button></form></div></div><div class="mt-10 flex gap-y-6 max-md:flex-col md:items-end md:justify-between lg:mt-[160px] xl:items-center"><div class="flex flex-1 gap-x-10 gap-y-6 max-lg:flex-col lg:items-center xl:gap-x-[126px]"><p class="text-link-s text-sky/40">© <!-- -->2024<!-- --> <!-- -->StarTree Inc. All rights reserved.</p><div class="flex flex-wrap gap-x-6 gap-y-2"><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/startree-trademark-policy">Trademark Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/privacy-policy">Privacy Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/terms-conditions">Terms of Use</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/responsible-disclosure">Responsible Disclosure</a></div></div><div class="flex space-x-4 max-md:order-first"><a target="_blank" href="https://www.linkedin.com/company/startreedata/"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">linkedin</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" fill-rule="evenodd" d="M2.285 17.45h3.171V6.9h-3.17v10.55ZM17.081 11.577v5.874h-3.104v-5.548c0-1.414-.5-2.284-1.602-2.284-.713-.008-1.354.47-1.602 1.196a2.28 2.28 0 0 0-.1.87v5.766H7.567V7.226h3.104V8.64c.583-1.081 1.652-1.744 2.804-1.74 2.003 0 3.605 1.522 3.605 4.677ZM3.915 2.685c-.814-.09-1.54.556-1.623 1.44-.004.045-.006.09-.007.135.001.873.653 1.579 1.456 1.577.028 0 .056 0 .084-.002.814.088 1.54-.555 1.623-1.44.003-.046.006-.09.007-.135.029-.843-.576-1.55-1.35-1.582-.064-.002-.127 0-.19.007Z" clip-rule="evenodd"></path></svg></div></span></a><a target="_blank" href="https://www.youtube.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">youtube</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="M15.057 3H4.685C2.65 3 1 4.75 1 6.908v5.5c0 2.158 1.65 3.908 3.685 3.908h10.372c2.035 0 3.685-1.75 3.685-3.909V6.908C18.742 4.75 17.092 3 15.057 3Zm-2.492 6.925L7.714 12.38c-.13.066-.279-.034-.279-.186V7.131c0-.154.153-.254.283-.184l4.851 2.608c.145.077.142.297-.004.37Z"></path></svg></div></span></a><a target="_blank" href="https://twitter.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">x</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="m10.956 8.85 5.424-6.173h-1.285l-4.711 5.36-3.76-5.36H2.284l5.688 8.106-5.688 6.473H3.57l4.972-5.661 3.972 5.661h4.338M4.034 3.626h1.974l9.086 12.728H13.12"></path></svg></div></span></a></div></div></div></footer></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"page":{"ID":270,"post_author":"1","post_date":"2024-07-05 13:00:27","post_date_gmt":"2024-07-05 13:00:27","post_title":"Real-Time Upserts","post_status":"publish","comment_status":"closed","ping_status":"closed","post_name":"real-time-upserts","post_modified":"2024-11-21 20:36:25","post_modified_gmt":"2024-11-21 20:36:25","post_parent":267,"guid":"http://startree.ai/?page_id=270","post_type":"page","filter":"raw","url":"https://startree.ai/products/real-time-upserts","page_options":{"header_color":"white","is_first_component_overflowing_nav":true,"footer_color":"indigo","banner":{"background_color":"indigo"},"popup":{"variants":"blue"}},"sections":[{"acf_fc_layout":"section","components":[{"acf_fc_layout":"mastheads","mastheads":[{"acf_fc_layout":"page_masthead","layout":"two_col","gradient":"red_blue","text_card":{"subheading":"Real-Time Upserts","heading":"Scale up, costs down","content":"\u003cp\u003eStarTree performs upserts at ingest for millions of rows per second while reducing infrastructure costs.\u003c/p\u003e\n","links":[{"link":{"link":{"title":"Book a demo","url":"/demo"},"type":"button","button":{"type":"default","background_color":"tumeric","size":"default","custom_classes":"hero-button"},"text":{"color":"indigo"}}},{"link":{"link":{"title":"Start for free","url":"/saas-signup"},"type":"text","button":{"type":"default","size":"default"},"text":{"color":"indigo","custom_classes":"hero-button"}}}],"options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h1","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h1","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"max-w-lg","custom_y_spacing":"default"},"page_callout":{"layout":"row"}},"add_asset":true,"asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/10212024-upserts_hero-v1.svg","alt":"10212024 Upserts Hero V1","width":490,"height":510}}},"asset_spacing":"default"}]}],"padding_top":"none","padding_bottom":"none","inner_spacing":"none","has_container":true,"background":{"background_color":"sky"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"content","content":[{"acf_fc_layout":"inner_page_nav","links":[{"link":{"title":"Why StarTree?","url":"#why"}},{"link":{"title":"The Challenge","url":"#challenge"}},{"link":{"title":"Overview","url":"#overview"}},{"link":{"title":"Features","url":"#features"}}],"icon":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/32x32-upserts_icon-v1.svg","alt":"32x32 Upserts Icon V1","width":32,"height":32}}]}],"padding_top":"none","padding_bottom":"none","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"StarTree performs upserts at ingest, making it incredibly efficient, fast, and scalable","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h3","heading_font_color":"white","heading_max_width":"max-w-5xl","custom_heading_max_width":"700","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_content_max_width":"460","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"icon_hover_cards","layout":"default","card_bg_color":"indigo","cards":[{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/lowest-price.png","alt":"Lowest Price","width":128,"height":128},"heading":"Reduce costs by minimizing compute and memory intensive operations","content":"\u003cp class=\"p1\"\u003eStarTree\u0026#8217;s ingestion-time reconciliation eliminates costly pre-ingestion checks and query-time processing, significantly lowering infrastructure costs and improving analytical performance.\u003c/p\u003e\n","theme":"yellow"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/freshest-data.png","alt":"Freshest Data","width":128,"height":128},"heading":"Increase data freshness by removing a step","content":"\u003cp class=\"p1\"\u003eBy reconciling upserts during ingestion, StarTree ensures real-time data accuracy without pre-ingestion delays or query-time consolidation.\u003c/p\u003e\n","theme":"blue"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/64x64-scalability-icon_yellow-v1.png","alt":"64x64 Scalability Icon Yellow V1","width":128,"height":128},"heading":"Massive scalability through minimizing processing overhead","content":"\u003cp class=\"p1\"\u003eHandle billions of primary keys per server and millions of upserts per second with StarTree\u0026#8217;s efficient processing and local storage persistence.\u003c/p\u003e\n","theme":"purple"}],"resource_callout":[{"ID":499,"post_title":"TEST — What is Apache Pinot?","categories":[{"id":4,"name":"eBooks \u0026amp; Whitepapers","slug":"ebooks-whitepapers"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/A4-1.svg","alt":"A4 1","width":245,"height":258},"intro":"Apache Pinot is an open source distributed database designed for real-time, user-facing analytics.","show_video_icon":true,"resource_callout_thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/image-31.jpg","alt":"Image 31","width":518,"height":292},"theme":"grey_green"},"layout":"papers"}}],"text_card":{"options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}}]}],"id":"why","padding_top":"120","padding_bottom":"160","inner_spacing":"96","has_container":true,"background":{"background_color":"indigo-900"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"resources","resources":[{"acf_fc_layout":"detailed_customer_slider","posts":[{"ID":4851,"post_title":"Amberdata: Real-Time Analytics for the Entire Cryptoeconomy","permalink":"/user-stories/amberdata-powering-real-time-blockchain-analytics-with-startree","acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/Amberdata-thumb.jpg","alt":"Amberdata Thumb","width":1920,"height":1080},"heading":"Amberdata: Real-Time Analytics for the Entire Cryptoeconomy","theme":"yellow_blue"},"logos":{"light_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/amberdata_logo_white.svg","alt":"Amberdata Logo White","width":564,"height":72},"dark_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/18px-amberdata_logo-dark.svg","alt":"18px Amberdata Logo Dark","width":141,"height":18}},"stats":{"stats":[{"stat":"66%","supporting_content":"reduced infrastructure costs","supporting_content_short":"decrease in costs"},{"stat":"350k","supporting_content":"insert events per second","supporting_content_short":"events per second"},{"stat":"Sub-second","supporting_content":"query latencies"}]}},"use_case":[{"id":8,"name":"Financial Analysis","slug":"financial-analysis","acf":{"icon":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Bar-chart.svg","alt":"Bar Chart","width":32,"height":32}}}],"industry":[{"id":39,"name":"Financial Services","slug":"financial-services"}]},{"ID":4355,"post_title":"Dialpad Powers Real-Time Customer Intelligence with StarTree Cloud","permalink":"/user-stories/dialpad-powers-real-time-customer-intelligence-with-startree-cloud","acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/The-Dialpad-product-is-an-AI-powered-platform.png","alt":"The Dialpad product is an AI powered platform","width":1200,"height":630},"heading":"Dialpad Powers Real-Time Intelligence with StarTree","theme":"yellow_blue"},"logos":{"dark_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/24px-dialpad_logo-dark.svg","alt":"24px Dialpad Logo Dark","width":103,"height":25}},"stats":{"stats":[{"stat":"10,000s","supporting_content":"of live users"},{"stat":"500 ms","supporting_content":"p95 latencies"},{"stat":"98%","supporting_content":"lower latencies"}]}},"use_case":[{"id":7,"name":"Business Metrics Monitoring","slug":"business-metrics-monitoring","acf":{"icon":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Analytics.svg","alt":"Analytics","width":32,"height":32}}}],"industry":[{"id":34,"name":"Telecommunications","slug":"telecommunications"}]}]}]}],"padding_top":"120","padding_bottom":"160","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"content","content":[{"acf_fc_layout":"two_column_text_asset","text_card":{"heading":"The challenge with upserts","content":"\u003cp\u003eAn upsert is a database operation that combines update and insert functions into a single operation, offering improved insight accuracy, enhanced data freshness and simplified architecture.\u003c/p\u003e\n\u003cp\u003eUpserts, while simple in operational databases, can pose challenges in analytical databases by disrupting efficient bulk-loading, conflicting with columnar storage, and degrading query performance due to re-indexing.\u003c/p\u003e\n","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}},"asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Masthead-5.svg","alt":"Masthead","width":510,"height":568}}},"gap_spacing":"default"}]}],"id":"challenge","padding_top":"120","padding_bottom":"120","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"subheading":"overview","heading":"What makes StarTree upserts unique","options":{"text_alignment":"center","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"custom","custom_heading_max_width":"800","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"content","content":[{"acf_fc_layout":"content_progress_scroll","layout":"center","no_spacing_top_or_bottom":true,"items":[{"subheading":"StarTree upserts","heading":"Ingestion-time reconciliation","content":"\u003cp\u003eStarTree revolutionizes upserts with ingestion-time reconciliation. It appends new records, uses metadata for status, marks obsolete records, and balances storage between memory and external systems. This approach improves scalability and reduces memory overhead.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/10242024-upserts_diagram_3-web_light-v1.svg","alt":"10242024 Upserts Diagram 3 Web Light V1","width":510,"height":500}}}},{"subheading":"Traditional upserts","heading":"Pre-ingestion reconciliation","content":"\u003cp\u003eMany vendors attempt to determine if a record is an insert or an update before data enters the database. This method increases data pipeline complexity and memory usage. It requires large volumes of temporary data, slows ingestion, and leads to ballooning overhead as data volumes grow\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/10242024-upserts_diagram_1-web_light-v1.svg","alt":"10242024 Upserts Diagram 1 Web Light V1","width":510,"height":500}}}},{"subheading":"Traditional upserts","heading":"Query run-time ingestion","content":"\u003cp\u003eQuery-time reconciliation works for low-volume scenarios but becomes costly and inefficient as queries increase. It adds processing time, requires extra resources, and impairs real-time analytics performance\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/10242024-upserts_diagram_2-web_light-v1.svg","alt":"10242024 Upserts Diagram 2 Web Light V1","width":510,"height":500}}},"resource_callout":[{"ID":517,"post_title":"TEST — Real-Time Analytics Innovations for Apache Pinot and StarTree Cloud Announced at RTA Summit","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"theme":"yellow_blue"},"layout":"post"}}]}]}]}],"id":"overview","padding_top":"80","padding_bottom":"160","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Ready for real-time?","content":"\u003cp\u003eStarTree Cloud customers experience over 50% infrastructure cost savings. Book a demo to learn how your organization can get started.\u003c/p\u003e\n","links":[{"link":{"link":{"title":"Book a demo","url":"/demo"},"type":"button","button":{"type":"default","background_color":"tumeric","size":"default"}}},{"link":{"link":{"title":"Start for free","url":"/saas-signup"},"type":"text","button":{"type":"default","size":"default"},"text":{"color":"white"}}}],"options":{"text_alignment":"center","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"river","heading_tag":"h2","heading_font_size":"default","heading_font_color":"white","heading_max_width":"max-w-4xl","content_font_size":"18","content_font_color":"sky","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"asset","type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/10242024-upserts_numbers-web_graphic-v3.svg","alt":"Real-world benefits of real-time upserts from StarTree customers","width":1520,"height":309},"options":{"is_centered":true}}}],"padding_top":"120","padding_bottom":"160","inner_spacing":"120","has_container":true,"background":{"background_color":"indigo"},"theme":"blue_red"},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"content","content":[{"acf_fc_layout":"testimonial_slider","testimonials":[{"ID":4859,"post_title":"Amberdata - Joanes Espanol","acf":{"quote":"\u003cp\u003e\u0026#8220;The benefits of migrating to StarTree and Pinot center around three areas: query performance, SLAs, and cost. With Pinot, we are now in the subseconds to milliseconds range, the higher query concurrency means we can serve more customers faster, and we\u0026#8217;ve been able to reduce our infrastructure costs.\u0026#8221;\u003c/p\u003e\n","job_role":"CTO and Co-Founder","logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/18px-amberdata_logo-dark.svg","alt":"18px Amberdata Logo Dark","width":141,"height":18},"inverted_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/amberdata_logo_white.svg","alt":"Amberdata Logo White","width":564,"height":72},"avatar":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/Amberdata-Joanes-Espanol.jpg","alt":"Amberdata Joanes Espanol","width":130,"height":130},"name":"Joanes Espanol"}}],"is_dark":true}]}],"padding_top":"160","padding_bottom":"80","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"subheading":"features","heading":"Perform upserts for millions of rows per second","content":"\u003cp\u003eAchieve real-time data insights with scalable, efficient storage.\u003c/p\u003e\n","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"custom","custom_heading_max_width":"700","content_font_size":"18","content_font_color":"ocean","content_max_width":"custom","custom_content_max_width":"460","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"content","content":[{"acf_fc_layout":"sticky_nav_and_card_scroll","cards":[{"label":"Deletes","heading":"Deletes","content":"\u003cp\u003eRemove obsolete data from your database that you don’t want to see in future queries. Once our real-time engine encounters a record with a delete column, the primary key will no longer be part of queryable documents — saving you headaches.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/deletes_upserts.svg","alt":"Deletes Upserts","width":464,"height":460}}},"theme":"green_blue"},{"label":"Partial upserts","heading":"Partial upserts","content":"\u003cp\u003eUpdate some of the fields in a record, but not all of them. Partial upserts enable flexible handling of data streams with partial information — perfect for Change Data Capture (CDC) streams where only updated columns are received.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/partial_upserts.svg","alt":"Partial Upserts","width":464,"height":460}}},"theme":"red_blue"},{"label":"Compaction","heading":"Compaction","content":"\u003cp\u003eMinimize disk space and overall infrastructure costs by periodically replacing obsolete records in your database with newer compacted segments that only contain valid records.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/compaction_upserts.svg","alt":"Compaction Upserts","width":464,"height":460}}},"theme":"purple"},{"label":"comparison column","heading":"Configurable comparison column","content":"\u003cp\u003eSelect a different time column for resolving upserts, rather than using the default. Perfect for when you need to prioritize records based on a different timestamp — not the most up-to-date record.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/comparison_upserts.svg","alt":"Comparison Upserts","width":464,"height":460}}},"theme":"green_grey"},{"label":"Bootstrap and backfill","heading":"Bootstrap and backfill","content":"\u003cp\u003eEfficiently bootstrap (initialize) and backfill (update past data) into an upsert-enabled table, using a batch data pipeline to directly upload segments.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/10/bootstrap_upserts.svg","alt":"Bootstrap Upserts","width":464,"height":460}}},"theme":"yellow_grey"}]}]}],"id":"features","padding_top":"80","padding_bottom":"80","inner_spacing":"96","has_container":true,"overflow":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"resources","resources":[{"acf_fc_layout":"preview_three_column","subheading":"resources for upserts","posts":[{"ID":4355,"post_title":"Dialpad Powers Real-Time Customer Intelligence with StarTree Cloud","permalink":"/user-stories/dialpad-powers-real-time-customer-intelligence-with-startree-cloud","acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/The-Dialpad-product-is-an-AI-powered-platform.png","alt":"The Dialpad product is an AI powered platform","width":1200,"height":630},"heading":"Dialpad Powers Real-Time Intelligence with StarTree","theme":"yellow_blue"},"logos":{"dark_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/24px-dialpad_logo-dark.svg","alt":"24px Dialpad Logo Dark","width":103,"height":25}},"stats":{"stats":[{"stat":"10,000s","supporting_content":"of live users"},{"stat":"500 ms","supporting_content":"p95 latencies"},{"stat":"98%","supporting_content":"lower latencies"}]}},"use_case":[{"id":7,"name":"Business Metrics Monitoring","slug":"business-metrics-monitoring","acf":{"icon":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Analytics.svg","alt":"Analytics","width":32,"height":32}}}],"industry":[{"id":34,"name":"Telecommunications","slug":"telecommunications"}]},{"ID":6009,"post_title":"Scaling Upserts Efficiently: How StarTree Delivers Real-Time Performance for Modern Analytics","permalink":"/resources/scaling-upserts-efficiently-with-startree","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"theme":"blue_purple"},"layout":"post"}},{"ID":1832,"post_title":"Real-Time Upserts in Apache Pinot and StarTree Cloud","permalink":"/resources/real-time-upserts-in-apache-pinot-and-startree-cloud","categories":[{"id":3,"name":"Blog","slug":"blog"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/1697675458-real-time-upserts-blog-preview.png","alt":"1697675458-real-time-upserts-blog-preview.png","width":1920,"height":1080},"theme":"yellow_blue"},"layout":"post"}}]}]}],"padding_top":"120","padding_bottom":"80","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"subheading":"keep exploring","heading":"The most powerful real-time analytics platform","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"max-w-2xl","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"use_case_grid","cards":[{"link":{"title":"Tiered Storage","url":"/products/tiered-storage"},"heading":"Simplified tiered storage","content":"Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/tiered_storage-horizontal-v1.svg","alt":"Tiered Storage Horizontal V1","width":626,"height":236},"theme":"ocean_river","width":"7"},{"link":{"title":"Indexing","url":"/products/indexing"},"heading":"Powerful, flexible indexing","content":"Harness extensive indexing to analyze your data, any way you want. Unlike other techniques which work on a single column, the star-tree index is built on multiple columns, using pre-aggregated results.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Simplified-Tiered-Storage-1.png","alt":"Simplified Tiered Storage 1","width":968,"height":532},"width":"5"},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine"},"heading":"Multi-stage query engine","content":"Trust StarTree to handle your multi-stage data processing. Run complex SQL queries without sacrificing blazing fast query performance. And gain the business insights your teams need, in real-time.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/real-time-upserts.svg","alt":"Real Time Upserts","width":588,"height":580},"width":"6"},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions"},"heading":"Autoscaling minions","content":"Save costs on your cloud infrastructure with auto scaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Auto-scaling-minions-2.png","alt":"Auto Scaling Minions 2","width":1176,"height":902},"theme":"jade","width":"6"}]}]}],"padding_top":"80","padding_bottom":"160","inner_spacing":"120","has_container":true,"background":{"background_color":"white"}}],"seo":{"title":"Real-Time Upserts | Startree","description":"Quickly and easily ingest upserts into your real-time analytics database for accurate, up-to-date business insights with StarTree Cloud."},"featured_image":{"width":1120,"height":600}},"postListing":{},"options":{"menu":{"header_links":[{"link":{"title":"Platform","url":"/products/startree-cloud","target":""},"has_submenu":true,"submenu":{"submenu_type":"platform","platform":{"nav":[{"heading":"","links":[{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""},"description":"Explore StarTree ThirdEye.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Anomaly-Detection.svg","alt":"Anomaly Detection","width":44,"height":44},"layout":""}]},{"heading":"Features","links":[{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""},"description":"Perform inserts \u0026 updates.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Real-Time-Updates.svg","alt":"Real Time Updates","width":44,"height":44},"layout":""},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""},"description":"Analyze all your data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Tiered-Storage.svg","alt":"Tiered Storage","width":44,"height":44},"layout":""},{"link":{"title":"Indexing","url":"/products/indexing","target":""},"description":"Create flexible indexes.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Indexing.svg","alt":"Indexing","width":44,"height":44},"layout":""},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""},"description":"Run complex SQL queries.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Multi-stage-query-engine.svg","alt":"Multi Stage Query Engine","width":44,"height":44},"layout":""},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""},"description":"Save costs on your infra.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Auto-scaling-minions.svg","alt":"Auto Scaling Minions","width":44,"height":44},"layout":""},{"link":{"title":"Fast \u0026 Scalable Data Ingestion","url":"/products/data-manager","target":""},"description":"Explore StarTree Data Manager.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/data_manger_icon-bkg.svg","alt":"Data Manger Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"Technology","links":[{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""},"description":"Enterprise-grade security.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Security.svg","alt":"Security","width":44,"height":44},"layout":""},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""},"description":"BYoC or use our SaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Deployment-options.svg","alt":"Deployment Options Icon","width":44,"height":44},"layout":""},{"link":{"title":"Technology Partners","url":"/partners","target":""},"description":"AWS, Google Cloud \u0026 Azure.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Partners.svg","alt":"Partners","width":44,"height":44},"layout":""}]}],"featured_link":{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""},"description":"Meet StarTree Cloud, the fully-managed DBaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Frame-1948759746-1.svg","alt":"Frame 1948759746","width":304,"height":281},"layout":"platform"}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Solutions","url":"/#","target":""},"has_submenu":true,"submenu":{"submenu_type":"solutions","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":[{"heading":"By Industry","links":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""},"description":"Build personal finance products.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fintech.svg","alt":"Fintech","width":44,"height":44},"layout":""},{"link":{"title":"Transportation, Delivery, \u0026 Rideshare","url":"/solutions/delivery-and-ridesharing","target":""},"description":"Power your location-based services.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/devliery-rideshare_icon-bkg.svg","alt":"Devliery Rideshare Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Retail","url":"/solutions/retail","target":""},"description":"Understand shopping habits.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Shopping.svg","alt":"Shopping","width":44,"height":44},"layout":""},{"link":{"title":"Human Resources","url":"/solutions/hr","target":""},"description":"Enhance employee experiences.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_icon-bkg.svg","alt":"Hr Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""},"description":"Deliver hyper-personalized gaming analytics.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/gaming_icon-bkg.svg","alt":"Gaming Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""},"description":"Provide personalized patient care.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/healthcare_icon-bkg.svg","alt":"Healthcare Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"By use case","links":[{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""},"description":"Detect fraud in real-time.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fraud-detection.svg","alt":"Fraud Detection","width":44,"height":44},"layout":""},{"link":{"title":"Business Metrics Monitoring","url":"/solutions/business-metrics-monitoring","target":""},"description":"Track key performance indicators.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Analytics.svg","alt":"Analytics","width":44,"height":44},"layout":""},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""},"description":"Tailor products with real-time data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Personalisation.svg","alt":"Personalisation","width":44,"height":44},"layout":""}]}]},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"For Developers","url":"https://dev.startree.ai/","target":""},"has_submenu":true,"submenu":{"submenu_type":"developers","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":{"title":"Docs","url":"https://dev.startree.ai/docs","target":"_blank"},"description":"Start building your real-time analytics application.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Group-64280.svg","alt":"Group 64280","width":199,"height":280},"layout":"devs"},"links":[{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"},"description":"Get first-rate support from dedicated engineers.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621.jpg","alt":"Frame 1948759621","width":844,"height":492},"layout":""},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"},"description":"Join our real-time community.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621-1.jpg","alt":"Frame 1948759621 1","width":844,"height":492},"layout":""}]},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Resources","url":"/resources","target":""},"has_submenu":true,"submenu":{"submenu_type":"resources","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":{"title":"User Stories","url":"/user-stories","target":""},"description":"Meet the leading companies who use StarTree and Apache Pinot.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_slider-image-v1.png","alt":"Hr Slider Image V1","width":2400,"height":1434},"layout":"resources"},"nav":[{"link":{"title":"Blog","url":"/resources/category/blog/","target":""},"description":"Explore articles, guides \u0026 content.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Blog.svg","alt":"Blog","width":44,"height":44},"layout":""},{"link":{"title":"Videos","url":"/resources/category/videos/","target":""},"description":"Learn more with walkthroughs.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Video.svg","alt":"Video","width":44,"height":44},"layout":""},{"link":{"title":"Glossary","url":"/glossary/","target":""},"description":"Your real-time analytics 101.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Glossary.svg","alt":"Glossary","width":44,"height":44},"layout":""},{"link":{"title":"Webinars","url":"https://startree.ai/resources/tag/webinar","target":""},"description":"Sign up to an online webinar. ","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Webinars.svg","alt":"Webinars","width":44,"height":44},"layout":""},{"link":{"title":"Events","url":"https://startree.ai/resources/category/events-webinars","target":""},"description":"Attend a StarTree event.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Event.svg","alt":"Event","width":44,"height":44},"layout":""},{"link":{"title":"StarTree All-Stars","url":"https://dev.startree.ai/community/all-stars","target":"_blank"},"description":"Join our real-time community.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/All-star.svg","alt":"All Star","width":44,"height":44},"layout":""},{"link":{"title":"RTA Summit","url":"https://startree.ai/rta-summit","target":""},"description":"Attend Real-Time Analytics Summit.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/11/64x64-rtas_icon-bkg.svg","alt":"64x64 Rtas Icon Bkg","width":44,"height":44},"layout":""}]}}},{"link":{"title":"Partners","url":"/partners","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Pricing","url":"/pricing","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}}]},"cta":{"heading":"Ready to deploy real-time analytics?","content":"\u003cp\u003eStart for free or book a demo with our team.\u003c/p\u003e\n","button_link":{"title":"Start for free","url":"/saas-signup","target":""},"text_link":{"title":"Book a demo","url":"/demo","target":""},"stats":[{"stat":"20,000","supporting_content":"QPS"},{"stat":"\u003c1s","supporting_content":"query latency"},{"stat":"Petabyte","supporting_content":"data scale"}]},"footer":{"footer_links":[{"heading":"Platform","nav":[{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""}},{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""}},{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""}},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""}},{"link":{"title":"Indexing","url":"/products/indexing","target":""}},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""}},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""}},{"link":{"title":"Integrations","url":"/products/data-manager","target":""}},{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""}},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""}},{"link":{"title":"Partner","url":"/partners","target":""}},{"link":{"title":"Pricing","url":"/pricing","target":""}}]},{"heading":"Industries","nav":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""}},{"link":{"title":"Retail","url":"/solutions/retail","target":""}},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""}},{"link":{"title":"Delivery \u0026 Ridesharing","url":"/solutions/delivery-and-ridesharing","target":""}},{"link":{"title":"Human Resources","url":"/solutions/human-resources","target":""}},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""}}]},{"heading":"Use cases","nav":[{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""}},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""}},{"link":{"title":"Business Metrics\u2028Monitoring","url":"/solutions/business-metrics-monitoring","target":""}}]},{"heading":"For Developers","nav":[{"link":{"title":"Docs","url":"https://dev.startree.ai/docs/","target":"_blank"}},{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"}},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"}}]},{"heading":"Resources","nav":[{"link":{"title":"User Stories","url":"/user-stories","target":""}},{"link":{"title":"Blog","url":"/resources/category/blog","target":""}},{"link":{"title":"Videos","url":"/resources/category/videos","target":""}},{"link":{"title":"Glossary","url":"/glossary","target":""}},{"link":{"title":"Events \u0026 Webinars","url":"/resources/category/events-webinars","target":""}},{"link":{"title":"Fundamentals","url":"/resources/category/fundamentals","target":""}},{"link":{"title":"RTA Summit","url":"/rta-summit","target":""}},{"link":{"title":"StarTree All-Stars","url":"/all-stars","target":""}}]},{"heading":"Company","nav":[{"link":{"title":"About","url":"/about","target":""}},{"link":{"title":"Careers","url":"/careers","target":""}},{"link":{"title":"Press","url":"/news","target":""}},{"link":{"title":"Contact","url":"/contact-us","target":""}},{"link":{"title":"Legal","url":"/legal","target":""}},{"link":""}]}],"newletter":{"heading":"Get the latest updates"},"legal_links":[{"link":{"title":"Trademark Policy","url":"/startree-trademark-policy","target":""}},{"link":{"title":"Privacy Policy","url":"/privacy-policy","target":""}},{"link":{"title":"Terms of Use","url":"/terms-conditions","target":""}},{"link":{"title":"Responsible Disclosure","url":"/responsible-disclosure","target":""}}],"socials":[{"logo":"linkedin","url":"https://www.linkedin.com/company/startreedata/"},{"logo":"youtube","url":"https://www.youtube.com/startreedata"},{"logo":"x","url":"https://twitter.com/startreedata"}],"logo":{"logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/svg-223107605-1699873195.svg","alt":"Svg 223107605 1699873195","width":80,"height":80}},"copyright_text":"StarTree Inc. All rights reserved."},"links":{"login":{"title":"Login","url":"https://startree.cloud/login","target":"_blank"},"start_for_free":{"title":"Start for free","url":"/saas-signup/","target":""},"demo":{"title":"Book a demo","url":"/demo/","target":""}}}},"__N_SSG":true},"page":"/[...slug]","query":{"slug":["products","real-time-upserts"]},"buildId":"fjFePtEzv4OGhiMlhwN32","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[79114,76442],"gsp":true,"scriptLoader":[]}</script></body></html>