1 / 13

SQL Databases on Unix: Comprehensive Overview and Best Practices Presentation

Dive into SQL databases on Unix systems with expert insights on architecture, performance tuning, and database management strategies for optimal efficiency. Learn about key technologies and practices from renowned industry professionals.

kennan-sosa
Download Presentation

SQL Databases on Unix: Comprehensive Overview and Best Practices Presentation

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. 01.09.2006 http://www.obs-itconsulting.com SQL-Datenbanken unter Unix Frankfurt/Main Presentation by Dipl.-Ing. Ralf Steffler Netcool Certified Consultant

  2. Hersteller IT-Abteilung eines Großunternehmens Microsoft HP IBM SAP Oracle Sybase Sun

  3. Solaris Linux HP-UX SUN HP Open Source Risc Betriebssystem-Hersteller Windows Microsoft Cisc 64 Bit Technik 32 Bit Technik

  4. Unix Symmetric Multi-Processing Preemptive Multitasking Since 1970 DOS Windows NT Multi-Processor Cooperative Multitasking 1995 Single Processor Single Tasking Single User 1981 Single Processor Cooperative Multitasking 1992 Unix

  5. S P E E D B G 2 3 U P C 8 z H G 1 SMP-Computer Super-Computer Unix Cray HP Superdome Sun Fire IBM eServer RAM SMP CPU Mid-Range

  6. Datenbank-Hersteller Produkt DB2 IBM Produkt 10g Oracle Sybase Produkt SQL Server 12 Günstige Alternativen Sehr Teuer Windows Microsoft SQL Server Linux MySQL (Open Source)

  7. Fremdschlüssel Primärschlüssel 1:n 1:n Relationen Eltern-Tabelle Kunden Kind-Tabelle Auftraege Kundenummer Artikelnummer Lieferdatum Preis bezahlt Kundenummer Artikelnummer Lieferdatum Preis bezahlt Kundennummer Nachname Vorname Strasse Hausnummer PLZ Ort Telefonnummer ... Auftragsnummer Kundennummer Artikelnummer Lieferdatum Preis bezahlt ...

  8. Oracle DB-Server Client-Server-Applications Enterprise Manager Designer L Q S Forms Help Desk 2000 TT-ID Contact Create Time New Close Time Customer Phone Clear TT-Status Email Category Search Problem Description Save Details

  9. MC Service G. SAM LEDs Management Oracle auf HP-UX Database Server Oracle OEM Cluster Unix Hardware

  10. Programs Tables Indexes Tuning DB auf 3 Platten verteilen Indices anlegen SQLServer Positive Abfrage Logik

  11. S R E S U H a B r d N D w a r G e I D S B E D D E d S r I B a G a N d H U S E e R S r a S Q L w Performance-Killer Bad SQL ist ein Performance-Killer d a B L Q S D B H a r dw a r e Bad D E S I G N U S E R S S Q L

  12. Indices Unique Index Tabelle Index 2581 9031 - .... Durchsucht1 MilliardeDatensätze Müller 9031 18318 - Schulz 10102 18318 - Schubert 18316 29346 - Albert 25348 28559 - in 31 Schritten .... 28559 29346 - 29346 - -

  13. Backup & Recovery Offline Backup Shutdown Database easy Copy Datafiles to Disk/Tape Online Backup dodgy Database up & running Consistent Database Dump

More Related