Optimizing database queries

A computerized method with a database that optimizes query requests for ranges, the method comprising:

• generating a first table comprising a list of non-overlapping and continuous ranges and an identifier for each of the ranges, wherein the ranges are not overlapping and continuous by including zero values for any empty ranges;
• generating a second table comprising the identifiers from the first table along with data to be stored for each of the identifiers;
• and
• accessing, in response to one of the query requests, the stored data for a requested range by locating the requested range in the first table and using the requested range's identifier to access the stored data corresponding to that identifier.

A computer system comprising:

• a database storing data that is associated with one or more ranges, the database comprising:
• a first table comprising the ranges and an identifier corresponding with each of the ranges, wherein the ranges are continuous and not overlapping;
• and
• a second table comprising the identifiers and the stored data, wherein the stored data is associated with the identifier that corresponds with the range;
• a processor coupled with the database for handling query requests relating to stored data and modifying the tables.