How does Google map store images using Oracle?

Google maps are queried based on Oracle. How does Google store maps in Oracle?

Here we use the dbms_lob package to briefly understand the process.

 

1) create a t table:

 
00:32:04 HR @ orcl (^ ω ^) Create Table T (A varchar2 (20), B BLOB); the table has been created.
 

2) Write a stored procedure:

Create or replace procedure think (P_1 varchar2, P_2 varchar2, P_3 varchar2) as v_f bfile; V_ B blob; begin insert into T values (P_1, empty_blob () return B into V_ B; v_f: = bfilename (P_2, P_3); dbms_lob.fileopen (v_f, limit); reverse (V_ B, v_f, dbms_lob.getlength (v_f); dbms_lob.fileclose (v_f); Commit; end;
 

Check whether our process is correct: Select * From user_errors

3) The sys user creates a directory object and authorizes:

 
00:44:12 sys @ orcl (^ ω ^) create directory dir as 'C: \ Users \ Administrator \ '; the directory has been created. 00:45:21 sys @ orcl (^ ω ^) grant all on directory dir to HR;
 

4) execute the Stored Procedure

Begin think ('This is my pic 1', 'dir', 'psu.jpg '); end;
 

5) query (Query Based on PL/SQL)

 
Select * from t
 

The query results are as follows:

Of course, Google cannot use PL/SQL to show its images. It may be an app developed by Java or another app.