The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Course Of The Month
3 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Raima Databases
Posted on 2004-04-07
Hi all,
I need to know how types like date, integers, floats and doubles are internaly kept in the Raima Data Manager Version 3.30
I am mainly interested in the floating point types float and double (or any other Raima types of this kind).
maybe someone can point me out to some documentation.
Many thanks,
Mafalda.
I need to know how types like date, integers, floats and doubles are internaly kept in the Raima Data Manager Version 3.30
I am mainly interested in the floating point types float and double (or any other Raima types of this kind).
maybe someone can point me out to some documentation.
Many thanks,
Mafalda.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
6 Comments
why should you care how the data is stored internally. That level of detail is generally irrelevant to the user application.
you can check out
http://www.raima.com/database_technology/rdm_server_spec.php3
AW
you can check out
http://www.raima.com/database_technology/rdm_server_spec.php3
AW
Well, I have a Raima database file without a data dictionary file and I need to extract the data.
I can see and extract small integers (like 0, 1, 2) and strings but I can't extract the decimal point numbers and larger integer numbers like 1050.
I know several floating point values (like 0.10, 0.12) and their suspected location but there is no way I can get it correctly from the file.
Also, the same number in different records appears to have a different representation . . .
I suspect that the value in the record is a pointer/address of the real location but again there is no clear pattern.
Maybe one of you have the knowledge of how these decimal point numbers (floats, doubles) and integers are kept inside the database ?
All the tools in the market rely on the existance of the .dbd (data dictionary) file.
I tried ITTIA and Birdstep tools but none prevail.
I am forced to write my own connectivity tools.
I have also an erlier version of a database which has a different structure (DAT files no dbd) and I asume that the internal representation of numbers there is the same.
Thanks again,
Mafalda
I can see and extract small integers (like 0, 1, 2) and strings but I can't extract the decimal point numbers and larger integer numbers like 1050.
I know several floating point values (like 0.10, 0.12) and their suspected location but there is no way I can get it correctly from the file.
Also, the same number in different records appears to have a different representation . . .
I suspect that the value in the record is a pointer/address of the real location but again there is no clear pattern.
Maybe one of you have the knowledge of how these decimal point numbers (floats, doubles) and integers are kept inside the database ?
All the tools in the market rely on the existance of the .dbd (data dictionary) file.
I tried ITTIA and Birdstep tools but none prevail.
I am forced to write my own connectivity tools.
I have also an erlier version of a database which has a different structure (DAT files no dbd) and I asume that the internal representation of numbers there is the same.
Thanks again,
Mafalda
have you contacted customer support at Birdstep (current parent company of RAIMA)?
Email: support@birdstep.com
Phone: +1 206 748 5333 or
1 877 462 2473
(08:00am to 04:00pm PST)
perhaps they can help you.
AW
Email: support@birdstep.com
Phone: +1 206 748 5333 or
1 877 462 2473
(08:00am to 04:00pm PST)
perhaps they can help you.
AW
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month3 days, 6 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.