Column by your name: The analytics database that skips the rows

Column by your name: The analytics database that skips the rows

These days, every company looking at analyzing their data for insights has a data pipeline setup. Many companies have a fast production database, often a NoSQL or key-value store, that goes through a data pipeline.The pipeline process performs some sort of extract-transform-load process on it, then routes it to a larger data store that the analytics tools can access. But what if you could skip some steps and speed up the process with a database purpose-built for analytics?

On this sponsored episode of the podcast, we chat with Rohit (Ro) Amarnath, the CTO at Vertica, to find out how your analytics engine can speed up your workflow. After a humble beginning with a ZX Spectrum 128, he’s now in charge of Vertica Accelerator, a SaaS version of the Vertica database.

Vertica was founded by database researcher Dr. Michael Stonebreaker and Andrew Palmer. Dr. Stonebreaker helped develop several databases, including Postgres, Streambase, and VoltDB. Vertica was born out of research into purpose-built databases. Stonebreaker’s research found that columnar database storage was faster for data warehouses because there were fewer read/writes per request.

Here’s a quick example that shows how columnar databases work. Suppose that you want all the records from a specific US state or territory. There are 52 possible values here (depending on how you count territories). To find all instances of a single state in a row-based DB, the search must check every row for the value of the state column. However, searching by column is faster by an order of magnitude: it just runs down the column to find matching values, then retrieves row data for the matches.

The Vertica database was designed specifically for analytics as opposed to transactional databases. Ro spent some time at a Wall Street firm building reports—P&L, performance, profitability, etc. Transactions were important to day-to-day operations, but the real value of data came from analyses that showed where to cut costs or increase investments in a particular business. Analytics help with overall strategy, which tends to be more far-reaching and effective.

For most of its life, Vertica has been an on-premises database managing a data warehouse. But with the ease of cloud storage, Vertica Accelerator is looking to give you a data lake as a service. If you’re unfamiliar, data lakes take the data warehouse concept—central storage for all your data—and remove limits. You can have “rivers” of data flowing into your stores; if you go from a terabyte to a petabyte overnight, your cloud provider will handle it for you.

Vertica has worked with plenty of industries that push massive amounts of data: healthcare, aviation, online games. They’ve built a lot of functionality into the database itself to speed up all manner of applications. One of their prospective customers had a machine learning model with thousands of lines of code that was reduced to about ten lines because so much was being done in the database itself.

In the future, Vertica plans to offer more powerful management of data warehouses and lakes, including handling the metadata that comes with them. To learn more about Vertica’s analytics databases, check out our conversation or visit their website.

See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

Jaksot(865)

Democratizing your data access with AI agents

Democratizing your data access with AI agents

Jeff Hollan, director of product at Snowflake, joins Ryan to discuss the role that data plays in making AI and AI agents better. Along the way, they discuss how a database leads to an AI platform, Snowflake’s new data marketplace, and the role data will play in AI agents. Episode notes:Snowflake provides a fully-managed data platform that developers can build AI apps on. We’re happy to have Stack Exchange data available on the Snowflake Marketplace. Connect with Jeff on LinkedIn and Twitter. Congrats to Timeless for throwing a Lifejacket to Using pandas to read HTML.TRANSCRIPTSee Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

23 Syys 29min

Off with your CMS’s head! Composability and security in headless CMS

Off with your CMS’s head! Composability and security in headless CMS

Ryan welcomes Sebastian Gierlinger, VP of Engineering at Storyblok, to talk about how headless content management systems (CMS) fit into an increasingly componentized software landscape. They run through the differences between headless and traditional CMS systems (and databases), prototyping and security concerns, and how a team building distributed systems can get that precious velocity by decoupling their content from its rendering. Episode notes:Storyblok provides a headless CMS they say is made for humans but built for the AI-driven era. Want to learn more about CMS design? Check out other pieces we’ve done with CMS providers Drupal and Builder.io. Connect with Sebastian on LinkedIn or Twitter. Congrats to Populist badge winner Răzvan Flavius Panda for dropping an amazing answer on How do I change the maintenance database for Postgres?.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

19 Syys 23min

What an MCP implementation looks like at a CRM company

What an MCP implementation looks like at a CRM company

Ryan chats with  Karen Ng, EVP of Product at HubSpot, to chat about Model Context Protocol (MCP) and how they implemented it for their server for their CRM product. They chat the emergence of this as the standard for agentic interactions, the challenges of implementing the server and integrating it with their ecosystem, and how agentic AI has affected work at Hubspot. Episode notes:Hubspot is a customer-relationship management (CRM) platform that aims to help businesses grow. MCP is an open-source protocol for connecting AI agents to external systems, originally developers at Anthropic. Connect with Karen on LinkedIn. Virtual hi-five to Rob Truxal for asking What is the purpose of "pip install --user ..."? and garnering themselves a Stellar Question badge. See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

