I have two tables, ips and ranges, where ips contains a list of ips
(INET) and ranges contains a list of ip blocks (CIDR), ala:
CREATE TABLE ips (ip INET, info varchar);
CREATE TABLE ranges (range CIDR, info varchar);
I would like to update the info column in ips to be the info column of
the mos
I'm having a bit of a brain freeze and can't seem to come up with
decent SQL for the following problem:
I have a table "t" of the form "time_occurred TIMESTAMP, prog_data
VARCHAR" and would like to create a query that outputs something of
the form "first_seen, last_seen, count, prog_data".
I hav
I'm developing a schema for a large data warehouse (10 billion records) and had a couple of questions about how to optimize it. My biggest question is on the design of the fact table and how much normalization I should actually do of the data.
The data is going to be keyed by IP address, stored
