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
 

 create a database


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

create a database  Using a CTAS statement, create a non-partitioned table called tmp_sales that has the same column structure as Sales table Build any indexes that are on the Sales table on the tmp_sales table Gather optimizer statistics on the tmp_sales table Issue the exchange partition command Alter table Sales exchange partition p2 with table tmp_sales including indexes without validation; The exchange partition command in the final step above, swaps over the definitions of the named partition and the tmp_sales table,

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

HCIMS - Picture Archiving Communication System (PACS) RFI/RFP Template

Workstations, Workflow, Storage, Archive, Database, Image Acquisition, and Product Technology 

Evaluate Now

Documents related to » create a database

A Road Map to Data Migration Success


Many significant business initiatives and large IT projects depend upon a successful data migration. But when migrated data is transformed for new uses, project teams encounter some very specific management and technical challenges. Minimizing the risk of these tricky migrations requires effective planning and scoping. Read up on the issues unique to data migration projects, and find out how to best approach them.

create a database  or a requirement to create a single view of product within an organization. In cases where migrated data is transformed for new uses, your project team encounters some very specific management and technical challenges. For example, a team that has been writing extraction, transformation, and load (ETL) code for a data warehouse faces a new set of challenges when migrating data to a live, operational system. Although a 2% error rate may be acceptable for aggregate reporting, it is not acceptable for Read More

A New Era Dawns for Sybase


Sybase, Inc. has announced an agreement to acquire New Era of Networks (also known as NEON). After completion, Sybase will create a new e-Business division integrating NEON and other parts of its product suite. Within the last month, Sybase has announced record earnings and completed a three-year re-engineering effort to transform themselves from a database vendor to an e-Business infrastructure provider.