16 Syys 24min

Planning to Arm mobile devices with chips that handle AI

Planning to Arm mobile devices with chips that handle AI

Ryan welcomes Geraint North, AI and developer platforms fellow at Arm, to dive into the impact of GenAI on chip design, Arm’s approach to designing flexible CPU architectures, and the challenges of optimizing large language models at the chip level for edge devices. Episode notes: Arm is a global compute platform that allows the world’s leading technology companies to innovate and deliver AI experiences.Arm just announced their Lumex CSS Platform, which provides a complete compute subsystem platform for mobile and desktop providers to enable efficient AI workloads. Connect with Geraint on LinkedIn.Congrats to Lifejacket badge winner I.sh., who won the badge for answering How to take screenshot on failure.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

12 Syys 32min

How AI is reshaping developer teams and the future of software development

How AI is reshaping developer teams and the future of software development

In this two-part episode of Leaders of Code, Peter O’Connor, Director of Platform Engineering, welcomes Ryan J. Salva, Senior Director of Product at Google, Developer Experiences, for a deep dive into the future of software development. They explore how AI-assisted tools are reshaping the developer experience, going far beyond just writing code. From breaking down deployment bottlenecks to streamlining operations and transforming how teams collaborate, this conversation unpacks where developer tooling is headed and how AI is changing the game at every stage of the software lifecycle.The discussion also:Addresses how AI is transforming team structures, enabling engineering teams to operate effectively with just a few people, reducing collaboration overhead and accelerating decision-making.Highlights the future of platform engineering and DevOps, where AI will assist with standardization and dynamically create and manage deployment pipelines in real time.Episode notes:Connect with Peter O’Connor and Ryan J Salva.Check out Google’s open source repository, Gemini-CLI, on GitHub.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

11 Syys 31min

We built stackoverflow.ai with the community and for the community

We built stackoverflow.ai with the community and for the community

Ryan is joined by our very own Ash Zade, Product Manager, and Alex Warren, Staff Software Engineer, to discuss our newly released stackoverflow.ai, how it’s enhancing user experience by combining human-validated answers with AI, and our future plans for deeper personalization and community integration. Episode notes: stackoverflow.ai is helping you get the technical answers you need with less friction, all powered by our 16 years of community knowledge.Connect with Ash on LinkedIn.Connect with Alex on LinkedIn.This week we’re shouting out user Ketan Ramani for winning a Populist badge for their answer to How to go about formatting 1200 to 1.2k in Android studio.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

9 Syys 33min

Kotlin is more than just the Android house language

Kotlin is more than just the Android house language

Ryan welcomes Jeffrey van Gogh, Director of Engineering, Android Developer Experience, at Google and board member of the Kotlin Foundation. They discuss the evolution of the Kotlin language from JVM to multiplatform, how their governance board works with the community to stop breaking changes, and the intricacies of Kotlin’s multiplatform capabilities beyond just Android.Episode notes: The Kotlin Foundation’s mission is to protect, promote, and advance the development of the Kotlin programming language.Over half of respondents in this year’s Annual Developer Survey reported that they want to start using Kotlin in the next year. Connect with Jeffrey on LinkedIn or email him at jvg@google.com.Congrats to user BMac on winning a Populist badge for answering the question How to convert UPPERCASE text to Title Case using CSS.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

5 Syys 30min

Building AI for consumer applications isn’t all fun and games

Building AI for consumer applications isn’t all fun and games

Kylan Gibbs, CEO of Inworld, joins the show to discuss the technical challenges of creating interactive AI for virtual worlds and games, the significance of user experience, and the importance of accessibility and cost-efficiency in deploying AI models.Episode notes: Inworld provides solutions for AI applications that allow teams to build and deploy workloads, spend less time on maintenance, and accelerate iteration speed.Connect with Kylan on LinkedIn.Today we’re shouting out the winner of an Illuminator badge, user MrWhite, who edited and answered 500 questions, both actions within 12 hours.See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

2 Syys 29min

Suosittua kategoriassa Liike-elämä ja talous

sijotuskasti
mimmit-sijoittaa
psykopodiaa-podcast
rss-rahapodi
puheenaihe
rss-rahamania
ostan-asuntoja-podcast
pomojen-suusta
rss-uppoava-vn-laiva
hyva-paha-johtaminen
taloudellinen-mielenrauha
rss-ysin-muijat
rss-seuraava-potilas
rss-paasipodi
inderespodi
herrasmieshakkerit
syo-nuku-saasta
oppimisen-psykologia
rss-startup-ministerio
rss-myyntikoulu