An approach for reverse engineering of relational databases

Premerlani, W.; Blaha, Michael

doi:10.1109/wcre.1993.287769

Cited by 58 publications

(59 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Here let us mention the work of Chris Date [16,15,14], Michael Blaha [8,7,53], Peter Aiken [2] and Kathie Hogshead-Davis [17]. In Europe Jean-Luc Hainaut [18] and Jean Henrard [28,26,27] have worked on the re-engineering of databases to promote performance.…”

Section: Related Workmentioning

confidence: 99%

Reducing operational costs through MIPS management

Kwiatkowski

Verhoef

2015

Science of Computer Programming

View full text Add to dashboard Cite

h i g h l i g h t s• We present an approach to reducing CPU usage costs in large organizations.• Source code scans are used to identify low-risk high-yield SQL-tuning opportunities.• Our approach is suitable for deployment in large business-critical IT-portfolios.• Case study: a mainframe production environment of 246 applications (19.7M+ LOC). a r t i c l e i n f o a b s t r a c t We focus on an approach to reducing the costs of running applications. MIPS, which is a traditional acronym for millions of instructions per second, have evolved to become a measurement of processing power and CPU resource consumption. The need for controlling MIPS attributed costs is indispensable given their significant contribution to operational costs. In this paper we investigate a large mainframe production environment running 246 Cobol applications of an organization operating in the financial sector. We found that the vast majority of the top CPU intensive operations in the production environment involve the use of DB2. We propose approaching portfolio-wide efforts to reduce CPU resource consumption from the source code perspective. Our technique is low-risk, lowcost and involves SQL code improvements of small scale. We show how to analyze a mainframe environment in an industrial setting, and to locate the most promising source code segments for optimizing runtime usage. Our approach relies on the mainframe usage data, facts extracted from source code, and is supported by a real-world SQL tuning project. After applying our technique to a portfolio of Cobol applications running on the mainframe our estimates suggested a possible drop in the attributed monthly CPU usage by as much as 16.8%. The approach we present is suited for facilitation within a mainframe environment of a large organization.

show abstract

Section: Related Workmentioning

confidence: 99%

Reducing operational costs through MIPS management

Kwiatkowski

Verhoef

2015

Science of Computer Programming

View full text Add to dashboard Cite

show abstract

“…Homogenizing means to remodel tables in the ODMG object model. In the FIHD approach, we incorporate ideas developed in the context of reverse engineering and semantic enrichment (Chiang et al (1994), Premerlani and Blaha (1994), Castellanos and Saltor (1991), Hohenstein and Korner (1995)). Hence, tables are not just converted to object types that possess the simple table structure, i.e., object types without relationships and without subtyping.…”

Section: Semantic Enrichmentmentioning

confidence: 99%

Plugging Files in Database Federations

Hohenstein¹,

Ebert²

2000

AJIS

View full text Add to dashboard Cite

In order to use files in database federations, we propose to migrate file data into a relational database. Integrating the database in a federation is then well-understood. This procedure has the advantage that a ,/eal" database is handled supporting transactions and SQL; files obtain a high-level interface for free. This paper presents a specification-based approach to support the process of migrating file data into a relational database, and vice versa. A specification language provides powerful concepts to describe the contents of files and directories. In contrast to similar work, directory structures are taken into account, because they contain useful semantics. Given some descriptive specification of file contents, an adapter is generated moving data from several files into the database, and the other way round.

show abstract

“…Reverse engineering goals are multiple, e.g., coping with complexity, generating alternate views, recovering lost information, detecting side effects, synthesizing higher abstractions, and facilitating reuse. Examples of problem areas where reverse engineering has been successfully applied include redocumenting programs [11] and relational databases [94], identifying reusable assets [23], recovering architectures [67], recovering design patterns [2,53,68,108], building traceability between code and documentation [1,76], identifying clones [7,10,62,81], code smells [111] and aspects [79,106], computing change impacts [6], reverse engineering binary code [29], renewing user interfaces [84,89], translating a program from one language to another [19], migrating [22] or wrapping legacy code [99]. Although software reverse engineering originated in software maintenance, its definition is sufficiently broad so as to be applicable to many problem areas, for example to create representations necessary for testing purposes [82], or to audit security and vulnerability [34].…”

Section: Introductionmentioning

confidence: 99%