Your article is very good Thomas and it give me several good ideas, thanks for sharing.
Greetings. Walter. On Fri, Apr 26, 2013 at 12:53 PM, Thomas Steinmaurer <t...@iblogmanager.com>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 <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 > > > > > > > > > [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/