Python-oracledb：Oracle AI 数据库与 Python 的高级集成 [LRN2902].pdf

1、Python-oracledb:Advanced Integration for Oracle Database and PythonLRN2902-October 2025Anthony TTechnical Advisor,Oracle Database DriversAgenda3Copyright 2025,Oracle and/or its affiliates|Confidential:InternalDataFramesDirect Path LoadsSessionless TransactionsVECTOR Data TypeAsyncioPipeliningCentral

2、ized Configuration ProvidersFrameworkspython-oracledb driverPythonpython-oracledb5Copyright 2025,Oracle and/or its affiliatesNeed to KnowOracle Database driver for the Python languageRenamed,major upgrade of cx_Oracle driverPython DB API V2 support with Oracle extensionsDefault“Thin”mode:no Oracle C

3、lient librariesSingle step install create table MyTab(id number,name varchar2(100);#List of sequencesdata=(1,Abi),(2,Anna),(3,Jane),(4,Jessie)connection.direct_path_load(schema_name=SCOTT,table_nameMYTAB,column_names=ID,NAME,data=data)20Copyright 2025,Oracle and/or its affiliates|Confidential:Intern

4、alFrom a list of sequences or a DataFrame#DataFramedf=pandas.DataFrame(i:1,2,3,4,n:Abi,Anna,Jane,Jessie)connection.direct_path_load(schema_name=SCOTT,table_name=MYTAB,column_names=ID,NAME,data=df)21Copyright 2025,Oracle and/or its affiliates|Confidential:Internal2.318.049.30102030405060100,0001,000,

5、0002,000,000SecondsRowsReading a CSV file(number,date,string)and inserting into the databasePandas read_csv()-Pandas to_sql()Python CSV loader to list-executemany()PyArrow CSV loader to DataFrame-executemany()Python CSV loader to list-direct_path_load()PyArrow CSV loader to DataFrame-direct_path_loa

6、d()Direct Path Load Performance22Copyright 2025,Oracle and/or its affiliates|Confidential:Internal2.318.049.31.614.335.11.311.229.70102030405060100,0001,000,0002,000,000SecondsRowsReading a CSV file(number,date,string)and inserting into the databasePandas read_csv()-Pandas to_sql()Python CSV loader