資源描述:
《open source and informix dynamic server》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、OpenSourceandInformixDynamicServerJonathanLefflerIBMInformationManagementI07Tuesday3rdOctober2006?15:15–16:15AgendaOpenSourceConnectingtoIDSPerl,DBI,andDBD::InformixTcl/TkandisqltclPHPAubit4GLSQLCMDSQSLPythonRubyOpenSourceWhatisOpenSource?Whichrockhaveyoubeenhidingunder?Softwarereleasedunderan
2、OpenSourcelicenseConformantwiththeOpenSourceDefinitionFoundathttp://www.opensource.org/FreeRedistributionSourceCodeDerivedWorksPermittedNoDiscriminationAgainstPeopleorGroupsNoDiscriminationAgainstFieldsofEndeavourDistributionofLicenseOpenSourceLicensesTherearemanyOpenSourcelicensesGPL–GNUGener
3、alPublicLicenseLGPL–GNULesserGeneralPublicLicenseBSD–BerkeleySystemsDistributionMIT–MassachusettsInstituteofTechnologyMPL–MozillaPublicLicenseAcademicFreeLicenseOpenSoftwareLicenseNearly60licensesattheOpenSourceInitiative!InformixDatabaseConnectivityESQL/CTheoriginalconnectivity.Standardizedin
4、SQLbyISO/IEC9075:1992ODBCOriginallydefinedbyMicrosoft.Standardized(asCLI)byISO/IEC9075-3:1996.JDBCJavaanalogueofODBC.StandardizedbySun.Alloftheseareproprietary.ButcanbeusedwithOpenSourcesoftware.ESQL/CPreprocessorthatconvertsextendedCintopureC.Linkswithspecificlibraries.Separatesstaticanddynam
5、icSQL.EventhoughInformixdoesnotreallydoso.intmain(void){EXECSQLWHENEVERERRORSTOP;EXECSQLDATABASEStores;EXECSQLBEGINWORK;EXECSQLDROPTABLECustomer;EXECSQLROLLBACKWORK;return(0);}ODBCDatabaseagnostic.Separatesdrivermanagerfromdrivers.Differentdriverscanbeloadedatruntime.Youcanavoiddatabase-specif
6、icfeatures.Butsometimesyouwanttousethem.Allstatementsaredynamic.De-emphasizedbyMicrosoftInfavourofnewertechnologiesADO,.NETJDBCDatabaseagnostic.DrivershavedifferentlevelsofJava-ness.Type4:pureJava–usuallythebesttypetouse.TheotherwaytoconnectinJavaisESQL/J.Notwidelyaccepted.JDBCisthelinguafranc
7、aoftheJavadatabaseworld.Perl–PracticalExtractionandReportLanguageOriginallywrittenbyLarryWallVersion1.0in1987Version5.0in1994Version6underdevelopmentforalongtimeApocalypse1postedApril2001(athttp://perl.com/)Currentstableversion:5.8.8—Fe