Integrator Toolbox: New crop of systems bring more features

At first glance, enterprise database systems seem to be super-sized versions of popular desktop database applications, such as Microsoft Access. But they have distinct differences.

At first glance, enterprise database systems seem to be super-sized versions of popular desktop database applications, such as Microsoft Access. But they have distinct differences.Database systems for the enterprise are highly scalable, meaning they can serve 10 or 20 users in a small workgroup or be upgraded to meet the needs of hundreds or thousands of networked users.Desktop databases typically cost several hundred dollars each, but enterprise database servers can cost thousands of dollars per server, depending on the number of licenses required or the options added to the core program.And unlike desktop databases, enterprise database programs are notoriously difficult to set up and manage. Even midsize enterprises generally require at least one database administrator to keep the programs up and running.But the job of an enterprise database also is considerably more daunting. And considering government agencies' needs to collect, store, transform and transmit huge amounts of information, databases are absolutely essential.Several classifications of databases are available. Of these, relational database management systems are far and away the most popular. But gaining momentum are two types more suited to the Web: post-relational object databases and XML databases.Unlike two-dimensional flat-file databases, in which all data is stored in a single file, relational databases store data in multiple flat files connected by shared data fields called keys. Users can query these files by using a language, usually structured query language, understood by all related databases. With the help of SQL, a standardized query language, relational databases can provide an array of information to users who may or may not understand how a database works.The market for relational database management systems is robust and growing steadily. Enterprises worldwide spent $8.8 billion on these systems in 2001 and will spend nearly $20 billion by 2006, according to International Data Corp., a Framingham, Mass., research firm. Interestingly, while the market for the software is growing at a healthy pace, the number of vendors is shrinking. Last year, only four database vendors accounted for more than 80 percent of the total amount of money spent on relational database management systems worldwide, according to Gartner Inc., a market research company in Stamford, Conn. Oracle Corp., maker of Oracle9i Database, accounted for 33.8 percent. IBM's DB2 Universal Database 7.2, had 30.1 percent. Microsoft's SQL Server 2000 SP2 came in with 14.9 percent. Sybase Inc.'s Adaptive Enterprise 12.5 came in fourth with a 3.9 percent market share but is still considered a market leader.All four companies have zeroed in on several keys to success in the database market: Enterprises will succeed or fail according to their ability to share information online. Virtually all relational databases support this standard language for querying database files. In fact, many users now use the terms "SQL database" and "relational database" interchangeably. Handling multiple transactions simultaneously is the bread and butter of relational database management systems. Online transaction processing and transaction logs are built into all the major relational databases. The technology isn't known for being user-friendly. Most systems require a skilled administrator who keeps the database software up and running and trains new users. The best relational database software contains advanced wizards that guide users through complex tasks, such as database and table creation or Web publishing. Graphical tools are also part of the arsenal. A good relational database provides safety checks whenever data is changed. Most write data to a transaction log as well as to the database itself. If a mistake occurs as a result of a series of database commands, the commands can be rolled back in order until the error is corrected. Software and hardware fault tolerance, as well as various levels of administrator-defined password protection, is also built into most software programs. A growing trend is built-in support for advanced data management features such as data warehousing, data analysis and data mining. Microsoft built limited support for data warehousing and online analytical processing into earlier versions of SQL Server and has enhanced them in its latest version. Oracle and IBM have followed suit. To meet demands for open systems software, proprietary database software makers have added support for open standards such as Java and extensible markup language.As good as it is, the technology has limits. Relational databases only understand limited and simple types of data, such as integers, dates and character strings. More complex data types, such as those used in e-commerce and Web applications, require new database architectures.According to the Aberdeen Group Inc., a Boston market research company, object-oriented databases are designed to support the complex logic and rapid deployment of Web applications, as well as Web tools such as XML and Web services."The new databases are 'low profile.' They can be embedded in the Web application, allowing low administrative costs and higher performance," an Aberdeen report said.InterSystems Corp.'s Cache 5, for example, is a popular post-relational object database that combines object, SQL and multidimensional technologies. Cache 5 includes relational capabilities but focuses on complex transactions. New features include a redesigned engine for greater performance and scalability, server pages for enhanced Web programming, real-time search capability for combined decision support and transaction processing, multilingual programming and enhanced XML object connections.Relational database systems are well-suited to manage data that fits into rows and columns, but they fail when called on to manage rich data such as audio, video, nested data structures or complex documents. All are characteristic of Web content.The XML standard is an open standard for storing, publishing and exchanging any kind of information. It lets business information be made independent from proprietary data formats and to remain readable forever.Some industry insiders are calling XML the most significant change in computing since the invention of relational databases and SQL.As a result, many vendors are jumping onto the XML bandwagon by building special XML extensions into their core products. This move is a step in the right direction, but will result in products that will never be as cost-effective and robust as native XML databases, according to Software AG and other XML developers.

