| Wat type of architecture is Oracle??? [message #53940] |
Fri, 18 October 2002 11:27  |
Vikash
Messages: 17
Registered: April 2002
|
Junior Member |
|
|
Hello.
can i know wat type of architecture is Oracle 8i datbase and its developments application, that is, form builder, Web db..etc is??? Is it built on a 2-tier architecture or 3-tier one.
Can u give me some explanation, How is it a 2/3 tier model?
thanks,
Vikash
|
|
|
|
| Re: Wat type of architecture is Oracle??? [message #53941 is a reply to message #53940] |
Fri, 18 October 2002 13:19  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Vikash,
Oracle database is a RDBMS and could be either second or third tier. Some refer to it as back-end, because always stays on the back in the data centers to provide data management for the fron-end.
You can have Oracle Forms and Reports as front-end in a two-tier setup, or in a three-tier setup. In case of three-tier setup Oracle AS could be the middle-tier.
In case of two-tier setup, the application holds most of the business logic and uses the Oracle DB to query and store the data.
In three-tier setup, clients become very thin - just provide convinient GUI, the business logic is moved into the middle-tier on AS, and the Oracle DB still holds tha data. You can store some logic in Oracle as well using PL/SQL or JAVA stored procedures.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
