Dr. Michael Stephen Bird Official Website

MAPPER DBMS Survives Over Time

Home
Beautiful Spouse
History of Dr. Bird
Dr. Bird as the Educator
Professional Speaker
Dr. Bird as the Author
Contact Dr. Michael Bird

Click Here to See Other Online Articles by Dr. Michael Stephen Bird

By Michael Stephen Bird
Written August 2008

According to Del Fiacco (2003, December), Unisys developed a relational database in 1968 called MAPPER with its own programming language.  This database and associated programming language was created to serve a business need that still exists in the current business environment.   A mission-critical business requirement at the Sperry Univac factory that was developing the computer systems in Minnesota sparked the creation of MAPPER.  Del Fiacco continued to state that there was a complex of four buildings that was located across land that spread over several acres with several employees on three different shifts.  Sperry Univac needed to control the engineering, procurement, storage of parts, assembly, inventory management, packaging, order entry, shipping and receiving, accounts payable and receivable, diagnostics, testing, certification, and customer support activities.

According to the Unisys Customer Education Manual (1993), MAPPER stands for maintaining, preparing, and processing executive reports. MAPPER started as a Unisys mainframe fourth-generation language and database management system.  Del Fiacco points out that while originally developed in 1968, it was introduced to the Unisys customers in the 1980’s. Many customers utilized the system as a high-level report writer but later the MAPPER system became a full-featured development system used successfully by both technical and non-technical users. This development system included a relational database, programming language, and other support tools that made MAPPER unique on the mainframe environment during the original introduction. 

The MAPPER database is comprised of series of tables. According to Rob and Carlos (2002), the relational database management system will perform the basic functions similar to any other database management system, but will have the ability to let the designer operate in a human logical environment. In accordance to this concept of a relational database, the Unisys Customer Education Manual (1993) reflects that the MAPPER database is comprised of three components:

o       Reports in Drawers (RIDS)

o       Drawers comprising of RIDS

o       Cabinets comprising of drawers

The cabinets will comprise of an application system that have eight drawers housing various tables with data, associated programs, and documentation of the system. The drawers with the database tables reflect a matrix consisting of a series of row and column intersection. The tables are related to each other by sharing a common entity characteristic. For example, a typical system would be within a cabinet with drawers that define the different types of medium ranging from “B” to “I.”  The “B” and “C” types (drawers) could reflect the database tables utilized by the system.  The “D,” “E,” and “F” types (drawers) could reflect the associated documentation for the system.  The “H” type (drawer) could reflect the security related tables for the application system. Finally, the “I” type (drawer) could reflect the MAPPER program code utilized by the system.  Rob and Carlos (2002) indicate that this concept provides a human concept in viewing the databases and its associated system.  The Unisys training manual continues to point out that the program codes, documentation, and database tables are in RIDS that are within a drawer that is housed within a cabinet. Therefore, MAPPER presents an easier format for humans in the business world to understand by storing a collection of related entities that resemble a file cabinet. This provides a visual representation of relational database’s entities, attributes within those entities, and relationships between those entities.

The MAPPER database is purely a logical structure that has become the source of a real database revolution. The advantages of MAPPER are its structural independence, improved conceptual simplicity, and a powerful database management system. Along with its ad hoc query capability through its interactive MAPPER query tools, the database management system provides for an easier database design, implementation, management, and overall use.  However, some disadvantages include the tendency for poor design and implementation that promote “islands of information” problems, due to its ease of use.  

Del Fiacco (2003, December) continues to state that factory software developers created MAPPER, considered as a self-contained and self-reliant software environment that included a relational database and programming language, depending on a lesser extent on the features and capabilities of the EXEC8 operating system. Once seen by business clients, the database and programming language became available to the customers of Unisys. Del Fiacco states that several businesses became dependent on MAPPER.

According to Shacklett (2000, September), e-business will continue to be a tremendous challenge to companies as they rapidly move towards web-enabled industrial-strength applications.  The author continues to state that proven solutions such as Unisys LINC and MAPPER products have been continuing to prove that they produce results.

Shacklett has indicated that MAPPER is a long-term, exceedingly successful foundation in the Unisys product line and it has established a way to re-create itself for the e-business environment. The author introduces a comment made by the MAPPER strategic program manager at Unisys, Walt Burdick, where he states, "MAPPER has gone through a major transition in modernization. It no longer has character-based applications. Everything is now run through a point-and-click GUI interface.”  The MAPPER system has a GUI interface that works on NT servers and has the ability to work with the Unisys Cool Ice product that will interface MAPPER directly with the internet, intranet, and extranet, making it ideal for e-business.

