open source and informix dynamic server

《open source and informix dynamic server》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

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