Introduction to the Data Model

IntroductiontotheDataModelDevelopersReidCarlberg:salesforce.com@ReidCarlberg@ForceDotComLabsSafeHarborSafeharborstatementunderthePrivateSecuritiesLitigationReformActof1995:Thispresentationmaycontainforward-lookingstatementsthatinvolverisks,uncertainties,andassumptions.Ifanysuchuncertaintiesmaterializeorifanyoftheassumptionsprovesincorrect,theresultsofsalesforce.com,inc.coulddiffermateriallyfromtheresultsexpressedorimpliedbytheforward-lookingstatementswemake.Allstatementsotherthanstatementsofhistoricalfactcouldbedeemedforward-looking,includinganyprojectionsofsubscribergrowth,earnings,revenues,orotherfinancialitemsandanystatementsregardingstrategiesorplansofmanagementforfutureoperations,statementsofbelief,anystatementsconcerningnew,planned,orupgradedservicesortechnologydevelopmentsandcustomercontractsoruseofourservices.Therisksanduncertaintiesreferredtoaboveinclude–butarenotlimitedto–risksassociatedwithdevelopinganddeliveringnewfunctionalityforourservice,ournewbusinessmodel,ourpastoperatinglosses,possiblefluctuationsinouroperatingresultsandrateofgrowth,interruptionsordelaysinourWebhosting,breachofoursecuritymeasures,theoutcomeofintellectualpropertyandotherlitigation,risksassociatedwithpossiblemergersandacquisitions,theimmaturemarketinwhichweoperate,ourrelativelylimitedoperatinghistory,ourabilitytoexpand,retain,andmotivateouremployeesandmanageourgrowth,newreleasesofourserviceandsuccessfulcustomerdeployment,ourlimitedhistoryresellingnon-salesforce.comproducts,andutilizationandsellingtolargerenterprisecustomers.Furtherinformationonpotentialfactorsthatcouldaffectthefinancialresultsofsalesforce.com,inc.isincludedinourannualreportonForm10-KforthemostrecentfiscalyearendedJanuary31,2010.ThisdocumentsandothersareavailableontheSECFilingssectionoftheInvestorInformationsectionofourWebsite.Anyunreleasedservicesorfeaturesreferencedinthisorotherpressreleasesorpublicstatementsarenotcurrentlyavailableandmaynotbedeliveredontimeoratall.Customerswhopurchaseourservicesshouldmakethepurchasedecisionsbaseduponfeaturesthatarecurrentlyavailable.Salesforce.com,inc.assumesnoobligationanddoesnotintendtoupdatetheseforward-lookingstatements.AskyourquestionsintheDreamforceOrg!WhoHas…Noorverylittleforce.comexperience?Modifiedastandardobject?Createdacustomobject?Developedacomplexappontheplatform?ProfessionalexperiencewritingSQL?Force.com:MoreThanaRepositoryStoreManageUnderstandSecureUISearchScaleDRToday’sGoalsCreateobjects,fieldsandrelationships.Leveragerelationship,summaryandformulafields.Connecttosecurity,analytics,UI,APIandotherservices.Nextsteps!TheLingo(OldNew)TablesObjectsColumnsFieldsKeysIds,ExternalIdsForeignKeysRelationshipsRowRecordStandardObjectsUsers,Accounts,Contacts,Opportunities,Cases,etc.StandardObjectsAreWellDocumented’sDemoApp:ProjectManagementProject__cMilestone__cAction__cUserNosuffix:Standard;“__c”,custom;“__r”,relationship;“Feed”&“__Feed”;“Share”&“__Share”;“History”&“__History”;“Tag”&“__Tag”Let’sBuildanApp!CommonFields:Identity,OwnershipandAuditID*GUIDNameTextorAutonumberOwnerLookuptoUserCreatedBy*LookuptoUserCreatedOn*DatetimeLastModifiedBy*LookuptoUserLastModifiedOn*Datetime*100%managedbyForce.comRelationshipsAreEasy!Project__cMilestone__cAction__cUserCustomMasterDetailStandardLookupCustomLookup“Milestone__c”“Project__c”“OwnerId”“User__c”ManytoManyRelationshipsAreEasyProject__cAccountAccountProjectJoin__cTwinCustomMasterDetailRollUps,Formulas,ExternalIDsRelationshipsArePowerfulProject__cMilestone__cAction__cUser“ShowmeMary’sAssignment”5OpenTasks30OpenTasksFormulasSpreadsheetlikesyntaxFielddefaultvalueStandalone&combinationformulasEvaluatedataccess(view,API,report,etc)ExternalIDsGreatforintegration/migration.RequiredfortheUPSERToperation.Facilitateautomaticforeignkeyresolution.Search,Analytics&SecurityMiscTopicsAPI:SOAP,REST,Bulk,MetadataSOQLandtheForce.comIDERecordtypesCustomsettingsRecyclebins:record,field&objectKeystoSuccessKnowyourproblemdomainModelsmart……butdon’tovernormalizeUsenativeforce.comfeaturesBesecurityawareNextStepsGetaDeveloperEdition–AttendAnotherIntroSession!–Workflow–Today2:15p–Force.comCode-Apex–Today3:45p–Force.comPages-Visualforce–Today5:15pChatterResourcesTwitterResources–@ReidCarlberg,@ForceDotComLabsIntroductiontotheDataModelDISCOVERVisittheDeveloperTrainingandSupportBoothinForce.comZoneDevelopertraining,certificationandsupportresourcesSUCCESSFindusinthePartnerDemoAreaofForce.comZone2ndFloorMosconeWestthathelpyouachieveRemember...CheckChatterforadditionalsessioninformationGetyourdeveloperWorkbooksandCheatSheetsintheForce.comZoneVisitformoreinformationrelatedtothistopicDon’tforgetthesurvey!HowCouldDreamforceBeBetter?TellUs!LogintotheDreamforceapptosubmitsurveysforthesessionsyouattendedUsetheDreamforceMobileapptosubmitsurveysEverysessionsurve