我有一个对数表,里面有数百万行。我正在考虑将数据分为多个表(即LoginHistory、ExceptionHistroy、PaymentProcessingHistory等)。当使用具有多行(而非列)的大表并创建多个表时,使用的术语是什么?
我当前的日志表模式类似于:LogID、LogMessage、LogReason、LoggedBy、LoggedOn等。
问题是我把太多的东西放在一张桌子上了,我想?也许这张表太普通了?
谢谢
我有一个对数表,里面有数百万行。我正在考虑将数据分为多个表(即LoginHistory、ExceptionHistroy、PaymentProcessingHistory等)。当使用具有多行(而非列)的大表并创建多个表时,使用的术语是什么?
我当前的日志表模式类似于:LogID、LogMessage、LogReason、LoggedBy、LoggedOn等。
问题是我把太多的东西放在一张桌子上了,我想?也许这张表太普通了?
谢谢
它被称为数据分区。
碎片是当前的术语。来自链接:
水平分区是一种数据库设计原则,根据该原则,数据库表的行被单独保存,而不是按列划分(如规范化)。每个分区构成碎片的一部分,该碎片可能位于单独的数据库服务器或物理位置上。
我认为您应该关注水平分区。水平分区或多或少是分片的一个子集。
For more details on horizontal partitioning, here s the wikipedia link:
http://en.wikipedia.org/wiki/Partition_%28database%29
您没有提到您使用的是哪种DB技术,但以下是一些可以帮助您进行数据分区的技术链接:
IBM DB2 partitioning
MySQL partitioning
Oracle partitioning
SQL Server partitions
PostgreSQL partitioning
Sybase ASE 15.0 partitioning
$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...
I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...
I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...
Does anybody know if it is possible to move some (not all) users from one ASP.NET membership database to another? (for the purposes of migrating some users to another database on another machine, but ...
Is it because of size? By the way, what is the limit of the size?
I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...
For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...
I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...