Data Management

Data Management

Time for a New View of Data Management by Curt A. Monash is an article about “Database management is in a crisis, one that's only partly recognized.” In this article tell us how there is so many different components to data, with different jobs that people have. They are all made harder “the boggling complexity of relational schemas.” They think that all this is going cause the data management to fall “As schema diversity explodes, the pure relational model is collapsing under its own weight.” Thought they say there is a cure or replacement to this. “We must replace it with a radically different view of data management, which I'm calling DBMS2, for database management system services.”

Some key aspects of DBMS2 are one use the cheapest/ simplest set of applications “cheap online transaction processing DBMSs, high-end OLTP DBMSs, data warehouse appliances, XML-based document stores, highly distributed and/or small-footprint DBMSs, in-memory systems without their own persistent storage, or cross-corpus indexers without their own storage.” Also you should limit you schema and not go past two simple models of this. “master-detail for transactions, and hypercubes/star schemas for analytics. Anything inherently more complex is, with rare exceptions, better handled via the schema flexibility of XML. If you need to access data from a legacy application that violates these precepts, do so via XML-based Web services.” Though  most DBMS2 data will integrate into an XML. “DBMS2 is the antithesis of much current database theory. Rather than fighting modularity, DBMS2 embraces it. Rather than gathering administrative tasks in one huge hairball, it spreads them across many simple systems. Above all, unlike the Oracle pipe dream of a grand unified enterprise relational database, DBMS2 is a pragmatic, realistic continuation of what every large enterprise is doing today.” The Biggest reason for the embracement of the DBMS is it is low cost and traditional. ”For most enterprises, relational OLTP is approaching commodity status.”