×
Discuss on any other topics
JBASE VS Oracle
- VIP1984
- Topic Author
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
15 years 4 months ago #3521
by VIP1984
JBASE VS Oracle was created by VIP1984
Hi All,
what is benefit JBASE over Oracle? which database recommended you use for T24? Oracle Or Jbase
what is benefit JBASE over Oracle? which database recommended you use for T24? Oracle Or Jbase
Please Log in or Create an account to join the conversation.
- Lior
- Offline
- Premium Member
Less
More
- Posts: 115
- Thank you received: 1
15 years 3 months ago - 15 years 3 months ago #3526
by Lior
Replied by Lior on topic Re:JBASE VS Oracle
T24 is always working with Jbase as its data base.
However, Temenos introduces a solution where Oracle can be used as well.
In Oracle there will be a table for each Jbase table.
The data in Oracle will be kept as XML data-type
Meaning, all the data base operations in T24 are done with the Jbase data base 'as usual' - read, write, update, etc.
However, the data is being translated to XML and being sent to/from the Oracle data base.
For example, a read operation from Customer table will send the request from the T24 application to Jbase, the Jbase will perform a read from Oracle table with the Customer ID, it will receive a string of XML that represents the data, it will format it with the Jbase format and send it back to the application.
It solves some issues like the limitation of table sizes in Jbase and adds some backup utilities of Orace.
Yet, it adds some complexity and harms performance as there is another layer.
However, Temenos introduces a solution where Oracle can be used as well.
In Oracle there will be a table for each Jbase table.
The data in Oracle will be kept as XML data-type
Meaning, all the data base operations in T24 are done with the Jbase data base 'as usual' - read, write, update, etc.
However, the data is being translated to XML and being sent to/from the Oracle data base.
For example, a read operation from Customer table will send the request from the T24 application to Jbase, the Jbase will perform a read from Oracle table with the Customer ID, it will receive a string of XML that represents the data, it will format it with the Jbase format and send it back to the application.
It solves some issues like the limitation of table sizes in Jbase and adds some backup utilities of Orace.
Yet, it adds some complexity and harms performance as there is another layer.
Last edit: 15 years 3 months ago by Lior.
Please Log in or Create an account to join the conversation.
Time to create page: 0.061 seconds