SIMPLE DATA MARKUP & APPS
IN WHAT CAPACITY?
In this age of smart phones and tablets, sometimes a golf cart is needed rather than a Humvee. It may not always serve to place data in a complex database, but a small file that is easily updated with an editor. From utilities like jQuery to web programming application servers like ColdFusion, interface commands are put in place to make access to XML and JSON convenient.
In fact, some web services, which can act like tiny spigots to huge databases, depend on extensible markup languages like XML to pull data out for news feeds, social networks, Twitter, smart phones, and more. These simple tools are quite powerful in the context of their purpose.
In many systems, the powerful server-based database coexists with its compact XML cohort, much like the tiny forklift extracts pallets in a huge warehouse with thousands of ceiling-high shelves full of inventory.
Choosing which data container to use depends on the eventual size, needs to search quickly, security tools in place, desire for defined relationships between tables, etc.
IMPORT AND EXPORT
Many organizations have data in older database formats. Often, this data can be collected in a batch method and moved to a newer database format so it can be used on the web, or on a company intranet. Notepad is a simple but mighty go-between for accomplishing a data transfer.