Browsing articles by " Anthony Clark"
Sep
25
2012

What is a Disaster Recovery Data Center

Disaster Recovery Data Center

As corporate dependence on IT solutions continues to grow in the early 21st century, demand for reliable, cost effective disaster recovery data centers is expected to be one of the major growth markets for server and networking suppliers in their search for business continuity solutions in the event of unforeseen disaster striking. Disaster recovery has taken on more urgency with the growth of computer use within global corporations, and uptake in developing nations. Recent tragedies such as 9/11, North-Eastern  power blackouts, or the Asian tsunami [...]

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 [...]

Sep
17
2012

What is a Disaster Recovery Plan?

Disaster-Recovery-Plan

Disaster recovery planning is an IT function often involving a whole of business team whose role it is to anticipate disasters of any scale, determine the effects these would have on business continuity, and then create a set of policies and procedures for minimizing downtime and expediting recovery to pre-disaster levels. In smaller corporations the disaster recovery plan may in fact be just a sheets of paper listing steps to take when the unforeseen occurs, in fact, smaller organizations may be able to download disaster [...]

Sep
10
2012

What is an Open Source Database?

MySQL PostgreSQL

Open source is a kind of design where you can immediately access any kind of information from a set group with less hassle.  This method has been closely studied by various companies to see whether this method can be used for their business.  It has also reached technology in the form of open source database. The term itself, open source, has been gaining popularity with the development of technology, such as computers and Internet, which allows large numbers of users to tap into their sources [...]

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
20
2012

What is Enterprise Information Integration

Enterprise Information Integration

Enterprise Information Integration, otherwise known by the acronym EII, refers to the ability of software to access data from multiple and perhaps incompatible sources using a single interface, in most cases custom written for the organizational needs, and which may include more display methods than a simple database query allows, for example graphical representation of data. The goal of enterprise information integration is to present the data homogeneously such that the user is not aware of the actual sources of the information, and thru presenting [...]

Mar
18
2012

What is Datawarehouse?

data Warehouse

Datawarehouse is primarily the depository of electronically stored data.  This tool is essential to aid in reporting as well as in analyzing.  Although, datawarehouse is focused on data storage, this is also used to extract and analyze data, transform, load and manipulate the data in the database or data dictionary.  Thus, datawarehouse is also defined as a repository of data, business intelligence tools and tools to manage or manipulate the metadata.  Datawarehouse is constantly being performed in a day-to-day basis.  With the use of the [...]

Mar
17
2012

What is Datamining?

Datamining

Most often, users would need an important tool to maximize the use of the database, and there is a certain tool that can help maximize the transformation of data to information, and this tool is called “datamining”.  Datamining is used to extract the hidden information from the database.  Datamining is commonly used for businesses and security purposes.  This certainly applies to any type of data, and it can unravel certain hidden patterns within the database.  But make sure that the hidden patterns are present within [...]

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 [...]

Pages:12345»