-1

How to create a huge database in Informix (IDS) version 11.50?

Jonathan Leffler
  • 666,971
  • 126
  • 813
  • 1,185
tabrez
  • 7
  • 2
  • please define 'huge' .. e.g. 1-5TB? – lexu Apr 12 '10 at 06:38
  • 1
    Have you tried anything? Do you have idea what you want to test? What tools or programming languages do you know: Java, C, Python, Perl...? Do you have schema for "huge" database? I think you should give us more details, not only Infromix engine version. – Michał Niklas Apr 14 '10 at 06:45
  • 1
    Can you show us what you have: database schema, sample data to fill database, tools you can use? – Michał Niklas Apr 14 '10 at 06:52
  • See also [How to create a huge Informix database](http://stackoverflow.com/questions/2602255/how-to-create-a-huge-informix-database). – Jonathan Leffler Oct 06 '12 at 17:00

2 Answers2

1

Is 2+ Terabytes big enough for you?.. Best way is to create a table, then load an ascii file into it. I have a 2TB+ (nrows=10M, rowsize=2048) ascii test file (with pipe delimiters) which has unique: fullnames, adresses, phone numbers and a variety of other datatypes, like DATE, SMALLINT, DECIMAL (9,2), etc. for testing/benchmarking purposes.

Problem is. how can i get it to you?

You could also create an SPL to insert random data, but for a huge test table, its not going to produce realistic or meaninful data for test purposes.

Frank R.
  • 2,206
  • 4
  • 29
  • 69
1

It is not very different from creating normal database. You can create tables as normal, but then you fill tables with huge amount of data. I think the best you can do is to create application that will fill database with random data. Of course you can use some real data like dates, city names, first names etc, or create "looking normal" names using Markov chain. Look at some examples in Python: Python Markov Chains and how to use them.

For massive inserts you should use PreparedStatement (this is quite easy with Java or Jython), or create huge text file and load them using dbimport.

Michał Niklas
  • 48,759
  • 16
  • 62
  • 100