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 file

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 file

Oracle Announces a Database Fire Sale


On December 16, Oracle Corporation announced lower software and support prices for the Oracle8i database. Specifically, the price of Oracle8i Standard Edition was lowered 40% from $25 per power unit to $15 per power unit, while Oracle8i Enterprise Edition was cut 50% from $200 per power unit to $100 per power unit.

database file  SQL Server , the competing database product from Microsoft Corporation. Oracle is aiming at the midrange to workgroup market with this move, hoping to take market share away from Microsoft. These changes do not affect Oracle''s named-user pricing model according to Ellison, but support pricing has been standardized at 7 percent of the software cost for continuous coverage. In addition, Ellison is hoping that all of Oracle''s sales can be booked via the Internet within the next year, which would serve to Read More

Why Database-agnostic Enterprise Applications Are on the Way Out


Middleware agnosticism is the wave of the future, and the database platform is becoming part of the application. It has therefore become increasingly important that vendors of enterprise applications offer a wider range of middleware choices to organizations.

database file  be accessed within the database itself rather than by pulling a large, unwieldy file out of the table in which it resides. Apart from enterprise search, database-specific applications can more easily deliver business intelligence (BI) and data-mining functions. BI tools such as online business analytical processing (OLAP) cubes can be built right into the application at the database tier, and this is where this type of functionality should naturally reside—as close to the actual data as possible. 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 file  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 round robin approach to connect to application servers. The client has a configuration file that contains a number of IP address/port combinations that define the locations of the application servers that the particular client is eligible to connect to. The client picks a 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 file  asynchronous I/O) bypassing the database buffer cache. A CTAS will always use direct path load but an IAS statement will not. In order to achieve direct path load with an IAS you must add the APPEND hint to the command. Insert /*+ APPEND */ into Sales partition(p2) Select * From ext_tab_for_sales_data; Direct path loads can also run in parallel. You can set the parallel degree for a direct path load either by adding the PARALLEL hint to the CTAS or IAS statement or by setting the PARALLEL clause on both Read More

SAP's Dr. Peter Barth on Client/Server and Database Issues with SAP R/3


To address questions for a TEC customer, we interviewed Dr. Peter Barth, Technology Marketing Manager for SAP AG in Walldorf, Germany. The conversation covered issues in the areas of client/server architecture and database management used by the SAP R/3 Enterprise Resource Planning suite of products.

database file  Barth on Client/Server and Database Issues with SAP R/3 Event Summary To answer questions for a Technology Evaluation Center customer, a large utility in the northeastern United States, TEC interviewed Dr. Peter Barth, Technology Marketing Manager for SAP AG in Walldorf, Germany. Dr. Barth works for Corporate Technology Marketing, where his main focus is basis technology, the Business Framework and new technologies. After graduating from the Universities of Nancy in France and Saarbruecken, Dr. Barth Read More

NCR's Teradata Database Meets Windows 2000. A Match Made in Redmond?


NCR Corporation announced it will support Microsoft Windows 2000 across its entire offering of products. In addition, NCR will present a full suite of consulting and support services to help businesses migrate to the Windows 2000 environment. The question is whether the power of Windows can keep up with Teradata.

database file  s Teradata Database Meets Windows 2000. A Match Made in Redmond? Event Summary SAN FRANCISCO - NCR corporation announced it will support Microsoft Windows 2000 across its entire offering of products, including its powerful Teradata database and many retail products. In addition, NCR will present a full suite of consulting and support services to help businesses migrate to the Windows 2000 environment. With NCR''s Teradata database, companies that prefer to employ a Windows 2000-based infrastructure Read More

Lowering Your IT Costs with Oracle Database 11g Release 2


New versions of database software and operating systems (OSs) come out regularly. In the past, upgrading the database and OS for individual environments has been very expensive and a never-ending job—by the time all the business systems are upgraded, it’s time to start again. This white paper discusses Oracle Database 11g Release 2, which reduces the cost and risk associated with making these changes.

database file  IT Costs with Oracle Database 11g Release 2 New versions of database software and operating systems (OSs) come out regularly. In the past, upgrading the database and OS for individual environments has been very expensive and a never-ending job—by the time all the business systems are upgraded, it’s time to start again. This white paper discusses Oracle Database 11g Release 2, which reduces the cost and risk associated with making these changes. Read More

Smart, Affordable Protection for Your SQL Server


Learn how to protect your sql server and your business in the white paper how to protect your sql server database.

database file  How quickly will your database and your business recover and resume their normal functions? At the end of the day, that depends on whether or not you have a system that keeps downtime to a minimum and facilitates fast data recovery. Like an iSCSI storage area network (SAN) solution with integrated SQL server protection features. That used to be an expensive proposition, but no longer. Today, you can have database snapshots, cloning, remote replication, and quick restore and recovery—at an affordable Read More

