# US 9,436,746 B2 · Next generation architecture for database connectivity

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

- Number: US 9,436,746 B2
- Document ID: US9436746B2
- Status: Granted
- Kind: B2
- Application number: 14/158,921
- Filed: 2014-01-20
- Published: 2015-07-23
- Granted: 2016-09-06
- Earliest claimed: 2014-01-20
- Assignees: Sap SE
- Applicants: Alexander Ocher
- Inventors: Alexander Ocher
- Web page: https://patentgrep.com/patent/US9436746B2

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F 16/2471: {Distributed queries}
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F 16/951: Indexing; Web crawling techniques
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

According to some embodiments, a method and an apparatus of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality. The method comprises receiving a command to access data. The command is associated with an ETL function. An executable file associated with the ETL function is called and the data associated with the command is received.

## Claims

### Claim 1

A method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS; and
receiving the data associated with the command.

### Claim 2 (depends on 1)

The method of claim 1, wherein the command to access data comprises a structured query language (“SQL”) or SQL-like query.

### Claim 3 (depends on 1)

The method of claim 1, wherein the command to access data comprises a stored procedure, a function or a subroutine.

### Claim 4 (depends on 1)

The method of claim 1, further comprising:
determining that the command to access data is associated with the ETL function based on command options.

### Claim 5 (depends on 1)

The method of claim 1, wherein the command to access data comprises a stored procedure and the stored procedure indicates a job name to call the ETL function.

### Claim 6

A non-transitory computer-readable medium comprising instructions that when executed by a processor perform a method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS; and
receiving the data associated with the command.

### Claim 7 (depends on 6)

The medium of claim 6, wherein the command to access data comprises an SQL or SQL-like query.

### Claim 8 (depends on 6)

The medium of claim 6, wherein the command to access data comprises a stored procedure, a function or a subroutine.

### Claim 9 (depends on 6)

The medium of claim 6, further comprising:
determining that the command to access data is associated with the ETL function based on command options.

### Claim 10 (depends on 6)

The medium of claim 6, wherein the command to access data comprises a stored procedure and the stored procedure indicates a job name to call the ETL function.

### Claim 11

An apparatus comprising:
a processor; and
a non-transitory computer-readable medium comprising instructions that when executed by the processor perform a method of importing data using a database management system (“DBMS”) with integrated Extract, Transform and Load (“ETL”) functionality, the method comprising:
receiving a command at a DBMS comprising an integrated ETL function to access data, wherein the command to access data comprises an SQL or SQL-like query and the query comprises a from statement that indicates a job name associated with the ETL function;
performing a lookup of the command in a data dictionary associated with the DBMS to determine that the command is to access data via the integrated ETL function;
loading an executable file associated with the command into the DBMS, wherein the command is determined to access data via the integrated ETL function;
executing, via a processor, the executable file associated with the ETL function in a memory space of the DBMS; and
receiving the data associated with the command.

### Claim 12 (depends on 11)

The apparatus of claim 11, wherein the command to access data comprises an SQL or SQL-like query.

### Claim 13 (depends on 11)

The apparatus of claim 11, wherein the command to access data comprises a stored procedure, a function or a subroutine.

### Claim 14 (depends on 11)

The apparatus of claim 11, wherein the method further comprises:
determining that the command to access data is associated with the ETL function based on command options.

### Claim 15 (depends on 11)

The apparatus of claim 11, wherein the command to access data comprises a stored procedure and the stored procedure indicates a job name to call the ETL function.

### Claim 16 (depends on 11)

The apparatus of claim 11, wherein the executable file comprises a Dynamic Link Library (“DLL”).

### Claim 17 (depends on 11)

The apparatus of claim 11, wherein the ETL function is represented as a data description language (“DDL”) object.