 |
|||
Sharing Knowledge of |
|||
My website discusses themes regarding database modeling,
normalization techniques, primary key considerations, programming strategies, DBA problems (and solutions),
and many other issues relating to building database models that will form the basis of high-performing databases.
|
"The most important motive for study at school, at the university, and in life, is the pleasure of working and thereby obtaining results which will serve the community. The most important task for our educators is to awaken and encourage these psychological forces in a young man or woman. Such a basis alone can lead to the joy of possessing one of the most precious assets in the world - Knowledge or artistic skill." Albert Einstein |
Have a nice time exploring this site!
Interview with
Donald Burleson
Interview with
Steven Feuerstein
What visitors say...
I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."
Mike, USA
Free eBook
Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:
Workshop
On rare occasions, I may perform a Database Design Workshop . Unfortunately, I am currently unable to, but maybe later...Influence me
Influence the content on this site: I want to know what database information you need the most: Participate in my Database Design Content investigation. I would appreciate it if you took the time...Database eBooks
DB Normalization
Analysis Phase
Database Keys
Software Tools
DB Glossary
Appl.Architecture
Oracle DBA
MySQL DBA
SQL Server DBA
Install Oracle
Install SQL Server
Proj.Management
Oracle Constraint
Programming Tips
Bookstore
Worst DB Designs
Internet biz.
Website Design
Database Normalization eBook:
 |
