|Sign-Up for Free Exclusive Services:||Portals|||||eNewsletters|||||Web Seminars|||||dataWarehouse.com|||||DM Review Magazine|
|Covering Business Intelligence, Integration & Analytics||Advanced Search|
Ask the Experts Archive
ARCHIVE OF QUESTIONS & ANSWERS FOR DATABASES
Please define data reconciliation and database reconciliation. I also need a definition of data synchronization.
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?
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.
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?
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?
How can I upload Excel spreadsheet data into
Oracle by using SQL*Loader? We now use Excel files and load data
different tables and make a link between each row.
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.
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.
question is in the realm of operational reporting. My client (a
government) does not want the expenses of an ODS or a data
they want to be able to copy the production database, index a
to make the reports run faster and run reports on it. What tools
to make copying the database easy? Are there any tools which can
apply the changes on a day-to-day basis instead of having to
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
exactly how this is calculated and measured in regards to server
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
We are planning to implement a data warehouse. What are the
advantages/ disadvantages of using Oracle database over Teradata?
We are (were) primarily a mainframe shop that has, in the
past couple of years, moved first to Oracle and most recently to
Server databases. We have begun to develop more and more
the PC and are looking for the reasons to create the position of
currently have people spending some of their time doing some of
functions but don't really understand all the advantages or
functions of a
full-time DBA. Can you enumerate some of the advantages?
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?
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?
How many databases have been sold in the past year?
What are centralized databases? What are the differences between centralized and distributed databases?
What are the changes required in order to convert a star schema warehouse to a snowflake schema warehouse?
Most companies seem to be going from the AS/400 to NT. Is this simply a cost issue?
Is there an OLAP tool available that has direct connectivity to an Oracle database?
Where can we find information about the types of tests to apply in the databases of the data warehouse?
Is there a rule concerning aggregates tables mirroring the fact tables?
Are there any cases where the dimensional table is larger than the fact table?
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?
If a tool can save development time but suffers host/4GL language performance issues, is the development time saved really worth it?
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.
We are considering implementing an Oracle DB to consolidate a few older databases. Which platform would you recommend, NT or Sun?
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?
Any advice regarding design and implementation of a very large database? What sort of object databases should I be considering for storage and performance?
We are planning to implement a data warehousing project. Can you give me some advice on which platform will be the good candidate?
I'm trying to build an application similar to a dictionary/thesaurus containing around 60 million words. What is a suitable tool to use?
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.
During the planning process of a data warehouse and BI solution, what elements will determine the choice of our approach?
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?
Would you provide an overview comparing tera data and db2/udb?
What exactly is a corporate information factory, and what are the pros and cons of this approach?
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?
What is the difference between database administrators and data administrators?
Where I can find details about centralized database computing?
What are the reasons one would choose data warehousing over a relational design?
They say a data warehouse is subject-oriented. What are the rules about defining the subjects?
My data warehouse vendor says he can put in a data warehouse in 90 days. Should I believe him?