Rare thoughts on understanding and usage of database systems.

Content Index

English Automating Progress® Database Maintenance

Maintenance of Progress® databases usually is a painless task, since most Progress® databases do run stable and solid as a rock without any DBA efforts. However, large Progress® databases may need some performance tuning every once in a while. Furthermore you need to monitor their allocation of disk space, especially on Windows® machines, where file sizes might be limited. Unfortunately Progress Software® does not provide GUI maintenance tools for every type of installation, thus you may need additional software. Read here what you need to keep your Progress® databases in good shape.

English Database Design Guide

Before you set up a new database, usually you spend a lot of time at the white board. Here are some basic tips. Most probably these Dos and Don'ts of database design will reduce your efforts and help you to gain a clean database design. The examples refer to Progress® databases, but you’ll get the idea, even when you use another database system.

German Es gibt keine Alternative zu technischen Primärschlüsseln

There is no such thing as a primary key with business meaning ... Das hier erläuterte Konzept der 'Eindeutigen Objektidentität' gilt nicht nur für die objektorientierte Softwareentwicklung. Technische Schlüsselsysteme können in jeder Architektur und mit jeder Datenbank eingesetzt werden.

English DevX Database Zone

Daily news, white papers, tutorials and articles on databases.

English Database Knowledge @ about.com

Mike Chapple's guide to databases.

English Database News from ComputerWorld

Daily news on Databases from Computer World.

English eWeek Database News

Fresh daily news on databases from eWEEK.com.

OffSite Links

English Database Debunkings

Fabian Pascal and C.J. Date made up this web site that sets matters straight by telling the truth about database management. It is the critical forum for concepts, principles and methods and their practical implications that receive little, incorrect, or no coverage from the trade media, and no consideration from vendors and industry pundits. It is dedicated to and intended for MIS professionals, application developers, managers, users (experienced or novices), academics and students who think for themselves, want to understand database management, rather than follow the prevailing "cookbook" approach, and who are interested in minimizing the severe costs imposed by mindless technology and marketing fads. The site is focused on database education--as distinct from product-specific training--and should be, therefore, useful, regardless of DBMS software or technology is used.

English Where Have All The Good Databases Gone?

Adam Bosworth (Google) asks a great question on his blog. He writes "Users of databases tend to ask for three very simple things:
1. Dynamic schema so that as the business model/description of goods or services changes and evolves, this evolution can be handled seamlessly in a system running 24 by 7, 365 days a year.
2. Dynamic partitioning of data across large dynamic numbers of machines.
3. Modern indexing. Google has spoiled the world. Everyone has learned that just typing in a few words should show the relevant results in a couple of hundred milliseconds.
Users of databases don't believe that they are getting any of these three. If the database vendors ARE solving these problems, then they aren't doing a good job of telling the rest of us. The customers I talk to who are using the traditional databases are esentially using them as very dumb row stores and trying very hard to move all the logic and searching out into arrays of machines with in memory caches."
This article and the following discussion on the need for data-base evolution is a great read.

English Database Abstraction Layers Must Die!

Some random bits scribbled by Jeremy Zawodny from Yahoo!
"Good engineers try to select the best tools for the job and then do everything they can to take advantage of their tool's unique and most powerful features. In the database world, that means specific hints, indexing, data types, and even table structure decisions. If you truly limit yourself to the subset of features that is common across all major RDBMSes, you're doing yourself and your clients a huge disservice."

· Home

· Databases

· smartDBcheck

· Design Guide

· Object Identifier

· DB Debunk

· DevX

· Good DBs?

· DB Abstraction Layers

· about.com

· ComputerWorld

· DB News

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help

Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly

Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking

Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed

Digg this · Add to del.icio.us · Add to Furl · We Can Help You!

Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives

Top of page

No Ads

Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy