Links: Database design

Kristian Fiskerstrand's blog

folder Root folder Reference folder Development folder Database related folder Database design

Sub Categories:

Links:

Books on database design

 

Clicked: 121 Added: 2004-05-31 01:40:12 - Bad URL? Report it

Data Modeling Dictionary

ABIE - Aggregate Business Information Entity Derived from UBL. See also BBIE ACC - Aggregate Core Component Derived from UBL. See also BBIE ACORD - ACORD Property & Casualty XML http://www.acord.org Aggregation - Technique that optimizes data retrieval by summarizing rows of a fact table according to a specific dimension. Alternate Key - Column or combination of columns, not the primary key columns, whose values uniquely identify a row in a table. ANSI - American National Standards Institute http://www.ansi.org 

Clicked: 163 Added: 2004-06-03 18:52:39 - Bad URL? Report it

Database Normalization Tips

@MSDN: This article offers tips to developers to help them avoid some of the pitfalls when designing Access tables. This article applies to Microsoft Access databases (.mdb) and Microsoft Access projects (.adp). 

Clicked: 127 Added: 2004-06-03 18:50:21 - Bad URL? Report it

DB Designer

Great OpenSource application to design database structures 

Clicked: 170 Added: 2003-08-14 23:22:09 - Bad URL? Report it

Introduction to Database Design: Entity-Relationship Diagrams

Learn how to draw a picture of your data that describes the objects in your database ("entities" or "tables") and how they relate to one another. Also helps you identify facts about the objects that you want to keep track of ("attributes" or "fields") An essential first step in thinking about relational database design. Below you may download the handouts distributed in this presentation. Except where noted, all are available in Adobe Acrobat PDF format. 

Clicked: 127 Added: 2004-05-25 23:03:00 - Bad URL? Report it

Introduction to Relational DataBase Design

Introduction During the last months, I had great fun presenting a series of articles about the mSQL database and using it to introduce the reader to Web and Java database programming. The feedback I received from you was amazing and inspiring, thanks a lot! So far the articles were about "how to start". We had many examples that I tried to make as close to real and useful applications as I could. But, to create real-world applications, you need more knowledge than simply programming practices. A topic of great importance is to understand how to make a proper design of relational databases. There's been a great hype about "true" Object Data Bases and the hybrid "Object-Relational" ones. Object databases are not so new. There are many mature products with years on the market but "the big ones" are just now trying to incorporate some of their features. Actually I guess we will stick with Relational Databases for a long time to come, despite all the hype regarding Object Databases. The Relational model is not only very mature, but it has developed a strong knowledge on how to make a relational back-end fast and reliable, and how to exploit different technologies such as massive SMP, Optical jukeboxes, clustering and etc. Object databases are nowhere near to this, and I do not expect then to get there in the short or medium term.  

Clicked: 207 Added: 2003-12-15 13:53:39 - Bad URL? Report it

Introduction to Relational Database Design @ 15seconds

An important aspect of most every business is record keeping. In our information society, this has become an important aspect of business, and much of the world's computing power is dedicated to maintaining and using databases. Databases of all kinds pervade almost every business. All kinds of data, from emails and contact information to financial data and records of sales, are stored in some form of a database. The quest is on for meaningful storage of less-structured information, such as subject knowledge. This is the first of a two-part article that will provide an introduction to relational databases and the SQL language. This first part describes some of the key elements of the technology with an emphasis on database normalization. The second part will describe a less theoretical approach to database design, as well as provide an introduction to the SQL language.  

Clicked: 149 Added: 2004-05-04 00:04:22 - Bad URL? Report it

1| 2| Next >>
Total number of links: 602 in 81 (sub)categories - Suggest a link



[Sitemap]