B]Szenario [/B]
a project for up to 4 million (prospective) users
data packages that are send and recieved range from 100k to 250 mb
system must be highly secure (patient data)
users must be verified
the ideal design of a university professor that should be done as follows - can anyone agree?
direct connection from the client via ODBC to a DBMS system, like e.g. Oracle
client access via PL-SQL-statements only - the Client defines all the SQL statements.
the complete business logic is completed as PL-SQL-statements in the client
Oracle facilitates all aspects of the connection - the threading (LOGGING, monitoring, user administration, en/decryption, …).
can and should such a design be implemented?
What are the problems?
Is that secure?
a project for up to 4 million (prospective) users
data packages that are send and recieved range from 100k to 250 mb
system must be highly secure (patient data)
users must be verified
the ideal design of a university professor that should be done as follows - can anyone agree?
direct connection from the client via ODBC to a DBMS system, like e.g. Oracle
client access via PL-SQL-statements only - the Client defines all the SQL statements.
the complete business logic is completed as PL-SQL-statements in the client
Oracle facilitates all aspects of the connection - the threading (LOGGING, monitoring, user administration, en/decryption, …).
can and should such a design be implemented?
What are the problems?
Is that secure?