The Cyrptocurrency Craze

Voice-Controlled Assistants

Dealing with a Future Without Jobs

Why You Need a Virtual Private Network

How Do You Feel About Being a Cyborg?

Why Artificial Intelligence Is Scary

Google Lens, Amazon Echo, and More Toys

Algorithms Are Us

Best Ways to Spot Fake News

More Options for Cable Cutters

Artificial Intelligence & Neural Nets

Beware of Fake News

Amazon Echo Dot

Driverless Cars Coming Soon

Governments Approve Commercial Drones

The Sharing Economy in Southeastern Iowa

Ad Blocker for Your Web Browser

Virtual Assistants: Siri, Cortana, Alexa

Google Cardboard: Cheap Virtual Reality

Periscope Addiction

Pet, Kid, Keychain Traciers

Google Tips and Tricks

Use Price Alerts to Save Money

Best Gadgets of 2015

Apple TV, Streaming Video Devices

My Favorite Email Newsletters

Peer-to-Peer Lending

3-D Printing

Chromebook, a $150 Laptop

Periscope: Live Video from Around the World

Get Your Questions Answered on Quora

Sling TV — $20 per Month

The Drone Revolution

Bitcoin Mining Flop

Smart Light Bulbs

Revolutionary Apple Watch

Smart Home Gadgets

Buying a Bitcoin Miner

Traveling with Siri

The Sharing Economy: Uber, Airbnb

Storing Your Music in the Cloud

The Internet of Things

Life in Cloud Heaven

2013 Tablet Buyers Guide

What Marketers Know About You

Google Dashboard Knows About You

Stream Video with Google Chromecast

Big Data, NSA, and You

Google's Predictive Search

Bitcoin—Mint Your Own Money

Android Smart TV via $45 Mini PC

MOOCs: Quality Free Online Courses

Beware of Dynamic Pricing

Use Crowdfunding to Raise Money

Tablet Computer Buyer's Guide

Google's Self-Driving Car

Mobile Media/App Stores Compared

Google Nexus 7 vs iPad

Email Follies

Your Million-Dollar Smartphone

Google Drive: Free Cloud Storage

Free and Low-Cost Phone Calls

Google Glasses

Loving iCloud

iPad Wins, Other Tablets Lose

Siri is Revolutionary

Essentials of Computer Backup

Homage to Steve Jobs

Are Your Files Safe in the Cloud?

Amazing Uses of iPhone Camera

Use Carbonite Online Backup

Cloud Services Roundup

Tablet Computer Roundup

Project Watson Wins at Jeopardy

Stream Video by Connecting a Computer to Your TV

The Appeal of Apple TV

Roundup of Streaming TV Devices

Options for Streaming Video to a TV

Dealing with Cell Phone Radiation

Ebook Readers & Tablet Computers

Dreaming of 4G

Google TV

The iPad in Your Future

The Magic of Google Translate

iPhone: There's an App for That

3-D TV and Robots in Your Future

More Goodies from Google

Google Wave — Better than E-mail

Growing Up with the Internet

Bing: Better than Google

Google Voice — Great free service

The Twitter Revolution

Virtualization and You

Death of Newspapers

Netbook Computers

Great New Search Engines

Boxee — Free Online TV

Mozy — Free Offsite Backup

Amazon's Video-on-Demand

Wanting a Kindle

iPhone Love

Better than Google

Cloud Computing and MobileMe

Digg and Other Social Media Sites Free TV & Movies

Pandora: Best Source for Streaming Music

Cell Phones Changing

Intro to HDTV

Best Free Phone Resources

Free Online TV: Joost

Movies, TV Go Online

Scary Internet Stories


The YouTube Election

Google Street View

Twitter, Twittervsion, and Flickervision fun

E-mail Tricks for Addicts

Cool PDA Phones

Webtop: Free Online Software

Useful Google Tidbits

My Yahoo, RSS, and Blogs

Google Earth

Online Videos

Web 2.0


Virtual Worlds: Second Life

InTrade Predicts the Future

The MySpace Revolution

Wikipedia — A Free Encyclopedia

Wikipedia as Emergent Phenomenon

Wikipedia Lies

Free Calling with Skype

Intro to Podcasts

Intro to File Sharing: BitTorrent

Dangers of Wireless Hotspots

Google Maps

Free Online Credit Reports

Making Money with Your Web Site

Beware of Spoofing and Phishing

Free Virus and Spyware Protection

Virus, Spyware Protection -- Part 2

A Brief History of the Internet

The Gadget Goddess

Free Open Source Software

Keeping Your Mac Tuned Up

Starting a Weblog

Getting Started with RSS

Latest Google Features

Selling on eBay &

Safe Online Shopping

Health-Related Web Sites

Free Virus Protection

Google Culture

Online Photo Sharing

Intro to GPS

