This chapter is from the book
This chapter is from the book
This chapter is from the book
Database Skills
Database skills are essential for almost any application using WebLogic. Information must be gathered, stored, and recalled on a moment's notice free from errors. Database specialists ensure that the system is scalable and has good performance for the application. This first step in this process is always database design.
Database Design
Database design encompasses knowledge of grouping related information. This enables information to be found and queried easily. Using certain rules such as third normal form, tables, fields, primary keys, foreign keys, and so on can be identified. A good database designer can make it easy for administration later on.
NOTE
A database designer can make the job of the entire team easy or near impossible. This can affect the entire project development process and even maintenance later on.
Database Development
Database developers take the design specifications and create the database, stored procedures, and views necessary for the application. Each database is slightly different in the features it supports, so database developers usually develop for only one database, such as Oracle or Microsoft SQL Server. This might not be true in all cases, but it's generally true that the larger the project, the more specialized the people.
Database Administration
Database administration is often overlooked when developing applications, but it's a crucial aspect of all areas of an application life cycle. Database administrators are responsible for analyzing database use to increase performance using database views, memory allocation, table size allocation, and stored procedures. These performance tweaks allow WLS applications to speed up the most time-consuming operation: waiting for data.