X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 database administrators


Exploring the Database Forest
This article for information technology (IT) leaders and database administrators portrays some of the most interesting trends that are shaking up the

database administrators  technology (IT) leaders and database administrators portrays some of the most interesting trends that are shaking up the information management industry, along with the noticeable effects that these developments are having on IT.

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Warehouse Management Systems (WMS)

A warehouse management system (WMS) should provide database and user-level tools in order for a company to optimize its storage facilities while at the same time providing user level task direction and activity support. The WMS should enable warehouse operators to optimize pick, put-away, and replenishment functions by employing powerful system logic to select the best locations and sequences. 

Evaluate Now

Documents related to » database administrators

How to Protect Your SQL Server Database


SQL Server deployments can be large and complex. However, Auto-Snapshot Manager simplifies data management tasks and offers a comprehensive approach to SQL Server protection by providing both local and remote database protection, allowing for quick data recovery in case of data loss or site failure. Find out more about how Auto-Snapshot Manager can provide you with the safety net you need for effective disaster recovery.

database administrators  corrupted state of the database to enable more detailed analysis of the cause of the corruption. REMOTE REPLICATION AND FAILOVER Data replication is becoming a more common practice to respond to network failures, power outages, and complete site failures caused by natural or human-created disasters. PS Series arrays include remote site replication as a built- in feature. Regardless of distance or network bandwidth, remote replication sites can be setup to maintain off-site copies of SQL Server databases. Read More

Syncsort Sigma Manages Database Aggregates


Syncsort, a software vendor with years of experience in the sorting of data, has released a new product called Sigma™, which is designed to produce aggregated data within data warehouses to improve response time and reduce database load. The importance of aggregation in a data warehouse cannot be underestimated.

