Jordi Pradel, Jose Raya, Xavier Franch


Given their need to manage the information they have under control, organizations usually choose among two types of widely used IT solutions: 1) information systems based on databases (DBIS) that are powerful but expensive to develop and not much flexible; 2) spreadsheets, which threaten the integrity of the data and are limited in exploiting it. In this paper we propose a new type of IT solution, namely information microsystems (MicroIS), that aims at reconciling the best of these two worlds: the low development and maintenance costs, ease of use and flexibility of spreadsheets, with the structure, semantics and integrity of DBIS. The goal is not to replace any of the above two paradigms but to lie somewhere in between depending on the changing needs of the organization. From the various possible points of interest of this IT solution, the article will focus specifically on issues related to data management, introducing the conceptual model of MicroIS, the transformations and validations that can be done around it, and they way in which the structure of the information is inferred from the data that users provide.


  1. Ambler, S. W., Sadalage, P. J. (2006). Refactoring Databases: Evolutionary Database Design. New York: Addison-Wesley.
  2. Dabble blog. (2005). Shouldn't be Spreadsheets. Retrieved April 30, 2010, from 2005/03/shouldnt-be-spr.html
  3. Baker, K. R., Foster-Johnson, L., Lawson, B. and Powell, S.G. (2006). A Survey of MBA Spreadsheet Users. Retrieved April 30, 2010, from http://mba.tuck.
  4. Cunha, J., Saraiva, J. and Visser, J. (2009). From Spreadsheets to Relational Databases and Back. Proceedings of ACM SIGPLAN Workshop on Partial Evaluation and Program Manipulation, PEPM09, Savannah, Georgia, USA.
  5. Johnson R. and Woolf B. (1997). Type Object Pattern. New York: Addison-Wesley.
  6. Kraus, J. (2005). The long Tail of Software. Millions of Markets of Dozens. Retrieved April 30, 2010, from tail_o.html.

Paper Citation

in Harvard Style

Pradel J., Raya J. and Franch X. (2010). INFORMATION MICROSYSTEMS . In Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: ICSOFT, ISBN 978-989-8425-22-5, pages 57-62. DOI: 10.5220/0003020000570062

in Bibtex Style

author={Jordi Pradel and Jose Raya and Xavier Franch},
booktitle={Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: ICSOFT,},

in EndNote Style

JO - Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: ICSOFT,
SN - 978-989-8425-22-5
AU - Pradel J.
AU - Raya J.
AU - Franch X.
PY - 2010
SP - 57
EP - 62
DO - 10.5220/0003020000570062