> 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 <m...@lawinegevaar.nl>wrote: > >> ** >> >> >> On Fri, 26 Apr 2013 09:37:19 -0400, W O >> <sistemas2000profesio...@gmail.com> >> 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 > > >