A responsibility

Question

I start with databases. I played with MySQL and Informix, but never had a real project.

What is the real responsibility of the database? Should we add Warehouse procedures and functions to the database or just allow them to be a data store without logic?

Answer 1

It is generally considered good practice not to place business logic in your database. The main reason is maintainability. It is enough to use stored procedures, but including the business logic within these stored procedures makes it difficult to debug and update your application.

- . , , , - -, , .

- (, java #), , ORM, , .

, - db .

edit: , , -. (.. Sproc), , . , . , , -, , , , - ( , sproc - 1000 !)

, -, , .

Answer 2

?

- . CSV + (, Excel) - . , , , .

?

? , , "-", , , " ". , , . 4GL, SQL, MySQL. , , .., , . , . . , ( ), , .

Oracle, ( , ) . : - - ?

- , .

API , , , , , . , , - ( ), , .

, , - :

1. : . . CREATE OR REPLACE PACKAGE? , " ".

2. : , Oracle, . , , . , , " ", - , , , ; !

Answer 3

, . . - .

: , , , , - , , . . .

, -, , .

,

Start: Select the database in {postgreSQL, MySQL, SQL Server (Express Edition)} and install it. Read more about Coding Rules , Normal Forms , Good Resource Begin to learn SQL, write queries. Understand the basics of creating a schema. Learning a procedural language in a database. Ask doubts about SO.