Podbean logo
  • Discover
  • Podcast Features
    • Podcast Hosting

      Start your podcast with all the features you need.

    • Podbean AI Podbean AI

      AI-Enhanced Audio Quality and Content Generation.

    • Blog to Podcast

      Repurpose your blog into an engaging podcast.

    • Video to Podcast

      Convert YouTube playlists to podcasts, videos to audios.

  • Monetization
    • Ads Marketplace

      Join Ads Marketplace to earn through podcast sponsorships.

    • PodAds

      Manage your ads with dynamic ad insertion capability.

    • Apple Podcasts Subscriptions Integration

      Monetize with Apple Podcasts Subscriptions via Podbean.

    • Live Streaming

      Earn rewards and recurring income from Fan Club membership.

  • Podbean App
    • Podcast Studio

      Easy-to-use audio recorder app.

    • Podcast App

      The best podcast player & podcast app.

  • Help and Support
    • Help Center

      Get the answers and support you need.

    • Podbean Academy

      Resources and guides to launch, grow, and monetize podcast.

    • Podbean Blog

      Stay updated with the latest podcasting tips and trends.

    • What’s New

      Check out our newest and recently released features!

    • Podcasting Smarter

      Podcast interviews, best practices, and helpful tips.

  • Popular Topics
    • How to Start a Podcast

      The step-by-step guide to start your own podcast.

    • How to Start a Live Podcast

      Create the best live podcast and engage your audience.

    • How to Monetize a Podcast

      Tips on making the decision to monetize your podcast.

    • How to Promote Your Podcast

      The best ways to get more eyes and ears on your podcast.

    • Podcast Advertising 101

      Everything you need to know about podcast advertising.

    • Mobile Podcast Recording Guide

      The ultimate guide to recording a podcast on your phone.

    • How to Use Group Recording

      Steps to set up and use group recording in the Podbean app.

  • All Arts Business Comedy Education
  • Fiction Government Health & Fitness History Kids & Family
  • Leisure Music News Religion & Spirituality Science
  • Society & Culture Sports Technology True Crime TV & Film
  • Live
  • How to Start a Podcast
  • How to Start a Live Podcast
  • How to Monetize a podcast
  • How to Promote Your Podcast
  • How to Use Group Recording
  • Log in
  • Start your podcast for free
  • Podcasting
    • Podcast Features
      • Podcast Hosting

        Start your podcast with all the features you need.

      • Podbean AI Podbean AI

        AI-Enhanced Audio Quality and Content Generation.

      • Blog to Podcast

        Repurpose your blog into an engaging podcast.

      • Video to Podcast

        Convert YouTube playlists to podcasts, videos to audios.

    • Monetization
      • Ads Marketplace

        Join Ads Marketplace to earn through podcast sponsorships.

      • PodAds

        Manage your ads with dynamic ad insertion capability.

      • Apple Podcasts Subscriptions Integration

        Monetize with Apple Podcasts Subscriptions via Podbean.

      • Live Streaming

        Earn rewards and recurring income from Fan Club membership.

    • Podbean App
      • Podcast Studio

        Easy-to-use audio recorder app.

      • Podcast App

        The best podcast player & podcast app.

  • Advertisers
  • Enterprise
  • Pricing
  • Resources
    • Help and Support
      • Help Center

        Get the answers and support you need.

      • Podbean Academy

        Resources and guides to launch, grow, and monetize podcast.

      • Podbean Blog

        Stay updated with the latest podcasting tips and trends.

      • What’s New

        Check out our newest and recently released features!

      • Podcasting Smarter

        Podcast interviews, best practices, and helpful tips.

    • Popular Topics
      • How to Start a Podcast

        The step-by-step guide to start your own podcast.

      • How to Start a Live Podcast

        Create the best live podcast and engage your audience.

      • How to Monetize a Podcast

        Tips on making the decision to monetize your podcast.

      • How to Promote Your Podcast

        The best ways to get more eyes and ears on your podcast.

      • Podcast Advertising 101

        Everything you need to know about podcast advertising.

      • Mobile Podcast Recording Guide

        The ultimate guide to recording a podcast on your phone.

      • How to Use Group Recording

        Steps to set up and use group recording in the Podbean app.

  • Discover
  • Log in
    Sign up free
Develpreneur: Become a Better Developer and Entrepreneur

Develpreneur: Become a Better Developer and Entrepreneur

Technology

The Rosetta Stone Pattern - A Common Format

The Rosetta Stone Pattern - A Common Format

2022-04-19
Download Right click and do "save link as"

Our new patterns include the rosetta stone.  This pattern provides a path to link disparate systems and their data formats.  It comes from the historical rosetta stone which was a multilingual text used to decipher ancient languages.  We use this as a sort of pathway to a common language for our application.

The Rosetta Stone Pattern Defined

