第6章数据库服务器

6WorldWideWedWebWebRDBMSStructuredQueryLanguage,SQLIBMDB2PostgreSQLSybasePostgreSQLPostgresRDBMSANSISQLUNIXPostgreSQLRedHatLinux6.0PostgreSQLSybaseAdaptiveServerEnterpriseRDBMS1998SybasePostgreSQLRedHatLinuxSybaseRPM/sybaseSybasePostgreSQLWebSQLHTMLSQLWeb6.1PostgreSQLRedHatLinux6.0PostgreSQLComponentstoInstallSQLServicesPostgreSQLpostgres/etc/rc.dUNIXinitRedHatLinux6.0PostgreSQLRPMRedHat/PRMsRedHatFTPPostgreSQLRPMPostgreSQLntsysv/etc/rc.d/init.d/etc/rc.d/rcX.dPostgreSQLPostgreSQLpostmaster6.2PostgreSQLDBMSWebPostgreSQLPostgreSQLPostgres/etc/rc.d/init.d/postgresqlrestartPostgreSQLRedHatluserlusernobodyluserluser6-16-1Postgreuseradd/etc/passwdcreateuserPostgreSQLpasswdluserUNIXnobodyWebIDPostgreSQLUNIXSybaseSysbasenobodyWeb683lusercreatedbshoppingDBMSdBasedatabaseRelationPostgreSQLtablecreatedbluserSQLpsqlshoppingSQLSQLlistPostgreSQLitemvendorcodequantityvendorcodequantityitemSQLSQLvendorsSQLINSERTINSERTINTOvendorsVALUES(100,'SuperGrocer');INSERTINTOlistVALUES('RootBeer',100,3);84RedHatLinux6NULLSQLSELECTSELECTitem,vendorcode,quantityFROMlist;SQLSELECTSELECTvendorcodevendornamevendornamevendors685vendorcodevendorsvendornameFROMWHERESQLjoinSELECTtablename.fieldnameSQLSELECTSELECTSQLORDERBYitemPostgreSQLSELECTUNIXSQL86RedHatLinux6[outerjoin]INSERTINSERTINTOlist(item,vendorcode,quantity)VALUES('AfricanViolet',103,1);SELECTlistAfricanVioletSELECTINSERTINTOvendors(vendorcode,vendorname)VALUES(103,'ACMEPlantStore');SQLUPDATElistSETitem='AfricanViolets'WHEREvendorcode=103;103WHERESQLDELETEDELETEFROMlistWHEREitem='AfricanViolet';DELETEFROMvendorsWHEREvendorcode=103;DELETEFROMlistindexSQLCREATEINDEXlisttabONlist(vendorcode);CREATEUNIQUEINDEXvendortabONvendors(vendorcode);vendorsvendorcodePostgreSQLVACUUMlist;VACUUMvendors;WebSELECTRedHatLinuxWebnobodyIDSELECT687REVOKEALLGRANTREVOKESQL\qpg_dumpPostgreSQLSQLshoppingShellpg_dumpshoppingdb.outShellpsql-eshoppingdb.outpsqlGNUReadlineEmacsControl-AReadlinevi16.3SybaseSybaseAdaptiveServerEnterpriseRDBMSPastgreSQLSybase/sybaseSybaseLinuxSybaseHTML110MB40MBRPM/opt/optRPMSybase/home/opt/homeSybase/homePHPPHP/opt/homecd/;ln-shomeoptSybaseAdaptiveServerEnterpriseRPMrpm-Uvhsybase-ase-11.0.3.3-1.i386.rpmYesRPMsysbase/yessybaseysybasesybaseysybasesybaseysybaseUNIXsybase88RedHatLinux6Sybaserpm-Uvhsybase-doc-11.0.3.3-1.i386.rpmsybinitsu-sybasesybinity311SQLSybaseSybaseSYBASESybaseSYBASESybase/home/sybase/689interfaces/etc/hosts1ControlASybaseControlASQL13SQL90RedHatLinux62SQLTCP1433Sybase7100RedHatLinux6.0X-Windows7100xfsSybase7100XMicrosoftSQLServer1433WindowsODBCControlAYServerInterfacesFileEntrymenuControlAY2ControlAWARNING:'/home/sybase/master.dat'isaregularfilewhichisnotrecommendedforaServerdevice.691Linux3ControlA92RedHatLinux64ControlA5693SybaseControlA6ControlA94RedHatLinux67ControlA6958ControlA96RedHatLinux69ControlA697SQLControlASQLY98RedHatLinux6ControlAControlA211SYB_BACKUP699ControlA32TCP1434ControlAYControlAinterfacesYControlAInterfaces100RedHatLinux6interfaces321ControlAControlAY6101ControlAControlA4Sybase132333CSQL102RedHatLinux6sybinitControlASybinitsybinitShellLinuxSybaseAdaptiveServerEnterprise11.0.3.3/etc/profilePATHSybaseSybaseSybaseShell/home/sybase/installRUNexec#RUN_SYBASERUN_SYB_BACKUPSybaseSQLisqlsqshSQLShellforSybaseGNUReadlineXWindowsqsh~gray/sqsh.htmlsybasesqshShell$SYBASE/binLinuxbugSybasebug2.0.36prepatch72.0.36prepatch7RedHatLinux5.0RedHat6.0Linux2.2SybaseRedHatLinux5.12.0.36SybaseSybaseASEGNUCglibcSybaseClibc5libc5RedHatLinux4.2,Slackware3.2CT-Liblibc5DB-LibLinuxTCP/IP6103Sybasesybase/oldlibssybasesqshSQLShellecho-eshutdownSYB_BACKUP\ngo\nshutdown\ngo\n|\/usr/local/bin/sqsh-SSYBASE-Usa-PsapassSybasesaSYBASE-Ssqshstop/etc/rc.d/init.d/sybase/etc/rc.d/init.d/sybaseSybaseIDENTITYburnIDENTITYburnSybasekillprocsqsh/etc/rc.d/init.d/sybase6.4SybasePostgreSQLSybaseLinuxext2fsUNIXSybasefdiskSybaseLinuxSybase/devI/OSybaseSybasesybinitSQLSybaseSybaseLinuxSybase/dev/sdb1SybaseLinuxSybaseASESybaseforLinux6.5SybaseSybaseSybasemaster104RedHatLinux6DBASybase2KB1MB=512SybaseSybaseisqlSQLsqshsqshisqlisql-Usa-SSYBASEsqshSQLGNUReadlineXWindow-U-SinterfacesSYBASEShellisql/home/sybase/bin/isql/opt/sybase/bin/isqlsqshSQLsaSybase20MBisqlsaDBAgoSybasegoPostgreSQLgosqshSybaseUNIXSybaseUNIXUNIXPostgreSQL6105SybaseSQLdumptransactionwithno-log5MBluserluserisqlisql-Uluser-SSYBASEisqlCREATEDATABASEshoppingONgendev=20LOGONgentran=5godiskinit2KBSybaselusersp_modifyloginluser,defdb,shoppinggopostgreSQL6-2Sybase106RedHatLinux66-26107clusteredindexSQLDELETESQLDROPINDEXCLUSTEREDSybasebcpbcpSybaseselectWHERE*==*SybaseSQLUPDATElistSETitem='AfricanViolets'WHEREvendorcode=103;dumptranshoppinggosp_helpdevicedumptranshoppingwithtruncate_onlygodumpdatabaseshopping108RedHatLinux6goSybase6109