dmoore's picture
Company:
Country:
Personal Website:
Day Job:
blog icon Recent Articles

Maybe your company is thinking of opening a new branch office if there are enough customers who live within the target area. Or maybe you want to let your customers know which of your stores they are closest to. Maybe you want to investigate the routes your delivery trucks take.

If it’s time for you to start understanding your organization’s location data in a different way, there’s a lot you can do with Teradata’s geospatial support.

More than likely, you need to keep track of the beginning and ending of some kind of an event. Maybe you track how long employees have been with your company, how much time users spend on a particular web site, or the duration of insurance policies.

In other words, you need to track temporal data. And you probably use a couple of DATE or TIME or TIMESTAMP columns to do just that.

Consider the following employee table that tracks the job duration of employees by using two DATE columns: start_date and end_date.

blog icon Recent Reference

dmoore hasn't created any reference articles.