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
 

 creating a data warehouse


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

creating a data warehouse  will only focus on creating the DATA diskgroup. In the simple RAC environment in Figure 1 each disk array has 16 physical disks. From these 16 disks, eight RAID 1 groups will be created (see Figure 2). Once the RAID groups have been established the ASM diskgroup DATA can be created. The ASM disk group will contain the eight RAID 1 pairs. When a tablespace is created ASM will allocate space in the diskgroup in 1MB chunks or allocation units in a round robin fashion. ASM starts each space allocation with a

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 » creating a data warehouse

The Data Warehouse Institute (TDWI) Conference in San Diego: The Agile Approach to Business Intelligence (BI)


Next month a TDWI World Conference will be taking place in San Diego, California. What’s so special about this conference anyway? The answer is simple:  the general topic is going to be “Creating an Agile BI Environment”. Progressively in the last four or five years, the agile software development methodology has been jumping from the software development area to the data warehouse

creating a data warehouse  (“ The Secrets of Creating an Agile, Adaptable BI Environment ”) and Ken Collier (“ Katabatic Winds of Business Intelligence ”), and there will be a promising set of training sessions given by Ralph Huges, an expert in adapting software engineering practices into the principles of the Agile methodology, and author of the book “ Agile Data Warehousing ”. On the same topic of Agile methodology, Len Silverston and Claudia Imhoff, both recognized experts in data warehousing and data management Read More

Data, Data Everywhere: A Special Report on Managing Information


The quantity of information in the world is soaring. Merely keeping up with, and storing new information is difficult enough. Analyzing it, to spot patterns and extract useful information, is harder still. Even so, this data deluge has great potential for good—as long as consumers, companies, and governments make the right choices about when to restrict the flow of data, and when to encourage it. Find out more.

creating a data warehouse  But they are also creating a host of new problems. Despite the abundance of tools to capture, process and share all this information—sensors, computers, mobile phones and the like—it already exceeds the available storage space (see chart 1). Moreover, ensuring data security and protecting privacy is becoming harder as the information multiplies and is shared ever more widely around the world. Alex Szalay, an astrophysicist at Johns Hopkins University, notes that the proliferation of data is making Read More

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.

creating a data warehouse  the migration process, thus creating a further audit validation. For example, you may map your in-patient data in an automated chart application to hospital admissions data that is captured by a financial system. Is this overkill? That entirely depends on your business user community and the extent to which you want to guarantee trusted data. Perform a Data Migration Assessment Effective planning will allow you to mitigate the risks associated with your project. If you have done the work of scoping the Read More

Poor Data Quality Means A Waste of Money


Data quality sounds like a motherhood and apple pie issue, of course we want our data to be right. However, very few enterprises get serious about it. Maybe that's because the cost of data quality is hidden. That cost can be huge.

creating a data warehouse  data quality problem is creating business problems, it cannot be fixed. In most companies, if a cost is not associated with the problem, it will never be given a priority and will continue forever. Therefore, the first step in addressing a data quality problem is to identify problems, the resulting impacts on the business and the cost of those impacts. This calls for both a broad picture and detailed analysis of specific issues. Management will need specific evidence of customer X being short shipped, Read More

PeopleSoft: No More a Humble Kid From a Rough Neighborhood?


PeopleSoft has been on a quest to dramatically improve its customer service & support by weeding out its 3rd-party consulting partners. PeopleSoft also has a new platform, a new set of products and a new surprising attitude of lambasting competition. Further, its financial results for the second quarter ended June 30, 2000 are upbeat.

creating a data warehouse  without doubt, lies in creating marketing awareness, promoting its new image, products, and the Web architecture as well as in crisp sales execution. While PeopleSoft has more than tripled its marketing budgets and is on the quest to beef up and focus its sales organization, a poor market acceptance of PeopleSoft 8 could be very detrimental to the company's future. We are afraid that betting mainly on enterprise performance management (EPM) analytics and new product architecture, on top of its Read More

Creating a Business from a Project


Many software services companies are not able to turn their individual project successes into a line of business that brings in additional revenue streams. At the root of this is the simplistic assumption that "if you build, they will come."

creating a data warehouse  taken half-hearted steps to creating a new practice around the new technology space, and asking the practice team members to put together some marketing collateral for showcasing to the market. The practice is inevitably comprised of one or two members drawn from the project team who have shown interest in doing presales kind of work but who lack any sales or presales background. Charged with the responsibility of creating marketing collateral, the practice swings between two extremes. Some go Read More

A Roadmap to Data Migration Success


Many large business initiatives and information technology (IT) projects depend upon the successful migration of data—from a legacy source, or multiple sources, to a new target database. Effective planning and scoping can help you address the associated challenges and minimize risk for errors. This paper provides insights into what issues are unique to data migration projects and to offer advice on how to best approach them.

creating a data warehouse  Roadmap to Data Migration Success Many large business initiatives and information technology (IT) projects depend upon the successful migration of data—from a legacy source, or multiple sources, to a new target database. Effective planning and scoping can help you address the associated challenges and minimize risk for errors. This paper provides insights into what issues are unique to data migration projects and to offer advice on how to best approach them. Read More

A Very Helpful Tool When You’re Choosing a New Software Solution


