The Mashup App on iTunes

Subscribe to RSS Feed
Blog Archive

Entries in spatio-temporal database (2)


Time: A New Type of Data

The Mashup App allows you to annotate time information to the data in your personal database. So you can add time data to web, PDF, image, video, and audio content to describe when the content was created, approved, or deleted.

Many types of users such as historians, archivists, rescue workers, and archaeologists have a requirement to document the relationship of time and location to other types of data such as documents and images. The Mashup App supports modeling both time and location data directly in your personal database as well as attributes attached to other data such as web, image, video, audio, and PDF content.


With direct support for saving time directly into your personal database, you can associate a group of data as being related to a specific event or time period. A researcher or rescue worker in the field can therefore catalog not only what she discovered but also when and where she discovered them. Furthermore, she can define the origin time and not only the discovery time.

Computer researchers and database companies have spent decades trying to develop time support for enterprise databases. Databases with support for time are also known as temporal databases. Though needed for many advanced applications, these temporal capabilities have not received wide adoption because corporate users have widely differing requirements and the industry has not been able to standardize on a core set of temporal features. On the consumer side of computing, the desktop metaphor and its use of files and folders has limited users to file and folder creation and last modified times. For files and folders, you generally need to know when a file was created or modified to ensure that you have the most recent file in case you have duplicates. File times are also helpful if you forget a file's name and have to guess about the data in the file. A user has no realistic ability to document that the data in a file refers to a certain time period or calendar event and is unrelated to the file and folder time. In temporal databases, this problem is sometimes refered to as the difference between database transaction time and real world valid time.


As professionals and home users begin to adopt mobile devices as their primary computing platform, it has become crucial to provide comprehensive support for time data. Accordingly, The Mashup App provides the following capabilities for time data:

  1. Every data item in your personal database can be associated with time information. This allows you to annotate web, PDF, image, audio, video, and location data with time information. Camera users realize the importance of knowing when a photo was taken but this capability also allows a user such as a historian or legal professional to document the creation, signature, or destruction of a PDF. Likewise a traveler is able to annotate trip data with the time that they visited each location thus providing a more memorable experience.

    The Mashup App provides detailed information about each place you visited associating time with location

  2. To support editing and undo, every data item in your personal database can have multiple versions each specifying a different time. By default, there is the version of the data at creation time and at last modified time. In this example, the user is editing a web article which was saved into her personal database

    In addition to saving web content into your personal database, The Mashup App allows you to edit and annotate web content by highlighting important sections and deleting irrelevant parts such as ads. You can undo your changes and revert to the original article.

  3. You can provide a textual description for the data which can include time information. This is an informal way to document time information. In this example, the user has saved an important web article by Virginia Postrel from Reason Magazine. The user has provided informal time information in the description:
    The category view allows you to search your personal database by description, URL, location, or time. As a memory aid, you can also sequentially browse your personal database.

  4. Every data item can have multiple time, location, and contact information associated with it. For example, a historian or legal professional will at times need to document the when, where, and by whom of a PDF for creation, signature, or destruction.

    Because many types of users including rescue workers, historians, archeologist, and legal professionals routinely deal with time data, you can associate time and location information with your data. You can also link a calendar event and contact information with your data.

  5. Time information may be defined either as a specific time or a duration. Users who work with time as a duration include historians and archeologist who need to catalog data as related to specific historical time periods. Also, legal professionals working in e-discovery need to group digital data according to contracts or laws in effect during a specific time period and geography. 

    For historical information, you might not want to define a caledar event. Nonetheless, you can add time information to your data and represent a time period or duration.

    As for users who need to treat time as a specific instant or event, this includes legal professionals who work in accident litigation.

    You can add time information to your data and represent a specific instance of time.

  6. Time information may incorporate uncertainly. For example, insurance fraud investigators may initially suspect when a crime was committed but may be uncertain of the length of time of the crime.

    The Mashup App allows you to navigate your personal database by time information.

  7. Every data item in your personal database may be linked to a calendar event from your device's built-in calendar app. Mobile professionals can access their personal database from the built-in calendar and address book. The user can tap on a special link which will display data from the personal database

    You can access your personal database from your calendar by linking calendar events with data in your personal database. This allows you to always have detailed information for meetings.You can access your personal database from your address book by linking contact information with data in your personal database. This allows you to access detailed context/biographical information about a contact.  



Location: A New Type of Data

The Mashup App allows you to save location data into your personal database. Location data can include the latitude and longitude of a place, Google Maps URL, the street/postal address, and neighborhood of a place, document, or media content such as images, audio, and video. 

Due to the desktop metaphor of files and folders, computer users have had limited exposure to location data and usually only through specialized photo management applications and photo sharing web sites. Enterprise databases have recently added support for location data. Database researchers describe databases with location support as geo-spatial databases. 

Your device can determine the latitude and longitude of its location. Unfortunately, this may not be very accurate so The Mashup App allows you to edit the location data to ensure the best possible accuracy. Using the latitude and longitude information generated by your device, The Mashup App can then determine the street address of the location by querying Location Servers found on the internet. This feature is called geolocation. 

The Mashup App does not transmit any personal data nor does it transmit your unique device identifier and only transmits to the Location Servers the latitude and longitude.
In addition to the street address, The Mashup App also uses Location Servers on the internet to determine the neighborhood for an address. This is helpful so that you can search your personal database for locations in a neighborhood, a city, or a state. Likewise, The Mashup App allows you to search your personal database for nearby places. For example, you can find places within a few miles from your current location.

The Mashup App can display location data on a map and you can share your location via email or SMS text messages.

There are 4 major benefits for saving location data: 

  1. Saving your current location. The Mashup App can determine the street/postal address, neighborhood, and the latitude and longitude of your device. This is helpful if you want to remember an address  or information about an unfamiliar place. You can provide a detailed description about the location, describe nearby places, and share with friends.

    The launch view of The Mashup App. From here you can save your data into your personal database. With just a tap you can save, edit, and organize web, PDF, audio, video, images, location and time data.

    If your data has location information associated with it or if it is a real-world place, you can browse and search by neighborhood, city, or state.
    Of course, you can visualize your location data on a map.

  2. Saving your location during a trip. The Mashup App can create a location log which you can visualize on a map. This helps you remember the streets you travelled on a trip, perhaps while sightseeing. The Mashup App is intelligent and will do its best to limit the drain on your device's battery.

    From the location log you can visualize your trip on an interactive map.

    The Mashup App provides detailed information about each place you visited.

  3. You can add location data to web and PDF documents as well as images, audio, and video content. Users such as rescue workers, archaeologists, and historians can use The Mashup App to quickly associate location and time data with their artifacts while in the field. The Mashup App also supports comprehensive reporting allowing the user to generate GeoRSS feeds.

    In addition to generating an RSS feed, GeoRSS feed, and custom web site from your data, you can also generate a formal report with a table of contents.

  4. Alerting you of important nearby places. For the mobile professional or just a person getting their clothes from the cleaners, The Mashup App can automatically display the data related to a location just before you arrive. So if you save your presentations and receipts in your personal database, you can always be prepared. This feature is called Vicinity Alerts and is based on a technology called geofencing.

    The Mashup App also allows you to set a Vicinity Alert around a location. When you travel near that location, The Mashup App will notify you that you are in the general area of that location and display any data related to the location. Vicinity Alerts decrease the time it takes to search your personal database by preloading and displaying data before you need it. This is helpful for mobile users who travel for business meetings or when you go to a place such as the cleaners where you must display a receipt. If you save your presentation and receipt in your personal database, The Mashup App will automatically search and display your data just before you arrive at your destination.