Anyway, OLAP and OLTP are general database concepts, not only applied to Firebird. Wikipedia and other Google sources will give you enough informations to play with. If you want a more academic approach, you could look to this awesome book: http://www.amazon.com/Fundamentals-Database-Systems-Ramez-Elmasri/dp/0136086209
This is one is very good book to start if you want to have a plain database systems knowledge. On Fri, Apr 26, 2013 at 1:53 PM, Thomas Steinmaurer <[email protected]>wrote: > > Ok, thanks, it is more clear now. > > > > Where I can find more information about OLAP and OLTP, some link you can > > recommend me? > > You might get an idea what OLAP means and the article is related to > Firebird as well. ;-) > > > http://www.iblogmanager.com/download/misc/articles/2008_05_Aggregate_Tables_With_Firebird.pdf > > > Regards, > Thomas > > > Greetings. > > > > Walter. > > > > > > > > On Fri, Apr 26, 2013 at 9:51 AM, Mark Rotteveel <[email protected] > >wrote: > > > >> ** > >> > >> > >> On Fri, 26 Apr 2013 09:37:19 -0400, W O > >> <[email protected]> > >> wrote: > >> > >>> Hello everybody: > >>> > >>> After reading in this article: > >>> http://www.firebirdfaq.org/faq3/ > >>> > >>> "Alternatively, you can add a second server to do long running reports > >>> (OLAP) and keep Super Server for fast transactions (OLTP)." > >>> > >>> it seems possible and desirable to have 2 Servers, one for long running > >>> reports (probably using Classic) and another for the other tasks (using > >>> SuperServer) > >>> > >>> Is that right? > >>> > >>> There are not risks of corrupting the database doing so? > >> > >> I don't think they are talking about using two servers on the same > >> database. My guess is it is talking about a two (or more) database > setup: > >> One is the OLTP database and the other its the OLAP / data warehouse > >> database. The OLTP is used for the actual 'business' side of things, the > >> OLAP for generating reports. The OLAP database is reloaded (or > >> synchronized) regularly from the OLTP database, but might be slightly > out > >> of date. > >> > >> Mark > >> > >> > >> > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > > Visit http://www.firebirdsql.org and click the Resources item > > on the main (top) menu. Try Knowledgebase and FAQ links ! > > > > Also search the knowledgebases at http://www.ibphoenix.com > > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Yahoo! Groups Links > > > > > > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > > [Non-text portions of this message have been removed]
