MYSQL网页设计典范Oracle图书保举(之四)

需要处理因此带来的更多的支持工作，这有可能会带来成本上的提高。在这种情况下，一些MySQL学习教程发行商可能倾向于选择别的开源数据库，例如遵循BSD授权的PostgreSQL。oracle典范的Oracle图书:

OracleHighPerformanceTuningfor9iand10gbyGavinPowell
BookDescription
TherearethreepartstotuninganOracledatabase:datamodeling,SQLcodetuningandphysicaldatabaseconfiguration.
Adatamodelcontainstablesandrelationshipsbetweentables.Tuningadatamodelinvolvesnormalizationandde-normalization.Differentapproachesarerequireddependingontheapplication,suchasOLTPoraDataWarehouse.InappropriatedatabasedesigncanmakeSQLcodeimpossibletotune.PoordatamodelingcanhaveamostprofoundeffectondatabaseperformancesinceallSQLcodeisconstructedfromthedatamodel.

Paperback:544pages;Dimensions(ininches):1.38x9.22x7.08Publisher:DigitalPress;(December8,2003)ISBN:1555583059AverageCustomerReview:Basedon4reviews.

PoorlywrittenSQLcodeisoftenaculpritofperformanceproblemsandisexpensivetorectify.However,tuningofSQLcodeisgenerallycheaperthanchangingthedatamodel.SQLcodetendstobecontainedinsideindependentblockswithinapplicationsorstoredprocedures.

Physicaldatabasetuninginvolveshardwareresourceusage,networkingandvariousotherOraclethingssuchasconfigurationandfiledistribution.PhysicalconfigurationisoftenaculpritofpoorperformancewhereOracleisinstalledwithdefaults,andneveralteredbyanexpert.

*IncludesallthreeaspectsofOracledatabasetuning:datamodeltuning,SQL&PL/SQLcodetuning,physicalplusconfigurationtuning
*Containsexperiencedguidanceandreal-worldexamplesusinglargedatasets*Emphasizesdevelopmentasopposedtooperatingsystemperspective


我在这里供应下载:当地下载
OracleEssentials,3e:OracleDatabase10gbyRickGreenwald,RobertStackowiak,JonathanStern

BookDescription

Theneweditionofthisclassicbook,OracleEssentials,3rdEdition:OracleDatabase10g,distillsavastamountofknowledgeintoaneasy-to-readvolumecoveringeveryaspectoftheOracledatabase.ReadersofalllevelswilllearnaboutOraclesfeaturesandtechnologies,includingtheproductline,architecture,datastructures,networking,concurrency,tuning,andmuchmore.Featuringfocusedtext,abundantillustrations,andhelpfulhints,theneweditionoffersavaluableoverviewofOraclesDatabase10g--theindustrysfirstdatabasetosupportgridcomputing.
Paperback:400pages;Dimensions(ininches):0.98x9.18x7.08Publisher:OReilly;1edition(February11,2004)ISBN:0596005857
AverageCustomerReview:Basedon2reviews.RecentreleasessuchasOracle9iand8iarealsocovered.Morecomprehensiblethanalargereference,andmoredetailedthanmotprimers,thisbookcoversalltheinformationyoullneedtoinstallandruntheOracledatabases,aswellastheconceptualbackgroundyoullwanttounderstandhowtheywork.IfyourenewtoOracleorupgradingtoOracle10g,youllfindthisall-in-oneguideessential.
供应下载:
当地下载

Oracle9i:TheCompleteReferencebyKevinLoney,GeorgeKoch
从Oracle8到Oracle9i，这本书一向是进门者的很好的案头参考书之一.
BookDescription
MasterallthepowerfulfeaturesofOracle9iusingtheexclusiveinformationinsidethisindispensableresource.Writtenbybest-sellingOraclePressauthorsKevinLoneyandGeorgeKoch,thisvolumeexplainshowtoimplementallthecomponentsofOracle9i.Thisisamust-havereferenceforallOracleprofessionals.
Paperback:1256pages;Dimensions(ininches):2.42x9.10x7.34Publisher:McGraw-HillOsborneMedia;1edition(August16,2002)ISBN:0072225211AverageCustomerReview:Basedon7reviews.


我在这里供应下载:
当地下载

Oracle9iDBAJumpStartbyBobBryla

BookDescription
InterestedinacareerasanOracledatabaseprofessionalbutdontknowwheretobegin?TheOracle9iOCAandOCPcertificationsaretwoofthehottestITcertificationsaround,andtheOracle9iDBAJumpStartfromSybexcanprovideyouwiththesolidfoundationindatabaseadministrationandprogrammingbasicsyoullneedbeforeembarkingonacomprehensivestudyprogram.TheJumpStartserieswasdevelopedinresponsetorequestsfromtechnicaltrainersseekingtoensurealevelstartingpointforstudentsintheirclassrooms.TheauthorisanexperiencedOracleinstructorwhoprovidessimple,tangibleexplanationstomaketheworldofdatabasesaccessibletonewcomerstotheITfield.Youlllearnaboutrelationaldatabaseconcepts,SQL*PlusoriSQL*Pluscommands,sortingandreportingtechniques,security,andmuchmore.Whenyouredonewiththisbook,youllbereadytofacethechallengesofOracle9icertificationpreparation.

Paperback:400pages;Dimensions(ininches):0.78x9.16x7.40Publisher:SybexBooks;1edition(March4,2003)ISBN:0782141897


我在这里供应下载:
当地下载MySQL对硬件的较低要求是其最大的优势之一，不过需要注意的是：内存越多越好，因为所有的重要数据存储都在内存中完成。

sqlserver的痛苦之处在于有用文档的匮乏，很多只是表明的东西

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

个人感觉没有case直观。而且默认的第三字段（还可能更多）作为groupby字段很容易造成新手的错误。

其中最有名的应该是row_number了。这个终于解决了用临时表生成序列号的历史，而且SQLServer2005的row_number比Oracle的更先进。因为它把Orderby集成到了一起，不用像Oracle那样还要用子查询进行封装。

比如，MicrosoftSQLServer2008的某一个版本可以满足现在的这个业务的需要，而且价格还比Oracle11g要便宜，那么这一产品就是适合的。

至于淘汰的问题，只能说在你的项目周期之内，微软应该都不会倒闭。

两个月啃那本sqlserver2005技术内部-存储引擎，花了几个月啃四本书

我是一个ERP初学者，对于前台运用基本熟悉，但对于后台SQLServer的运用一点也不懂，特想学习下相关资料。至少懂得一些基本的运用。希望各位能给于建议，小弟再谢过！