Imagine that you need to build a system that retrieves data from an external data source (such as a Web service) and imports it into your database. However, the data source's table and column names are different from the ones your database uses. Changing your database's structure (tables, columns, and so on), stored procedures, and relations to match those of the data source isn't a viable solution. It's smarter to use middleware code that maps the original data-source names to the destination data-source names. The code manages every naming conversion when you must retrieve data from the original source and insert it into the destination source, and vice versa.
展开▼