Database Design Skills)

[Editor's note] Database is the core of the entire system. Its design is directly related to the efficiency of system execution and system stability. Therefore, in software system development, database design should follow the necessary database Paradigm Theory to reduce redundancy and ensure data integrity and correctness. There are still some skills in the database design process, which are worth learning and learning from.

Database Design Methods, specifications and skills
Database technology is the most effective means of information resource management. Database Design refers to constructing the optimal database mode for a given application environment, establishing a database and its application system, and effectively storing data to meet user information requirements and processing requirements.

Database Design Skills
When it comes to databases, I don't think we have to talk about the data structure first. In 1996, when I first went to college to study computer programming, the teacher told us: ComputerProgram= Data Structure +Algorithm. Although the current development of programs has gradually transitioned from process-oriented to object-oriented, I strongly agree with the formula that the teacher told us eight years ago: computer programs = data structures + algorithms.

Design principles and development skills for large databases
As computer technology is increasingly widely used in various fields of the national economy, while computer hardware is constantly miniaturization, application systems are evolving towards a more complex and large-scale direction. Database is the core of the entire system. Its design is directly related to the efficiency of system execution and system stability. Therefore, in software system development, database design should follow the necessary database Paradigm Theory to reduce redundancy and ensure data integrity and correctness.

Improve query performance using the Oracle execution plan mechanism
The time consumed when preparing to use the Oracle execution plan mechanism to improve query performance new SQL statements is the most important component of the Oracle SQL statement execution time. However, by understanding the internal execution plan generation mechanism of Oracle, you can control the number of times that Oracle spends evaluating the connection sequence and improve query performance in general.

How to import and export large amounts of data from MySQL
The size of the database exceeds a certain size. For example, if the size of 6 MB is used for export, the database can be correctly saved to the hard disk of the local machine, but cannot be imported!

Database performance improvement-reducing the number of visits to the database
In the previous two methods, we call the getproductsbycategoryid (categoryid) method of the productsbll class to obtain the product of the current category (first, through objectdatasource, and second, through getproductsincategory (categoryid )). each time a method is called, BLL calls the Dal, which queries the database through SQL and returns a specific record.

Several design paradigms of relational databases
What is paradigm? The paradigm is actually a specification for database design. databases designed according to this specification will make the structure clearer. In fact, the main purpose is to minimize data redundancy and avoid data exceptions. Therefore, we should understand the paradigm from this perspective, rather than simply understanding it in terms of concept.

In-depth analysis on Database permission settings
With the development of database technology in recent years, Informix Dynamic Server represented by UNIX platform and ms SQL sserver represented by NT platform have been widely used. In a public environment, there are a large number of user operations, including database administrators, mainly for data management and maintenance, as well as common users, for data modification and Data Query under certain authorization.
 

Original address: http://tb.blog.csdn.net/TrackBack.aspx? Postid = 1792908