create a database  After completion, Sybase will create a new e-Business division integrating NEON and other parts of its product suite. Within the last month, Sybase has announced record earnings and completed a three-year re-engineering effort to transform themselves from a database vendor to a provider of e-business solutions. Denver, Colorado-based NEON offers a range of enterprise application integration products and services in the application-to-application (A2A) space. (It should be noted that TEC treats A2A as 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.

create a database  and data warehouses can create, manage and process data aggregates with speed, ease and accuracy with a new software product unveiled by Syncsort Incorporated. Called Sigma, the vendor states that the product combines a high-performance data aggregate engine with an intuitive graphical user interface. By simplifying aggregation creation, Sigma reduces the time it takes to define and maintain aggregates, saves computer resources when processing aggregates, and dramatically cuts response time for database Read More

Leveraging Technology to Maintain a Competitive Edge During Tough Economic Times--A Panel Discussion Analyzed Part Four: RFID Software Issues


Logically, radio frequency identification (RFID) deployment will be a far cry from a minor development project that can be completed in a few months or weeks. It will take months and years to assess how RFID will affect manufacturing and shipping operations and IT systems. It will take time to bring software up to a pilot stage, and after that, years of fine-tuning and IT system development will be needed to fully realize the gains in operational efficiency that the technology promises.

create a database  suppliers will have to create a database that contains information about what the item is, where it was made, and what its expiration date is. There is a more complex and costly write-and-read standard that lets companies add information to the tag. Retailers will need to figure out exactly what information they need, what format it should be in and how it should be shared, in addition to working together with their suppliers to solve these issues. Furthermore, it is not yet clear how companies will Read More

Leveraging Technology to Maintain a Competitive Edge During Tough Economic Times -- A Panel Discussion Analyzed Part Two: Business Process Modeling


Business processes must be enabled across the artificial boundaries of disparate applications that must work together to support these business processes. To that end, business process management (BPM) could assist in compliance issues, can reduce training requirements, and increase the overall efficiency of a business.

create a database  be to pay vendors, create invoices, book debits and credits, or schedule maintenance? However, with respect to more extrovert applications like SCM and CRM, it is important to be able to model the application to how an organization does business with trading partners, and not be constrained by the software. The need for SOA, Web services, and BPM has been boosted by these external processes, which are most often automated workflows that involve multiple companies and a diversity of existing enterprise Read More

The ROI of a New Learning Management System (LMS): How to Construct a Successful Business Case


In today’s fast-changing world, the learning management system (LMS) has become mission critical to organizations that are trying to keep employees up to date on everything from the latest technologies and regulatory requirements, to industry certifications, best practices plus job-specific and leadership skills. Download this white paper to learn how to construct the business case to justify the purchase of an LMS.

create a database  ROI of a New Learning Management System (LMS): How to Construct a Successful Business Case In today’s fast-changing world, the learning management system (LMS) has become mission critical to organizations that are trying to keep employees up to date on everything from the latest technologies and regulatory requirements, to industry certifications, best practices plus job-specific and leadership skills. Download this white paper to learn how to construct the business case to justify the purchase of an Read More

Pragmatist's Guide: Building a Business Case for a Formula-based ERP


If you're a process manufacturer taking a close look at the option of acquiring an enterprise resource planning (ERP) solution, you may be finding that you're faced with a bewildering array of options, technologies, and applications. What should you look for, and which business issues do you need to address to position your acquisition-and implementation-for maximum success? Download this report to find out.

create a database  s Guide: Building a Business Case for a Formula-based ERP If you're a process manufacturer taking a close look at the option of acquiring an enterprise resource planning (ERP) solution, you may be finding that you're faced with a bewildering array of options, technologies, and applications. What should you look for, and which business issues do you need to address to position your acquisition-and implementation-for maximum success? Download this report to find out. Read More

Configuration Guide: Managing Virtual Servers Using a Virtual Machine Manager and a Clustered File System


Virtual data centers must enable increased physical server use and central management of virtual machine infrastructure. A clustered file system, with a virtual machine manager (VMM), can add critical new management and migration capability to current virtual servers. Before installing and configuring VMM, find out the hardware and software required for migration and integration, and helpful “how-to” pointers.

create a database  Guide: Managing Virtual Servers Using a Virtual Machine Manager and a Clustered File System Virtual data centers must enable increased physical server use and central management of virtual machine infrastructure. A clustered file system, with a virtual machine manager (VMM), can add critical new management and migration capability to current virtual servers. Before installing and configuring VMM, find out the hardware and software required for migration and integration, and helpful Read More

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.

create a database  Announces a Database Fire Sale Event Summary REDWOOD SHORES, Calif., Dec. 16 /PRNewswire/ Today, Oracle Corp. 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. Every time we lower prices we sell more software, said Larry Ellison, Oracle Chairman and CEO. Just about Read More

Taking Innovation from a Buzzword to a Business Standard


Companies realize that innovation can mean the difference between effectively growing or transforming their business and falling behind. But for a company to thrive in today’s environment, innovation has to be seen as more than a clichéd talking point. It has to be a key part of the company’s core business processes. Download this interview with Eric Verniaut, SAP’s head of North America services, to find out how innovation has helped services delivery models to evolve.

create a database  Innovation from a Buzzword to a Business Standard Companies realize that innovation can mean the difference between effectively growing or transforming their business and falling behind. But for a company to thrive in today’s environment, innovation has to be seen as more than a clichéd talking point. It has to be a key part of the company’s core business processes. Download this interview with Eric Verniaut, SAP’s head of North America services, to find out how innovation has helped services Read More

E-Commerce Lesson: Success Gets a Yawn, Failure Takes a Beating


ERP giant SAP Aktiengesellschaft announced full details of its Internet strategy. Consumer electronics giant Best Buy announced 2Q earnings rise of 34 percent, but delays Internet launch.

create a database  Commerce Lesson: Success Gets a Yawn, Failure Takes a Beating Event Summary With the Internet quickly shaping up as the major battleground in the ERP arena, SAP's formal announcement might have been earthshaking. It takes an early lead among the ERP vendors and positions itself to meet growing challenges from such software component manufacturers as Ariba, Commerce One and Concur. However, neither the stock market nor news analysts seemed to care very much. Almost simultaneously, Best Buy announced second Read More

Business Agility for Communication Service Providers: A Few Simple Steps Are a Great Way to Start


In today’s market, customers have no patience for companies that let their size and complex product lines slow them down. The challenge for communication service providers (CSPs) is to leverage their size and complex service offerings to keep pace with competitors. Discover how a next-generation configuration solution can provide you with the tools and the service agility you need to meet and exceed customer expectations.

create a database  programmers or developers to create models by writing code and rules that could be interpreted by the configuration engine. IT involvement was imperative, which reduced a company's agility and increased costs by moving processes further away from the customer. Companies believed the development costs and loss of agility would be acceptable tradeoffs once the configurator was put into production. This was not always the case, however, and the delays frequently had a negative impact on customer Read More

A Tale of a Few Good SCM Players - Part 4


Part 1 of this blog post series followed the genesis of Manhattan Associates from its inception in 1990 throughout the mid-2000s. During this time, Manhattan Associates was the epitome of an impeccable supply chain management (SCM) software company in terms of market share, growth, profitability, and its product capabilities. Indeed, the company set the industry standard for the supply chain

create a database  Tale of a Few Good SCM Players - Part 4 Part 1 of this blog post series  followed the genesis of  Manhattan Associates  from its inception in 1990 throughout the mid-2000s. During this time, Manhattan Associates was the epitome of an impeccable  supply chain management (SCM)  software company in terms of market share, growth, profitability, and its product capabilities. Indeed, the company set the industry standard for the supply chain execution (SCE) space and was the envy of its competitors. But Read More