Jump to content

MICRO Relational Database Management System

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by W163 (talk | contribs) at 01:14, 23 February 2012 (get ready to change the name of the article to something more appropriate and which doesn't include an acronym, some general cleanup). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The Micro Information Management System was the first-large scale set-theoretic database management system to be used in production.[1] Its major underpinnings and algorithms were based on the Set-Theoretic Data Structure (STDS) model developed by D. L. Childs of the University of Michigan's CONCOMP (Conversational Use of Computers) Project.[2][3][4] Micro featured a natural language interface which allowed non-programmers to use the system.[5]

Implementation of Micro began in 1970 as part of the Labor Market Information System (LMIS) project at the University of Michigan's Institute of Labor and Industrial Relations (ILIR).[5] Funding came from the Office of Manpower Administration within the U.S. Department of Labor. It was first used for the study and analysis of micro-statistics; hence the name of the system. Organizations such as the US Department of Labor, the US Environmental Protection Agency, and researchers from University of Alberta, the University of Michigan, Wayne State University, the University of Newcastle upon Tyne, and Durham University used Micro to manage very large scale databases until 1998.

Micro runs under the Michigan Terminal System, the interactive time-sharing system developed at U-M that runs on IBM S/360, S/370, and compatible mainframe computers.[6] Micro provides a query language, a database directory, and a data dictionary to create an interface between the user and a collection of very efficient collection of proprietary Set-Theoretic Data Structure (STDS) software developed by the Set-Theoretic Information Systems Corporation (STIS) of Ann Arbor, Michigan. The lower level routines from STIS treat the data bases as sets and perform set operations on them, e.g., union, intersection, restrictions, etc. Although the underlying STDS model is based on set theory, the Micro user interface is similar to those subsequently used in relational database management systems.[7][2] MICRO's data representation can be thought of as a matrix or table in which the rows represent different records or "cases", and the columns contain individual data items for each record; however, the actual data representation is in set-theoretic form. In labor market applications the rows typically represent job applicants or employees and columns represent fields such as age, sex, and income or type of industry, number of employees, and payroll.[1]

Micro permits users with little programming experience to define, enter, interrogate, manipulate, and update collections of data in a relatively unstructured and unconstrained environment. An interactive system, Micro is powerful in terms of the complexity of requests which can be made by users without prior programming language experience.[8] Micro includes basic statistical computations such as mean, variance, frequency, median, etc. If more rigorous statistical analysis are desired, the data from a Micro database can be exported to the Michigan Interactive Data Analysis System (MIDAS),[9] a statistical analysis package available under the Michigan Terminal System (MTS).[10]

References

  1. ^ a b "A set theoretic data structure and retrieval language" (PDF), William R. Hershey and Carol H. Easthope, Paper from the Session on Data Structures, Spring Joint Computer Conference, May 1972 in ACM SIGIR Forum, Volume 7, Issue 4 (December 1972), pp. 45-55, DOI=10.1145/1095495.1095500
  2. ^ a b "Sets, Data Models and Data Independence", by Ken North a Dr. Dobb's Blogger, March 10, 2010
  3. ^ Description of a set-theoretic data structure, D. L. Childs, 1968, Technical Report 3 of the CONCOMP (Research in Conversational Use of Computers) Project, University of Michigan, Ann Arbor, Michigan, USA
  4. ^ Feasibility of a Set-Theoretic Data Structure : A General Structure Based on a Reconstituted Definition of Relation, D. L. Childs, 1968, Technical Report 6 of the CONCOMP (Research in Conversational Use of Computers) Project, University of Michigan, Ann Arbor, Michigan, USA
  5. ^ a b MICRO Information Management System (Version 5.0) Reference Manual, M.A. Kahn, D.L. Rumelhart, and B.L. Bronson, October 1977, Institute of Labor and Industrial Relations (ILIR), University of Michigan and Wayne State University
  6. ^ "Chapter 6: MICRO" in Introduction to database management systems on MTS, Rick Rilio, User Guide Series, Computing Center, University of Michigan, March 1986, pages 147-189
  7. ^ "A Relational Model of Data for Large Shared Data Banks", E.F. Codd, Communications of the ACM, volume 13, issue 6 (June 1970), pp. 77–387, doi= 10.1145/362384.362685
  8. ^ "Use of a Relational Database to Support Clinical Research: Application in a Diabetes Program", Diane Lomatch, M.P.H., Terry Truax, M.S., Peter Savage, M.D., Diabetes Center Unit, MDRTC, University of Michigan, 1981
  9. ^ Documentation for MIDAS, Daniel J. Fox and Kenneth E. Guire, Third Edition (September 1976), Statistical Research Laboratory, University of Michigan, 203 pp.
  10. ^ "Converting from Traditional File Structures to Database Management Systems: A Powerful Tool for Nursing Management", Yvonne Marie Abdoo, Ph.D., R.N, Wayne State University College of Nursing, 1987
Retrieved from "https://en.wikipedia.org/w/index.php?title=MICRO_Relational_Database_Management_System&oldid=478349924"