Diskpar.exe is used for aligning a partition
at the storage level, to align at 64 KB ,can result in 20-30% performance improvement.
Disabling inflow control allows the writing the
I/O to cache
Random, Sequential, Reads, Writes
Apps with Higher % of I/O content
Email, DSS, and Rich Media
Apps with Higher % of CPU content
OLAP, CRM, and ERP
I have used three types of statements:
I. Statement – Executes
a standard query
II. PreparedStatement –
Executes a precompiled SQL statement
III. CallableStatement –
Executes non-SQL Statement
Metadata
is data (or information) about data. JDBC allows the programmer to discover a large amount of information about a database
and any given ResultSet via metadata classes.
ODBC (Open Database Connectivity), a C-based
interface to SQL-based database engines, provides a consistent interface for communicating with a database and for accessing
database metadata (information about the database system vendor, how the data is stored, and so on).
Individual vendors provide specific drivers
or "bridges" to their particular database management system. Consequently, thanks to ODBC and SQL, I can connect to a database
and manipulate it in a standard way. It is no surprise that, although ODBC began as a PC standard, it has become nearly an
industry standard.
I have used it
as a front-end accessing data from an Oracle back-end using the Oracle ODBC Driver.
I. Data definition functionality
II. Physical criteria
III. Access criteria
IV. Transactions
V. Utilities
VI. Development tools
VII. Miscellaneous features
Constraints that are derived from the meaning and interrelationships
of the data attributes
I. Descriptive page titles
II. Clear instructions
III. Consistent grouping of input fields
IV. Logically labeled fields
V. Consistent color use
VI. Properly sized data entry fields
VII. Logical cursor movement
VIII. Error messages
IX. Clearly indicated optional fields
X. Completion message
I. Identifying entities
II. Identifying attributes and attribute domains
for entities
III. Identifying relationships
IV. Identifying candidate and primary keys for entities
V. Creating an Entity-Relationship diagram
VI. Reviewing the ER model by the user and design
team