Intro to Weblogs

Avoiding Spyware

Loving Google News

Testing your Internet Literacy

Urban Legends and Hoaxes

Buying and Selling on

Personalizing Yahoo

Stopping Spam

Useful New Search Engines

Conspiracy Theories

Online Nature Guides

Intro to Wireless

Yahoo Groups Are Fun and Useful

The Joys of Broadband

Free Expert Help

Asking questions online

Finding the lowest price

Movie information

Online Reference


The Internet bazaar

MP3 music

Noah's Ark and the Internet

Link Rot

The Geek Report

About this site

Today's News and weather

Hot tips


Honoring Fred Rosenberg, Database Administrator

March 2018

You probably haven't thought much about what happens when you make a phone call. Neither did I until my friend and tennis partner Fred Rosenberg explained it. I was fascinated, and for years had planned to get a few more details from him so I could share it with you. But now he's gone, having recently died unexpectedly. He was in his late 60s and at the peak of his career, and his tennis game.

When you punch in the numbers to make a call, it opens a connection with a powerful computer called a switch that's operated by your phone company. The switch then routes your call across the phone network.

When you hang up, the switch notes the length of your call and creates a record in a database. But there's still more for the switch to do. It then needs to rate the call: that is, it needs to figure out how much to charge you and how much the call is costing the phone company.

Let's say you make a call to the UK. The switch looks up your account in a separate database and sees how much you pay for calls to the UK. (Different customers are charged different amounts: a corporate customer with 500 lines will likely be paying less for that call than you.)

The switch also needs to connect with a database of the network in the UK that handles your call, to see how much the company is paying the network to handle that call.

Here's the kicker: After Fred finished describing this to me, he said, "And all of this takes place in a fraction of a second."

Fred's job was to administer the call record database used for billing. The whole company, known as XCast Labs, which currently has about 30 employees and is headquartered in Los Angeles, depended on that database working. That level of responsibility would keep me awake at night, worrying that things would go wrong.

And they did go wrong. Often at our weekly tennis match Fred would tell me about the latest crisis.

There are actually two call record databases. One rates the calls in real-time, as they're made. This is a quick-and-dirty rating to track activity and send alerts of fraud if suddenly an account was making thousands of more calls than usual.

The other, which Fred administered, would access that real-time database at 2 a.m. every morning and download the previous day's call records. Fred's database would then rate all the calls again, but more thoroughly. For example, if a customer exceeded a specific data allotment on a cell phone account, this rating would know to charge for the overage. Plus, it would add in any extra surcharges, and calculates taxes.

So what could go wrong? One challenge Fred faced was simply the growth of the company. His database was rating perhaps 5 million call records a day when we first talked about it. But then that came close to doubling, and his server was only capable of rating 10 million calls in 24 hours. If there were more than 10 million calls, then he'd be in trouble because they'd already be in the next 24-hour period but would still be rating the previous batch of calls.

Because they're a small company, adding an additional server is a big expense. Instead Fred would try to figure out how to make his database more efficient, so it could rate more calls in a 24-hour period. And he did. Sometimes his experiments would break things, but then he'd get it working again.

Still the volume increased, and so the company eventually bought a second server, which could in theory handle an additional 10 million per day. But you can't have two separate databases. Fred's next challenge was to figure out how to make those two servers work in concert. After trying various approaches, he got it to work seamlessly.

But still the volume increased. Soon they were bumping up against 20 million per day. Fred then came up with his most elegant solution yet. The brains of their servers each had 16 cores – almost as if there were 16 separate processors. Because today's chips are reaching the speed limit for silicon technology, chipmakers have increased power by using multiple cores.

But software often can't take advantage of this extra power. Fred figured it out, though. He found a way to set up the server so that a sub-group of cores would act like a single computer. In essence, a single server was now like four different computers, with each capable of rating 10 million calls in 24 hours. Suddenly the company had much more capacity. Which was good, because at the time of Fred's passing, they were handling over 30 million calls a day.

Fred was a hero, working quietly in the background to keep the call record database humming so that the monthly billing could go off without a hitch.

If Fred's small company handles over 30 million calls a day, imagine the volume a much larger company would be handling. And imagine similar huge databases in other industries around the world. Working quietly in the background behind each enterprise are the Freds of the world. I salute them, and I salute Fred.

© 2018 by Jim Karpen, Ph.D.

E-mail Jim Karpen

In Association with


Learn More Click Here to Pay



Hosted by the webmasters at:

Start here to find it FAST!(TM)

PayPal Fraud, Part 1

Internet Fraud, Part 2

Internet Fraud, Part 3

Suing My Credit Card Company

Bored.Com is fun

Best source for news

Guinness World Records

Tellme voice portal

eHow.Com tells you how

Free graphics online

Low-cost movies, software

Cheap airfares

Simple, free money transfer

Government information