Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Thumbs up Need cheap/free start to large datawarehouse

    Do you have any suggestions about a cheap/free data
    warehouse system?
    My needs in a database, datawarehouse system:

    1. 1200 fields per record
    2. 100K records per file
    3. hundreds of files
    4. need batch only export or extraction of data
    for Access database, etc.
    5. raw data is now about 3 GB, which means about
    6GB of data now once it is in database/warehouse
    from Access experiments
    6. SQL etc. simple batch export ability.
    Many thanks in advance.

  2. #2
    Join Date
    Sep 2009
    Posts
    39

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Ref this Information Week report.

    Google IS your friend... 10 minutes on google search & I found a couple of candidates...

    Code:
    Name		 		Licensing			DW Back End DBs
    Link(s)
    **************		***********************************	************************
    InfoBright ICE		(Open Source, or Licensing)		MySQL
    http://www.infobright.com/
    
    Pentaho	BI		(Open Source, Trial, Licensing)		MySQL, PostgreSQL, Oracle
    http://www.pentaho.com/products/data_integration/
    http://www.prashantraju.com/projects/pentaho/
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Apr 2011
    Posts
    3
    i suggest you firebird
    it is open source
    and you can find db tools open sources too
    like
    flame robin
    ibexpert personel edition

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •