configuring and administration of data storeds 400adm配置管理数据存储

OpenLABCDS

AdministrationDataStoreServerAdministration

Tang,Yang

ApplicationEngineer,PSO

<21/08/2014>1AgendaWhatisOpenLABDataStore?DataStoreSoftwareandHardwareRequirementsDataStoreLicensingDataStoreConfigurationDataStoreUserInterfaceFolderpermissionsusinggenericprojectsArchivingDataStoreArchitectureBackupandRestoreTroubleshooting/LogfilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A2Overview3WhatisDataStore?SecurecentralstorageforOpenLABCDSEZChromandChemStationeditionsHandleslocalizedChineseandJapanesecontentForlaboratoryenvironmentswith≤15concurrentinstrumentsThefoundationfornewmarketopportunitiesbydeliveringanall-in-onesolutionthatincludesCDS,DataStore,SharedServicesandELN/Notebook.SupportedforbackendstorageonnetworkedanddistributedconfigurationsofbothChemStationandEZChromeditions.StoragebasedonSQL2008R2database.Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A4WhyDataStore?

Simplesolutionforscientificcontentmanagement

OpenLABECM:DifficulttoremovefunctionalityfromOpenLABECMOpenLABECMlocalizationverycostlyProprietaryarchitecture,requiresabuildonlyphilosophyDataStore:FunctionalitycanbeaddedasmodulesCorealreadyinternationalizedIndustryStandardsolutionprovidesaccesstolargeecosystemtobuildoutthecoremorequicklyRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A5ValueProposition–OpenLABCDS&DataStoreFORsmalltomediumlaboratoriesinPharmaandChemicalindustriesWHOdesireAnetworkedCDSsolutionthatsecuresandmanagesitsdatainacentralstorageFullsupportforoperatinginlocallanguages(ChineseandJapanese)aswellasinEnglishCDSsupportforbothAgilentandNon-AgilentinstrumentsAgilentOpenLABoffersanintegratedsolutionwithsimplifieddeploymentbasedonanopenstandardsplatformthatmeetsyourneedstodayandalsoallowsyoutoextendfunctionalityovertimeRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A6WhatisOpenLABDataStore?Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A7October9,2024AgilentConfidential7EfficientDataStorageandRetrievalCentralizedStorageforOpenLABCDS&ELN*SupportsprojectbasedorganizationandrightsFilescanbeefficientlysearchedandretrievedLocalLanguageSupport(Chinese&Japanese)SecurityFullysecuresdataAuthorizesaccessforregistereduserswithrolesIntegrateswithOpenLABControlPanel

DataIntegrityandTraceabilityFilehistoryismaintainedActivitiesarefullyauditedTrailofwhohaswhatitemTrailofwhenanitemwasreceived21CFRPart11CompliantProductbuilttoFDAregulationsDataIntegrityandTraceabilityElectronicSignaturesSecurerepositoryforstorageofrawdataandreportsfullfiling21CFRPart11andGMP/GLPrequirements.OpenLABDataStoreOpenLABSharedServicesDataStoredelivers21CFRPart11ComplianceOpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A8FDA21CFRPart1111.1,11.2,11.311.1011.3011.5011.7011.10011.20011.300(a),(b),(d)11.300(c),(e)ChemStationOnly

ChemStation+DataStore

*

EZChromEditionwithAFS

*

