关于数据库...... [英] About Databases...

问题描述

你好NG，


我仍​​然是Python的新手（无论如何我强烈使用wxPython）。

我想知道什么是，在你的意见中，我可以在Python中使用的最佳/更快的数据库

（当然，我应该能够链接所有内容

with a wxPython GUI）？具体来说，我从事油藏模拟工作，而且通常我需要存储离散/大量的数据（这取决于

油田）。你可能已经理解了，我几乎不知道数据库

;-)

一般来说，我的数据将是数字（浮点数，整数）。请问二进制存储器是否可以减少数据库的大小？b $ b（如果可能的话）？那么存储/检索的速度怎么样？
数据？


非常感谢您的每一个建议。


Andrea。

Hello NG,

I am still quite a newbie with Python (I intensely use wxPython, anyway).
I would like to know what are, in your opinions, the best/faster databases
that I could use in Python (and, of course, I should be able to "link" everything
with a wxPython GUI)? Specifically, I work on Reservoir Simulation, and
usually I have to store a discrete/huge amount of data (it depends on the
oil field). As you may have understood, I know almost NOTHING about databases
;-)
In general, my data will be numeric (floats, integers). Will a binary storage
(if it is possible) reduce the size of the DB? And what about speed in storing/retrieving
data?

Thank you a lot for every suggestion.

Andrea.

推荐答案

2005年3月11日星期五23:32:48 +0100，一个*********** @ tin.it 在comp.lang.python中声明了

：

On Fri, 11 Mar 2005 23:32:48 +0100, an***********@tin.it declaimed the
following in comp.lang.python:

油田）。正如你可能已经理解的那样，我对数据库几乎一无所知


然后你的第一个方法应该是一本关于关系数据库的书

设计，规范化（以及何时到违反规范化）和SQL。

最好是一本并非特定于任何关系型DBMS的书。虽然

我可能会避免任何有关分层DBMS章节的书，

CODASYL / DBTG网络DBMS，或关系代数和/或关系

微积分 - 除非你在20世纪70年代运行大铁，但在这种情况下，

你可能没有Python甚至试图访问它们......< ; G>


在你将泛型化了之后，你可以考虑任何可用的RDBMS的

细节......


Python模块可能存在于：M

oil field). As you may have understood, I know almost NOTHING about databases
Then your first approach should be a book on relational database
design, normalization (and when to violate normalization), and SQL.
Preferably a book that is NOT specific to ANY Relational DBMS. Though
I''d probably avoid any book that has chapters on Hierarchical DBMS,
CODASYL/DBTG Network DBMS, or Relational Algebra and/or Relational
Calculus -- Unless you''re running on 1970s "big iron", but in that case,
you may not have Python by which to even attempt to access them... <G>

After you''ve gotten the generics down, then you can consider the
specifics of any available RDBMS...

Python modules likely exist for: M

JET（我假设你在

a Windows框中，包括服务器），M

JET (I''m presuming you''re on
a Windows box, including the server), M

SQL Server / MSDE，MySQL，MaxDB

由MySQL（他们的名称为重新包装的SAP DB），PostgreSQL，Firebird
（Interbase的后代）。我很确定上面的所有内容都运行在
WinNT上，大多数甚至可用于W9x。

一般来说，我的数据将是数字（浮点数，整数） ）。二进制存储器（如果可能的话）会减小数据库的大小吗？那么存储/检索数据的速度怎么样？

我不知道任何RDBMS /不支持二进制数据

数字，虽然他们可能只使用32位整数和仅64位

浮点数（许多虽然有短期和长期的整数，而且单个或双重

浮点数） 。许多还有十进制或货币数据类型。但是，在SQL查询中，您的数据将在

插入期间格式化为文本，并由RDBMS服务器转换回二进制文件。


如果你需要存储什么是基本上大的数组，那么

永远不会通过RDBMS零碎访问（IOW：你将检索

或商店整个阵列一次）你会想要检查每个

候选RDBMS中BLOB（二进制大对象，我记得）的

功能。 />

- ====================================== ============ ============<
wl ***** @ ix.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG<
wu******@dm.net | Bestiaria支持人员<
========================================= ========= ============<
主页：< http://www.dm.net/~wulfraed/> <
溢出页面：< http://wlfraed.home.netcom.com/> <

SQL Server/MSDE, MySQL, MaxDB
by MySQL (their name for the repackaged SAP DB), PostgreSQL, Firebird
(the descendent of Interbase). I''m pretty sure all of the above run on
WinNT, and most are even available for W9x.
In general, my data will be numeric (floats, integers). Will a binary storage
(if it is possible) reduce the size of the DB? And what about speed in storing/retrieving
data?
I don''t know of any RDBMS that /doesn''t/ support binary
numerics, though they may do so with 32-bit-only integer and 64-bit-only
floats (many though have short and long ints, and single or double
floats). Many also have either a decimal or currency data type. However,
IN the SQL query, your data will be formatted as text during the
insertion, and converted back to binary by the RDBMS server.

If you need to store what are essentially large arrays, which
will never by accessed via the RDBMS piecemeal (IOW: you will retrieve
or store the entire array at once) you''ll want to check on the
capabilities of BLOBs (Binary Large OBjects, as I recall) in each
candidate RDBMS.

-- ================================================== ============ <
wl*****@ix.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
================================================== ============ <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.netcom.com/> <

这篇关于关于数据库......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！