Good Design?

[rko]

Szenario
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?

[debasisdas]

Its very dificult to comment ,without knowing the minute details of the project.

All the aspects must be taken into consideration before the actual implementation.