MSSQL编程：分量级数据库 Ingres 正式开源

仓酷云

提供用于管理、检查、优化数据库操作的管理工具。数据|数据库Anonymous写著
http://www3.ca.com/Press/pressrelease.asp?CID=61597

CARELEASESINGRESINTOOPENSOURCE
CommunityisInvitedtoParticipateinShapingFuture
OfEnterprise-ClassDatabase
ISLANDIA,N.Y.,August4,2004-ComputerAssociatesInternational,Inc.(NYSE:CA)todayannouncedtheavailabilityofIngresr3undertheCATrustedOpenSourceLicense(CATOSL).ThereleaseenablestheopensourcecommunitytoreviewandsubmitmodificationstotheIngresr3codelineforpossibleinclusioninthegeneralavailabilityversion,scheduledforSeptember30,2004.

Thismarksthefirsttimeamajorenterprisesoftwarevendorhascollaborateddirectlywiththeopensourcecommunitytodeliverenterprise-classdatabasetechnology.

CATOSLisaderivativeofthecommonpubliclicensethatisavailablefromhttp://opensource.organdisOpenSourceInitiative(OSI)compliant.SoftwaredeveloperscanincorporateIngresintotheirownsolutionsaslongastheIngressourcecodeismadeavailableinaccordancewithCATOSL.CAwillprovidesupportforIngresr3,includingindemnification,asanaddedcostoption.

DevelopersandotherpartiescandownloadIngresr3todayathttp://ca.com/opensource.ThissitealsoprovidestechnicalandsupportinformationforIngresandCAsotheropensourceprojects.Contributorscansubmittheirmodificationstotheprojectatthissite.

"Ingresr3hasexceededourexpectationsthroughoutthebetatesting-providingpowerfulnewfunctionalityontheLinuxplatformwhilepreservingourexistingapplicationinvestments,"saidShafRahman,grouptechnicaldirectoratICLP,aglobalmarketingservicesagencywithofficesinsevencountries."TheinnovationthatCAisfosteringwiththeopensourcecommunitywilltakeIngrestonewheights,creatinganevenmoresophisticated,powerfulandadaptableopensourcedatabase."

Ingresr3isapowerful,provendatabaseplatformthatofferscustomerssuperlativeperformance,scalabilityandmanageability.Newfeaturesinclude:

*HighAvailabilityClustersformaintaininguninterruptedperformanceintheeventofafailureofonedatabaseorservernodewithinaclusterconfiguration.
*ScalableDatabaseClustersthatenablecustomerstouseLinuxandcommodityhardwaretoachieve24x7x365availabilitywithunmatchedeconomy.
*TablepartitioningandindexingdesignedtomeetthedemandsofVeryLargeDatabaseimplementations.
*Parallelqueryprocessing,whichprovidesunrivaledscalabilitybydividingindividualqueriesintocomponentsthatcanbeexecutedinparallelacrossallavailableresources.
*On-linetableandindexreorganization,whichsupports24x7availabilitybyallowingdatabasetablemaintenancetobeperformedwhilethedatabaseremainsonlineandinproduction.
*Theabilitytofullyexploit64-bitenvironments—includingimprovedqueryexecution,addressabilityof64-bitfilesystemsand64-bitdatabasecacheenablement.
*ComprehensivesupportforglobalbusinessdatasourcesunderUnicode,auniform,fixed-width,encodedcharacterset.

Ingrescanseamlesslyintegratewithotherapplicationsanddatainaheterogeneousenvironment.ThisisofparticularsignificanceasLinuxbecomesmoreprevalentinenterpriseITenvironmentsandcanbecomeimportantintheeventofabusinessmergeroracquisition.Itsease-of-integrationalsoallowsittobeusedwithawiderangeofapplicationdevelopmenttools.Ingresisespeciallywellsuitedforembeddedapplications,thankstoindustry-standardconnectivityoptionsthatallowdeveloperstoworkwithinaJ2EEframework,a.NETenvironmentorboth.

CATechnologyServicesisofferingawiderangeofcustomizableeducationcoursesandservices,bothon-siteandremote,tohelpcustomerstakeadvantageofIngresr3.

"ThetensofthousandsofcustomerswhodependonIngrestechnologytoruntheirbusinesscannowleveragethevastresourcesoftheopensourcedevelopmentcommunityaswellasCAsownR&D,"saidTonyGaughan,seniorvicepresidentofdevelopmentatCA."ReleasingIngresintoopensourceunderscoresCAsvisiontoembracetheopensourceparadigmtobestservetheinterestsofourcustomers."

ThisreleasefulfillsCAscommitmentatcaworld2004inMaytodeliverIngrestothecommunityunderCATOSLwithin90days.Ingresr3willalsobeavailableonWindows,UNIXandOpenVMS.导致了一个使用几乎和mSQL一样的API接口的用于他们的数据库的新的SQL接口的产生，这样，这个API被设计成允许为用于mSQL而写的第三方代码更容易移植到MySQL。

而写到本地,我又考虑到效率问题.大家来讨论讨论吧,分数不打紧,就给10分,十全十美,没啥对错,各抒己见,但是要有说服力的哦~

同样会为索引视图等应用带来麻烦。看看行级和事务级的快照数据放在tempdb中，就能感觉到目前架构的尴尬。

分区表效率问题肯定是大家关心的问题。在我的试验中，如果按照分区字段进行的查询（过滤）效率会高于未分区表的相同语句。但是如果按照非分区字段进行查询，效率会低于未分区表的相同语句。

从底层原理到表层引用，书籍多的很。个人认为没有什么那本书好？这样的说法。主要看和个人的学习方法是否适合。

现在是在考虑:如果写到服务器端,我一下搞他个10个存储过程导过去,那久之服务器不就成垃圾箱了吗?即便优化了我的中间层.

习惯敲命令行的朋友可能会爽一些。但是功能有限。适合机器跑不动SQLServerManagementStudio的朋友使用。

记得在最开始使用2k的时候就要用到这个功能，可惜2k没有，现在有了作解决方案的朋友会很高兴吧。

原来的计算字段其实和虚拟字段很像。只是管理方面好了而已，性能方面提高不多。但是SQL2005提供了计算字段的持久化，这就提高了查询的性能，但是会加重insert和update的负担。OLTP慎用。OLAP可以大规模使用。