English 中文(简体)
象Sql服务器这样的RDBMS表与像Csv这样的表格文件有何区别?
原标题:What is the difference between a table from a RDBMS like Sql Server and a tabular file like Csv?

我有一个理论问题,如果表格和单壳文件都以表格形式储存数据,它们之间的区别是什么?

Can I for example access a database table from outside the server as if it were a file? In what format are the tables of a RBDMS stored? Do they have an extension like .csv or .txt? I am somewhat new to the subject, so I would greatly appreciate the recommendation of any or bibliography that explains the differences or clarifies concepts, Thank you!

问题回答

Database table formats are specific to the database vendor, and often change between database versions. You should never access the files directly, as there are often caching mechanisms between the database engine and the disk files. Assuming you are using MySQL, I suggest you google "mysql database file formats" and bone up on indexes and foreign keys as well.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签