Accurateandcompletecopiesofrecords.Versioningofallrelevantrecordsfortraceability.PreservationofrecordsbetweentheircreationandtheirautomatictransfertoOpenLABDataStoreimmediatelyafteracquisition,reprocessingorinteractivemodifications.Controlledcopiesofthedata.MandatorylogintoOpenLABDataStorebeforeallowingaccesstotheCDS.Recordsofchangescapturedinuser-independenttime-stampedaudittrails.OpenLABDataStoreenablesfullsupportforallcompliancerequirementsmandatedby21CFRPart11.*Thisrulesappliesonlyto“opensystems”,whenthelaboratoryhasnocontroloverwhoaccessesthesystemRev1.0-June2012DataStoreProductStructureProductNumberOptionProductDescriptionG6750AAOpenLABDataStoreProvidesthefollowing:DataStorelicenseforsingleSQLServerLicenseOpenLABSharedServicesLicense100OpenLABDataStoreCDSInst.LicenseProductNumberOptionProductDescriptionG6777AAOpenLABDataStoreCDSInst.LicenseLicensetostoredatafromoneinstrumentinDataStoreRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A9CoreDriverSWLicenseInstControlLicenseAdd-onLicenseServerLicenseLegend:M8400AA:OpenLABCDSInst.DriverforAgilentGCM8500AA:OpenLABCDSInst.DriverforAgilentLCM8360AA:OpenLABCDS3DUVAdd-onM8400AA:OpenLABCDSInst.DriverforAgilentA/DM8201AA:OpenLABCDSEZChromWorkstationM8237AA:OpenLABCDSEEVarianCP38/3900,CP-200XM8300AA:InstrumentControlLicenseM8305AA:OpenLABCDSSharedServicesServerSWG6750A:DataStoreServerDataStoreSystemLicensingG6777AA:DataStoreInstrumentControlLicenseG6777AA:DataStoreInstrumentControlLicenseG6777AA:DataStoreInstrumentControlLicenseG6777AA:DataStoreInstrumentControlLicenseTwonewlicenseoptionshavebeenintroducedtosupporttheuseofdatastoreasthestoragelocation.Eachinstrumentrequiresadatastorespecificinstrumentcontrollicenseinadditiontotheexistinglicenses.(G6777AA)ADataStoreServerlicenseisrequiredinadditiontothesharedserviceslicenseontheserver.(G6750AA)Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A10DataStore

Architecture11ContentStorageRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A12DSData9

contentstore9

YYYY9

M9

DD9

HH9

mm9

{guid}.binDSIndex9

solrFileSystemStorageRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A13Alsocalled“dir.root”itcontainsthebinarycontent.The“Solr”indexesarestoredbydefaultinthesamedriveastheonechosenforthedatabasefiles.ApertiesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A14OpenLABDataStoreArchitectureRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A15PlatformSQLServerApplicationServer(TomCat)CoreAlfrescoServicesExtensionsContentRepositoryWebServer(TomCat)WebServicesRemoteAPIsProtocolsCIFSWebDAVFTPIMAPSharePointAgilentWebUIAgilentFilter/sAgilentWebServicesE-SigAuditSearchOLSSSecurityOLSSServerInstrumentsProjectsSecurityOpenLABCDSClient/sOpenLABControlPanel(OLCP)OpenLABCDSOLSSAPIDataStoreAPIAlfrescoModuleAgilentDataStoreModuleOtherAgilentModuleWindowsOSBrowser/sPlatformModule/3rdPartyComponentsDiagnosticsUserLicenseServerLicensingAPILocalRAIDSOLRStorageSearchStartupLicenseFlexeraMgmtNotebooklicensingFlexeraServer(FNP)LicensingEmbeddedAPIsOpenLABDataStoreServerShareHiddenAlfrescoModuleDataStore

SoftwareandHardwareRequirements16SupportedTopologiesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A17OpenLABSharedServicesandDataStoreServer“AllinoneServer”DataStoresystemsaresupportedinnetworkedworkstationanddistributedconfigurations.DataStoreserversarealwayscoupledwiththeSharedServicesserverwheninstalled.SharedservicesmanagesuseraccountaccessrightsandsynchronizeswithDataStorepermissions.SoftwareandHardwarerequirementsMicrosoftWindowsServer2008R2withSP1+MSHotfixesKB2577795andKB2600907MicrosoftSQLServer2008R2SP1(STDorEnterpriseOnly)SQLServer2008mustbepre-installedOpenLABDataStoreisaddedtotheOpenLABCDSdisksetasaseventhdisk.

