English 中文(简体)
具有数百万行的日志表。现在,什么?
原标题:Log table with millions of rows. Now, what?

我有一个对数表,里面有数百万行。我正在考虑将数据分为多个表(即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





相关问题
what is wrong with this mysql code

$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 ...

Users asking for denormalized database

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 ...

Easiest way to deal with sample data in Java web apps?

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 ...

join across databases with nhibernate

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 ...

How can I know if such value exists in database? (ADO.NET)

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 ...

Convert date to string upon saving a doctrine record

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 ...

热门标签