Database development/admin – What exactly should I be trying to learn? [closed]

Closed 11 years ago.

Saving all hits to a web app

Are there standard approaches to persisting data for every hit that a web app receives? This would be for analytics purposes (as a better alternative to log mining down the road).

Clustering and custom applications

So lets say we have a clustered environment setup. We have a cluster SQL Server (I don’t know exactly how its done but lets just say its been done for the sake of argument). Now if a website or application is trying to access that database for read/write (say an ASP.NET app or a C# Winforms app) and during that time SQL goes down – it takes a couple of minutes for the clustering failover to take affect to switch to another node. What happens during this time?

Point me to info about constructing filters (of lists)

I would like some pointers to information which would help me understand how to go about providing the ability to filter a list of entities by their attributes as well as by attributes of related entities.

My father is a doctor. He is insisting on writing a database to store non-critical patient information, with no programming background [closed]

Closed 8 years ago.

DB API for shell scripting (any shell)

I am faced with some legacy shell scripts that run batch data processing jobs in Oracle using SQL+. For the most part, the data tier does not have to communicate back to the script with retrieved data to be passed for shell-level processing but in a few cases it does.

Keeping an enum and a table in sync

I’m making a program that will post data to a database, and I’ve run into a pattern that I’m sure is familiar: A short table of most-likely (very strongly likely) fixed values that serve as an enum. So suppose the following table called Status:

Why aren’t Object Oriented databases used as much as Relational Databases? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for […]

NoSQL as file meta database

I am trying to implement a virtual file system structure in front of an object storage (Openstack). For availability reasons we initially chose Cassandra, however while designing file system data model, it looked like a tree structure similar to a relational model. Here is the dilemma for availability and partition tolerance we need NoSQL, but our data model is relational.

When should we use weak entities when modelling a database?

This is basically a question about what are weak entities? When should we use them? How should they be modeled?