Need cheap/free start to large datawarehouse

DBMasterNot · #1 (**permalink**) 01-20-10, 17:43

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.

Fakin · #2 (**permalink**) 04-17-10, 16:39

for this you can use: mysql or postgresql if you want free.

MySQL :: MySQL in Data Warehousing & Business Intelligence
MySQL :: Data Warehousing with MySQL and Infobright
PostgreSQL 8.1 targets data warehousing | Desktop Apps | ZDNet UK

loquin · #3 (**permalink**) 04-21-10, 15:39

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/

coderserdar · #4 (**permalink**) 04-22-11, 05:25

i suggest you firebird
it is open source
and you can find db tools open sources too
like
flame robin
ibexpert personel edition

Internet Services

Web Development

Digital Marketing

Consumer Tech