173:
25:
414:. IBM subsequently acquired the database division of Informix in April 2001, making UniVerse and UniData part of IBM's DB2 product family. IBM subsequently created the Information Management group of which Data Management is one of the sub-areas under which the IBM U2 family comprised UniData and UniVerse along with the tools, SystemBuilder Extensible Architecture (SB/XA), U2 Web Development Environment (U2 Web DE) and wIntegrate.
127:
576:
Thus the first three fields of this record, including the record ID and trailing field mark, would use 49 bytes of storage. A given value uses only as many bytes as needed. For example, in another record of the same file, JOHN JONES (10 bytes) may be replaced by MARJORIE Q. HUMPERDINK (21 bytes) yet
710:
Rocket
Software Universe and Unidata have limited ability to create web-based front-ends to Universe/UniData content. Since Rocket Software provides SQL access to its database products, a SQL-based product can be used to build a web-based UI to the databases; regardless of using Files or Tables in
632:(UniVerse Basic and UniBasic, respectively), similar to Pick/BASIC which naturally operates on the structures of the MultiValue database. They also have a structured database query language (RetrieVe and UniQuery) used to select records for further processing and for ad hoc queries and reports.
537:
Files are made of records, which are similar to rows within tables of a relational database. Each record has a unique key (called a "record ID") to distinguish it from other records in the file. These record IDs are typically hashed so that data can be retrieved quickly and efficiently.
678:
Both UniVerse and UniData support TLS transport level data encryption and record and file level encryption of data at rest using OpenSSL. Additional API encryption functionality is also available to allow custom solutions or meet specific regulatory requirements.
580:
Fields may be broken down into values and even subvalues. Values are separated by value marks (character xFD); subvalues are separated by subvalue marks (character xFC). Thus, if John Jones happened to get a second email address, the record may be updated to:
545:
strings; there is no binary data stored in U2. For example, the hardware representation of a floating-point number would be converted to its ASCII equivalent before being stored. Usually these records are divided into
509:. When searching for data in a hashed file, the system only searches the group where the record ID is stored, making the search process more efficient and quicker than searching through the whole file.
410:
and are embedded into the vertical software applications. In 1997, the
Unidata Corporation merged with VMark Systems to form Ardent Software. In March 2000, Ardent Software was acquired by
489:
Files are made of two parts: a data file and a file dictionary (DICT). The data file contains records that store the actual data. The file dictionary may contain
529:. This type of file is stored as a subdirectory within the account directory on the host operating system and may be read or edited using appropriate tools.
417:
On 1 October 2009 it was announced that Rocket
Software had purchased the entire U2 portfolio from IBM. The U2 portfolio is grouped under the name RocketU2.
406:
UniVerse was originally developed by VMark
Software and UniData was originally developed by the Unidata Corporation. Both Universe and Unidata are used for
145:
988:
688:
430:
Systems are made of one or more accounts. Accounts are directories stored on the host operating system that initially contain the set of
909:
590:
479:
635:
RocketU2 provides a set of Client Tools to allow software developers to access U2 databases from other software languages.
587:
567:
559:
809:
569:
as the second field and $ 4321.00 as a monthly salary stored in the third field. (The up-arrow (^) above is the standard
833:
89:
550:(which are sometimes called "attributes" in U2). Each field is separated by a "field mark" (hexadecimal character FE).
61:
108:
268:
725:
68:
566:
might represent a record in the EMPLOYEE file with 123-45-6789 as the Record ID, JOHN JONES as the first field,
1023:
459:
447:
46:
902:
797:
620:. e.g. an employee record will have data stored in the form of fields/attributes like his name, address etc.
241:
75:
1008:
1003:
204:
317:
42:
57:
998:
895:
482:
in that each file has a unique name to distinguish it from other files and zero to multiple unique
407:
233:
1013:
993:
35:
720:
570:
360:
337:
517:
Nonhashed files are used to store data with little or no logical structure such as program
285:
782:
770:
8:
857:
439:
952:
455:
364:
248:
82:
604:; in U2 terms, a "translate"), this provides the reason why U2 may be classified as a
600:
Since each email address can be the ID of a record in separate file (in SQL terms, an
962:
547:
261:
821:
711:
U2. A third-party application framework, can be used to build such web interfaces.
475:
463:
352:
280:
141:
601:
918:
451:
368:
356:
321:
185:
1018:
845:
483:
313:
210:
UniData 8.1, UniVerse 12.1.1, SB+ 6.5.6, Web DE 5.1.2 / January 7, 2022
629:
577:
each name uses only as much storage as it needs, plus one for the field mark.
982:
502:
434:
needed for the system to function properly. This includes the system's VOC (
431:
758:
617:
518:
947:
942:
881:
605:
526:
506:
435:
325:
273:
180:
172:
937:
746:
24:
957:
874:
490:
443:
411:
887:
967:
462:. Each of these classes of VOC entries can also be created by a
349:
296:
493:
to describe the contents or to output the contents of a file.
616:
Raw information is called Data. A record is a set of logical
542:
541:
Records (including record IDs) store the actual data as pure
379:
372:
345:
253:
237:
341:
257:
522:
391:
505:
to allocate the file's records into groups based on the
669:
Python (available as of UniVerse 11.3 and UniData 8.2)
705:
597:
where the close bracket (]) represents a value mark.
49:. Unsourced material may be challenged and removed.
980:
691:designations related to the U2 product family.
146:sources that evaluate within a broader context
903:
822:'Rocket Software U2 Acquisition Announcement'
783:'UniVerse Guide for Pick Users, Version 10.3'
682:
320:(DBMS) and supporting software now owned by
771:'UniVerse System Description, Version 10.3'
910:
896:
839:
486:that are logically related to each other.
171:
834:'Rocket Software to purchase U2 from IBM'
573:notation of a field mark; that is, xFE).
109:Learn how and when to remove this message
793:
791:
764:
752:
742:
740:
989:Proprietary database management systems
884:, a recognized international user group
803:
981:
851:
891:
788:
776:
737:
501:For hashed files, a U2 system uses a
136:focuses too much on specific examples
120:
47:adding citations to reliable sources
18:
917:
420:
13:
706:Web-based applications for U2 data
623:
512:
14:
1035:
866:
666:JSON (JavaScript Object Notation)
628:Both UniVerse and UniData have a
638:Client Tool interfaces include:
408:vertical application development
125:
23:
695:Rocket U2 Application Developer
585:
557:
496:
34:needs additional citations for
827:
815:
698:Rocket UniVerse Administration
384:U2 Web Development Environment
336:. Both of these products are
1:
701:Rocket UniData Administration
398:terminal emulation software.
7:
714:
673:
438:) file that contains every
425:
363:. The family also includes
10:
1040:
689:professional certification
683:Professional certification
532:
401:
16:Database management system
925:
785:page 1-3, Rocket Software
773:page 1-3, Rocket Software
630:structured BASIC language
291:
279:
267:
247:
229:
225:
203:
199:
191:
179:
170:
836:, International Spectrum
731:
469:
166:Rocket U2 Product Family
648:UniOLEDB - OLEDB Driver
611:
586:123-45-6789^JOHN JONES^
558:123-45-6789^JOHN JONES^
371:technologies including
687:RocketU2 offers three
338:operating environments
1024:Divested IBM products
810:'Informix Definition'
721:Pick operating system
474:Files are similar to
361:Pick operating system
340:which run on current
212:; 2 years ago
848:, Rocket Corporation
380:SB+ or SystemBuilder
328:database platforms:
142:improve this article
43:improve this article
858:'U2 Certifications'
798:'Ardent Definition'
759:'U2 Product Matrix'
747:'U2 Product Family'
480:relational database
324:. It includes two
318:database management
167:
1009:Database companies
1004:Big data companies
926:Historical entries
553:Thus this string:
377:sometimes known as
165:
976:
975:
963:Folio Corporation
953:SystemBuilder/SB+
860:, Rocket Software
824:, Rocket Software
749:, Rocket Software
657:UniObjects (Java)
654:UniObjects (.NET)
645:Intercall (C/C++)
503:hashing algorithm
355:. They are both
353:operating systems
307:
306:
163:
162:
119:
118:
111:
93:
1031:
912:
905:
898:
889:
888:
878:
877:
875:Official website
861:
855:
849:
843:
837:
831:
825:
819:
813:
807:
801:
795:
786:
780:
774:
768:
762:
756:
750:
744:
651:UniObjects (COM)
593:
562:
421:System structure
303:
300:
298:
220:
218:
213:
175:
168:
164:
158:
155:
149:
129:
128:
121:
114:
107:
103:
100:
94:
92:
51:
27:
19:
1039:
1038:
1034:
1033:
1032:
1030:
1029:
1028:
999:NoSQL companies
979:
978:
977:
972:
921:
919:Rocket Software
916:
873:
872:
869:
864:
856:
852:
844:
840:
832:
828:
820:
816:
808:
804:
796:
789:
781:
777:
769:
765:
761:Rocket Software
757:
753:
745:
738:
734:
717:
708:
685:
676:
663:U2 Web Services
626:
624:Programmability
614:
535:
515:
513:Nonhashed files
499:
472:
428:
423:
404:
322:Rocket Software
295:
221:
216:
214:
211:
192:Initial release
186:Rocket Software
159:
153:
150:
139:
130:
126:
115:
104:
98:
95:
52:
50:
40:
28:
17:
12:
11:
5:
1037:
1027:
1026:
1021:
1016:
1014:Data companies
1011:
1006:
1001:
996:
994:1990s software
991:
974:
973:
971:
970:
965:
960:
955:
950:
945:
940:
935:
929:
927:
923:
922:
915:
914:
907:
900:
892:
886:
885:
879:
868:
867:External links
865:
863:
862:
850:
846:'Client Tools'
838:
826:
814:
802:
787:
775:
763:
751:
735:
733:
730:
729:
728:
723:
716:
713:
707:
704:
703:
702:
699:
696:
684:
681:
675:
672:
671:
670:
667:
664:
661:
658:
655:
652:
649:
646:
643:
625:
622:
613:
610:
595:
594:
564:
563:
534:
531:
514:
511:
498:
495:
471:
468:
427:
424:
422:
419:
403:
400:
305:
304:
297:rocketsoftware
293:
289:
288:
283:
277:
276:
271:
265:
264:
251:
245:
244:
231:
227:
226:
223:
222:
209:
207:
205:Stable release
201:
200:
197:
196:
193:
189:
188:
183:
177:
176:
161:
160:
133:
131:
124:
117:
116:
99:September 2014
31:
29:
22:
15:
9:
6:
4:
3:
2:
1036:
1025:
1022:
1020:
1017:
1015:
1012:
1010:
1007:
1005:
1002:
1000:
997:
995:
992:
990:
987:
986:
984:
969:
966:
964:
961:
959:
956:
954:
951:
949:
946:
944:
941:
939:
936:
934:
931:
930:
928:
924:
920:
913:
908:
906:
901:
899:
894:
893:
890:
883:
880:
876:
871:
870:
859:
854:
847:
842:
835:
830:
823:
818:
811:
806:
800:, PC Magazine
799:
794:
792:
784:
779:
772:
767:
760:
755:
748:
743:
741:
736:
727:
724:
722:
719:
718:
712:
700:
697:
694:
693:
692:
690:
680:
668:
665:
662:
659:
656:
653:
650:
647:
644:
641:
640:
639:
636:
633:
631:
621:
619:
609:
607:
603:
598:
591:
588:
584:
583:
582:
578:
574:
572:
568:
560:
556:
555:
554:
551:
549:
544:
539:
530:
528:
524:
520:
510:
508:
504:
494:
492:
487:
485:
481:
477:
467:
465:
461:
457:
453:
449:
445:
441:
437:
433:
418:
415:
413:
409:
399:
397:
393:
390:connectivity
389:
385:
381:
378:
374:
370:
366:
362:
358:
354:
351:
347:
343:
339:
335:
331:
327:
323:
319:
315:
311:
302:
294:
290:
287:
284:
282:
278:
275:
272:
270:
266:
263:
259:
255:
252:
250:
246:
243:
239:
235:
232:
228:
224:
208:
206:
202:
198:
194:
190:
187:
184:
182:
178:
174:
169:
157:
154:February 2015
147:
143:
137:
134:This article
132:
123:
122:
113:
110:
102:
91:
88:
84:
81:
77:
74:
70:
67:
63:
60: –
59:
55:
54:Find sources:
48:
44:
38:
37:
32:This article
30:
26:
21:
20:
932:
853:
841:
829:
817:
805:
778:
766:
754:
709:
686:
677:
637:
634:
627:
618:grouped data
615:
599:
596:
579:
575:
565:
552:
540:
536:
516:
500:
497:Hashed files
488:
473:
458:, and other
429:
416:
405:
395:
387:
383:
376:
369:web-enabling
333:
329:
309:
308:
240:, UniBasic,
181:Developer(s)
151:
140:Please help
135:
105:
96:
86:
79:
72:
65:
53:
41:Please help
36:verification
33:
812:PC Magazine
642:ODBC / JDBC
606:MultiValued
592:^432100^...
561:^432100^...
519:source code
357:derivatives
286:Proprietary
58:"Rocket U2"
983:Categories
948:DataMirror
943:Aldon Inc.
660:Native XML
608:database.
602:outer join
527:plain text
507:record IDs
436:vocabulary
396:wIntegrate
388:UniObjects
326:MultiValue
274:MultiValue
230:Written in
217:2022-01-07
144:by adding
69:newspapers
938:Model 204
933:Rocket U2
386:(WebDE),
365:developer
310:Rocket U2
958:AeroText
715:See also
674:Security
491:metadata
460:pointers
444:filename
426:Accounts
412:Informix
334:UniVerse
249:Platform
968:OpenKBM
726:Reality
533:Records
484:records
448:keyword
440:command
402:History
359:of the
350:Windows
330:UniData
292:Website
281:License
262:Windows
215: (
83:scholar
548:fields
476:tables
456:script
242:Python
85:
78:
71:
64:
56:
1019:NoSQL
732:Notes
543:ASCII
478:in a
470:Files
452:alias
432:files
373:SB/XA
346:Linux
314:suite
312:is a
254:Linux
90:JSTOR
76:books
882:U2UG
612:Data
571:Pick
464:user
394:and
367:and
348:and
342:Unix
332:and
299:.com
269:Type
258:Unix
195:1987
62:news
525:or
523:XML
392:API
382:),
316:of
301:/u2
238:C++
45:by
985::
790:^
739:^
521:,
466:.
454:,
450:,
446:,
442:,
344:,
260:,
256:,
236:,
911:e
904:t
897:v
589:]
375:(
234:C
219:)
156:)
152:(
148:.
138:.
112:)
106:(
101:)
97:(
87:·
80:·
73:·
66:·
39:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.