# US 2014/0208290 A1 · Application source code scanning for database migration

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2014/0208290 A1
- Document ID: US20140208290A1
- Status: Published application
- Kind: A1
- Application number: 13/746,755
- Filed: 2013-01-22
- Published: 2014-07-24
- Earliest claimed: 2013-01-22
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Barry McGillin
- Web page: https://patentgrep.com/patent/US20140208290A1

## CPC

- G06F 16/214: {Database migration support}
- G06F 8/51: Source to source
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Systems, methods, and other embodiments associated with application source code scanning for database migration are described. In one embodiment, a method includes identifying a subset of application source code files that are likely to require modification to access a destination database. The subset of application source code files is scanned for artifact expressions that access a source database and should be changed to access the destination database.

## Claims

### Claim 1

A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computer cause the computer to perform a method, the method comprising:
identifying a set of source code files for applications that access data in a first database, where the first database has been migrated to a second database;
selecting a migration rule, where a migration rule includes a recognizer criterion and a replacement rule;
applying the recognizer criteria in the selected migration rule to the set of source code files to identify a subset of source code files that meet the recognizer criterion; and
applying the replacement rule in the selected migration rule to the subset of source code files.

### Claim 2 (depends on 1)

The non-transitory computer-readable medium of claim 1, where the recognizer criterion specifies one or more filename extensions and where applying the recognizer criterion comprises identifying a filename extension of the source code files and selecting source code files having one of the filename extensions for the subset.

### Claim 3 (depends on 1)

The non-transitory computer-readable medium of claim 1, where the recognizer criterion specifies one or more recognizer expressions, and further where applying the recognizer criterion comprises scanning a source code file to locate any of the one or more recognizer expressions.

### Claim 4 (depends on 1)

The non-transitory computer-readable medium of claim 1, where each replacement rule specifies an artifact expression, and further where the instructions for applying the replacement rule comprise scanning a source code file to identify each occurrence of the artifact expression.

### Claim 5 (depends on 4)

The non-transitory computer-readable medium of claim 4, where the artifact expression is a text expression.

### Claim 6 (depends on 4)

The non-transitory computer-readable medium of claim 4, where the artifact expression is a regular expression.

### Claim 7 (depends on 4)

The non-transitory computer-readable medium of claim 4, where the instructions further comprise returning a location of each occurrence of the artifact expression in the source code file.

### Claim 8 (depends on 4)

The non-transitory computer-readable medium of claim 4, where the instructions further comprise replacing each occurrence of the artifact expression with a replacement expression specified in the replacement rule to produce a second application adapted to access the second database.

### Claim 9 (depends on 4)

The non-transitory computer-readable medium of claim 4, where the instructions further comprise:
passing the artifact expression to a translator;
receiving a replacement expression from the translator; and
replacing each occurrence of the artifact expression with the replacement expression to produce a second application adapted to access the second database.

### Claim 10 (depends on 1)

The non-transitory computer-readable medium of claim 1, where selecting a migration rule comprises accessing a set of migration rules and selecting a migration rule that is mapped to i) a first database type of the first database and ii) a second database type of the second database.

### Claim 11

A computing system, comprising:
memory media configured to store a set of migration rules for revising a set of first applications that access data in a first database to a second set of applications that access a second database, where the first database has been migrated to the second database; and
an application migration tool configured to:
select a migration rule;
input a set of source code files associated with the set of first applications;
select a subset of the source code files that are likely to require modification to access the second database; and
apply one or more replacement rules to the subset of source code files to produce the set of second applications.

### Claim 12 (depends on 11)

The computing system of claim 11, where the application migration tool comprises a recognizer logic configured to apply a recognizer criterion specified in the migration rule to the set of source code files and select source code files that meet the recognizer criterion for inclusion in the subset.

### Claim 13 (depends on 12)

The computing system of claim 12, where the recognizer logic is configured to identify a filename extension of the source code files and select source code files having filename extensions specified by the recognizer criterion for inclusion in the subset.

### Claim 14 (depends on 12)

The computing system of claim 12, where the recognizer logic is configured to scan source code files and select source code files that include any of one or more recognizer expressions specified by the recognizer criterion for inclusion in the subset.

### Claim 15 (depends on 11)

The computing system of claim 11, where the migration rule includes an artifact expression and a replacement expression, and further comprising a replacement logic configured to scan the subset of source code files to identify each occurrence of the artifact expression.

### Claim 16 (depends on 15)

The computing system of claim 15, where the replacement logic is further configured to replace each occurrence of the artifact expression with a replacement expression specified by the replacement rule.

### Claim 17 (depends on 15)

The computing system of claim 15, where the replacement logic is configured to:
pass the identified artifact expression to a translator;
receive a replacement expression from the translator; and
replace each occurrence of the artifact expression with the replacement expression to produce a second application adapted to access the second database.

### Claim 18 (depends on 11)

The computing system of claim 11, where the application migration tool is configured to access a set of migration rules and select a migration rule that is mapped to i) a first database type of the first database and ii) a second database type of the second database.

### Claim 19

A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computer cause the computer to perform a method, the method comprising:
providing an interface for receiving one or more recognizer criteria for identifying source code files for a set of first applications that access data in a first database that are likely to require modification to access a second database;
associating the recognizer criteria with one or more replacement rules that map replacement expressions to artifact expressions in source code files, where replacing corresponding artifact expressions with corresponding replacement expressions revises the source code file to produce a set of second applications that access the second database; and
storing the one or more recognizer criteria and replacement rules for future processing.

### Claim 20 (depends on 19)

The non-transitory computer-readable medium of claim 19, where the instructions further comprise providing an interface for receiving the one or more replacement rules.

### Claim 21

A computer-implemented method comprising:
identifying a set of source code files for applications that access data in a first database, where the first database has been migrated to a second database;
selecting a migration rule, where a migration rule includes a recognizer criterion and a replacement rule;
with a processor, applying the recognizer criteria in the selected migration rule to the set of source code files to identify a subset of source code files that meet the recognizer criterion; and
applying the replacement rule in the selected migration rule to the subset of source code files.

### Claim 22 (depends on 21)

The computer-implemented method of claim 21, where the recognizer criterion specifies one or more filename extensions and where applying the recognizer criterion comprises identifying a filename extension of the source code files and selecting source code files having one of the filename extensions for the subset.

### Claim 23 (depends on 21)

The computer-implemented method of claim 21, where the recognizer criterion specifies one or more recognizer expressions, and further where applying the recognizer criterion comprises scanning a source code file to locate any of the one or more recognizer expressions.

### Claim 24 (depends on 21)

The computer-implemented method of claim 21, where each replacement rule specifies an artifact expression, and further where applying the replacement rule comprises scanning a source code file to identify each occurrence of the artifact expression.

### Claim 25 (depends on 24)

The computer-implemented method of claim 24, further comprising replacing each occurrence of the artifact expression with a replacement expression specified in the replacement rule to produce a second application adapted to access the second database.

### Claim 26 (depends on 24)

The computer-implemented method of claim 24, further comprising:
passing the artifact expression to a translator;
receiving a replacement expression from the translator; and
replacing each occurrence of the artifact expression with the replacement expression to produce a second application adapted to access the second database.
