dbms techmax book free download Just the term "dbms technology" that name is enough to be scared. Of course, one can't always stay away from fear, because it's so much easier than conquering it. But by learning how the database management system works and taking note of their various intricacies you'll also be able to conquer your own fears. That is, if you do so voluntarily and not because somebody told you to. Read on to learn how DBMS works and why it can help in facing your fears. All right, here's the first guy that you should be scared of (yeah, he is a real person - remember him?). He was first named as a "Moby Dick" by a storyteller and was first named as having large teeth. Apparently, he also had some special powers :-). So let's see what else we have to fear from the database management system. Fear #1: You can't access your data! In fact, some may even want to deny you had some access to your data in the first place! But believe me, if you have been using a database from time to time it's not as hard as many people think. If you're worried, most likely it's not your fault, but the one of the products you're using is obsolete and rigid in its structure. So what to do? Fear #2: You can't extend your data! Well, if you know how to code in SQL or write an advanced query you'll know there are ways for this. But what if you don't know how? What if you like writing macros (or VBA) in MS Access? Well, unfortunately I have bad news. There will be new ways to access your data soon - new DBMS technologies will come out on the market that will offer that option for free. Fear #3: You can't put your data into any format you want! Well, this is an obvious myth. If the product is flexible enough to have debug capabilities then you should be able to read your data in any format that's supported by the said tool. Use it as a text file, use it as a CSV file, use it as an XML file. So what are you waiting for? A "Database" Is A Collection Of Data Tables That Include An Index And Membership Relationships Between Those Tables. The Database Is Used To Access The Contents Of The Data Table And To Unify The Accessibility Of Data Within Different Uses Or For Different Purposes. The term "database" was first introduced by Edgar F. Codd in 1970s, who was the father of the relational database management system (RDBMS). According to Codd databases can be defined as follows: "A collection of data that includes an index and membership relationships among those tables." So how does a database look like? Well, it's just a bunch of tables with some data stored in them. Let's see what we have so far: First we have a schema – this is a set of classes representing objects which will be used later to store and retrieve different data types. 8eeb4e9f32 50
grifethpresmyte
Comments