Modern software often has multiple other systems that need to be integrated with.  That means we need to pass data back and forth.  The format and structure of the data we send can be challenging to map across multiple systems.  The rosetta stone pattern approaches this problem by designing a single format that all of our data will transform into or be exported from.  Thus, we always map to one set of data when pulling from other systems.  Likewise, we have one format we generate that other systems are provided.  

That avoids us having to map from each disparate system to every other system.  We create a hub and spoke rather than a mesh network.  Therefore, we have a dramatically reduced number of integration points that need to be addressed.  Also, we have a set format to convert new systems into. 

Applying The Pattern

There are two main ways to apply this pattern.  One can either build a master format that combines the data from all of the desired integration systems or build what the solution needs as the master.  The latter approach tends to be better as it focuses on the solution rather than other systems.  We also are driving the format and structure instead of reacting to other systems.  Finally, we have a static universal format that does not change based on external factors.

Challenges
Data types and labels are always a challenge for this pattern.  Date-related fields in particular have a number of challenges including time zone mappings and a multitude of formats.  When the central structure is created it helps to make it as similar as possible to the external systems.  However, organizations and lines of businesses use that data in different ways and often have different views of the related labels.
For example, take a field called "name."  That can be the name of many things and likely is helped by a qualifier.  The disparate systems may all have only one thing that is named in their data set while we have dozens.  The more external sets we have to inform our central creation, the better.
view more

More Episodes

How to Find Balance in Software Development
2025-07-10
Level Up Your Development Workflow: Declutter with AI for Better Focus and Cleaner Code
2025-07-08
Essential Habits for Software Developers: Practical Steps for Long-Term Success
2025-07-03
Building Better Developers with AI: Mastering Developer Feedback
2025-07-01
Winning Your First Developer Project: Lessons from Building Better Developers with AI
2025-06-26
Updating Developer Tools: Why It Matters More Than Ever
2025-06-24
Improving Team Collaboration in Software Development: Proven Strategies for Success
2025-06-19
Software Methodologies: Thrive in Agile, Waterfall & DevOps
2025-06-17
Solving Problems in Software Projects | Building Better Developers with AI
2025-06-12
Coding vs. Developing: What AI Reveals About Developer Growth
2025-06-10
Building Better Developers with AI: Season Premiere
2025-06-05
Building Better Businesses: Key Lessons from the Podcast
2025-06-03
Remote vs In-Office: Finding the Right Fit for Your Business
2025-05-29
Upgrading Your Business: Save Time And Improve Efficiency
2025-05-27
Why Retrospectives Matter: Learning from the Past to Build Better Businesses
2025-05-22
Business Tune-Up Checklist: How to Refresh, Refocus, and Reignite Mid-Year
2025-05-20
Impostor Syndrome: Simple Ways to Reclaim Your Confidence
2025-05-15
Off the Rails in Business: Reclaim Your Time and Sanity
2025-05-13
Reading the Room: The Leadership Skill That Sets You Apart
2025-05-08
How to Demo Your Product and Get Feedback That Matters
2025-05-06
  • ←
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • →
012345678910111213141516171819

Get this podcast on your
phone, FREE

Download Podbean app on App Store Download Podbean app on Google Play

Create your
podcast in
minutes

  • Full-featured podcast site
  • Unlimited storage and bandwidth
  • Comprehensive podcast stats
  • Distribute to Apple Podcasts, Spotify, and more
  • Make money with your podcast
Get started

It is Free

  • Podcast Services

    • Podcast Features
    • Pricing
    • Enterprise Solution
    • Private Podcast
    • The Podcast App
    • Live Stream
    • Audio Recorder
    • Remote Recording
    • Podbean AI
  •  
    • Create a Podcast
    • Video Podcast
    • Start Podcasting
    • Start Radio Talk Show
    • Education Podcast
    • Church Podcast
    • Nonprofit Podcast
    • Get Sermons Online
    • Free Audiobooks
  • MONETIZATION & MORE

    • Podcast Advertising
    • Dynamic Ads Insertion
    • Apple Podcasts Subscriptions
    • Switch to Podbean
    • YouTube to Podcast
    • Blog to Podcast
    • Submit Your Podcast
    • Podbean Plugins
    • Developers
  • KNOWLEDGE BASE

    • How to Start a Podcast
    • How to Start a Live Podcast
    • How to Monetize a Podcast
    • How to Promote Your Podcast
    • Mobile Podcast Recording Guide
    • How to Use Group Recording
    • Podcast Advertising 101
  • Support

    • Support Center
    • What’s New
    • Free Webinars
    • Podcast Events
    • Podbean Academy
    • Podbean Amplified Podcast
    • Badges
    • Resources
  • Podbean

    • About Us
    • Podbean Blog
    • Careers
    • Press and Media
    • Green Initiative
    • Affiliate Program
    • Contact Us
  • Privacy Policy
  • Cookie Policy
  • Terms of Use
  • Consent Preferences
  • Copyright © 2015-2025 Podbean.com