mendedserverspecifications:Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A18SmallServerConfiguration

(5instrumentsfor3years)LargeServerConfiguration

(15instrumentsfor3years)CPU2x(IntelXeon2.93GHz4Core)2x(IntelXeon3.06GHz6Core)Memory16GB(1333Ghz)24GB(1333Ghz)Disk1:

OS,DB,Indexes2x(300GB15KrpmSCSI)RAID12x(300GB15KrpmSCSI)RAID1Disk2:Data3x(1TB7.2KrpmSATA)RAID5(2TBoftotalspace)4x(2TB7.2KrpmSATA)RAID5(6TBoftotalspace)Network1GBPS1GBPSRAIDLevels

RedundantArrayofIndependentDisksRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A19Mirroringwithoutparityorstriping.Minimum#ofdrives:2SpaceEfficiency:1/nBlock-levelstripingwithdistributedparity.Minimum#ofdrives:3SpaceEfficiency:1-1/nSQLServer2008Specifics

FeatureInstallationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A20SQLServer2008Specifics

FeaturesselectionRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A21DonotselectReportingServices,thisservicesisusingtheport80whichwillconflictwiththeOpenLABDataStorewebserver.SQLServer2008Specifics

ServicesAccountconfigurationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A22Select“UsethesameaccountforallSQLserverservices”Selectinthedropdownbox“NTAuthority\NetworkService”SQLServer2008Specifics

AuthenticationModeRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A23Select“MixedMode”AddtheuserthatwillbeyourSQLServerAdministratorSQLServer2008Specifics

DataDirectoriesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A24Forbetterindexingperformances,thedatabasefilesshouldbelocatedonthefastestdisk.OpenLABDataStoreInstallationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A25OpenLABDataStoreInstallationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A26OpenLABDataStoreInstallation

InstallationfolderRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A27OpenLABDataStoreInstallation

InstallationtypeRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A28OpenLABDataStoreInstallation

NetworkedsystemselectionRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A29OpenLABDataStoreInstallation

DatabasetypeRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A30InstallationonaseparateserverisnotsupportedWithDataStoreA.01.01OpenLABDataStoreInstallation

DatabaseconnectionRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A31OpenLABDataStoreInstallation

SharedServicesDatabasenameRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A32OpenLABDataStoreInstallation

ContentFiledirectoryRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A33Selectthediskwiththelargestdisksize(2TB,6TBormore).OpenLABDataStoreInstallation

SummaryRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A34OpenLABDataStoreInstallation

RequiredMicrosoftHotfixesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A35Reboottheserveraftertheinstallation!PostInstallationstasksFirewall:Port80mustbeopenandnotused/sharedbyotherapplicationsTocheckyourinstallation,opentheInternetExplorerbrowserandtype:

http://<servername>/datastoreorusetheshortcutmenuontheserver.

TheOpenLABDataStorelogin

screenshouldappear.Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A36InstalledServicesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A37DataStore

Configuration38ConfiguringDataStoreasCentralStorage

Authenticationprovider

Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A39DataStoreisavailableasastoragetypeforthefollowingauthenticationproviders:InternalWindowsLocalWindowsDomainConfiguringDataStoreasCentralStorage

AddingtheOLSSSystemadministratorRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A40ConfiguringDataStoreasCentralStorage

DataStoreServerActivationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A41http://<servername>/adminadminToactivatetheDataStoreServer:url:http://<servernameUsername:adminPassword:adminPresstheactivatebuttonIftheactivationisfailingVerifytheurlandcredentialsRestarttheAlfrescoTomcatserviceCheckthefirewallCheckforPortconflictConfiguringDataStoreasCentralStorage

DefinetheProjectRootfolderRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A42Ifyouareplanningtouseprojects,youcandefinearootfolderthatwillholdyourdifferentprojectsfoldersandfiles.ConfiguringDataStoreasCentralStorage

ApplyingthenewconfigurationRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A43ChangingtheAdminpasswordRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A44ChangethepasswordoftheinternalAdminaccount.Thedefaultpasswordisadmin.UserandPermissionManagementDataStoreUsers,GroupsandPermissionsismanagedbySharedServicesdonefromOLCP.UsersarecreatedinOLCPandSpecificDataStoreprivilegesaremappedtoDataStore“permissions”.Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A45PermissionscanbeassignedforusersonprojectsinordertograntaccesswithintheDSfolders.TheusersandpermissionsettingsaresynchronizedbetweenOLSSandDataStoreManualsynchronizationtriggeredfromtheOLCPAutomaticsynchronization(every5mn)WhentheuserconnectstotheDataStoreWebinterfaceOpenLABDataStoreRolesApproverContributorReader5roles/groupsarepre-definedinDataStoreandautomaticallymappedwithSharedServicesrelatedPrivileges.NopossibilitytocreatecustomizedrolesfromtheDataStoreUserInterface.NopossibilitytocreateusersfromtheDataStoreUserInterface.RoleDefinitionCorrespondingOLSSPrivilegeReaderAllowsreadtoeverythingbydefaultProject|ProjectManagement|ViewprojectorprojectgroupContributorContributorisaReaderwhocanaddandmodifycontent.Project|ProjectManagement|EditContentofprojectApproverApproverisaContributorwhocansignfiles.Project|E-Signature|E-SignatureSignDataFilesArchivistArchivistcanarchivefiles.Administrative|DataStore|ArchiveContentFile&FolderAdministratorAdd,MoveorDeletefilesandfoldersAdministrative|SystemAdministration|ManageSecurityOpenLABDataStoreServerTrainingAN-CE-NDS-2-176-ARev1.0-June201246OpenLABDataStoreRoles

CDStoDataStorePermissionMappingAgilentRestrictedRev1.0-May201247CDSPrivilegeNameDataStorePermissionGivenDataStore:ArchiveContentDataStoreArchivistSystemAdministration:ManageSecurityDataStoreFileandFolderAdministratorProject:ViewProjectorProjectGroupDataStoreReaderESignatureSignFilesDataStoreApproverESignatureRevokeDataStoreContributorChemStation:SaveDataToStorageDataStoreContributorEZChrom:MethodSaveDataStoreContributorEZChrom:UpdateMasterMethodDataStoreContributorEZChrom:DataSaveDataStoreContributorEZChrom:SequenceSaveDataStoreContributorEZChrom:SequenceProcessDataStoreContributorEZChrom:PretreatmentSaveDataStoreContributorEZChrom:UpdateMasterPretreatmentDataStoreContributorEZChrom:SingleRunDataStoreContributorEZChrom:SequenceRunDataStoreContributorEZChrom:AddStandardReportTemplateDataStoreContributorEZChrom:AdvancedReportSaveDataStoreContributorTheCDSprivilegesthatresultinthegrantingofdatastorepermissionsonprojectfoldersbysynchronizationareasfollows:BothEditionsEZChromEditionChemStationEditionOpenLABDataStoreGroupsOpenLABDataStoreServerTrainingAN-CE-NDS-2-176-ARev1.0-June201248The“ManageUsers”and“ManageGroups”toolsarenotvisibletoDataStoreusers.

TheyhavebeenenabledhereinordertoshowthedifferentDataStorebuilt-ingroups.GenericProjectsGenericprojectsallowforthecreationofprojectfoldersthatcontainnosub-folders.(Results,templates,methods,etc…)Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A49Genericprojects,onceenabled,cannotbedisabled.EnablingthesewilladdaprojectssectiontoChemStationeditioncontrolpanel.Onlyavailabletobeenabledonasystemusingadatastorestoragetype.AllowsfolderaccessrightstobegrantedtodatastorelocationsbasedonprivilegesintheOpenLABControlPanel.Can’tbeusedtolaunchinstrumentsastheylackthenecessaryapplicationsettings.EZChrom:CreatingGenericProjectsTocreateagenericprojectuncheckallexistingitemsinthe“Applications”sectionduringprojectcreation.Rev1.0-April2012AgilentRestricted50GenericProjects

ManagingfolderpermissionsRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A51Afterbreakingtheparentprivilegesinheritance,youcanaddusersorgroupstoaprojectandchangethedefaultroleofauserforaspecificproject.LAB:InstallingandConfiguringtheDataStoreServer.Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A52DataStore

UserInterface53DataStoreLoginRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A54Startyourwebbrowserandtypehttp://<servername>/datastoreSupportedwebbrowser(s)InternetExplorer8.0or9.0Firefox8.xDataStoreUserInterfaceRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A55WorkingAreaActionBarNavigationSearchBarDataStoreUserInterfaceRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A56SearchBarTheEntersearchterms...boxenablesyoutosearchforcontent.Thenameofthecurrentlyloggedinuserappearsasamenunexttothesearchicon.

ClickLogouttologoutoftheprogram.ClickHelptoopentheonlinehelp.DataStoreUserInterfaceRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A57NavigationDocumentsenablesyoutoviewtheI'mEditing,andMyFavoritesfolders.

RepositorydisplaystheDataStorecontentsinadirectory.

UsetheRepositorytomanagefoldersandfiles.ToolsenablesyoutoViewAuditTrailDataStoreUserInterfaceRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A58ActionBarThetopoftheworkingareaalwaysdisplaysanavigationbreadcrumbthatallowsyoutojumptoanypartofthebreadcrumbpath.Thetoolbarcontainsnavigationbuttons,whichvarydependingontheuserprivilegesDataStoreUserInterfaceRev1.0-May2012AgilentRestricted59NavigationDocumentsenablesyoutoviewtheI'mEditing,andMyFavoritesfolders.

RepositorydisplaystheDataStorecontentsinadirectory.

UsetheRepositorytomanagefoldersandfiles.ToolsenablesyoutoViewAuditTrailDataStoreUserInterfaceRev1.0-May2012AgilentRestricted60ActionBarThetopoftheworkingareaalwaysdisplaysanavigationbreadcrumbthatallowsyoutojumptoanypartofthebreadcrumbpath.Thetoolbarcontainsnavigationbuttonswhichwillvarydependingonuserpermissionsonthecurrentfolder.DataStoreUserInterfaceRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A61WorkingAreaTheworkingareachangesdependingontheinformationyouarelookingatorthetaskyouareperforming.DataStoreRepositoryRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A62TheRepositorydisplaystheDataStorecontentsinadirectory.

UsetheRepositorytostoreandmanagefoldersandfiles.Toworkwithfilesandfoldersintherepositoryyoumusthavethecorrectrole/permissionsAfoldermaycontainamaximumof5000subfoldersandatthemostmaycontain10000files.DataStoreRepositoryRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A63

TodesignatethefolderorfileasafavoriteThisiconwillchangedependingonthekindoffile(.docx,pdf,png,etc.).

ClicktoopentheFileDownloaddialogboxwhereyoucanopenorsavethefile.ThisiconappearsonfilesBeingeditedbyyou.Marktoselectthefolderorfile.OpenthefilepropertiesClickingtodownloadthefileUploadingFilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A64YoucanuploadmultiplefilestoDataStoreifyouhaveadobeflashplayerinstalled.Uploadeddocumentswillhavetheversion1.0ManagingFilePropertiesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A65ManagingFileProperties

FilteringfilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A66Youcanusethefiltertodisplayaspecificnameorfileextension.ManagingFileProperties

UpdatingafileRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A67Whenupdatingafile,theusercanselecttheversionbasedonthetypeofchanges.TheCDS(ChemStationorEZChrom)alwayscreatesmajorrevisions.MinorversionscanonlybecreatedfromtheDataStoreUserInterface.ManagingFileProperties

