Database developers are a strange lot. We find things like entity relations and stored procedures cool. I know, it's probably not something you'd care to learn about, let alone think was cool. But what exactly is involved with database development, and what's my approach to it? Before we dive into that, let's review our areas of expertise, with regards to our database consulting and database development services.
Areas of Expertise
It seems like a new database comes along every day. I prefer to stick with the ones I know best. Therefore, I almost always develop database systems using one or more of the following technologies:
- Microsoft SQL Server
- Microsoft Access
- Visual FoxPro
If your project involves one (or more) of the above database technologies, I can probably help you. I've designed and created database management systems since the series Dallas was on TV. Yes, I've been doing database consulting for that long.
What's a Database?
A database management system (known as a "DBMS") is a set of computer programs that controls the creation, maintenance and storage of data. Sure it does a lot more than that, but that's the main purpose of a database, in a nutshell. Databases come in all shapes and sizes. For smaller applications, Microsoft Access may be used. For larger applications, Microsoft SQL Server, or MySQL might be used. For those in-between projects, something like Visual FoxPro is popular.
When we talk about database development, we are talking about defining, designing, developing and deploying a complete database solution. It's the whole enchilada. It involves the front-end (user interface) of the system, and it involves the back-end (database, other tiers). My point is, we aren't just creating tables here. We are designing and building an entire database-centric application. That's why they call it a database management system