database administrators  at Syncsort. Sigma helps database administrators manage the explosive growth of data in their companies and meet the demands by their users for faster query processing of click-stream data from web sites, 24/7 business operations and electronic commerce initiatives. Sigma frees administrators to concentrate on selecting those aggregates that will optimize query performance. Market Impact Data warehouse administrators have long been vexed by the difficulty of creating aggregations of data. (An aggregate Read More

Best Practices for a Data Warehouse on Oracle Database 11g


Companies are recognizing the value of an enterprise data warehouse (EDW) that provides a single 360-degree view of the business. But to ensure that your EDW performs and scales well, you need to get three things right: the hardware configuration, the data model, and the data loading process. Learn how designing these three things correctly can help you scale your EDW without constantly tuning or tweaking the system.

database administrators  Data Warehouse on Oracle Database 11g Best Practices for a Data Warehouse on Oracle Database 11g If you receive errors when attempting to view this white paper, please install the latest version of Adobe Reader. Oracle has been helping customers like you manage your business systems and information with reliable, secure, and integrated technologies. Source : Oracle Resources Related to Data Warehouse : Data Warehouse (Wikipedia) Best Practices for a Data Warehouse on Oracle Database 11g Data Read More

PeopleSoft on Client/Server and Database Issues


To address questions for a TEC customer, we interviewed PeopleSoft's Michael Daniels. The conversation covered issues in the areas of client/server architecture and database management as they relate to the PeopleSoft Enterprise Resource Planning suite of products.

database administrators  on Client/Server and Database Issues Event Summary To answer questions for a Technology Evaluation Center customer, a large utility in the northeastern United States, TEC interviewed Michael Daniels of PeopleSoft on how the PeopleSoft ERP product performs in the areas of client/server architecture and database management. Question: Is PeopleSoft designed as a fault tolerant environment? Exactly how is this accomplished? Is the failover manual or automatic? Mr. Daniels: PeopleSoft clients use a Read More

Business Intelligence and Database Management Services


Lister's BI team helps organizations to structure their data and extract actionable information from it. The team is comprised of experts who perform end-to-end deployment of BI solutions over the intranet, the extranet, or the World Wide Web. The BI team has over ten years of experience with various database systems such as Oracle, SQL Server, and DB2, to name a few. Backed by several years of reporting experience, the team has built up expertise in industry tools like Business Objects, Oracle Business Intelligence, Crystal Reports, and SQL Server Reporting Services. It has also worked with open-source BI solutions like JasperReports, and aims to fulfill the exacting requirements of any organization that approaches it with a BI project. Lister offers end-to-end BI solutions that can bring a good return on investment (ROI). Among the BI services Lister offers are remote database administration (DBA); data quality services; extract, transform, and load (ETL); database design and management; online analytical processing (OLAP) services; reporting; analysis; and dashboards.  

database administrators  Intelligence and Database Management Services Lister's BI team helps organizations to structure their data and extract actionable information from it. The team is comprised of experts who perform end-to-end deployment of BI solutions over the intranet, the extranet, or the World Wide Web. The BI team has over ten years of experience with various database systems such as Oracle, SQL Server, and DB2, to name a few. Backed by several years of reporting experience, the team has built up expertise in Read More

How to Overcome SQL Server Maintenance Challenges


For SQL server administrators, it is very important to analyze SQL server performance and storage structure regularly, and get information that will help to manage SQL server capacity, performance and storage issues, as well as its forecast future requirements. Administrators should be completely aware of the entire SQL server environment and the status of different performance and storage parameters. Download the white paper.

database administrators  to Overcome SQL Server Maintenance Challenges For SQL server administrators, it is very important to analyze SQL server performance and storage structure regularly, and get information that will help to manage SQL server capacity, performance and storage issues, as well as its forecast future requirements. Administrators should be completely aware of the entire SQL server environment and the status of different performance and storage parameters. Download the white paper. Read More

About WebFirst


WebFirst enables customers to dynamically access the CustomerFirst database utilizing standard web browsers. Through a secure portal on a corporate web site, customers can perform a variety of functions related to incident reporting, as well as customer and contact information.

database administrators  dynamically access the CustomerFirst database utilizing standard web browsers. Through a secure portal on a corporate web site, customers can perform a variety of functions related to incident reporting, as well as customer and contact information. Read More

MODX Revolution


 MODX Revolution can scale to much larger, multi-server environments, including customizable caching, multiple database support (MySQL, Microsoft SQL Server). In addition MODX Revolution natively supports multiple websites, secure configurations with most files stored outside of web root. While both Evo and Revo support Resources (web pages) and Weblinks (redirecting links to other pages on the internet), MODX Revolution also includes Static Resources (static files on the filesystem), Symlinks (links to other pages that can maintain their position in dynamic menus), the ability to create custom resources and Media Sources which can store files literally anywhere that is accessible via an API (like Amazon S3).

database administrators  including customizable caching, multiple database support (MySQL, Microsoft SQL Server). In addition MODX Revolution natively supports multiple websites, secure configurations with most files stored outside of web root. While both Evo and Revo support Resources (web pages) and Weblinks (redirecting links to other pages on the internet), MODX Revolution also includes Static Resources (static files on the filesystem), Symlinks (links to other pages that can maintain their position in dynamic menus), the Read More

The Benefits of 3-way Auditing


Whatever your reasons for needing to capture a complete audit trail for all database activity, you want to make sure your system allows you to support three accepted approaches. This three-way auditing ability can provide auditing for all activity in your database, including monitoring, reporting, and alerting on all critical data activity across your company. Learn more about these approaches, and their many benefits.

database administrators  audit trail for all database activity, you want to make sure your system allows you to support three accepted approaches. This three-way auditing ability can provide auditing for all activity in your database, including monitoring, reporting, and alerting on all critical data activity across your company. Learn more about these approaches, and their many benefits. Read More

Remote Management and the Information Infrastructure


Consolidating various data center devices running on multiple platforms provides network administrators with a more efficient information infrastructure. After all, fewer moving parts results in better overall efficiency and reliability. Use a centralized console to manage infrastructure, and combine reliability and remote connectivity while reducing costs—without compromising application and technology service levels.

database administrators  Management and the Information Infrastructure Consolidating various data center devices running on multiple platforms provides network administrators with a more efficient information infrastructure. After all, fewer moving parts results in better overall efficiency and reliability. Use a centralized console to manage infrastructure, and combine reliability and remote connectivity while reducing costs—without compromising application and technology service levels. Read More

Open, Manage, and Accelerate SSL Encrypted Applications


Although secure sockets layer (SSL) is a ubiquitous enabler of e-commerce and outsourcing, it creates a special challenge for network administrators and security professionals because its encryption is known to decelerate data. In order to regain control over application delivery—when everything business-related is encrypted—organizations need to look toward SSL-aware solutions that can help decipher and accelerate data.

database administrators  Manage, and Accelerate SSL Encrypted Applications Although secure sockets layer (SSL) is a ubiquitous enabler of e-commerce and outsourcing, it creates a special challenge for network administrators and security professionals because its encryption is known to decelerate data. In order to regain control over application delivery—when everything business-related is encrypted—organizations need to look toward SSL-aware solutions that can help decipher and accelerate data. Read More

Oracle Further Orchestrates Its SOA Forays Part Two: Strategy


Oracle's vision of a complete collaborative e-Business solution requires a database strategy, an application server strategy, and an e-business strategy. Will users buy into this vision?

database administrators  Forays Part Two: Strategy Database Strategy In light of Oracle Corporation 's (NASDAQ: ORCL) recent acquisition of PeopleSoft and its growing appetite for the competition, its easy to see how one might underestimate Oracle's internally-developed, product strategy. However, this California-based (US) company has heeded the calls of its customers and the market by beginning a product strategy that focuses on open and flexible business processes. Ease of integration, the consolidation of databases, data Read More

IBM Announces the Release of DB2 Universal Database Version 7


IBM (NYSE: IBM) has announced the release of DB2 Universal Database Version 7, with a new pricing structure for application service providers (ASPs), support for customer relationship management (CRM), and an incubator program for e-business applications to help emerging companies get up and running on the Web.

database administrators  a program to retrain database administrators familiar with competing products. The presence of an additional 500 software engineers and sales specialists (it should be noted that IBM doesn't state whether they will all be dedicated to this product), in addition to IBM's well-known abilities in the consulting arena, should also ease the customer's concerns about migration or the initial build of their application. Read More

Oracle Loses Again


SAP AG has chosen SQL Server 7.0 as its strategic database for the Windows platform. The companies also will cooperate to make the Windows 2000 OS available as a platform choice for customers wishing to implement mySAP.com solutions. On the heels of the agreement to use IBM DB2 as a preferred backend database, Oracle continues to lose market share as a database in the ERP arena.

database administrators  7.0 as its strategic database for the Windows platform. The companies also will cooperate to make the Windows 2000 OS available as a platform choice for customers wishing to implement mySAP.com solutions. Microsoft also announced that it is the first mySAP.com customer to use Windows 2000 for its product implementation of SAP inter-enterprise software solutions. mySAP.com is an open collaborative business environment of personalized solutions on demand that lets organizations of all sizes fully engage Read More