Checkoutfiles1/2Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A68Checkoutafiletodownloadaworkingcopyofthefiletoyourcomputer.Thefileislockedtopreventothersfromeditingtheitemsimultaneously.Doesnotpreventotheruserstodownloadit.ManagingFileProperties

Checkoutfiles2/2Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A69Theuserchecking-outafilewillseeapeniconI’mEditingprovidesaquickaccesstotheallchecked-outfileofauser.OtheruserswillseealockiconManagingFileProperties

Checking-inafileRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A70Aftermodifyingafile,ausercancheckitinasanewminorormajorversionorundothecheckout.SearchingforfilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A71Theprogramprovidesbothbasicandadvancedsearchesforfiles.Searchingforfiles

BasicSearchRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A72Thebasicsearchwillsearchthedocumentcontentandtext-valuedmetadata.

Tosearchfordatesornumbersinthemetadata,useAdvancedsearch.Thesearchisnotcasesensitive.Torefineyoursearch,useAdvancedsearch.Searchingforfiles

AdvancedSearchRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A73ThesearchUIconsistsofthreecomponentsAselectorbuttonorcomboboxforselectingametadatafieldAtextboxinwhichaqueryiscreated.Abuttontoinvokeasearch.SearchSyntaxStringNumericDatetime===!=!=!=

>

>

>=>=

<

<

<=<=Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A74Conditions/OperatorsThequery,enteredinthetextbox,consistsof1ormoreterms,separatedbywhitespace.Query:=SearchTerm[SearchTerm[SearchTerm…]]]SearchTerm:=<MetadataFieldName>:([operator]expression)ExamplesSearchallentriescontaining“isocratic”inthesamplename

samplename:(isocratic)

samplename:(*isocratic*)Searchallentrieswithsamplenameexactlymatching“biphenyl”andacquiredbyJohn

samplename:(=biphenyl)acqoperator:(John)SearchallfilesarchivedlastweekandsignedbyPaul

archivedOn:(lastweek)signer:(=Paul)

archivedOn:(>2012-04-17)archivedOn:(<=2012-04-24)signer:(Admin)Theformatoftimesisclientlocale-specific.Theformatyyyy-mm-ddshouldworkinanylocale.

Datepredefinedvariablescanalsobeused:today|yesterday|lastweek|lastmonth|lastyear“OR”Statementsarenotsupported.Queriesusingwildcards(*,?)arecasesensitiveLAB:DiscoveringtheDataStoreUserInterfaceandManagingFilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A75ElectronicSignaturesOpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A76OpenLABDataStorecontainsacompleterevisionhistoryofallfilesitmaintains.Allfileversionsareavailableforinspectionand/oruse,ifrequired.UserscanelectronicallysignfilesinOpenLABDataStoreDataStoreandCDSelectronicsignaturesaremutuallyexclusiveSigningadatafileinEZChrominstrumentinterfacesdoesnotreflectadatastoresignatureinthedatastoreinterfaceandviceversaRev1.0-June2012DataStoreAuditTrailRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A77Changesarerecordedinasecure,computer-generated,time-stampedaudittrail.Providesthefacilitytosearch,export,andprint.

ArchivingFilesRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A78ArchivingFoldersRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A79LAB:Rev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A80DataStore

BackupandRestore81BackupandRestore

OverviewRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A82OpenLABDataStorestoresfiles,indexesandsomeotherrelatedinformationdirectlyonthefilesystem.Metadata,suchasfileandfolderinformation,audittrails,signaturesarestoredinarelationaldatabase.Thefiles,IndexesandtheDatabasemustbebackedupinordertoensurethatthesystemcanbelaterrestoredtothesamestate.BackupandRestore

SetupThefirststepinthebackup/restoreprocessistodetermine:DatabasenamethatstorestheOpenLABDataStoreinformationLocation(Windowsfolder)wherethecontentisstoredLocation(Windowsfolder)wheretheindexesarestoredRev1.0-June2012OpenLABDataStoreServerTrainingAN-CE-NDS-2-176-A83BackupandRestore