What are they? Enterprise database management systems serve up to thousands of networked users. They run on single servers or multiple servers organized in clusters. Most can run on a variety of operating systems.

What's established? Relational databases are the most widely used. They can handle immense amounts of data and easily be queried through the use of Structured Query Language, or SQL. Most support advanced data management features and are Web-friendly.

What's new? Post-relational databases are object-oriented and go well beyond the limits of traditional relational databases. They are suited for managing enterprise e-business requirements. XML is an open standard for storing, exchanging and publishing any kind of information; XML databases could be the future of database technology.

Must-know info? The ability to handle rich data, including audio, video and multimedia, will be a requirement of all database systems before long. Most relational database vendors now provide XML extensions to their core systems, and it won't be long before more native XML database programs come to market.























Internet use.

SQL.

Transaction processing.

Manageability.

Data security.

Advanced data management.

Open source.



















J.B. Miles of Pahoa, Hawaii, writes about communications and computers. E-mail him at jbmiles@hawaii.rr.com.

NEXT STORY: Commerce: IT heavyweight

X
This website uses cookies to enhance user experience and to analyze performance and traffic on our website. We also share information about your use of our site with our social media, advertising and analytics partners. Learn More / Do Not Sell My Personal Information
Accept Cookies
X
Cookie Preferences Cookie List

Do Not Sell My Personal Information

When you visit our website, we store cookies on your browser to collect information. The information collected might relate to you, your preferences or your device, and is mostly used to make the site work as you expect it to and to provide a more personalized web experience. However, you can choose not to allow certain types of cookies, which may impact your experience of the site and the services we are able to offer. Click on the different category headings to find out more and change our default settings according to your preference. You cannot opt-out of our First Party Strictly Necessary Cookies as they are deployed in order to ensure the proper functioning of our website (such as prompting the cookie banner and remembering your settings, to log into your account, to redirect you when you log out, etc.). For more information about the First and Third Party Cookies used please follow this link.

Allow All Cookies

Manage Consent Preferences

Strictly Necessary Cookies - Always Active

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data, Targeting & Social Media Cookies

Under the California Consumer Privacy Act, you have the right to opt-out of the sale of your personal information to third parties. These cookies collect information for analytics and to personalize your experience with targeted ads. You may exercise your right to opt out of the sale of personal information by using this toggle switch. If you opt out we will not be able to offer you personalised ads and will not hand over your personal information to any third parties. Additionally, you may contact our legal department for further clarification about your rights as a California consumer by using this Exercise My Rights link

If you have enabled privacy controls on your browser (such as a plugin), we have to take that as a valid request to opt-out. Therefore we would not be able to track your activity through the web. This may affect our ability to personalize ads according to your preferences.

Targeting cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Social media cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.

If you want to opt out of all of our lead reports and lists, please submit a privacy request at our Do Not Sell page.

Save Settings
Cookie Preferences Cookie List

Cookie List

A cookie is a small piece of data (text file) that a website – when visited by a user – asks your browser to store on your device in order to remember information about you, such as your language preference or login information. Those cookies are set by us and called first-party cookies. We also use third-party cookies – which are cookies from a domain different than the domain of the website you are visiting – for our advertising and marketing efforts. More specifically, we use cookies and other tracking technologies for the following purposes:

Strictly Necessary Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Functional Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Performance Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Social Media Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Targeting Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.