In which database type i should store large amount of data?

[Nishant]

Hiii, All

           I am using DAQ cards to fetch the data from 32-Analog channels and 16-digital channel and after that, i am storing those datas into .xls file(Tab delimited file), but i was creating new file, whenever it fills with the 60,000 rows, and i was creating a new file with the index name is next file number related to the previous file, but the problem is customer wants that, all the data should be stored in the single file and the possibilities that rows can be increased more than 65,535 and file can be overlapped and customer cannot see the dat, so can anybody tell me that which database instead of excel i can use so that, it can be stored in the singole file, instead of creating more files for more datas, actually it is a trigger, whenever trigger comes, data writing in the file started and when trigger ends, file writing ends and the main thing is for one trigger there must be a single file, please suggest me something.

Thanks in Advance,

Nishant

[Ryan.S]

Using LabVIEW together with database toolkit, you can connect to many kinds of database, such as Access. But not sure the limit for Access.

Anyway, I guess you are not using Lookout. You'd better post it in some other forum.

[Mike@DTSI]

SQL Server (full or express)
mySQL
Oracle

Depending on the exact size reqs. Access may work as well, and its "easier"

[Nishant]

Hiii, Ryan and Mike,

                     Thanks for the reply, and yes you both are right i should have to go to one of those databases and Ryan yes you are right, i am not using Lookout, but by mistake i have post vi in this forum, anyways thanks to both of you, but one thing i would like to ask can anyome of you give me some information about Lookout, what is that? and for which purpose you are using it? i am not aware of anything about Lookout, its good for me if you can provide me with some information about Lookout.

Thanks,

Nishant

[Mike@DTSI]

Lookout is SCADA software.  We use it for Water and Waste Water systems.

[Nishant]

Hiii Mike

                     Thanks, now i came to know something about Lookout, actually, where i am workig we are using Citect as a scada software, citect is an australian based company, can you please give me a links where i can read about this, because as you are using continuousy, i think you know something about that, anyways thanks for the information.

Thanks,

Nishant

[Mike@DTSI]

have played with Citect myself, Lookout is "simpler" to setup and use.  Though Citect offers some more powerful options.  Pros and Cons 🙂

http://sine.ni.com/nips/cds/view/p/lang/en/nid/12511
http://www.scadaequipment.com/static/R_Solutions_and_Product_Information.asp