|
Database Systems |
Rare thoughts on understanding and usage of database systems.
Content Index
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.
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.
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.
Daily news, white papers, tutorials and articles on databases.
Database Knowledge @ about.com
Mike Chapple's guide to databases.
Database News from ComputerWorld
Daily news on Databases from Computer World.
Fresh daily news on databases from eWEEK.com.
OffSite Links
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.
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.
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 · DevX · DB News · Contact · Site map · Get Help Most popular: Free Tools:
| |
Digg this · Add to del.icio.us · Add to Furl · We Can Help You!
