[firebird-support] There are risks accessing a database with two servers?
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? Thanks in advance. Walter. [Non-text portions of this message have been removed]
Re: [firebird-support] There are risks accessing a database with two servers?
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? Classic server can't open a database opened by superserver, because SS opens it exclusive mode. May be the article refer to two classic servers accessing the same db. Jesús [Non-text portions of this message have been removed]
Re: [firebird-support] There are risks accessing a database with two servers?
I'm pretty sure that what the article means (although not clearly especified), is that you should have two firebird instances with 2 separated databases. These databases should be replicated from one (OLTP) to another (OLAP) in any way you think is best for your case. On Fri, Apr 26, 2013 at 10:45 AM, Jesus Garcia jeg...@gmail.com wrote: 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? Classic server can't open a database opened by superserver, because SS opens it exclusive mode. May be the article refer to two classic servers accessing the same db. Jesús [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]
Re: [firebird-support] There are risks accessing a database with two servers?
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
Re: [firebird-support] There are risks accessing a database with two servers?
Ok, thanks, it is more clear now. Where I can find more information about OLAP and OLTP, some link you can recommend me? Greetings. Walter. On Fri, Apr 26, 2013 at 9:51 AM, Mark Rotteveel m...@lawinegevaar.nlwrote: ** 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 * 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/
Re: [firebird-support] There are risks accessing a database with two servers?
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.nlwrote: ** 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
Re: [firebird-support] There are risks accessing a database with two servers?
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 t...@iblogmanager.comwrote: 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 ++ 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]
Re: [firebird-support] There are risks accessing a database with two servers?
Thank you very much Thomas, I shall read that article right now. Greetings. Walter. On Fri, Apr 26, 2013 at 12:53 PM, Thomas Steinmaurer t...@iblogmanager.comwrote: ** 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/
Re: [firebird-support] There are risks accessing a database with two servers?
Thank you very much Leonardo, I shall try to get the book. Greetings. Walter. On Fri, Apr 26, 2013 at 1:02 PM, Leonardo Carneiro chesterma...@gmail.comwrote: ** 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 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 ++ 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] [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/
Re: [firebird-support] There are risks accessing a database with two servers?
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.comwrote: ** 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/