IIS在控制面板->添加或删除程序 ->添加/删除Windows组件 ->Internet信息服务(IIS)添加;
2、cache(Ensemble)安装步骤总共十二步
3.安装完成后 shutdown数据库。
4.拷贝原库Cache.cpf到EnsembleSys根目录下,cpf中主要配置数据库存放路径,根据事情情况可以自己修改cpf文件,或者在
System management Portal->Local Databases->Home->Configuration->Local Databases->Edit
5.拷贝Cache.key到EnsembleSys\Mgr根目录下;
CSP的配置
按照原库路径配置以下内容
1、设置路径: [Home] >[Security Management] >[CSP Applications] >[Create NEW CSP Application]>[Save];
2、Csp Application路径为IE访问路径
3、Resource required to run the application: %Service CSP
4 、Namespace: ————————
5、CachePhysicalPath:“数据库存放路径”
6、Default Superclass:locale.Chinese
CSP Gateway Management的设置
设置路径[Home] >[Configuration] >[CSP Gateway Management]
Server Access(一般安装数据库后自动生成)
Application Access(需要添加一个)
IIS中虚拟目录设置 // 只使用数据库 不考虑
*** 作路径:控制面板->管理工具->Internet 信息服务->(本地计算机->网站->默认网站) 。如果以前添加了站点,那么在完成上一步CSP设置之后,需要删除原来的IIS站点,重新添加。
此处注意权限。
对上面 *** 作步骤说明
1、虚拟目录别名为
2、第四步目录名称必须指向数据存放路径下,
3、第四步执行权限全选; //写CLS CSP 需要配置
补丁 *** 作
注意:在做补丁之前需要把CACHELIB的ReadOnly更改为No,做完补丁后再更改回Yes。
将以下内容拷贝到C:\EnsembleSys\Mgr\FDBMS
Patch\FDBMS_F173_Cache_52_WNT下CACHE.DAT文件
Patch\ qaqcasl523.mro文件
将以下内容拷贝到C:\EnsembleSys\CSP\sys\mgr
Patch\adhoc5412plus\adhoc5412\UtilConfigSQL.csp
%SYS>zn "fdbms"
FDBMS>d ^mdbmsins("","FDBMS")
Converting User Security Definitions.....DONE
CONVERTING USER PASSWORDS...
ALL DONE
FDBMS>d integ^mdbmsins()
FDBMS>d ^%RIMF
Load routines from a %ROMF file.
WARNING: This routine will delete the source code (if any)
for existing object routines that are being replaced.
Device: C:\patch\FDBMS_F173_Cache_52_WNT\qarmacF173.mro
file format: ("UR") =>
M/WNT wrote this file on Nov 03 2006 3:03 PM.
File Comment: patch for compiling routines in FDBMS
( All Select Enter List Quit )
Routine Input Option: all
If a selected routine has the same name as one already on file,
shall it replace the one on file? No =>yes
Building existing routine list ... done.
@ indicates routines which have been saved to disk.
. indicates routines which already exist in this directory.
Loading Routines ...
%qarmac@.
1 routine in 0 minutes, 0 seconds
none of them skipped.
FDBMS>
FDBMS>d ^%RIMF
Load routines from a %ROMF file.
WARNING: This routine will delete the source code (if any)
for existing object routines that are being replaced.
Device: C:\patch\FDBMS_F173_Cache_52_WNT\SYS.SQLSRV.mro
file format: ("UR") =>
M/WNT wrote this file on Nov 03 2006 3:03 PM.
File Comment: patch for compiling routines in FDBMS
( All Select Enter List Quit )
Routine Input Option: all
If a selected routine has the same name as one already on file,
shall it replace the one on file? No =>yes
Building existing routine list ... done.
@ indicates routines which have been saved to disk.
. indicates routines which already exist in this directory.
Loading Routines ...
FDBMS>
再做adhoc5412plus.zip(如文档readme_5412.txt,需要拷贝UtilConfigSQL.csp到C:\EnsembleSys\CSP\sys\mgr下);
FDBMS>zn "%sys"
%SYS>d ^%RI
Input routines from Sequential
Device: C:\patch\adhoc5412plus\adhoc5412\adhoc5412.rsa
Parameters? "RS" =>
File written by Cache for Windows using %RO on 17 May 2007 9:32 PM
with extensions INC,INT and with description:
( All Select Enter List Quit )
Routine Input Option: all
If a selected routine has the same name as one already on file,
shall it replace the one on file? No =>yes
Generate backups? No =>No
Recompile? Yes =>yes
Display Syntax Errors? Yes =>yes
^ indicates routines which will replace those now on file.
@ indicates routines which have been [re]compiled.
- indicates routines which have not been filed.
%msql.INC^ syConfig.INC^ STUCNFG1.INT@
3 routines processed.
%SYS>s path="C:\patch\adhoc5412plus\adhoc5412\SQL.xml"
%SYS>do $SYSTEM.OBJ.Load(path,"cbrps")
Load started on 04/12/2008 10:56:40
Loading file C:\patch\adhoc5412plus\adhoc5412\SQL.xml as xml
Imported class: %SYSTEM.SQL
Compiling class %SYSTEM.SQL
Compiling routine %SYSTEM.SQL.1
ERROR: Compiling class includes
Processing %systemInclude.INC into a precompiled header
Load finished successfully.
%SYS>s path="C:\patch\adhoc5412plus\adhoc5412\adhoc5412.xml"
%SYS>do $SYSTEM.OBJ.Load(path,"brpsu")
Load started on 04/12/2008 10:57:57
Loading file C:\patch\adhoc5412plus\adhoc5412\adhoc5412.xml as xml
Imported object code: %SYS.PATCH
Imported global: ^CacheTempPatch
Load finished successfully.
%SYS>do ^%MGDIR
You're in namespace %SYS
Default directory is c:\ensemblesys\mgr\
%SYS>do ^%SYS.PATCH
Apply Patch Utility
Adhoc: 5412
Description: PVA089,DPV2673
Created at: 2007-05-18 00:51:28
Created on $zv: Cache for Windows (Intel) 5.2.3 (Build 710)
Apply (Y/N) y
Applying Patch...
.......
Successfully Applied!
Please test the patch. If it fails, you can remove the
patch by executing the following command:
Do Restore^%SYS.PATCH()
%SYS>d $System.CSP.LoadPage("/csp/sys/mgr/UtilConfigSQL.csp","fc")
Compiling file /csp/sys/mgr/UtilConfigSQL.csp
Compiling class %cspapp.mgr.utilconfigsql
Compiling routine %cspapp.mgr.utilconfigsql.1
%SYS>d $System.OBJ.Load("C:\patch\Collection.ListOfDT.xml","fc")
Load started on 04/12/2008 12:17:50
Loading file C:\patch\Collection.ListOfDT.xml as xml
Imported class: %Collection.ListOfDT
Compiling class %Collection.ListOfDT
Compiling routine %Collection.ListOfDT.1
Load finished successfully.
%SYS>d ^%RIMF
Load routines from a %ROMF file.
WARNING: This routine will delete the source code (if any)
for existing object routines that are being replaced.
Device: C:\EnsembleSys\Mgr\FDBMS\qaqcasl523.mro
file format: ("UR") =>
M/WNT wrote this file on May 18 2007 3:48 PM.
File Comment: backport of AK626, fix INTO :Array() problem
( All Select Enter List Quit )
Routine Input Option: all
If a selected routine has the same name as one already on file,
shall it replace the one on file? No =>yes
Building existing routine list ... done.
@ indicates routines which have been saved to disk.
. indicates routines which already exist in this directory.
Loading Routines ...
%qaqcasl@.
1 routine in 0 minutes, 0 seconds
none of them skipped.
%SYS>
%SYS>zn "DHC-APP"
DHC-APP>d $system.SQL.Purge(0)
更改SQL Setting
[Home] > [Configuration] >[SQL Settings]
将DISTINCT optimization turned on 的值置为 Yes ,保存,然后再置成No保存.
全部做完后把CACHELIB的ReadOnly更改为Yes
核酸序列数据库(genbank)和基因组数据库(ensemble)的区别:1、GenBank 是一个有来自于70,000多种生物的核苷酸序列的数据库。每条纪录都有编码区(CDS)特征的注释,还包括氨基酸的翻译。GenBank属于一个序列数据库的国际合作组织,包括EMBL和DDBJ。
2、Ensemble数据库可为药物研发提供超过167,000种生物活性化合物包括化学结构在内的必要信息。本数据库利用用户容易掌握的界面将数据、文本和图象资料有机地结合起来,便于查询。Ensemble可从药品专利开始,再通过其临床前和临床研究资料,直至注册信息、市场概况及其他方面的相关资料来跟踪药物。数据库每月更新一次,每年增加约10,000 种新化合物。
Ensembl
http://www.ensembl.org/index.html
1.选择物种,搜索基因。
2.点击进入基因的summary页面。
3.点击左侧sequence,得到序列信息。
4.橘色背景红色字体序列为exon区域,第一个外显子前边的序列即为promoter序列,默认设置为600bp。
5.若想获取更长的promoter序列,点击左侧“Configure this page”重新配置。
6.修改5' Flanking sequence (upstream),例如修改为1000,保存并关闭,即可得到更新后1000bp的promoter序列。
7.在UCSC中核实(Ensembl和UCSC注释之间就TSS的识别可能存在差异)。复制启动子序列,在UCSC进行blat,点击第一条的browser进入基因组浏览界面,zoom out 3X,查看页面确保启动子序列符合UCSC注释(输入的序列在目标基因的第一个exon之前,序列区域内有CpG岛)。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)