Using IBM DB2 NoSQL Graph Store in Websphere Application Server Community Edition

This is the first of a series of blog posts about our experience with the IBM DB2 Express-C NoSQL Graph Store (hereafter DB2 RDF) in combination with IBM WebSphere Application Server Community Edition (hereafter WASCE).

The DB2 RDF product allows the storage and manipulation of RDF data. The data can be stored in graphs, all according to W3C Recommendations. The DB2 RDF product uses the Apache Jena programming model to interact with the underlying store. In the very detailed documentation there is an outline of products and tools needed to get the basic DB2 RDF programming environment going.

This series of articles is specifically about using the tools inside the WASCE environment. While developing our RESC.Info product we gathered a lot of experience which we like to share with the community using this article. We will also be presenting our experience during this years IBM Information On Demand 2013 in Las Vegas.

The series will cover the following topics:

  • Configuring WASCE data sources
  • Assembling the correct Jena distribution
  • Dealing with transactions

This first article is about configuring WASCE data sources for use with the DB2 RDF and Jena programming model. This is NOT meant to be an extensive installation guide for these products, you should refer to the respective product documentation for more information on installation.
It is very important to select the correct versions of the various products:

  • IBM DB2 Express-C 10.1.2
  • IBM WebSphere Application Server Community Edition 3.0.4

Creating a DB2 database and graph store

To  be able to use the DB2 RDF features we need to create a standard database with some specific parameters. The DB2 documentation contains extensive information for this task. To create a database ‘STORE’ that supports DB2 RDF we issue the following commands:

db2 CREATE DATABASE STORE PAGESIZE 32 K
db2 UPDATE DATABASE CONFIGURATION FOR STORE USING LOGFILSIZ 20000
db2 CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4

For the correct administration we also need to execute:

db2set DB2_ATS_ENABLE=YES
db2 UPDATE DB CONFIG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_RUNSTATS ON
db2 alter bufferpool IBMDEFAULTBP IMMEDIATE SIZE 15000 AUTOMATIC

Now that the database is created we still need to create a graph store inside the database. This is done with the following command:

createrdfstore rdfStore  -db STORE -user db2admin -password XXX -schema public 

This can take a while. After completion you will have a graph store ‘rdfStore’ inside your database ‘STORE’. To check the presence of this store issue the following command when connected to ‘STORE’:

db2 SELECT * FROM SYSTOOLS.RDFSTORES

The resulting table should contain reference to our store ‘rdfStore’ in schema ‘public’

WebSphere Application Server Community Edition installation

Install WASCE with the installer, but do not start it yet. WASCE is distributed with some older DB2 JDBC drivers which interfere with the DB2 JDBC4 drivers that are needed for the DB2 RDF interface. In the repository directory of WASCE look for the path

<wasce_install>/repository/com/ibm

and delete the db2 sub-directory. Run WASCE with the -clean parameter, which causes WASCE to cleanup all references to the included DB2 JDBC drivers.

geronimo.[sh/bat] run -clean

Installing db2jcc4.jar

Now it is time to install the JDBC4 driver into WASCE repository. In the advanced mode of the console you will find the Resources/Repository tab where you can add new jars to the repository. Select the db2jcc4.jar from your <DB2_INST>/java directory and fill out the fields as shown in the image and click ‘Install’.
wascerepos

Creating a Database Pool

Once the correct jar is installed the creation of the connection to the database is the same as any other regular database connection. Select DB2 XA as ‘Database type’ and fill out the connection information. You should only see one JDBC driver here, the one we just installed. Fill out the details of your regular DB2 database ‘STORE’ and click ‘Deploy’.

After a database source object is created we can use it in the simple SQL entry field, select the newly created data source and issue the following command:

SELECT * FROM SYSTOOLS.RDFSTORES

The result should be the same as the result we had after issuing this query from the command line.

Conclusion

Now we have setup a DB2 RDF connection inside WASCE with the correct version of both products and connecting drivers. The next step will be to create a simple Jena based application to interact with the store.

