Browsing articles in "DBMS"
Sep
20
2012

What is a Flat File Database?

Flat File Database

Databases have evolved as technology continues to develop.  Contrary to popular belief, databases have existed before computers were built.  The data was not recorded in a computer but with crude accounting systems which were used by banks.  There are different ways to collect and organize data to form a database.  One of the models used in early time before the age of computers were flat file databases.  A flat file database encodes a table of data in different means as a plain text file.  A [...]

Sep
19
2012

What is a DSN or Database Source Name?

Database Source Name

A data source name, also called the DSN, is a data structure that provides information on a certain database.  This database usually includes an open database community server that it requires to function effectively.  A data source name, which is usually embedded in a registry or a text file, includes information such as the name, the directory as well as the driver of the database.  The DSN also includes the name and password of the user, which also depends on the DSN type.  Most developer [...]

Apr
20
2012

What is a Microsoft Access Database?

Access Logo

Microsoft Office Access, also formerly known as Microsoft Access, is the newest addition to the software management tools provided by the Microsoft System last 2007. Microsoft Office Access is a combination of the Microsoft database engine system with software development tools as well as graphical user interface. Microsoft Office Access presents many productive tools to help software developers and architects build new and simple applications. History of Microsoft Office Access The first Microsoft Access was developed in November 1992, while the second version (version 1.1) [...]

Apr
15
2012

What is a Microsoft SQL Server Database?

Sql Server 2008 Management Studio

Microsoft SQL Server was developed by Microsoft in the year 2005. The Microsoft SQL Server is a relational database management system that has two main languages – the MS-SQL and T-SQL. The T-SQL or the Transact Structured Query Language is basically a tool that users can use to manage SQL servers. Although there are many SQL servers available in the market, Microsoft SQL server has provided the best services that money can buy, but what is the significance of Microsoft SQL Server to developers, businesses [...]

Apr
12
2012

What is a MySQL Database?

Mysql Logo

MySQL is one of the well-known relational database systems. It is owned by a Swedish company called MySQL AB, which became a subsidiary of Sun Microsystems in 2008, recently acquired by Oracle. It is widely used in web applications and also acts as a database component. It is commonly used for open source bug tracking tools such as Bugzilla. MySQL became well known due to the popularity of PHP and Ruby on Rails, which were often combined with it. High-traffic websites such as Google, YouTube, [...]

Apr
10
2012

What is a PostgreSQL Database?

Postgresql logo

PostgreSQL is primarily an object-relational database management system that was launched under BSD-style license. Thus, PostgreSQL is free software. It is then managed by several companies and is taken into global heights. History of the PostgreSQL Database PostgreSQL was developed after the Ingres project at the University of California in 1985. Its developer, Michael Stoneback, planned to commercialize the Ingres. After some time, he came back and started on the post Ingres project. The post Ingres project was conceptualized because of the problem on database [...]

Apr
8
2012

What is a Database Management System or DBMS?

Database Tables

The Database Management system or DBMS is also called a file or database manager that allows users to have access to a database. When a person uses a database manager system, he has the opportunity to understand where the necessary data are located. The Database Management System manages the user’s request to access a database and its data on other related programs. All about Database Management Systems A database system is a compilation of information in collaboration with a set of program in order to [...]

Mar
22
2012

What is ETL or Extract, Transform, and Load?

Extact Transform Load

To be able to understand ETL better, it’s best to first briefly say what a data warehouse is.  When you talk about Data Warehouse, what you’re actually talking about is the place where you keep all your data – electronically, that is.  However, your data warehouse isn’t only the place where you store all the electronic data you’ve gathered and now want to keep for future use.  It’s not like a garage where you carelessly throw in everything you’ve gathered.  Your data warehouse should be [...]

Mar
16
2012

What is Database Replication?

Database Replication

For anyone who has ever had problems with handling their bulk data, whether for personal use or for office purposes, the importance of database management cannot be emphasized enough. A lot of major corporations as well as individuals who run their own home-based businesses rely heavily on the computer for storing their important data among other things.  This is why database management has become a key player in the success of any business venture because it helps keep track of all the important information needed [...]

Mar
15
2012

What is Data Management?

Data Management

In any organization, whether at work or in school, data collecting is essential as it provides all the facts and references that you could need some time in the future.  Data is, in fact, an integral part in any endeavor as it provides you with all the premises that you could use to back up your claim, your conclusion or your solution.  This is especially true if you are running a business, big or small, as it gives you all the pertinent details that could [...]

Pages:12»

Advertisements