RDBMS Components Two important pieces of RDBMS architecture are the kernel, which is the software, and the data dictionary, which consists of the system-level data structures used by the kernel to manage the database. The RDBMS Kernel You might think of an RDBMS as an operating system (or set of subsystems), designed specifically for controlling […]
Tag Archives: Sql
06
Feb
Feb
Microsoft SQL Server is a very powerful and robust database application. It is the premiere choice of most large organizations who utilize a database solution. In most cases the data being stored in these databases are mission critical and coming up with a disaster recovery plan is top priority. There are many parts to a […]
05
Aug
Aug
Though basic queries work well in a Microsoft Access database, sometimes you need something a little more powerful, like a join query. Joins allow you to gather data from multiple tables at one time based upon existing relationships. Relationships can include one-to-one, one-to-many and many-to-many. Depending on your needs, there are several different types of […]