SQL数据库中实验的矩阵存储
我需要将实验矩阵存储在数据库中。我首先编译ERD并遇到问题。必须需要表“矩阵”和“ matrix_element”（这是一个要求）。问题在于实验的矩阵具有字符串名称，因此我想通过名称访问，而不是ID访问。同时，用字符串类型替换“ matrix_id”似乎是不正确的，因为名称可以很长（例如“ tempnreg410”），而矩阵大小可以是5000x60000，并且有数百个这样的矩阵。事实证明，长期重复的重复很多次。请告知如何进行。以下是我到目前为止能够提出的两个图。
I need to store experimental matrices in a database. I started by compiling an ERD and ran into a problem. The tables "Matrix" and "Matrix_element" must be required (this is a requirement). The problem is that the matrices for experiments have string names, so I would like to have access by name, and not by id. At the same time, it seems not correct to replace "matrix_id" with a string type, because the names can be quite long (something like "TempNreg410"), while the matrix size can be 5000x60000, and there are hundreds of such matrices. It turns out the repetition of a long line a huge number of times. Please advise how to proceed. Below are 2 diagrams that I have been able to come up with so far.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论