# newbie questions about kdb **URL:** \ **Category:** Community Support\ **Tags:** kdb-and-q\ **Created:** [October 21, 2010, 9:21pm UTC](https://forum.kx.com/t/newbie-questions-about-kdb/6758 "2010-10-21T21:21:00Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![kjackson](https://avatars.discourse-cdn.com/v4/letter/k/b9e5f3/32.png) [@kjackson](https://forum.kx.com/u/kjackson)\ **Post date:** [October 21, 2010, 9:21pm UTC](https://forum.kx.com/t/newbie-questions-about-kdb/6758/1 "2010-10-21T21:21:00Z")
I’m a complete newbie to kdb. As a hobby, I am currently developingmy own analysis software using a SQL server backend. I have roughly120 GB worth of tick data.I’ve been reading good things about kdb, so I decided to check it out,and if it works better I was thinking of migrating to it.. Idownloaded the trial software, but the website is rather sparse…also, it seems to be tiny, less than 1 MB and only a form of CLI.Did I download the right software?If so, will the trial software allow me to import 120 GB of data?Thanks in advance,Ken ---
**Author:** ![Aaron\_Davies](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@Aaron\_Davies](https://forum.kx.com/u/Aaron_Davies)\ **Post date:** [October 22, 2010, 1:11am UTC](https://forum.kx.com/t/newbie-questions-about-kdb/6758/2 "2010-10-22T01:11:00Z")
That’s the right software, it’s runnable as a REPL or an interpreter for script files. The trial version has some limitations, which I don’t remember off the top of my head; I’m not sure whether they’ll affect you. 100GB will almost certainly need to be stored as a partitioned database (details in the wiki at [code.kx.com](http://code.kx.com)), and you’ll probably need to write some sort of ETL program to get your data into the right format. (It should be about 10 lines.) ---
**Author:** ![f11](https://avatars.discourse-cdn.com/v4/letter/f/2bfe46/32.png) [@f11](https://forum.kx.com/u/f11)\ **Post date:** [October 22, 2010, 1:28am UTC](https://forum.kx.com/t/newbie-questions-about-kdb/6758/3 "2010-10-22T01:28:00Z")
Hello Ken, Further to Aaron’s advice, the trial software is only available in 32-bit, so you’ll have the RAM restriction imposed by 32-bit addressability, which could inhibit your data import. If you search through this group you’ll find the other trial software restrictions. The following link may be of use to you when importing the data: [https://code.kx.com/trac/wiki/KdbplusForMortals/dotQ\_utilities#a1.5.5.Q.fs](https://code.kx.com/trac/wiki/KdbplusForMortals/dotQ%5C_utilities#a1.5.5.Q.fs) user/pass:anonymous/anonymous Regards, Fintan. ---
**Author:** ![kjackson](https://avatars.discourse-cdn.com/v4/letter/k/b9e5f3/32.png) [@kjackson](https://forum.kx.com/u/kjackson)\ **Post date:** [October 22, 2010, 9:47pm UTC](https://forum.kx.com/t/newbie-questions-about-kdb/6758/4 "2010-10-22T21:47:00Z")
Great, thanks to both of you for the info! I will look this upfurther and try to get it up and running.On Oct 21, 5:28?pm, Fintan Quill \ wrote:\> Hello Ken,\>\> Further to Aaron’s advice, the trial software is only available in\> 32-bit, so you’ll have the RAM restriction imposed by 32-bit\> addressability, which could inhibit your data import. If you search\> through this group you’ll find the other trial software restrictions.\>\> The following link may be of use to you when importing the data:\>\> [https://code.kx.com/trac/wiki/KdbplusForMortals/dotQ\_utilities#a1.5.5...>>](https://code.kx.com/trac/wiki/KdbplusForMortals/dotQ_utilities#a1.5.5...>>); user/pass:anonymous/anonymous\>\> Regards,\>\> Fintan.\>\>\>\> On Thu, Oct 21, 2010 at 8:11 PM, Aaron Davies \ wrote:\> \> That’s the right software, it’s runnable as a REPL or an interpreter\> \> for script files. The trial version has some limitations, which I\> \> don’t remember off the top of my head; I’m not sure whether they’ll\> \> affect you.\>\> \> 100GB will almost certainly need to be stored as a partitioned\> \> database (details in the wiki at [code.kx.com](http://code.kx.com)), and you’ll probably\> \> need to write some sort of ETL program to get your data into the right\> \> format. (It should be about 10 lines.)\>\> \> On Thursday, October 21, 2010, kjackson \ wrote:\> \>\> I’m a complete newbie to kdb. ?As a hobby, I am currently developing\> \>\> my own analysis software using a SQL server backend. ?I have roughly\> \>\> 120 GB worth of tick data.\>\> \>\> I’ve been reading good things about kdb, so I decided to check it out,\> \>\> and if it works better I was thinking of migrating to it.. ?I\> \>\> downloaded the trial software, but the website is rather sparse…\> \>\> also, it seems to be tiny, less than 1 MB and only a form of CLI.\> \>\> Did ?I download the right software?\>\> \>\> If so, will the trial software allow me to import 120 GB of data?\>\> \>\> Thanks in advance,\>\> \>\> Ken\>\> \>\> –\> \>\> Submitted via Google Groups\\\