Blink
Del.icio.us
Digg
Furl
Google
Simpy
Spurl
Technorati
Y! MyWebAll rights reserved.
All information contained on this website is for informational purposes only.
*Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.
Return to top
The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.
Custom Spider Map for www.databasedesign-resource.com
The Database Design Resource Center
A database design resource center for DB Professionals seeking solutions to database design details in relational databases.
Interview with Donald Burleson
Interview with Donald Burleson on Oracle DBA and business building
Interview with Steven Feuerstein
Interview with Steven Feuerstein on Oracle PL/SQL Programming
Contact me: The author at the Database Design Resource Center
Contact me: The author at the Database Design Resource Center
The Database Design Resource Center Newsletter
Database Design Newsletter
The Database Design Resource Center sitemap
The Database Design Resource Center sitemap
About me: The author at the Database Design Resource Center
About me: The author at the Database Design Resource Center: Who is behind this voice?
The Database Design Watercooler : A small pause from your database design work
The Database Design Watercooler : A small pause from your database design work
Free eBook: The eBook on how to create your own eBook!
Free eBook: The eBook on how to create your own eBook! All you need to know to make and sell an Internet product! free of charge!
eBook affiliate program: A chance to earn my own Internet income!
Join for free as an affiliate for this eBook affiliate program: A chance to earn extra income from your website!
eBook lectures in database design
eBook lectures in database design with emphasis on performance, normalization and tuning
Entity Relationship Modeling - Principles
Entity Relationship Modeling - a lecture on the prinsiples of er diagrams and erd modelling, with focus on proper entity and relationship principles
Database Design Testimonials: Feedback from visitors
Database Design Testimonials: Feedback from visitors, What I have received, of good, bad and evil remarks.
Using a ref cursor in Oracle PL/SQL
Using a ref cursor in Oracle PL/SQL programming
Using an Oracle ref cursor in Java
Using an Oracle ref cursor in Java is an easy way to get your data from the database and into your Java application.
Oracle DBA : Common tasks you have to master in your work as an Oracle DBA.
Oracle DBA : Common tasks you have to master in your work as an Oracle DBA.
Oracle Recovery : Restoring the database after uncontrolled shutdowns.
Oracle Recovery : Restoring the database after uncontrolled shutdowns.
Database Design Workshop: Personalized training
Database Design Workshop: Personalized training. An in-house workshop dedicated to your exact needs
Important analyst ethics - reminding words
Analysis Trap 2 - Incomplete business understanding. The lack of experienced system analysts are often a key failure factor in system development
The Analysis phase - The starting point of effective Database Design
The Analysis phase - The starting point of effective Database Design. This is series of articles adressing different issues in the database analysis phase
The database analysis team - Teamwork
The database analysis team - Teamwork. what is the ideal team in database analysis?
A database design content survey for this website
A database design content survey for this website
database theory and practice : Dealing with databases in practice
Database theory and practice : dealing with today's relational databases in accordance with the relational model
Flat relational tables : Like the Earth is flat
Flat relational tables : There are many who argue that relational tables are flat, or two-dimensional. What is the thruth about it, and: Are we walking on a flat Earth?
Atomic database values : How small is small enough?
Atomic database values : How small is small enough? This article deals with the breakdown of information into : How small units?
NULL values in a database
Should we be able to store NULL values in a database. A discussion of NULL values with examples
Worst Database Design
The worst database design experience: Share your experience with a qualified group of DB professionals
Oracle Developer
I was hired as a developer on a mature project, still running on Forms/Reports 6.0 (not 6i) in 2006. My job consisted of fixing problems in a
Oracle Developer
I was hired as a developer on a mature project, still running on Forms/Reports 6.0 (not 6i) in 2006. My job consisted of fixing problems in a
Using a Sequence instead of a year number
Using a Sequence instead of a year number: I just have to tell you this one: While working as a DB QA manager in a large DB project, upon revision of
Using a Sequence instead of a year number
Using a Sequence instead of a year number: I just have to tell you this one: While working as a DB QA manager in a large DB project, upon revision of
Database normalization - Creating high performance from the start
Database normalization - Creating high performance from the start. The importance of a well-normalized database design should never be underestimated
The 5 Normal forms in Database Design
The 5 Normal forms in Database Design. The formal definition of the five Normal Forms as a foundation for sound database design
Database Normalization Techniques - Essentials
Mastering database normalization techniques: Essentials for high performance relational databases
Primary and foreign keys - How to find your rows
Primary and foreign keys - How to find your rows in relational databases
Defining Primary Keys: Critical issues and strategies
Choosing the right primary key for a table is one of the most important issues for creating a high performance database. This lecture discusses the good and the not-so-good options for primary keys.
Database Software Products that enhances your productivity
Database Software Products that enhances your productivity
Using case tools : An invaluable tool for database designers
Using case tools : An invaluable tool for database designers
Database Glossary. Important database design terms in database design defined.
Database Glossary. Important database design terms in database design defined.
Analysis Trap 2 - Incomplete business understanding
Analysis Trap 2 - Incomplete business understanding. The lack of experienced system analysts are often a key failure factor in system development
How should you design your database application architecture - High Performance
How should you design your database application architecture - High Performance applications use normalised databases and a sound architecture.
OO-Programming and Relational Databases
oo Programming and Relational Databases: How to combine the best from both worlds
Being a SQL Server DBA : Common tasks and solutions
Being a SQL Server DBA : Common tasks and solutions
Adding users in SQL Server : An illustrated how-to
Adding users in SQL Server : An illustrated how-to step by step
Installing the Oracle Database: a concentrated how-to
Installing the Oracle Database: a concentrated how-to, based on all the troubles others have experienced
Trial Oracle download: How to get it
Trial Oracle download: Where you can find it and what other resources you'll need
Installing SQL Server Database: Tips, tricks and traps
Installing SQL Server Database: A complete set of articles on tips, trick and traps for SQL Server DBAs
SQL Server hardware requirements: Minimum and recommendations
SQL Server hardware requirements: An overview of minimum and recommended hardware configurations
Software Project Management - Introduction to project teamwork in the industry
Software Project Management - Introduction to project teamwork in the IT industry
Work Breakdown Structure : Managing large projects
Work Breakdown Structure : Managing large projects: An introduction
Oracle database constraints: The declarative approach
Oracle database constraints: The declarative approach to data integrity in the database
What are Oracle Constraints: A primer
What are Oracle Constraints: A primer: Basic concepts abour Oracle constraints and their usability
Programming against databases
Programming against databases. Tips and hints for programming against major relational databases.
SQL programming: A short intro and useful links.
SQL programming: A short intro and useful links.
Hardcopy books and selected writings on the Net
Hardcopy books and selected writings on database design, performance, normalization and tuning
Enabling and disabling Oracle constraints: Short how-to
Enabling and disabling Oracle constraints: Short how-to and introduction to constraint handling
Oracle constraints and indexing: performance improvements
Oracle constraints and indexing: performance improvements
Disabling constraints: An automated process
Disabling constraints: An automated process: Copy and use this procedure
Constraint naming standard: A suggestion
Constraint naming standard: A suggestion how to easily recognize and classify Oracle constraints in your database's metadata.
Unique constraints in Oracle: how-to
Unique constraints in Oracle: how-to: An introduction to key constraints
Foreign key constraints: Enforcing referential integrity
Foreign key constraints: Enforcing referential integrity by declaring relationships in the database
Referential integrity : Binding together rows from different tables
Referential integrity explained: binding rows in different tables together
Candidate keys: Choosing the right primary key
Candidate keys: Choosing the right primary key. When an entity or a table has multple candidate keys, how should we choose the right one?
Business rules: Informal predicates. A foundation
Business Rules: Informal Predicates - What are they, and how are they represented in the database?
Deferred integrity constraints: Why you should avoid it
Deferred integrity constraints: What it is, and why you should avoid it
Constraints on views: What is allowed in Oracle?
Constraints on views: What is allowed in Oracle? A specification of what is allowed to define
User-defined types: Type definition in Oracle
User defined types: Type definition in Oracle. Define your own data types
Agile Project Management : The Scrum approach
Agile Project Management : The Scrum approach: An introduction to new methods
Multidimensional Project Management : A brief introduction
Multidimensional Project Management : A brief introduction: Chaos or top efficient?
Collaborative Project Management : Keeping all the strings together
Collaborative Project Management : Keeping all the strings together: A brief introduction
Project Management Failure : Why projects fail
Project Management Failure : Why projects fail. Critical factors that should not be ignored.
Managing Software Projects - Not for the weak-hearted
Managing Software Projects - A brief introduction and guidelines
Gantt Charts : A must-have tool for Project Managers
Gantt Charts : A must-have tool for Project Managers: A beginners guide for project managers
Pert Charts : the Project Network Diagramming technique
Pert Charts : the Project Network Diagramming technique: An introduction
Project Time Tracking : Having control over your software project
Project Time Tracking : Having control over your software project: An introduction
Project Management Success : How to handle the stakeholders
Project Management Success : How to handle the stakeholders: Balancing the interest groups in a software project management situation.
SQL Server edition: Different releases
SQL Server edition: How to upgrade your SQL Server database and select the right version
SQL Server options when installing
SQL Server options when installing the database
SQL Server installation confirmation: Testing the correctness
SQL Server installation confirmation: Testing the correctness of your new installation or upgrade
Uninstall SQL Server: Detailed how-to
Uninstall SQL Server: Detailed how-to instructions on how to rebuild a SQL Server database after a failure
SQL Server overview: Basic components of the product
SQL Server overview: A walk-through of SQL Server's most important components
SQL Server Installation - Tutorial
SQL Server Installation - An illustrated step by step tutorial
SQL Server installation methods: different options
SQL Server installation methods: details on each installation option
Upgrading SQL Server. New versions of your database
Upgrading SQL Server: A short tutorial
SQL Server troubleshooting: How to find and correct installation problems
SQL Server troubleshooting: How to find and correct installation problems
Preparing the Oracle environment: Tips
Preparing the Oracle environment: Useful information and capacity figures
Oracle installation: A quick guide
Oracle installation: An easy guide with illustrated examples
Configuring and tuning Oracle
Configuring and tuning Oracle: Tricks to help you run the system without problems
Adding users in Oracle databases: A simple guide.
Adding users in Oracle databases: A simple guide.
Oracle installation problems: How to correct them
Oracle installation problems: Common problems and how to fix them
Oracle access control: How to protect your database
Oracle access control: How to protect your database with passwords, roles and privileges
Security settings in Oracle: Your possibilities
Security settings in Oracle: System and schema object privileges
Moving the database : SQL Server detach and attach functionality
Moving the database : SQL Server detach and attach functionality
SQL Server jobs - Using jobs in SQL Server to getting the job done
SQL Server jobs - Using jobs in SQL Server to getting the job done
SQL Server Profiler - Monitoring activities in the database
SQL Server Profiler - Monitoring activities in the database
SQL Server Transaction log - A short how-to
SQL Server Transaction log - A short how-to
Import and export in SQL Server : How to set it up
Import and export in SQL Server : How to set it up
SQL Server indexes - Speeding up performance in the database
SQL Server indexes - Speeding up performance in the database
SQL Server Maintenance Plan - Keeping your database in shape
SQL Server Maintenance Plan - Keeping your database in shape
SQL Server Backup - Secure your database for disaster
SQL Server Backup - Secure your database for disaster
SQL Server restore database - when catastrophy happens
SQL Server restore database - when catastrophy happens
SQL Server training for DBAs
SQL Server training for DBAs : A simple tutorial on application architecture
Denormalization, Database normalization and Performance
Denormalization, Database normalization and Performance - Hidden dangers. What are the real impacts when you denormalize a database structure ?
Microsoft SQL Server Training : The Presentation layer
Microsoft SQL Server training : The Presentation layer. The last of the tutorials on SQL Server Architecture
SQL Server programming : The business tier
SQL Server programming : The business tier. Efficient software development
The Universe - A Simplified Database Model
The Universe - A Simplified Data Model. J ust for fun: we'll see how far we can get with one, two, and three entities and Entity Relationship modeling.
DBxtra database reporting tool: A professional database reporting and extraction
DBxtra database reporting tool: A professional database reporting and extraction package!
Compare databases and synchronize automatically (SQL Server only)
Compare databases and synchronize automatically (SQL Server only)
IT Project Management Tools: A complete set of workbooks
IT Project Management Tools: A complete set of workbooks
Objects vs relational tables: What's the big catch? How to dismantle a car
Objects vs relational tables: What's the big catch? How to dismantle a car (or an atomic bomb), and get a brand new car each day
Database Analysis: Using generic or specific models?
Database Analysis: Using generic or specific models?
Analysis Progress - Increasing speed
Analysis Progress - Increasing speed. Today's tools make designing databases happen faster and faster
Database Analysis Trap 1 - Incompleteness
Database Analysis Trap 1 - Incompleteness. Looking at only part of the business may get you into serious trouble in your ER modeling
Oracle indexes : The easy way to high performance.
Oracle indexes : The easy way to high performance.
Oracle Scheduler : Putting tasks in an Oracle database on auto pilot.
Oracle Scheduler : Putting tasks in an Oracle database on auto pilot.
Oracle Export : The tool for extracting data subsets from your Oracle database
Oracle Export : The tool for extracting data subsets from your Oracle database
Performing an Oracle Backup : A simple guide to backing up an Oracle Database.
Performing an Oracle Backup : A simple guide to backing up an Oracle Database.
Oracle Import : Loading data into your Oracle Database.
Oracle Import : Loading data into your Oracle Database.
Oracle log files : An introduction and step-by-step tutorial.
Oracle log files : An introduction and step-by-step tutorial.
Redefining Oracle objects : Changing database objects in real-time.
Redefining Oracle objects : Changing database objects in real-time.
Oracle partitions : A method to segment your tables.
Oracle partitions : A method to segment your tables.
SBI! TV
DESCRIPTION NOT FOUND
MySQL DBA : Common tasks you have to master in your work as a MySQL DBA.
MySQL DBA : Important DBA tasks and programming tips and tricks for MySQL DBAs and programmers/developers
MySQL Database Design: General hints and tricks
MySQL Database Design: General guidelines for designing database tables in MySQL
MySQL Database Management: General hints and tricks
MySQL Database Management: How to administer and define your MySQL database system
MySQL Storage Engines: General hints and tricks
MySQL Storage Engines: How to choose the right storage model for your system or different tables?
MySQL Stored Procedures: General hints and tricks
MySQL Stored Procedures: How to write highly effective stored procedures that will enhance productivity, security and application logic independence
MySQL Triggers: An instruction guide
MySQL Triggers: How to write secure updating mechanisms and populate tables within a modification of other tables.
MySQL Backup: A quick guide on MySQL DBA tasks
MySQL Backup: A user's guide to backup and recovery in MySQL
MySQL Replication: General hints and tricks
MySQL Replication: How to administer and define a failsafe MySQL database system
MySQL Transactions: An instruction guide
MySQL Transactions: How to write secure updating mechanisms according to the ACID principle
MySQL Tuning: General hints and tricks, and examples
MySQL Tuning: General guidelines for tuning a MySQL database, with thorough examples
The database designforum
SBI Website Design: Build your own Internet Business
SBI Website Design: Build your own Internet Business
|
Search engine spider map courtesy of:
Search Engine Marketing Tools |