Extracting term units and fact units from existing databases using the Knowledge Discovery Metamodel

Abstract

The extraction of business vocabulary is one of the main tasks in discovering business knowledge implemented in a software system. In this paper we present a model-driven approach to the extraction of business vocabularies from databases of existing software systems. We describe a transformation framework for obtaining the Knowledge Discovery Metamodel based representation of data structure and define an algorithm for the extraction of candidates for business vocabulary entries (i.e. Term and Fact Units) from the representation. The extracted candidates may be further refined by business analysts and used for the identification of business scenarios and rules in software systems.

Keywords

Business vocabulary business rules knowledge extraction Knowledge Discovery Metamodel

Get full access to this article

View all access options for this article.

References

Seacord

Plakosh

Lewis

. Modernizing legacy systems: Software technologies, engineering process and business practices. Boston, MA: Addison-Wesley Longman, 2003.

Abran

Bourque

Dupuis

Moore

Tripp

. Guide to the Software Engineering Body of Knowledge – SWEBOK. Piscataway, NJ: IEEE Press, 2004.

Chikofsky

Cross

. Reverse engineering and design recovery: a taxonomy. Software, IEEE 1990; 7(1): 13–17.

OMG. Architecture driven modernization task force, http://adm.omg.org (2008, accessed 15 January 2013).

OMG. Knowledge Discovery Metamodel specification version 1.3, http://www.omg.org/spec/KDM/1.3/PDF/ (2011, accessed 10 May 2013).

Ulrich

Newcomb

. Information systems transformation: Architecture-driven modernization case studies. San Francisco, CA: Morgan Kaufmann, 2010.

Normantas

Vasilecas

. Extracting business rules from existing enterprise software system. In: Skersys

Butleris

Butkiene

(eds) Information and software technologies. Communications in Computer and Information Science, Volume 319. Berlin: Springer, 2012, pp. 482–496.

OMG. Semantics of business vocabulary and business rules v1.0, http://www.omg.org/spec/SBVR/1.0/. (2008, accessed 10 May 2013).

Chiang

. Extracting business rules from legacy systems into reusable components. In: IEEE/SMC International Conference on system of systems engineering, 2006.

10.

Chiang

Bayrak

. Legacy software modernization. In: IEEE international conference on systems, man and cybernetics, Volume 2, 2006, pp. 1304–1309.

11.

Huang

. Business rule extraction from legacy code. In: Proceedings of the 20th conference on computer software and applications. Washington, DC: IEEE Computer Society, 1996, pp. 162–167.

12.

Wang

Sun

Yang

Maddineni

. Business rules extraction from large legacy systems. In: Proceedings of the eighth euromicro working conference on software maintenance and reengineering (CSMR’04). Washington, DC: IEEE Computer Society, 2004, pp. 249–255.

13.

Sneed

Erdos

. Extracting business rules from source code. In: Proceedings of the 4th internationalworkshop on program comprehension (WPC ’96). Washington, DC: IEEE Computer Society, 1996, pp. 240–246.

14.

Sneed

. Extracting business logic from existing COBOL programs as a basis for redevelopment. In: Proceedings of the 9th international workshop on program comprehension, 2001, pp. 167–175.

15.

Chaparro

Aponte

Ortega

Marcus

. Towards the automatic extraction of structural business rules from legacy databases. In: 9th Working conference on reverse engineering, 2012, pp. 479–488.

16.

Castillo

Cruz-Lemus

de Guzman

IGR

Piattini

. Business process archeology using MARBLE. Information & Software Technology 2011; 53(10): 1023–1044.

17.

Gibb

McCartan

O’Donnell

Sweeney

Leon

. The integration of information retrieval techniques within a software reuse environment. Journal of Information Science 2000; 26(4): 211–226.

18.

Antoniol

Canfora

Casazza

De Lucia

. Information retrieval models for recovering traceability links between code and documentation. In: Proceedings of international conference on software maintenance, 2000, pp. 40–49.

19.

Putrycz

Kark

. Connecting legacy code, business rules and documentation. In: Bassiliades

Governatori

Paschke

(eds) Rule representation, interchange and reasoning on the Web. Lecture Notes in Computer Science, Volume 5321. Berlin: Springer, 2008, pp. 17–30.

20.

Ambler

Sadalage

. Refactoring databases: Evolutionary database design. Boston, MA: Addison-Wesley Professional, 2006.

21.

Hainaut

. Introduction to database reverse engineering. Problems, Methods and Tools, Tutorial notes, CAiSE, 2002.

22.

Paradauskas

Laurikaitis

. Business knowledge extraction from legacy information systems. Information Technology and Control 2006; 35(3): 214–221.

23.

Paradauskas

Laurikaitis

. Extracting conceptual data specifications from legacy information systems. Electronics and Electrical Engineering 2011; 1(107): 46–50.

24.

Andersson

. Extracting an entity relationship schema from a relational database through reverse engineering. In: Proceedings of the 13th international conference of the entity relationship approach. Berlin: Springer, 1994, pp. 403–419.

25.

Khedker

Sanyal

Karkare

. Data flow analysis: Theory and practice, 1st edn. Boca Raton, FL: CRC Press, 2009.

26.

Nielson

Hankin

. Principles of program analysis, corrected edn. Berlin: Springer, 2004.

27.

Budinsky

Steinberg

Ellersick

. Eclipse modeling framework: A developer’s guide. Boston, MA: Addison-Wesley Professional, 2003.

28.

ISO/IEC. SQL – Part 2: Foundation (SQL/Foundation), ISO/IEC 9075, 2008.