Results 1 to 2 of 2

Thread: Needed Tips for Database users

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    85

    Cool Needed Tips for Database users

    Can someone give suggestions that database users have to bear in mind while using or creating or accessing database? Say like tips for database users.


  2. #2
    Contributing Member
    Join Date
    Jul 2006
    Answers
    93

    Re: Needed Tips for Database users

    There are various hints and guidelines a programmer or database user has to bear in mind while using or creating or accessing database. Some of them are given below:
    * Database Design is the heart of database. So this has to be designed properly taking all needs and functionality into consideration in the initial stage itself as modification to the design stage would increase the cost and complexity of the database application in addition to adding work overload to the database users.
    * Proper and standardized naming convention has to be decided and this has to be followed throughout. This is very important as this helps to achieve standardization and helps the database application to be maintained easily for further usage.
    * Wherever possible it is always good to use system tables directly. Only in situation of where system tables could not be used avoid the usage of system tables.
    * Though complete normalization cannot be achieved it is always best to achieve at least till third normal level. Also keep in mind to give room for de-normalization to certain level as this helps the query processing to be done fast.
    * Always document properly in SQL triggers, procedures and batch files as this would help all users to know the functionality of written triggers or procedures or batch files and make use of them at appropriate places without rewriting them in different manner again. This approach would also help in future maintenance.
    * Always in database operations users must aim for best performance achievement. This can be achieved by using less Input Output operations. One way for achieving this is use only needed attributes or column names in select statement and avoid using select * in select statement unless the usage of all column in the table is very much needed.
    * A good database design would definitely have a primary key designed in it. So when there is choice between using while looping structure and cursors it is always better to go for while structure rather than cursors. Also one important point to bear in mind while using the while looping construct is include primary key in the same while querying.
    * It is always best to avoid temporary table. This would decrease the table scan and there by input and output operations and there by improve the performance of the database application.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact