1 / 14

Oracle 11G XE

Oracle 11G XE. Cuprins. Introducere Cui se adreseaza? Ce ofera? Ce nu ofera? Posibile configuratii Avantaje utilizarii Intrebari. Introducere. Prezentator: Ciprian Onofreiciuc. Inginer in stiinta sistemelor si a calculatoarelor

stu
Télécharger la présentation

Oracle 11G XE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle 11G XE

  2. Cuprins • Introducere • Cui se adreseaza? • Ce ofera? • Ce nu ofera? • Posibile configuratii • Avantaje utilizarii • Intrebari

  3. Introducere Prezentator: Ciprian Onofreiciuc • Inginer in stiintasistemelorsi a calculatoarelor • Administrator baze de date sisisteme Linux Oracle certificat • SQL Expert • Oracle PL/SQL DezvoltatorCertificat

  4. Introducere (cont.) Oracle 11G Express Edition • Lansata la mijloculanului 2011, succede 10G XE dupamaibine de 5 ani • Corespunde release-ului R2 a versiuniicomerciale • Prezintaversiunipentrusistemele Windows pe 32bit si Linux, pe 64 bit

  5. Cui se adreseaza? • 11G XE reprezinta un mediu de start pentru oricine doreste sa exploreze si sa invete tehnologiile Oracle, fara cost de licentiere • Dezvoltatorilor care doresc o baza de date pentru dezvoltare (PHP, Java, .NET, si alte tehnologii) • Integratorilor SW si HW care doresc o baza de date pe care sa o distribuie fara cost de licentiere • Institutiilor de invatamant precum si studentilor care au in curiculum cursuri de BD

  6. Ce ofera – limitari sistem • Installer grafic ~ 300 MB • Instalat are nevoie de 1.5 GB spatiu • Utilizeaza - 1 CPU (2 core-uri x86) – chiar in situatia in care sistemuloferamaimulteprocesoare, baza de date se vacomporta ca si cum arexista un singurprocesor. • Utilizeaza – minim 250 MB – max 1 GB memorie RAM (SGA+PGA) • Oferaspatiugazduire de date util – 11 GB • O singurainstanta de baze de date : xe

  7. Ceofera – Sist.Operaresuportate 64 Bit • Oracle Enterprise Linux 4 Update 7 / OEL 5 Update 2 • Red Hat Enterprise Linux 4 Update 7 /RHEL 5 Update 2 • SUSE Linux Enterprise Server 10 SP2 / SUSE ES 11 32 Bit • Microsoft Windows XP Professional • Microsoft Windows Server 2003 / 2003 R2 • MS Windows Server 2008 – Standard/Enterprise/Datacenter/Web, +Foundation editions. • MS Windows 7 - Professional, Enterprise, and Ultimate editions

  8. Ce ofera – functionalitati dezvoltare • Suportpentrucaractere Unicode - AL32UTF8 • Mediu de dezvoltare web integrat(APEX) • PL/SQL • JDBC / OLE & ODBC (Windows) • DML / Database event / Instead Of A Triggers • Index organized tables • Temporary Tables • Objects • LOB • Function based index • Regular Expressions • SQL Analytic Functions • Encryption toolkit

  9. Ce ofera – functionalitati de management/disponibilitate/backup • Flashback Query • Drop / Rename Column • Oracle Logminer • Online Backup • Incremental backup and recovery • Automatic datafile management • Automatic Memory management • Automatic Undo Management • Automatic Optimizer Statistics Management

  10. Ce ofera – functionalitati de integrare de date • Direct Path Load API • External Tables • Distributed Queries • Distributed Transactions

  11. Ce nu ofera • Database Web services – oficial nu existasuportpentru web services, obs: DBMS_XDB oferaposibilitateaimplementarii de servici web • Java suport in DB • FlashBack table/database • Data Compression • Bitmap index • Parallel queries • Virtual Private Database • Fine grained auditing • Database Resource Manager • Transportable Tablespace • Automatic Storage Management

  12. Posibile Configuratii • Aplicatiidezvoltatepetehnologii de programare orientate • PL/SQL – APEX cu embeded GW/Apex Listner/Mod_PLSQL • Java – cu servere de aplicatii (Glassfish / Weblogic / Jboss/etc.) sau stand-alone • .NET – utilizand Oracle Data Provider sau Oracle Database Extensions for .NET • PHP – utilizand Apache siZend Core for Oracle si OCI8

  13. Avantajele Utilizarii • Gratuit • Linux si Windows suport • APEX framework • O baza de date standard SQL cu un limbajprogramatic

  14. Intrebari

More Related