The Evolution of Data Management Technology : from Traditional File to Data Warehouse.
1) Traditional data file processing
▲ The above figure is the process of file processing systems.
Traditional data file processing (TDFP) methods have several limitations. It is because the data must be accessed by a written software program and any changes require modifications to the program. Thus, it sometimes makes the end users to be frustrated. Hence, TDFP has been replaced by database processing systems and TDFP are now used as backups for database systems.
There are several advantages of TDFP which included:
TDFP also has some disadvantages which included:
(1) Data Redundancy (Duplication of Data). This will happen when the data need to be updated. For example, the same data item may have different names in different files or the same name may be used for different data items in different files.
(2) Lack of Data Integration. This is resulted from having the data in independent files as it made the process difficult to provide the users with the information for ad hoc request that required accessing data stored in several different files.
(3) Data Dependence. File descriptions are stored within each application program that accesses a given file.
(4) Lack of Data Integrity or Standardisation. There is a problem to ensure all the data is accentuated.
(Sources: http://www.ncbi.nlm.nih.gov/pmc/articles/PMC2245120/ and
2) Data Warehouse
Advantage Database Server -
Sybase iAnywhere - Embedded Database
Advantage Database Server lets you modernize your data with speed, ease and confidence.
Advantage Database Server is a full-featured, easily embedded, high performance client/server relational database management system specifically designed to meet the needs of business application developers. Advantage is unique among the Sybase database management offerings in that it provides both Indexed Sequential Access Method (ISAM) table-based and SQL-based data access, providing a growth path for database software applications and enabling them to use enterprise-caliber feature sets.
Advantage Database Server is specifically targeted towards Independent Software Vendors (ISVs) and is designed to be embedded into the business applications these ISVs build, sell and distribute. Advantage is ideal for small and medium sized environments, generally, 5 -500 users. Advantage requires no DBA or ongoing administration, excelling in database environments with limited or no IT Staff.
Replication Server -
A real-time data replication software and synchronization solution
Move and synchronize data across the distributed enterprise with Replication Server.
Replication Server moves and synchronizes data across the enterprise to meet a host of competing challenges in the enterprise, such as heterogeneous data replication and synchronization, real-time reporting, and disaster recovery and high availability. This allows businesses to comply with increasingly rigid industry regulations, remove risk from their distributed enterprise environments, and leverage existing investments of acquired assets.
In addition to Replication Server, the following replication product offerings are available:
• Replication Server Heterogeneous Edition – meets the data movement needs of enterprise customers by supporting multiple data source and target (Oracle, Microsoft, IBM or Sybase)
• Replication Server Messaging Edition - delivers heterogeneous database events proactively and non-intrusively across the enterprise in real-time
Data Warehousing Software -
Get Smart with Analytics Servers Designed for Faster Results
Insightful decision making commands a premium in today’s competitive world. Meeting the demand for business intelligence, advanced analytics, data mining, predictive modeling, stringent regulations and blazingly fast reporting requires more than a traditional data management system can handle.
More than 1700 enterprises all over the world get their answers up to 100 times faster with Sybase IQ. Sybase IQ handles the most challenging reporting, analytics, and data warehousing requirements with ease. Compatible with your choice of standard hardware platforms, operating systems and leading analytics applications, Sybase IQ offers extraordinarily high performance at a fraction of the cost of Teradata or other data warehouse appliances.
(Source: http://www.sybase.com/products/databasemanagement)
No comments:
Post a Comment