存储数据 [英] storing the data
问题描述
我有13.8 GB的数据。
数据如下： -
1：Proc Natl Acad Sci US A. 2003年8月19日; 100（17）：9768-73。 Epub 2003年7月30日。
表征myotubularin相关蛋白7及其结合配偶体，
myotubularin相关蛋白9.
Mochizuki Y，Majerus PW。
华盛顿大学医学院内科，660
S. Euclid Avenue，St。 Louis，MO 63110，USA。
Myotubularin-related protein 7（MTMR7）是myotubularin（MTM）
家族的成员。编码小鼠MTMR7的cDNA含有1,983bp，预测的
蛋白质的推断分子量为75.6kDa。 Northern和Western印迹
分析显示MTMR7主要在脑和小鼠神经母细胞瘤中表达
定位于高尔基体样颗粒和胞质溶胶中，亚细胞分级分析显示MTMR7在N1E-115细胞中的细胞质和膜定位。在来自N1E-115
光谱测定法。 MTMR9的卷曲螺旋结构域足以结合MTMR7的b
。 MTMR9的结合增加了MTMR7的Ins（1,3）P2磷酸酶活性。我们的研究结果表明，MTMR7与MTMR9形成复合物，并且b / b
磷酸化磷脂酰肌醇3-磷酸和Ins（1,3）P2神经元
细胞。
出版类型：
体外
研究支持，美国政府，小灵通
PMID ：12890864 [PubMed - 为MEDLINE索引]
我存储在文件中。
我想存储13.8 GB的mysql数据库中的数据。
将数据存储在数据库或文件中是否可靠？
这里的主要概念是用户将指定一些关键词说癌症它应该
检索包含癌症这个词的数据。（如上面提到的数据将被检索）。
将搜索更快，如果存储在文件或数据库中？
关于
Archana
Hi,
I have 13.8 GB of data.
The data is of the following:-
1: Proc Natl Acad Sci U S A. 2003 Aug 19;100(17):9768-73. Epub 2003 Jul 30.
Characterization of myotubularin-related protein 7 and its binding partner,
myotubularin-related protein 9.
Mochizuki Y, Majerus PW.
Washington University School of Medicine, Department of Internal Medicine, 660
S. Euclid Avenue, St. Louis, MO 63110, USA.
Myotubularin-related protein 7 (MTMR7) is a member of the myotubularin (MTM)
family. The cDNA encoding the mouse MTMR7 contains 1,983 bp, and the predicted
protein has a deduced molecular mass of 75.6 kDa. Northern and Western blot
analyses showed that MTMR7 is expressed mainly in brain and mouse neuroblastoma
N1E-115 cells. Recombinant MTMR7 dephosphorylated the D-3 position of
phosphatidylinositol 3-phosphate and inositol 1,3-bisphosphate [Ins(1,3)P2]. The
substrate specificity of MTMR7 is different than other MTM proteins in that this
enzyme prefers the water-soluble substrate. Immunofluorescence showed that MTMR7
is localized in Golgi-like granules and cytosol, and subcellular fractionation
showed both cytoplasmic and membrane localization of MTMR7 in N1E-115 cells. An
MTMR7-binding protein was found in an anti-MTMR7 immunoprecipitate from N1E-115
cells and identified as MTM-related protein 9 (MTMR9) by tandem mass
spectrometry. The coiled-coil domain of MTMR9 was sufficient for binding to
MTMR7. The binding of MTMR9 increased the Ins(1,3)P2 phosphatase activity of
MTMR7. Our results show that MTMR7 forms a complex with MTMR9 and
dephosphorylates phosphatidylinositol 3-phosphate and Ins(1,3)P2 in neuronal
cells.
Publication Types:
In Vitro
Research Support, U.S. Gov''t, P.H.S.
PMID: 12890864 [PubMed - indexed for MEDLINE]
I have stored in files.
I want to store 13.8 GB of data in mysql database.
Is it reliable to store the data in database or in files?
The main concept here is user will specify some keyword say "cancer" it should
retrieve the data which contains the word cancer.(like mentioned above data will be retrieved).
will searching be faster if store in files or in database?
with regards
Archana
推荐答案
有一个交易 。随机访问文件可能更快但也记得mySQL使用InnoDB和myISAM进行搜索，因此您也可以将数据存储在数据库中。这个想法是尽可能避免顺序访问
There is a trade off . Random access files may be faster but also remember that mySQL uses InnoDB and myISAM for search so you can also store the data in a database. The idea is avoiding sequential access as much as possible
Heya，Archana。
MySQL非常擅长这一点。
Heya, Archana.
MySQL is very good at this.
Heya，Archana。
MySQL非常擅长这个。
感谢您的链接。
我浏览了这些链接。
我在我的mysql数据库中查了但是它出错了。
错误是这样的： -
错误1064：你的SQL语法在第1行''BOOLEAN MODE''附近有错误
我检查了mysql版本，版本是3.23.58。
全文搜索无法在mysql 3.23.58中运行吗？
还有其他办法吗？可以吗？
因为我必须使用布尔表达式（例如：-cancer和tissue）它应该
检索有的文章这两个字我认为我必须使用boolean
mode.But这是一个错误。
什么是兼容mysql版本3.23 .58。
如何解决这个问题呢？
问候
Archana
Hi,
Thanks for the link.
I went through the links.
I checked in my mysql database but it is giving an error.
error is this:-
ERROR 1064: You have an error in your SQL syntax near ''BOOLEAN MODE)'' at line 1
I checked the mysql version and version is 3.23.58.
does full text searches will not work in mysql 3.23.58?
Is there any other way to be done?
since i have to use boolean expressions (for eg:-cancer and tissue) it should
retrieve the articles which has both these words i think i have to use boolean
mode.But that is giving an error.
what is compatible to mysql version 3.23.58.
How should i solve this problem?
with regards
Archana
这篇关于存储数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