Viewpoint Construction Software


Learn how Viewpoint Construction Software used Clientele to combine its different databases into one common customer database that is customized to fit the unique needs of the company.

database file  into one common customer database that is customized to fit the unique needs of the company. Read More

Intrusion Detection and Security Auditing In Oracle


Database intrusion detection and security auditing continues to grow in importance. Thus, monitoring your database applications is a critical component of achieving a strong defense-in-depth around your sensitive data. However, to be efficient and effective, you must use the right combination of tools. Monitoring should never replace other layers in the security stack—it should complement the existing pieces instead.

database file  Security Auditing In Oracle Database intrusion detection and security auditing continues to grow in importance. Thus, monitoring your database applications is a critical component of achieving a strong defense-in-depth around your sensitive data. However, to be efficient and effective, you must use the right combination of tools. Monitoring should never replace other layers in the security stack—it should complement the existing pieces instead. Read More

SAP HANA-One Technology to Watch in 2012 (and Beyond)


Did you know that SAP HANA is much more than a high-speed analytic appliance? TEC principal analyst P.J. Jakovljevic reveals how HANA is a universal database that will enable companies to analyze large volumes of operational and transactional information in real time, from virtually any data source, and that will eventually deliver an entirely new class of applications that will change the way people think, work, plan, and operate.

database file  repository”, i.e., a general-purpose database of the future? For that reason, I initially confused HANA with SAP’s offerings that were touted by Hasso Plattner (SAP’s renowned co-founder and the current chairman of the supervisory board of SAP AG) a few years back. I am talking here about SAP BusinessObjects (BO) Explorer and SAP Business Warehouse (BW) Accelerator (see the related blog post series from 2009 ). Well, now I know that SAP BO Explorer is a tool for creating InfoCubes , and for further Read More

Sarbanes-Oxley Database Compliance


Under the US Sarbanes-Oxley Act, companies must maintain proven auditing practices and assure integrity and timeliness of data. Thus, companies must secure systems that monitor corporate data. To effectively accomplish this, you are best off investing in a solution that can comprehensively cover your reporting and auditing needs while providing you the capacity to respond swiftly should any incidents occur.

database file  Oxley Database Compliance Under the US Sarbanes-Oxley Act, companies must maintain proven auditing practices and assure integrity and timeliness of data. Thus, companies must secure systems that monitor corporate data. To effectively accomplish this, you are best off investing in a solution that can comprehensively cover your reporting and auditing needs while providing you the capacity to respond swiftly should any incidents occur. Read More

The CyberAngel: Laptop Recovery and File Encryption All-in-One


Relevant Technologies took the CyberAngel into our labs to test it for our acceptability rating. It worked as advertised, and had more features than expected.

database file  CyberAngel: Laptop Recovery and File Encryption All-in-One Background According to the Computer Security Institute''s 2003 Computer Crime and Security Survey, theft of private or proprietary information created the greatest financial losses for the survey respondents. If you are a medical institution, government agency, or financial institution, information theft can result in violation of patient privacy regulations, loss of customer credit card numbers, unauthorized financial transactions, or Read More

Oracle Database Security: Preventing Enterprise Data Leaks at the Source


Addressing information protection and control (IPC) is a complex challenge. Enterprises must secure their databases to protect sensitive information and comply with policy regulations. Learn more about threats to business information, the impact of government regulations on data protection, and how database security best practices can prevent sensitive customer data or company information from being distributed.

database file  Database Security: Preventing Enterprise Data Leaks at the Source Addressing information protection and control (IPC) is a complex challenge. Enterprises must secure their databases to protect sensitive information and comply with policy regulations. Learn more about threats to business information, the impact of government regulations on data protection, and how database security best practices can prevent sensitive customer data or company information from being distributed. Read More

Oracle Sets Date for Database In-Memory Release


The Oracle Database In-Memory is Oracle’s answer to the in-memory database race that has been heating up over the last couple of years. Oracle Database In-Memory is scheduled for general availability in July and will run on all hardware supported by Oracle Database 12c.

database file  Sets Date for Database In-Memory Release Oracle CEO Larry Ellison took center stage at a special event to announce the planned release of the Oracle Database In-Memory . The Oracle Database In-Memory is Oracle’s answer to the in-memory database race that has been heating up over the last couple of years. Oracle originally announced the in-memory solution during last year’s Oracle OpenWorld conference. The Oracle Database In-Memory demonstrated from 100x to more than 1000x speedup for enterprise Read More