If you've ever been involved in selecting a business software solution, you know how tricky it can be. Today’s software systems are quite complex, and it can be very difficult to tell which vendor has the solution best suited for the special needs and business processes of your organization. One way to help avoid making a bad choice is to have a complete list of software functions to refer to.Let

creating a data warehouse  each vendor supports them. Creating this prioritized list of functional requirements and submitting it to vendors would not only help make sure that no functionalities important to your organization are forgotten or overlooked, it would also help you eliminate those vendors who don't support, or only poorly support, the functionalities your organization requires. You would be taking a giant step toward making sure you don't end up with a software system that isn't designed to do what you want it to. Read More

Baan Seeking A New Foster Home -- A Déjà vu Or Not Quite? Part Three: Market Impact and User Recommendations


Baan's focus on discrete manufacturing has not been a close fit with Invensys' plant automation products that have been geared mostly to process industries. To that end, Invensys has had a nightmarish job of trying to rationalize Baan and its process ERP counterparts, Protean and PRISM, development - strategy abandonment has been a catchphrase of late. Thus, while the savvy buyer will obtain much improved technology and large customer base in need for new products, the overriding problem has been the lingering negative sentiment around the company, as viability of the vendor is of utmost importance in the enterprise applications space.

creating a data warehouse  satisfy all their needs, creating functional connections between front office, ERP and plant automation applications was a colossal task. Baan's service and support viability was also uncertain in the interim owing to the exodus of Baan staff and questionable Invensys' core competency in extended ERP applications. The need for cross training of the sales force in functionally disparate applications should not be neglected either. Also, it turned out that there might have been a cultural gap between many Read More

Linked Enterprise Data: Data at the heart of the company


The data silos of today's business information systems (IS) applications, and the pressure from the current economic climate, globalization, and the Internet make it critical for companies to learn how to manage and extract value from their data. Linked enterprise data (LED) combines the benefits of business intelligence (BI), master data management (MDM), service-oriented architecture (SOA), and search engines to create links among existing data, break down data walls, provide an open, secure, and long-term technological environment, and reduce complexity—read this white paper to find out how.

creating a data warehouse  data silo,business information systems,linked enterprise data,LED,business intelligence,BI,master data management,MDM,service-oriented architecture,SOA,search engines,Antidot,Antidot white paper,semantic web Read More

Top 10 Reasons Why a Metals Company Should Move to a Packaged ERP Software Solution Today


Most metals companies are recognizing that it’s time to consider replacing their aging in-house developed information systems with a commercial enterprise resource planning (ERP) solution. There are many reasons why these companies should make the move to an industry-specific solution—the first being that the quality of their systems can be the limiting factor for growth in today’s competitive markets.

creating a data warehouse  10 Reasons Why a Metals Company Should Move to a Packaged ERP Software Solution Today Most metals companies are recognizing that it’s time to consider replacing their aging in-house developed information systems with a commercial enterprise resource planning (ERP) solution. There are many reasons why these companies should make the move to an industry-specific solution—the first being that the quality of their systems can be the limiting factor for growth in today’s competitive markets. Read More

Move from a "Cost Center" to a "Game Changer"


While the role of IT in product development and sales has increased tremendously, a disconnect remains between the IT and business sides of an organization. Some organizations also incorrectly believe that IT spend does not add direct value to the business and hence is not justified. The onus is on IT to mend this perception by delivering tangible business value. Learn how.

creating a data warehouse  from a Cost Center to a Game Changer While the role of IT in product development and sales has increased tremendously, a disconnect remains between the IT and business sides of an organization. Some organizations also incorrectly believe that IT spend does not add direct value to the business and hence is not justified. The onus is on IT to mend this perception by delivering tangible business value. Learn how. Read More

Data Security Is Less Expensive than Your Next Liability Lawsuit: Best Practices in Application Data Security


Insecure data. Heavy fines due to non-compliance. Loss of customers and reputation. It adds up to a nightmare scenario that businesses want to avoid at all costs. However, this nightmare is preventable: knowledge base-driven data security solutions can be critical tools for enterprises wanting to secure not only their data—but also their status in the marketplace.

creating a data warehouse  Security Is Less Expensive than Your Next Liability Lawsuit: Best Practices in Application Data Security Insecure data. Heavy fines due to non-compliance. Loss of customers and reputation. It adds up to a nightmare scenario that businesses want to avoid at all costs. However, this nightmare is preventable: knowledge base-driven data security solutions can be critical tools for enterprises wanting to secure not only their data—but also their status in the marketplace. Read More

Achieving a Successful Data Migration


The data migration phase can consume up to 40 percent of the budget for an application implementation or upgrade. Without separate metrics for migration, data migration problems can lead an organization to judge the entire project a failure, with the conclusion that the new package or upgrade is faulty--when in fact, the problem lies in the data migration process.

creating a data warehouse  meeting data quality requirements, creating appropriate project methodologies, and developing general migration expertise. Use Case Scenario Move Off The Mainframe Need: Increase competitiveness by replacing a limited mainframe-based application with a comprehensive client/server application. Approach: Adopt a data integration platform with native mainframe access to streamline data migration. Benefit: Increase performance in accessing the mainframe ten-fold, halve the numbers of resources required to Read More