Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

RESOURCE PORTALS
View all Portals

WEB SEMINARS
Scheduled Events

RESEARCH VAULT
White Paper Library
Research Papers

CAREERZONE
View Job Listings
Post a job

Advertisement

INFORMATION CENTER
DM Review Home
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

GENERAL RESOURCES
Bookstore
Buyer's Guide
Glossary
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

DM REVIEW
About Us
Press Releases
Awards
Advertising/Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Ask the Experts Archive

Ask the Expert

Meet the Experts
Ask a Question (Names of individuals and companies will not be used.)
Question Archive
Ask the Experts Home

ARCHIVE OF QUESTIONS & ANSWERS FOR DATABASES
BACK TO THE LIST OF CATEGORIES


Read It! (Posted )


Read It! (Posted )

Please define data reconciliation and database reconciliation. I also need a definition of data synchronization.
Read It! (Posted )

What are the major risks of implementing an RDBMS in an enterprise? Are these risks present across all vendors or are the risks vendor-specific?
Read It! (Posted )

We about to establish a new IT section, using Oracle9i with a UNIX operating system. Do you think it is better to purchase two servers ? one for the database and the other for the Oracle application server and the user server with two processors; or would it be better to purchase one server with two processors and put the database, Oracle application server and the user application on the same server? We do not have a huge amount of data, but we want to add collaboration and the Oracle work flow and archiving system later in addition to HR, payroll, accounting, loan and other administrative applications.
Read It! (Posted )

We are in the planning stages of implementing a managed data warehouse. The current solution is an Oracle database which feeds Microsoft Access (MSA). Our finance department supports all current reporting and analysis using MSA. They are content with Microsoft Access. How do I explain to them that MSA is not the tool of choice for BI/performance management/analytics? They want to know "where the value is" in moving to a different tool set. What are some of the negatives associated with MSA?
Read It! (Posted )

I am looking for a best practice on how to archive data from a very large database (VLDB). Do you have any suggestions on where to start?
Read It! (Posted )

How can I upload Excel spreadsheet data into Oracle by using SQL*Loader? We now use Excel files and load data into two different tables and make a link between each row.
Read It! (Posted )

I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart dimensions and fact tables. They have created database views for this purpose. I would like to know if this is standard practice within other organizations. I would like to get other opinions and experiences on the matter because this is the first time I have seen such a standard.
Read It! (Posted )

What are the pros and cons of horizontal database partitioning and please focus on the scenario when the database is part of a package (e.g., Siebel) which contains meta data.
Read It! (Posted )

My question is in the realm of operational reporting. My client (a state government) does not want the expenses of an ODS or a data warehouse, but they want to be able to copy the production database, index a few fields to make the reports run faster and run reports on it. What tools are there to make copying the database easy? Are there any tools which can just apply the changes on a day-to-day basis instead of having to copy the complete database?
Read It! (Posted )

Is there a standard that can be used as a guideline for sizing and capacity? I?ve been reading many sources of information regarding database and cube sizing but I am not clear on exactly how this is calculated and measured in regards to server and database resources.
Read It! (Posted )

Do you have any information relating to very large, multiterabyte data warehouses and ODBC performance vs. other access methods to retrieve large queries? I don't think it is particularly efficient, but I need facts, studies, etc. to validate the claim. We are using Oracle 8i on Alpha's running Tru64.
Read It! (Posted )

We are planning to implement a data warehouse. What are the advantages/ disadvantages of using Oracle database over Teradata?
Read It! (Posted )

We are (were) primarily a mainframe shop that has, in the past couple of years, moved first to Oracle and most recently to SQL Server databases. We have begun to develop more and more applications on the PC and are looking for the reasons to create the position of DBA. We currently have people spending some of their time doing some of the DBA functions but don't really understand all the advantages or functions of a full-time DBA. Can you enumerate some of the advantages?
Read It! (Posted )

Assuming that the applications and databases are on separate machines, what is the current thinking on where the data warehouse database should reside? Should it be on a separate machine from the transaction systems databases, on the same large machine but in a different domain, or in the same domain?
Read It! (Posted )

We are building a data warehouse on AS/400. We plan to build this on a separate logical partition (LPAR2) outside of the operational environment (LPAR1). We are facing complexities in copying and synchronizing files and programs between the two partitions. Do you recommend this approach of separating the data warehouse environment from the operational environment?
Read It! (Posted )

How many databases have been sold in the past year?
Read It! (Posted )

What are centralized databases? What are the differences between centralized and distributed databases?
Read It! (Posted )

What are the changes required in order to convert a star schema warehouse to a snowflake schema warehouse?
Read It! (Posted )

Most companies seem to be going from the AS/400 to NT. Is this simply a cost issue?
Read It! (Posted )

Is there an OLAP tool available that has direct connectivity to an Oracle database?
Read It! (Posted )

Where can we find information about the types of tests to apply in the databases of the data warehouse?
Read It! (Posted )

Is there a rule concerning aggregates tables mirroring the fact tables?
Read It! (Posted )

Are there any cases where the dimensional table is larger than the fact table?
Read It! (Posted )

I want to begin collecting e-mail addresses for newsletters, but my DBA is resisting an e-mail address-only database. How do organizations handle these data management issues?
Read It! (Posted )

If a tool can save development time but suffers host/4GL language performance issues, is the development time saved really worth it?
Read It! (Posted )

We have just kicked off our data warehouse project, and I'd like to know where I can get information about the performance comparison between SQL Server and ShowCase's Strategy.
Read It! (Posted )

We are considering implementing an Oracle DB to consolidate a few older databases. Which platform would you recommend, NT or Sun?
Read It! (Posted )

Can I use QMF for Windows to access our data from the Oracle database? Would we have to modify our present queries to do so?
Read It! (Posted )

Any advice regarding design and implementation of a very large database? What sort of object databases should I be considering for storage and performance?
Read It! (Posted )

We are planning to implement a data warehousing project. Can you give me some advice on which platform will be the good candidate?
Read It! (Posted )

I'm trying to build an application similar to a dictionary/thesaurus containing around 60 million words. What is a suitable tool to use?
Read It! (Posted )

We are an AS/400 shop, but I would like to find information to support bringing in Unix RS/6000 (AIX) which I believe is a better performing data warehouse platform.
Read It! (Posted )

During the planning process of a data warehouse and BI solution, what elements will determine the choice of our approach?
Read It! (Posted )

Why should we care that an end user would understand the physical table structure when there are access tools that can "translate" it into a simple meaningful structure?
Read It! (Posted )

Would you provide an overview comparing tera data and db2/udb?
Read It! (Posted )

What exactly is a corporate information factory, and what are the pros and cons of this approach?
Read It! (Posted )

Have you found that some vendors market their product as a multidimensional index tool when, in fact, it is an inverted index? What are realistic time frames for ROI and user availability for a tool based on inverted indexes?
Read It! (Posted )

What is the difference between database administrators and data administrators?
Read It! (Posted )

Where I can find details about centralized database computing?
Read It! (Posted )

What are the reasons one would choose data warehousing over a relational design?
Read It! (Posted )

They say a data warehouse is subject-oriented. What are the rules about defining the subjects?
Read It! (Posted )

My data warehouse vendor says he can put in a data warehouse in 90 days. Should I believe him?
Read It! (Posted )



Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.