Micro DBMS

Micro was one of the earliest set theoretic/relational database management systems.[1] Its major underpinnings and algorithms were based on the set-theoretic model of David Childs of the University of Michigan's CONCOMP (Conversational Use of Computers) Project.[2][3][4] It was also influenced to a lesser extent by the relational model made famous by Edgar F. Codd, a research scientist at IBM.[5] It used a natural language interface which allowed non-programmers to use the system.[6]

Micro permitted 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 was powerful in terms of the complexity of requests which could be made by users without prior programming language experience.[7] Micro includes basic statistical computations such as mean, variance, frequency, median, etc. If more rigorous statistical analysis were desired, the data from a Micro database could be used with Michigan Interactive Data Analysis System (MIDAS), a statistical analysis package available under the Michigan Terminal System (MTS).[8]

Implementation of Micro began in 1970 at the University of Michigan's Institute of Labor and Industrial Relations (ILIR) and ran under the Michigan Terminal System, the time-sharing system developed at U-M. It was first used for the study and analysis of micro-statistics contained in the United States Census data base; hence the name of the system.

The underlying data model and retrieval algorithms were deeply influenced by David Childs' Set Theoretic Data Model. Although the underlying model was based on set theory, the user interface utilized a query language subsequently used in relational database management systems. It became the first-large scale set theoretic/relational database management system to be used in production. 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 it to manage very large scale databases. Micro continued to run in production until 1998.

References

  1. ^ "A set theoretic data structure and retrieval language", William R. Hershey and Carol H. Easthope, Papers 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, Special Interest Group on Information Retrieval, Association for Computing Machinery, New York, NY, USA
  2. ^ "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, David 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, David 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 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
  6. ^ 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
  7. ^ "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
  8. ^ "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

External links

University of Michigan Database Research Group


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Micro — is a word that comes from the Greek μικρός (mikrós), meaning small . It can be used to indicate a smaller than average scale, as opposed to prefixes mega and macro, which can be used to indicate a larger than average scale. Some examples are:… …   Wikipedia

  • Database management system — A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and the use of a database. It allows organizations to conveniently develop databases for various applications by database… …   Wikipedia

  • Relational database management system — A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. Most popular commercial and open source databases currently in use are based on the… …   Wikipedia

  • List of relational database management systems — See DBMS for a shorter list of “typical”, representative database management systems.Current software*4th Dimension *Adabas D *Alpha Five *Apache Derby *CA Datacom *CSQL *Daffodil database *Dataphor *DB2 *Derby aka Java DB *EnterpriseDB… …   Wikipedia

  • Список СУБД —   Это служебный список статей, созданный для координации работ по развитию темы.   Данное предупреждение не устанавливается на информационные списки и глоссарии …   Википедия

  • Oracle Corporation — Type Public Traded as NYSE: ORCL NASDAQ:  …   Wikipedia

  • Btrieve — In computing, Btrieve is a transactional database product based on Indexed Sequential Access Method (ISAM), which is a way of storing data for fast retrieval. There have been several versions of the product for DOS, Linux, older versions of… …   Wikipedia

  • EXtremeDB — Infobox Software name = e X treme DB caption = developer = McObject latest release version = 3.1 latest release date = April 2, 2008 operating system = Cross platform genre = DBMS license = Commercial license website = http://www.mcobject.com e X …   Wikipedia

  • Abkürzungen/Computer — Dies ist eine Liste technischer Abkürzungen, die im IT Bereich verwendet werden. A [nach oben] AA Antialiasing AAA authentication, authorization and accounting, siehe Triple A System AAC Advanced Audio Coding AACS …   Deutsch Wikipedia

  • Liste der Abkürzungen (Computer) — Dies ist eine Liste technischer Abkürzungen, die im IT Bereich verwendet werden. A [nach oben] AA Antialiasing AAA authentication, authorization and accounting, siehe Triple A System AAC Advanced Audio Coding AACS …   Deutsch Wikipedia


Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”

We are using cookies for the best presentation of our site. Continuing to use this site, you agree with this.