294 thoughts on “Using IBM DB2 NoSQL Graph Store in Websphere Application Server Community Edition

  1. Accelerate Your Growth – 30 Days at No Cost

    Hi,

    My name is Irma and I am the founder at BIGLEP. We work with organizations like Getresponse to accelerate small businesses growth through offering email marketing tools.

    Powerfully-simple features let you concentrate on your business — not marketing technology:
    drag and drop email creation, pre-built templates, automations, powerful analytics.

    Interested? Get 15mins on your calendar to explore: https://www.biglep.com/growth

    Cheers,
    Irma

    To unsubscribe: reply “no”

  2. Good post. I study something tougher on different blogs everyday. It’s going to at all times be stimulating to read content from other writers and follow a bit of something from their store. I抎 want to use some with the content on my weblog whether you don抰 mind. Natually I抣l offer you a link on your internet blog. Thanks for sharing.

  3. After research a few of the blog posts on your website now, and I actually like your way of blogging. I bookmarked it to my bookmark web site checklist and might be checking back soon. Pls try my web page as nicely and let me know what you think.

  4. I’m not sure why but this web site is loading incredibly slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later and see if the problem still exists.

  5. I was wondering if you ever thought of changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?

  6. Hey! I could have sworn I’ve been to this site before but after checking through some of the post I realized it’s new to me. Anyways, I’m definitely delighted I found it and I’ll be bookmarking and checking back often!

  7. I was curious if you ever thought of changing the page layout of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two pictures. Maybe you could space it out better?

  8. Thanks for sharing your ideas. I might also like to state that video games have been ever before evolving. Modern tools and innovative developments have aided create genuine and interactive games. These kind of entertainment video games were not as sensible when the real concept was first of all being tried out. Just like other styles of technological know-how, video games as well have had to grow by many years. This is testimony on the fast continuing development of video games.

  9. I was suggested this blog by my cousin. I’m not sure whether this post is written by him as no one else know such detailed about my trouble. You are wonderful! Thanks!

  10. Hmm is anyone else experiencing problems with the images on this blog loading? I’m trying to determine if its a problem on my end or if it’s the blog. Any feed-back would be greatly appreciated.

  11. Hiya, I am really glad I’ve found this info. Today bloggers publish only about gossips and net and this is actually frustrating. A good site with exciting content, that’s what I need. Thanks for keeping this site, I’ll be visiting it. Do you do newsletters? Can’t find it.

  12. There are some fascinating deadlines on this article but I don’t know if I see all of them center to heart. There may be some validity but I’ll take hold opinion until I look into it further. Good article , thanks and we want extra! Added to FeedBurner as properly

  13. I seriously love your website.. Pleasant colors & theme. Did you build this amazing site yourself?

    Please reply back as I’m planning to create my own blog and would like to find out where
    you got this from or just what the theme is called. Cheers!

  14. Thanx for the effort, keep up the good work Great work, I am going to start a small Blog Engine course work using your site I hope you enjoy blogging with the popular BlogEngine.net.Thethoughts you express are really awesome. Hope you will right some more posts.

  15. Aw, this was a really nice post. In idea I wish to put in writing like this additionally – taking time and actual effort to make a very good article… but what can I say… I procrastinate alot and under no circumstances appear to get one thing done.

  16. Thanks for ones marvelous posting! I genuinely enjoyed reading it, you are a great
    author. I will be sure to bookmark your blog and will often come back in the
    foreseeable future. I want to encourage you to definitely continue your great posts, have a nice morning!

  17. great submit, very informative. I ponder why the opposite experts of this sector don’t realize this. You must continue your writing. I am sure, you’ve a huge readers’ base already!

  18. Thanks a lot for sharing this with all of us you really know what you’re speaking approximately! Bookmarked. Please additionally talk over with my web site =). We could have a link trade agreement among us!

  19. I believe that is one of the such a lot vital info for me. And i’m happy reading your article. However want to commentary on some basic things, The site style is great, the articles is in reality great : D. Good process, cheers cialis generic.

  20. Its such as you learn my thoughts! You seem to know
    so much about this, such as you wrote the e-book in it or something.

    I feel that you just could do with a few p.c.
    to pressure the message house a bit, but instead of that,
    that is excellent blog. An excellent read. I’ll certainly
    be back.

  21. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your blog?
    My blog is in the exact same area of interest as yours and my visitors
    would certainly benefit from some of the information you present here.
    Please let me know if this okay with you. Appreciate it!

  22. Amazing blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. Many thanks

  23. At this time it appears like Expression Engine is the preferred blogging platform out
    there right now. (from what I’ve read) Is that what you’re using
    on your blog?

  24. Most of what you state happens to be astonishingly precise and it makes me wonder why I had not looked at this with this light before. Your article really did switch the light on for me as far as this particular subject goes. Nonetheless there is actually one issue I am not necessarily too cozy with and whilst I make an effort to reconcile that with the main theme of the position, permit me see just what the rest of your subscribers have to say.Well done. canadian pharmacy online

  25. President Kennedy once made exercise in school a major component of U.S. youth education, orientation, and lifestyle. With childhood obesity and diabetes on a meteoric rise in this country, we need to get back to teaching the importance of being active to get and stay healthy. viagra prices

  26. Howdy just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Safari. I’m not sure if this is a formatting issue or something to do with web browser compatibility but I thought I’d post to let you know. The design look great though! Hope you get the issue solved soon. Kudos cialis online.

  27. you are actually a excellent webmaster. The web site loading velocity is amazing.

    It sort of feels that you are doing any unique trick.
    Also, The contents are masterpiece. you have done a magnificent
    job in this topic!

  28. May I just say what a relief to find somebody who actually understands what they’re talking about on the net. You definitely understand how to bring a problem to light and make it important. More and more people need to look at this and understand this side of the story. I was surprised you are not more popular since you most certainly possess the gift.

    https://www.manumanu.com – manumanu

  29. Oh my goodness! Amazing article dude! Many thanks, However I am having problems with your RSS.
    I don’t understand the reason why I am unable to join it.
    Is there anybody else getting identical RSS issues?
    Anyone who knows the solution can you kindly respond?
    Thanks!!

  30. I have been surfing online more than 3 hours today, yet I never found any
    interesting article like yours. It’s pretty worth enough for me.

    In my opinion, if all webmasters and bloggers made good content as
    you did, the net will be much more useful than ever before.

  31. It’s appropriate time to make some plans for the long run and it’s time to be happy.
    I’ve learn this submit and if I may just I wish to suggest you few interesting issues or suggestions.
    Maybe you can write next articles relating to this article.
    I want to read more things approximately it!

  32. First of all I would like to say awesome blog!
    I had a quick question that I’d like to ask if you do not mind.
    I was interested to find out how you center yourself and clear
    your mind prior to writing. I’ve had a difficult time clearing my mind in getting my thoughts out there.
    I do enjoy writing however it just seems like the first 10 to 15
    minutes are lost simply just trying to figure out how to begin. Any suggestions or hints?
    Appreciate it!

  33. It is appropriate time to make some plans for the future and it’s
    time to be happy. I have read this post and if I could I desire to
    suggest you few interesting things or suggestions. Maybe
    you can write next articles referring to this article.
    I want to read more things about it!

  34. I have observed that car insurance companies know the automobiles which are vulnerable to accidents as well as other risks. Additionally, these people know what style of cars are inclined to higher risk as well as the higher risk they’ve already the higher your premium fee. Understanding the simple basics regarding car insurance will assist you to choose the right kind of insurance policy that should take care of your preferences in case you get involved in any accident. Thank you sharing the actual ideas on your own blog.

  35. It’s perfect time to make a few plans for the future and it is time to be happy.
    I’ve learn this put up and if I could I wish to counsel
    you some attention-grabbing things or suggestions. Maybe
    you could write next articles regarding this article. I desire to learn more issues approximately it!

  36. Somebody essentially lend a hand to make severely posts I’d state.
    That is the very first time I frequented your website page and to this point?

    I amazed with the analysis you made to create this particular post
    amazing. Wonderful process!

  37. When I originally commented I clicked the “Notify me when new comments are added” checkbox and
    now each time a comment is added I get four e-mails with the same comment.
    Is there any way you can remove me from that service?

    Many thanks!

  38. I will immediately snatch your rss as I can’t in finding your e-mail subscription link or e-newsletter service. Do you’ve any? Kindly let me know in order that I could subscribe. Thanks.

  39. Admiring the hard work you put into your site and in depth information you offer.
    It’s nice to come across a blog every once in a while that isn’t the same out of date rehashed information. Great
    read! I’ve bookmarked your site and I’m adding your RSS feeds to my
    Google account.

  40. really nice

    This is as a matter of fact established information my friend. you are a exceptionally good novelist . i dearth to dividend with you my website as well. tell me what do you deem about it

    buy youtube views

    Thankyou again for posting such good content. Cheers

  41. Please let me know if you’re looking for a author for your site. You have some really great articles and I think I would be a good asset. If you ever want to take some of the load off, I’d really like to write some content for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Thanks!

  42. Thanks , I have just been looking for info about this subject for a while and yours is the
    best I’ve came upon till now. But, what in regards to the conclusion? Are you sure in regards to the source?

  43. Great V I should certainly pronounce, impressed with your site. I had no trouble navigating through all the tabs and related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Reasonably unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your client to communicate. Excellent task..

  44. Hmm it appears like your blog ate my first comment
    (it was super long) so I guess I’ll just sum it up what I
    submitted and say, I’m thoroughly enjoying your blog.
    I too am an aspiring blog writer but I’m still new to the whole
    thing. Do you have any tips for newbie blog writers?
    I’d genuinely appreciate it.

Leave a Reply to Michaelwaify Cancel reply

Your email address will not be published. Required fields are marked *