I would like to redevelop a large FAQs page in one of our website.
At the moment, the page is a static HTML document with all the (expandable) questions/answers pairs structured in a DL list, each list being a category.
However, this leads to SEO issues. I would like to find the best way to redevelop this section so that each question maps to a unique URL in Google.
This is a Java EE, Spring/Hibernate (Oracle in the background) application. However we do not want to use our Oracle DB to store the FAQs. We would like to keep this page as much client-driven as possible. I have read that single-page web apps are bad for SEO.
What are your recommendations, CouchDB, NoSQL, partials? We are already using jQuery, AngularJS and Gson in the background.
If you implement the idea I wrote in the comments, I see no reason not to put the FAQ on your Oracle database - since you no longer need to transfer the database to the user.
If you still insist on not using your Oracle database, I would suggest not using a database, but saving the questions in an XML\JSON file instead.
If you need database capabilities, I usually recommend SQLite, but use whatever tool you know best.