As business demands and technology has provide the necessity for business to convert and migrate the applications and databases from the mainframe to other environments such NT or UNIX. The need to improve operational efficiency, manage risk, and reduce costs has generated the migration need.  The MAPPER system with its relational databases and programming language has survived this migration process by Unisys enhancing the product to handle the newer technology.  The conversion of MAPPER applications to the other servers is more cost-effective due to the ability of the MAPPER database to migrate across various platforms.

Shacklett (2000, September) stated that the self-reliant nature of the MAPPER design has presented many developers a tremendous latitude in technological innovation because of the advances did not have to be synchronized with dissimilar software structural design, design, and development outside the MAPPER domain.  It is due to this latitude that MAPPER has pioneered in many advanced concepts in the business environment.

Hoffman (1994, April 25) stated that in an effort to bridge the gap between distributed systems and their relative inability to perform robust online transaction processing, Unisys had introduced the necessary middleware to ensure MAPPER the portability of the relational database and its associated fourth-generation language package. Shacklett (2000, September) further states that tremendous strides have been made on web-enabled front-end browser technology but the strength for web-enabled systems will continue to come from the legacy and in some-cases, the server-based database repositories that back them up. MAPPER has been able to offer Unisys customers the capability to quickly interface the existing data repositories to the outer browsers that connect the organization’s stakeholders in an e-business format. Both Hoffman and Shacklett have indicated that MAPPER has expanded to new internet applications, wireless application protocol, and mobile access capabilities through enhancements made by Unisys. This has contributed to the long history of the MAPPER database. According to the Unisys corporate website, MAPPER is now part of their Business Information Server product line.

Del Fiacco (2003, December) states that the MAPPER database system invented client server programming before the actual industry defined it. The author continued by stating that MAPPER stored, rendered, and displayed digital images on graphical displays before the Windows product was invented by Bill Gates. The author went on to say that MAPPER reflected data in a dynamic, computable spreadsheet form before Excel even existed. Del Fiacco points out that MAPPER was Heterogeneous Multi-Processing (HMP) enabled years before Unisys actually coined the HMP term and created the ClearPath platforms with this name. Therefore, MAPPER was ahead of its time which contributes to its current success.  The fact that it currently can be utilized in many platforms besides the mainframe and allows for GUI and Internet technology, also accounts for its continued success among Unisys customers. At Carnival Cruise Lines, the MAPPER applications was a part of the total integrated package tied to DMS1100, ORACLE, and other databases across the infrastructure. Based on my personal knowledge, MAPPER has been an integral part of many organizations, including the Hillsborough Sheriffs Office, National Data Corporation, some trucking companies, and governmental agencies.

  One could conclude that the software product known as MAPPER, which comprises of a relational database and a fourth-generation programming language, was conceived and generated to serve a need that continues to persists and thrive to the current business environment.  Remaining ahead of its time and building upon this strong history, Del Fiacco indicates that Unisys has renamed MAPPER as the Unisys Business Information Server (BIS) and adapted the product to a Microsoft Windows environment. 

Del Fiacco continued to state that beneath the surface, major revamp and enhancement of the BIS engine have occurred in recent years. The author continues to state that much of this has been focused on performance which is needed to keep pace with the demands of the Unisys community of BlS applications and end users, as well as to take advantage of the mounting capacity and power of various hardware configurations.

In conclusion, the MAPPER database management system, regardless of the name, has been a successful database and will continue to thrive over the years by remaining ahead of its time.  As presented in this paper, the MAPPER database management system has been strong in the Unisys client community and remained successful, even with its rename to BIS, by evolving to meet the changing conditions and needs of the business community.

 


 

Reference:

Del Fiacco, Gerry (2003, December). Mapper: A mission critical legacy. Enterprise Networks & Servers, 9, 12, 9.

 

Del Fiacco, Gerry (2003, December). Mapper: A mission critical legacy. Unisys World, 24, 12, 1.

 

Hoffman, Thomas (1994, April 25). Unisys unveils distributed OLTP. Computerworld, 28, 17, 4.

 

Rob, Peter and Carlos Coronel. Database Systems:  Design, Implementation, and Management. Boston:  Course Technology, 2002.

 

Shacklet, Mary (2000, September). LINC, MAPPER make transition to e-business applications. Unisys World, 21, 8, 1 – 3.

 

Unisys Corporate Website. Retrieved on August 4, 2006, from http://www.unisys.com.

 

Unisys Customer Education Manual: MAPPER Training (1993). Roseville, Minnesota.  

© Michael Stephen Bird, 2008
This online published article

Dr. Michael Stephen Bird Website Links:

One Professor Menu
-- General Information -- TOSA Business Model -- Books -- Online Publications -- CV

Dr. Michael Stephen Bird * South Florida * USA * Email: professor_mbird@yahoo.com or professormbird@gmail.com
© Dr. Michael Stephen Bird, 2011